Jaishri Sidhwaney, PMP, OCP DBA US Citizen - Secret Clearance

**** ******** *****, *******, ** 21076 410-***-**** 443-***-****

PROFESSIONAL SUMMARY

• 15 years of extensive experience in the Data Analysis, Database administration, Database Design, Software Development, Testing and Implementation of very large database systems

• 20 Years of SQL queries, PL/SQL programming, performance tuning, IMPORT / EXPORT procedures, RMAN

• Proficient in developing Test Plans, Scripts & Business Data Analysis.

• 10 years of SDLC from design thru testing

• 3 Years of Oracle Spatial

PROFESSIONAL EXPERIENCE

Project: Payment Management System Health and Human Services 10/2011 to Present

The Payment Management System (PMS), is a centralized grants payment system and cash management system operated by the HHS Program Support Center (PSC), Division of Payment Management (DPM). The Payment Management System accomplishes all payment-related activities for HHS grants from the time of award through closeout of a grant. In addition, the Payment Management System provides these same services for several major Federal agencies outside of HHS. These "cross-serviced" agencies include among others: Department of Labor, Department of Agriculture, and Department of Interior. The Payment Management System processed over $179 billion in payments in fiscal year 1999 to over 22,000 grant recipients.

• Develop Forms and reports in PL/SQL Packages, Java Script and Oracle Web Tool Kit in J2EE, SOA environment. Following Serena Source control, Team Track, Unix Scripts and CMMI methodology.

• Reverse engineer 300 oracle tables into smaller data models to prepare for next generation modernization development work using Toad Data Modeler.

7/2006 to 3/2009 USA Census Bureau Suitland, MD

Oracle Application Developer

Project: Automated Cartographic Map Processing System (ACPS)

• Reviewed the status of work accomplished versus requirements of the project.

• Developed the programming standards for team to follow, implemented programming environment by identifying and selecting CM tool, User privileges and profiles, documentation standards.

• Developed standards to architect data mart for specific map type from world’ largest geo data warehouse and automated ETL processes to populate the data for cartographers. Reviewed PDMs produced by team members.

• Directed very diverse programming team of 6 contractors and mentored 14 client team members. Created project schedule of major tasks and identified resources for tasks, Created Internal Release Management process to help with the transition from design to development to test and to UAT test phases. Planned resources to support project schedule and was proactive in notifying program manager of project status, and project risks.

• Intensive interactions with clients for user requirements; DBAs for programming environment, space requirements, oracle patches, user security profiles; Software developers and testers.

• Identified bottlenecks in poor performance processes and provided solutions to increase the performance.

• Solved branch’s toughest problem of cartographic generalization process which saved the group many months of developing cost and manual processing and produced consistent result.

• Environment: Oracle 10g Spatial, RAC, Linux, UNIX, Windows, PL/SQL, Oracle Designer, VISIO AML, ESRI Products, Map Viewer and PEARL languages.

• Received two awards ‘ABOVE and BEYOND’ service, and ‘EXCELLENT PERFORMANCE’ in 2007 and 2008 respectively.

6/2004 to 7/2006 Convergent Solutions Inc. Arlington, VA

Oracle Consultant – Net Centric Project

• To support DISA’s 2020 budget allocation requirement, participated in a team and prepared a multiyear budget planning document reflecting the estimated cost of acquiring hardware and software, network and labor requirements.

• To support DISA’s requirement of right EVM tool and methodology, evaluated, presented and selected software for Earned Value Management system by researching COTS, GOTS and best of breed available. Then recommended to develop a custom tool by integrating MS PROJECT and COBRA (COTS EVM) tool.

• Facilitated CMMI level 2 certification process. CMMI certification process included Initiate formal policies, procedures, best practices and standards for application development, design and test plan documents.

8/1999 – 5/2004: Booz Allen Hamilton (BAH), Mclean, VA

Software Development Manager / Architect

Supported various government contracts by providing management services in database design, reusable software system components, CM Processes for web based and client server based systems Oracle 8i, 9i, Oracle Forms, Reports, web based forms, HTTP packages, PL/SQL, SQL, ColdFusion, Oracle Case Designer 2000.

