SUMMARY

• Over 7 years of experience in Data Warehousing/Integration using ETL Tool Informatica PowerCenter 9.x/8.x/7.x across the business areas such as Pharmaceutical, Healthcare and Finance.
• Involved in full Life Cycle Development including System Analysis, Design, Data Modeling, Implementation and Support of various applications in Data Warehousing, and OLAP applications.
• Extensive experience in using Informatica PowerCenter 9.x/8.x/7.x and 6.x to carry out the Extraction, Transformation and Loading process as well as Administering in creating domains, repositories and folder.
• Have clear understanding of Data Warehousing and BI concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Data Modeler with strong Conceptual, Logical Data Modeling skills and experience in requirements gathering, source to target mapping, writing functional specifications, queries.
• Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data staging for operational sources using ETL and data mining features for data warehouses.
• Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Expertise in OLAP/OLTP System Study, Analysis and ER Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi dimensional modeling
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Good understanding of relational database management systems like Oracle, Teradata, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Actively involved in Performance Tuning and have working knowledge on Java/J2ee and claims.
• Experience in implementing update strategies and incremental loads
• Usage of Informatica mapping variables/parameters and session variables strong in UNIX Shell scripting and Perl Scripting. Scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Control - M and Autosys.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Expert in Oracle 11g/10g, IBM DB2 8.1, Sybase, SQL Server 2008/2005/2008 , SQL, PL/SQL Stored procedures, functions, and exception handling using Toad.
• Responsible for interacting with business partners to identify information needs and business requirements for Reports
• Extensive database experience and highly skilled in SQL Server, Oracle, DB2, Sybase, XML Files, Flat Files, MS Access.
• Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.01/8.6.1/7.1.3/6.2

Database: Oracle (7i/8i/9i/10g/11g), IBM DB2 8.1, SQL Server 7.0/2000, Teradata, Sybase

Reporting Tools: SQR, Crystal Reports

Operating Systems: Windows NT/2000/XP, HP-UNIX, Linux

Web Technologies: HTML, JavaScript.

Languages: SQL, PL/SQL, Visual Basic 6.0, C, C++, Java, UNIX Shell Scripting, Perl Scripting

Scheduling Tools: Control-M, CRON tab and Autosys.

Other Tools: Ultra Edit, Toad, Benthic

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

ETL Informatica Developer

Responsibilities:

• Interacted with the Business Users in gathering and analyzing the Business requirements.
• Identified Sources tables and Targets tables and Designing, Development and Testing of ETL Mappings according to Business Rules using various Informatica Transformations.
• Worked on Designing, Development and Testing of Workflows and Worklets according to Business Process Flow.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Extracted the data from various Flat files and Loaded in Datawarehouse Environment and written UNIX Shell scripts to move the files across the Servers.
• Developed UNIX and Perl scripts to automate different tasks involved as part of loading process and scheduling.
• Responsible for maintain and run the workflows and wrote SQL queries to validate the Data as part of Quality assurance.
• Implementeddaily and weekly audit processfor theClaimssubject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Designed the ETL processes using Informatica to load data from Sybase, Oracle, Flat Files, XML Files and Excel files to target Oracle Data Warehouse.
• Developed ETL Mappings to populate SCD Dimension tables.
• Involved in Performance Tuning of ETL Mappings and Sessions.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Extracted data from flat files and oracle database, applied business logic to load them in the central Oracle database.
• Performance tuning, Maintenance and enhancements of ETL programs and scripts.
• Written Unix Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.

Environment: ETL Informatica (PowerCenter 8.6.1,PowerConnect for SAP R/3), Sybase, Oracle 10g, SQL, SQL*Plus, PL/SQL, Perl Script, Unix Shell Scripts (Korn), Windows XP, TOAD 8, ERwin 4, Control-M.

Confidential, Madison, WI

ETL Developer

Responsibilities:

• Gathered business requirements from business users and prepared functional specifications for various interfaces and Data Migrations.
• Developed ETL jobs to load data into XML files from Oracle database.
• Developed various mapping to migrate the data from ADMIN/LIMS to Darwin.
• Developed various interfaces like Darwin to Smart lab bi-directional interface, ADMIN/LIMS to Smart Lab bi-directional interface, MDI interface etc.
• Used Integration Manager to load data from XML files into Darwin system.
• Extensively worked on developing and modification of ETL Mappings using various Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Router transformations in Informatica Designer
• Extensively worked on creating Workflows for various Interfaces and Data Migrations
• Developed UNIX shell scripts to execute interfaces and data migration mappings.
• Scheduled workflows using UNIX command tasks to automate the entire process of fetching the source file from a different path and ftp it onto the server.
• Involved in creation of target tables in Oracle and Informatica mappings and workflows and executing them through UNIX Shell Scripts.
• Worked with heterogeneous sources from various channels like Sybase, Oracle, Flat files.
• Developed FTP scripts to move files across different servers, XML files and Excel files to target Oracle Data Warehouse.
• Loading the OLTP data into the Warehouse OLAP and built the Re-usable
• Created various UNIX Shell Scripts for scheduling, data cleansing and loading process
• Used pmcmd command in the UNIX shell scripts.
• Involved in Testing of Interfaces and Data Migrations.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.

