SUMMARY:

• Total 10+ yrs SAP experience with 3 yrs in SAP R/3 Abap/4 development and 19 yrs in SAP BW/BI.
• 18 yrs of experience as Techno functional consultant in implementing SAP HANA, SAP BW ( BW 7.5,7.4,7.3, BI 7.0, BW 3.5), SAP BPC, SAP ABAP/4, SAP BOBJ, SAP BO (4.1, 4.0, XI3.1), SAP BODS, HANA Live, SAP ECC and SAP Lumira projects.
• Modeled different solutions based on side - car HANA approach, BW on HANA and native Hana Models including data provisioning using DXC, SLT and BODS.
• Worked on SAP Native HANA, HANA (side-car scenario) & BW on HANA.
• Worked on design and development of reporting on S/4 HANA Finance (Month-end & Historical Data).Good understanding of all aspects of integration with SLT and BO Data Services 4.0. Good knowledge on HANA Attribute, Analytical and Calculation View.
• Knowledge of HANA scripting and ability to merge both SAP and Non- SAP Data. Worked 6 full life cycle BW/BI implementations.
• Experienced Sr. SAP BI Consultant & Architect who has successfully led project teams from 4- 15 resources from requirements gathering through to implementation and support.
• Lead and worked with teams on an Onsite-Offshore model.
• Worked on SolMan 7.1 (Solution Manager) and ChaRM (Change Request Management) for all the CTS (Change & Transport systems) to move objects within environment.
• Worked on integration between SAP Fiori/UI5 and SAP BI Business Objects and SAP Fiori/UI5 &NetWeaver Gateway Expertise.
• Fiori/UI5 expertise: ECC HCM Apps, Logistics & MM Apps, System Landscape, Architecture, SSO, Security Set Up, Gateway configuration.
• Fiori Package Configuration on SAP Gateway & Backend ECC App Configuration Worked on 7 BI 7.0 Upgrade Technical and Functional Upgrade projects upgrading BW2.1C to BW 3.0(at Pratt and Whitney),2.1c to 3.5( SAP NetWeaver '04) (at Avid Technologies) and BW 3.1c to BI 7.0( SAP Netweaver 2004s R1 SP8 at IBM) and BW 3.1 to BI 7.0 NW2004s.
• Extensively worked in SAP BW-CRM and reporting, data warehouse data analysis SAP BW/BI:
• Expertise in DataModelling creating infoproviders, DSO(ODS), Multiproviders and Infosets. Extraction from COPA, FI, SD, MM, APO(SCM), SRM, CRM and FI-SL modules.
• Experience with Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP data extraction, loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
• BEx -Reporting - Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries and Web application designer, Web Items and Web Reports.
• Also experience using Report Painter in R/3 creating sever FI/CO reports.

WORK EXPERIENCE:

SAP BI HANA Consultant

Confidential

Environment: SAP R/3 ECC 6.0, SAP S/4 HANA, SAP HANA SDI, Sybase IQ, SAP CRM 7.3, BI 7.5, BI 4.1

Responsibilities:

• Worked on a SAP BW 7.5 upgrade and BW on HANA Database Migration to BW 7.5 BW on HANA.
• Defined design standards and best practices of building models over HANA.
• Successfully migrated 15 TB Oracle system to HANA using downtime - minimized approach.
• Primary liaison with SAP during ramp-up, responsible for all OSS communications and resolutions. Involved in Pre and Post migration tasks for DMO.Performed pre-validation steps.
• BW to HANA migration Readiness Check.
• Worked on the HANA conversion to SAP HANA-optimized DSOs and cubes (InMemory cubes) after system migration. Migrated existing info providers to HANA optimized providers.
• Involved in architect, design, development and maintenance of HANA data models (Attribute view, Analytical View and Calculation views), HANA Security, data provisioning thru SLT, Import, export and migration.
• Assists in all phases of implementations as needed including analysis, migration, testing, and training/knowledge transfer to end-users, go-live assistance, and post implementation support.

SAP BI HANA Consultant

Confidential, New Haven, CT

Environment: SAP R/3 ECC 6.0, SAP HANA1.0, SAP HANA SDI, Sybase IQ, SAP CRM 7.3, BI 7.4, BI 4.1

Responsibilities:

• Worked on analysis, strategy and archiving BW data using the BW to Sybase IQ NLS (Near - line storage) option for Cubes & DSO, Identifying the target BW InfoProvider objects best suited to be archived. Work with Basis team to Identify the NLS archiving criteria.Built BW Process chains to move the data.
• SAP BW 7.4 upgrade and BW on HANA Database Migration to BW 7.5 BW on HANA.
• Defined design standards and best practices of building models over HANA.
• Successfully migrated 10 TB Oracle system to HANA using downtime-minimized approach.
• Primary liaison with SAP during ramp-up, responsible for all OSS communications and resolutions. Involved in Pre and Post migration tasks for DMO.Performed pre-validation steps.
• BW to HANA migration Readiness Check.
• Checks of ETL ABAP code and fixed outstanding issues in all environments.
• Gathered benchmark performance statistics for load and activations.
• Performed pre-activity steps in all environments and Involved in HANA sizing.
• Used Delta Merge process in the database to optimize data loading and help improve the execution performance of query processing on SAP HANA using Merge types Auto merge & Smart merge
• Assessment of current BW environment and provided over all environment and functional area specific data flow optimization guidelines.
• Used SAP HANA SDI (Smart Data Integration) to extract structured/unstructured data from different source systems into HANA. Worked on the DP (Data Provisoning) Agents that hosts all the SDI Adapters and acts as the communication interface between HANA and the Adapter which establishes the link between SAP HANA and the external source.
• Responsible for architecture, preparing system for BW on HANA upgrade including system prep and cleanup activities.
• Involved in preparing the BW environment for Pre & Post Migration steps to HANA.

Confidential

SAP BI HANA Analytics Consultant

Environment: SAP R/3 ECC 6.0, SAP S/4 HANA, SAP HANA SDI, Sybase IQ, SAP CRM 7.3, BI 7.4, BI 4.1

Responsibilities:

• Working on the Solution Architecture for Micron's SAP HANA BI FMS (Facilities maintenance System) project for developing Notification, Cash Flow & Work order reporting (Customized BW product) as per end user legacy Maximo reporting solutions.
• SAP S/4 HANA Functional knowledge in areas of Finance, Operations, Purchasing, and knowledge of the associated tables and transactions.
• Re - developing and re-design the Data Models, BW Cubes, ODS's, Configuration, BeX& BOBJ queries in the BI 7.5 system.
• Worked and have experience in SAP S/4 HANA version 1709 FPS02 specifically with development skills in Embedded Analytics - CDS Views Development.
• Lead, Mentor, and coach the offshore BW HANA team of professionals.
• Worked on HANA Embedded Analytics. Integrated CDS Views with SAP Analytics cloud, Analysis for office, BO - Webi&Fiori.
• Worked on how to integrate CDS Views with Analytical Consumption Tools including SAP Analytics Cloud, Analysis for Office, Business Objects - Webi, and Fiori Tiles.
• S/4 HANA Embedded Analytics Tools - Query Browser / Query Viewer and how to identify standard SAP Views available to satisfy Analytical Reporting requirements
• Enhanced the standard CDS Views (BASIC, COMPOSITE, CONSUMPTION) delivered by SAP in order to fulfill customer specific reporting requirements.
• Develop & led the project. Establish & develop relations with the client.
• Participated in pre-Sales activities..Worked on preparing the RFP for S/4 HANA Embedded Analytics.
• Develop the tools and methodologies as per the client needs and expand the offering portfolio.
• Working on the POC for the client's BW to Azure Data lake data extraction.

Sr. SAP HANA Consultant

Confidential, Sacramento, CA

Environment: SAP R/3 ECC 6.0, SAP HANA1.0, Salesforce.com, SCM 7.0, BI 7.4, BI 4.0, BI 4.1, Analysis for Office, BODS, BO Design Studio 1.5.

Responsibilities:

• Worked closely with stakeholders & users in the gathering and validation of requirements and ensuring that delivered solutions meet and exceed stakeholder expectations.
• User requirement analysis and development for COPA, Logistics and FI reports and created LSA ++ dataflow. Responsible for analyzing the requirements and identifying the gaps.
• Involved in ETL Based replication to provision the data from ECC to HANA system through BODS
• Involved in providing solutions to the complex requirements using BW 7.3 Infoproviders (Transient Infoprovider, Virtual Master Data InfoObjects, Composite Providers, Multiproviders) for HANA Models and resolved HANA error's like data type mismatch, numeric overflow, etc.
• Involved in identifying the area to improve the performance by utilization of HANA In - Memory computing feature, Column store, Calc Engine features.
• Involved in Optimizing the Design of the data flows in BW, HANA for the requirements.
• Involved in Planning of data load activities runbook preparation. Created SQL, SQL Script, CE Functions.
• Worked on Users requirement for development of BOBJ WebI (Web Intelligence & also Analysis for Office) reports and Variants for SAP as well as Non- SAP data sources.
• Collaborate with onsite/offshore team with respect to all ongoing customer deliverables.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical issues.
• Evaluating existing standards and processes and recommending and implementing new standards and processes on a proactive basis.
• Involved in building a set of Webi pricing reports and Dashboards for Management and Pricing team to do what if Analysis scenarios in Product Pricing.

SAP BI HANA Consultant

Confidential, Mason, MI

Environment: SAP R/3 ECC 6.0, SCM 7.0, SAP HANA 1.0, SAP S/4 HANA(Finance), BI 7.3, BI 4.0, BI 4.1, SAP Fiori/UI5, Analytics for Office, Lumira, BO Design Studio 1.5.

Responsibilities:

• SAP BW upgrade and BW on HANA Migration.
• Defined design standards and best practices of building models over HANA.
• Successfully migrated 56 TB Oracle system to HANA using downtime - minimized approach.
• Primary liaison with SAP during ramp-up, responsible for all OSS communications and resolutions. Involved in Pre and Post migration tasks for DMO.Performed pre-validation steps.
• BW to HANA migration Readiness Check.
• Checks of ETL ABAP code and fixed outstanding issues in all environments.
• Gathered benchmark performance statistics for load and activations.
• Performed pre-activity steps in all environments and Involved in HANA sizing.
• Assessment of current BW environment and provided over all environment and functional area specific data flow optimization guidelines.
• Responsible for architecture, preparing system for BW on HANA upgrade including system prep and cleanup activities.
• Involved in preparing the BW environment for Pre & Post Migration steps to HANA.
• Conversion to SAP HANA-optimized DSOs and cubes (In memory cubes) after system migration. Migrated existing info providers to HANA optimized providers.
• Involved in architect, design, development and maintenance of HANA data models (Attribute view, Analytical View and Calculation views), HANA Security, data provisioning thru SLT, Import, export and migration.
• Assists in all phases of implementations as needed including analysis, migration, testing, and training/knowledge transfer to end-users, go-live assistance, and post implementation support.
• Included a mix mode SAP HANA and SAP BW on HANA approach where there were standalone HANA models, HANA models exposed as Virtual Providers in SAP BW and finally classical BW on HANA models. The latter made use of in Memory Optimized DSOs exposed thru Multi-Providers and BEX Queries and use of in-memory optimized cubes when aggregating data with different granularity
• Performance Optimization techniques, HANA Stored Procedure calls by Data Services
• Developed HANA models and BODS flows for Phase II and Phase III.
• Reports Developed in this Project: Customer Black log Summary Report, Customer Touches, Billing Summary, Opportunity Summary, Sales summary, New Customer Mix / Growth, Expense Reports for QTD and YTD, P&L analytics on monthly, quarterly, year to date basis.
• SAP S/4 HANA Functional knowledge in areas of Finance, Operations, Purchasing, and knowledge of the associated tables and transactions.
• Worked on identifying SAP S/4 HANA reporting capabilities and effort to migrate current operational reports in BW to be supported by S4 HANA.
• Worked on Confidential 's ERP Global Systems in to EHP7 as a prerequisite to start Simple Finance Migration under S/4 HANA on premises edition and used S/4 HANA CDS (Core Data Services) for creating Analytical Views for Webi Reports off Finance data.
• Knowledge of how to integrate CDS Views with Analytical Consumption Tools including SAP Analytics Cloud, Analysis for Office, Business Objects - Webi, and Fiori Tiles. ills.