SUMMARY

• 8 years of IT experience and 6+ years in Data Warehousing, which includes requirement analysis, Gap analysis, Source Systems Analysis along with design, development, testing, data modeling, ETL jobs, Shell scripting, Query optimization, Performance tuning, full cycles of SDLC, Data Cleansing and Production support monitoring.
• Aspiring Professional with proven record in Planning, Executing, Controlling and Designing implementations in projects life - cycle using Water-fall and Agile methodologies.
• Over 3 years of experience as a Senior ETL Consultant, working with multiple teams and participating in status meetings.
• Strong subject and technical matter expert at inception, elaboration, construction and transition stages of various successful data warehouse and data migration implementations complying with industry best practices.
• Successful implementation of Health Care, Manufacturing and financial Data Warehouses, OLTP and Operational Data Store systems in wide variety of businesses.
• Extensive hands-on expertise using Informatica 9.x/8.x/7.x
• 5 years of experience in job monitoring with scheduling tools and scripting.
• Strong SAP experience in retrieving the data using ABAP extract and loading data using IDOC and BAPI’s.
• Involved in coordinating development activities with onsite and off shore developers.
• Extensively involved in writing scripts to Extract, Transform and Load raw data (XML, EDI, Flat files, IDOC’s, DB) into tables as part of Data Warehousing development using Power Center Tool.
• Worked extensively on Query optimization & Performance tuning for maximum throughput, and benchmarking
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in using Informatica Power Center to create and schedule workflows and expertise in Autosys and Control-M for scheduling.
• Strong technical development and design experience with systems integration and interface development
• Involved with developers and application support staff in testing and troubleshooting applications.
• Ability to solve complex technical problems and work under time constraints.
• Highly skilled, self-motivated team player, excellent communication and interpersonal skills with results oriented dedication towards goals.
• Involved in on call rotation schedule supporting 24/7 production applications.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x /7.x (PowerMart & PowerCenter)

Languages: PL/SQL, Shell scripting, C, Cobol, JCL

Databases: Oracle 11g/10g/9i, DB2, SQL Server 2008 R2/2005, Teradata 13.10, Mainframes

Tools: and Utilities: SharePoint, LSMW, Erwin, SQL Assistant, Teradata Manager, Teradata Administrator, BTEQ, TOAD, Quality center expert, ITSM Tools (ServiceNow, Remedy), File Manager, Change man, SPUFI, FMIMS, SOAPUI (UI).

Operating Systems: Z’ OS, Windows 2000/XP/NT, UNIX, Linux

Scheduling Tools: Autosys, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Concord, New Hampshire

Sr. ETL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, testing and implementation of project Hub ODS.
• Involved in the meetings with business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the ETL loading
• Work with multiple teams and Subject Matter Experts (SMEs) performing development activities across all phases of the project development lifecycle and participated in GAP analysis.
• Provided in-depth technical consultation to ensure development of efficient application systems by utilizing established methodologies and best practices
• Followed Agile Deployment methodology starting from the User Stories reviews, planning, development and testing of the objects.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Developed Informatica SCD type-I and SCD type 2c, mappings and tuned them for better performance.
• Extensively used almost all of the transformations Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected & Unconnected Lookup transformation, Sequence Generator etc.
• Coordinated deployments that include Informatica deployments as well as Unix Shell Scripts, Database DDL, DML Scripts.
• Extensively wrote user SQL coding for overriding generated SQL query in Source Qualifier.
• Used Power Center (Designer, Workflow Manager,Monitor and Administrator) at variety of stages. Designed templates and used them for coding jobs for loading dimensions, details, facts and summaries. ETL naming standards were strictly followed.
• Automated scripts to enable Job status information.
• Used designer debugger along with session log to monitor data flow and fix related bugs.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of the project with the workflows and their dependencies.
• Created and scheduled Interface jobs to feed data into Dashboard applications using Autosys
• Involved in Unit testing of Mappings, Workflows and debugging mappings for failed sessions.
• Involved in end-to-end Integration testing and issues/defects resolution and coordination with off shore team
• Used ITSM tool ServiceNow for troubleshooting user issues and service requests.

Environment: Informatica Power Center 9.1, Oracle 9i, Oracle 11g, UNIX, Windows XP, Citrix, ServiceNow,Autosys, DB2.

Confidential, Milwaukee, WI

Sr. ETL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, testing and implementation.
• Responsible for Functional specs signoffs for OTC and STP objects and Involved in source to target mapping documents.
• Coordinated with Master Data team and Legacy data team in creating design standards and technical specifications for powercenter jobs.
• Responsible for conducting daily scrum calls with different data leads about integration testing of all the objects.
• Design Jobs for Order to Cash (OTC) and STP Schedule to Produce (STP).
• Responsibilities include migration of jobs for multiple process areas across different projects.
• Involved in troubleshooting failed jobs, fixing bugs, performance tuning and enhancements.
• Used Power Center (Designer, Workflow Manager, Monitor and Administrator) to develop business compliant mappings.
• Extensively used IDOC and BAPI for loading data directly into SAP.
• Used background processing in SAP for faster processing of data.
• Involved in unit testing and validating the data on target SAP system and Familiar with the SAP table structures and T-codes.
• Used the SAP T-codes to load/test and check the data in the SAP tables.
• Created job sequences to control networks of jobs and handle the load dependency.
• Used Autosys to run, monitor and schedule the jobs.
• Involved in Unit Testing and developing Test Cases for various complex scenarios of input data.
• Provided On-call support 24x7 when required.

