SUMMARY

• Overall 8 Years of experience in Information Technology wif 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 the 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 wif 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 the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables and Normalization/De-normalization strategies.
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
• Optimizing the SQL to improve the 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 wif the Data modelers, Product managers and Business users to understand the 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 wif experience in coordinating various client meetings, seminars, presentations and group discussions.
• Highly motivated and result oriented professional wif 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 wif Business Analysts, Data architects and Source application developers to develop a data model.
• Preparation of the application design documents based on the 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 the Data warehouse and used Erwin 4.0 to design the 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 the data components based on business standards and architecture using IDQ.
• Data Governance techniques for improving data quality, protecting sensitive data, promoting the 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 the 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 the existing applications at the 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 the 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 the pmcmd functionality to start and stop sessions.
• Used Data warehouse Admin Console (DAC) for Scheduling the 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 tan 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 the data is loading into target, which was extracted from different source systems according to the user requirements.
• Utilized Quality Center (Defect Tracking Tool) for communication wif the 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 the production environment on a day to day basis.
• Worked closely wif OBIEE reporting team to halp 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 wif Business System Analysts to understand the requirements and functionality.
• Involved in requirement gathering and analysis for the 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 the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Normalizer, Aggregator, Update strategy & stored procedure transformations.
• Worked wif 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 tan loaded the 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 the 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 the 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 the session and error logs for troubleshooting Data mappings and sessions.
• Worked wif performance issues of Informatica mappings and tuned ETL mappings for better performance using various techniques and strategies.
• Provided production support and involved wif root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.
• Coordinated wif the 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 the ETL Design Documents and Technical Specifications Documents as per the 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 the 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 the PL/SQL Packages, Stored Procedures, Functions to accomplish the business rules and tuning the SQL queries.
• Designed and developed the sessions for the relevant mappings for Informatica jobs and organized as sequential or concurrent.
• Extraction, transformation and loading were performed using Informatica PowerCenter to build the data warehouse.
• Used Teradata as a Source and a Target for few mappings. Worked wif Teradata loaders wifin Workflow manager to configure FastLoad and MultiLoad sessions.
• Automated the Informatica jobs using UNIX shell scripting.
• Used ER studio for version control.
• Performed Unit, System and Regression testing of the mappings. Involved in writing the test cases and also assisted the users in performing UAT.
• Implemented Slowly Changing dimension tables (SCD TYPE 2) for accessing the full history of accounts and transaction information.
• Implemented performance tuning logic on targets, sources, mappings, sessions to optimize the load and query performance.
• Developed schedules to automate the 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 the specifications provided by the clients.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin 3.5 to design the business process, grain, dimensions and measured facts.
• Created number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic and to load the data incrementally.
• Used Informatica tool to extract the data from the 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 the Informatica Mapping Designer.
• Created Mapplets to reuse the 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 the target database.
• Improved Performance by tuning SQL Queries, tuning mappings, sessions, and system levels.
• Testing the data and data integrity among various sources and targets.
• Associated wif Production support team in various performances related issues.
• Monitored and Improved query Performance by adding Indexes, Hints and analyzing the tables.
• Project support during System testing (Fixing of Issues, Coding Change Request’s if any)
• Code Review for the 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 the ETL jobs using Informatica 5.1.
• Designed ETL process using Informatica Designer to load the 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 the update processes andInformatica sessions and batches.
• DevelopedShell scriptsto setup runtime environment, and to run stored procedures, packages to populate the 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 the Quality procedures related to the 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