SUMMARY

• Over 8 years in Data Warehouse/Data Mart Development. Experience in Design and maintenance of Pharmaceutical, Financial, Health Insurance and Manufacturing Data Warehouse applications.
• Excellent experience in data extraction, transformation and loading data using Informatica Power Center 9.5.1/9.1.1/8.6.1/8.1.1 (Designer, Workflow Manager, Workflow Monitor), and Informatica Power Exchange 8.1.1.
• Support between developers and end users, functional managers and Oracle regarding issues with database software, SQL programming, tuning, releases and development with Oracle tools like Oracle Warehouse Builder.
• Experienced in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Created Webservice definitions and developed corresponding WSDL’s for the Webservices.
• Created data maps, registration groups and amended all the DTL fields to capture the changes in the power exchange navigator.
• Actively involved in Performance Tuning, Error handling Product support on various Platforms.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in data modeling in ERwin 4.0/3.5.
• Experience in coding using SQL, SQL * plus, PL/SQL procedures/functions, triggers and exceptions. Good experience in Relational Database concepts, Entity relation diagrams.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.

TECHNICAL SKILLS

Data warehousing Tools: Informatica Power Center 9.5.1/9.1.1/8.6.1/8.1.1 , OWB 10.2, Informatica Power Exchange 8.1.1, Webservices Hub

Data Modeling: ERwin 4.0/3.5, Star and Snow schema Modeling

Operating Systems: UNIX, Sun Solaris, Linux (redhat 9.0), Windows95/98/2000/XP/NT, HP-UX

Programming Languages: C, C++, HTML, DHTML, XML, PL/SQL, Shell Scripting

Databases: Oracle 9i/10g/11g, MS SQL Server 2005/2000, DB2

Tools: TOAD, Kintana, VSS, Serena Dimensions, MQC, QTP, SharePoint, SOAP UI, Tivoli, Remedy, Starteam

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Senior DW Developer

Responsibilities:

• Worked with other ETL developers to provide the deliverables on time.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Prepared Detail design documents for the project as per the ETL standards, procedures naming conventions and code fixes.
• Developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from Oracle database.
• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Designed different types of look-up (connected/unconnected) transformations in both mapping and mapplet according to the requirement of transformation.
• Involved in designing Logical and Physical models for staging, transition of the Data.
• Analysis was done using existing transactional database schema and designing Data Model to support user need for reporting.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Written pre session and post session scripts in mappings.
• Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager. Generated completion messages and status reports using Workflow Manager/Workflow Monitor.
• Created tables using DDL’s and modified existing tables in the database based on the requirements.
• Created test cases and test scenarios and worked with users on test load analysis.
• Involved in system testing of overall processes and provided production support.
• Performance tuning of ETL Jobs and provide analysis of any outstanding issues.

Environment: Informatica 9.0.1,Cognos 10.1, Framework Manager, Transformer, Oracle 11g, UDB DB2, PL/SQL,Window 7, Unix.

Confidential, Yardley, PA

Sr. DW Developer

Responsibilities:

• Participated in all phases of system development life cycle from requirements gathering to deployment of the finished system into production followed by maintenance and knowledge transfer tasks.
• Gathered requirements by analyzing source systems and identification of business rules through regular requirements gathering sessions with business users and other support teams for various OLTP and OLAP systems.
• Used power Center Designer to design the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Extensively used STAR and SNOWFLAKE schema models in design.
• Extensively used Transformations like look up, Router, Filter, Joiner, Stored procedure, Source qualifier, Aggregator, Update strategy, Etc.
• Involved in code review sessions to bring the team’s attention to best practices and to identify areas of improvement.
• Responsible for implementing action items identified during code review sessions focused towards improving data quality and performance.
• Involved in performance tuning of sessions that work with large sets of data by tweaking block size, data cache size, sequence buffer length and target based commit intervals.
• Developed sessions and batches to move data at specific intervals and on demand using workflow manager.
• Developed PERL scripts used to cleanse the data, recreate indexes and run batch jobs.
• Used PMCMD to run workflows and CRON tab to automate their schedules.
• Participated in deployment planning and in deployment of the system to production.
• Facilitated business user smoke testing of the production system by setting up test data.
• Involved in production support duties including monitoring of nightly batches.

