SUMMARY

• A dynamic professional with 6years of IT experience in System Analysis, Business Analysis, DW Development, Testing, Implementation and Integration of various Data Warehouse Systems and Business Intelligence Applications on Client - Server, SOA and Mainframe environments.
• DWH: Have strong experience in Design and Implementation of Data warehouse Methodologies like Ralph Kimball and Inmon in Implementation of ODS, EDW and Metadata Repositories.
• Informatica: 5+ years of Data Warehousing experience using Informatica Power Center 9.1/8.6.1/8.1./5.1 , OLAP, OLTP, Autosys, Strong experience in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, and legacy system files.
• Databases: Extensively worked on Oracle 10g/9i, DB2 8.0/7.0, MS SQL Server 2005, Teradata V13, PostgresSQL, HPNeoview.
• Experienced in integrating data from various Heterogeneous sources (Relational database, SIEBEL, Flat Files, XML Files, COBOL Files, Excel) into Data Warehouse and Data Mart.
• Worked on operating systems UNIX, Linuxand Windows. And have experience in InformaticaandBusiness Objects Administrationand strong experience in installing in windows, Unix environment.
• Unix: Have very good experience in Writing Bash Shell Scripts.Strong testing experience on UNIX based applications.
• Production Support - Done extensive 24x7 production support and issue resolutions.
• Offshore Team Co-ordination - Onsite-offshore co-ordination experience and well versed with off-shore teams ensuring timely and quality results.
• Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to provide accurate software solutions.
• Excellent in Documentation, End-User Training, Knowledge Transfer and Production Support.

TECHNICAL SKILLS

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

Languages: PL/SQL, Shell scripting, C, C++

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),DAC.

Operating Systems: Z’ OS, Windows 2008 server/XP, 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 Hub ODS.
• Developed ETL for Data Extraction,Data Mapping and Data Conversion using Informatica Power Center 9.5.1.
• 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 AgileDeployment 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.
• 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.
• 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 applicationsusingAutosys
• 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.5, Oracle 9i, Oracle 11g, UNIX, Windows XP, Citrix, ServiceNow,Autosys,DB2.

Confidential, WoodlandHills, 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 documentand 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 SRSin 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 DAC.
• 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 Center8.6,TeraData, DB2, MS SQL Server, UNIX, MVS Mainframes

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.
• 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 PowerCenter 8.6/7.1, UNIX, MVS Mainframes, COBOL, JCL,Windows,Oracle10g, 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 sourcesincludingDB2,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