PROFESSIONAL SUMMARY:

• Around 9 years of experience in the IT industry with extensive skill set dedicated to business and System Analysis, Data Modeling, Data warehousing on Client Server and Web-Enabled Systems, which includes over 8 years of expertise in Development and Implementation of Data Warehouse applications using ETL tool INFORMATICA.
• 9 years of IT experience with good knowledge and experience in different phases of Software Development Life Cycle SDLC including analysis, design, development, testing and production.
• Extensive experience in ETL tool Informatica.
• Experience in Data warehousing, Data Architecture Extraction, Transformation and loading ETL data from various sources into Data Warehouse and Data Marts using Informatica Power Center 9.0.1/9/8.6.0/8.1.1/7.x and Datastage 8.x/7.x.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement.
• Involved in all aspects of ETL-requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, designing various mappings, developing mappings, unit testing, integration testing, regression testing and UAT in development
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files Fixed width Delimited , XML Files, COBOL files, VSAM, IBM DB2 UDB, Excel, Oracle, Sybase, MS SQL Server and Teradata.
• Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc
• Extensively worked on Repository Manager, Workflow Manager, Workflow Monitor and Designer to develop Mappings, Mapplets, Reusable Transformations, Tasks, Workflows, Worklets to extract, transform and load data.
• Strong experience in writing PL/SQL Stored Procedures, Functions, Packages, Triggers and Performance Tuning.
• Strong Experience working on Oracle Database environment
• Worked in various Industry Sectors such as Financial, Pharma, Investment, Insurance applications.
• Experience in Implementing the Parallel Processing for increasing the performance.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling and Slowly Changing Dimensions.
• Worked on Logical and Physical Database designing using ERWIN Tool.
• Expertise in problem solving and decision making, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.

TECHNICALSKILLS:

• ETL Tools : Informatica Power Center 9.0.1/9/8.6.1/8.5/8.1.1/8.1/7.x Source Analyzer,
• Datastage 8.x/7.x, Mapping Designer, Mapplet, Transformations, Workflow Monitor,
• Workflow Manager
• Data Modeling : E-R Modeling, Dimensional Data Modeling, Star Schema Modeling, Snow Flake
• Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling, Erwin
• 9.5/7.2/4.0/3.5/3.0, Microsoft Visio
• Databases : Oracle 11g, 10g/8i/9i, MS SQL Server 2012/2008/2005/2000, MS Access
• 2000/1997, Teradata V2R5/V2R4, Salesforce Cloud, Axeda Cloud
• Languages : C, C , SQL, SQL Plus, PL/SQL, Toad.
• Environment : Windows 2003 server, Windows 95/98/NT 4.0/2000, XP, MS DOS, Sun Solaris
• 2.6/2.7,UNIX.
• Packages : MS Office MS Access, MS Excel, MS PowerPoint, MS Word .

PROFESSIONAL EXPERIENCE:

Sr ETL Developer Data Modeler

Ecolab is the global leader in water, hygiene and energy technologies and services. Around the world, businesses in the foodservice, food processing, hospitality, healthcare, industrial, and oil and gas markets choose Ecolab products and services to keep their environments clean and safe, operate efficiently and achieve sustainability goals.

SpringBoard:

The Project was aimed to build an application to remotely configure and analyze the field installed pool controllers. The controllers send the data to a cloud application named Axeda . As part of this application we have to move the data from Axeda to G360 database through IDM to support Service Detail Report and Corporate Reports. The major tasks involved in this project are Creating data models, Data movement and UI development.

Responsibilities:

• Responsible for database Development, Dataflow, Integration and Data Modeling.
• Responsible for UI development on Axeda Platform using Html, Javascript, Groovy and Jquery
• Using Erwin, develop conceptual models and create various Logical and Physical Models such as Relational and Dimensional Data Models.
• Design and develop Informatica Mappings and Sessions based on business user requirements and business rules to load data from source to targets.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Responsible for the data integration into SalesForce.com using Informatica PowerCenter and Informatica Cloud
• Responsible for the data integration Axeda cloud to Ecolab Systems using Informatica PowerCenter
• Configured and used FTP by the Informatica Server to access source files.
• Responsible to work on Agile / Scrum development methodologies
• Worked with advanced systems like Web services and Messaging Queues Active MQ
• Analyze business data requirements to produce relevant ETL architecture deliverables source analysis, source to target maps, ETL flows in a Data Warehouse environment
• Creating various forms of documentation like Data Design Documents/Conceptual Design Documents/DDL For various projects.
• Effectively explains data related concepts at both IT and business user levels.
• Tools Technologies: Informatica 9.0.1, Erwin 9.5, Power Designer, SQL Server 2012/2008, Html, JavaScript, Jquery, Goovy, Axeda, intelliJ, Salesforce, CA Workload Automation, UC4, Visio, Windows 2000/XP/7
• Allianz Life Insurance Company of North America, MN Dec 2011 Mar 2014

Sr ETL Developer

