SUMMARY

• Over 7 years of IT experience wif extensive Data Warehousing implementations across Health Care, Financial, Pharmaceuticals.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Knowledge on Business Intelligence tools like OBIEE/Siebel Analytics, Business Objects/Crystal reports.
• Experienced in Installation, Configuration, and Administration of Informatica PowerCenter on Client/Server environment.
• Has extensively worked on Teradata, DB2, Oracle 11g/10g/9i/8i.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes for data warehouses.
• Complete understanding of Informatica Power Center 9.x/8.x architecture and experience using Informatica PowerCenter 9.1/8.x/7.x.
• Experience in Informatica PowerCenter Designer, Source Analyzer, Warehouse Designer, Repository Manager, Repository Server, Administration Console, Server Manager, Workflow Manager, Workflow Monitor.
• Has extensively worked on data conversion projects.
• Experience in Debugging/Optimizing/Tuning Informatica mappings for better Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Strong noledge of Entity - Relationship concept, Facts and dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Well versed inOLTP Data Modeling, Data warehousing concepts.
• Involved in Data modeling to determine data definitions and establish referential integrity of the system.
• Performed system Analysis and QA testing and involved in Production Support.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Data modeling experience using Dimensional Data modeling, Star Schema modeling, Physical & logical data modeling in ERWIN.
• Extensive experience in writing PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.
• Experienced in loader utilities including SQL Loader and Teradata TPump, Fast Load and MultiLoad.
• Experience in UNIX shell scripting and PERL scripting, FTP and file management in various UNIX environments.
• Developed and maintained UNIX shell, awk, sed and Perl scripts using VI Editor for automated daily load processes and batch processing.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Ability to meet deadlines and handle multiple tasks, decisive wif strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.x/7.x, Informatica Power Exchange

Databases: Oracle 11g/10g/9i/8i, Teradata 12/V2R6 (BTEQ, Fast Load, Multi Load, Fast Export, T-Pump), IBM DB 2 9.5/8.0/7.0 , MS SQL Server 2008/2005

Data Modeling: Physical and Logical Data Modeling, MS Visio, Star Schema Modeling, Snow Flake Modeling, Erwin

Reporting Tools: OBIEE 10.1.3.1, Siebel Analytics, Business Objects (Web-Intelligence 2.5, Designer 5.0, Crystal reports and Developer Suite & Set Analyzer 2.0)

Programming Skills: C/C++, SQL, PL/SQL, JAVA, Unix Shell Scripting

Operating Systems: UNIX, Windows 2000/2003/NT/XP, IBM AIX

Web Technologies: HTML, DHTML, CSS, JavaScript

Others: SQL*plus, Toad, PL/SQL Developer, SQL*LOADER

Scheduling Tool: Control M

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Informatica Developer

Responsibilities:

• Coordinating wif source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked wif Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Maintaining the shared objects and taking care of import and export.
• Worked on Control M for processing classification file and classification delta file.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica 9.1/8.6.1, Oracle 11g, S QL, AIX UNIX, Windows, Toad, Oracle SQL Developer, SQL Server Management Studio, Unix shell scripting, Control M.

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Involved in designing of Data Validation for accurate data loads.
• Worked on Informatica Designer, Workflow Manager, and Repository Manager for Migration of Code from Informatica Power Center Component.
• Worked on a number of key enhancement requirements and responsible for adding extra functionalities to some of the most crucial modules.
• Developed ETL Mappings using various Informatica transformations like Expression, Lookup, Aggregate, Joiners, Router, Filter, Stored Procedure, SQL Transformation, Update Strategy etc.
• Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships) and determine feasibility and practicability in real time environment.
• Created complex Stored Procedures, triggers, cursors, views and user-defined functions.
• Designed reports using Crystal Reports.
• Knowledge in all phases of SDLC and specifically worked on Define, Build, Test, Deploy and Post Production Phases.
• Involved in debugging of the mappings using Informatica Debugger by creating breakpoints to gain troubleshooting information about data and error conditions.
• Overriding the default query in the Source Qualifier by incorporating SQL queries and applying the business rules at the source itself to improve efficiency and avoid cumbersome transformations.
• Developed Error handling mechanism and delta logic in different mappings. Developed mappings using XML files as sources
• Worked on Push down Optimization, which improves the mapping performance.
• Performance tuning the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Scheduled different workflows using Informatica scheduler.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Was involved in 24/7 Production support as required.
• Used type me and type II dimensions to update and insert the information in the data warehouse.
• Developed FTP/SFTP process to move data in Flat files to receive/send from/to various systems.