Environment: Informatica Power Center 9.1. Erwin 4.0, Oracle9i, SQL*PLUS, MS SQL Management studio, TOAD, DB2, UNIX, Windows

Confidential, CA

ETL Developer

Responsibilities:

• Designed and developed ETL Processes based on business rules using Informatica Power Center.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, and lookup and update strategy transformations.
• Used repository views in mappings in order to get the load status.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session.
• Developed standard and re-usable mappings and mapplets using various transformations like Stored Procedure, Expression, Aggregator, Joiner, Source Qualifier, Router, Lookup, and Filter.
• Designed and developed the workflows, validated the dependencies in between the workflows which involved various tasks like even-wait, command, session tasks.
• Developed reusable transformations and mapplets.
• Migrated Informatica Objects (Mappings, Work-flows and Sessions) from Dev/Test environment to Production environments by creating deployment groups.
• Involved in Performance Tuning of the mappings, used Informatica Debugger.
• Introduced partitioning in sessions based on data regions.

Environment: Informatica 8.6.1, Oracle 11i, PL/SQL, SQL,Flat files, XML, MS Access, Web services, Unix, Toad

Confidential, NJ

ETL Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 8.6.1.for extraction, loading and transformation (ETL) of data in the datamart.
• Designed and developed ETL Mappingsto extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using workflow monitor.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Developed and tested all themappings, sessions and workflows.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i,PL/SQL,Flat files, XML, MS Access, Web services, Unix, Toad, Business Objects.

Confidential, DC

ETL Developer

Responsibilities:

• Implemented Change Data Capture (CDC) using the pwx listener and condense jobs.
• Registered tables and amended all the DTL fields in the condense jobs.
• Performed row test to ensure all the changes are captured in the power exchange.
• Created Complex SCD type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Involved in performance or tech test to check the efficiency or performance of the code
• Created parameter files for all the workflows in both the initial/historical and incremental load.
• Loaded Data Acquisition (DA) layer with the committed transactions like Inserts, Updates, and Deletes on the source database (ODS Facets 4.5) using power exchange and power center to serve downstream applications reporting requirements.
• Used SQL transformations to run all source and target queries stored in Metric audit tables.
• Assisted in scheduling batch jobs using JCL's and shell scripts on CA-7 scheduler.
• Used Serena Dimensions for version control of ETL code, parameter files and migration of the code to different environments.
• Used PMERR tables in the power center for Error Handling.

Environment: Informatica Power Center 8.1.1, Informatica Power Exchange 8.1.1, Oracle10g, Toad, SQL Developer, UNIX, MQC, Serena Dimensions.

Confidential, MD

ETL Developer

Responsibilities:

• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Responsible for using the capabilities of PowerCenter namely list files, pmcmd, pmrep, Target override, Persistent lookup, Dynamic & Static lookup.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.
• Developed Informatica Mappings, Re-usable Transformations, and Mapplets for data load to data warehouse and database (oracle).
• Support between developers and end users, functional managers and Oracle regarding issues with database software, SQL programming, tuning, releases and development with Oracle tools like Oracle Warehouse Builder.
• Involved in Re-Design that includes dynamic creation of the logic when the new data is added to the system avoiding recoding.
• Walked through the Logical and Physical Data Models of all source systems for data quality analysis.
• Involved in XML parsing and loading XML files into the database.

Environment: Informatica Power Center 8.1, OWB 10.2, Oracle 11g/10g, ERWIN 4.0, PL/SQL developer, XML, UNIX, Windows.

Confidential, PA

Informatica Developer

Responsibilities:

• Created Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Involved in designing of star schema based data model with dimensions and facts.
• Wrote shell scripts in UNIX environment.
• Involved in writing lot of Functions, Stored Procedures in PL/SQL as per the requirements.
• Used Dashboards and created complex SCD type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Partitioned sources to improve session performance.
• Performance Tuning of Sessions and Mappings.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time and Monthly loading of Data.
• Creating Relational Connections, Migrating the Mappings from Dev to Test and Test to Production.
• Created design documents and performed Unit Testing on the Mappings.

Environment: Informatica Power Center 8.1/7.1.3, Business Objects 6.0, ERWIN 4.0, TOAD, XML, Oracle 10g/9i, UNIX, Windows.