Project: Office for Special Technology Countermeasures (JPO-STC), a 9 million dollar budget.

• Reviewed requirement document to create a logical and physical database design, interacted with the client and the subject matter experts. Facilitated Joint Application Development (JAD) sessions, reviewed relevant literature, and identified and documented functional requirements.

• Developed a very large Online Transaction Processing (OLTP) Model of worldwide network telecommunication assets using Erwin. Championed the automation process of DDL generation from Erwin repository to avoid human errors and discrepancies between the data model and the databases.

• Assisted a testing team with User Acceptance testing (UAT) and user requirements.

• Extracted data from source files in to staging tables, wrote PL/SQL procedures to transform data based on target database and performed the data load process, reported bad data to data providers for correction.

• Assisted network analysts to prepare test cases, perform tests and validate results.

Project: Center for Network Analysis solutions (CNAS) –Data Warehouse from scratch

• Architected and developed OLAP data warehouse from scratch using hybrid approach for CNAS lab. Emerged as the one person known for the knowledge and analytical skills of the CNAS DW source data and business needs.

• Developed LDM and PDM using Designer 2000 tool. Scheduled data model walk through sessions among team members and client.

• Communications with clients for requirements and user sign-off and user acceptance.

• Data sources were from local and long distance telecom companies LERG, MCI, AT&T, Sprint and several smaller datasets of cellular, microwave, power data.

• Designed a process to refresh data quarterly for LERG, MCI, AT&T, Sprint data sets and one time load for smaller data sets as per availability of data.

• Environment: Oracle 9i, designer 6.0, pl/sql language, SQL PLUS.

Project: Office of Immigration & Naturalization Service’s – Automated Case Processing System (ACPS)

• Gathered requirements by JAD sessions, reading requirement document and visiting client site in California.

• Reverse engineered legacy system regional data models using Designer 2000, mapped requirements functions with the data model and customized data model by adding missing functions, missing relationships and missing attributes.

• Architected and developed new national level data model, documented changes in the repository, and created requirement traceability matrix report.

• Developed the Data Management Plan (DMP) by including a physical data model (PDM), an Entity Definition report and an Attribute Definition report; process model and function hierarchy. Software used was oracle 8i, designer 6.0 in Windows NT environment.

• Interacted with client for client acceptance and sign-off.

Project: Army National Guard of distance learning project

• Developed stored procedures and PL/SQL HTTP packages to support web based Course Repository Management, Content Management, and Cash Disbursement Payment System (CDPS) modules.

• To support National Guard’s 24/7 content availability requirement introduced Master - Master replication process to create stand by database.

Project: Food & Drug Administration (FDA), -- Software Development and Maintenance

• Reviewed project proposal to manage statement of work by planning tasks, budget and resources.

• Create work breakdown structure (WBS), project schedule, monitor schedule, manage releases

• Schedule weekly meetings to validate progress accomplished versus planned.

• Communicate with CM, developers, DBAs, testers, client to ensure every member is on same page

• Managed a team of 20 software developers and testers;

• Assisted the program manager in keeping up with the budget versus tasks delivery process;

• Perform staff evaluation, motivate and request for more resources if necessary.

• Reviewed and approved time and expense charges for staff.

5/1989 – 2/1999: Oracle Corporation San Francisco, CA

Principal Consultant / Independent Oracle Consultant

I was initially hired by Oracle Corporation in 1989, and then worked as an independent oracle consultant, hired back by Oracle corporation total three times finally left in 1999.

Project: Baltimore Gas and Electric Company

• Developed a prototype of project management tool for data entry and reports functions using Oracle forms 3.0 and Oracle Reports.

• Supported a team to gather requirements of BG&E Conversion of legacy system from IBM to Oracle.

• Performed DBA functions: created users, assign privileges, allocated space, created database and database tables Indexes, monitored rollback segments, tablespaces.

Project: Bureau of Land Management (BLM),

