SUMMARY

• 12+ years’ experience building Enterprise Data Integration solutions using ETL tools like Informatica PowerCenter and RDBMS like Oracle, Teradata and SQL Server for Insurance, Banking, Telecom and Life sciences industries.
• Well versed with all phases of software development life cycle (SDLC) starting with requirements, analysis, design, development, testing, implementation and maintenance using Waterfall and Agile methodologies.
• Strong expertise in Data Warehousing, Business Intelligence, Performance management, Requirements gathering, Requirement analysis and Data Modeling.
• Solid understanding of Ralph Kimball/WH Inmon approach and experience in Dimensional data modeling, Star schema modeling, Snow - Flake modeling, identification of fact and dimension tables.
• Well versed with building of ER data model
• Expert in data warehousing techniques for ETL/ELT, Data cleansing, Surrogate key assignment, Slowly Changing Dimension (SCD), Change Data Capture (CDC) and Late Arrival Dimensions.
• Good Exposure in Development, Design, Testing, Implementation, Maintenance, Performance Tuning & Production support
• Good Experience in Data profiling, Business Rules, Data Standardization & Data cleansing by using IDQ and Oracle EDQ
• Good Knowledge in SQL, PL/SQL and UNIX shell scripting
• Experience in Relational Database like ORACLE, SQL Server and Teradata.
• Expertise in providing end-to-end user training and support and provide detail documentation.
• Experience in working with and handling multi-cultural teams having worked at client locations in India, Singapore, Dubai, UK and USA.
• Experience in both leading a team as well as Independent contributor
• Facilitated and evaluated several Business Process Reviews (BPR) and GAP Analysis to resolve business requirements understanding issues.
• Experience in building RFP's for sales pursuits and driving POC projects
• Experience in hiring and managing a technical team
• High performance standards, self-motivated, team-player, resourceful and ready to learn new stuff

TECHNICAL SKILLS

ETL: Informatica PowerCenter 8.x/9.x, Informatica Cloud services

Scheduling Tools: Control-M

RDBMS: Oracle 12C/11i/10g/9i, MS SQL Server 2005/2008, Teradata V2R5/V2R6

Reporting: Tableau 8.x

Languages/ Technologies: SQL, PL/SQL, UNIX shell scripting

Operating Systems: Windows 2000, UNIX and Linux.

Data Quality: Informatica Data Quality 9.x, Oracle EDQ

Other Tools: HP-Quality Centre, SQL Developer, TOAD, MS Visio, WinSCP, Putty, Erwin, VSS & MS Project

Statistical Computing: R Programming

Testing Automation Tool: WinRunner 7.6

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

Project Lead and ETL developer

Responsibilities:

• Carried out Data profiling of the source systems data using IDQ and SQL
• Come up with Standardization and cleansing rules based on the analysis of Source Data profiling
• Interacted with Client's business team to understand Project Requirements
• Involved in preparing design specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Carried out analysis, scoping, Estimation based on project requirements
• Developed Party Role Data model
• Lead a team with peak size of 5 resources
• Lead 2 modules of which one module constituted more than 50% deliverables
• Ensure that the profiling results are leveraged while designing the quality routines
• Design overall ETL Architecture
• Develop ETL Processes to integrate source data from various business line source systems into the MDM system
• Played vital role in Quality Processes like Defect Prevention whilst managing the development
• Develop daily and weekly Status reports and share it with Project Management and Client's team
• Involved in various project management activities concerning CMMi
• Developed an excel macro based data reconciliation tool to assist in unit testing and SIT
• Create unit test cases and capture test results
• Modify ETL mapping/workflow based on Unit testing
• Support Client team in UAT
• Involved in deploying & scheduling code to SIT, UAT and PROD environments
• Supported during the warranty period of the project

Environment: MS SQL SERVER 2008, Informatica Data Quality 9.x, Informatica Data Explorer 9.5, Oracle 11i

Confidential, Bellevue, WA

ETL Developer and Teradata SME

Responsibilities:

• Reverse Engineering of SQL SERVER code that has been implemented in the past and derive business transformation rules
• Carried out Data profiling of sources and identified data anomalies
• Came up with Cleansing and standardization rules based on analysis of Data profiling results
• Developed ER data model based on analysis of business requirements and in consultation with business finalized the same
• Developed Design specification documents from functional specification documents
• Constructed Teradata Tables and other Database objects
• Carried out thorough analysis to identify right Primary Index for Teradata tables
• As Teradata SME for the project guiding Team on critical issues related to Teradata Technology
• Developed Informatica PowerCenter mappings/workflows to integrate data from various source systems into the downstream ODS.
• Developed Unit Test cases and carry out Unit Testing
• Assisted Client during UAT testing phase
• Involved in migration and scheduling of ETL mappings/workflow and other related code to SIT, UAT and PROD environments

