Project Oracle
Resume:
Sanyogita Jamadagni
*******************@*****.***
. 9 Years of IT experience in diversified industries like Insurance,
Telecom, logistics and Manufacturing. Over six Years of diversified
experience in IT industry as an Oracle Developer / Lead
. Well Versed with Oracle SQL, PL/SQL and Developer 6i
. Good knowledge of Relational Data Modeling and Relational Database
Concepts like Tables, Primary and foreign keys, Views and Referential
Integrities
. Experience in Design and Implementation of PL/SQL Stored Procedures,
Functions, Packages, and Database Triggers for Oracle Relational
Databases
. Wrote scripts to Load the raw data into the database using SQL* Loader
. Experience in creating materialized views and assigning privileges to
users.
. Proficient in the Data Manipulation using SQL for the retrieval of data
from the Relational Database (inner joins, outer join, group by, order
by, cursors etc.)
. Hands on experience in creating business process flows and business
requirements, Functional and Technical documents
. Experience in Analysis, Design, Development, Testing and Implementation
of various projects in Client/ Server environment for Oracle Databases
using Oracle Development Tools.
. Experience in Development and Customization of Interfaces using Oracle
Developer Suite
. Experience in Installing, Configuring, Upgrading and maintaining client
databases
. Experience in working on both Unix and windows platforms
. Familiar with version control tools PVCS.
. Six Sigma Green Belt Certified. Expert in SEI CMM Level 5 practices.
. Well versed with all phases of Software Development Life Cycle SDLC
. Experienced in working on Production Support, Enhancements and
Development projects.
. Expert in onsite offshore delivery models.
. Excellent interpersonal skills, ability to interact with people at all
levels, good communication and presentation skills.
. My strengths are lead capabilities and an aptitude to learn faster.
. Excellent Analytical and Design Skills
. Well versed with Insurance sector and stream lined the processes for a
major insurance company State Farm Insurance (SFI-USA).
. Won accolades from the client GE Health Care, USA for enhancements to the
application and stabilizing the system.
TECHNICAL EXPERIENCE
Programming Languages : PL/SQL, SQL, UNIX Script, VS COBOL II,
JCL
Databases : ORACLE 7.3, 8.3, 9i, MS Access, IMS-DB, DB2
Oracle utilities : SQL * Plus,
SQL * Loader, Import/Export,
Front end tools : Oracle Forms 6i, Oracle Reports 6i
Visual Basic 5.0, 6.0, IMS-DC
Tools & Utilities : APPWORX scheduling tool, TOAD, Quality center QCT,
Clarify, ISPF-EDITOR Ver 4.2, PANVALET, BTS-
Batch Terminal Simulator, Xpeditor, Microsoft
Hardware : Sun Solaris, IBM - OS/390 series
(Client's Host).
Operating Systems : MS -DOS, Windows 2000/95/NT/XP, UNIX,
OS/390
PROFESSIONAL AND BUSINESS EXPERIENCE
The following serve to highlight my range of experience:
1. Project Name: Connectivity Equipment Documentation (CED)
Maintenance
Client Belgacom, Brussels
Role Project Lead
Organization Tata Consultancy Services Ltd
Duration 07/2007 - till date
Team Size 14 onsite + 14 offshore
Environment Software Languages: SQL, PL SQL, shell scripts
Database: Oracle 9i
Tools: Toad, Appworx, MS Excel, Production
Turnover, PVCS.
Hardware Sun Solaris
Project Description
CED is the group of applications that documents all the FLS(fixed line
services) data from the Inventory, Connectivity etc. till the different
services being provided. These are core business applications. Applications
are as listed below:
. ABD-FH : Fault Management PSTN & ISDN Basic
. ABD-NFH : Non fault management PSTN & ISDN Basic
. ABR : Local Loop Network Inventory
. ITR : Infrastructure Transmission (backbone network Inventory)
The Maintenance Service comprises of following:
. Incident Handling (support activities)
. Corrective Maintenance for the Application Domain Software.
. Enhancements and New developments as per the Market trends.
Contribution: As a Project lead, I was responsible for
. Lead a support project for a major telecom service provider in Europe.
The project is operated as offshore-onsite model with a team size of
around 30.
. Effectively trained, motivated and mentored the onsite-offshore team.
. Involved in requirements gathering/definition/elaboration meetings and/or
interviews with project stakeholders / user community.
. Liaised with Business Users to transform the business requirements to
technical specifications
. Review of functional specifications
. Preparation of technical specifications and review.(Low level design
document)
. Analyzed, Designed, Developed and tested complex Stored Procedures,
Functions, Packages, and Database Triggers.
. Worked extensively in various kinds of queries such as Sub-Queries,
Correlated Sub-Queries, Dynamic SQL, Union Queries and concentrated much
on Query tuning
. Reviewed Unit Test Cases, Testing
. Developed UAT Scripts by working closely with business and testing team
for business requirements
. Ensured on time delivery and smooth running of the applications.
. Facilitated the flow of development, testing phases and deployment of the
changes in production.
. Collected and analyzed the metrics. Established processes to adhere to
the customer defined SLAs.
. Involved in interaction with the End Users and implemented reviews of the
application
2. Project Name: TIP ALS Maintenance
Client GE TIP US
Role Project Lead - Oracle Tech lead
Duration 10/2005 - 06/2006
Team Size 16
Environment Software Languages: SQL, PL SQL, shell scripts
Database: Oracle 8
Tools: Toad, Appworx, MS Excel, Production
Turnover, PVCS.
Hardware Sun Solaris
Project Description
The GE TIP Operational Systems are responsible for maintaining the business
information required for the leasing of trailer units to customers. The GE
TIP Operational Systems collect and process information from the business
users and store this information in a number of databases. From here the
information is processed and then passed via interfaces to other systems
that share the information.
Contribution: As a Project Lead, I was responsible for
. Overall responsibility for the offshore project execution as per the
QMS.
. Resource allocation and delegation of tasks to the team.
. Analyzing and estimating the Work Request received from the Business
Users.
. Prioritization of Issues In order to meet the SLA that is agreed with
GE.
. Planning and estimating for the project, keeping the plan up to date.
. Tracking and Monitoring of the issues using Dashboards.
. Coordinating cross module trainings within the team.
. Support the deployment of migrations/customisations.
. Planned and implemented various SQL statements, stored procedures and
triggers according to the requirements
. Tuned frequently used SQL Statements and PL/SQL blocks using Stats
Pack, TKPROF and Explain Plan
. Managing user/ Roles through Developer and Command line
. Providing database support to the developers
. Loaded bulk amount of data into oracle database using SQL*loader
. Prepare Unit Test Cases, Testing
. Interviewed candidates for recruitment.
3. Project Name: Upgrade and Integration of Market Maker
Legacy system to Oracle Applications
Client GE-Medical Systems, Waukesha WI
Role Team Lead
Duration 02/2004 - 08/2005
Team Size 5
Environment Software Languages: SQL, PL/SQL, shell scripts
Database: Oracle 8.0, Oracle eBS 11.5.9
Tools: Toad, Appworx, MS Excel
Hardware Sun Solaris
Project Description
GE Health Care implemented Oracle e-BS to facilitate their business needs
and smooth functionality of their business. Market Maker is a legacy System
which is used to maintain the GE Health care items MMICV (Market Maker
Inventory Carrying Value) and Transfer Prices. . The project is aimed at
eliminating the existing market maker system, and enables its functionality
to be available through the global instance of Oracle applications. The
item and cost details from and to each legal entity will be available in
the Market Maker. The BOM for each catalog item will be used to roll up the
cost for each item. The MMICV will be determined using the BOM rolled up
cost. The costing module of oracle apps is used to achieve this purpose.
Contribution as a Team Lead, I was responsible for
1. Collecting the requirements from the client and drafting it as a
project charter.
2. Initiated meetings for requirements collection.
3. Analysis of existing system.
4. Review of functional specifications.(MD60)
5. Preparation of technical specifications and review.(MD70)
6. Designed and Created Database objects Tables, Views, and Indexes as
per project requirements.
7. Coded with SQL and PL/SQL to develop Stored Procedures, Functions,
Packages, and Database Triggers to implement business rules.
8. Prepare Unit Test Cases, performed detailed testing
9. Developed Loader Programs to migrate data from legacy system to
database using SQL*Loader
10. Involved in Report Lay out Design and development of Oracle Reports
11. Documentation and presentation of the project.
12. Plan for move to production (PM10)
13. Plan for knowledge transfer.
14. Knowledge Transfer and post implementation support to the production
support team
4. Project Name: Enhancements to Market Maker application
Client GE-Medical Systems, Waukesha WI
Role Team Lead
Duration 07/2002 - 01/2004
Team Size 5
Environment Software Languages: SQL, PL SQL, shell scripts
Database: Oracle 8.0
Tools: Toad, Appworx, MS Excel, Oracle Forms and
Reports.
Hardware Sun Solaris
Project Description
2 Projects (Auto Approval of MMICV, BOM Download from Oracle) were taken up
as enhancements to Market Maker Application.
Auto Approval of MMICV:
This automatic MMICV approval process will create a systematic approach to
approve the MMICV from items in the daily add process into Market Maker. In
the existing system all items submitted to Market Maker go through a manual
approval process before being accepted into Market Maker.
BOM Download from Oracle:
This was a major enhancement in GE Medical systems for Market Maker
Application.
The purpose of this project is to enable Market Maker to pull BOM structure
from Oracle Bill of materials. Since most legacy systems are already on
Oracle and others plan to move to Oracle Application - they do not maintain
BOM structure in legacy system GPCP.
This project helped to eliminate the usage of legacy data from GPCP and
replaced it with data from Oracle. This was a challenging project in which
a legacy system was replaced with an Oracle system. It was implemented in
accordance with the six sigma standards.
Contribution : As a Module Lead, I was responsible for
. Initiated meetings for requirements collection.
. Estimation of efforts and resources. Project plan preparation.
. Analysis of existing system. Design of proposed system. Detailed plan for
migration.
. Review of functional specifications
. Preparation of technical specifications and review.(Low level design
document)
. Designed and Created Database objects such as Tables, Views and
materialized views and assigning privileges to users.
. Coded with SQL and PL/SQL to develop Stored Procedures, Functions,
Packages, and Database Triggers to implement business rules
. Analyzed, Designed, Developed and tested complex Forms using Oracle
Forms.
. Involved in Report Lay out Design and development of Oracle Reports
. Worked extensively in various kinds of queries such as Sub-Queries,
Correlated Sub-Queries, Dynamic SQL
. Prepare Unit Test Cases, performed detailed testing
. Educating the client/functional users about the changes in the
application.
5. Project Name: Market Maker Production Support
Client GE-Medical Systems, Waukesha WI
Role On Site Coordinator
Duration 02/2001 - 06/2002
Team Size 3
Environment Software Languages:, SQL, PL SQL, shell scripts, COBOL,
JCL
Database: Oracle 8.0, IMSDB
Tools: Toad, Appworx, MS Excel, FTP, FILEAID,
Production Turnover, Business Objects, PVCS,
Kintana
O/s: OS 360,
Hardware Sun Solaris, (mainframe - OS/390 series)
Project Description
MARKET MAKER as commonly called, is a global repository to store cost
information of all products and service parts offered by GE Medical
Systems. It is intended to be a single view of the global costs incurred by
GEMS on each product. This global metric is termed MARKET MAKER Inventory
Carrying Values (MMICV). The transfer price is computed for all items from
each source to destination.
The data in this repository is part of the GEMS Enterprise Data warehouse,
where the GEMS MARKET MAKER and Finance functions to carry out what-if
analysis to help them make critical business decisions will use it. All
Decision Support Systems (DSS) related reporting off the MARKET MAKER data
will be done from this Enterprise Data warehouse. Market Maker is a
customized application where in it has interfaces with other finance
modules.
Contribution as an on site Coordinator, I was responsible for
. Coordinating Onsite and Offshore activities, providing technical guidance
to offshore resources
. As the production support team coordinator for Market Maker team, I was
available on 24X7 hour alert to support and set right any process
whenever needed.
. Reviewed technical queries and provide responses within a turn around of
24 hrs.
. In Case of any enhancements, performed studying the requirements,
analyzing the existing code for possible impact and changes explaining
the requirements to offshore and receive the deliverables within the time
lines. Test the deliverables, and make sure that they meet the six-sigma
standards. Repeat procedure until deliverables are bug free. Getting them
verified and approved from the client. Test and integrate the
enhancements into production environment.
. Guide the new sites from Manufacturing that are going live on Oracle Apps, so that their data is loaded and processed in Market Maker. Loaded bulk
amount of data into oracle database using SQL*loader in Market Maker
. Trouble shooting in solving issues.
. Provided database support to the developers.
. Worked extensively on Query tuning
. Partitioned huge tables (size >10GB) for continued data availability,
data management operations, Scalable performance with substantial growth
in data volumes.
6. Project Name: Fire Application Support System
Client State Farm Insurance, Bloomington IL
Role Team Member, Module leader, Onsite Coordinator
Organization Satyam Computer Services Ltd - Hyderabad
Duration 08/1998- 01/2001
Team Size Project: 200 Module: 15
Environment Software Languages: VS COBOL II
Database: IMS-DB / DB2
Tools: Connectivity tool Rumba, ISPF-EDITOR Ver
4.2, PANVALET, RUMBA 95/NT Ver
5.0, Batch Terminal Simulator (BTS), Xpeditor,
VSAM, FILEAID
O/s: OS/390
Hardware IBM - OS/390 series (Client's Host)
Desktop PC 586 machines to access the Client'
host..
Project Description:
The Interactive Fire system is a data input system for the Fire Company.
Interactive Fire is composed of on-line and batch programs which edit and
convert the input data and produce reports about the entry of the input
data.The project is maintenance and enhancement required by Fire Systems
Division of SFI to keep it operational, it involves various stages of
Software Engineering processes like Analysis, Preparing Technical System
Design (TSD), reviewing the code, Unit Testing. The system had both online
and batch subsystems which help in processing the insurance policies.
Contribution: As a Team Member I was responsible for
. Understanding the requirement specifications prepared by Onsite
Coordinator.
. Analysis for implementation.
. Estimating the number of hours needed to implement Work request.
. Preparation of design specifications and code changes specification.
. Ensuring that the Specifications confirm to SFI specified standards.
. Coding the programs in adherence to the specifications
. Preparation of Test cases and test plans.
. Detail testing.
As a Module Leader:
. Review and analysis of requirement specification.
. Delegating the activities to team members.
. Reviewing the technical specifications prepared by the team members.
. Reviewing the code changes and test results.
. Preparing the delivery document.
As an Onsite - Coordinator:
. Coordinating Onsite and Offshore activities.
. Interacting with the client to freeze the requirements.
. Attending Meetings for clarifications of requirements.
. Reviewing the Specs and Test Plans.
. Negative Testing.
. Issuing the changed components to Production.
. Trouble shooting for issues if any.
PROFESSIONAL HISTORY
1 TCS Belgium, July 2007 Project lead for
Brussels to till Application Maintenance
date and support
2 GE TIP US Pennsylvan Oct 2005 Team lead for
ia to Jun Application Maintenance
2006 and support
3 GE Health Care Waukesha, Feb 2001 Project I: Team lead for
WI to Aug Application Maintenance
2005 Project II: Project lead
for Application
integration with Oracle
eBS
Project III: Project
Lead for Application
upgrade
4 State Farm Bloomingto Aug 1998 Project I : Team lead
Insurance n IL to Jan for Application
2001 Maintenance
Project II: Team Member
for Enhancements
5 Ram Hyderabad Dec 1997 Application development
Informatics to May using core oracle
1998 technology
EDUCATION
Master Of Computer Applications - Osmania University, India
B.Sc. Computer Science - Osmania University, India
Contact this candidate