Experience Summary

• Nine plus years of professional IT experience.
• Solid experience in Data warehousing field specifically Informatica 8.X, 9.1.0, SQL SERVER 2000/2005, SSIS,SSAS,SSRS,Oracle 9i,10g.
• Experience in Informatica installation/configuration and administration.
• Expertise in using Informatica client tools Designer , Repository Manager, Repository Server Administration Console, Workflow Manager and Workflow Monitor
• Expertise in testing, debugging, validation and tuning of mappings, sessions and workflows in Informatica
• Solid experience in analyzing and fixing Production issues in the Informatica Applications
• Excellent Data Analysis skills.
• In-depth understanding of Data warehousing concepts such as Kimball's methodology, OLAP, SCDs type1,type2 and type3 , star schema and snowflake schema
• Strong programming and debugging skills in PL/SQL, SQL and Unix shell scripting
• Extensive experience in entire SDLC
• Extensive production support experience including day to day monitoring of Informatica jobs
• Worked as onsite coordinator/team lead, good experience in working in onsite-offshore model.
• Working knowledge on OBIEE and Hyperion Essbase.
• Worked on POCs using OBIEE and Essbase.

TECHNICAL SKILLS

CHRONOLOGY OF EXPERIENCE

Confidential

Role: Sr. Informatica ETL Developer

• Create data integration strategy from different source systems in the data warehouse.
• ADT provides residential and small business electronic security, fire protection and other related alarm monitoring services in North America.
• Athena data warehouse is a new enterprise data warehouse in ADT. Sources data from multiple source systems and loaded into staging area. Data is subsequently loaded into integration layer and then to data mart layer. OBIEE reports are built based on mart data.
• Perform data profiling of different ADT source systems using Informatica Analyst 9.6 and SQL / PLSQL scripts.
• Create reusable transformations and code snippets to calculate important business metrics from transactional data.
• Design , document and implement complex ETL extract, transform and load logic as per business requirements to stage data, normalize and integrate it in warehouse
• and to derive and pre calculate critical business metrics and key performance indicators using Informatica Power Center 9.6 mappings, sessions and workflows, Oracle 11i PL / SQL scripts , packages, procedures etc.
• Provide inputs to create data marts to support existing reports and feeds as well as to support future enhancements.
• Design and implement data marts using Ralph Kimball hybrid methodology to enable OBIEE reporting.
• Design and build out bound feeds to ADT's business partners, compliance companies etc.
• Perform data quality checks and provide inputs for data cleansing in source systems.
• Create testing scripts for unit testing as well system integration testing.
• Perform code reviews.
• Create database objects like tables, indexes, triggers, packages, stored procedures, functions etc.
• Facilitate user acceptance testing.
• Create UNIX shell scripts to cleanse data, format files, perform server maintenance and ftp files to different servers within ADT.
• Optimize performance of ETL by the use of index creation, mapping partitioning, encoding logic, optimizing buffer size and modifying commit intervals in data load.
• Create static and dynamic deployment groups to bundle ETL code and promote it to Test and Production.
• Perform ongoing maintenance support of existing warehouse and business needs during the transition phase as well as for new DW.
• Report daily status of all assigned tasks.
• Create data dictionaries to capture metadata, low level ETL and reporting specifications as well as production run books and troubleshooting guides.

Environment :

Informatica 9.6.0,Oracle 11g,AIX 6.1.,OBIEE

Confidential

Role: Sr ETL Developer SSIS/Informatica

• Worked on developing SSIS packages and Informatica mappings.
• Business requirements gathering and preparing technical specifications documents.
• Extensively worked on Process Design, Development and Testing
• Effectively interacted with Business Users in analyzing the data quality issues reported.
• Extensively worked on debugging the programs for data quality issues and job failures
• Assisted in all aspects of the project to meet the scheduled delivery time.
• Conducted unit testing of the enhacements done.
• Worked as a part of a team and provided 7 x 24 Support when required.
• Involved in enhancements and Production Support.

