SUMMARY

• Around 8 years of experience in data warehousing with in - depth knowledge by using Informatica Power Center.
• Knowledge in Data Warehousing/ETL programming and Fulfillment of data warehouse project tasks such as data extraction, cleansing, transforming and loading Warehouse using Informatica Power Center 9.5.
• Strong exposure in Production support & development life cycle
• Strong Exposure in Financial, Industrial, Educational sectors
• Experience with data analysis and Dimensional Data Modeling (specific to a data warehouse), Star schema/Snowflake schema, fact and SCD dimension tables
• Extracting data from sources like ERP, Mainframes, TM1, Flat files using Informatica.
• Experienced working on backend database like Oracle,Teradata,SQL server
• Extensive scripting knowledge of SQL\PLSQL,Unix scripts.
• Knowledge in Salesforce service cloud
• Have domain expertise in Electric and Utility domain and financial data like trade end-to-end life cycle.
• Worked with transactions involving large data amounting to millions of records.
• Possess strong analytical and problem solving skills
• Experience in preparing Technical Design documents based on functional specification.
• Prepared and executed functional Test Plans for User Acceptance Testing (UAT) to support business users.
• Good written and oral communication ability in translating the business requirements into Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Requirement traceability matrix and System Requirement Specification.
• Extensive experience with cross country teams and working directly with offshore teams.
• Exceptional user facing skills and client relationship skills, ability to perform independently as well as in team player, ability to meet tight deadlines and work under pressure.
• Experienced in presenting trainings to the wider audience.
• Possess excellent business and communication skills, ability to master new skills and Technologies in Faster pace, Dedicated, Hard worker and Good Team player.
• Have a professional attitude and good communication skills, self-motivated and multi-task oriented, with strong work ethic and ability to work effectively

TECHNICAL SKILLS

BI Tools: Informatica Power Center 9.5.1, Congos, Informatica Meta data manager, Hyperion, Business objects, Autosys

Databases: Oracle 9i,10g Teradata 13.11, Microsoft SQL Server 2008

Operating Systems: Windows NT / 2000 / XP / 2003, UNIX

Front End Tools: TOAD, SQL Plus, SQL Developer

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Project Management: Estimates/Scheduling, Resource Allocation, Project Planning, Tracking and Reporting

S/W development Methodologies: Agile, Waterfall models

PROFESSIONAL EXPERIENCE

Confidential, Reston,VA

Operations Analyst

Responsibilities:

• Understanding the enhancement requirements from the Business users and Providing solutions for it
• Resolving p1( 4hours) incidents with in deadlines
• Handling manual data requests
• Preparing test cases and helping QC team for performing quality checks
• Preparing dashboard for tracking incidents
• Through DML scripts fixing data issues in prod
• Identifying the bugs in ETL (informatics mappings) flow
• Fixing the issues in flat files, through unix commands
• Monitoring the ETL jobs
• Coordinating with DBA’s and change management control team for fixing the production issues

Confidential, Stamford, CT

Project lead

Responsibilities:

• Worked in onsite/offshore model managing a team of 15 members. Part of a huge 35 member’s team.
• Understanding the enhancement requirements from the Business users and Providing solutions for it
• Developed complex mappings which includes type 1, type 2 dimension & Fact tables.
• Conducted design and review meetings to get design approval from different stake holders in the project.
• Prepared the TDD, FDD, impact analysis docs
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Helping the support team for resolving P1 incidents with in the deadlines (1 hour).
• Mentoring the team in tough situations
• Involved in developing the projects from scratch to Production deployment
• Prepared necessary docs for moving the code from Dev to QA,Prod
• Prepared test cases for QA team for testing the informatica objects
• Worked with parameter files and also created parameter values across mappings.
• Used Informatica Workflow Manager, Workflow monitor and repository manager.
• As an onsite coordinator I have handled responsibilities like customer facing, played anchor role between offshore team and client, provided technical route map to team for resolving the issues in time
• Identified the bottlenecks in the existing project and provided solutions which saved the resource and user time
• Minimized the project cost by utilizing the resources in best way
• Management plays vital role in this project because as we are loading the data from 12 source systems, a lot of coordination, effective communication and management is required to tackle the issues.
• As we are dealing with financial data, maintained 100 accuracy in design and implementation
• Prepared project estimates (RFP).

Confidential

Team Lead

Responsibilities:

• Understanding the enhancement requirements from the Business users and providing solutions for it.
• Prepared 50 complex mappings which are related to CDC, SCD type -1, Aggregate loads
• Conducted design and review meetings to get design approval from different stake holders in the project.
• Prepared the TDD, FDD, impact analysis docs
• Worked with parameter files and also created parameter values across mappings.
• Used Informatica Workflow Manager, Workflow monitor and repository manager.
• As part of self-deployment process, deployed the code to QA, Prod
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Preparing Daily status reports.
• Tracked the issues through ticketing System(TSG service now)
• Identifying the bottlenecks in the project and providing solution for it.
• Resolving Support Issues within the SLA
• Monitoring informatica jobs
• Participating in Yearend Activities
• Taking care of manual runs
• Mentoring the team

Confidential

Developer

Responsibilities:

• Worked in onsite/offshore model, coordinated with onsite lead for requirement gathering.
• Involved in all phases of development starting from Requirements Analysis to Production Move
• Prepared 25 complex mappings which are related to stage, incremental load,SCD type -1, Aggregate loads
• Used different types of transformations like Source Qualifier, filter, Aggregator, Expression, Unconnected Lookup, Router for designing the mappings.
• Worked with parameter files and also created parameter values across mappings.
• Used Informatica Workflow Manager, Workflow monitor and repository manager.
• Conducted design and review meetings to get design approval from different stake holders in the project.
• Prepared Unit & Integration test cases for testing the data.
• Prepared ETL specification
• , Database Sizing Documents
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Post-production support including KT to support team.

Confidential

Developer

Responsibilities:

• Analysis of the specifications/requirements provided by the onsite lead.
• Review the requirements, and obtain clarifications if any.
• Prepared 15 complex mappings which are related to stage, incremental load,SCD type -1, Aggregate loads
• Worked on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Joiner and Lookup.
• Worked with parameter files and also created parameter values across mappings.
• Used Informatica Workflow Manager, Workflow monitor and repository manager.
• Prepared Unit & Integration test cases for testing the data.
• Prepared ETL specification(LLD), Database Design Documents
• Designed Reports Like Crosstab,List,chart,Dashboard Reports
• Involved in scheduling the Repots
• Post-production support including KT to support team.

Confidential

Support Analyst

Responsibilities:

• Created mappings using different sources like Flat file and Oracle by using Expression, Aggregator, Sequence Generator, Look-up, Joiner, Router, Filter, Sequence Generator, Sorter and Update strategy transformations.
• Developed and tested ETL mappings as per business logic in the requirement document.
• Worked with parameter files and also created parameter values across mappings.
• Used Informatica Workflow Manager, Workflow monitor and repository manager.
• Involved in migration and production Support.
• Supported 10 critical applications which plays vital role for business
• Resolved P1 &P2 incidents with in SLA
• Tracked the issues through ticketing System Helpdesk tool
• Created and configured sessions in Informatica workflow Manager for loading data into Data Warehouse tables from various heterogeneous database sources like Flat files and CSV files.
• Prepared Unit & Integration test cases for testing the data
• Delivered quality code with zero defects which was highly appreciated by the client.