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 wif various versions of Informatica Powercenter 9x/8x - Client and Server tools.
• Expertise in tuning teh performance of mappings and sessions in Informatica and determining teh 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 wif sql server, oracle and able to handle teh Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.
• Experience includes thorough domain noledge of Insurance & Reinsure, Pharmacy claims systems, Telecom Industry.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities wif 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 teh PL/SQL code and map teh data accordingly.
• Load teh data to staging tables from teh 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 teh mappings and data load.
• Schedule teh workflows using Control-m BMC.
• Unit test and Debug teh designed mappings.
• Write Unix scripts to trigger teh workflows.
• Regular activity includes Developement, business users request support, regular status update meetings.

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Interacted wif business community and gatheird requirements based on changing needs. Incorporated identified factors into Informatica mappings to build teh DataMart.
• Developed a standard ETL framework to enable teh reusability of similar logic across teh 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 teh 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 theirby 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 wif data base DBA’s and Informatica administrators, creating remedy ticket, handling all teh singoff’s for teh production, updating all changes wif new versions using START team, creating test cases using Quality Center.
• Written SQL Queries, Triggers, PL/SQL Procedures to apply and maintain teh Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out teh bottlenecks and improved teh 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 teh source and target database schemas, and teh Mapping Designer to map teh sources to teh 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 wif code review process.
• Interaction wif Business Users and Data Modelers to come up wif ETL strategy for teh business requirement.
• Developing Mapping Inventory to distribute teh load among teh developer.
• Develop Mapping Specification and in corporate teh 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 wif ETA) requests from business analyst (BA) database related changes from DBA, which halped business to do Impact analysis.
• Implemented Slowly Change Dimension Type I & II to capture history and created process flow chat for insert/update using TEMPeffective end date.
• Documented Handling Error process come up wif 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 wif 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 teh purpose of Data Warehouse (including transformations, mapplets, mappings, sessions, and batches) so as to facilitate teh personnel to understand teh process and in corporate teh 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 wif 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) wif 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 teh 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 teh failed mappings and fixed them.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Modified teh mappings according to teh new changes and implemented teh 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 teh execution of jobs in pre and post sessions to modify parameter files, prepare data sources.
• Identified teh issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Created and used reusable mapplets and worklets to reduce teh 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