SUMMARY:

• Over 11 years of experience in leading and designing BI solutions in SAPBW/ BI/BO with HANA (in last 4 years).I am having solid experience in understanding user requirements, business use cases, data modeling, extraction, and data visualization in the area of Business Intelligence. Champion on reporting and data visualization tools like BEx query designer, Web Intelligence, Microsoft Analysis and Dashboard Designer.
• Well - versed in architecture of HANA, and data modeling BI solutions using BW on HANA, Native HANA and Hybrid solutions to consume with BOBJ tools.
• Very good Experience with Production support related to Incidents and CR's in HPQC, HPSM and service now.
• Trained SAP Phoenix team on SAP BW, SAP IP and HANA.
• I worked extensively worked with BWA or BIA and BWIP (integrated Planning).I worked on SAP HANA and BPC10.1, developing POCs for the automobile industry, Oil&Gas sector.
• I worked directly with the users in solving the production issues as well as UAT issues.
• Led the BI/BO/HANA reporting projects and defined the KPI’s for delivering the work and updated the status to program manager, stack holders and onshore/offshore senior managers.
• Leverages knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Involved in user for giving the application KT and preparing the user documentation.
• Involved in QA analysis starting from reports to source and target mappings and raised defects if any.
• Worked extensively with data extractions from SD, FI, MM, PP, CRM modules and APO DP -SNP flows.
• Worked on SAP HANA data modeling using Attribute View, Analytical view and Calculation view.
• Worked extensively with SQL scripting using calculation views and attribute views.
• Worked extensively with Data-Modeling, Data Extraction, DataLoading, Scheduling, Monitoring, Infosources, Info-cubes, ODS objects, Multi-Cubes.
• Business content, Flat file, LO Cockpit, Generic data Extraction and BW APD's.
• Reporting: BEx-Analyzer, Bex Query & Workbooks. Involved in Managing of InfoCubes, which involves InfoCube Content, Performance issues like Indexes, Statistics, Compression of InfoCube and Rolling up the data to the Aggregates.
• Worked extensively with BIA (Business Intelligence Accelerator) and cell editor.
• Very well experienced in developing Bex reports from information using Bex Analyzer and implementing Bex queries consisting calculated and restricted Key figures, Filters, variables, workbooks.
• Experienced in configuring InfoCubes, ODS objects, InfoObjects, InfoSources, Update rules and Transfer rules.
• Worked extensively on change control and transport management in BI/BW.
• Worked extensively with datasource enhancements.
• Worked extensively on various Business functional Areas like SD, FI, CRM,SRM and HR modules.
• Strong analytical, problem solving and multi-tasking skills, as well as communication and interpersonal skills and good organizational skills.
• Involved in HANA sidecar implementation for the modules related to FI-GL, Inventory, QM.
• Worked as an overall BOBJ Development Lead and Developer to ensure all the deliverables are developed to the quality standards.
• Involved in Development of WebI Reports and enhancing/modifying existing reports by creating newFormulas, Filters,Charts like Pie charts, Bar Charts & Element Linking, Document Linking etc. as per the client requirements.
• Developed WebI Reports As per the requirement brings the same layout with same level of sort’s breaks,sections and variables in WebI 4.1.
• Developed Dashboards using Xcelsius /Dashboard Designer 4.2 using the back-end SAP BW
• Prepared the plan for cutover activities and ensured successful go live in the given time frame.
• Design and development pertaining to change request and design change in the various functional areas.
• Worked on Reports scheduling and publications experience with Infoview/CMC
• Troubleshooting various ad-hoc issues raised by users.
• Assisted users in creating Ad-hoc reports and interacted with them for reporting requirements.
• Having good experience with ER (Entity - Relationship) and dimensional data modeling as well as OLAP.
• Designed HANA views using SQL scripts extensively.
• Worked with LSA and LSA++ Methodology. Extensively worked with Open ODS view and composite providers.
• Extensively worked change management using HP service desk, Service manager and BMC remedy. Worked on Control M tool as well.
• Worked Extensively with BEX query designer and BEX Analyzer.
• Worked explicitly with SAP HANA Live for extracting the SAP R/3 data to BW by creating the HANA views (calculation views) and connecting open ODS view in SAP BW.Worked extensively with CR, RFP's and RICEF's.
• Extensively worked with the SAP MI (Manufacturing)with HANA.
• Good experience with SAP BI with POSDM.
• Good Experience with BW Authorizations related to BEx query objects.
• Extensively worked with BOBJ webi reports scheduling.
• Implemented the Trade promotion management process from CBP system.
• Crated the real time cubes for TPM tool and then created the input queries and analysis office workbooks.
• Worked with the Bank Analyzer tool.
• Designed the Tableau reports on top of SAP BI and power BI.

