PROFESSIONAL SUMMARY:

• 11 years of experience in IT including extensive Functional and Technical expertise in Data Warehousing, Data modelling, Business Intelligence, Reports Generation, SQL Development and Business Analysis.
• 5 years of experience as Technical Lead on various Data Warehouse projects.
• Experience providing Enterprise Business Intelligence and Data Warehouse solutions. Good technical knowledge and experience working on Informatica Power Center 7.1.3/8.6.1/9.1.0, Power Exchange 8.5.1, Oracle 10g/11g PL/SQL, SQL Server 2005 and Linux / AIX Servers.
• Strong expertise in EDW Concepts/Tools. Good understanding of Data Warehouse, Data Management, CDC, Business Intelligence BI , OLAP, OLTP and ERP concepts.
• Strong domain experience in Supply Cain, Telecom, Banking, Manufacturing and Financial services.
• Experience in Oracle 10g/11g and SQL Server 2005 databases, writing complex SQL queries, PL/SQL and Stored procedures Triggers.
• Good knowledge on performance tuning of long running SQL queries on Oracle and SQL Server.
• Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, and reusable objects using Informatica Power Center.
• Programming experience in designing and developing Unix Shell Scripts for automation of ETL Process, Error handling and Auditing.
• Good knowledge on logical and physical modelling techniques using Erwin and MS SQL workbench.
• Experience on OLAP reporting tools like SAP BI/BW and Business Objects.
• Expertise in using scheduling tools such as Autosys, TWS and cron.
• Excellent skills in Data Analysis and maintaining Data Quality / Data Integrity.
• Experience in managing Informatica Servers using Informatica PowerCenter Administration console, Domain, Nodes, Integration service and Repository service.
• Experience working on complex Source system / legacy system Landscapes. Worked on projects involving 20 Source Systems.
• Experience in analyzing business specification documents, developing test plans, defining test cases, developing and executing scripts, manual quality Assurance testing of Client/Server, using Mercury Quality Center 8.0.

TECHNICAL SKILLS:

• ETL: Informatica Power Center 9.1.0/8.6.1/7.1.3, Power Exchange 8.5.1
• OLAP Tools: Business Objects XI/6.x, Cognos Impromptu 7.1, Bex Analyzer, Cognos Series 7 and 8.x
• Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3.5/4.0/4.1, Microsoft Visio
• Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2008, IBM DB2 UDB, MS Access 2003/2010
• Tools: MS Project, Visio, SQL Loader, Exam-Diff, Autosys, Dollar Universe, Cron, TWS.
• Languages: SQL, TSQL, PL/SQL, UNIX Shell Scripting KSH , Perl, C, C , VB6, .NET
• Web Technologies: HTML, PHP, XML, Apache Server, Java script
• Operating Systems: Windows 2000/2003, OS/390, and UNIX AIX.

EXPERIENCE:

Confidential

ETL/BI Technical Lead

Environment: Informatica Power Center 7.1.3/8.6.1/9.1.0, IBM AIX/Linux, Oracle 11g/10g, SQL Server 2005/2008, SAP BI/BW, BEX Analyzer, SAP R3 4.6 /ECC 6.0, Business Objects, Windows XP, Autosys, Crystal Enterprise, Exam-Diff 6.0, MS Project and MS Visio.

Responsibilities

