SUMMARY

• Over 11 years of IT experience working on ETL Architecture design, System Analysis, Application Design, Development, Testing, Implementation, Maintenance and Supporting for an Enterprise level Data Integration, Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store (ODS), Data Warehouse (DW)/Data Mart (DM), using available ETL technologies.
• Experience in Data Modeling techniques like Dimensional Data modeling, Star/Snowflake/Hybrid Schema modeling, and Conceptual/Logical/Physical data modeling using Erwin/Visio tools.
• Proven ability in defining goals, coordinating teams and achieving goals.
• Project Planning, Tracking and Scheduling using SDLC/AGILE/SRCUM methodologies in delivering the project on schedule.
• Experienced as a Data Architecture in designing and implementing Data Mart / Data Warehouse applications using Informatica Power Centre 9.x (Designer, Workflow manager, Workflow monitor and Repository Manager) and Informatica Power Exchange.
• Experienced in requirements gathering, project estimating, planning design, build, maintenance, report design, user navigation design, testing and implementation.
• Extensive experience in complete Software development life cycle(SDLC)including the following EDI standards Experience in Ralph Kimball Methodology wif a strong background in Design/Modeling, database development and implementation of various business intelligence andData Warehouse / Data Martsprojects that cover gathering Business Requirements, GAP Analysis, Development, Implementations and Documentation.
• Experience in integration of various data sources like Oracle, Teradata, Exadata, Netezza, Sybase, flat files, XML, Share Networks, Web services and Salesforce.
• Experience working wif scheduling tools like Crontab/Autosys/Control M etc.
• ETL experience in development of mappings and tuned existing mappings for better performance using InformaticaPowerExchange, InformaticaPowerCenter.
• Expertise in writing Oracle PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by partitions, creating Explain Plan, SQL hints for query and indexing.
• Excellent interpersonal and communication skills, and experienced in working wif Executive, senior level managers, business people and developers across multiple disciplines
• Experience inBanking & Financial services, Life Science/HealthCare/Pharmaceuticals andRetail Solutions.

TECHNICAL SKILLS

ETL Tools: Informatica IDQ/Power Center & Power Exchange, Informatica Data Explorer, AQUA

Business Intelligence: Business Objects

RDBMS: Oracle 12C/11G/10G/9i, SQL*Loader, Teradata, Netezza, Exadata, Sybase

Data Modeling: Erwin 9.X, Microsoft Visio

Tools: Toad, SQL DBx, PL/SQL Developer, SQL Assistant, Rapid SQL 8.x, Putty, WinSCP, Autosys, Remedy, Quality Center, Control - M, JIRA

Languages: SQL, PL/SQL, UNIX Shell Scripting, PL/SQL, Visual Basic, XML.

Operating Systems: Windows, UNIX/LINUX, AIX, Sun OS

PROFESSIONAL EXPERIENCE

Confidential, Lexington, MA

Principal Consultant

Responsibilities:

• Involved in Designing ETL Architecture framework for new project (QIP) using Informatica ETL Tool, Oracle/Exadata, UNIX and ERWIN/VISIO, Autosys/Informatica Scheduler
• Conceptual, Logical & Physical Data Model designing for large scale projects
• Worked on Erwin/Visio Data Model, Informatica 8.x/9.x and Informatica Power Exchange
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, Source to Target Mapping, Functional/Technical Specifications, SAD, ETL Design Documents, Development, Testing and Support Activities
• Trained and mentored other resources for ETL development/Testing projects and coordinated wif source systems owners wif day-to-day ETL progress monitoring.
• Design Data Architecture for large scale projects
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by partitions, creating Explain Plan, SQL hints for query and indexing
• Involved in designing and developing Database schemas like Star schema, Snow flake schema, Dimensional Modeling using ERWIN/VISIO and SCD’s
• Extensively ImplementedError Handling Concepts, Testing, Code Debugging and Performance Monitoring and Tuning.
• Expertise in RCA (Root Cause Analysis)and resolvingperformance bottlenecksand enhance for optimization of themappings, sessions and workflows.
• Closely worked wif other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all the Data Quality and Data Governance related activities
• Developed workflow tasks like Event wait, Event Raise, Timer, Command and Decision.
• Created Oracle Functions/Stored Procedures to implement complex business logic for good performance and extensively used Informatica Stored Procedure transformation.
• Automated the entire processes using UNIX shell scripts.
• Engaging in client meeting and identify the business/technical requirements and gaps in the system/process.
• Coordinating and liaising wif multiple vendor’s and Onsite/offshore support team