Environment: Informatica 8.5/8.1, SAP ECC 6.0, Autosys, Oracle 9i.Oracle 11g, UNIX, Windows XP, Citrix, Remedy HP Quality Center, Microsoft Access.

Confidential, Woodland Hills, CA

ETL Developer

Responsibilities:

• Designed the ETL Framework that included Data modeling for Staging Database
• Written single reusable Code with Table driven/Parameterization for migration of 8 source systems
• Involved in the meetings with business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the ETL loading
• Worked with data modelers in preparing logical and physical data models.
• Integrated 3rd Party Business Rule engine to validate the Staging Provider Information
• Understanding functional specification, data model requirement and ETL specification document and preparing HLDs and LLD’s of, to be implemented requirement.
• Perform mock conversions to load data in test environments
• Involved in Integration testing and UAT Support.
• Analyzed existing system and prepared and presented Impact Analysis.
• Prepared technical design documents based on BRD and SRS in a standard template explaining entity relationships and its components.
• Created Shell scripts for Automating of Worklets, batch processes and Session schedule using pmcmd.
• Good hands on over Teradata fastload and bteq commands.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow and if deposited correctly in Target Tables.
• Scheduled the jobs through UNIX shell scripts using CTL-M.
• Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.
• On-call support to enable 24x7 coverage.
• Used Remedy to log and track user issues.
• Extensively worked with QA team to resolve the issues
• Worked extensively with the release team to plan and execute the releases.
• Responsible for migrating projects between multiple environments (Dev, QA, UAT and Prod).

Environment: Informatica Power Center 8.0/8.1, TeraData, DB2, MS SQL Server, UNIX, MVS Mainframes, COBOL, JCL, TOAD, Remedy and Control-M.

Confidential, Woodland Hills, CA

Informatica Developer

Responsibilities:

• Extensively used Powercenter designer to develop various parallel jobs to extract, cleanse, transform into Enterprise Data Warehouse Tables.
• Modified the existing COBOL, JCL to include new functionality as per the business rules.
• Translation of project requirements into project objectives and tasks; manages project resources and reports on project progress throughout its lifecycle.
• Experience in data Extraction, Transformation and Loading (ETL) processes. Worked extensively on data extraction, cleansing and data integration, and loading from different data sources using Power Center 7.5. (Data Designer, WFManager, Monitor, and Administrator).
• Responsible for the Data Cleansing of Source using LTRIM,RTRIM along with all mathematical and logical functions of the Expression Transformation
• Extensively worked with both Connected and Un-Connected Lookups using all types of Look up Caches to improve the performance of the lookup transformations
• Replicate operational tables into staging tables, Transform and load data into enterprise data warehouse tables using Informatica from their legacy systems and load the data into targets by ETL process through scheduling the workflows.
• Involved in developing the SQLs, which are used to apply all business rules on the data before load into the target tables.
• Implemented optimization techniques for performance tuning and wrote necessary Pre & Post session shell scripts.
• Developed and executed effective test plans to ensure quality and stability and provide direction to contractors performing tasks.
• Worked with reusable objects like Re-Usable Transformation and Mapplets
• Handled various loads like Daily Loads, Weekly Loads, Monthly Loads and Quarterly Loads using Incremental Loading Technique
• Worked on ERWIN Tool for data modeling.
• Worked extensively with the release team to plan and execute the releases
• Involved in production support

Environment: Informatica Power Center 8.6/7.1, UNIX, MVS Mainframes, COBOL, JCL,Windows, Oracle 10g, SQL, Shell Scripts. Erwin, Control-M.

Confidential

Intern/ Trainee/ Informatica and Mainframe Developer

Responsibilities:

• Involved in Requirements gathering, Logical design model & physical design model meetings to understand the data flow, frequency of data loads into EDW and create Mapping documents and Visio diagrams.
• Captured data from a variety of sources including DB2,VSAM files, MS SQL Server, Sybase, Oracle, and flat files and other formats
• Designed & developed numerous Jobs in all the projects which involved complex transformations, performance enhancements, validations, referential integrity, surrogate keys, SCD’s on mainframe and distributed environments.
• Written Shell Scripts to automate files, schedule batch jobs and developed various SQL queries on the UNIX OS and ran batch files on the UNIX using Cron utility.
• Learning the parallel processing, shared nothing architecture using Teradata.
• Involved in Database Migration/upgrade & Testing from existing legacy systems to single db.
• Written Various SQL procedures for insert, update and bulk load into EDW.
• Involved in documenting changes and potential Production Issues, Workflow Analysis and Standards.
• Prepared unit test, integration test, and performance test plan documents. Performed unit test, integration test, and performance test as per the approved test plan, and documented test results.
• Creation of Triggers, Stored Procedures, Tables, Indexes, Rules, Defaults etc.
• Analysis of Issues in Production Runs and fixes.

Environment: Power Center 8.x/7.x, DB2, Oracle 9i, Teradata 13.10, MS SQL Server 2000, Windows 2000, Autosys, Control-M