PROFESSIONAL SUMMARY:

• A software professional with 12 years of IT experience, including 6 years of Team Lead and Project Management experience with prominence in DWBI and Database technologies.
• Ability to plan and manage projects aligning business goals with technology solutions. Has managed large teams and delivered complex engagements while performing various roles alike Solution Architect, ETL Lead and ETL Developer.
• 10 years of experience in complete life cycle implementation of Enterprise Data Warehouse Business Intelligence systems and processes. Strong experience in Data Warehouse design, Dimensional Modelling, Informatica ETL Development and Troubleshooting.
• 10 Years of strong Data warehousing experience specializing in RDBMS, ETL Concepts, Strategy, Design & Architect and Informatica Development and Testing.
• An expert in the ETL Tool Informatica which includes components like Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager and Administration Console. Have had extensive experience in working with various Power Center Transformations using Designer Tool. Have handled various Data Sources like DB2, Oracle, SQL Server, Netezza, Flat Files and XML Files.
• Have had extensive experience working with databases like Oracle and MS SQL Server.
• Was involved in the complete life cycle of quite a few Data warehouse implementations which include System Architecture, Technical Design, Development - Coding and Testing (Unit Testing and System Integration Testing) and Implementation.
• Good experience in Unix Shell Scripting and ETL Process Automation using Shell Programming with Informatica. Also, have had quite good experience in Performance Tuning at both Database Level and Informatica.
• Good experience in physical/logical data modelling with various Industry verticals like Retail, Manufacturing, Finance, Insurance and Banking with appropriate DW/ETL Implementations.
• Strong Logical and Analytical Reasoning Skills, Excellent Communication with Good Listening, Presentation and Intrapersonal Skills.
• Strong Team building and mentoring skills with excellent Team leadership capability and performed Managerial roles with a maximum project team size of 20 members.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9x, Informatica Data Quality, MS-SSIS

RDBMS: Oracle, SQL Server, Netezza, Teradata, DB2

Operating System: UNIX, Windows XP.

Other Software: TOAD, SQL Developer, AUTOSYS

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Working with Data Stewards to understand the Functional requirements in order to transform those into design and preparation of documents like BRD and TDD.
• Coordinating with offshore team and guiding with implementing business rules for creating robust mappings, mapplets, and reusable transformations using Power Center and Debugging Mappings to identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Involved in handling change requests and performance enhancement for the existing mappings.
• Creating deployment groups, rollout plan documents for production migration (mappings, workflows, parameter files and UNIX scripts) and supporting the post production support during warranty.
• Worked with Offshore team to oversee the development activity, reviewing code and ensure the standards followed by team.

Confidential

Responsibilities:

• Working with Business Analyst to understand the Functional requirements in order to transform those into design and preparation of documents on the same like Design, STT, etc.
• Coordinating with offshore team and guiding while implementing complex business rules by creating robust mappings, mapplets, and reusable transformations using Power Center and Debugging Mappings to identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Involved in handling change requests and performance enhancement for the existing mappings.
• Creating deployment groups, rollout plan documents for production migration (mappings, workflows, parameter files and UNIX scripts) and supporting the post production support during warranty.
• Worked with Offshore team to oversee the development activity, reviewing code and ensure the standards followed by team.

Confidential

Responsibilities:

• Working with Business Analyst to understand the Functional requirements in order to transform those into design and preparation of documents on the same like Design, STT, etc.
• Coordinating with offshore team and guiding while implementing complex business rules by creating robust mappings, mapplets, and reusable transformations using Power Center and Debugging Mappings to identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Involved in handling change requests and performance enhancement for the existing mappings.
• Creating deployment groups, rollout plan documents for production migration (mappings, workflows, parameter files and UNIX scripts) and supporting the post production support during warranty.
• Worked with Offshore team to oversee the development activity, reviewing code and ensure the standards followed by team.

Confidential, Edinberg

Responsibilities:

• Worked with business analysts to understand business requirements in order to transform business requirements into effective technology solutions.
• Created High level, low level design documents, ETL specification documents and test cases documents.
• Attended weekly status meeting with the client Project Manager to provide updates on all modules within the project.
• Extensively worked on Performance Tuning at the mapping level, session level, source level, and the target level for the mappings which were taking long time to complete.
• Analyze source data for potential data quality issues and reported bad data.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Reviewed the design document and code with support team and also conducted the Knowledge transfer sessions about the project to support team

Confidential

Responsibilities:

• Analyzing the requirements and having discussion with onsite and business team to understand the requirements.
• Involved in Low level design document, ETL specification document and test cases documents.
• Created the Graphs for business requirements also to help the team in their design process, involved in code reviews as the offshore lead in this project.
• Extensively worked with Slowly Changing Dimensions (SCD) and Incremental Loading.
• Created and Documented ETL test plans, test cases, test scripts, expected results, assumptions and validations for unit, integration and system tests for mappings developed.
• Involved in post-production support and monitoring the activity in various environments.
• Involved in Effort estimation for ETL Design and Development.

Confidential

Responsibilities:

• Discussion with Onsite lead for understanding dimensional modeling
• Re-created dimensions and Facts from the existing schema model
• Involved in effort estimation and resource estimation for ETL Design & development
• Created ETL packages for loading Data into DataMart and refreshing the CUBE in periodic basis
• Co-ordinated with SME's and Business analyst for OLAP requirements
• Created High level & Low Level design documents for OLAP requirements
• Co-ordinated with ETL team to identify the new records for cube refresh and scheduling cube processing

Confidential

Responsibilities:

• Designed and developed Informatica mappings, enabling the extract, transform and loading of the data into target tables.
• Involved in identifying source related data quality issues and implemented data quality rules to load data into data warehouse.
• Implemented code re-usability by using Mapplets, transformations, parameters and variables.
• Created and scheduled workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Written UTC for testing the mappings and workflows and testing the same.

Confidential

Responsibilities:

• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Created procedures and packages for the business requirement and ETL requirements
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created, updated and maintained ETL technical documentation.
• Creation of the Test Data & Test cases Unit Testing of the ETL Scripts.
• Code move to other environments QA and Prod.

Confidential

Responsibilities:

• Involved in Preparing the ETL Specs and developing the Packages based on the ETL Specs.
• Implemented the business rules using various transformations within Packages.
• Created, updated and maintained ETL technical documentation.
• Creation of the Test Data & Test cases Unit Testing of the ETL Script.