SUMMARY:

• 10 years of extensive experience in Data Warehousing analysis, design, develop and implementation of DW and Data Marts.
• Design and implementation of ETL environment with Informatica 9.1/ 8.6 /7.1 /6. x Power Center, Business Objects Data Services, Sagent .
• Developed ETL's for supporting Data Extraction, transformations and loading using Informatica Power Center, and BODS.
• Designed complex mappings using Aggregator, Update Strategy, Lookup, Joiner, Router and Stored Procedure Transformations.
• Designed and Implemented Slowly Changing Dimensions and partitioning in the session.
• Experience in working in different sources and databases (Teradata 13, SQL Server 2000/ 2005, Oracle, XML, Flat Files and Excel Spreadsheets, SQL Server 2000/2005).
• Extensively used Teradata utilities MLOAD, FLOAD, BTEQ, FastExport, TPump, and TPT to design and develop dataflow paths for loading and maintaining data in data warehouse.
• Hands - on experience with Power Designer and strong knowledge of Relational database modeling and Dimensional database modeling concepts and star/snowflake schemas implementation
• Experience in performance tuning techniques at application, database and system levels.
• Experience in working Agile and Waterfall methodology projects.
• Working on Agile Scrum team in collaboration with ETL, Reporting team, Testers and DBAs.
• Active participation in Agile Scrum sprint standup meeting and sprint review meetings.
• Supporting Scrum Master to deliver the product demo.
• Attended Agile Scrum Training.
• Good exposure to Scoping, Requirement Gathering, Design, and Development, testing, implementation and production support.
• Extensively worked with OLAP tools such as Business Objects 4.0/XI 3.1. XI R2 (Universe Design, Web intelligence, Xcelsius, Live Office, Dashboards), Crystal Reports, Microstrategy.
• Experience working on Unix environments and Tivoli Scheduling tool.
• Handled large database environment of 293 TB.
• Strong experience working with Remedy incident management, HP service manager, Confidential Service manager tools for raising incidents, normal, expedite, emergency change requests.
• Self learnt and trained all the team members to use the Remedy incident management tool.
• Expertise over preparing requirement document, High level and low level design documents, solution blue prints, report specifications, test plans, database designs, UAT Scenarios, deployment documents.
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self-motivated fast learner, good leadership skills and the ability to develop solutions for challenging client needs.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.1 /8.1/ 7.2, Business Objects Data Services 4.0 / Data Integrator 11.5, Sagent

BI/OLAP: SAP Business Objects 4.0/XI3.1/XIR2/6.x, CMC, Designer, InfoView, Web Intelligence, Desktop Intelligence, Xcelsius, Dashboards, Crystal Reports 9, Crystal Reports for Enterprise, BI, BW, Microstrategy

RDBMS: Teradata 13.1, MS SQL Server 2000 / 2005, Oracle 9i, SQL

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Power Designer, Microsoft Visio

Web Expertise: ASP 3.1, Java Script, VB Script, HTML

Others: Tivoli Maestro scheduler, CVS, VSS

PROFESSIONAL EXPERIENCE:

Confidential, Egan, MN

Responsibilities:

• Analysis to determine the scope of the change.
• Responsible for designing and modeling the data model for the project.
• Will be working on medium to high architectural impact projects, creating Conceptual Architecture and High Level Design documentation and recommending Best Practices.
• Work with ETL architecture team for creating for Data Marts.
• Preparing the requirement specification, interface agreement document, Informatica Extraction, Transformation and Loading (ETL) mapping document, design documents, test plans, supporting documents.
• Designing and developed Informatica mapping to source from SAP BW system.
• Developing mappings, mapplets, sessions, workflows, worklets and workflow tasks based on the user requirement.
• Create mappings to load into fact and dimension tables using various.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations
• Create Unit test plans and test every mapping developed.
• Work with Business Objects team to validate the data from user perspective
• Work with business users to validate the data in UAT meetings.

Environment: Informatica Power Center 9.1, SAP BO 4.0, Oracle 11g.

Confidential, Richfield, MN

Technology Architect

Responsibilities:

• Analysis on the metrics to be displayed on the dashboard to indicate the KPIs
• Responsible for working on medium to high architectural impact projects, creating Conceptual Architecture and High Level Design documentation and recommending Best Practices.
• Created logical, physical and dimensional data models using Power Designer
• Worked with ETL design and developing architecture for Data Marts.
• Discussing with business users on designing the dashboard GUI.
• Preparing the requirement specification, interface agreement document, Informatica Extraction, Transformation and Loading (ETL) mapping document, design documents, test plans, supporting documents
• Implemented logical and physical Data Modeling with Star schema using Power Designer in Data Mart.
• Designed and developed Informatica mapping and incremental updating/aggregation strategies
• Developed mappings, mapplets, sessions, workflows, worklets and workflow tasks based on the user requirement
• Extensively used ETL to load data from wide range of source such as flat files, Relational Database to Data Warehouse.
• Created mappings to load into fact and dimension tables using various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, input, output transformation in the mapping
• Developed and Implemented Informatica parameter files to filter the daily data from the source system
• Performance tuning of sources, targets, mappings and SQL queries in the transformations
• Implemented the slowly changing dimensions type 2.
• Created Sessions, Workflows, Link Tasks, Controls and Command Tasks using Workflow Manager and monitored the workflows/sessions using Workflow Monitor
• Developed Unit test plans for every mapping developed and executed the test plans before moving the code into QA environment
• Created new Business objects universe from scratch.
• Created personalized version of reports as well as statements for customers using Business Objects WEBI reports and Dashboards
• Proving all the inputs to team to create dashboard reports.
• Coordinating with on shore team and off shore team in getting on time delivery