Environment: Informatica 9.1, Teradata V2R6, UNIX

Confidential, Schaumburg, IL

Project Lead and ETL developer

Responsibilities:

• Interacted with Client's business team to understand Project Requirements
• Carried out analysis, scoping, Estimation based on project requirements
• Design overall ETL Architecture
• Assisted in development of documentation likes Development standards, Functional Specs, Technical Specs
• Lead a team of two in ETL and Tableau development
• Develop ETL Processes to integrate source data from various source and make it available to Tableau for visualization
• Oversaw Tableau development team and assisted wherever required
• Played vital role in Quality Processes like Defect Prevention whilst managing the development
• Develop daily and weekly Status reports and share it with Project Management and Client's team
• Involved in various project management activities
• Create unit test cases and capture test results
• Modify ETL mapping/workflow based on Unit testing
• Support Client team in UAT
• Involved in deploying & scheduling code to SIT, UAT and PROD environments
• Supported during the warranty period of the project

Environment: Informatica PowerCenter 9.5, Tableau 8.2, Oracle 11g

Confidential, New York, NY

ETL Architect

Responsibilities:

• Conducted interviews, workshops and one-on-one meetings with Business analyst to understand Project Requirements and finalize the same
• Carried out analysis, scoping, Estimation based on project requirements
• Prepare Functional and technical requirements document for JDM KPI’s for non-GPM reporting requirements.
• Design overall ETL Architecture
• Design Solution and Technical Architecture for JDM
• Lead a team of 3 in development.
• Develop ICS jobs to source Data from Model N and populate JADE data mart and make it available to Tableau for Visualization
• Build PL/SQL views in oracle to manipulate data and make it available to Tableau for Visualization
• Conduct System and Integration testing
• Participate in User Acceptance Testing along with Client team
• Develop Production Migration plan and share it with business
• Support during Warranty period
• Conduct Knowledge transfer meetings with support team and Business leaders

Environment: Informatica Cloud Services, Oracle 11g, Model N, Sun OS 5.1

Confidential, New York, NY

ETL Architect cum developer

Responsibilities:

• Conducted requirements gathering session with Business to develop virtualization layer
• First in line was Product Data standardization
• Carried out Data profiling of sources and identified data anomalies
• Came up with Cleansing and standardization rules based on analysis of Data profiling results
• Developed ER data model based on analysis of business requirements and in consultation with business finalized the same
• Developed Design specification documents from functional specification documents
• Constructed Oracle DDL objects like Tables, Indexes, materialized views
• Design overall ETL Architecture
• Develop ETL Processes to integrate source data from various business line source systems into the staging area which feeds virtualization layer
• Played vital role in Quality Processes like Defect Prevention whilst managing the development
• Focused on performance management to enhance updates without compromising Inserts
• Develop daily and weekly Status reports and share it with Project Management and Client's team
• Implement RFC (Request for Change) requests and ensure no code breaks happen
• Developed Unit Test cases and carried out Unit Testing and captured Unit test results
• Oversaw migration of Informatica and oracle objects into SIT, UAT and PROD environments

Environment: Informatica 8.6.1, Oracle 10g, Composite, Red Hat Linux 5.6

Confidential, New York, NY

ETL Architect and developer

Responsibilities:

• Interacted with Client's business team to understand Project Requirements.
• Carried out analysis, scoping, Estimation based on project requirements.
• Develop documentation likes Development standards, Functional Specs, Technical Specs.
• Create database tables partition based on version id and manage data accordingly.
• Created SFTP scripts to move the files from one server another server.
• Create Informatica PowerCenter mappings/workflows to integrate data from various sources into the HCP data store.
• Carry out Data Stewardship activities using PL/SQL.
• Create unit test cases
• Carry out unit testing and capture test results
• Assist Business team in User Acceptance Testing
• Involved in migration and scheduling of ETL mappings/workflow and other related code to SIT, UAT and PROD environments

Environment: Informatica 8.6.1, Oracle 10g, Business Objects 6, Red Hat Linux 5.6