SUMMARY

• More than 8 years of global experience in Information Technology with an expertise in Design, Implementation and Maintenance of OLTP & Data Warehouse systems, ETL processes, Business Intelligence and Enterprise Application Integration across various industries
• Experience in all the phases ofData Warehouse life cycleinvolving Requirement Analysis, Design, Coding, Testing, and Deployment
• Experience in working withbusiness analysts to study, identify and understandrequirements and translate them into ETL code
• Extensively worked on theETL mappings, Analysis and documentation ofOLAP reports and other requirements
• Strong knowledge ofEntity - Relationship concept, Facts and Dimension tables, slowly changing dimensions (SCDs)andDimensional Modeling - Star Schema and Snow Flake Schema
• Strong background in ETL Data Warehousing using Informatica PowerCenter
• Experience in integration of various data sources likeOracle, DB2, SQL server, MS access andnon-relational sources likeflat filesinto staging area
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) andMappingsusing Informatica Designerand processing tasks usingWorkflow Managerto move data from multiple sources into targets
• Experience in creatingReusable Tasks(Sessions, Command, Email) andReusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control)
• Tuned mappings using PowerCenter Designer and various logic to provide maximum efficiency and performance
• Experienced inUNIXwork environment,file transfers,job schedulingand error handling
• Extensively work donedevelopinganddebuggingInformaticaMappings, Mapplets,Sessions andworkflows
• Good exposure inInformatica Data Quality including data Cleansing, De-duping and address correction
• Worked onPerformance Tuning,identifyingandresolving performance bottlenecksin various levels like sources, targets, mappings and sessions
• Experience in writing, testing and implementing PL/SQL triggers, stored procedures, functions, packages
• Involved increating Test data, Unit testing, System testingto check the accuracy of data loaded into target

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9.x/8.x /7.x, SQL Server 2012/2008/2005/2003/2000 , MS-Access

ETL Tools: Informatica 9.x/8.x PowerCentre, Work Flow Manager, Work Flow Monitor, Repository Manager, Designer, Informatica Data Quality 9.5.1(IDQ)

Reporting Tools: Qlik View 11/10x/9x, Tableau Desktop

Database Skills: SQL, PL/SQL, SQL Developer, TOAD

Operating Systems: Windows 2007/XP/2000, UNIX

PROFESSIONAL EXPERIENCE

Confidential | Irving, TX

ETL/Informatica developer

Responsibilities:

• Involved in all phases of the project life cycle including requirement gathering, analysis, coding, testing and implementation
• Developed ETL procedures consistent across all systems by analyzing business requirement and working closely with various application and business teams
• Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity
• Involved in analyzing the source data coming from different Data sources such as Oracle, XML, flat files etc.
• Developed data models/mappings between source systems and warehouse components
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, Rank, Sequence Generator, Stored procedure, and XML transformations
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor
• Used Workflow Manager for creating workflows, worklets, email and command tasks
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files
• Used SQL tools like TOAD for Data Analysis, wrote and executed tuned SQL queries to troubleshoot data issues and to view & validate the data loaded into the warehouse
• Utilized QlikView to develop complex dashboards like product, orders, traffic, billing, customer and sales with multiple sheets using boxes, buttons, charts and cyclic groups.
• Resolved Dashboard data issues by modifying load scripts, eliminating synthetic keys, and closed loops
• Customized dashboards by using expressions, bookmarks, functions, dynamic charts, filters, action triggers and system variables
• Created incremental load scripts using QlikView for ordering, billing and service monitoring
• Connected to different ODBC, OLE Database sources (SQL Server, Oracle) and flat files to create and schedule different complex reports
• Established a secure environment as well as implemented field and document level security using QlikView Section Access and Triggers

Environment: Informatica Power Center 9.1x, TOAD, Oracle 11g, QlikView 10x, Flat Files, Windows XP, SQL

Confidential | Philadelphia, PA

ETL/IDQ Developer

Responsibilities:

• Gathered and analyzed business requirements from Business Analyst and converted it into data analysis projects
• Documented user requirements, translated it into system solutions developing implementation plan & schedule
• Worked with Informatica Data Quality 9.5.1(IDQ) Toolkit for analyzing, standardizing, cleansing, matching, conversion, exception handling, reporting and monitoring the data as well as implementing Data Quality rules
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank
• Created and configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data
• Optimized the performance of the mappings by various tests on sources, targets and transformations
• Identified and removed bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance
• Developed and tested all the backend programs, stored Procedures, data flows and update processes
• Write documentation to describe program development, logic, coding, testing, changes and corrections
• Utilized Tableau to create metrics, attributes, filters, reports, and dashboards including advanced chart types, visualization and complex calculations to manipulate data
• Created SQL scripts, indexes, and complex queries for data analysis and extraction
• Scheduled data extracts on a daily basis and combined multiple data silos that exist on campus to one location
• Created rich dashboards using Tableau dashboard and prepared user stories to deliver actionable insights

Environment: SQL Server management studio 2012, PowerCenter 9.5, IDQ 9.5, Tableau, Flat Files, XLS, Windows

Confidential | Des Moines, Iowa

ETL Developer

Responsibilities:

• Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and business units in order to define the requirements
• Documented user requirements, translate requirements into system solutions and develop implementation plan and schedule
• Extracted data from excel files, high volume of data sets from data files, Oracle, DB2, SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area
• Developed data Mappings between source systems and warehouse components
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures
• Developed and tested all the backend programs, Informatica mappings and update processes
• Created and Monitored Batches and Sessions using Informatica PowerCenter Server
• Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Written documentation to describe program development, logic, coding, testing, changes and corrections
• Generated context filters and used performance actions while handling huge volume of data
• Generated Tableau dashboards for sales with forecast and reference lines
• Created visualizations for department and customer spend analysis
• Generated test cases for each specification in requirement specification document corresponding to module
• Participated in user acceptance warranty testing including security and negative testing of the application
• Generated KPI for customer satisfaction survey results and investment management

Environment: Informatica PowerCenter 9.1,Oracle, Tableau, PL/SQL, Flat Files, MS Access, XML, Windows 7

Confidential

ETL Data warehouse/Developer

Responsibilities:

• Collected and analyzed business requirements with the management and converted them in to project documentation
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions
• Involved in analysis and design of physical and logical data models for Enterprise data warehouse with a pool of various data marts
• Imported data from various sources to Data Warehouse targets using Informatica PowerCenter, Server Manager, Repository Manager and Designer
• Imported sources from IMS DB, ERP(SAP) systems using Informatica PowerConnect
• Developed various Mappings with the collection of all sources, targets and lookup, joiner, aggregator, rank transformations using designer
• Managed global and local repository permissions using Repository Manager in Oracle Database
• Created and monitored sessions and batches using Server Manager to load data into the target database
• Used Infromatica Reject Loader utility to load erroneous data

Environment: Informatica PowerCenter 7x, Oracle 9i, PL/SQL, TOAD, Windows XP, Linux