Professional Summary:

• Almost 6 years of IT experience as a ETL Developer having strong Data Warehouse Design/Development experience using ETL tools like Informatica 8.6/8.1, Ab Initio 1.15/3.1.
• Experience in all phases of Data Warehousing development life cycle Estimation, Requirement gathering, Design Documentation, Unit test planning, System test Planning, Implementation planning.
• Experience in OLTP/OLAP System - Study, Analyze and Develop Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Extensive experience in Data Extraction, Transformation, and Load from disparate Data sources like Relational Databases, Flat Files.
• Worked on scheduling tools like - Autosys and CA7
• Expertise in performance tuning of mappings, sessions, workflows Throughput analysis, Session partitioning, caching technique - static, dynamic, and persistent.
• Business Intelligence experience using Business Objects XI R2.
• Excellent communication, presentation, interpersonal skills and leadership qualities.
• Experience in different database like SQL Server, Oracle and MS-Access.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.

TECHNICAL SKILLS

PROJECT SUMMARY

Confidential

Technology Analyst

Responsibilities:

• Work with business clients to deliver strategic and tactical solutions
• Involved in Production Support of the daily load process.
• Involved in end user support and bug fixes and tuning the code for better performance.
• Identify, diagnoses, and resolves problems for users of Merchant DSS and communicates solutions to end-users.
• Serves as a liaison between internal/external business community and the IT organization in order to provide technical solutions to meet user's needs.
• Translates business requirements into functional specifications for the IT development teams, manages changes to such specifications, and educates the IT organization on the direction of the business.
• Documents existing process in order to evaluate and define new IT solutions and implementation process.
• Posses understanding of technical trends and uses this knowledge to bring solutions to business groups supported to enhance the enterprise's competitive advantage.
• Study and understand all the functional and technical requirements to better serve the project.
• Developed Ab Initio graphs using different components for Extracting, Loading and Transforming external data into data mart.

Confidential

Data Warehouse Analyst

Responsibilities:

• Participated in solution and technical design, development, testing and delivering of data warehousing solutions.
• Designed and developed analytic and reporting solutions using BI tools, Business Objects.
• Performed data requirements analysis and prepared appropriate documentation to communicate and validate the information
• Developed new reporting data marts, ETL processes, BO universes and reports.
• Involved in production support and interaction with users.
• Involved in documentation of solutions e.g. technical specs, etc.

Confidential

Informatica Developer

Responsibilities:

• Involved in deriving Technical Specifications based on Functional Specifications.
• Developed and tested ETL components using Informatica Power Center.
• Worked on Informatica Designer tools like Source Analyzer, Transformation Developer, and Mapping Designer.
• Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Worked extensively on Lookup, Router, Filter, Aggregator, Expression, Stored procedure, Sequence Generator and Update Strategy Transformations.
• Worked with mapping parameters and variables to load data from different sources to corresponding database table.
• Performed testing of the developed components.
• Involved in System testing and UAT support.
• Involved in Production Support.
• Involved in writing shell scripts for file transfers, file renaming and few other scripts to be executed from UNIX.
• Dealt with mappings that incorporate Incremental loads, Constraint Based Loading.
• Worked on PowerCenter Versioning Check-in, Check-out , Querying to retrieve specific objects, maintaining the history of objects.
• Involved in end user support and bug fixes and tuning the code for better performance.
• Performed Integrated and System testing of the complete system.
• Responsible for configuration control using VSS

Confidential

Data Warehouse Developer/Analyst

Responsibilities:

• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Prepared documentation such as Functional Specifications document, Technical or ETL Specifications document,
• Worked on Data Analysis, Mapping, Identify Data Quality issues, Data Cleaning, Data validation and Loading.
• Performances Tuning recommending tuning strategies in Informatica Mappings, Sessions, Workflows and sending automated email on errors, failures, success of the sessions/workflows.
• Hands on experience leading all stages of system development efforts, including requirement definition, design, architecture, testing, support and administration.
• Expertise in developing and running Informatica Mappings, Sessions/tasks, Workflows, Worklets, and Batch processes on Informatica server.
• ETL Architect, Define ETL Standards, ETL process, batch processing, bulk loading, initial data capture, change data capture, implementation process.
• Create Perform Unit Integration Test Cases, UAT Test Case Review, Migration to Production.
• Worked on Informatica Designer tools like Source Analyzer, Transformation Developer and Mapping Designer.
• Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Worked extensively on Lookup, Router, Filter, Aggregator, Expression, Stored procedure, Sequence Generator and Update Strategy Transformations.
• Involved in exhaustive testing of the developed components.
• Involved in System testing and UAT support.
• Involved in end user support and bug fixes and tuning the code for better performance.