Environment: Informatica Power Center 9.1, SAP BO 4.0, Power Designer, Teradata 13, MS Visio, Windows 2000, UNIX, Tivoli Maestro

Confidential

Technology Architect

Responsibilities:

• Preparing the requirement specification, interface agreement document, mapping document, design documents, test plans, supporting documents
• Responsible for architecture, design and implementation of an application for Business.
• Defined the data integration standards and designed the data integration process from multiple sources using the standards.
• Extensive data analysis across multiple sources for creating the enterprise data models
• Involved in Logical and Physical database using Power Center tool
• Data modeling and design of data marts in Snow flake schema methodology with confirmed and granular dimensions and FACT tables.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Created Technical Specification documents using MSVisio and maintained Technical specification documents throughout development lifecycle
• Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Created and managed daily, weekly, and monthly data operations, workflows and scheduling processes.
• Created complex mappings using Un connected and Connected Look Up transformations
• Worked with the Joiner transformation using Normal Join, Master outer join, Detail Outer Join, and Full Outer Join
• Implemented Error handling logic to capture the invalid data.
• Created mappings in designer to implement the type 2 slowly changing dimensions.
• Optimized/Tuned mappings for better performance and efficiency
• Recommended tuning options to source/target database.
• Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data
• Designing and developing new universe from scratch.
• Developed new complex web intelligence reports, with multiple tab reports. Each tab reports will display different level of data. Input control was created on the graphs, such that user can change the data as per their requirement.
• Working with customers on validating the reports during UAT and post production phase.
• Training junior level developers in Informatica, BO 4.0.
• Leading a team of 15 people and coordinating between onshore-off shore teams.

Environment: Informatica Power Center 9.1, SAP BO 4.0, Power Designer, Teradata 13, MS Visio, Windows 2000, UNIX, Tivoli Maestro

Confidential

Technical Lead

Responsibilities:

• Preparing the requirement specification, interface agreement document, mapping document, design documents, estimation plans, test plans, supporting related documents.
• Involved in analyzing the business requirements and framing the business logic for the ETL process.
• Extracted data from various sources like Teradata, SQL Server, Oracle, and flat files.
• Developed Mappings as per the Technical specification approved by Client.
• Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router and Expression.
• Created Mapplets to reduce the development time and complexity of Mappings and better maintenance
• Implemented the SCD Type2 to keep track of historical data.
• Extensively Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions
• Created new scripts and modified existing scripts using Teradata utilities like BTEQ, FLOAD and MLOAD
• Updating existing Universe and enabling ad hoc report generation
• Creating new complex reports in web-I and helped the team in overcoming all technical challenges.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data
• Trained 5 fresher’s in Informatica and 5 fresher’s in Business Objects XI R3.1. Also trained them in the internal tools, which was used for documentation, version control, ticketing system, migration request system.
• Coordinating with off shore team and on site lead to drive the project for successful completion
• Proved the capability to manage a team of 25 people which involved multiple iterations going in parallel.
• Post production support

Environment: Business Objects XI R2 / R3, Informatica 9.1, Teradata 13.1, Teradata Utilities, UNIX, Maestro

Confidential

Technology Architect

Technical Lead

Responsibilities:

• Interacting with the clients to understand the requirements
• Participating in design discussion.
• Creation of data dictionary and Mapping documents, unit test cases and unit testing.
• Developing mappings using BODI (Business Objects Data Integrator/ Data Services).
• Modifying reports, using InfoView and Web Intelligence
• Unit testing, System testing and acceptance testing.
• Production Implementation and Support

Environment: Business Objects Data Integrator (BODI) 11.5, Business Objects XI R2, MS SQL Server 2005, Windows XP

Confidential

Technical Lead

Responsibilities:

• Understanding the requirements
• Creation of data dictionary and Mapping documents.
• Participating in preparing function document
• Developing mappings using BODI (Business Objects Data Integrator).
• Creating Unit Test Cases and Unit Testing
• Production support

Environment: Business Objects Data Integrator (BODI) 11.5, MS SQL Server 2005, Windows XP

Confidential

Senior Developer

Responsibilities:

• Running the operations for dailies, weekly, monthly jobs.
• Generating reports using Micro strategy
• Monitoring the Scheduler.
• Timely escalation of issues.

Environment: Informatica 7.1, Oracle 9i, UNIX, Microstrategy

Confidential

ETL and Report Developer

Responsibilities:

• Involved in extracting the data from different data sources like Oracle and Flat files.
• Developed mappings/sessions using Informatica power center for data loading.
• Created various Transformations like Joiner, Aggregator, Expression, Filter, and Update Strategy.

Environment: Informatica 6.1, MS SQL Server 2000, Crystal Reports 9, Windows NT