Environment :

Informatica,SSIS and SQL Server

Confidential

Role : Informatica Lead Developer/Administrator

• Worked on Informatica installation on AIX and configuration.
• Business requirements gathering and preparing technical specifications documents.
• Extensively worked on Process Design, Development and Testing
• Trained DWH team on informatica 9.1
• Effectively interacted with Business Users in analyzing the data quality issues reported.
• Extensively worked on debugging the programs for data quality issues and job failures
• Worked on creating shell script for enhancement in the current application.
• Completed the performance tuning in the current process and finally reduced the job run time considerably.
• Developed Stored Procedures, Packages and Functions.
• Assisted in all aspects of the project to meet the scheduled delivery time.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation and process flow of the application
• Conducted unit testing of the enhacements done.
• Worked as a part of a team and provided 7 x 24 Support when required.
• Involved in enhancements and Production Support.

Environment :

Informatica,Oracle 10g,PL/SQL,Cognos and UNIX Shell scripting

Confidential

Role : BI Developer

• Extensively worked on Process Design, Development, Testing and Implementation of the Project.
• Effectively interacted with Business Users in analyzing the data quality issues reported.
• Created Technical design specification documents for implementing the solution for new countries.
• Extensively worked on debugging the programs for data quality issues and job failures
• Worked on creating shell script for enhancement in the current application.
• Completed the performance tuning in the current process and finally reduced the job run time considerably.
• Developed Stored Procedures, Packages and Functions.
• Assisted in all aspects of the project to meet the scheduled delivery time.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation and process flow of the application
• Conducted unit testing of the enhacements done.
• Worked as a part of a team and provided 7 x 24 Support when required.
• Involved in enhancements and Production Support.

Environment :

Oracle 10g,PL/SQL,UNIX Shell scripting

Confidential

Role: Tech Lead/onsite co-ordinator

• Actively involved in understanding the business requirements and converting them into design documents.
• Designed the ETL/OLAP processes using Informatica and SSIS/SSAS to load data from Oracle,SQL Server, Flat Files Fixed Width and delimited into Staging tables.
• Created Mappings and Mapplets using Informatica Designer and processing tasks using Workflow Manager that populated the Data into the Targets on Oracle 11g Instance and involved in Performance tuning of targets, sources, mappings and sessions
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level and used different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator in extracting data in compliance with the business logic developed.
• Created Informatica mappings with stored procedures to build and load cross reference tables
• Developed ETL mappings, transformations using Informatica PowerCenter 8.6. Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability
• Generated Flat file Targets and Reports for the target team with Header and Tailers.
• Created database objects including tables, indexes, views, materialized views, constraints, jobs, snapshots, table partitioning and development of SQL, PL/SQL, stored procedures, triggers and packages and troubleshooting and performance tuning PL/SQL and SQL.
• Involved in enhancements and maintenance activities including performance tuning, writing of stored procedures for code enhancements, creating aggregate tables, and modifying target tables.
• Proficient in Performance Tuning, Troubleshoot of sources, targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints, changing session parameters, re-designing the mappings, using test loads.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed.
• Provided support for Dev/SIT/UAT/Prod runs to analyze and fix the issues in

Runtime.

• Involved in setting up the Dev/UAT UNIX Environment and Created UNIX shell scripts to run the workflow from Unix and created PL/SQL procedures, pre-session and post-session scripts to ensure timely, accurate processing and ensure balancing of job runs.
• Extensively worked SSAS and MS-OLAP in building cubes
• Performed Disaster Recovery activity to ensure the systems availability during un expected events.
• Involved in planning and migration of servers from one Data Centre to another data centre.

Environment :

Informatica PowerCenter 8.6.1, Oracle 10g,MS SQL Server 2000/2005, SSIS,Sun Solaris 5.10 Unix, SQL, PL/SQL,Hyperion Essbase,SSAS and Cognos.