• Integrated MWV's legacy source systems to Enterprise Data Warehouse. Source system landscape was integrated using Informatica Power Center. Involved in all SDLC phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.
• Managed end-user business intelligence Business Objects and ensured data is balanced in the source systems.
• Liaison with business and IT teams in the organization crafting solutions in DW/BI.
• Maintain and develop packages, stored procedures, functions and triggers on Oracle database.
• Participated in gathering business requirements for the Data Warehouse Source Systems.
• Work with QA to resolve data quality issues related to ETL and data conversion projects.
• Analysed ETL processes, prepared level of estimates, assigned tasks, provided system test support and involved in code migration activities.
• Develop and maintain complex SQL queries in Oracle, SQL Server and DB2 to analyze issues in the ETL / Data conversion projects.
• Enhance performance of long running queries or bottlenecks on ETL projects.
• Improved the Query Performance both Data Loads and Data Reporting Queries by applying new techniques and removing wasteful processing of data by identifying and removing dormant and redundant data throughout the Data Warehouse.
• Supported global data convergence strategy through ETL Using Informatica Power Center releases 7.1.3/8.6.1/9.1.0 process development and minimized failure points within current processes.
• Use Informatica Best practices based on industry standards.
• Ensure surrogate key assignments are as per Organization standards.
• Work with other key teams on Architecture and overall Integration of Data.
• Maintained managed multiple Production/Test/Dev Quality database instances of the Data Warehouse. Including BO and ETL databases 20 Production/Development/Test/Quality and Upgrade database instances, which contain more than 2.25 Terabytes volume of data .
• Supported Business projects for successful Go-Live or implementation.
• Extracted and Maintained Reference/Dimension Information used in Data Warehouse reporting from various Reference Systems.
• Developed and maintained OLAP reports in SAP BI/BW using BEX and Business Objects.
• Maintained multiple SDLC Informatica environments, user creation and group creations across various teams.
• Migrated code across repositories and maintained version control and Deployment groups for code migrations.
• Involved in on call support to resolve production issues during implementations.

Confidential

DW Consultant:

Environment: Informatica Power Center 7.1, UNIX shell scripts, Oracle 9i, Windows XP, DB2, Crystal Enterprise, Hyperion, Cognos Impromptu, IBM QMF, and Linux.

Responsibilities:

• Involved in Supporting BI and ETL Applications production jobs and changing existing code based on business needs.
• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Developed SQL queries, triggers and procedures using SQL Plus.
• Automated and improved Business processes using existing technologies.
• Managed master data / dimension for use in Data Warehouse reporting.
• Scheduled jobs, created users and provided DW Administration.
• Migrated code across repositories and maintained version control and Deployment groups for code migrations.
• Used transformations such as Lookup, Union, Normalizer, Update strategy, Expression, Filter, Aggregator, Joiner, Router, Rank and Sequence generator etc
• Developed Type2 Type3 slowly changing dimension mapping for various project requirements.
• Extensively used debugger, analysed log files and loader logs to test the data.
• Developed override SQL statements in Source Qualifier and Lookups to extract desired data from desired region.
• Created mapping parameters and variables in Informatica to handle the incremental date logic using parameter file to connect to various environments.
• Identified bottle neck and fine-tuned Source, Targets, Mappings, Transformations and sessions for better performance
• Supported unit testing and integration testing for the Informatica mappings and Warehouse data and prepared Technical design documents.
• Involved in on call support to resolve the production issues during the implementations.
• Wrote various UNIX shell scripts to handle File process, validation and ETL controls.

Confidential

ETL Developer:

Environment: Oracle 8i, Informatica 5.1.1, PL/SQL, Business Objects, UNIX HP Windows NT.

Responsibilities:

• Involved in extracting source data from different files and developed mappings by using Informatica designer and also involved in debugging of mappings and unit testing.
• Involved in developing Data Warehouse using Star schema.
• Created repositories using Informatica Repository Manager.
• Analyzed requirements, functional specifications and the source data to be moved to the Data Warehouse.
• Developed SQL join queries for better performance and PL/SQL stored procedures for loading data into data warehouse.
• Configured the sessions to load data from various heterogeneous sources.
• Worked on pre-session and post-session settings and file list generation.
• Developed work flow diagrams and worked with technical specifications.
• Involved in Performance tuning for mappings and sessions
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Involved in developing the mapping, which contains all the Lookups used by all the facts to improve performance.
• Used Server Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Involved in error checking and testing of ETL procedures and programs in Informatica session log.

Confidential

Oracle Developer:

Environment: Oracle 7, SQL, Visual Basic, ODBC and Photoshop6.0, Windows NT.

Responsibilities:

• Analyzed system specification and business requirements.
• Designed and developed detailed test plan.
• Developed forms to automate business process and generated reports for decision making.
• Inserted Buttons, text boxes, combo boxes and various Visual Basic objects for user-friendly interfaces.
• Developed oracle PL/SQL stored procedures for calculations.
• Developed validation code for data entry screens.
• Involved in connecting the user interfaces to the database to store and retrieve the data.