SUMMARY

• 9+ years of extensive hands - on experience in the field of Data Warehousing, ETL Integration, Database development and Business Intelligence with industry exposure in Retail Marketing and Sales, Health Care
• Extensive experience in ETL process using Informatica PowerCenter 9.1,8.6, 8.5, 7.1/6.X.
• Experienced in loading data, troubleshooting, Debugging mappings by analyzing the data flow and evaluating transformations, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2008.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience inUNIXOperating System andShell scripting.
• Experience in using the Informatica command line utility pmcmd to schedule and control sessions and batches.
• Experience in creation of UNIX (AIX) scripts for automation of Data warehouse specific tasks like file movement and file watching scripts.
• Created Schemas (Star and Snow Flake) to fit reporting, query and business requirements.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Expertise in analyzing and coordinating clinical trial data, generating reports, tables, listings and graphs
• Expertise in importing and integrating legacy system data to relational database systems.
• Strong leadership, excellent communication, analytical, design and development skills
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business users across different phases of the project life cycle
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL SKILLS

Architecture: EDW (Enterprise Data Warehousing), BIRA (Business Intelligence Reference Architecture), IDW (Inventory Data Warehousing) and Large scale Batch Processing.

ETL Tools: Informatica Power Center 9.X/8.X/7.X/6.X, Power Exchange 9.X/8.X, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), SSIS

BI Tools: Qlikview 11.0/10.0, Business Objects XIR2, XI, OBIEE 10.XMethodologies/

Data Modeling Tools: Data Mart, Dimensional, Snow Flake, Star Schema, CA Erwin 4.0/3.5.5/3.5.2, Microsoft Visio

RDBMS: Oracle 11i/10g, Teradata, SQL Server, DB2 9.7, UDB

O/S: Microsoft Windows 98/NT/2000/XP, Sun Solaris, UNIX, Linux Red Hat

PROFESSIONAL EXPERIENCE

Confidential, TX

ETL/ Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehouse efforts.
• Developed ETL mappings, transformations using Informatica Power Center 9.5
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, MappingDesigner, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Created ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
• Worked on building UNIX Shell scripts to check and update the Teradata/Oracle tables and appending multiple CSV’S to a single CSV and used them in Datastage jobs.
• Implemented Type 1 and Type 2 Slowly changing dimensions.
• SAP provides the cost data in the form of flat files.Informatica is used to extract the data from SAP UNIX system and load it into the Oracle staging database.
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Schedule jobs as per requirement using Autosys and Control-M.
• Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting.
• Experienced in several facets of MDM implementations including Data Profiling, metadata acquisition and data migration.
• Integrated Crystal Reports into web application using Java/J2ee. Worked on data conversion from old data to new data
• Documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support in administration of the Informatica repository and assisted in the design and architecture of multiple repositories to support multiple application development and QA environments.
• Created and scheduled jobs in Autosys.
• Production support Written 24/6.

Environment: Informatica Power Center 9.5, IBM WebSphere Information Server(DataStage Designer), Power Connect, Teradata, Greenplum, Oracle 10g, Flatfile, Java, TOAD, UNIX scripting, Autosys, Windows XP Professional, Hyperion.

Confidential, Kansas City, MO

Informatica Developer/ Admin

Responsibilities:

• Responsibilities include installation and configuration ofInformatica8.1 on DEV, UAT and PROD environments.
• Informatica9.1 installation and configuration on a distributed environment.
• InstalledInformaticaClients on end user desktops/laptops and troubleshooting daily issues..
• Informaticarepository upgrade from 7.1 to 8.1to 9.1
• Co-ordinate with all the dependent teams like Infrastructure, WINTEL, STORAGE, UNIX, Identity
• Management team upon any planned maintenance and upon the impact on the same onInformatica.
• Continually worked towards improving and stabilizing production environment through shell scripts usingInformaticacommand line utility and deploying them as part of release management
• Involved in support of ETL application batch processes on a rotational, on-call basis
• Developed jobs according to specifications, revising as necessary to meet the desired quality.
• Prepared Unit test cases for the jobs and Performed Unit testing
• Involved in unit, performance, Regression and integration testing of and prepared documentation
• Excessive usage for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Resolved issues occurred during regular testing.Informaticaapplications support and server maintenance
• Installed Informatica power center 9.1 and setup, configure and administration
• Informatica projects creation, users setup and access control
• Trouble shooting Database connectivity problems and Created documentation for various Administration activities.
• Assist in the preliminary planning discussions to determine the objectives, scope, constraints, risks, and deliverables of the project.
• ETL code review and enhancements before Prod deployment

Environment: Informatica PowerCenter 9.1, SQL Server 2008, Windows Xp, Oracle 11g, VSS, Toad.

Confidential, Pleasanton CA

Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• ETL flows are developed from Source to Stage, Stage to Work tables and Stage to Target Tables.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Migrated Informatica Folders from Development Environment to Test and System Test Environment and Worked with Admins to migrate the same to Production environments.
• Wrote PL/SQL procedures for reconciliation of financial data between source and target to automate testing phases and help business for preliminary validation.
• Wrote UNIX scripts, environment files for Informatica.
• Developed Metadata driven code for effective utilization and maintenance using technical metadata, business metadata and process metadata.
• To externalize the business logic instead hardcoding in the mapping I have used Parameter file in Informatica.
• Generated Cognos reports to test standardized reports as per business requirements.
• Tuned Mappings and Mapplets for best Performance on ETL Side and Created Indexes and Analyzed tables periodically on Database side.
• Organized the dataflow and developed many Control M jobs for Scheduling Jobs and moved to production.
• Primary resource in Production support team so, involved in emergency calls when application outage occurred and resolved defects when raised.