• Allianz Life Insurance Company of North America Allianz is a leading provider of retirement solutions, including fixed and variable annuities and life insurance for individuals.
• There are several Projects I have been involved in

SalesForce Integration CRM Uplift:

• The Project was aimed to sync the data between two CRM systems TeamPoint and Saleforce.
• Teampoint, the Variable Business line CRM tool is out of support and has been identified as a significant risk to the line of business and this functionality is now built on Salesforce and data should be synched in between the systems for every 15 min. The major tasks involved in this project are Records Changed Management, Failed Records Management, Job Management and Data Management.

Responsibilities:

• Involved in analyzing, defining, and documenting data requirements by interacting with the client and Salesforce team for the Salesforce objects.
• Worked on the Business Requirement documentation by identifying the business rules, basic business process flow and sub-flow for the concerned business activity flow steps.
• Developed DDD and Mapping Document to present to client for the Informatica process for the Salesforce objects.
• Worked on Offshore Onshore model, held meetings on a daily basis for coordination and planning.
• Dealt with Oracle and SQL Server databases and flat files as sources
• Created SQL stored procedures, views and Oracle Procedures and Triggers
• Created and edited custom objects and custom fields in Salesforce and checked the field level Securities.
• Enabled Bulk data load for loading into the Sales force and checked the jobs in sales force Administration setup.
• Used Pre and post sql's in session level in Informatica.
• Data validation was done using GUI TOOLS and on Salesforce.com
• Created Deployment Groups to move Informatica code into various environments.
• Developed error logging process where the rejected records were shown in ELF viewer.
• Espresso scheduler and CA workload Automation tool were used to schedule jobs on daily and hourly basis.

Print:

• The Project is involved in creating print functionality for Prospectus, RMD, Shareholder reports, Policy print,
• Statements, Confirms. Insurance Industry standard 1203 ACORD XML is used in all the work streams to generate the message.

Responsibilities:

• Worked extensively on XML transformations like XML Target, XML Generator, XML Parser.
• Extracted data from Oracle system and generated XML's into a target folder and also dropped them into Message Queue.
• Knowledge in HTML, XML, DTD, XML Schema.
• Created Views and Store Procedures in SQL Server and Oracle.
• Worked on creating Synthetic Trade Reports which help Business to know about the data staged by source system on that day.
• Extracted XML's from SQL Server and generated flatfiles, CSV and DAT files as per Vendor system requirement.
• Espresso scheduler and CA workload Automation tool were used to schedule jobs on daily and hourly basis.

Tools Technologies: Informatica Power Center 9.0.1, DB2, Business Objects, Oracle 11g, MS SQL Server 2008/2005, Erwin, PL/SQL, Windows NT/2000,Autosys,XML, Espresso, CA Workload Automation.

Sr Informatica Developer

• DTE Energy Co. is a Detroit, Michigan-based utility incorporated in 1995 providing gas and electric utility services to millions of Michigan homes and businesses, and energy-related services to businesses and industries nationwide. Michigan Consolidated Gas Co. A natural gas utility serving 1.2 million customers in Michigan.
• The project was aimed at making a data warehousing and BI Reporting system for customer and various policy plans. The Project objective is to design and develop a Single Integrated Data Warehouse for reporting the insurance data for the organization, which enables the insurance servicing Department to track the insurances and improve the overall performance.

Responsibilities:

• Used Informatica Power Center for extracting Source data and loading into target table.
• Created complex mappings using reusable Mapplets, Mapping Parameters and Mapping Variables to use globally.
• Developed mappings to extract data from various source systems and load them into Oracle targets.
• Designed and developed ETL processes using DataStage designer to load data into Oracle Database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Written SQL code to extract, transform, and load data ensuring compatibility with all tables and customer specifications.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Created workflows and worklets with parallel and sequential sessions that extract, transform, and load data to one or more targets.
• Worked with complex mappings having an average of 15 transformations.
• Performed code migrations as part of weekly/Monthly Change request releases.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Worked on various tuning issues and fine-tuned transformations to make them more efficient in terms of performance.
• Configured and used FTP by the Informatica Server to access source files.
• Extensively used TOAD for ORACLE to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions.
• Created and Scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Organized data in reports using Filters, Sorting and Ranking data with alerts.
• Involved in performance tuning and optimization of existing Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Extensively used Autosys for Scheduling the Sessions and tasks.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Involved in the preparation of documentation for ETL standards, procedures and naming conventions, wrote Shell scripts.
• Involved in data modeling Star Schemas according to the Business requirements using the Erwin 6.3.8.
• Assisted Collaborated in generation of a complete set of reports using Business Objects to target different user segments.
• Creation of different types of reports, such as Master/Detail, Cross Tab and Chart for trend analysis . Use of Prompts, filters, conditions, calculations etc.
• Precise Documentation was done for all mappings and workflows.
• Worked onsite and coordinated with off-shore resources and assisted for production stage.

Environment: Informatica Power Center 8.6, Datastage 8.0, DB2, Business Objects, Oracle 9i/10g, MS SQL Server 2008, Erwin, PL/SQL, UNIX solaris , Shell, Windows NT/2000,Autosys,XML.

