SUMMARY

• Total 11 yrs experience in ETL Analysis, Development, Performance Tuning and Support in Data Warehousing projects
• Have worked in Telecom, Life Science, Financial Services and Real Estate(confidential) Domain
• Have extensively worked on writing PLSQL procedures and complex queries in Cognizant, Life Science project for 3.4 years and modifying existing queries for performance tuning.
• Have extensively worked on Performance tuning in Onsite and Offshore at TechMahindra for 3.3 years.
• Have extensively worked on Oracle and Oracle Warehouse Builder, Requirement Capturing and providing solution for Implementation.
• Worked as OWB Consultant to migrate entire ETL logic in SSIS to OWB 11gR2 in Accenture (client location) for 15 months
• Been trained and working on Informatica projects from past 3 year
• In - depth business knowledge of Telecom domain of 3.3 years with specialized knowledge about Business Intelligence
• In-depth business knowledge of Life Science domain of 3.4 years with specialized knowledge about Business Intelligence
• Handled & interacted with Business users & client during requirement gathering, leading on end2end deliverables
• Closely worked with Data Modeler, DBA’s, and Reviewers when doing low level designs for a requirement. Co-ordination & delivery management
• Experience of around 16 Months of working directly with clients & their vendors, at client location in Cardiff, UK as ETL analyst
• Experience of around 11 Months of working directly with clients & their vendors, at client location in New Jersey, USA as Onsite coordinator and Technology Specialist
• Coordinated with offshore teams, delegating work & handled change request and defects deliveries to the client
• Worked on enhancements and defects including end2end deliverables of both. Worked on development projects handling end2end deliveries single handedly from Onsite
• Worked on Data Migration Project from Siebel CRM to Salesforce

TECHNICAL SKILLS

Languages: PL/SQL

Other Technologies: Oracle Data Integrator 11g Informatica 8.1.1, 9.5.1 Oracle Warehouse Builder (10.1, 11.2) Oracle Data Warehousing & Data Modeling OMB Plus Scripting Unix Scripting Informatica Cloud

Databases: Oracle 8i to 11gR2 SQL Server MySQL Server

Other Applications: Microsoft VSS Borland StarTeam Quest TOAD Oracle SQL Developer Clarify TestTrack Pro Quality Center Salesforce JIRA

PROJECTS SUMMARY

Consultant

Confidential

Responsibilities:

• Initially this was a development project where we converted the Informatica Cloud, ETL to work with MySQL server from SQL Server
• Did Development, Support and Enhancement in ETL Informatica Cloud to provide data for MicroStrategy reporting
• Developing code for all required database objects in MySQL
• Doing End to End testing for components developed in Informatica Cloud, MySQL
• Worked on making changes in existing Python scripts

Confidential

Consultant

Responsibilities:

• Did reverse engineering of existing Informatica Mappings to understand the existing ETL coding
• Developing mappings in ODI 11g
• Developing code for all required database objects
• Doing End to End testing for components developed in ODI

Confidential

Sr. Software Engineer, QA Test Engineer

Responsibilities:

• Understand the functional requirements
• Test the Front-End applications for each of the objects like Contacts, Account, Leads, Opportunities, verifying if every stage is working correctly
• Interacting with developers and clients to understand the implementation and functionality expected from Application

Sr. Software Engineer

Confidential

Responsibilities:

• Did reverse engineering of existing Informatica Mappings to understand the existing data model
• Preparing low level design for mapping objects from RightNow to Data warehouse
• Developing code for all required database objects
• Developing ETL logic required for in Informatica
• Doing End to End testing for components developed in Informatica
• End to End deliverables of data warehouse code

Confidential

Sr. Software Engineer

Responsibilities:

• Preparing Low level design
• Developing code for all required database objects
• Developing ETL logic required for in Informatica
• Doing End to End testing for components developed in Informatica

Confidential

Sr. Software Engineer

Responsibilities:

• Preparing Low level design
• Preparing Low Level design document
• Developing ETL logic required for Confidential in Informatica
• Making changes in existing interfaces
• Doing End to End testing for components developed in Informatica

Confidential

OWB Consultant

Responsibilities:

• Migrating Entire ETL logic Build in SSIS to OWB, including the Generic code and making it compatible with new Batch Framework
• Preparing guidelines/code review checklist for developers to be followed while coding
• Preparing Training document, Development Guide, Troubleshooting Guide
• Fixing on System Testing, APPSIT, P&V Defects
• Performance Tuning of New OWB Code

Confidential

Technical Lead

Responsibilities:

• Developing new interfaces
• Unit testing and System Integration Testing and support for deploying the code into Production
• Resolving production issues
• Enhancement to existing Interfaces
• Database Clean-up activities
• Resolving technical challenges faced in the team
• Performance Tuning & Code review.
• Acquired Domain knowledge for Life Sciences/Pharma Industry.