SUMMARY:

• Having 13 years of experience in Software development, ETL Development, Data analysis, Production Support. 4 Years Onsite experience.
• Experience in implementing end - to-end Data warehousing solutions using SAP BODS, Informatica
• Having 2+ years of experience in Informatica Development.
• Having 5+ years of experience in SAP BODS /BODI. 2 years as BODS Admin.
• Well versed in handling Web Administrator / Management Console components.
• Expertise in setting up Datastores and configuring using Webadmin to create user profile and user credentials.
• Expertise in designing ETL Strategy and ETL Framework documents.
• Expertise in preparing test cases to perform ETL unit testing.
• Good understanding of Slowly Changing Dimension (SCD) concept.
• Expertise in writing complex SQL queries.
• Got a professional training on BOXI (Webi/ Universe Designer) Reporting tool.
• Basic knowledge of Qlikview Reporting Tool.
• Good understanding of Oracle hints.
• Knowledge of various data modeling techniques: Star Schema, Snowflake.
• Good understanding of RDBMS.
• Closely worked with Pre-sales team to develop internal POC/ RFPs.
• Good Exposure on Project Management: Preparing daily/weekly status report, preparing estimates for new modules, preparing project planning and project schedule.

TECHNICAL SKILLS:

OS: Windows 8/7/98/2000 Professional/XP, Linux, UNIX.

Database: DB2, SQL Server 2008, Oracle 8.0 / 11.0, MS Access

BIDW Tools: Business Object Data Integrator (BODI) 11.5, Business Objects Data Services (BODS) (3.0/4.0), Informatica 8.6/9.1, BOXI, Qlikview.

Scheduling Tools: Tivoli, Dollar Universe, WebRestart

Other Tools: Toad 11.6. Qlikview.

Internet Programming: Java, JSP, HTML.

PROFESSIONAL EXPERIENCE:

Confidential, KY

Onsite Coordinator / Technical Lead

Environment: Informatica 9.1, Oracle 11g, Oracle PL-SQL, Dollar Universe.

Responsibilities:

• Data Analysis on multiple data marts to fix data issues in production environment.
• Co-ordination with multiple teams including business users, delivery Team, Testing Team to understand source data and validity of the data in EDW and Data marts.
• Writing complex queries to analyze the data.
• Informatica / Oracle job monitoring / Bug fixing in Production environment
• Providing guidance to team in terms of requirement understanding, providing technical solution, designing technical documents.
• Involved in Capacity planning on production environment.
• Effort estimation for new requirements.
• Involved in preparation of Weekly / Monthly status report.
• Involved in Unit Testing / String Testing with Development Team.
• Leading Team of 20 members including onsite and offshore.

Confidential

Technical Lead

Environment: BODS 4.0, Oracle 11.0.

Responsibilities:

• Requirement Analysis.
• Data modeling analysis: - Analyzing data dependency and data hierarchy of different Dimension and Fact tables.
• XML Data Analysis: -
• Analyzing mandatory and non mandatory attributes from XML files.
• Analyzing relationship (1-1,1-M) between parent segment and child segments.
• Preparing XML sample data according to XML / XSD format.
• Design / Development -
• Preparation of BODS ETL strategy / Architecture document.
• Preparation of BODS job design document on the basis of Data model and ETL strategy document.
• Analyzing relationship (1-1,1-M) between parent segment and child segments.
• Implementation of SCD-1, SCD-2 functionality using transformation like xml pipeline,Table comparison,History Preserving,SQL,Map operation,Query.
• Testing - Reviewing unit and integration test cases
• Quality - Preparation of SQA related documents like Project plan, Weekly Status Report, PIP (Process Improvement Plan), Defect analysis document, Skill Matrix document etc

Confidential

Technical Lead

Environment: Informatica 8.6.1, Oracle 10.0.

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, and support for production environment.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor

Confidential 

Technical Lead

Environment: BODS 6.5, Oracle 10.0.

Responsibilities:

• Communication: - SPOC for all project related communication with client and onsite team.
• Requirement Analysis - Involved in requirement gathering and Data analysis.
• Design / Development - Involved in the preparation of low-level and high level design documents. Providing guidance to the team during ETL development phase.
• Involved in promoting BODS objects across different environments.
• Testing - Reviewing Integration test cases. Providing support for UAT.
• Quality - Preparing SQA related documents like Project plan, Weekly Status Report, Deliverable Tracker, Traceability Matrix etc.

Confidential

Team Lead

Environment: BODS 11.5, DB2 8.0.

Responsibilities:

• Requirement Analysis - It includes analyzing requirement documents.
• Design / Development - Involved in low-level design and developed various jobs and performed data loads and transformations using different objects in Data Integrator like SAP-R3,Data transport, Query, Merge, lookup, Table Comparison, History Preservation etc.
• Database – Preparing DDL for the database changes.
• Testing – It includes writing, reviewing & executing unit & integration test cases, providing support for UAT.

Confidential

Production Support Lead

Environment: BODS 11.5, DB2 8.0.

Responsibilities:

• Code Promote in different environments like UAT, Pre-prod, and Production.: - This includes promotion of different acta objects like Dataflow, Workflow, Jobs, Datastores etc.
• Userids and Passwords maintenance in all environments:
• Job Monitoring using Data Integrator WebAdmin
• Job scheduling using Tivoli
• Capacity planning: - This includes analyzing filesystem / tablespace size on target databases depending on the source system data size.
• BRIO Dashboard development: - This includes development of bqys to view / analyze the data in more efficient way using various brio components like Pivots, Reports, Charts etc.
• Opening ESMs and working with SDC team for any environment or database related changes/ issues on preprod and prod environment.