SUMMARY

• 8+ years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Expertise in designing and developing mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• Expertise in data warehousing, ETL architecture.
• Experience in working with various versions of Informatica Power center 9x/8x - Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat files, DB2 Mainframes.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts.
• Experience in Data migration.
• Knowledge in design and development cycle of Business Intelligence reports using BI tools Business Objects, Cognos.
• Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.
• Experience includes thorough domain knowledge of Insurance & Reinsure, Pharmacy claims systems, Telecom Industry.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

Data warehousing: Informatica PowerCenter 9x/ PowerExchange for DB2, Metadata Reporter Data Profiling, Data cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling

BI Tools: Business Objects XIR2/6.0/5.1,Cognos 8

Databases: SQL Server 2005/7.0, Oracle10g, 9i, Sybase, TeraData 6,My SQL, MS-Access, DB2 9.x

Languages: C, C++, SIEBEL, XML, SQL, PL/SQL,UNIX Shell Scripting

Operating System: HP-UX11,Windows XP Professional

Other Tools: Autosys, Control M, Informatica work scheduler.

DB Tools: SQL*Plus, SQL*Loader, Export/Import, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Informatica Consultant

Responsibilities:

• Understand the PL/SQL code and map the data accordingly.
• Load the data to staging tables from the flatfiles, XML, EBCDIC files.
• Load data to fact tables and summary tables.
• Experience in IDQ 9.1 and following standards, guidelines and best practices using
• Informatica Power Center.
• Practice of common error handling procedures.
• Performance tuning of the mappings and data load.
• Schedule the workflows using Control-m BMC.
• Unit test and Debug the designed mappings.
• Write UNIX scripts to trigger the workflows.
• Regular activity includes Developement, business users request support, regular status update meetings.

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files and load into DataMart using the PowerCenter.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• 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 data to DataMart.
• Developed Slowly Changing Dimension for Type 1 SCD,Type 2 SCD,Type 3 SCD.
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Written procedures, Queries to retrieve data from DWH and implemented in DM.
• Data extraction and data Transfer from and to SQL Server Database using utilities / tools like BCP, and BULK INSERT.
• Responsible for submitting DBA requests, following up with data base DBA’s and Informatica administrators, creating remedy ticket, handling all the singoff’s for the production, updating all changes with new versions using START team, creating test cases using Quality Center.
• Written SQL Queries, Triggers, PL/SQL Procedures to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Involved in generating reports from Data Mart using Cognos.
• Defects were tracked, reviewed and analysed.
• 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.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.

Environment: Informatica PowerCenter 9.5, SQL Server 2006,Oracle 10g, Teradata 6, SQL, PL/SQL,IBM AIX, Cognos, Erwin, STAR team, Remedy, Maestro job scheduler, Mercury Quality Center

Confidential, MO

ETL Developer

Responsibilities:

• Designed and developed Maps, Sessions, Workflows, and Database Connections and created test cases and involved with code review process.
• Interaction with Business Users and Data Modelers to come up with ETL strategy for the business requirement.
• Developing Mapping Inventory to distribute the load among the developer.
• Develop Mapping Specification and in corporate the changes.
• Discover, design and Create re-useable codes - transformations and mapplets - mplt ERROR MSG, Transformation to generate surrogate keys.
• Created shared folders using Repository manager and created short-cuts for re-usable transformation, targets and sources in Dev folders.
• Maintained Change Request Process document and captured mapping related (logic with ETA) requests from business analyst (BA) database related changes from DBA, which helped business to do Impact analysis.
• Implemented Slowly Change Dimension Type I & II to capture history and created process flow chat for insert/update using effective end date.
• Documented Handling Error process come up with negative dimensions -1,-2 and -3 for natural keys lookup, matching CDC data capture flag and Dynamic Lookup and error out if any mismatch.
• Performed Data Profiling and created User Defined Functions (UDF) /process to handle null fields with default values for string, date and number.
• Imported / modified dashboards, reports, alerts and indicators in Data Analyzer.
• Created shell scripts - execute workflow, copy source file and archives source files.
• Use of parameter file for all mapping, mapplet and database connection.
• Involved in performance tuning, load strategies / identity dependencies, re-satiability (minimize cleaning process

Confidential

ETL Developer

Responsibilities:

• Designed technical layout considering Standardization, Reusability, and Scope to improve if need be.
• Documented the purpose of Data Warehouse (including transformations, mapplets, mappings, sessions, and batches) so as to facilitate the personnel to understand the process and in corporate the changes as when necessary.
• Developed complex mappings to extract source data from heterogeneous databases Tera Data, SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and pl/sql code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT (User Acceptance Testing) with user community
• Developed K-shell scripts to run from Informatica pre-session, post session commands. Set up on Success and on Failure emails to send reports to the team.

Environment: Informatica PowerCenter 7.1, Oracle9i, SQL Server 2006, Erwin, XML, TOAD, HP - Unix 11.11, Dendrite Webforce, Cognos Report Net.

Confidential

ETL Developer

Responsibilities:

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Created new mappings according to business rules to extract data from different sources, transform and load target databases.
• Debugged the failed mappings and fixed them.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources.
• Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Created and used reusable mapplets and worklets to reduce the redundancy.
• Developed robust Informatica mappings and fine-tuned them to process lot of input records.

Environment: Informatica power center, Oracle9i, SQL, PL/SQL, MS Vision, Ms-Access