TSQL-Rajendra_P_Shrestha
W
Document Sample


Rajendra P. Shrestha
18308 Aspen Dale Court
Boyds, MD 20841
Phone: (301) 540-7867 (home); (240) 401-0252 (cell)
e-mail: shresthar@saic.com OR rajendra@rjjm.com
WWW: http://www.rajendra.net
Goal
To work in a challenging software/systems development environment as a Technical Lead, Systems
Architect or Technical Project Manager contributing to the entire software/systems development life cycle.
Summary of Experience
Over 12 years experience in the IT industry, with experience in COTS implementation, COTS
development and custom systems development
Depth and breadth of experience in multiple technology platforms: Microsoft .NET, Java/J2EE, open
source “LAMP”, Mac OS X, iPhone OS; demonstrated ability to learn new technologies quickly
Experienced in the entire systems life-cycle: business process analysis, requirements, architecture,
design, development, testing and operations/maintenance with depth of experience in architectural
analysis, design and development
Over 9 years experience managing/leading technical teams of up to 11 team members; knowledgeable
in all aspects of project and technical management
Experienced in developing, implementing and monitoring process improvements (including CMMI) in
software development teams
Education
George Washington University, Washington, DC
M.S. in Systems Engineering (currently enrolled, expected graduation in 2011)
University of Illinois at Urbana-Champaign, Urbana, IL
M.S. in Environmental Engineering, December 1996
Thayer School of Engineering, Dartmouth College, Hanover, NH
B.E. with concentration in Environmental Engineering, June 1995
Dartmouth College, Hanover, NH
A.B., magna cum Laude, in Engineering Sciences with High Honors, June 1995
Professional Certifications
• Certified Systems Engineering Professional (CSEP), INCOSE, October 2009
• Project Management Professional (PMP), Project Management Institute, July 2009
Computer Skills
Domain Skills and level
Operating Systems Windows 9x, NT, 2000, XP, Vista, 7 on the desktop
Windows NT, 2000, 2003, 2008 on the server
Linux (Red Hat, Debian, Ubuntu) on the desktop and server
Unix (Solaris, AIX, HP-UX) on the server
Mac OS X on the desktop
Programming Java, C#, C, C++, Objective-C, Visual Basic, Javascript, PHP, Perl, Pascal,
Languages bash, Python, Ruby
Development Eclipse for Java programming
Environments Visual Studio.NET, Visual Studio, Delphi
Xcode for OS X and iPhone programming
gcc, emacs, make, gdb and other Linux-based development tools
System Windows NT/2000/2003/2008, including IIS
Administration Linux, including sendmail, Apache, Bind, Samba
Web programming HTML, CSS, JavaScript
CGI programming with Perl
PHP and ASP
ASP.NET programming with C#
J2EE programming with servlets, JSP, EJB, Struts (Tomcat , JBoss, Oracle
Application Server)
Ruby on Rails
XML, XSLT, SOAP and related technologies in .NET and Java
Other iPhone OS programming using Cocoa Touch
programming .NET Windows Forms
frameworks
Database Microsoft SQL Server, Oracle, Microsoft Access, Mysql, PostgreSQL
Administration
Database SQL Server TSQL and SQLCLR, Oracle PL/SQL, PostgreSQL PL/pgSQL
Programming Client-side programming with RDO, ADO, ADO.NET, JDBC, Hibernate
VBA programming in Excel, Access
Design and Object-oriented Design using UML
Modeling Business Process Analysis
Service Oriented Architecture (SOA) using Web services
ERWIN, Microsoft Visio
Specialized Essential EH&S (an enterprise-level emissions and compliance
applications management system)
Atlassian Confluence (custom plug-in development)
CORE (requirements analysis, functional analysis, systems architect)
ExtendSIM (simulation)
Microsoft Project
Work Experience
Science Applications International Corporation (SAIC) 2003 - present
Development Lead, National Institutes of Health, Electronic Research Administration
October 2008 – present
The Electronic Research Administration (eRA) maintains NIH’s electronic grants management system,
which is used for application, processing, awarding and management of all extramural research grants
for NIH and other HHS agencies. The system is a J2EE web application built using EJB, Struts,
Oracle database and deployed in Oracle Application Server. I am the Development Lead on the team
that maintains the common framework and shared business components that are used by the other
teams to build user-facing applications. My role on the project involves:
- Lead a team of 11 developers in designing, coding and unit testing system enhancements
and bug fixes.
- Work with Federal managers and requirements analysts to ensure requirements are clear
and technically feasible
- Provide to the Federal managers LOE and schedule of tasks assigned to the team
- Provide weekly status reports to Federal managers.
- Supervise the work of other developers on the team, assigning tasks and ensuring they are
completed on time
- Support the testers as they test new releases in TEST and STAGE environments
- Support the Operations team as they deploy new releases in TEST, STAGE and PROD
environments
- Conduct design and code reviews
- Do hands-on design, coding and unit testing of some tasks that are assigned to myself
- Work closely with architects to ensure that new code is consistent with overall
architecture and to plan and implement changes to the architecture.
Some of my specific achievements to date include:
In the first months, led the team in implementation of NIH’s Early State Investigator (ESI)
rules into the eRA system. The ESI team, including me, was awarded NIH Director’s Award
in July 2009 for our work in the project.
Designed and implemented a centralized job scheduling engine. The scheduler, based on
Quartz but using a custom job store, allows jobs to be centrally managed for multiple
applications running on multiple application servers.
Led the team on meeting schedule deadlines for all quarterly enterprise releases
Consultant, National Heart Lung and Blood Institute Guidelines Development
January 2008 – October 2008
During this period, I worked as a short term consultant in a SAIC project that is helping the National
Heart Lung and Blood Institute (NHLBI – an institute under NIH) in developing a new set of
guidelines for obesity, hypertension and cholesterol. The project is using a virtual collaborative
workspace built on top of Atlassian Confluence Wiki application. Confluence is a J2EE application
that runs on top of Tomcat, Struts, Hibernate and other Java-based frameworks. It exposes a rich
Java plug-in API that can be used to extend the functionality of the Wiki system. My tasks on the
project were:
- system administration of the test and production environments
- extend the Confluence system to meet project requirements. I built a Confluence plug-in
that allowed selected users to enter abstraction data from peer-reviewed journal articles
and to easily create evidence tables based on those abstracted data. These tables will be
used to answer scientific questions posed by the guidelines panels as they develop the
guidelines. The plug-in is written in Java using Confluence’s API as well as other third-
party Confluence plug-ins.
Technical Lead, Health Resources Services Administration
January 2003 – January 2008
During this five year period, I was the Technical Lead on web applications development projects for
the Maternal and Child Health Bureau (MCHB), Health and Human Resources Administration of the
Federal Department of Health and Human Services. These web applications allow States and other
organizations to apply for MCHB grants and for grantees to report on their grants' progress.
My responsibilities in this position included:
Manage a group of developers and testers in the design, coding, testing and deployment of the web
applications
Work with the project manager and subject matter experts on the design and quality control of the
applications
Work with the client and project manager to define requirements for the systems and to ensure that
the systems meet the requirements
Train the developers in new technologies
Manage work assignments to developers and ensure that all technical work is completed on time
Work with the project manager to define project schedules and to ensure that the projects are on
schedule
Our project team developed or enhanced the following systems during this period:
1. A C#/.NET/SQL Server/XSLT based web application that allows States to apply for the Title V
Block Grant and to report on their State's performance in prior years. This system was developed,
tested and deployed within four months in early 2003. I helped train the developers in .NET
technology, contributed to the requirements and led the design and actual coding and testing of the
system.
2. An ASP-based reporting system that reports on the data submitted by the States for their Title V
Block Grant in prior years. This was an existing system that we enhanced with new functionalities.
3. A C#/.NET/SQL Server/XSLT based web application that allows organizations to apply for
various discretionary grant programs offered by MCHB and for grantees of such programs to report
on their progress. I have been involved in the entire lifecycle of this project – from the initial
requirements, to design, coding, testing, deployment and current maintenance. The system went
live in October 2004.
4. A reporting system for the discretionary grants system using Microsoft .NET and SQL Server.
5. An admin utility application written in ASP.NET that made significant use of SQL Server 2005’s
XML features
During 2005, our project was chosen as a Focus Project to undergo a CMMI Level 3 assessment for
our Business Unit. The formal Class A CMMI Assessment was conducted in early 2006, and our
Business Unit was certified as Level 3 compliant. During this process, I functioned as the Process
Mentor for our project and was responsible for making sure that our project met all the requirements
for attaining the Level 3 status.
Business Process Analysis Lead, National Health Services Corp
April 2006 – May 2007
During this one year period, I worked part-time on a project to conduct business process analysis and
re-engineering effort for the National Health Services Corps (NHSC). As part of a small team, I
interviewed most employees and other contractors of NHSC
analyzed and documented NHSC’s current business processes
gathered business requirements for a new system to replace NHSC’s existing mainframe
based system
proposed business process enhancements and modernization opportunities
developed a Concept of Operations (ConOps) and system architecture for the future system.
Technical Solution Architect, various bids and proposals
I have participated in writing multiple SAIC bids and proposals, serving mainly as a technical solution
architect Some of the proposals I have worked on have included:
re-competition of my existing project – maintenance and enhancement of .NET/SQL Server
based systems
a new Wiki based collaborative system for community annotation of E. coli using open source
tools, and Collexis for literature search
a new Service Oriented Architecture (SOA) based system to replace a legacy system, using
Microsoft BizTalk, Global 360 BPM, Microsoft SharePoint, other COTS products and .NET
3.0 for integration and custom components.
maintenance and enhancement of a Java/J2EE/Oracle based system.
For two of these, I participated in oral presentations before the proposal evaluation committee.
Essential Information Systems (formerly Essential Technologies, Inc.) 1997-2003
My work experience over the six years that I was at Essential covered many different aspects of
software development and implementation. Essential’s flagship product is Essential EH&S
(“Plantware”), an enterprise-level emissions and compliance management suite used at many large
chemical and manufacturing facilities. I was able to leverage my academic background in chemical and
environmental engineering with my interests in programming and information management to help
push this product into new business and technology domains.
Director of Development, December 2000 – January 2003
As director of software development, I managed a group of seven developers. Our group’s goal
was to maintain the existing products of Essential, as well as create new products and features to
satisfy customer needs as well as to leverage new technologies. Some of my responsibilities in this
position included
• Manage new releases, including supervising release needs, development and testing
• Help product management produce requirements for enhancements
• Systems analysis and design of new features and enhancements
• Development of both bug fixes and new features – including client-side coding in Visual
Basic, as well as database side programming in PL/SQL and TSQL
• Development of a web-based GUI replacement for the application using ASP.NET and
C# to replace the legacy VB-based client. The new GUI continued to use the existing
middle tier business objects (written in VB)
• Design and develop new add-ons using a pure .NET approach (i.e. ASP.NET talking to a
C# middle tier using ADO.NET to access the database)
• Administrative supervision of the Development group
Senior Systems Analyst: April 2000 – December 2000
During most of 2000, I was a Senior Systems Analyst responsible for Essential EH&S’s Air and TRI
modules. My primary responsibility was on designing new features for these modules as well as the
systems analysis and database modeling required for developing the features. I also worked closely
with the developers to ensure that the features were coded properly and with QA/QC to verify the
functionality. As the systems analyst for the modules, I was also responsible for managing bug fixes
for those modules.
• Project Engineer: February 1997 – April 2000
Between 1997 and 2000, I worked in the Client Services department as an implementation engineer, as
well as a custom application/reports developer, on Essential’s Essential EH&S (Plantware) suite. Some
of the projects I was involved during that period include:
• Worked as the main technical engineer in a large enterprise-wide implementation of PlantWare’s
environmental modules for a chemical manufacturer. This implementation has thousands of users
using PlantWare through Citrix ICA against an Oracle database. This 1.5 years on-site
implementation work involved: implementation design; configuration; managed the design,
development and testing of a large set of reports which were ultimately merged into the core
product; developed a VB-based bulk data uploader; wrote Oracle scripts to get QA/QC reports;
implementation support for users; software support to system and database administrators;
developed custom report to generate state air emissions reports.
• Developed various VB and Crystal-based reports for the PlantWare32 product.
• Implemented the Air module at a chemical manufacturing facility in Alabama.
• Developed VB-based tool to migrate data from Essential’s legacy software (AEMS) to PlantWare.
Yomari, Inc., Kathmandu Nepal
Founding CEO and Chief Technology Officer, January 1997 – 2005
I helped establish and grow Yomari, a Web programming company that is based in Kathmandu, Nepal.
The company is now a recognized leader in Web development in Nepal. My involvement from the
United States included general management, server systems management and researching new Internet
technologies that could be of use to develop our business. Most of what Yomari does involve open-
source software (Linux, Apache, Mysql, PHP, Perl) as well as Java and J2EE development. I helped
develop many web applications (for clients, end users and for internal use). Some of these were
developed using PHP. Others used Java/J2EE frameworks such as JSP and Struts.
Environmental Engineering Program, University of Illinois at Urbana-Champaign
Research Assistant: July '95 - January 1997
• Worked under Prof. Mark Rood on a project to study light scattering by atmospheric aerosols.
• Helped to maintain an ambient aerosol monitoring station
• Primary responsibility: data analysis, developed a database management system using Delphi
• Managed computer hardware, software and network within the research group
Honors and Affiliation
Phi Beta Kappa, Dartmouth College
Tau Beta Pi, New Hampshire Chapter
Formal Trainings
• GWU Systems Engineering program (Oct. 2008 – present): Systems Engineering I & II, Project
and Program Management, Enterprise Architecture, Software Engineering
• Software Development Best Practices Conference, Boston, September 2007
• Project Management 101 (3-day course), SAIC, August 2006
• Systems Engineering (3-day overview course), SAIC, January 2006
• CMMI role-based trainings on Peer Review, Requirements Development and Management,
Verification and Validation, Measurements and Analysis, 2005
• SEI Introduction to CMMI, July 2005
• Oracle Database Administration: Learning Tree, December 1999
• Oracle for Experienced SQL Users: Oracle Education, November 1998
• Mastering Visual Basic: New Horizon, 1998
Other Domain Skills
• Grants application and reporting management
• Environmental emissions management and reporting - engineering calculations of air, water and
waste emissions, regulatory reporting for Federal, State and local agencies as well as IT consulting
support for other environmental and compliance management issues.
Miscellaneous
Languages: Fluent in English and Nepali, working knowledge of Hindi
References: Available on request
Citizenship: USA
Related docs
Other docs by yvtong
Web_Design_Tourism-MASTER_OF_ARTS_TOURISM_MANAGEMENT_NI_TermEnd_Examination_June_
Views: 4 | Downloads: 0
Web_Design_Tourism-Select_Italy_Press_Release__Italy_Travel_and_Vacation_Packages_
Views: 2 | Downloads: 0
Web_Design_Tourism-LEHIGH_UNIVERSITY_STUDY_ABROAD_OFFICE_PC_ROSSIN_COLLEGE_OF_
Views: 1 | Downloads: 0
Get documents about "