PROFESSIONAL PROFILE:

• Having total 13+ years of experience and working in BW/BI from past 13+ years as SAP BW/BI Consultant as well Interaction center consultant.
• I had actively involved with application in the area’s development, Implementation, Production Support.
• Currently working on BW (7.5) offerings: New BI Dataflow, New Reporting features.
• I am a motivated professional team player, have been a member of Support teams of Confidential
• Worked in the areas of Designing and Maintenance of Info Cubes, Multi Providers, ODS Objects, Open ODS Views, Advanced DSO’s, Composite Providers, Smart Data Integration (SDI), Performance tuning to achieve best possible performance.
• Reporting: Having experience in Data Modeling and worked on reporting tools like BEx Query Designer, BEx Analyzer, workbooks, BOBJ Reports, BO Analysis for Office, Analytics for Cloud, Embedded Analytics on S/4 HANA.
• He had undergone IBM internal on HANA & BPC 10.0 which is a new concept of SAP.
• He had worked on Extraction of data from SAP source systems using LO Extraction, COPA and Generic Extraction from Flat Files including installation of Business Content.

TECHNOLOGY CAPABILITIES:

• SAP HANA, SAP HANA XS, SAP BW on HANA
• SAP HANA Analytical / Calculation views & knowledge on CDS views.
• ADSO’s, Composite Providers, Open ODS Views.
• Smart Data Access, Smart Data Integration
• SAP BW 3.1C / 3.5 / 7.0 / 7.3 / 7.4 , 7.5 on HANA, SAP BW Accelerator
• SAP Business Explorer Tools
• BEx Query Designer, BEx Analyzer
• SAP BW - Business Objects Integration (XI R3, BO 4.0 / 4.1)
• SAP Design Studio, Web Intelligence, SAP Lumira
• SAP Analysis for Office - Excel and OLAP
• Dashboard Design (Xcelsius)
• BO Universe Designer and Information Designer
• SAP BPC - BW Integration
• SAP BW - Source system Integration
• SAP ECC (Sales, MM, Finance, COPA, Controlling, QM, PS etc.,)
• SAP Utilities.
• SAP CRM, SAP APO (SNP & DP), SRM.
• Services - Leads, Quotes, Opportunités, Interaction Center, Contracts, Activities etc.
• SAP HCM (Employee, Payroll etc.,)
• SAP BPC - Data manger Tigger, EPM.
• Tableau, Power BI, Qlik Sense Data Visualization Reporting, Knowledge on Hadoop.
• UC4, Zena
• HP Quality Center
• Service Now

PROFESSIONAL AND BUSINESS EXPERIENCE:

SAP BW /BO /SAP BW on HANA AMS Lead

Confidential, Marysville, Ohio

Responsibilities:

• Responsible for test case execution, defect tracking, dashboard reporting.
• Identifying test cases relevant to individual process areas and managing them in HPQC.
• Responsible for FUT & SIT test case execution for ECC, BW, SRM & BPC migration.
• Worked as a lead on designing project systems with LSA++ architecture both backend development and reporting.
• Worked on complex project on project systems flow and reporting and went golive successfully.
• Responsible for the deliverable in the areas of Finance, Purchasing & BPC
• Globally supporting JP, AO & North America regions.
• Being a medium with the client & offshore team and responsible for fixing the issues timely.
• Supporting Business Objects & BPC environment which was a new reporting tool.
• Reviewing the existing design and finding out the places where there is an improvement required in the flow and proposing CIP’s to the clients, so that the same issue with not get repeated & making the system more stable.
• Involved in preparing SAP BI roadmap for the organization involving BW upgrade and moving towards BW on HANA.
• Supporting BPC loads, Data mangers triggers for Budget, Work Force and Project Systems flow.
• Handling load issue timely is one of the responsible jobs.
• As being the oldest in project responsible for giving process knowledge to entire team.
• Helping the team timely on the issue they are facing & sharing knowledge so that issue can be fixed smoothly.
• Worked on upgrade from BW 7.4 to BW 7.5 HANA.
• Data Archiving POC done for Hadoop integration with BW 7.5. Cold data moved from BW to Hadoop.
• Near line storage for Hadoop and configuring clusters using Hive.
• Configuring Hadoop with SAP HANA and BW with basis.
• Supporting Business Objects Analysis Reporting.
• Worked on HANA objects like Attribute Views, Analytical Views, Calculation Views, filters, Input parameters, Calculated Measures, Restricted Measures in data modeling.
• Created ADSO and Composite Providers for the new data flows with Open ODS Views.

