SUMMARY

• Over 8+ years of IT experience in Analysis, Design, Development, Implementation and Support of Relational Database (OLTP), Data Warehousing Systems (OLAP) and Data Marts in Pharmacy, Insurance, Financial, Healthcare, Logistics and Steel sectors.
• Extensive experience in using Informatica PowerCenter 9.1/8.6.1/8.5/8.1/7. x/6.x/5.x., Power Exchange, Power Mart 5.x/4.x, Informatica Data Analyzer (Reporting Tool).
• Extensively used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server tools - Informatica Server, Repository Server.
• Experience in designing/developing complex mapping using transformations Connected and Unconnected Lookup, Source Qualifier, Joiner, Expression, Filter, Sorter, Aggregator, Router, Update Strategy, Rank, Stored Procedure, Sequence generator, Normalizer, HTTP transformation and Re-usable transformations
• Extensive experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load and PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Strong experience using Erwin, Multi Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), and handling slowly Changing Dimensions.
• Proficient in the integration of various data sources involving multiple relational databases like Oracle11g/10g/9i, MS SQL Server, DB2, COBOL files and Flat Files ( fixed width, delimited ), into the staging area of ODS, Data Warehouse or Data Mart.
• Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Specialized in Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception Handling using TOAD, SQL*PLUS and PL/SQL.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments and experience in error handling and problem fixing in Informatica.
• Excellent understanding of Software Development Life Cycle (SDLC).
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using Auto Sys scheduler and Involved in migration/conversion of ETL processes from development to production environment.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to testing, testing to QA and from QA to production.
• Strong technical background, and posses excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/8.5/8.1/7. x/6.xSource Analyzer, Mapping Designer, Workflow MonitorWorkflow Manager, Data Cleansing, Data QualityRepository, Metadata, Data Mart, OLAP, OLTPWeb services, Power Mart 5.1/4.7.2, informatica Data

Data modeling tools: Erwin 7.x/ 4.2/3.x, Microsoft Visio

RDBMS: Oracle 11g/10g/9i/8i, MSSQL ServerIBM-DB2, MS Access

Web Tools: HTML, DHTML, XML, CSS, Java Script

Other tools & Utilities: SQL* Plus, TOAD, Auto Sys

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

Scripting languages: UNIX Shell Scripting, Korn Shell Scripting

Operating systems: Windows 2000/2003/NT/XP, UNIX (Sun Solaris, AIX)LINUX

PROFESSIONAL EXPERIENCE

Confidential, Groton, CT

Sr. Informatica Developer

Responsibilities:

• Involved Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Extensively used Informatica PowerCenter 9.1.0 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Extracted data from multiple sources like Oracle RDBMS, XML files and flat files to load data into data warehouse built on Oracle.
• Created and Configured Workflows, Worklets and Sessions to load the data to target warehouse tables using Informatica Workflow Manager
• Developed Informatica SCD type-I, Type-II mappings.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing, Performance tuning of Oracle PL/SQL Scripts
• Hands on Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Designed UNIX Shell Scripts to automate Pre-Session and Post-Session Processes.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Strong in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like UC4 Automation tool.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to testing, testing to QA and from QA to production.

Environment: Informatica PowerCenter 9.1.0 (Designer, Workflow manager, Workflow monitor), Oracle 11g, XML Files, Flat Files, TOAD 9.7.2, PL/SQL, ERWIN 7.3, SQL* PLUS, Windows NT, UNIX Shell scripting, UC4 Automation Tool.

Confidential, Pittsburgh, PA

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed mapplets and worklets for reusability.
• Implemented weekly error tracking and correction process using Informatica.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD type-I, Type-II and Type III mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process
• Extensively used Informatica Data Analyzer to create reports relative to corporate business planning modules such are: Demand Manager, Demand Fulfillment, Master Planner and Material Allocator.
• Extensive hands on Schema design, XML import/export, Scheduling, System management using Data Analyzer.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power Center 9.1(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor), Informatica Power Analyzer 9.1, ABPP Demand manager, ABPP Demand Fulfillment, ABPP factory Planner, ABPP Material Allocator, Oracle 11g/10g, Flat Files, TOAD 10.6 for Oracle, PL/SQL, ERWIN 7.3 Data Modeling tool, Windows 2000, UNIX PERL scripting, AutoSys, Informatica Scheduler.

Confidential, Philadelphia, PA

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 8.6.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Created source-to-target mappings, storage capacity planning, developing ETL processes using the Oracle Data Integrator 10g.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, xml, JAVA, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed Informatica SCD type-I and Type-II mappings.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process
• Created UNIX Shell scripts and called as pre session and post session commands.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power Center 8.6.1/8.1.1 , Oracle 10g, SSIS, Netezza 4.6, TOAD 9.7.2 for Oracle, Flat Files, PL/SQL, IDE, ERWIN 7.3 Data Modeling tool, Windows 2000, UNIX PERL scripting, AutoSys.

Confidential, Bridgewater, NJ

