SQL Developer Resume

PROFESSIONAL PROFILE:

Total 13 years of experience out of which 10 years in Analysis, Design, Development, Implementation and Migration of Data warehousing and Data Integration projects using Informatica, Oracle, Teradata and Shell Scripting on UNIX platform.
Worked in the capacity of Project Manager, Technical Lead, Module Lead and Developer on different domains in BIDW like Securities, Healthcare and Retail.
Requirement Gathering with Business Users and translating them to Technical Specifications & ETL Design.
Experience in developing complex Informatica Mappings & Workflows, SQL - PL/SQL, BTEQ’s & Shell Script codes.
Experience in loading High Volume Data and Optimizing SQL-Queries/Mappings/Workflows to improve performance.
Documentation and Maintenance of coding standards as per the Client norms.
Providing Technical/Functional KT to new resources.
Received e-awards and Appreciation from Client/Onsite team for quality work.

WORK EXPERIENCE:

Confidential

SQL Developer

Skillset: Oracle PL/SQL, Informatica Powercenter 8.6/9.5, Unix Shell scripting, Control M.

Responsibilities:

Requirements Gathering and Analysis for new enhancements with Confidential Subject Matter Experts and Business Users.
Impact Analysis, Functional and Technical Design Documentation.
Effort Estimation, Code review and peer testing with team.
Implementation of code, Develop Unit Test cases and Unit Testing on various environments.
Lead role in Migration of 300+ Informatica Workflows from version 8.6 to 9.5.
Migration of application servers from Linux to CHP server and from FTP to FTPS for 50+ upstream/downstream feeds to Linux/Windows servers.
Migration of Oracle Database from 10g to 11g.
Database growth management by various methods like Purging, Moving to Offline Storage etc.
Experience as Project Management role for 1 year.
Onsite and Offshore project coordination with the team.
Application Development and Unit Testing on various environments.
Integration and System Testing on various environment.
Defect Tracking during Quality Acceptance Testing(QAT) and User Acceptance Testing(UAT)
Deployment of code in various environments.
Maintaining Technical and Release documentation.
Support of bug fixes and issues reported.
Status update meeting to track progress of Development Activities.

Pharmacy Advisor

Confidential

Skillset: Informatica 8.6; Teradata, Oracle 10g (SQL/PLSQL); Solaris.

Responsibilities:

Analysis and Creating Application Design document, Review and Signoff with the customers/onsite coordinators.
Developing Mappings using FastLoad/Mload connections .
Created BTEQ’s having SQL queries for loading data to Teradata.
Creating test cases and data loading scenarios for Unit/Integration Testing.
Peer code review and Providing QAT/UAT support for developed modules.
Resolving Performance bottlenecks for Sources, Targets, Mappings and Sessions.
Team Lead role in migration of 400+ Informatica Jobs from one server to another for 3 Months.

Confidential

SQL Developer

Skillset: Informatica 7.x/8.x; Oracle 10g (SQL/PLSQL); HP-UX; Control M; Harvest.

Responsibilities:

Analysis of the requirements and specifications and creating Design Documents.
Developing fact and dimension loading mappings.
Observing and curtailing the Performance bottlenecks at different stages like Sources, Targets, Mappings and Sessions.
Creating metadata, development of Shell and PLSQL scripts to perform the special functionalities, post and pre INFA processing.
Interact with P&G as the IZoom development SPOC for the Confidential team.
Prepare development plan, Issue Tracker, Operation Doc, RTM and Migration Doc.
Pre-BAT/BAT/Hypercare support, Training of new joiners in project.

Confidential

SQL Developer

Skillset: Informatica 7.x, Oracle 10g (SQL/PLSQL); HP-UX; Control M.

Responsibilities:

Preparing LLD documents for new integrations of different customers into P&G warehouse.
Understanding requirements of each source systems and creating metadata in Oracle DB.
Understanding of complete Data Flow and designing and executing end-to-end runs to load data from source feed until to views.
Creating unit test cases and executing SIT.
Scheduling complete E2E in Control M and Pre BAT and BAT support
Creating Views, Materialized View’s and working with External Cube Teams for any data issues.

Confidential

SQL Developer

Skillset: Peoplesoft 8.9, HP-UX, Oracle 10g (SQL/PLSQL).

Responsibilities:

Analysis and Development of PL/SQL codes to extract payroll reports, user reports and troubleshoot day to day production issues.
Complete maintenance of the application and L2/L3 support.
Providing deep investigation and resolution for day to day Incidents which cannot be resolved by L2 support team.
Set up and Troubleshooting of Production Batch Jobs which are scheduled in TIDAL.