SAP BW /BO Lead / Architect

Confidential

Responsibilities:

• Responsible for initial set up of project along with D2D session, desk management for the transition from third party vendor to IBM.
• Responsible for the deliverables in the areas of Billing, Idex, FICA & DM for ISU Utility.
• Delivering the maintenance release every month which are identified as critical to business.
• Managing a team of five from offshore and managing the deliverables and managing the expectations to client by working closely.
• Responsible for Unbilled Activity to enable smooth month activity.
• New Power BI dash board reporting created.
• Reviewing the work delivered by the offshore team and solving the critical issues.
• Align most of the Process Gaps and providing solution to stabilize the system and ensure proper Documentation of all the ongoing deliverables, in alignment with RWE guidelines.
• Supporting the BI system after a huge volume of data migration from legacy.
• Solving the Incidents raised in HPSC Incident tool.
• Responsible for delivering the monthly Maintenance Releases.
• POC done on Tableau reporting based on the business needs.
• Helping the team timely on the issue they are facing & sharing knowledge so that issue can be fixed smoothly.
• Developed BW IP scenarios using different planning concepts, basic planning functions, etc.
• Working on start routine, End routines and supporting the write optimized Operational Data Store (DSO) to stage the data before transferring the DSO contents to the Info Cubes.
• Supporting the batch process chains which were scheduled from UC4 scheduling tool & fixing the load failures which occur daily.
• Responsible for defining technical strategy and tactical plan for implementing data load delivery solutions.
• Having knowledge on ABAP4 programming, analytical, problem solving, and debugging skills.
• Designing BI functional & technical specifications as small project.
• Served as the SPOC for the design and development of BW - BO objects for this whole project.

SAP BW/BW, BO Lead

Confidential

Responsibilities:

• Responsible for the deliverables in the areas of O2C, B2R, DP, CRM.
• Globally supporting APAC, EMEA & North America regions.
• Being a medium with the client & offshore team and responsible for fixing the issues timely.
• Supporting Business Objects environment which was a new reporting tool to Estee Lauder.
• Reviewing the existing design and finding out the places where there is a improvement required in the flow and proposing CIP’s to the clients, so that the same issue with not get repeated & making the system more stable.
• Support & Maintenance the global roll outs for different countries & phases.
• Handling load issue timely is one of the responsible jobs.
• Working on extracting data from SAP CRM TPM for Budget Postings, Funds and Promotions in to SAP BW.
• As being the oldest in project responsible for giving process knowledge to entire team.
• Helping the team timely on the issue they are facing & sharing knowledge so that issue can be fixed smoothly. ed as the best employee for Client Satisfaction.
• Supported Hyper Care activities to stabilize the production system.
• Create Operational Procedures for the BI Team for the client for future s.
• Involved in data extraction and conversion between BPC and ERP systems with extractors and ETL tools.
• Developed custom Process chains to support master data and transaction data loads for BI to BPC.

SAP BW/BW, BO Lead

Confidential

Responsibilities:

• Working on Phase 1 Support and Phase 2 Implementation.
• Primary responsibility is to Support & Implementation for B2R, P2P, O2C & NARR.
• Working on BI reports and workbooks.
• Completing tasks within the time frame and priority.
• Projects should test the queries they need and repair if needed as part of the project the testing includes time to create new test data.
• Working on the New Developments and coordinating with the team members to deliver the Objects with High quality of work.
• Development and analysis of the new objects and processes the need that to be implemented.
• Discussing with in the team and with client about the requirements timely.
• Supporting and coordinating with the client team for the deliverables.
• Attending Conference calls with counterparts without any fail.
• Fixing the process chain loads timely.

SAP BI/ BW/BO - BI Architect

Confidential

Responsibilities:

• Worked independently for the entire project in designing, development, and deployment activities for BI technical solutions and provided a development buffer during peak capacity.
• Prepared and implemented BI Initial setups & cutover tasks for the QA & Productions environment.
• As a Conavtec BI Team I am responsible in developing the SD, MM, PS, PP, FICO Cubes & Reports.
• Installation and activation of all the SAP Business Content Cubes & respective Reports for SD, FICO, PS, MM, PP.
• Created naming conventional document for Confidential Customizations.
• Managing a team of three from offshore.
• Performed Data Extraction using LO Cockpit (LBWE) to support business needs.
• Data Extracting from SAP R/3 (FI/CO, MM, SD and PS, PP)
• Served as the SPOC for maintaining the test cases and performing the testing using HPQC by coordinating with the users and creating / tracking the incidents & change requests using Service Now.