Environment: Informatica Power Center/Power Exchange 9.5.1, Oracle 11G, Netezza, Exadata, PL/SQL, Flat Files (XML/XSD, CSV, EXCEL), VISIO, UNIX/LINUX, Shell Scripting, Autosys/Informatica Scheduler, HP Quality Center, Remedy, SharePoint.

Confidential

Sr. Datawarehouse Engineer

Responsibilities:

• Created IOD data assessment, data synchronization and data replication tasks using IOD application
• Involved in designing and development of ETL code for the Aggregate Spend project using Informatica, Oracle, UNIX and ERWIN/VISIO
• Engaging in client meeting and identify the business/technical gaps in the system or process and providing future focused solutions.
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, Functional/Technical Specifications, ETL Design Documents, ETL Development.
• Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target
• Conducted systems design, feasibility, application based studies and recommends cost-TEMPeffective cloud solutions.
• Written SQL queries against force.com API
• Performed Inserts/Updates and Deletes into a Veeva application (SFDC objects, Accounts/Address etc) using both Informatica power center and Informatica cloud application.
• Extracted the Salesforce data using Informatica Cloud and loaded it into Oracle Database

Environment: Informatica Power Center 9.X, Informatica Could Services, Oracle 11G, PL/SQL, Flat Files, ERWIN 9.5/VISIO, UNIX/LINUX, Shell Scripting, Informatica IDQ, HP Quality Center, SharePoint

Confidential

Team Lead

Responsibilities:

• Creation and maintenance of ETL & Data Architecture’s for the Credit Risk Insight system and provided technical leadership to team by designing the ETL solution.
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, CODE Mapping, Functional/Technical Specifications, ETL architecture documents (HLD & LLD), ETL Designs & Development, Testing and Support Activities.
• Developed mappings, sessions, workflows and workflow tasks based on the user requirement and scheduled the workflows in workflow manager and monitor the status of the workflow runs in workflow monitor.
• According to the business logic created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Responsible for migrating code from development to testing then to the production environment and experience in creating Reusable Transformations and Mapplets and used them in Mappings.
• Created Oracle Stored Procedures to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Designing High level & Low Level design documents according to project requirements.
• Designing conceptual, logical & physical Data Models for large scale projects
• Engaging in client meeting and identify the business/technical gaps in the system.
• Created IOD data assessment, data synchronization and data replication tasks using IOD application.
• Extensively used Workflow Manager and Workflow Monitor for creating and monitoring workflows and sessions
• Design Data Architecture for large scale projects

Environment: Informatica 8.x/9.x, Informatica Cloud Services, Oracle 11g, PL/SQL, Flat Files, Sybase, ERWIN/VISIO Data Modeling tool, UNIX/LINUX, Shell Scripts, Control M, Clarity, HP Quality Center, SharePoint, JIRA, Remedy, Crontab

Confidential

Sr. Software Engineer

Responsibilities:

• Client Liaison, Analysis, Designing, Development and Support new project requirements. Involved in conducting complete business requirement gathering and converting URS to Functional & Technical documents.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Engaging in client meeting and identify the Business/Technical gaps in the system or process and providing future focused solutions.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Expertise in Teradata FSLDM Concepts and Involved in Logical Data Model and Physical Data Model design and architecture.
• Experienced in defining Roadmap, providing Solutions, Data Architecting, Modeling, Designing and Developing Database, Datawarehouse/Data Mart and Business Intelligence Applications
• Provided an Data Architecture solution that is reusable, maintainable and scalable.
• Designed and Developed Oracle PL/SQL Stored Procedure for efficient customized data loading, retrieval and implement complex business logic for good performance
• Created Materialized views for summary tables for better query performance
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality
• Involved in writing UNIX shell scripts to automate the business process and also provided End-user training and support.

Environment: Informatica Power Center 8x, Oracle 10g, SQL, PL/SQL, and Windows, Autosys, Unix, Metadata Manager, Teradata R11, XML, Erwin 7.

Confidential

ETL Consultant/Lead

Responsibilities:

• Experienced in defining Roadmap, providing Solutions, Architecting, Modeling, Designing and Developing Database, Data warehouse and Business Intelligence Applications
• Management to forecast their markets accurately identifies the factors that most impact involved in all phases of SDLC from requirement, design, development and testing.
• Each segment's profitability. Warehouse is supposed to assist in defining strategy for extensively involved in requirement analysis and created ETL mapping design document.
• Each product segment. The project is focused on developing various details and summary Extensively Designed, Developed, Tested complex Informatica mappings and Mapplets reports that will prove helpful for the sales and marketing teams. dis application is to load data from external flat files and other databases.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplets Designer and Mapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings.
• Extensively worked on the Repository Manager to create/modify/delete users/group/roles.
• Developed functional and technical specification documents, mappings and exception handler for ETL processes.
• Design Data Architecture and Dimensional Data Modeling for new projects
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse and provide technical support to Quality Assurance team and Production group.
• Hands on experience in Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) to analyze, standardize and cleanse the data.
• Fair amount of noledge in Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent.

