Executive Summary

Over 8 years of extensive hands on experience in SAP Business Object BO .Keen planner with comprehensive exposure in working with service delivery / implementation of SAP BIBO projects / program initiatives and ensuring delivery of projects within time to clients.Currently working with Tata Consultancy Services as SAP BO Consultant.

• Exposure on SAP BIBO version migration: Migrated thousands of report from BO 3.x to BO 4.x using Direct BEx BICS and OLAP Universe.
• Exposure on migration Legacy Data warehouse to SAP Data warehouse: converted thousands of report from Legacy system to SAPBO 4.x using Direct Bex BICS and OLAP Universe into various business area.
• Exposure on HANA migration: Worked on switching existing BOBJ 4.x reports to HANA landscape by pointing Data source/Objects mapping with SAP BW on HANA.

Technical Skills

Confidential

Title Design and development for retiring Legacy Data warehouse for AmerisourceBergen Corporation at Onsite.

Position SAP BO consultant

Responsibilities:

• Involved in end to end Risk Management project life cycle, from Gathering Requirement, understanding requirements, making function specification and drafting technical design to till deploying reports on live.
• Creation of Access Matrix in CMC, development of Universes, Webi reports.
• Having good experience production support, ticket handling, and Interacting users and resolving issues.
• Participated project E2E documentation such as Functional specification Requirement specification , Technical design ETL data mapping, Universe table/field mapping, scheduled Jobs , End user Presentation workshops.
• Involved in every phase of this project, integration test case submission and getting sign of from users, creation of CRs and getting code promotion approval Dev to UAT, UAT to PROD.
• Played vital role in code migration process and content migration methodology.

Project The Project involves development of SAP Solutions to retire Legacy Data Warehouse systems. This is an onsite/offshore activity. Team included of 3 members from Onsite and 4 members from Offshore. Approximately 800 reports are being migrated from Legacy Data warehouse to SAP system which includes SAP BW and SAP BO with HANA.

Carried out the following activities:

• Requirement gathering based on the discussion with Subject Matter experts at Onsite.
• Estimations prepared for the effort needed.
• Creating Technical Document based on the Functional Document.
• Coordinating with Offshore for development activities.
• Unit Testing and code review.

Operating System Windows XP

Special Software SAP BW, SAP BO, HPQC, Citrix, Maximo, IPMS, KNOWMAX

Title Design and development for HANA Switching Report Management for AmerisourceBergen Corporation, Offshore.

Position SAP BO Developer.

Responsibilities

• Analysis of Functional Design Documents, building the technical design document TDD and developing data models.
• Involved in end to end Risk Management project life cycle, from Gathering Requirement, understanding requirements, making function specification and drafting technical design to till deploying reports on live.
• Creation of Access Matrix in CMC, development of Universes, Webi reports..
• Performing Testing of the reports in various environments like Development, Quality, Staging and creating Unit Test Documents UTP .

Project

AmerisourceBergen Corporation is an US based Drug wholesale and distribution company and works with manufacturers of branded pharmaceuticals, generic pharmaceuticals, biotech and specialty drugs, over the-counter remedies, and health and beauty aids.AmerisourceBergen Corporation has replaced its legacy applications with SAP ERP and BI Systems.TCS has implemented critical modules like Chargeback Vistex and providing development to various modules like Customer Rebates, SD, MM. and We have also been a part for implementing BO/BEx query and BW Development for HANA Switching Report Management.

Operating System Windows XP

Special Software SAP BW, SAP BO, HPQC, Citrix, Maximo, IPMS, KNOWMAX

Mumbai, India

Title Design and development of Data Warehouse Migration project for Sony Pictures Entertainment.

Responsibilities

• Update client on the progress / issues necessary details.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Involved in developing new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using aggregate awareness function to create the summarized reports.
• Mentored for project manager on Project Deliverables Weekly Status, Monthly Status project updates, tasks status .
• Extensively Involved in Design, Route cause analysis, Issue tracker, ticket management.
• Played vital role in BOXI 3.1/4.x Landscape Planning, Designing and Implementation.
• Assign reports to team members keep track on the progress of the reports.
• Created aggregate awareness, LOV, Custom Hierarchies, Time Hierarchies and used Functions with objects in Universe Design
• Resolved Chasm Fan traps and resolved loops using aliases, Contexts, shortcut joins.
• Develop Universes reports.
• Developed critical reports like drill down, master/detail for analysis of parts benefits and headcount.
• Created different reports containing charts showing revenue and operating income by different divisions, sales and revenue.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements
• Actively executing Process Exceptions according to User's requirement.
• Maintain project related documents.
• Involved in creating Web intelligence reports, Rich Client reports with various sources Universe, OLAP, RDBMS.

Design and development of Data Warehouse Migration project for Sony Pictures Entertainment which enables user to take analytical decision by retrieving latest data by creating Ad-hoc report from data warehouse.

Operating System Windows XP

Languages SQL

Special Software SAP BO, Universe designer, Oracle8i

Responsibilities

• Requirement Analysis and gathering from client.
• Prepare Technical Design Document.
• Developing applications/Reports using Lotus Notes and SQL.
• Perform Unit testing for the application developed.
• access company internal information, policies, News, applications.

Operating System Windows XP,

Languages HTML, Lotus Scripting.

Special Software Lotus Notes, Lotus Domino.

Position Developer

Responsibilities

• Requirement Analysis and gathering from client.
• Prepare Technical Design Document.
• Developing application using Lotus Notes Scripting and Lotus document management tool.
• Perform Unit testing for the application developed.

which enables users to access and manage banking document effective and easily, allows maintain of version of documents.

Operating System Windows 2003 server, Windows XP.

Languages HTML, Lotus Notes scripting.

Special Software Lotus Notes Domino.

Achievements

• Business Development: Sony Pictures Entertainment Business Transition Process.
• Major clients include SONY Pictures USA, AmerisourceBergen, USA.
• ITIL V3 Foundation Certified.
• Exposure on SAP BIBO version migration: Migrated thousands of report from BO 3.x to BO 4.x using Direct BEx BICS and OLAP Universe.
• Exposure on migration Legacy Data warehouse to SAP Data warehouse: converted thousands of report from Legacy system to SAPBO 4.x using Direct Bex BICS and OLAP Universe into various business area.
• Exposure on HANA migration: Worked on switching existing BOBJ 4.x reports to HANA landscape by pointing Data source/Objects mapping with SAP BW on HANA.