Confidential

BW/BI Consultant

Responsibilities:

• Co-ordination with the team to complete all the tasks on time.
• Transformed 30 Cubes from 3.x flow to 7.0 flow.
• Copied the 3.x update rules & transfer rules of a Info Cube to 7.0 transformations using new Info source concept as a medium if we have multiple ABAP Routines & multiple data sources.
• Created single Transformations where there is single data source mapped to the Infocube.
• Compared the field mappings with the 3.x to 7.0.
• Loading the data using Info Packages & DTP’s.
• Converted Various Infocubes of SD,MM,INV,COPA,FI,QM cubes from 3.x to BI 7.0
• Migrated various data sources, queries from 3.x to BI 7.0
• Actively participated in conversion of data flows from 3.x to BI 7.0 which includes customizing the cubes according to the requirement and loading the data and Re-consoling the data.
• Used HPQC to perform the testing and managed the testing team for this whole project.

SAP BW/BI/WEBI Reporting - SAP Implementation

Confidential

Responsibilities:

• As a team member to implement reporting functionality for SAP CO & SD module in a three BI team.
• Understood and analyzed the business cases of reporting requirements from BI perspective.
• Analyzing the customer requirements & creating RDD’s for technical specifications.
• Created Technical specifications and documentation
• Worked on the Standard Controlling Costs and Allocations Cube, Sales Overview Cube & Order
• Items DSO and customized Cubes & DSO’s to satisfy Confidential requirements.
• Development and Maintenance of Info Sources, Transformations, DTP’s, Info Cubes, Multi Providers, DSO’s & PSA.
• Worked on standard Cost & Allocation Reports & customized reports for SD.
• Worked on LO extractor in the following Applications, Sales Orders, Delivery and Billing.
• Align most of the Process Gaps with the BI business content Reports and build Interfaces and reports for the remaining non-aligned gaps.
• Worked on flat file extraction to bring sales history data.
• Direct Master Data Staging: Update from Master Data into an Info Object without using Update rules.
• Created various reports using variables, filters, restricted key figures, calculated key figures and free characteristics as per user requirement & publishing into portal.
• Maintenance and development of Process Chain, related events and maintenance of the same.
• Involved in development of Web Application Designer.
• End-to-end Data Extraction architecture in BI with ECC.
• Regression testing of Production and Pre-Production systems and related configurations.
• Resolving support issues after post-go live.

SAP BW/BI Consultant

Confidential

Responsibilities:

• As a BW Admin I am responsible for monitoring process Chains for various FI, PM, MM, Reports.
• Resolving tickets using Incident management tool MTK.
• Monitoring process chains for daily loads and weekly loads.
• Monitored Data Loads and Resolving Issues Call Tickets (CT’s)
• Good understanding of Delta mechanism and good at rectifying load fallacies: transactional and master.
• Creating and Scheduling InfoPackages and Process Chains for Master and Transactional Data loads.
• Intensively involved in Loading Master and Transactional data with Delta handling and in rectifying the load issues in production by analyzing the system.
• Created Info Package to do perform Delta and Full extraction methods depending on the business requirement.
• Interacting with the clients from time to time to discuss the open issues.
• Informing Clients about the Success / Failure of the loads as soon as the activity is finished.
• Development support for all countries and new implementations along with IBM France.
• Changes to the existing Reports & Creation of new Reports as per Clients requirements.

SAP BW - BW Maintenance & Support

Confidential

Responsibilities:

• I am responsible for monitoring process Chains for various FI, PM, MM, Reports.
• Resolving tickets using Incident management tool CMS.
• Monitoring process chains for daily loads and weekly loads.
• Worked on PSA for data staging and data cleansing.
• Ensuring quality deliverables for the client within specified deadlines.
• Enhanced the standard Business Content Master Data and Transactional Data DataSources.
• Checking the daily time schedule for the run & ensuring that the jobs are finished within the specified time frame.
• Even though the client was having BWA, they had many reports on Multiproviders with DSOs under them. After analyzing these, came up with the design proposal of moving the data from those DSOs in to InfoCubes so that it can then be moved to BWA for better reporting performance.