Environment: Informatica Power Center 8.1.1, AQUA, Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, ERWIN & VISIO, Teradata V5R4, Unix Shell Scripting using AWK/SED, Linux, Cognos 8.0, ProcMon Scheduler, HP Quality Center

Confidential

Informatica Consultant/Lead

Responsibilities:

• Involved in gathering and reviewing business requirements, designing functional / technical specifications design documents and design of Data warehouse / marts.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Design Data Architecture and Dimensional Data Modeling for new projects
• Created Conceptual, Logical & Physical models, used Erwin & VISIO for Dimensional Data Modeling.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Demonstrated expertise utilizing ETL tools and Informatica ETL package design in RDBMS systems like Oracle, Sybase, Teradata etc.
• Extracted data using BTEQ scripting which includes Fast Export and Multi Load utilities
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data wif business rules, and built reusable mappings, non as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Fair amount of noledge in Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent..
• Conduct status meetings wif project managers, escalate issues when necessary, conducts meetings for issues resolution.
• Hands on experience in Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) to analyze, standardize and cleanse the data.

Environment: Informatica Power Center 8.x, Power Exchange, Autosys, HP QC, UNIX, Erwin, Oracle 9i/10g, Visio, SQL, PL/SQL, SQL * Loader, TOAD, XML, Business Objects

Confidential

Informatica Consultant/Lead

Responsibilities:

• Reviewed data models, system and designed Extracting architecture, Applications design, requirements documentation and program specifications.
• Production Support, ETL Executions using web methods scheduler, Performing Root Cause Analysis on Critical batch jobs failure, Defect Tracking and bug reporting, UAT Data & production Implementation support.
• Work closely wif business areas to identify high value business issues.
• Created Informatica repositories in different stages of project, which supports multi-language data (Unicode data) and created users, user groups and connections.
• Designed the mappings and sessions to extract Real-Time data from different systems.
• Created Simulation mappings, sessions and workflows for processing error records while loading into Informatica.
• Workflows have been scheduled dynamically according to the business usage by using UC4 scheduler.
• Written UNIX shell scripts to process the Real time extracted staging files for the load process
• Write complex SQL Queries/Stored Procedures for Functional, Regression, Integration testing, User Acceptance Testing.
• Provide End to End support activities using scheduler and monitoring & automating the production workflows.
• Prepare High Level and Low Level Design Document, Functional Specification documents, CODE mapping Documents according to the Business Requirements

Environment: Informatica Power Center 7.1.4/8.0, Oracle, Neoview, web methods scheduler, HP Quality Center, UC4 Dynamic Scheduler, UNIX Shell Scripting, Sun Solaris.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL mappings, transformations using Informatica power center.
• Implemented source and target definitions in workflow designer.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Mappings were designed to cater the slowly changing dimensions.
• Used various stored procedures in the mappings.
• Preparation of Test Plans, Test Cases/Scripts, SIT/UAT Testing, Reporting, Client Presentation and Post Production Support Activities.
• Development Reports using Business Objects reporting solutions
• Data Modeling Design using Erwin & Microsoft VISIO
• Developed several reusable transformations and Mapplets that were used in other mappings.
• Worked on the server manager to run several sessions and batches concurrently and sequentially.
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic.

Environment: Informatica power center 7.1.4/8.1.1, Oracle 9i, UNIX, PL/SQL, STAR Schema, Flat files, Quality Center, Remedy, Autosys, Business Objects

Confidential

ETL Developer

Responsibilities:

• Involved in creation of Schema Objects like indexes views, and stored procedures. Involved in the Analysis of how the purchase order process is organized.
• Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
• Implementation of ETL Strategies, which optimizes Mapping Performance and Assist in planning and review of Internal Quality processes, Metrics and approaches
• Involved in writing procedures and functions.
• Preparations of Test Plans, Test Cases, SIT Testing, Post Production Warranty Support Activities.

Environment: Informatica 7.1.4, Oracle 9i, UNIX, PL/SQL, STAR Schema, Flat files, Quality Center, Remedy, Autosys.