SUMMARY

• Eight plus (8+) years of IT experiences with (6+) years in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions, IDQ and prebuilt function uses.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
• Hand on knowledge and exposure in Sales ForceCRM Solution, Data Warehousing and Informatica data integration in clouding environment with SalesForceOn Demand CRM solution. Sales force data migration and integration processes in web-portal in clouding concepts.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Talend, SSIS, Ab-Initio.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008/2005 , DB2 v8.1, Teradata 14, PgAdmin 8

Data Modeling tools: Erwin, MS Visio

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/ , Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3 , Micro strategy, Hyperion.

Languages: SQL, PL/SQL, UNIX, Shell scripts, C++

Scheduling Tools: Autosys, Control-M, TWS

Testing Tools: QTP, WinRunner, LoadRunner, HP ILM Q.Center, Test Director, Clear test, Clear case.

PROFESSIONAL EXPERIENCE

Confidential, Montery Park, CA

Informatica ETL Developer

Responsibilities:

• Logical and Physical data modeling was done using CA Erwin for data warehouse database in STAR SCHEMA. CA package management for Risk management control.
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 11g,PgAdmin,SQL server and JCL (Mainframe flat files) by incorporating global financial business rules using different objects and functions that infa tool supports. Using TOAD, SQL developer 4, PostgreSQL 8.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to business rules. IDQ and Address doctor.
• Used various transformations like Source Qualifier, Joiner, Lookup, Aggregator, sql, Router, Filter, Expression and Update Strategy,SQL,XML perser.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement
• Etl Automation using AutoSys v11. Scripting, Scheduling, Conditioning, Monitoring and Validating against business need and ETL transport timeline aspect.

Environment: Informatica Power Center 9.5 - (Designer, Repository Manager, Workflow Manager), Oracle 11g, Oracle 10g, PgAdmin,TOAD, SQL Developer, AQT, UNIX Shell Scripts

Confidential, St. Louis, MO

Informatica ETL Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Aggregator, sql, Router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Use of most recent TD 14.1 utility in temporal data set and capturing most recent data .
• Use IDR tool to map source and target, schedule migration of Oracle 11g log data.
• Use DVO to validate captured data in ELT automation in data validation process
• Use of most recent version of Autosys as ETL scheduler.
• Interact, Collaboration and emphasize new approaches as common goal
• Interact and manage team members
• MKS version control
• Working with Admin for real-time ETL solution in Unix architecture, Data modeler using Erwin.

Environment: Unix, Windows 7, Informatica 9.5.1+, TD 14.1 oracle 11g, Toad, IBM MKS, Sharepoint and CA Erwin.

Confidential, Denver, Colorado

ETL Application Developer

Responsibilities:

• Participate in all phases of SDLC including business requirements collection, analysis, sizing, design, development, testing, deployment and production support
• Agile Scrum/Sprint environment.
• Design, develop, debug, test and promote ETL code into various environments from DEV through to PROD using informatica 9.1
• Perform unit, integration and System testing of new application.
• Add and Create ETL admin guide and other smoke testing documents as part of development.
• Develop and contribute to Business Requirements Document along with users.
• Work with onsite/offshore consultants in writing detailed Functional and Technical Design documents.
• Production support.

Environment: Informatica Power Center 9.1x - (Designer, Repository Manager, Workflow Manager), Talend 5.3, SSIS 2012, SAP ERP, BO, Crystal reporting, Oracle 11g, TOAD, SQL Developer, UNIX Shell Scripts

Confidential, Des Moines, IA

ETL Application Developer

Responsibilities:

• Participate in all phases of SDLC including business requirements collection, analysis, sizing, design, development, testing, deployment and production support
• Hands on ETL Development (Talend) with support from onsite consultants on daily basis in Agile Scrum/Sprint environment.
• Data modeling, profiling, cleansing using Talend pallet components
• Define and create data model, tables, views, queries etc. to support business requirements. Create and support Web Services that integrate ETL Jobs with BPM application.
• Design, develop, debug, test and promote ETL code into various environments from DEV through to PROD.
• Develop and contribute to Business Requirements Document along with users.
• Work with onsite/offshore consultants in writing detailed Functional and Technical Design documents.
• Perform unit, integration and System testing of new application.
• Ability to work under tight deadlines to deliver high quality software for a new application from scratch
• Hands-on development/maintenance experience in Talend and data integration in Oracle, SQL and SAP R3.
• Creating various Reports using BO/Webi/BEX in SAP cubes.
• Job scheduling from talend platform as well as use of IBM Tivoli.

Environment: Informatica Power Center 9.0/8.6 - (Designer, Repository Manager, Workflow Manager), Talend 5.3, SSIS 2012, SAP ERP, BO, Crystal reporting, Oracle 11g, TOAD, SQL Developer, AQT, UNIX Shell Scripts

