BACKGROUND SUMMARY:

• Implemented Dimensional Data Modeling using Star & Snow Flake schema. Good understanding of Ralph Kimball and Bill Inmon Methodologies.
• Hands - on high and detail level design experience of ETL/ELT process using Data Flow diagrams and Data Mapping documents.
• Well versed with Data Warehouse/Data Mart Development Life Cycle.
• Actively involved in Job automation, Performance tuning and Error handling.
• Key strengths include task ownership, superior communication and professional relationship building. Quick learner, go-getter and innovative problem solver.

• Requirement Analysis
• Data Flow & Process Flow Design
• Data Modeling
• High level and Detail level ETL Design
• ETL / ELT development
• Shell Scripting, PL/SQL Coding

CORE TECHNICAL EXPERTISE:

Databases:  Oracle 9i/8i/10g, Microsoft SQL Server 2008, Netezza Twinfin

BI Tools:  Informatica PowerCenter 9.6 / 8.6 / 8.5.1 / 8.1.1 / 7.1.1 , Cognos, Business Objects

Languages:  SQL, PL/SQL, Unix Shell Scripts

Operating Systems:  Linux, All flavors of Windows

Methodologies:  SDLC, Ralph Kimball, Bill Inmon

Other Utilities:  Toad 9.6, ERWin, Visio, Visual Source Safe, Share Point 2007, Autosys, Tidal, WinCVS, ESP Scheduler

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead

Key responsibilities

• Analysis to the Data model and the updates needed to accommodate the changed data requirements
• Detail Design, development, testing of the ETL routines using Informatica 9.1
• No damage testing of the ETL routines that get data from upstream and provide data to downstream applications
• Reverse engineering of ETL routines and updates to them to support the Upgrade
• Support to Deployment team

Analyst / ETL Lead

Key responsibilities

• Detail Design, development and testing of the ETL mappings using Informatica 8.6
• Bridged the gap between the Functional Analyst and the developers, responsible for translating the functional design to technical design and ETL mapping specifications
• Deployed the ETL routines into Production environment
• While serving as the Requirement Analyst on the Supply Chain Core team, collected requirements during the workshops with the business users
• Worked on requirement analysis deliverables - Requirements document, Requirement Traceability Matrix, Fit/Gap Analysis, RICEFW

ETL Lead

Key responsibilities

• Analysis of all SQL Server Integration Services mappings, PL/SQL Scripts and Processes used in the current EDW environment.
• Design of the enhancements to be as implemented on Netezza database that sized 2 TB
• Setting up the Tidal jobs for automating the ELT process

Technical Lead

Key responsibilities

• Data profiling and analysis of documented Source Systems for all products within UMS. These source systems were analyzed for both technical and business requirements.
• Analysis of all the current system - Informatica mappings/Scripts/Processes. This analysis illuminated any business rules currently hidden in source code in production that may not be documented.
• Design of new UMS components was implemented on Netezza database that sized 3 TB to start with
• Creation of new UMS ETL/data movement procedures - using UNIX Shell scripts and PL/SQL
• Setting up the Tidal jobs for automating the ELT process

 ETL Lead

Key responsibilities

• Carried out ETL design, Source Data Analysis, Effort Estimation and assisted Development using Informatica PowerCenter 8.6.
• Carried out Performance Tuning of the Informatica mappings.
• Used Informatica PowerExchange for developing the CDC routines. Used Informatica Data Quality suit to monitor and cleanse the data.
• Defined complex Autosys jobs structure using established procedures and documented dependencies. Worked with the Autosys team to ensure correct implementation of dependencies and job flow.

ETL Lead

Key responsibilities

• Was part of the global development team carrying out Business Requirement Analysis of 7 different source systems and their data interdependency by applying techniques such as Business Process modeling, Dimensional modeling.
• Documented Functional Specifications and designed Process Flows that were further used for Detail Design documentation.
• Lead the ETL developers in the Informatica PowerCenter 8 .6 mapping development and testing phase.
• Assisted the Production Support Team to ensure smooth execution of the interfaces.
• Did Knowledge Transfer to the ETL processes to the Phase II team of 20 resources across the globe.

Sr. ETL Developer

Key responsibilities

• Contributed to the detailed study of the existing data warehousing model and to the documentation of the processes
• Came up with functional specifications and designed data flow diagrams, process diagrams and activity diagrams
• Worked with Data Analysts to understand Sources' inter-dependencies and documented the Mapping Specifications
• Enforced ETL coding standards and best practices. Knowledge transfer of the processes to the team of 5 resources
• Worked with Business users in documenting complex business concepts into Technical Specifications applicable to various data movement and transformation processes
• Contributed to the development of complex ETL mappings using Informatica Power Center 8.1.1 Was responsible for the Installation and Configuration of domains and repositories
• Leveraged these components of Informatica PowerCenter 8.1 - Data Transformation and Scheduling
• Had hands-on training on Informatica PowerExchange for designing CDC routines

Sr. ETL Developer

Key responsibilities

• Did Requirement Analysis and Data Mapping of the most business process intensive transaction interfaces involving heterogeneous systems.
• Developed testing documents in these phases - unit, integration, system and high availability and disaster recovery – which constituted to more than 30% of overall project effort.
• Developed stored procedures, triggers and UNIX shell scripts for the interface between UNIX and Informatica PowerCenter 7.
• Knowledge transfer of the processes to 10 developers at the end of the project life cycle.

ETL Developer

Key responsibilities

• Performed data analysis to identify data quality issues using IDQ and came up with ETL process design for cleansing data.
• Designed and developed Informatica PowerCenter 5.1.1 mappings to load into Staging tables, Dimension and Fact tables in accordance with the functional specifications.
• Designed Error Logging process and generated error files in user-friendly format to allow Data Analysts eliminate errors.
• Designed UNIX scripts, developed PL/SQL scripts for implementing the business logic.