Environment: Informatica 9.1/8.6.1, DB 2 9.5/8.0/7.0 , Oracle 11g, SQL Server 2008, AIX UNIX, Windows, Toad, Oracle SQL Developer, SQL Server Management Studio, Erwin 8.2.

Confidential, Durham, NC

Informatica Developer

Responsibilities:

• Interacted wif Business Analysts to gather and analyze the Business Requirements.
• Involved in Designing, forward engineering using Erwin.
• Prepared Technical Required Documents along wif Design and Mapping documents.
• Worked wif BA/BSA, Data Modeler/Architect team in designing the Data Model for the project.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline the data to Database.
• Used Informatica Power Center to create mappings, mapplets, User defined functions, workflows, worklets, sessions and tasks.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Used shell scripts for performing initial file validations like duplicate checks, counts(control & balance), file size & structural validations, date and data type format validations on input and intermediate files coming from a third party system.
• Implemented control and balance piece at all required levels by using ABC layer.
• Created Sessions, Workflows, Link Tasks and Command Tasks using Workflow Manager and monitored the workflows/sessions using Workflow Monitor.
• Extensively used stored procedures, functions and also worked wif parallel processing.
• Worked wif events such as Timer, Event Wait, Event Rise, Control and Decision.
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD.
• Created Unix Shell scripts for FTP/MFT, Error handling, Error reports, Parameter files etc.
• Involved in performance tuning of the complex mappings.
• Performed Unit testing and worked closely wif offshore testing team in preparing test cases for System Integration testing.
• Involved in migration of the mappings, Sessions and other Objects from Development to QA and to Production environment.

Environment: Informatica 8.6, Oracle 10g, SQL Server 2008, AIX UNIX, Windows, Toad, Oracle SQL Developer, SQL Server Management Studio.

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Worked closely wif Business Analysts in understanding the Business requirements.
• Responsible for data analysis.
• Responsible for Maintaining Warehouse metadata, naming standards and warehouse standards for future application development.
• Worked on Dimension/Fact tables to implement the business rules and get required results.
• Assisted in designing Logical/Physical Data Models, forward engineering using ERWIN.
• Utilized Informatica Data Explorer to analyze legacy data for data profiling.
• Used Informatica Data Explorer to find hidden data problems, wherever they are - dat put the project at risk. Using this software we used to discover and analyze all anomalies across all data sources.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and load into Data warehouse using the Mapping Designer.
• Used Java to get files from Java code and used for uploading files.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created reusable transformations in transformation developer/ mapplets in mapplet designer.
• Developed Mappings using various Transformations like Aggregate, Expression, Filter, Lookup, Joiner, Sequence Generator, Stored Procedure, Update strategy and Rank.
• Used Workflow Manager extensively to create tasks, worklets, and workflows and executed the tasks.
• Extensively worked to implement Type-2 slowly changing dimensions using Version number and time stamping to keep track record of changed data.
• Developed PL/SQL stored procedures to implement complex business rules.
• Monitored database performance tuning and implemented the session partitions and made changes to database by re-building the indexes.
• Used to create reusable transformations.
• Used command line mode to embed Pmcmd commands in to shell scripts and used Pmcmd, Pmrep commands in Interactive mode to access repository and workflows.
• Implemented reconciliation process for data consistency between source systems.
• Defects were tracked, reviewed and analyzed.
• Involved in migration of the mappings and workflows from the development server to the Test Server to perform the integration and system testing.

Environment: Informatica Power Center 7.2, Informatica Data Explorer, Erwin, Oracle 9i, SQL Server 2005, Windows XP, Sun Solaris, SQL, PL/SQL, TOAD, UNIX, UNIX Shell Scripting, Clear Quest.