SUMMARY:

• 7.09 years of experience in development of Oracle SQL and PL/SQL database objects.
• 2 years of experience in ETL development using tools like Oracle warehouse builder, Data Virtualization using Cisco Information Server Studio and IBM Infoshpere Data Stage .
• Currently working as Associates in Confidential in ETL, Data Virtualization and Oracle SQL, PL/SQL Development area for the client E - Trade Financials in Alpharetta GA.
• Experienced in creating Application Interface Design documents and design documents based on High Level Design.
• Experienced in development of Oracle PL/SQL objects like complex Stored Procedures (using Collections, XML types, Ref cursors), user defined Functions, Cursors, Tables, and Triggers, Indexes, Views to facilitate efficient data manipulation and data consistency.
• Experienced in the database development using Oracle 11g/10g/PL/SQL, SQL PLUS, TOAD and SQL Developer and PL/SQL developer
• Experienced in production and QC issue resolution.
• Experienced in migrating the DB Objects from Development to QA, UAT and Production Environments.
• Involved in Database Production Fixes, Production Support activities and resolving support tickets.
• Experienced in working with the DBAs in ensuring that the development and deployments are done.
• Worked extensively with the System / Database Architects.
• Experienced in developing RDBMS.
• Experienced in Production Deployments of Database Objects.
• Experienced in working in Agile Model project.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.
• Mentored offshore associates on PL/SQL by handling training sessions on PL/SQL.

TECHNICAL SKILLS:

Operating System: Microsoft Windows XP, Windows 7

Languages: SQL, PL/SQL

Database: Oracle 11g

Concepts: DWH-ETL Process, DBMS, Data Virtualization.

Tools: Oracle Warehouse builder 11g, IBM Infoshpere Data Satge, Toad, I-track, SQL Developer, PL/SQL Developer, Cisco Information Server studio, SVN, Rally Dev,Putty (Unix), Altova XML SPY (XSD creation and XML validation), ControlM for Job scheduling.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

PL/SQL, ETL Developer

Responsibilities:

• Involved in various stages of development like Analysis, Design, Coding and unit testing.
• Development of new PL/SQL packages, ETL packages (Parallel jobs, Sequence Jobs in Data stage, mappings and process flow in OWB) and enhancement of existing packages as per business requirement.
• Creation of new JCLs and update existing JCLs for controlM automation for ETL packages.
• Adding data sources in CIS, creation of views, procedures and publish them to push the data to client for reporting purpose.
• Perform admin activities in CIS manager like user management, privilege management.
• Development of new views and enhancement of existing views in DV.
• Enhance existing oracle procedure changes and creation of new procedure.
• Creating mappings and process flow to support to load data into the database from various data sources.
• Review and Analysis of Business Requirements.
• Debugging and deployment of the code.
• Peer review of Design, Coding and testing.
• Responsible for error free and timely delivery.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.
• Resolving issues and providing inputs for performance improvement.
• Active Involvement in Defect resolution.

Confidential, Minneapolis, MN

PL/SQL Developer

Responsibilities:

• Development and enhancement of PL/SQL packages, functions, procedures as per client requirement to support data migration from source to target.
• Procedure changes and creation of new procedure.
• Involved in various stages of development like Analysis, Design, Coding and unit testing.
• Performance testing and Tuning.
• Review and Analysis of Business Requirements.
• Debugging and deployment of the code.
• Peer review of Design, Coding and testing.
• Peer review of test plan.
• Responsible for error free and timely delivery.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Confidential, Atlanta, GA

PL/SQL Developer and Designer

Responsibilities:

• Creation of AID and AD based on the HLD as per business requirement.
• Involved in various stages of development like Analysis, Design, Coding and unit testing.
• Changes and creation of new PL/SQL packages as per business requirement.
• Procedure changes and creation of new procedure (mainly used Collections, XML types, Ref cursors).
• As part of the CCR- R Team I have the responsibility for vending data for the middleware clients.
• Performance testing and Tuning.
• Review and Analysis of Business Requirements.
• Debugging and deployment of the code.
• Peer review of Design, Coding and testing.
• Peer review of test plan.
• Responsible for error free and timely delivery.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.
• Resolving issues and providing inputs for performance improvement.
• Active Involvement in Defect resolution.

Confidential

Data Analyst and PL/SQL Developer

Responsibilities:

• PMF in Life project’s objective is to make the business changes for products which are either already LIVE or launching new products on an existing live baseline.
• These changes are done on a monthly basis which includes price changes and other changes like product name changes or any other attribute changes.
• These product changes comes as a front door request and then goes through different phases like Design, Data Build, E2E Testing and finally deployed on LIVE.
• Oracle PIM (Product Information management) Database which holds the information of all BT products like broadband, DF products, PSTN, BT vision etc is responsible for data vend out activity.
• Understanding of Change Requests.
• Data change discussion with the SMEs and VVT
• Through the ETL process makes changes in database, Extraction of old data Transformation of the old data into new changes and Loading the updated data on server, after that release the data on multiple OSSs like billing, OV etc.
• Apart from ETL activity I had the responsibility of creation or enhancement of new PL/SQL packages