SUMMARY:

• Confidential, a SAP BW, BO and HANA Manager / Architect, holds a bachelor’s degree in Mechanical engineering and has experience in end - to-end SAP BW/BO and HANA Implementation.
• He has around 13 Years and 3 months of experience in SAP BW/BO, SAP HANA and SAP BW IP implementation.
• He is a SAP Certified Application Associate - SAP HANA 1.0.
• He has sound knowledge in designing end-to-end solutions, especially in the area of Order-To-Cash / Recording-To-Reporting, Sales, marketing and purchasing using SAP BW / BO, SAP BW -Integrated Planning and SAP BW Accelerator. He also has hands on experience in reporting tools like Tableau, BO tools such as Design Studio, Universe Designer, Xcelsius, Data Federator, Data Services and BO Explorer.
• He has worked in extracting data from SAP ECC, SAP CRM, MS SQL Server and SAP APO to BW and then also worked on moving the data to BWA for improving reporting performance.
• His experience also includes SAP ABAP development; ECatt based testing and SAP BW Accelerator integration with SAP BW. He was part of the BI/BW COE team and was involved in SAP BW/BO/HANA proof of concept creation.
• He led the SAP HANA COE with 25 people in Confidential & Confidential and delivered two POCs successfully.

SAP TECHNICAL:

• SAP HANA, SAP HANA XS, SAP Native HANA SQL Scripting, SAP BW on HANA
• SAP HANA Analytical / Calculation views
• SAP HAN SQL Procedures
• SAP BW 3.5 / 7.0 / 7.3 / 7.4 , SAP BW Integrated Planning, SAP BW Accelerator
• SAP Business Explorer Tools
• BEx Query Designer
• BEx Analyzer
• BEx Web Application Designer
• SAP BW - Business Objects Integration (XI R3, BO 4.0 / 4.1)
• SAP Design Studio, Web Intelligence and Crystal reports
• SAP Lumira
• Data Services - BWA Integration
• SAP Analysis for Office - Excel and OLAP
• Dashboard Design (Xcelsius) - SAP BW Integration
• BO Universe Designer and Information Designer
• Data Federator - SAP BW Integration
• Data Services - SAP BW Integration
• BO Explorer (Polestar)
• SAP BPC - BW Integration
• SAP BO SDK
• SAP BW - Source system Integration
• SAP ECC (Sales, MM, Finance, COPA, Controlling, QM etc.,)
• SAP CRM (Leads, Quotes, Opportunities, Interaction Center, Contracts, Ibase, Activities etc.,)
• SAP HCM (Employee, Payroll etc.,)
• SAP APO (SNP, DP etc.,)

PROFESSIONAL AND BUSINESS EXPERIENCE:

SAP BW on HANA/SAP HANA Architect

Confidential, Hershey, PA

Responsibilities:

• Working as an architect for the designing five different complex BW and HANA dataflows involving creation of BW ADSOs and HANA Calculation views
• Working on extracting data from SAP CRM for Funds, Campaigns in to SAP BW and creating data flows based on that.

SAP BW on HANA/BO Architect

Confidential, Southfield, MI

Responsibilities:

• Worked as an architect for the consolidation of multiple BI instances in to one BW 7.5 on HANA with BI 4.2 instance by converting the existing BW InfoCubes, DSOs in to ADSOs and creating new BO WebI reports / Power BI dashboards based on user requirements.
• Migrated 100+ BW 7.0 data flows to BW 7.5 with new ADSO design and improved architecture
• Designed and Developed 20 WebI reports and two Design studio dashboards for Sales, Delivery and Inventory business areas based on BW 7.5 backend
• Designed and Developed a universe and 5 WebI reports on top of SQL Server database tables for QM business area
• Achieved the automated delta load from BW -> SQL and used Redwood scheduler to sync the loads in BW and SQL to make sure that SQL loads are scheduled only after the completion of BW loads
• Lead the whole development team including contractors and client members and delivered the objects on time
• Developed HANA analytical and calculation views and created WebI reports on the same.
• Served as the SPOC for the design and development of BW - BO objects for this whole project

Confidential

SAP BW IP / BO Architect, St Louis MO

Responsibilities:

• Worked on complex BW IP scenarios and fixed the issues raised by the users after analyzing the existing planning data flows
• Developed complex BW / BW IP scenarios based on customer requirements and delivered it on time.
• Developed Design studio dashboards for Sales Planning requirement to replace the existing BEx Web template.
• Created WebI reports and Design Studio dashboards on Native HANA analytical and calculation views.

Confidential

HANA & BW-BO Lead / Architect, Columbus, OH

Responsibilities:

• Performed analysis, design, development, and deployment activities for complex BI technical solutions and provided a development buffer during peak capacity.
• Involved in leading the monthly BI Release wherein I had to validate and combine the cutover plans from all the developers for their changes and then coordinate with the Transport team, developers and users to get their tasks completed.
• Worked on customizing the BO SDK to come up with a user defined BI Launchpad experience.
• Lead the Onshore team (US), offshore team (China, India - Mumbai) and Vendor team (Deloitte and KPIT) on their development activities and host weekly calls to get their status. Also helped them if they get stuck during development.
• 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.
• Involved in preparing SAP BI roadmap for the organization involving BW / BO upgrade and moving towards BW on HANA.
• Worked on creating in memory cubes in BW on HANA, DSOs in BW and composite provider (both using Analytical indexes and workbench). Created WebI reports on top of these cubes and composite providers.
• Designed and developed the complex highly visible Design Studio for Statistics (BEx and BO), BI Developer performance (Service Now data), Finance, SAM (Order-To-Cash) and Services using Agile project methodology which involved repeated requirement changes and scope changes with the already finalized timeline. The dashboard included requirements like custom authorization using a flat file, Chart with dynamically changing dimensions, chart with dynamic scaling and cross tabs with different formats (used different .css logic) and toggling between chart and table.
• During design studio dashboard development, followed performance best practices like reducing server calls by refreshing the queries only during BEx variable value changes and optimum BEx query design to make sure to reduce the number of queries.
• Created Lumira story boards based on pricing team requirement to predict future outcomes in pricing and forecast as per the changing pricing market situations.
• Created Tableau dashboards, WebI reports, Crystal reports and Design Studio dashboards on Native HANA analytical and calculation views. Also developed stored procedure in Native HANA using SQL script.
• Worked on extracting data from SAP CRM for Leads, Quotes, opportunities, Service orders, Ibases in to SAP BW and creating data flows based on that.
• Worked on creating the Booking and billings report by integrating data from Sales (SD), Billing and Purchasing (MM) areas. Served as the SPOC for this report data flow for any queries / issues on this report.
• Worked on Sales and Price planning projects using BW IP functions like Repost, Custom Planning function and FOX formula etc., For Price planning, designed planning on a DSO using custom data slice to allow planning only for specific time period. For Sales planning comments requirement, used characteristics of length 250.
• Came up with the most optimum method to calculate the effort / capacity of each developer and improved the overall delivery outcome from the developers by implementing the new method.
• Bridged the communication gap between the developers and the report users.
• Lead the BW 7.4 upgrade, BO 4.1 and BO 4.2 upgrade by coordinating with developers, testers and Basis team.

Confidential

BW-BO & HANA Lead / Architect, Jackson, MI

Responsibilities:

• Involved in the planning and strategizing the BO 4.1 migration process
• Came up the step by step process for migration project
• Prepared the Training material and involved in training the end users in BO 4.1 post migration process.
• Created Lumira story boards for the procurement team to predict their future purchase needs based on average increase in new power connections for a particular area.
• Once they got HANA, worked with the teams which use Oracle data to report on BO to move their data to HANA and then create new Attribute / Analytical views, WebI reports, Crystal reports and Design Studio Dashboards. Also worked on creating new stored procedures in Native HANA based on their updated requirements for the Plan-To-Make / Procure-To-Pay areas.
• Worked as a BO admin team member by monitoring the BO system performance and optimized the same by working on the load balancer project.
• Worked on creating in memory cubes in BW on HANA, DSOs in BW and transient provider in ECC. Created WebI reports on top of these cubes and transient providers.
• Used HPQC to perform the testing and managed the testing team for this whole project.
• Extensively used SLT as a data provisioning tool to bring in data from legacy DB to HANA and created complex SQL based Calculated views.

Confidential

BW-BO Lead / Architect

Responsibilities:

• Involved in the planning and strategizing the BO 4.1 upgrade
• Performed initial assessment of client’s current BO Reports and analytics architecture
• Created POCs in Dashboard Design (Xcelsius) and WebI 4.1 based on their existing complex Prod reports to explain the features of BI 4.1 (more visual capabilities, better performance and ability to directly consume BEx query skipping the Universe layer).
• Created POCs in moving data from current DB to HANA using SLT based on HANA Side car approach as this client wanted to use HANA in parallel to their current DB

Confidential

BW-BO Lead / Architect

Responsibilities:

• Acting as the Architect for the BW-BO design and worked as a SPOC for the BO report delivery
• Designed and architectured 16 WebI reports and three dashboards in SAP BO 4.1. Also shared the work by taking up the complex reports so that the project could be completed on time.
• Managed the BO offshore team and delivered all the needed dashboards and reports on time

Confidential

BW-BO Lead / Architect, BWA Specialist, Milwaukee, WI

Responsibilities:

• Trained the internal WE BI team on the best practices of using BW 7.0 data flows to increase load and report performance.
• Acting as the single point of contact from Confidential side on the BW-BO design and successfully got the Sign off of the BW design for the New GL / Real time FERC project. The role is a combination of a Developer and an Architect.
• Provided quick possible solutions for the client's ( Confidential ) top BW Reporting Usability issues and included them in the new design.
• Worked in the development phase wherein I have provided solutions for complex issues like BW Custom extractor for bringing the Ad-hoc Order groups from ECC to BW.
• 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.
• Created a BW IP based on Status tracking-based planning scenario using copy, formula and repost planning functions for Bottom-up planning.

Confidential

BW-BO Development team lead, Cleveland, OH

Responsibilities:

• Worked in extracting data from SAP QM, SAP SD and SAP FI to BW for reporting purposes.
• Associated with the implementation design, development and building of BI objects (that included all associated ETL process objects and data loading).
• Assisted in the design of SAP extract structures and Custom Exit BW variables using ABAP programming where ever needed.
• Created prototypes for hybrid provider and semantically partitioned providers which played a vital role in selecting a design approach for the whole project.
• Worked on extracting data from MS SQL Server in to SAP BW and creating data flows based on that.
• Worked on the Sales and resource planning requirements using BW IP. Used FOX formula, Characteristic relationship and Custom Planning function using ABAP etc., in this project.
• Extracted SNP and DP data from SAP APO in to SAP BW and created reports combining inventory data and APO data.
• Created complex BW IP Sales planning Web templates containing multiple tabs using FOX formula for a requirement to copy records using a condition based on a key figure.
• Supported BI users on their questions or concerns pertaining to reporting or general BI use.
• Created best practice documents on customization of BW Data sources and user exit variables.
• Created WebI reports, Crystal reports and Advanced Analysis workbooks based on BW queries as per client requirements for the Plan-To-Make / Procure-To-Pay areas.
• Associated with the project phases like design, development, cut over activities and testing.
• Used HPQC to perform the testing and performed Unit test / System Integration Test before releasing any change for UAT to the user.