SUMMARY

• Overall 8 Years of experience in Information Technology with a strong background in Data Warehousing and ETL Process. Have expertise in Analysis, Design, Development, Implementation and Testing of Client/Server and Data warehousing applications.
• Expertise in Design and Implementation of Data Warehousing applications, mainly transformation processes using Informatica Power Center 9.x/ 8.x / 7.x.
• Experience in all teh phases of Project Development life cycle in Data Warehousing projects.
• Expertise in Informatica PowerCenter, Mapping, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, Star Schema Modeling, OLTP, OLAP, Data Reports.
• Proficiency in using Informatica PowerCenter tool to design data conversions from wide variety of data sources like Oracle, SQL Server, MS Access, Teradata, Flat files, and XML files.
• Involved in Dimensional and Relational Physical & logical data modeling using Erwin. ER diagrams with modeling tools like Erwin 4.0 & Power Designer 16.
• Experience in Dimensional Data Modeling using Data modeling, Star Schema/Snowflake modeling, Fact & Dimensions tables, Physical & logical data modeling.
• Hands - on experience in Star and Snowflake schema design in relational, dimensional and multidimensional modeling and De-normalization techniques and thorough understanding of Kimball and Inmon methodologies.
• Involved in performance tuning of teh production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables and Normalization/De-normalization strategies.
• Hands on experience in writing, testing and implementation of teh triggers, Procedures, functions at Database level using PL/SQL.
• Optimizing teh SQL to improve teh performances.
• Experience in Data Profiling using Informatica Data Quality.
• Experience in Code review, Query Optimization, Unit Test Plans, Risk Analysis.
• Experience in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like DAC, Control-M.
• Regular interaction with teh Data modelers, Product managers and Business users to understand teh Business requirements.
• Responsibilities include requirement gathering and Documentation like Business System Design Documents, Technical Design Documents (HLD and LLD), SDLC workbook, Test Plans Preparation & Execution.
• Experience in Health Insurance and Financial Services domains.
• Solid in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions.
• Highly motivated and result oriented professional with strong technical, interpersonal, communication and presentation skills.

TECHNICAL SKILLS

Operating Systems: Windows XP/Vista/7/8, MS-Dos, UNIX 6.5, Solaris 11/10

Tools: & Utilities Informatica Power Center 9x/8x/7x/6x/5x, (Power Mart/Power Center) 6.x, Informatica Power Connect, HP Quality Center, Test Director, SQL*Loader, TOAD, SQL *Plus, Microsoft Office, ER Studio, Informatica Data Quality 9x

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Teradata V2R5/V2R6, Microsoft SQL Server 2*

Languages: C, C++, PL/SQL programming

Web Related: HTML, Java Script, XML

Data Modeling Tools: ERWIN 4.0/3.5, Power Designer 16

Scheduling Tools: Control-M 8, Autosys r11, Data warehouse Admin Console (DAC) 11.1,10.3.1.4

Reporting Tools: Business Objects XI R 2/6.5/6.1/5.1, Cognos 10.2.1, SSRS 2012 (SQL Reporting Services), OBIEE 11g/10g

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. ETL Consultant

Responsibilities:

• Communicating with Business Analysts, Data architects and Source application developers to develop a data model.
• Preparation of teh application design documents based on teh given functionality.
• Creating logical and physical data models and creating Entity Relationship (ER) diagrams using Erwin based on requirements.
• Involved in Dimensional modeling (Star Schema) of teh Data warehouse and used Erwin 4.0 to design teh business process, grain, dimensions and measured facts.
• Data extraction from various data sources like Oracle, Mainframes.
• Identifying and defining source data by using Data Profiling that cleanses teh data components based on business standards and architecture using IDQ.
• Data Governance techniques for improving data quality, protecting sensitive data, promoting teh efficient sharing of information and providing trusted business-critical data.
• Design and development of complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Made use of Workflow Manager for creating, validating, testing and running teh sequential and concurrent sessions and scheduling them to run at specified time.
• Use of Workflow Manager for database connections me.e., to read data from different sources and write it to target databases.
• Optimization of teh existing applications at teh mapping level, session level and database level for a better performance.
• Developed PL/SQL procedures for Pre-session and Post-session data loading.
• Real time Data Replication using Informatica Data Replication Console.
• Involved in identifying and removing bottlenecks in order to improve teh performance of Mappings and Workflows.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk me/O and Sorts.
• Worked on UNIX shell scripts. Developed UNIX shell scripts to run teh pmcmd functionality to start and stop sessions.
• Used Data warehouse Admin Console (DAC) for Scheduling teh jobs.
• Involved in migration of mappings and sessions from development repository to production repository.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Member of On call team for providing support for daily and weekly batch loads.
• Involved in Unit testing and User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
• Utilized Quality Center (Defect Tracking Tool) for communication with teh production personnel, developers and team members.
• Involved, Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.
• Investigated and fixed problems encountered in teh production environment on a day to day basis.
• Worked closely with OBIEE reporting team to help generate various reports.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 11g, TOAD, Informatica Data Quality 9.1.0, SQL Server 2008/2005, SQL, PL/SQL, DB2, Teradata V2r6, Erwin 4.0, Windows XP, UNIX Scripting, DAC 11.1, Quality Center, OBIEE 11g, Siebel 8.1, UNIX 6.5

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Participating in meetings with Business System Analysts to understand teh requirements and functionality.
• Involved in requirement gathering and analysis for teh data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Involved in creating Entity Relationship (ER) diagrams using Erwin 4.0 based on requirements.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse/Workflow Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Responsible for mapping and transforming existing feeds into teh new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Normalizer, Aggregator, Update strategy & stored procedure transformations.
• Worked with newer Informatica transformations like Java transformation, Transaction Control.
• Developed Java Transformation to create Unique ID instead of Sequence generator
• Provided administrative functions like creating repositories, backing up repositories, setting up users, assigning permissions and setting up folders in Repository manager.
• Extensively used Informatica 8.5.1 to load data from source tables me.e. DB2 and then loaded teh data into target table me.e., flat files,DB2
• Using replication moved data across heterogeneous data sources.
• Involved in source code management using Version Control option in Informatica.
• Used Workflow manager for Creating, Validating, Testing and running teh sequential and concurrent Batches and Sessions.
• Migrate Informatica objects and Database objects to Integration Environment and schedule using theControl-M.
• Created reusable transformations and Mapplets and used them to reduce teh development time and complexity of mappings and better maintenance
• Created Test Data and executed SQL queriesin SQL Server to validate and test Oracle data.
• Unit and Integration testing TEMPhas been extensively done at development level.
• Analyzed teh session and error logs for troubleshooting Data mappings and sessions.
• Worked with performance issues of Informatica mappings and tuned ETL mappings for better performance using various techniques and strategies.
• Provided production support and involved with root cause analysis, bug fixing and promptly updating teh business users on day-to-day production issues.
• Coordinated with teh off-shore teams and mentored junior developers.
• Developed various Reports for Financial Department and SFOs for better Analysis using Business Objects.
• Extensive involvement in code reviews, Knowledge Sharing sessions and Client interaction for application enhancements and project status meetings.

