PROFESSIONAL SUMMARY

• 7+ years of extensive IT Experience in Design, Development, Implementation, Maintenance and leading teams for a wide range of applications in various domains like Insurance, Financial and Telecom Sectors.
• Over 6+ years of ETL and data integration experience in developing ETL mappings and scripts in Informatica PowerCenter 9.x/8.x using Designer, Repository Manager, and Workflow Manager.
• Expertise in implementing complex Business rules by creating robust mappings, Mapplets, reusable transformations using transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Normalizer, Update Strategy etc.
• Experience in Database using Oracle, MS SQL Server, Sybase, DB2, and Teradata.
• Experience with Informatica Power Exchange 9.x/8.x for change data capture (CDC) and mainframe data.
• Attended Informatica Data Quality 9.0.1(Analyst and Developer Tool) training provided by Informatica Education services.
• Expertise in OLTP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling
• Experience with industry standard methodologies like Waterfall, Agile, and Scrum methodology within the Software Development Life Cycle.
• Extensively worked with Informatica Data Quality for data analysis, cleansing, and data matching.
• Excellent track record of working end-to-end implementation and integration projects to successful completion under tight deadlines.
• Expert in implementing Type 1 and Type 2 Slowly Changing Dimensions as per the requirements.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, Targets, various Transformations in the mappings and sessions.
• Strong in database programming using PL/SQL and SQL with creation of packages, stored procedures, functions, triggers, materialized views, cursors and performance tuning of SQL.
• Practical knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Surrogate keys, Normalization/Denormalization, FACT and Dimensional Tables.
• Experience in developing UNIX Shell and Perl Scripts for automation of ETL process.
• Experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
• Experience in Production support and in Onsite-offshore coordination.

Technical Skills:

ETL Tools: Informatica (Power Center 9.1/8.x/7.x), Informatica 9.1.0 Analyst/Developer, Informatica Power Exchange 8.1/9.1.0

RDBMS: SQL, PL/SQL, Oracle

Scripting Languages: PERL and Shell

Case Tools: ERWIN and Microsoft Visio

Databases: MS SQL Server, Oracle 8i/9i/10g/11g, MYSQL, Sybase, DB2

Job Schedule: Autosys, Cybermation

Development Tools: SQL Navigator, TOAD and SQL *Loader

Reporting Tools: Cognos, Hyperion (Interactive Reporting)

Other Tools: Trillium

Professional Experience:

Confidential, Cleveland, OH

Sr. Informatica Developer/Designer

Environment: Informatica PowerCenter 9.1/8.6 (Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), Oracle 11g/10g, Toad Oracle Designer, Business Object 6.x, SQL Server, PL/SQL, UNIX Shell Scripting.

Responsibilities:

• Worked with business analysts and DBA for requirements gathering, business analysis and to design the data marts
• Worked with Data Modelers in the creation of the ETL source to target mapping document with the transformation logic
• Analyzed the current system for the core properties
• Analyzed the impact of changes on the existing systems
• Created mappings/sessions/workflows for moving the data from different sources into Oracle database
• Used Informatica (Power Center 9.1) tool as ETL tool for constantly moving the data from different sources into staging area
• Worked with heterogeneous sources from various channels like Oracle, DB2, SQL Server and Flat Files
• Created Unix scripts to process several flat file feeds
• Developed scripts using PMCMD command to run the Workflows, Sessions from UNIX environment which are called in Autosys jobs
• Extensively worked on various Transformations like Joiner, Lookups (connected and unconnected), Update strategy, Sequence generators, Routers, Aggregators, Union in the development
• Worked on creating Mapplets and reusable transformations where necessary
• Developed the sessions and workflows in the workflow Manager
• Extensively worked on performance tuning of ETL mappings and sessions
• Used TOAD to run SQL queries and to validate the data.
• Troubleshoot and tune SQL using EXPLAIN PLAN
• Worked on the deployment of the jobs to Production
• Worked closely with the testing team and the user team to resolve bugs in the UAT
• Analyzed session log files if the session failed and fixed the Issues that come out of UAT
• Involved in reviewing the Test Cases written by the peers
• Provided production support of the processes

Confidential, Cleveland, OH

Sr. Informatica Developer

Environment: Informatica PowerCenter 8.6.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), Power Mart, Power Connect, Power Analyzer, Oracle 11g/10g/9i, PL/SQL, Toad, XML, SQL*Loader, Teradata 13.0, SQL Server, Erwin 7.2, Unix,Win XP.

Responsibilities:

• Worked with business analysts and DBA for requirements gathering, business analysis and to design the data marts
• Involved in customizing data models for Data Warehouse supporting data from multiple sources on real time
• Involved inLogical and Physical datamodels that capture current/future state data elements and data flows usingErwin
• Used advanced techniques of Informatica to load data fromMS SQL Server, XML files, Flat filesinto the targetOracledatabase
• Designed reusable transformations and mapplets
• Implemented changes in Slowly Changing Dimension tables
• Extensively worked with transformationsLookup, Update Strategy, Expression, Filter, Stored Procedures, Routerand others
• Designed and developed source to stage mappings/sessions/workflows
• Designed and developed stage to ODS mappings/sessions/workflows
• Designed and developed ODS to data mart mappings/sessions/workflows
• Imported external data (flat files)into Oracle tables using SQL*Loader
• Coordinated with IT department and external auditors during SOX IT testing
• Used debugger to test thedata flowbetweenSource and Targetand to fix the invalid Mappings
• Worked on different tasks in Workflows likesessions,events raise,event wait,decision-mail,command,worklets,Assignment,Timerandschedulingof the workflow
• Used Altova XML-Spy to create tables based on the XSD
• Worked on Custom views in creating the views in the XML wizard based on the Global elements
• Developed UNIX shell scripts and PL/SQL procedures
• Extensively worked on performance tuning of ETL mappings and sessions
• Used TOAD to run SQL queries and to validate the data
• Documented all mappings, created effective test cases by performing unit testing and Integration testing to ensure the successful execution of data loading process
• Analyzed session log files if the session failed and resolved the errors
• Provided technical assistance by responding to inquiries regarding errors or questions with programs/interface
• Tested the data and data integrity among sources and targets using Unit Testing
• Associated with Production support team in various performances related issues
• Created number of standard reports and queries based on the existing classes/objects

Senior Software Engineer

Confidential

Environment: Informatica Power Center 8.6.1, DB2, Windows Xp.

Environment: Oracle 8i, PL/SQL, SQL, TOAD, UNIX, Windows 2000/03/NT

Responsibilities:

• Designed and executed a new scalable, real time and batch data sourcing and distribution system for products and pricing data to various internal groups.
• Set up ETL systems to generate reports on various securities like equity, mortgages, funds providing reference, pricing and ratings data from multiple vendors.
• Worked on a reusable mapplet which has been used across the project for generic data domain validation and exception loading.
• Used SQL loader to quickly load the source data from flat files to Oracle.
• Worked on Lookup, Aggregator, Rank, Normalizer, Union, Filter, Router, Expression, Joiner, Update Strategy, Stored procedure, Sequence Generator transformations.
• Used Connected, Unconnected lookup transformations with Update Strategy transformation for SCD tables.
• Removed bottlenecks and minimized look up data from tens of look-up transformations on current and existing mappings to improve performance.
• Debugged code by creating new debug sessions and running existing sessions.
• Performance tuning of SQL queries using explain plan
• Created partitioned tables for better performance and history management.
• Unit tested mappings and documented the results.
• Provided End-user support for every release cycle to get the systems stable and familiar to support teams.
• Involved in all phases of Software Development like Code Development, Unit Testing, Integration Testing, Code Promotion, and Preparation of Checklists at each phase, Maintaining Issue Logger System etc.

Confidential, Auburn Hills, MI

ETL/ Informatica Developer

Environment: Informatica 6.x/7.x (PowerMart/ PowerCenter), PowerConnect, WorkFlow Designer, Powercenter Designer, Repository Manager, Cognos 8.0, XML, DB2, Oracle 9i, PL/SQL, Teradata, Mainframes, SQL*Plus, TOAD, SQL Server 2000, Windows NT 4.0, UNIX, Erwin

Responsibilities:

• Interacted with business users in the analysis and development phase and was involved in requirement gathering, prepared various documents like Technical design documents, Integration test plan, unit test plan and resolved business related issues
• Worked closely with System Analyst to identify various tables and the layout of data, understanding the complex business rules, identify appropriate sources for Data Warehouse, document business needs and implementing the data transformation methodology
• Extracted data from variety of sources like mainframe tables, flat files, SQLServer and loaded to the Data Warehouse
• Used Type2 mapping to update slowly changing dimension table to keep full history
• Developed reusable mappings, mapplets, sessions and worklets
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation
• Worked on databases implementing complex table joins, aliases, views, aggregate conditions to implement business logic
• Created test cases for Unit Test, System Integration Test, check the data quality issues, removing defects and to ensure the successful execution of data loading process
• Responsible for monitoring all the sessions that are scheduled, running completed and failed
• Involved in debugging the Mappings that failed and fixing
• Performed performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache

Confidential

SQL Developer

Environment: SQL server, Oracle 9i, PL/SQL, DB2, UNIX Scripting (Ksh)

Responsibilities:

• Designed, developed, tested, tuned, and implemented relational databases and procedural database code.
• Provided database development support to development team.
• Produced ad-hoc queries and developed reports to support business needs.
• Performed unit testing of developed solutions.
• Supported database administration and participated in special projects related to database administration.
• Developed and maintained SQL scripts in Microsoft SQL Server.
• Managed quality assurance, tuning, and testing at the unit level.
• Planned, organized, and controlled technical projects.
• Identified and specified complex business requirements and processes.
• Provided technical guidance to development staff in all phases of the development and implementation process.
• Coordinated the activities of the section with the client area and other IT sections.