Summary:
13 years of IT experience. In various roles of her career, she has performed as an Architect, Senior Programmer, Business Analyst, Project Leader, Backup Project Manager, Quality Manager, and Developer. In these roles, she has been responsible for systems analysis, design, development and implementation of a variety of complex business systems, specifically in Pharmaceutical, Commercial, Telecommunications and Finance industry in the USA, the UK, Germany and India. Through this experience she had developed the ability to work in heterogeneous teams with individuals of different skill levels, a strong commitment to getting the job done under pressure and excellent oral and written communication skills.

specializes in Oracle backend design and development. She also has extensive experience in development and support of Data Loading, Data Migration, Data Validations and Client Server applications using technologies like Oracle (SQL, PL/SQL (Packages, Procedures, Functions, Triggers), Java Stored procedures, existing database packages), Developer 2000, Designer 2000, UNIX shell scripting, Data Warehousing and Reporting (Business Objects). She has developed and supported Internet applications using technologies like JSP, JAVA and HTML with Oracle as the backend. Manisha has successfully executed projects for GE, Pfizer (Parke Davis Data Migration) and Free2Talk for Siemens, UK.

also worked in a support role for several systems, including CARS/IS and Business Objects, used by the Contracts Management department at Pfizer, Inc.

Recently worked at GE Treasury, involved in the TOBI (Treasury Data Hub Outbound) Interface & Vault Project as a Senior Business Analyst/ Architect.

Professional Experience:

Confidential,CT, US (Feb 2010 – May 2011)
Data Architect & Sr. Programmer/Analyst
Project: TOBI (TDH (Treasury Data Hub Outbound Interfaces )

GE Treasury, centralizing all treasury functions for GE Capital & GE Company businesses, is the
largest corporate borrower in the world. Working in the TDH (Treasury Data Hub) Outbound Interfaces (TOBI) project/team. TOBI is provider & publisher of Harmonized Treasury Data to Users & Applications via ESB (Enterprise Service Bus). TOBI provides Super Data Sets (SDS) for treasury data groups & encapsulates TDH/EDW design from end users. It is a single source for Integrated Treasury Data for reporting & analytics purposes.

Project: Vault

Vault project is an initiative to maintain all the related Bank data in GE at a single place.

Responsibility Description:

• Interaction with Business to gather requirements.
• Requirement Analysis / Gap Analysis / Data Analysis
• Understanding of the existing Data warehouse dimension & fact tables.
• Creation of new dimension & fact tables as needed
• Developing database objects to facilitate requirement needs, reporting & analysis for the End Business users.
• Communicating with various IT groups for easy synchronization of information/ data flow from the Source systems to the Target systems.
• Environment: Oracle 10g, SQL Developer, SQL, SQL*Plus, ERWIN

Confidential,US(November 2003 to December 2006)
Sr. Programmer/Analyst, Pfizer
Project: CARS/IS Reporting using Business Objects
Responsibility Description:

• Work with business analyst to define reporting requirements.
• Design reports based on an expert knowledge of the CARS/IS data model.
• Create and support around 30 operational reports in Business Objects. The data is pulled from multiple databases, the primary database being CARS/IS.
• Environment: Oracle 9.2.0.1.0/ 8.1.7.3.0, Solaris, PL/SQL, SQL, SQL*Plus, Business Objects 6.5

Project: Enhancements / Updates in CARS/IS application OR on CARS/IS database.
Responsibility Description:

• Work related to any updates/enhancements on the CARS/IS application or databases.
• Part of the Upgrade team moving from CARS/IS 3.7.1 to version 3.11
• Developed a system to perform customer data updates en masse in CARS/IS, saving hundreds of hours of manual work.
• Environment: Oracle 9.2.0.1.0/ 8.1.7.3.0, Solaris, PL/SQL, SQL, SQL*Plus, SQL*Loader, Shell scripts, Business Objects 6.5

Project: Design & Development of Contract Performance Tool (CPT).
Description:

• As a result of Pfizer’s acquisition of Pharmacia, the management of several legacy Pharmacia Group Purchasing Organization (GPO) contracts has presented a challenge. Within these GPOs, member hospitals or facilities may elect to participate in Performance Participation Agreements (PPA). These agreements afford the member off-invoice discounts based on market share changes (as measured by extended units or dollars provided on IMS DDD data) or sales percentage changes (as measured by a rolling 12 months of internal sales units).

Each quarter, Pfizer must evaluate the results of members participating in the PPA programs and assign these members to appropriate price groups by determining milestone achievement for volume-based or market share-based tiered contracts. The current member assignment process is performed manually. Automating this process will provide improvements to Pfizer contract management in terms of reduced cycle time, reduced effort, and improved accuracy.

• Environment: Oracle 8.1.7/ 9.2.0, Solaris, PL/SQL, SQL, SQL*Plus, SQL*Loader & Shell scripts.

Responsibilities:

• Creation of Technical Specifications & design documents
• Defining entities, attributes, relations and building ERDs using ERWIN
• Creation of application database schema (tables, views, sequences, indexes, database links)
• Backend coding (procedures, functions and packages using PL/SQL, triggers)
• Technical design and implementation of the migration packages.
• Import and Export of data and objects across databases
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring
• Use of SQL*Loader for data loading from external party into Oracle database.
• Quality Assurance
• Implementation Plan
• Perform general technical trouble shooting and give consultation to development teams
• Day to day administration of the business systems
• Work as part of a team and provide 7x24 support when required
• Technical support to end-users for in-house developed applications
• Creation of reports using Business Objects

Confidential,NJ, USA(April 2003 to August 2003)
Sr. Programmer/Analyst

Project: Deduction Management Component, Open & Clear Deductions, Datawarehouse
Description:

• Changes in processing of the deductions. The open and clear deduction details files from SAP, is received and loaded in the data warehouse. The open deduction details are then sent to AMPS and Food Service for further processing. The acknowledgement for the same is received and processed. After successful processing at each end, extracts are generated and sent back to SAP for further clearance.
• Environment: Oracle 9.2.0.1.0/ 8.1.7.3.0, Solaris, PL/SQL, SQL, SQL*Plus, SQL*Loader & Shell scripts.

Responsibilities:

• Creation of Technical Specifications & design documents
• Backend coding (procedures, functions and packages using PL/SQL, triggers)
• Develop custom UNIX shell scripts
• Use of SQL*Loader for data loading from external party into Oracle database
• Performance Tuning
• Creation of SQL*PLUS Reports
• Production support

Project: Mobil
Description:

• Project Mobil – the initiative to redesign the company. Project Mobil combines UBF Foodservice’s U.S., Canadian and International FoodSolutions businesses into a single, customer-focused North American organization.
• Environment: Oracle 9.2.0.1.0/ 8.1.7.3.0, Solaris, PL/SQL, SQL, SQL*Plus, SQL*Loader & Shell scripts

Responsibilities:

• Creation of Technical Specifications & design documents
• Backend coding (procedures, functions and packages using PL/SQL, triggers)
• Develop custom UNIX shell scripts
• Use of SQL*Loader for data loading from external party into Oracle database
• Performance Tuning
• Defining entities and attributes
• Creation of SQL*PLUS Reports
• Production support

Education:
BS Engineering (B.E. Honors.) in Electronics

Professional Training:

• Cobol, 1 month, conducted by IIS Infotech
• Oracle8, 1 month, conducted by SQL Star People India Ltd.
• C++, 10 days, conducted by Siemens Information Systems Ltd.
• Java, 7 days, conducted by STG
• Adventures In Attitude, 3 days, conducted by ESPN
• Software Configuration Management, 1 day, conducted by QAI
• Introduction to SDH (10 days), APIT, Delhi.
• Introduction to EWSD Switch (3 days), Siemens, Gurgaon.
• Intercultural Co-operation with German Partners (3 days), Siemens, Gurgaon.
• AUTOCAD (4 months part time), CAD Centre, Hauz Khas.