• Reverse engineered an IBM legacy database to Oracle Physical data model. Developed programs to load data into new data model. Identified the order to load master tables, detail tables and look up tables. Then loaded data in order. Delivered populated database to client for verification and validation.

Project: British Petroleum Company, Anchorage Alaska

• Developed software for well exploration modules in FORTRAN, Oracle 6 environment.

• Communicated with end user for module testing.

Project: Lockheed Martin – INDUS Engineering

• Performed acceptance test for software developed by INDUS engineering.

• Developed and executed the test plans, wrote change requests and bug fix report by using in house templates.

Project: first Choice Insurance Company in Seattle, WA.

• Performed Database administration functions viz. Install oracle and oracle patches, Backup and recovery, write SQL and UNIX scripts, PL/SQL programming, performance tuning.

• Developed data load processes and loaded ICD codes, and Insurance related data in to tables.

• Communicated with client for data validation and verification.

Project: Hanford Environmental Health Facility, Richland, WA. Firm Fixed price contract

• Managed a conversion of IBM COBOL, DB2 to Oracle, Windows, PL/SQL, FORMS reports project.

• Effective project planning, executing and monitoring resulted in completion of project in time and within budget.

• Work in parallel by assigning Forms, reports, data load functions to developers and DBA

• Communicated with user on timely basis to prepare the test plans while developing tasks were going on.

5/1983 – 5/1989 IBM Corporation Atlanta, GA

Contract Programmer

• Converted IMS database marketing tool for sales department to SQL/DS under VM and installed three worldwide databases (AFE, EMEA, and US) into production. 1988-89

• Led Nuclear Plant Reliability Data System (NPRDS) for Institute of Nuclear Power Organization (INPO) in IBM, DB2, PL1, RPG, and MVS environment.1987

• Database support / programmer for ICI Americas, Goldsboro, NC. 1986

• Developed test cases and carried out test plans for network communication control facility (NCCF) product. 1984-85

• Converted engineering applications from DEC VAX to IBM in MVS, VM, CMS, DB2, PL1, FORTRAN, COBOL, and CICS environments for Structural Dynamics Research Corporation, Cincinnati, Ohio. 1983-84

• Worked as a programmer for VA medical center, Palo Alto, CA.

TECHNICAL SKILLS

Hardware: HP, SUN Solaris, DEC, IBM-3090, IBM-370, Apollo and PC/AT/PENTIUM

Operating System: UNIX, WINDOWS-95/98/2000/XP, OS/390, MVS/ESA, MS-DOS,

Languages: SQL, PL/SQL, Perl, VS COBOL II, MVS COBOL, JCL, FORTRON77, PL1, HTML, JAVA SCRIPT, REXX, ASSEMBLER,PL/1 and VB SCRIPT, Stored Procedures, Triggers, Unix shell Scripts

Database: Oracle, DB2, IMS-DB, IDMS and ORACLE; OLTP AND BI data Models

Tools/Utilities: Oracle Case Tool Designer 2000, TOAD, ERwin, and VISIO, SQL Developer, PVCS, Map viewer, ESRI ARC SDE, ARC MAP, ARCINFO JCL,ISPF/PDF, SPUFI, Oracle JOB SCHEDULER SOFTWARES FOR HANDLING PROJECTS.

Other: ODBC, SQL, Microsoft Office, Netscape Communicator, Java applets, FTP and E-Mail.

EDUCATION/CERTIFICATION/TRAINING

• 1/1979 to 8/1982 Master of Science in Computer Science, Bowling Green State University, Ohio

• 6/1972 to 5/1973 Bachelor of Science in Education, University of Poona, India

• 6/1967 to 5/1971 Bachelor of Science in Chemistry, University of Poona, India

• Oracle Certified Professional (OCP) Database Administrator by Oracle Corporation, 4/2001

• Project Management Professional (PMP) by PMI 9/2005

• Attended OBIEE seminar by Oracle Corporation, 1/2010

• Many DBA, Developer, Designer, Advanced Replication, Oracle Spatial courses by Oracle Corporation 1989 – 2006

Contact this candidate