Sr. Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse
• Identified the flow of information, analyzing the existing systems, evaluating alternatives and choosing the “most appropriate” alternative
• Developed mappings to extract data from Oracle, Flat files and load into Data Warehouse using the Mapping Designer
• 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
• Understood the Business point of view to implement coding using Informatica Power Center designer
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica Power Center designer and workflow manager. Ver 8.6
• Migrate historical data, which is one time and built migration process for ongoing data loads using Informatica power center designer
• 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 Data Warehouse
• Involved in versioning the whole process and retiring the old records using the built-in DD UPDATE, DD DELETE and DD INSERT
• Performed queries and generated reports from various information sources such as claims, eligibility, providers and memberships
• Developed standards and procedures for transformation of data as it moves from source systems to the Data Warehouse
• Extensively used “pmcmd” commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Written Triggers, Stored Procedures for Complex mappings, Used Debugger in troubleshooting the existing mappings
• By using Autosys, created the job which runs a UNIX script. The script in turn runs the "pmcmd" command to run a workflow
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manage
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking
• Worked as a part of a production support team and provided 24 x 7 supports

Environment: Informatica Power center 8.6/8.1, Oracle 10g, PL/SQL, Windows XP, SQL Server, TOAD, UNIX, Autosys

Confidential, Columbus, OH

Sr. Informatica Developer

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Created ER diagram of the data model using Erwin data modeler to transform business rules into logical model.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Worked with Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Lookup, Stored Procedure, Joiner, Update strategy, Expression and Aggregator transformations to pipeline data to Data Warehouse/Data Marts
• Handled slowly changing dimensions of Type1/Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse
• Extensively worked with Informatica Designer. Designed and developed Informatica mappings for data loads and data cleansing.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions in a detail design document.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based on commit interval.
• Created Sessions and Batches to run Workflows.
• Responsible for writing unit test cases and performing the unit test.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Worked with the QA team in order to determine the data validation and performed the data validating at the source and the target database level.
• Involved in Production support and trained the other developers to handle issues.

Environment: Informatica PowerCenter 8.6.1/8.1.1 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Power Exchange, Oracle 11g, MS SQL Server 2000, TOAD 9.7.2, Flat Files, Web Services, PL/SQL, ERWIN 7.3, SQL* PLUS, Windows NT, UNIX Shell scripting, Auto Sys 3.0

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Interacted closely with Business Users in the Requirements gathering phase.
• Worked with Data Architect in the logical and physical design of the data model.
• Documented the design by creating High-level design document and a Low-level design document.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier transformations.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Developed the sessions and workflows in the workflow Manager
• Created worklets when a group of sessions need to run multiple times
• Implemented Error Rejection process to load bad/invalid records into a separate reject table
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Responsible for UNIX shell scripts for backup and monitoring database
• Assisted DBA in writing Stored Procedures, triggers and functions in Oracle.
• Played a key role in all the testing phases and responsible for production support as well.

Environment: Informatica Power Center 8.1.1(Designer, Repository Manager, Workflow Manager), Oracle 10g, UNIX Shell Scripting, XML, SQL Server 2000, windows XP, Sun Solaris 9, Visio, TOAD 9.1, SQL*Plus.

Confidential, Dublin, OH

Sr. Informatica Developer

Responsibilities:

• Extracted data from multiple sources reformatted the form and made it available for analysis purposes using Informatica (ETL).
• Creating Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool, which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Designed a Sales data mart and have built ETL processes to refresh the underlying star schema and associated materialized views using Oracle warehouse builder.
• Created specification documentation for each ETL process based on client requirements.
• Created necessary Repositories to handle the metadata in the ETL process.
• Created complex mappings using Unconnected, Lookup, and Aggregate transformations for populating target table in efficient manner.
• Created Dynamic lookup transformation to increase the session performance
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Implemented various loading techniques like Slowly Changing Dimensions and Incremental Loading.
• Configured the folder structures and developed mapping to create and maintain Parameter Files used by the sessions and workflows.
• Extensively worked in the performance tuning of ETL mapping and session.
• Developed SQL, PL/SQL, stored procedures, triggers, cursors for implementing business rules and transformations.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to testing, testing to QA and from QA to production.

Environment: Informatica Power Center 7.1.3(Designer, Workflow Monitor, Workflow Manager, Repository Manager), Flat files, Erwin 4.0, Oracle 10g, Windows NT,MS SQL Server 2000, PL/SQL,UNIX, TOAD 8.6

Confidential

Informatica Developer

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Worked with Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Used Source Qualifier, Aggregator, Lookup, Expression, Stored Procedure Transformations.
• Extensively worked with Informatica Designer. Designed and developed Informatica mappings for data loads and data cleansing.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions in a detail design document.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based on commit interval.
• Created Sessions and Batches to run Workflows.
• Responsible for writing unit test cases and performing the unit test.
• Worked with the QA team in order to determine the data validation and performed the data validating at the source and the target database level.
• Involved in Production support and trained the other developers to handle issues
• Documented the ETL process and also issues encountered during UAT and production support for ease of future maintenance.

Environment: Informatica PowerCenter 5.1, Designer, Workflow Manager, Workflow Monitor, Oracle 9i, Flat files, Erwin, PL/SQL, SQL*Plus, Windows NT, Toad 7.6