SUMMARY

• 8 Years of experience in the Software Development Life Cycle (SDLC) that includes expertise in the Analysis, Design, Development, Implementation, Testing and Data Warehousing using ETL tools like Informatica, SSIS
• Experience in developing ETL applications using SSIS and Informatica.
• Extensive experience in creating SSIS Packages, Informatica Mappings and Workflows.
• Experience working with various heterogeneous source systems such as Oracle, DB2, SQL Server, MySQL, XML files and flat files.
• Performed ETL performance tuning of the sources, targets, transformations, mappings, workflows and sessions to resolve or remove the bottlenecks.
• Sound knowledge of Oracle, MySQL Database, Data Warehousing Concepts and SQL.
• Creating SSRS RDL Reports.
• Experience in writing Unix Scripts.
• Creating test cases and unit testing of developed component.
• Conversant with all phase of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Understanding the design document and analysing the business process requirements.
• Providing support for user acceptance testing.
• Code base lining and versioning using various tools like Tortoise SVN and GitHub.
• Active involvement in the code deployment process across all testing, production and BCP environments.
• Providing post - implementation, maintenance and enhancement support.
• Working with the Amazon Web Services infrastructure setup.

TECHNICAL SKILLS

RDBMS: Oracle 10g, MySQL, SQL Server

Languages: SQL, C++, C, UNIX Scripting

ETL Tools: Informatica Power Center and SSIS

Additional Skills: Thorough understanding on Amazon Web Services, Micro-Strategy

PROFESSIONAL EXPERIENCE

Confidential

Lead Developer

Environment: SQL Server, SSIS, Flat files, SQL Developer, SSRS

Responsibilities:

• Understanding the business requirements.
• Analyze the requirements and bridge the gaps if any.
• Prepare the database design and document the same.
• Review the design document.
• Design and Develop the code based on the requirements.
• Migrate the existing data to the new system for a seamless transition.
• Support unit and integration testing of all the modules.
• Support deployment and post deployment activities.

Confidential

Lead Developer

Environment: SQL Server, MySQL, SSIS, Flat files, SQL Developer, AWS

Responsibilities:

• Understanding the business requirements.
• Analyze the requirements and bridge the gaps if any.
• Review the design document.
• Design and Develop the code per the requirements.
• Setting up the infrastructure in the cloud for lower environments using Amazon Web Services.
• Create test data adhering to business requirements using T-SQL.
• Create various DB related activities like Cold Backups, Replication etc. for MySQL Database.

Confidential

Lead Developer

Environment: Oracle 10g, Informatica Power Center9.5, Unix, Flatfiles, SQL Developer, Serena Business Manager, HP-QC, Tortoise SVN, Autosys.

Responsibilities:

• Requirement gathering from the Business Analysts and End user.
• Analyze the requirements provided and bridge the gaps and review the design document.
• Design and Develop the code per the requirements with in tight timelines.
• Maintain and create Unit test case documents.
• Interact with the downstream and upstream partners to fulfill the ad-hoc needs.
• Support SIT Testing and UAT Testing.
• Deployment of code to the higher environments.
• Handling Infrastructure requests based on the environment usage and working with DBA’s to keep a track of overall application performance and request for scaling the resources based on the needs.

Confidential

Lead ETL Developer

Environment: Oracle 10g, Informatica Power Center9.5, Unix, Flatfiles, SQL Developer, Serena Business Manager, HP-QC, Tortoise SVN.

Responsibilities:

• Creating a high level design by working in tandem with finance team to understand the requirements.
• Gathering and analyzing business requirements from the business and recommending design changes.
• Identifying the key constrains of the Legacy systems and providing a solution for those as part of new system being developed.
• Develop and maintain SDS as per the business requirements and the PRD proposed by the business.
• Prepare and maintain process flow diagrams to identify the dependencies (upstream/downstream) of the new system being developed.
• Coordinating with the offshore team on daily basis and assigning them tasks to ensure that the business requirements are coded properly.
• Formulating low level design to enable offshore team to convert business requirements into a workable solution.
• Involved in Unix Scripting for basic operations like File FTP, Archival, merging of many files to one.
• Peer review the code developed by offshore team and recommend the changes.
• Analyzing the interdependency of various systems and the new system to help the business user in creating an appropriate job schedule.
• Handling change requests for the existing mappings.
• Deployment to of code to various environments like SIT, UAT and Prod.

Confidential

Lead ETL Developer

Environment: Oracle 10g, Informatica Power Center9.5, Unix, Flat files, XML Files, Excel Files(xls), SQL Developer, Serena Business Manager, HP-QC, Tortoise SVN.

Responsibilities:

• Creating a high level design by working in tandem with system architects to create an application that is robust and scalable.
• Gathering and analyzing business requirements from the business and recommending design changes.
• Involved in peer review of the design document and recommend changes.
• Develop Informatica mappings as per the design document and also analyze the scenarios on ad-hoc requests and recommending a solution.
• Coordinating with the offshore team on daily basis and assigning them tasks to ensure that the business requirements are coded properly.
• Formulating low level design to enable offshore team to convert business requirements into a workable solution.
• Understanding the granularity of data required for different XML targets, recommending the XSD changes to the business and extensively working for key generation to produce XML outputs.
• Involved in Unix Scripting for basic operations like File FTP, Archival, merging of many files to one.
• Peer review the code developed by offshore team and recommend the changes.
• Analyzing the interdependency of various systems and the new system to help the business user in creating an appropriate job schedule.
• Handling change requests for the existing mappings.
• Deployment to of code to various environments like SIT, UAT and Prod.