Informatica Developer

• Pharmerica is a leading institutional pharmacy services providing long-time care pharmacy from industry-leading consultant pharmacist services, streamlines billing options to maintain regulatory compliance.
• The project was aimed for Design and the development of the Data Warehousing project for the improvement of drug sales and promotions for new and old facilities. This data warehouse was developed to provide reports for the portfolio managers to assist in establishing, monitoring, evaluating, developing and implementing strategies for new and existing nodes under the company.

Responsibilities:

• Attended user design sessions, studied user requirements, completed detail design analysis and wrote design specs.
• Dimensional modeling of the data warehouse to design the business process.
• Designed Logical data model and Physical conceptual data model using Erwin
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Used Pre-Session, Post-Session SQL in Informatica Mappings.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Worked with UNIX shell scripting to automate jobs.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Extensively used Autosys for Scheduling the Sessions and tasks.
• Used various tasks like even-wait, command, session tasks.
• Process design documentation of the Data Warehouse Dimensional Upgrades.
• Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports in Business objects.
• Assisted in the design of report layouts to maximize usability and business relevance.
• Conducted end user technical training on reporting tools.
• Responsible for Unit Testing of the Mappings created according to the business requirements.

Environment: Informatica Power Center 8.1.2 Power Center Repository Manager, Designer , Power Exchange, Erwin, Oracle 9i, SQL Server 2008, Sybase, Autosys, DB2 , Toad , PL/SQL, Business Objects , UNIX AIX , Windows NT

Informatica Developer

• Frontier Communications is a divided part from Verizon is one of the nation's largest rural local exchange carriers providing services like internet, digital phones and television making customers happy by providing timely services.
• The project aimed to build the integrated data warehouse from different databases and a reporting system in order to provide the solution for tracking the customer information on recent promotional plans and insurance policies opted to make the respective decision making department make progress in providing new offers to the customers and build their new strategies to make their business grow.

Responsibilities:

• Involved in gathering the Business requirements from the client and writing and maintaining technical/design documentation.
• Involved in Logical and Physical data models that capture current/future state data elements and data flow using Erwin.
• Used advanced techniques of Informatica to load data from source MS SQL Server, Flat files, DB2 into the target DW, TeraData.
• Designed and developed complex Mappings using Informatica PowerCenter Designer.
• Designed reusable transformations and Mappings Data Quality Plan Mapplets, Build Data quality Scorecards.
• Design/develop and manage power center upgrades from 7.x to V 8.x, Migrate ETL code from Informatica 7.x to V 8.x. Integrate and manage workload of Power exchange CDC.
• Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router and others.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance. Imported external data flat files into Oracle tables.
• Implemented changes in slowly changing Dimension Type 2 3 tables.
• Created and ran workflows using Workflow Manager to load the data into the Target Database. Optimized/Tuned mappings for better performance and efficiency.
• Developed mapping parameters and variables to support SQL override.
• Used debugger to test the data flow between source and target and to fix the invalid 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.
• Used session partitions, dynamic cache memory and index caches for improving performance of Informatica services/ server
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Used UNIX shell scripting and PMCMD command line for workflow automation and Created Shell scripts to execute some packages from Informatica.
• Used application development tools like TOAD Oracle to develop SQL queries and stored procedures. Oracle as backend database and Oracle CDC.
• Tested the data and data integrity among sources and targets using Unit Testing, UAT.
• Associated with Production support team in various performances related issues.
• Involved in Generating and Validating Reports using COGNOS.

Environment: Informatica PowerCenter 7.x/8.x, PowerExchange, COGNOS, Oracle 9i, SQL, PL/SQL,

ETL Developer

• Birla Soft is a one of the India Leading companies providing banking and finance services, Insurance, Manufacturing, Asset and service management, consulting DWH and BI, Enterprise solutions and IT services.
• This application was to build a Data Warehouse for the Employees of a HDFC BANK. Informatica power center 7.1.1 was used as an ETL tool to extract data from source systems and to load data in to target systems.

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project coordination. Research Sources and identify necessary Business Components for Analysis.
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs.
• Involved in creation of Data Warehouse database Physical Model, Logical Model using Erwin data modeling tool.
• Extracted the data from Oracle, Flat files and load into Data warehouse.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expression, sequence Generator and aggregator transformations to pipeline data to Data Warehouse.
• Created Tasks, Workflows, Sessions to move the data at using workflow manager and workflow monitor.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Involved in Designing of the database and the tables and the relationship between the tables.
• Wrote stored procedure to clean the existing data and created tables, views and indexes.
• Involved in coding of database Triggers, Stored Procedures and Maintaining Integrity Constraints.
• Involved in creating new stored procedures and modifying the existing ones.
• Worked on improving the SQL Query performances.

Environment: Informatica Power Center 7.1.1, Power connect, UNIX AIX 5.2 , Toad, Windows NT, Erwin 3.5.2, Shell Scripting, SQL Plus, PL/SQL, SQL Navigator, Flat files, SAP, MS SQL Server 2000