PROFESSIONAL SUMMARY:

• 7+ years of IT experience in Data Analysis, Design, coding and testing of Data Warehousing implementations.
• Informatica: 7 years of Data Warehousing experience using Informatica Power Center 10/9.5/9.1.0/8.6.1, Power Mart 6.1/5.x, Warehouse Designer, ETL, OLAP, OLTP, Autosys, Control M. Experience in designing and developing complex mappings to extract data from diverse sources including flat files (fixed width, delimited), XML, RDBMS tables, legacy system files.
• Data Analysis: Strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Methodologies: Complete knowledge of data warehouse methodologies (Ralph Kimball, Inmon), ODS, EDW.
• Business Intelligence: Business Intelligence experience using Business Objects 6.5/ 6.0, Cognos Series 7.0, Data Reports, Developer 2000, MS Access Reports.
• Transformations: Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update Strategy transformations.
• Databases: Extensive experience using Oracle 11g/10g, DB 2 8.0/7.0/6.0, MS SQL Server 2005/2000, Teradata V2R6/V2R5, Sybase 12.x/11.x, SAP R/3, MS Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILL SET:

ETL - DW Tools: Informatica Power center 10.x/9.5/9.1.0, Informatica Designer, Workflow Manager, Workflow Monitor, ETL, Data mart, OLAP, OLTP, Mapplet designer, Transformations, Control M, SQL*Plus, SQL*Loader.

Dimensional Data Modeling: Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions tables, physical and logical data modeling, Erwin 4.1.2/3.x and Oracle Designer

Reporting Tools: Business Objects, Web Intelligence, Tableau

Programming Languages: SQL, C, C++, Java

Databases: MS SQL Server 2008/2005, Oracle 11g/10g/9i, PL/SQL, DB2 UDB, Fox Pro, MS SQL Server

UNIX Tools: Shell Scripts, C Shell, K-Shell Scripts, AWK and VI-editor.

GUI: Visual Basic 6.0/5.0/4.0, FrontPage 98/2000, Excel, Power Point.

Servers: Oracle 9iAS, MTS, IIS, Apache, Tomcat and MS Site Server, Web sphere

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Sr Informatica Consultant

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field user and support for production environment.
• Closely Worked with the Data Architects to understand and design the architecture of the ODS.
• Used Erwin for logical and Physical database modeling of the warehouse, responsible for Database schemas creation based on the logical models.
• Designed the Tech Specs Document helpful for developing the mappings based on the Business requirement.
• Worked extensively on different types of transformations like Source Qualifier,normalizer, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator, Sorter, joiner etc.
• Designed and Developed complex mappings, reusable Transformations.
• Developed mapping to implement Type 1 and Type 2 SCD.
• Created Sessions, workflows and worklets for designed mappings.
• Wrote Unit test and Data validation plans for the mappings.
• Wrote Reusable Script generators to perform the data validation in Test environments.
• Extensively worked in performance tuning of programs, ETL procedures and processes. Also used debugger to troubleshoot logical errors.
• Worked on Stored Procedures, triggers, views and indexes.
• Worked on SQL Scripts and implemented the database CDC process.
• Written SQL overrides in source Qualifier according to business requirements.
• Deployed the code to higher environments using tickets.
• Build Master responsibilities like creating the Database Connections, Creating and Updating Parameter Files using the Parameter File Utility, Executing the DDL and DML scripts in Higher environments using Production Data and Procedure Change App.
• Performed Code Review in all the environments.
• Co-ordinate with the users and provided all possible KT sessions.
• Requested policies from Policy Center to support the testing criteria of Finance.
• Developed Unix Shell Scripts to schedule the Informatica process using UNIX command and Informatica pmcmd commands.

Environment: Environment: Informatica 10.1/9.x, Business Objects, Informatica B2B Data Transformation Studio 9.0, Oracle 18, Exadata, Informatica MDM 9.0, ER Studio Data Architect 8.5, MQseries Messaging, Visio2003, XML Spy, Autosys

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Converted the business requirements into technical specifications for ETL process.
• Worked with PeopleSoft team to identify the best means of extraction of source and source data validation directly from PS tables.
• Developed Informatica Mappings/Sessions to populate the Data Warehouse and Data Mart.
• Worked on modifying/ updating PL/SQL codes, views, materialized views and stored procedure, triggers and packages.
• Used technical transformation document to design and build the extraction, transformation, and loading (ETL) modules.
• Designed and Developed Informatica Mappings which will capture and load the incremental load from the source tables into the target tables.
• Implemented Slowly Changing Dimensions - Type I, II mappings as per the requirements.
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications
• Coordinating with source system owners, day-to-day ETL progress monitoring and maintenance of daily Informatica batch schedule run on a nightly basis.
• Developed complex mappings using Informatica Power Center Designer to transform and load data from various source systems like Flat files, Mainframe DB2 IBM MQ Series, SQL Server.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet designer and Transformations.
• Worked on various Transformations such as Source Qualifier, Expression, Aggregator, Stored procedure, and Connected & Unconnected lookups, Filter, Rank, Router, Sequence Generator, Sorter, Joiner and Update Strategy.
• Created error log table to capture the error messages, session load time.
• Optimized Query performance and DTM buffer size, Buffer Block Size to tune session performance.
• Performance tuned the workflow by identifying the bottlenecks in sources, targets, mappings and sessions.
• Worked on creating Mapplets and reusable transformations to prevent redundancy ofTransformation usage and maintainability.
• Used Workflow Manager for Workflow and Session Management, Database Connection Management and Scheduling of jobs.
• Developed SQL overrides in Source Qualifier according to the business requirements.
• Implemented variables and parameters in the mappings
• Created post-session and pre-session shell scripts and email-notifications.
• Involved in Performance Tuning of Targets, Sources, Mappings and Sessions.
• Created Unix Shell Scripts to control the execution of Workflow.
• Scheduled and monitored automated weekly jobs.
• Assisted in Unit and System Testing of developed mappings.

Environment: Informatica Power Center 10.x/9.x, Informatica Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager, Power Exchange, Windows NT, Mainframes, Control-M, TOAD, Oracle 18c, Business Objects, Tableau.

Confidential

Data warehouse Developer

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL process.
• Extensively Designed, Developed, Tested complex Informatica mappings, Mapplets and Reusable Transformations to load data from various sources.
• Design the Informatica ETL architecture that transfers data from different heterogeneous source systems to the Targets according to the business rules.
• Involved in Performance Tuning of Targets, Sources, Mappings and Sessions.
• Extensively Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Created workflow design document, mapping design document, Integration test plan document, Unit test plan document etc.
• Modeled the Data Warehousing Data marts using Star Schema, Built Dimension Tables and Fact Tables.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Used the update strategy to effectively migrate data from source to target.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created, Configured and Scheduled the Sessions and Batches for different mappings using workflow Manager and Unix Scripts.
• Integrated various sources into the Staging area in Data warehouse.
• Used Power Connect to extract data from other systems.
• Created necessary Repositories to handle the Metadata in the ETL process.
• Created the Source and Target Definitions in Informatica Power Center Designer.

Environment: Informatica Power Center 9.5 (Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle 9i, Business Objects, Unix Scripting, PL/SQL, Autosys, MS Visio, Microsoft office, Erwin Data Modeler