Confidential, Des Moines, IA

ETL Application Developer

Responsibilities:

• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven development and Scrum.
• Part of the Informatica upgrade project which was from version 8.6 to 9.1
• Testing and Redesigning the existing Informatica mapping/workflows as a part of upgrade.
• Scheduling the Informatica and other related processes using MAESTRO schedulers.
• Modifying the UNIX scripts as a part of Upgrade and making sure they point to the correct directories.
• Modifying table structure according to the new/changing requirement and also interacting with business users and DBA in order to be on the same page.
• Working closely with the testers in order to help with overall-testing completion of the committed Iteration capacity(points). Duties including Production support.

Environment: Informatica Power Center 9.0/8.6 - (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 10g, TOAD, SQL Developer, AQT, UNIX Shell Scripts

Confidential, Houston, TX

ETL Developer

Responsibilities:

• Part of ETL advance team activities member, worked closely with lead and PM for project completion process and cost management scenarios.
• Delegate Data conversion process from legacy system to Oracle 11g
• High level Global Data design implementation in web-portal.
• MDM Item classifications in Version control, validating and promoting.
• MDM supplier & customer data cleansing.
• Oracle techno-functional implementation in-group environment.
• Exercise in BI reporting tools and Web-portals and web-services.
• Using smart templates for data pre-validation in conversion process.
• Legacy data cleansing and keeping specific data format. Logistic help in setup, mentoring and helping team members as well as offshore developers in SME. Data monitoring during Data conversion process. Informatica IDQ and data validation governs DVO.
• Creating and observing data validation reports and updating mapping, coding and scheduling as needed. Used IDQ, prebuilt functions and excel templates. Agile environment.

Confidential, St.Louis, MO

ETL/Informatica/Application Dev

Responsibilities:

• Worked on Informatica 9.1 Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor. Scheduling tool using TWS.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Used Informatica IDQ for specific data format and quality to standerize data.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other HIPAA RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Used Power Exchange to source copybook definition and then to row test the data from data files etc.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets & reusable transformations to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• A Unit testing, code reviewing, moving in UAT and PROD.
• Agile and scrum environment.

Confidential, Stamford, CT

ETL Consultant

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Analyzed, identified, fixed bad data and Imported data fromSalesForce - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,SQL Developer

Confidential, Pittsburgh, PA

ETL/Informatica Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica PowerCenter 8.6, Oracle 11g, SQLServer2008, IBM ISeries (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

Confidential, Secaucus, NJ

ETL Developer

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements by using S2T Documents.
• Involved in the preparation of High level design documents and Low level design documents.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Followed Ralph Kimball approach (Bottom Up Data warehouse Methodology in which individual data marts like Shipment Data Mart, Job order Cost Mart, Net Contribution Mart, Detention & Demurrage Mart are provides the views into organizational data and later combined into Management Information System (MIS)) .
• Prepared Level 2 Update plan to assign work to team members. This plan is very helpful to know the status of each task.
• Involved in monitoring the workflows and in optimizing the load times.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Involved in writing procedures, functions in PL/SQL.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Rational Clear case is used to Controlling versions of all files & Folders (Check-out, Check-in)
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Defect Tracking and reports are done by Rational Clear Quest.

Environment: Informatica Power Center 8.6/8.1, SQL*Loader, IDOC, RFC, HP Quality Center, Oracle9i/10g, AUTOSYS, Rational Clear case, Rational Clear Quest, Windows XP, TOAD, UNIX.

Confidential, Chicago, IL

ETL Consultant

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL process.
• Extracted data from Oracle as one of the source databases.
• Involved in JAD sessions for the requirements gathering and understanding.
• Involved in the ETL design and its documentation.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ER-STUDIO.
• Followed Star Schema to design dimension and fact tables.
• Experienced in handling slowly changing dimensions.
• Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
• Responsible for the development, implementation and support of the databases.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Developed reusable Mapplets and Transformations.
• Used data integrator tool to support batch and for real time integration and worked on staging and integration layer.
• Optimized the performance of the mappings by various tests on sources, targets and transformations
• Design, develop and Informaica mappings and workflows; Identify and Remove Bottlenecks in order to improve the performance of mappings and workflows
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Scheduled the tasks using Autosys.
• Loaded the flat files data using Informatica to the staging area.
• Created SHELL SCRIPTS for generic use.
• Created high level design documents, technical specifications, coding, unit testing and resolved the defects using Quality Center 10.
• Developed unit/assembly test cases and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.

Environment: Windows NT, Informatica Powercenter 8.6, UNIX, Oracle 10g, Oracle Data Integrator, SQL, PL/SQL,SQL Developer, ER-win, Oracle Designer, MS VISIO, Autosys, Korn Shell, Quality Center 10.

Confidential, NJ

Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows 2000