SUMMARY:

• 14 Plus yrs. of IT experience with last 12 yrs. in SAP BW/BI & Business Objects (BO) as Architect/Technical Lead, 3 plus years of HANA modeling with 2 end - to-end BW on HANA project implementation experience, 1 BW on HANA migration Project and one S/4HANA Analytics Project.
• 5 full-cycle SAP BW/BI implementations, Upgrade projects, Application Development/ Support projects, migration project, Worked on SAP Integrated Planning application.
• Experienced SAP HANA Analytics professional in design, implement and deploy SAP HANA solutions for customers across industries, including SAP S/4HANA, SAP BW/4HANA, SAP Enterprise HANA and SAP Analytics solutions (SAP BOBJ, SAP Analytics Cloud)
• Business Process knowledge plus hands on experience across BI/BW solutions for Logistics (Sales, Inventory, Purchasing), FI-CO, SCM (Procure to Pay, Order to Cash, Logistics Capacity Planning, Spend Analysis), APO (Demand Planning and Supplier network planning), SAP IS Utilities, CRM (Warranty claims, Service Orders), CS (Customer Service), QM, PP, PS (PS (Project Systems), TM (Transportation Management), WM, Dispute Management, Spend Performance Management, VISTEX modules.
• Total IT experience in requirement gathering, technical analysis, estimation, solution design and architecture, development & implementation of business intelligence applications for FMCG, Manufacturing, Telecommunications, Electronics, Automobile, Petrochemicals, Engineering/service, Food Processing and Enterprise Software Industries.
• ABAP development working experience on User Exits, functional modules, BADI and CMOD enhancements and good ABAP Debugging skills.
• Worked at customer locations India, USA, Europe, Saudi Arabia & Egypt in requirements gathering and implementation phases of the projects and worked closely with business process leads with shared responsibility to define/manage the scope of Data and Analytics Workstream (Reporting requirements, Data extraction, cleansing, transformation, mapping, load)
• Worked as a Team lead for projects of onsite and offshore model, closely worked with the Client, Co-ordinated with offshore team.
• Using Agile & Scrum methodologies, leveraging agile methodologies in SAP. Meetings with business for quarterly and yearly projects to be implemented, creating Epics and Stories. Actively Involved in Sprint planning, backlog refinement and release management activities using JIRA, AgileCentral tools.
• Experience with Proposal building activities and POC Creations.
• Experience in SAP BW 7.5/7.3/7.0 on new features like ADSO, Composite Providers, Semantic Partitioning Objects and SAP BW 3.x
• Experience with SAP BW on HANA, worked on mixed scenarios using both HANA as data mart + BW on HANA and consumption of HANA models in BW and BW models in HANA.
• Experience in Hybrid SAP BW S/4HANA Modeling Scenarios.
• Implementing SAP BW on HANA specific modelling like Advance DSO, Open ODS View, Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning.
• Data extraction, in multiple functional areas, from SAP source systems such as Confidential, S/4 HANA, CRM and from non-SAP systems.
• Implemented BW powered by HANA solutions using LSA++ Architecture.
• Experience & Knowledge on migrating from systems on SAP BW >= 7.0 on Any-DB to SAP BW on HANA or SAP BW4HANA environments.
• Strong experience in SAP BW Support, maintenance activities & implementations including data modeling, extractions, data staging, loadings, transformations, and reporting
• Experienced in using BEx Query Designer for OLAP reporting and for enterprise reporting.
• Used BW-Intergrated Planning to build planning applications in SAP.
• Implemented SAP BW/BI Authorization/security requirements for data access.
• Used various tools within SAP BW like Open Hub, Information Broadcaster, Precalc Server.
• Knowledge in SAP BPC best practices & involved in supporting activities.
• Experience in developing HANA data models using Attribute views, Analytical Views and Calculation Views (Both Graphical & SQL script based), developed stored Procedures.
• Worked with Eclipse based development Environment of HANA 1.0 and integration of HANA, Confidential, BW & BO.
• Experience in data modeling, schema management, content import & export, data provisioning technology including SLT, Data Services and SAP HANA Enterprise Information Management (SDI/SDQ), used Hana Smart Data Integration (SDI), various Adapters to get the data from Source Systems.
• Good Experience in Performance tuning the HANA Information models.
• Interacting with key business stakeholder, understand existing reporting Capabilities and created requirement specification document, Design and develop solutions in using Business objects (BI 4.x) reporting Tools like Web intelligence (WEBI), Information Design Tool (IDT), Xcelsius, Design Studio 1.5, Lumira 1.25, Analysis for MS Office.
• Experience in Extraction and ETL data flow developments to ensure successful data acquisition from SAP Confidential, Non-SAP sources into HANA through SLT and BO Data Services along with monitoring and debugging of data loads.
• Experience in Configuring and Consuming SAP BW & HANA models in Dashboards and Reporting Tools LUMRIA, Design Studio, Microsoft PowerBI and Integrated SAP HANA with HADOOP.
• Experience integrating Non-SAP applications/datasources with SAP Analytics Cloud for reporting and visualization
• SAP S/4HANA Embedded Analytics based on ABAP Core Data Services ( Confidential ) views.
• Data Migration to SAP S/4HANA in an on-premise using SAP Data Services ( Confidential )

PROFESSIONAL EXPERIENCE:

Confidential, New York

SAP BW/IP Consultant

Responsibilities:

• Used BI Integrated Planning with BOBJ Design Studio in Contracts bookings automation development to Flexibly Change Characteristic Values.
• Helped CA Financial planning and Analysis team by automating the Bookings Consolidation & developed Query in BEx to be consumed by team using SAP Analysis for Microsoft Office.
• Worked on Revenue Recognition ASC606 standard BI Queries to report on Actual and Planned Revenue, Deferred, Unbilled Revenue and Total Accrued value using different rate types.
• Worked on some reconciliation reports, which reconciles the Billings, G/L data and reports to get unbilled, differed revenue information, Contracts and Billings summary report, Billing events information.

Environment: SAP BW 7.3 system, SAP BOBJ Design Studio 1.6 SP6, SAP Analysis for Microsoft Office.

Confidential, San Jose

SAP S/4HANA & BW Analytics Consultant

Responsibilities:

• Executed master and transactional conversion dataloads from Confidential & fixed Issues in this rapid data migration to S/4HANA by Extracting, cleansing, transforming and validating the data.
• S4HANA real time Analytics ( Confidential views): Worked on Virtual Data Model (VDM) developments in Core Data Services ( Confidential ) in S/4HANA.
• Worked on S/4HANA Anlaytics reports based on Confidential views like ‘Sales Analytics Report (Orders-scheduleline-Delivery Analysis)’ & Confidential Report ( Backlogs, Billing & Bookings Report ).
• Reports are developed includes BWoH owned persistence (BWoH as Data Warehouse), Non-BW owned persistence (Embedded BW). Crawl Report is that of hybrid Model report developed to analyze Revenue & Open orders in Current and Prior weeks for same Calender quarter and week combination.
• LUMIRA Dashboard developed for same Crawl data out of BWoH.
• Used Hana Smart Data Integration (SDI), ABAP Adapter to get the data from old BW 7.3 system into BW 7.5 system and HANA Adapter to get the data from S/4HANA system.
• Workbooks created using AFE based on Confidential views & BEx reports created on BW Composite Providers.

Environment: SAP S/4HANA 1610, BOBJ 4.2 (Lumira 2.0 & Analysis for Office 2.4), Confidential 4.2, BWoH 7.5 system

Confidential, Arkansas

SAP BW/HANA/ Confidential Consultant

Responsibilities:

• Created new data models using LSA++ Architecture in BW 7.5 with Advanced DSO, Composite providers.
• Designed and implemented SAP HANA info models for Sale Integrated Reporting solution, Enterprise data management applications using Attribute Views, Analytic Views, Calculation Views, Restricted and Calculated Measures, Input Parameters, Variables, Stored Procedures and SQL script.
• Implemented Dispute Management Reporting Solution in SAP BW.
• Participated in the implementation of VISTEX BW/HANA data models (Green book Query, Trade Analytics Query - Billbacks, Customer Rebates, Sales Incentives)
• Loaded data into HANA table definitions, suspending data loads, resuming data loads using SLT.
• Performed data transformation and load into SAP HANA database from Confidential, SQL Server, Flat files, CSV sources using SAP Business Objects Data Services ( Confidential ) and SAP Landscape Transformation (SLT).
• Performed Error Analysis, Debugging SQL Scripts, and in using SAP HANA Plan Visualizer. Experience in optimizing existing application which is migrated on HANA.
• Developed Confidential jobs, data flows and data store creation and scripts with the platform transformations.
• Built multiple BOBJ Dashboards and Reports using Design Studio.
• Consumed BW Data models & HANA information models in SAP Lumira.
• Helped in several Pre/post Cutover activities & Technical Upgrades.
• Extensively involved in User Acceptance Testing (UAT), Pre-Production testing & Post Production Support.
• Trained multiple Business groups across the various Departments to fulfill complex reporting requirement needs.
• Involved in solving SAP BW BPC related production incidents.
• Team member in re-building the Sales Integrated reporting solution in Hadoop platform using Sqoop, Attunity, Hive, HDFS, Atscale.

Environment: - SAP BW 7.3/7.5 on HANA, SAP BOBI 4.1, SAP Confidential 4.2, SAP Confidential 6.0, SAP HANA 1.0 SP8/SP11, BEx Analyzer, Query Designer, Analysis for Excel, Design Studio 1.5, SAP Lumira 1.31.

Confidential, Indianapolis

Lead Consultant SAP BW on HANA/BOBJ

Responsibilities:

• Gathered and analyzed business requirements to fulfill reporting needs for Inventory, Purchasing, FIGL, COPA, CRM Data models. Involved in Define (Project Preparation), Design (Blueprint), Develop (Realization), Deploy & Transition (Final Preparation, Go-Live & Hypercare Support) phases.
• Enhanced BW business content for Confidential Core Modules (SD, FI/CO, Inventory management, Production planning, Purchasing), and CRM. Written Start Routines, End Routines & one Expert Routine as part of Transformation Logic.
• Developed CRM BW Data models for Service Orders, Service Confirmations, and Opportunities. Enhanced CRM Business content datasources for Service Orders, Service Confirmations, and Installed base.
• Developed WEBI reports for the requirements in COPA & Purchasing and connected source data from SAP BW BEx Queries using BICS.
• Involved and analyzed in creation of WEBI reports with different functionality like cascading prompts, drilldown, Charts, Ranking, alerts and implemented with row level security.
• Created Lumira dashboards using SAP BW BEx Query.
• Involved in working with different database environments PROD, DEV, and QA and migration of the universes and reports using Lifecycle Manager.
• Used LSA++ Architecture in building the data models.

Environment: SAP BW 7.3 on HANA, SAP BOBI 4.0, ECC6, SAP CRM, BEx Analyzer, Query Designer, SAP Lumira 1.20

Confidential

Lead Consultant SAP BW/BOBJ

Responsibilities:

• Conceptualized and worked on critical projects for Confidential & Confidential . Built an impressive record of achievements leading the architectural design and implementation SAP business intelligence solutions. Responsible for New SAP BI Developments in AS, FES, MTWL, MVML (M&M Companies).
• Involved in Data-modelling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for the MM, SD and FI/CO modules.
• Designed the Warranty Analysis data model & Reports in SAP NetWeaver Business Intelligence. Handled various Inventory Management scenarios in BW.
• Provided reporting solutions using BOE XI 3.1 - Universe Designer on top of SAP BEx Queries.
• Architected and developed Crystal reports & Campaign marketing dashboard that measures leads and contacts for different marketing channels. Implemented End to End solution, starting from Universe, to the Web Intelligence dataset layer, to the Xcelsius Dashboard.
• Developed QlikView reports to financial & Sales team which increased the efficiency of reporting and Visual analytics.
• Participated in Pre/Post-Activity Steps, Pre/Post-Validation Steps for Each Environment (Dev, QA & Prod).
• This migration project includes, daily status reports, team meetings, issues handling, portal integration and tests of front-end tools.

Environment: SAP BW 7.3, BI 7.0, BOXI 3.1/4.0, ECC6 (EHP6), BEx Analyzer, Query Designer, QlikView 11.2

Confidential

Lead Consultant SAP BW/BOBJ

Responsibilities:

• Participated in the Design of a new Confidential architecture to replace implementation of SAP Business Content. Managed, aligned and conformed KPI definitions from Legacy to SAP environment. Provided analysis, guidance and direction to Confidential regarding SAP BW.
• Studied the Business processes in existing Confidential system ‘FANAR’ & Completed the design of globally harmonized processes in blueprint.
• Developed Operational reports, based on the Confidential methodology for processes in Procure-to-Pay (P2P).
• Worked on SCM KPIs, BO Xcelsius Dashboard, which includes Demand Planning and Supply Network Planning, related reporting KPI's.
• Worked on Logistics Capacity Planning (LCP), BO Web Intelligence reports

Environment: SAP BI 7.0, BOXI 3.1, ECC6, BEx Analyzer, Query Designer.

Confidential

Senior SAP BW-BI Consultant

Responsibilities:

• Developed Productivity & Deviation reports (Supervisor level reports) related to Customer Service Module. That provided leadership teams with an effective means to analyze the technician productivity rate within the company.
• Developed MPB (Major Project Business) BI analysis reports, The MPB Reporting solution covers the Front-Line businesses and Supply Line businesses and thereby providing full chain profitability view for the business. The used is from following SAP ERP modules: Sales & Distribution, Customer Service, Plant Maintenance, Project Systems, Controlling, Finance.

Environment: SAP BI 7.0, SAP R/3 - ECC6, BEx Analyzer, Query Designer.

Confidential

SAP BW-BI Consultant

Responsibilities:

• Worked on BW report developments in Asset Management, Funds Management reporting
• Worked on the proposal to Integrate Business Objects with SAP NetWeaver BI.
• Dashboard reporting using Xcelsius, Business Objects Web Intelligence for SAP BI.

Environment: SAP BI 7.0, SAP R/3 - ECC6, BEx Analyzer, Query Designer.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Involved in the renewal of Confidential ’s IT platform to bring it more in line with its business needs: Developing new business processes in BW 7.0 by defining new BI objects. Data Distribution: Providing business data to Confidential (Head Office) through Confidential functionality in BW.
• Performance Optimization (Aggregate Definition and Maintenance, DB Tool Support (statistics, indices etc.)). Worked with BEx Web Application Designer, Published BEx Queries/Views using BEx Web Application Designer in Enterprise Portal.
• Participated in development and dataflow of rebate agreement data which is necessary for reporting this information in SAP BW from CRM Rebate Management area in R/3. Used BW-IP to build planning applications in SAP for an Accrual project.
• Created authorizations objects for reporting users.
• Project: Technical / Functional migration of BW 3.5 to BI 7.0:

Environment: SAP BI 7.0, BW 3.5, R/3 - 4.X/ECC6, BEx Analyzer, Query Designer.