TECHNICAL SKILLS:

Programming Languages: C, C++,ABAP/4

Operating Systems: Windows NT 4.0/XP/2000/98, UNIX, Linux ES 5/4, OS/390

RDBMS: SQL

GUI: Crystal Reports 8.0/8.5/11.0

Data Warehousing: Business Objects - Webi4.0,Webi4.1,Dashboards, SAP BW3.5, BI7.0, SAP BI7.3, SAP BI7.4, SAP BW 7.5 SP7.

Hardware Software / Special Tools: SAP HANA 1.0, SAP BIA and SAP BO SUPM.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, California

BI/BO/HANA Architect

Technologies used: SAP HANA 2.3 SP19, BW 7.4 SP04,Microsoft Analysis office 2.3 SP1 and BO Webi 4.1 as well as excel tool using SAP HANA MDX, Tableau, Power BI.

Responsibilities:

• Designed and created the Microsoft Analysis office work books for the MPR division, department, class and subclass.
• Responsible of designing and implementing the solutions for finance sector in the space of BI and HANA.
• Designed and implemented the reports for the GL detail, income statement, Opex, Opex review and Budget vs Actuals reports for the BI side as well as HANA side.
• The reports design involves creating of the calculation views and directly connecting to the Webi reports as well as to the excel using SAP HANA MDX connection.
• Worked extensively with the SAP BO-Webi, Analysis and SAP HANA MDX.
• Worked directly with the Finance super users, managers and directors for requirement gathering.
• Involved in performance testing, UAT and integration testing for the reports developed.
• Extensively done the testing for huge finance data by doing the excel V look ups and spread sheets. This involves ECC functionality matching with the BI side functionality matching.
• Suggested the client on the new features in the space of SAP HANA.
• Designed the Tableau reports on top of SAP BI and power BI.

Confidential, Newjersey

BW-IP/BO/HANA Consultant

Technologies used: SAP HANA 2.3 SP19, BW 7.5SP04,BW-IP, Microsoft Analysis office 2.3 SP1, SAP CAR 2.0

Responsibilities:

• Designed and created the Microsoft Analysis office work books for the MPR division, department, class and subclass.
• Created the planning queries using BEX query designer which is part of SAP HANA studio.
• Created the infoobjects, Advanced DSO’s and Composite providers directly in SAP HANA studio.
• Created the views for master data and transaction data, which are in turn mapped to infoobjects in SAP HANA studio.
• Extracted data using SAP HANA SDI.
• Created the Aggregation levels, planning sequences, Planning Filters, Data Slices and Planning Functions using RSPLAN.
• Extensively worked with the top down and bottom up planning function types.
• Designed the calculation views for Sales, receipts and inventory.
• Extensively worked with the HANA views performance in HANA studio which are based on SQL.
• Created Calculation views on top of Bank Analyzer data.
• Trained SAP Phoenix team on SAP BW, SAP IP and HANA.
• Trained in HANA migration activities and estimations.
• Designed and created the “What- If” planning Analysis work book using BEX planning queries in the BW -IP for the North America.
• Created the Aggregation levels, planning sequences, Planning Filters, Data Slices and Planning Functions using RSPLAN.
• Created the real time cubes and defined the locking mechanism for the same.
• Implemented the Volume Planning and TPM (Trade Promotional Management) developments for what if planning workbook, data which is coming from CBP system.
• Created the real time cubes for TPM tool and then Aggregation levels, input queries for the Analysis office workbook.
• Converted the BEX queries and work books related to Planning to the Microsoft Analysis office reports.
• Extensively worked with the FOX coding.

Confidential, California

BI/BO/HANA Consultant

Technologies used SAP HANA 1.0 SP8, BW 7.5 SP7, Microsoft Analysis office 2.1, SAP BO 4.1 SP6SAP BODS 4.2 SP1, Tableau 9.3

Responsibilities:

• Successfully implemented and designed the solution in bringing the Inventory flow from the SAP HANA real time to BW by creating the views using open ODS View and then by connecting these to BEx queries. This is extensively with HANA Live.
• On top of BEX queries created the Microsoft Analysis reports and BO -Webi reports.
• Specially designed and implemented the critical logic in bringing the Stock in Transit information from SAP HANA to BW, then to Microsoft Analysis office reports and BO -Webi reports.
• Completely designed and implement the flow for Plant maintenance flow from SAP R/3 to BW and then created the reports for comparing Planned, Actual costs and deviations by cost element and G/L Account.
• Enhanced the Plant maintenance datasources (0PM OM OPA 1 and 0PM OM OPA 2) for additional requirements in the BW reports.
• Completely worked with the flows for quality Management by creating the customer complaints and production reports.
• Worked with FI-GL, QM, WM and Cost center accounting Modules explicitly with BW on HANA implementation.
• Worked with the users directly in requirements gathering, created detailed design documents based on the FD’s.
• Created Attribute, Analytical and Calculation views as part of customer complaints, quality management and Inventory related reports. Designed Calculation views using SQL scripts.
• Involved in HANA sidecar implementation for developing the inventory reports (especially in Stock in Transit) using SAP SLT.
• Created Process chains and done daily activities related to BW support (PC fixing, process improvements, data corrections, report issues, users etc..).
• Worked extensively with RFP's and RICEF's for Inventory management.
• Extensively worked with the SAP MI (Manufacturing)with HANA.
• Very Good experience with Agile methodology.
• Extensively worked with the BO Webi reports scheduling.

Confidential, New York

BI/BO/HANA Reporting Lead

Responsibilities:

• Determines the size and scope for a suitable data solution in BIBO/HANA projects based on the identified business requirements.
• Provides guidance and advice to Sales Executives, Pre-sales and Solution Architect resources on the data approach in BI/BO/HANA projects.
• Created complex Calculation views by using SQL script and Graphical Interface.
• Created BO- webi reports directly on calculation views of SAP HANA.
• Completely design the SFC and sales marketing reports as a BI Architect.
• Works with project managers, offshore and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.
• Leverages knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Prepared project deadlines for BI/BO/HANA reports objects and updating daily with status.
• Prepared the functional documents in the area of SFC (Skills future credits), PLMS, WTSmailer and sales and marketing reports for the CRM application.
• Prepared technical design and developed the BEX queries and BO - webi reports for the SFC, PLMS, WTS mailer and sales and marketing reports.
• Develops a collaborative working relationship with clients.
• Developed webi reports and dashboards from SAP and non - SAP data source (ex: oracle).
• Involved in the Creation of Dashboards with the dynamic visibility of the components according to user requirements.
• Commonly used Components Line chart, column chart, pie chart, score card, combo box, bar chart, Stacked bar chart, Image component, Rectangle, Label, Radio Button, Query Prompt Selector, Query Refresh button.
• Technically designed and created the cubes, multiproviders, DSO’s and Transformation’s by doing mapping between CRM and BW systems.
• Connected the CRM and BW through CRM adapter via push mechanism.
• Evaluated statistical performance using BW Statistics for optimization. Improved data load and query performance by using BI Accelerator (BIA), Compression, Aggregates, Indexes, optimizing Data packet size.
• Involved in data source enhancements for agreement, claims and business Partner using CMOD.
• Tested all query performance using RSRT debug mode and executed.
• Worked on writing baseline configuration, unit test, string test and integration testing scripts and uploading and executing in SAP Solution manager & HPQC.
• Created the process chains and defined the strategy for automating the daily loads and monthly loads as well as yearly loads.
• Suggested SCI (code inspector)tool for code reviewing in SAP BI routines to follow code guide lines as per SAP.
• Involved in performance ratings and reviews to the team members.

Confidential, New York

Team Lead

Responsibilities:

• Created SAP HANA modeling views such as Attribute, Analytic Views and Calculation Views as part of information modeling for the finance module.
• Created variables Input Parameters, restricted and calculated measures including various aggregation types such as Min, Max, and Sum etc.
• Followed best practices from SAP for designing the views to give better performance.
• Worked extensively with SQL scripting using calculation views and attribute views.
• Responsible for the offshore deliveries for LATAM BW support and leading the offshore team.
• Responsible for all the supporting activities like monitoring, PC fixing, incident handling and enhancements.
• The main supporting activities are Monthly MEC for LAS and LATAM, proposals preparation (RFP's)for the new CR's as well as for tickets related to MEC. This involves budgeting, planning and execution.
• The main flows involving are APO (SNP and DP flows), CRM, Plant maintenance, cost center accounting and BPS flows.
• Gathers business requirements from key stakeholders and translate them to a comprehensive data solution design using multiple products.
• Determines the size and scope for a suitable data solution in BIBO/HANA projects based on the identified business requirements.
• Works with project managers, SAP’s offshore and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.
• Worked extensively with CO-PA extractors (1 CO PA CCA and 1 Co PA COEP).
• Extensively created the BEX reports using query designer to execute in BEX Analyzer.

Confidential

Consultant

Responsibilities:

• Developed queries for sales and marketing reports by extracting from non-SAP system (sales force) through SAP BODS. On top of BEX queries created BO Webi reports and Analysis office reports.
• Created Interface for connecting the Salesforce data and BW.
• Created SFE webireports using Bex queries by getting the data from BPC system as well from BW system.
• Created remote cube in BW for extracting the BPC comments.
• Created infoobjets and Infoproviders, process chains for Sales and Marketing flow as well as SFE.
• Involved in report requirements gathering.
• Created detailed design document.
• Involved in testing.
• Created flat file format for loading the hierarchies.
• Created the transports for all the objects in SAP BI.
• Having good Idea and worked on ordered to cash process.

Confidential

Senior Consultant

Responsibilities:

• Extensively worked with the SAP WM (Internal and external orders).
• Worked extensively with the Work management (Unplanned meter readings and disconnection of electricity and Gas).
• Worked extensively with the SAP CR&B (Customer Relations and Billing) Billing and invoicing.
• Created the business master data and business partner for SAP CR&B.
• Defined Billing rates as part of SAP CR&B billing master data construct.
• Flat file format creation to upload history data in APOBW.
• Create a customized cube in APOBW to upload history data.
• Transfer of history data to planning area.
• Calculation of forecast in APO.
• Create a new or customized cube in APO BW for uploading the planning data.
• Transfer of planning data to BI by generating export datasource.
• For the same we have to create the customized characteristics and key figures in BI.
• Creation of a new cube in BI to extract the planning data from APO BW.
• Creation of the queries in BI related to demand planning.
• Ability to compare and analyze demand forecast versus actual sales.

Confidential, Philadelphia

Senior Consultant

Responsibilities:

• Responsible of BI Design and Development
• Worked on User Workshops and presentations for FI, HCM and PTP areas
• Worked on Technical Documents to help start with Blue Print preparation
• Worked on Reviewing FS and developing TS for the BI developments
• Developed Back-end Technical Design Documents for FI-AP, FI-AA, CO-PC
• Working on BI Content Installations and Enhancements.
• Involved in creation of Info Areas, Info Objects, Info Cubes, and DSO’s, write Optimized DSO and created required Transformations and DTP to load data into Data Targets.
• Uploaded Master Data and Transaction Data from Different Source systems.
• Involved in preparation and review of Unit Test Plans & Documentation.
• Designing and mapping source and target structures to load transactional data and master data.
• Maintained routines for required objects.
• Extensively created the BEx reports in BEX Analyzer.
• Involved in transporting the cubes, Transformations and Multi Providers from Development to Quality system.
• Created Process chains for Master data and transaction data loads.

Senior Consultant/Incident Manager

Confidential

Responsibilities:

• Worked extensively on BI 7.0.
• Daily responsible for monitoring of loads and process chains.
• Responsible for timely handling of tickets using service desk and providing value added solutions with highest customer satisfaction.
• Responsible for successful completion of daily data loads from different source systems (R/3, APO, BPS and ORACLE). From APO, we are extracting Demand planning data, SNP data.
• Monitored the BIA performance for production system.
• Involved in flat file loading, the files which are coming from different countries and from projects.
• Extensively worked with the BW authorizations.
• Involved in Change requests for reporting changes.
• Extensively worked change management using HP service desk, Service manager and BMC remedy for the change requests as well as supporting tickets.
• Responsible for the delivery of complete BI Consumer lifestyle system as an Incident manager.
• Involved in performance tuning for data loads and queries.
• Involved in Mass Printing engine activities.
• Extensively Worked on BIA or BWA (Business Intelligence Accelerator). Worked on BWA administration and its tasks related to "monitoring" as well as proposing of creating the index to the necessary data targets.
• Worked on Cristal and Xcelsius reports.
• Created monthly, quarterly and annual reports for P&L, Cash Flow and Balance Sheet.
• Created Static views, Analysis views and KPI queries for financial cubes.
• Worked extensively with cell editor.
• Worked with Solution manager.
• Involved in Unit Testing.
• Involved in partitioning of cubes.
• Developed queries using filters, Restricted Key Figures, Calculated Key Figures variables, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Created structures for a query in the report.
• Extensively created the BEx reports using query designer in BEX Analyzer.
• Involved in preparation of system documentation
• Responsible for publishing the Query cook-books as per created queries.
• Extensively worked and supported BW Integrated Planning (IP), for the Finance loads related to monthly, quarterly and Yearly activities. Where extensively created the Planning filters, planning functions, Planning sequences and Data slices for the planning queries related to the Finance sector of Philips Consumer lifestyle.
• Extensively set the locking mechanism for the BW-IP real-time cubes.
• Created multiple planning queries for EU,AP and US regions for Retail -CPG practice.