TSQL-Rajendra_P_Shrestha

W
Shared by: yvtong
Categories
Tags
-
Stats
views:
2
posted:
7/23/2012
language:
pages:
6
Document Sample
scope of work template
							                                     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