Environment: ETL Informatica Power Center 9.0.1, Integration Manager, Sybase, Oracle11g, SQL,PL/SQL, Unix Shell Scripts(Korn),Windows XP, TOAD 8.5,MQ series,ClearCase Explorer.

Confidential, Morgantown, WV

Informatica Developer

Responsibilities:

• Data sources /input files are provided by external vendors like NDC, AMA, IMS·
• Worked on the designing of the Central customer database and the decision support system for the ETL and UNIX process.
• Worked on informatica workflow manager to organize sessions, scripts and commands.
• Worked on Extraction, Transformation and Loading of the data Using Informatica Power Center.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Created many common components of UNIX and Perl Scripts.
• Worked on connected as well as unconnected Transformations.
• Worked on normalizer transformation to normalize the demoralized sources
• Extensively worked in the informatica performance tuning
• Worked on column level data validation rules on the source data before the data enters the records by record stage of formatting and standardization.
• Worked on Unix Scripts for the informatica and Unix integration level
• Worked intensively on informatica, UNIX and oracle integration part
• Designed and developed various mappings, sessions and workflows to extract data from flat files, Oracle sources and load to Oracle and flat files.
• Extensively used SQL, PL/SQL for testing the Customer Central database and the Decision support system process.

Environment: Oracle 9i, SQL, PL/SQL, Informatica PowerCenter 7.1.3, Windows XP/2000/2003, Sybase, Perl Script, Unix Shell Scripting.

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Involved in conversion of Business Specifications to Functional Specifications for ETL Jobs
• Extensively worked on developing ETL Mappings using various Transformations like Unconnected Lookup, Aggregator, Router, Expression and Joiner.
• Extensively worked on creating and scheduling Workflows.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Extracted data from SQL server Source Systems and loaded into Oracle Target tables.
• Designed ETL process flow for entire DWH application and developed data mapping spread sheets to define transformation rules for each stage of ETL process.
• Performed Debugging of mappings and error rectification as necessary.
• Wrote SQL, PL/SQL and Stored Procedures for implementing business rules.
• Involved in performance tuning of mappings.
• Created Entity Relationship Diagrams using Erwin 4.0.
• Interacting with the users and making changes to the Business reports and Informatica mappings according to the Business requirements.

Environment: Informatica Power Center 6.2, Oracle 9i/8i, PL/SQL, UNIX Shell Scripting, Sybase SQL*Loader, MS SQL Server 2000, Windows XP/2000/2003, MS Access 2000, Windows NT 4.0

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Extensively used Power Center to design multiple mappings with embedded business logic.
• Extensively worked with Informatica Transformations like Sequence generator, Expression, Lookup, Aggregate, Update Strategy, Joiner and Source qualifier transformations in Informatica Designer.
• Developed various mapping and tuning using Oracle/PL SQL and SQL*Plus in the ETL process
• Interacted with the users and making changes to Informatica mappings according to the Business requirements.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Developed PL/SQL scripts for the data cleaning and loading the data from source system to the staging area
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Involved in using the Stored Procedures, Functions and Triggers at Data Base level and imported them in Informatica for ETL.
• Created complex mappings and mapplets and Worked on different tasks like sessions, events raise, event wait, decision, e-mail, and command.

Environment: Informatica Power Center 6.2, PL/SQL, Oracle 9i/8i, DB2 7.0, HP-UX 10.20, Windows NT 4.0, Windows XP/2000

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center 6.2 - Source Analyzer, Data warehouse designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Responsible for design, development and maintenance of Data Marts including Sales, Policy, Customer Reporting and Claims leveraging Informatica Power Center ETL tool, Oracle, DB2 and PL/SQL.
• Responsible for developing, Testing, support and maintenance for the ETL processes using Informatica Power Center.
• Responsible for development of robust and reliable solutions requiring low maintenance, thorough testing of solutions.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Used Informatica Power center workflow manager to create sessions, workflows and Worklets to run with the logic embedded in the mappings.
• Used the Informatica Server Manager to embed sessions with pre- and post-session shell scripts. Also, wrapped session PMCMD commands in shell scripts for batch processing using Autosys Scheduler.
• Developed BTEQ, MLOAD scripts to load data to Teradata Data mart.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts.
• Used crontab to schedule jobs in the production environment.
• Unit tested and tuned SQLs and ETL Code for better performance.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Developed Complex Teradata SQL in BTEQ scripts to transform the data in Teradata staging tables before loading into EDW.
• Developed BTEQ and Fast Export scripts to extract data to files from warehouse for downstream applications.
• Created Stored Procedures to transform the data. Worked extensively on SQL, PL/SQL for various needs of the transformations.
• Actively involved in building the system test environment and migrated mappings from Development to System Test environment and executed code in QA environment.
• Created packages in Harvest to migrate code across multiple environments through a standard transmittal process.
• Involved in conducting a POC (proof of concept) on SAS integration with Teradata.
• Participated in Review of Test Plan, Test Cases and Test Scripts prepared by system integration testing team.
• Monitored the performance and identified performance bottlenecks in ETL code.

Environment: Informatica Power Center 6.2, Oracle 9i, DB2, Erwin 4.0, Unix Shell Scripting, Teradata V2R5, Crontab, MS PowerPoint, Business Objects 6.0/6.5, SAS, TOAD 7.5, SQL, PL/SQL, Win NT 4.0