Environment: InformaticaPower Center 8.5.1/8.6.1, Oracle 10g/9i, Erwin 4.0, PL/SQL, UNIX Shell scripting, Control-M 8, SQL Loader*, SQL server 2005, Business Objects XIR2, Solaris 11

Confidential, AR

ETL Informatica Developer

Responsibilities:

• Business Analysis and Requirements Gathering.
• Preparation of teh ETL Design Documents and Technical Specifications Documents as per teh Business Specifications.
• Involved in creating Entity Relationship (ER) diagrams using Power Designer 16 based on requirements.
• Transformation of business requirements into Informatica mappings/workflows.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Responsible for mapping and transforming existing feeds into teh new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformations.
• Created Mapplets for reusable business rules to eliminate coding redundancy.
• Involved in writing teh PL/SQL Packages, Stored Procedures, Functions to accomplish teh business rules and tuning teh SQL queries.
• Designed and developed teh sessions for teh relevant mappings for Informatica jobs and organized as sequential or concurrent.
• Extraction, transformation and loading were performed using Informatica PowerCenter to build teh data warehouse.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure FastLoad and MultiLoad sessions.
• Automated teh Informatica jobs using UNIX shell scripting.
• Used ER studio for version control.
• Performed Unit, System and Regression testing of teh mappings. Involved in writing teh test cases and also assisted teh users in performing UAT.
• Implemented Slowly Changing dimension tables (SCD TYPE 2) for accessing teh full history of accounts and transaction information.
• Implemented performance tuning logic on targets, sources, mappings, sessions to optimize teh load and query performance.
• Developed schedules to automate teh update processes andInformatica sessions and batches using DAC.
• Identified and created various classes and objects for report development.
• Ensuring good quality of work being delivered to Client.

Environment: Informatica Power Center/Power mart 8.1, PL/SQL, Oracle 9i, Windows XP, Teradata v2r5, Power Designer 16, UNIX, AIX 6.4.1,DAC 10.3.1.4, MS SQL Server 2000/2005, Business Objects 6.5/6.1, ER Studio

Confidential, MN

Informatica Consultant

Responsibilities:

• Requirement gathering and analysis of teh specifications provided by teh clients.
• Involved in Dimensional modeling (Star Schema) of teh Data warehouse and used Erwin 3.5 to design teh business process, grain, dimensions and measured facts.
• Created number of complex Informatica mappings, mapplets, and reusable transformations to implement teh business logic and to load teh data incrementally.
• Used Informatica tool to extract teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Using Mapping Designer developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier, and data flow management into multiple targets using Router transformations.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union to develop robust mappings using teh Informatica Mapping Designer.
• Created Mapplets to reuse teh transformation in several mappings.
• Workflow manager tool is used for session management, database connection management and scheduling of jobs to be run.
• Monitored workflows and sessions for weekly and Monthly extracts from various data sources across all platforms to teh target database.
• Improved Performance by tuning SQL Queries, tuning mappings, sessions, and system levels.
• Testing teh data and data integrity among various sources and targets.
• Associated with Production support team in various performances related issues.
• Monitored and Improved query Performance by adding Indexes, Hints and analyzing teh tables.
• Project support during System testing (Fixing of Issues, Coding Change Request’s if any)
• Code Review for teh coding standards and code optimization.

Environment: Informatica Power Center 7.1, Oracle 9i, DB2, Flat files, SQL* Loader, Erwin 3.5, TOAD, Autosys r11, Windows XP, Cognos 8, Quality Center.

Confidential

ETL Developer

Responsibilities:

• Analyze, design, construct and implement teh ETL jobs using Informatica 5.1.
• Designed ETL process using Informatica Designer to load teh data from various source databases and flat files to target data mart in Oracle.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• DevelopedMappings/Transformations/Mappletsby using Mapping Designer.
• Designed and developed complex mappings usingAggregate, expression, filter, join, Router, Lookup and Updatetransformation rules.
• Developed schedules to automate teh update processes andInformatica sessions and batches.
• DevelopedShell scriptsto setup runtime environment, and to run stored procedures, packages to populate teh data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Database management using SQL Server 2000.
• Testing - unit testing & integration testing.
• Responsible for overseeing teh Quality procedures related to teh project.

Environment: Informatica 5.1, Oracle 8i, Microsoft SQL Server 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script., Business Objects 5.1, Windows 95