SUMMARY:

• SAP technical proficiency with 9+ full lifecycle SAP implementation experience developing and delivering SAP solutions using SAP HANA, HCP, SAP Native HANA, BW/4HANA.
• Delivered SAP Analytics solutions (on premise, cloud based, hybrid), SAP Cloud for Analytics (SAC).
• 5+ years of SAP HANA/BI Project Lead experience, responsible for architecting, building and testing BI, HANA, HANA Cloud Platform (HCP), HDI Containers.
• Strong hands - on project experience delivering BI/Analytics/data warehousing solutions, and in-memory solutions using SAP HANA 2.0 in on premise/cloud/hybrid scenarios.
• Strong experience working on IS- Public Sector: Tax and Revenue Management, FI-CA modules.
• Initiated and lead a performance management team to focus on delivering high quality reports following basics and best practices.
• End-to-end understanding of SAP BO toolsets, SAP Business Objects, Web Intelligence, Analysis for Office and Dashboards, SAP Analytics for cloud (SAC), Tableau, Microsoft Power BI.
• Experience defining systems strategy, developing systems requirements, designing and prototyping, testing,, defining support procedures and implementing best practices.
• SAP functional exposure in SAP FI-CA, Finance, IS-Retail, Supply Chain, AFS, SD/MM, OTC, RTR, TPM.
• Experience working with huge volumes of data, developing HANA tables, views and SAP Data Services Interfaces (BODS) integrating SAP and non-SAP source systems using HANA SQL environment.

TECHNICAL SKILLS:

• Data Warehouse: SAP HANA 2.0, BW/4HANA 2.0, BW - IP.
• Modelling Tools: BW/4HANA Modelling, SAP HANA Studio, WebIDE, Eclipse IDE, SQL script
• Reporting Tools: SAP Analytics for Cloud (SAC), SAP BOBJ, WEBI, AFO, Lumira, Tableau, Power BI
• SAP ETL: SLT/BODS/SDA/SDI (Smart Data Integration), SAP Cloud Platform (SCP) Integration
• Programming Languages: ABAP, CDS

PROFESSIONAL EXPERIENCE:

Confidential, Lake Zurich, IL

Sr. SAP HANA BW Lead

Responsibilities:

• Architected the HANA BW 7.5 reporting solution for Procure to Pay, Record to Report, Order to Cash and Plan to Manufacture, Financials, APO modules.
• Implemented SAP Analytics for Cloud (SAC), delivered stories canvas, responsive, grid, Smart Discovery, custom calculations, groupings, data wrangling, visualizations using charts, maps.
• Oversaw the scope of work which included the project planning, business process mapping, design, configuration, and setup of technical environment.
• Delivered HANA data models, ADSOs, Composite providers, Calculation views, ODP extraction using SAP best practices and naming standards using WebIDE environment.
• Responsible for the Analysis authorizations for BW and BOBJ with SSO.
• Delivered dashboards and visualizations using SAP Analytics for Cloud and Business Objects platform.
• Provide the functional specifications to the development team and follow the development, providing solutions to potential problems.
• Support process experts and key users during business integration tests and user acceptance tests.

Confidential, Lansing, MI

Sr. SAP HANA/BI Lead

Responsibilities:

• Worked extensively on Michigan Business Taxes reporting.
• Responsible for overall BW/HANA Production Support and deliverables
• Delivered data models and reports for metrics of IS- Public Sector: Tax and Revenue Management, FICA, Master Data Analytics.
• Worked closely with stake holders and delivered analytical applications for Collections, Payments, Refunds.
• Delivered analytical models, Composite providers, ADSOs, SPOs (SAP BW on HANA), Enhancements to standard extractors, custom extractors.
• Responsible for the Analysis authorizations for BW and BOBJ with SSO.
• Delivered dashboards and visualizations using SAP Lumira 2.0 and Business Objects platform.
• Delivered the Business Objects Data Services(BODS) interfaces and integrated with HANA SQL, HDI Containers.

Commercial, Irving, TX

Sr. SAP HANA/BI Lead

Responsibilities:

• Delivered data models for PS (Project Systems) and PM (Plant Maintenance.
• Delivered Native HANA models, Calculation Views, HANA tables and dashboards that show the inspection results and status, analysis on Notifications and production analysis across plants, cost centers.
• Developed Finance reports and visualizations to monitor and manage the past and current WBS project performance using BOBJ (WEBI, AO) and SAC.
• Integrated legacy systems with Native HANA using SDI/SDA/BODS. Worked extensively on the data extraction, preparation, loading into SAP HANA.
• Responsible for the development of the conceptual model, logical model and physical model for the Plant Maintenance Backlog, QM performance metrics.
• Served as a SME for integrating SAP data ERP and Non-SAP customer data into BW/BI environment.
• Provided sessions with detailed documentation.

Confidential

Sr. SAP HANA/BI Lead

Responsibilities:

• Responsible for the design and development of BI/HANA Planning models for SAP Trade Promotion Management to manage promotion targets.
• Delivered HANA/BI Reports for promotion outcomes, revenue, and profit.
• Delivered the BI Planning models for Promotion Planning - worked extensively on planning functions and sequences based on baseline historical promotions.
• Delivered Supply Chain Reports to monitor the plant maintenance metrics.
• Delivered Planning workbooks using Analysis for Office.
• Developed the planning models using custom Formulae extensions (FOX).
• Involved in Unit testing, Integration Testing, User acceptance testing etc.

Confidential

Sr. SAP HANA/BI Lead

Responsibilities:

• Responsible for the design and development of the HANA and BW 7.4 Analytics.
• Translate Functional Specifications into Technical Specifications.
• Delivered dashboards for Curtailments, comparable sales analytics and what-if planning scenarios.
• Delivered SAP HANA data models and analytics for planning and audit analysis with SAP BOBJ WEBI, Dashboard designer for reporting.
• Define the design Documents for the HANA Models for Financials, Controlling, Project systems, Sales.
• Delivered the HANA optimized models using SAP HANA Modelling.
• Integrated AS400, Sales force systems with Native HANA using SDI/SDA/BODS. Worked extensively on the data extraction, preparation, loading into SAP HANA.
• Delivered Planning workbooks and estimate templates for Finance teams.
• Designed, developed and maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Worked extensively on Analysis for Office for planning scenarios - migrated all BEx workbooks to Analysis for Office workbooks and delivered for users.

Commercial, Irving, TX

Sr. SAP HANA/BW Lead Consultant

Responsibilities:

• Responsible for the design and development of the Revenue Recognition analytics on BW 7.4 data models Project systems (PS), Finance (AP, AR, GL)
• Delivered the BW Models for reporting analytics for open contracts (backlog), Revenue Accounting Items, Project systems activities.
• Developed - DSO, Cubes, Hybrid Provider, Transformations, DTP's, Process Chains, Multi Provider, OpenHub and BW queries for the BI Revenue Recognition solution.
• Involved in the development of BW interfaces for Blackline Systems automation process for G/L and bank open items consolidation.
• Delivered data models and BOBJ WEBI reports based on Project Systems like Budget Availability Control for Individual WBS Elements.
• Developed HANA based applications including reporting, dashboards and other information analysis and delivery systems for OTC - Mills, Americas and International.
• Work with development (on-site/offshore), infrastructure, test, and production support teams to ensure proper implementation of solution.

Confidential, Nashville, Tennessee

SAP BW/HANA Lead Architect

Responsibilities:

• Work with Key Stakeholders on the gathering of business requirements; develop a technical plan with duration estimates. Execute the plan and deliver the required deliverables within the time estimate.
• Responsible for holding and scheduling workshops for requirement gathering for Vendor spend analytics, pricing conditions reporting.
• Set up data provisioning using BODS for migrating legacy data to SAP HANA.
• Developed and maintained HANA Calculation Views using SAP HANA Studio for the operational reporting in HANA.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Assist in testing,, and support for SAP BI/BOBJ users.
• Validate the HANA views, identify the gaps and recommend improvements.

Confidential, San Diego, CA

SAP HANA Consultant

Responsibilities:

• Responsible for architecting, building and testing the HANA and BI solutions.
• Work with Key Stakeholders on the gathering of business requirements; develop a technical plan with duration estimates.
• Serve as the SME to business, operations and technology requirements.
• Delivered HANA calculation views used for predictive analytics for the Sensor Tags, Operations and Quality management defects.
• Worked on BOBJ IDE and delivered Universes with HANA calculation views as source and delivered the ad-hoc reports using BOBJ (WEBI), AO.
• Provided guidance to support teams during analysis, design, development and testing processes.

Confidential, Plano, TX

SAP BI Lead

Responsibilities:

• Responsible for the BW Project Plan, status tracking of tasks/activities for realization, testing, cutover and post go-live support.
• Implemented & delivered the BW 7.4 and BOBJ 4.1 reporting solution for SAP IS Retail, POTB, Sales, Inventory, APO, FI/CO modules.
• Coordinated with business users to develop, implement the reporting & planning solutions for Assortments, Initial Buy and replenishments.
• Involved in full life cycle implementation of APO Demand Planning and Supply Network Planning, worked extensively on APO data sources and ETL.
• Delivered complex reports for different reporting streams from POTB, Assortment, POS Sales, Article Movements, sales & billing, inventory, shipments.
• Delivered BW custom data models using Standard and Write-Optimized DSO, Info Cubes, Multi Providers, SPOs to handle huge data volumes.
• Delivered and documentation on BI Launchpad & Planning Layouts.
• Developed WEBI Reports and management Dashboards for all departments.
• Testing - Performed Integration and performance testing, Unit testing and assisted in UAT for all new development. Documented all results in HPQC.

Confidential, Santa Rosa, CA

SAP BI/BW Lead Consultant

Responsibilities:

• Responsible for the BI reporting solution for AFS.
• Worked closely with stakeholders to analyze business requirements and define target SAP BI/BW solution architecture and implementation plan.
• Delivered BI objects such as Info Objects, Info Cubes, Info Sources/Data Sources, Master Data, Transformations, DSO, Extractors, Aggregates, Process Chains
• Delivered data models to extract data from SAP ECC, CRM source systems.
• Delivered operational reports for various streams - AFS, FI, SD, MM.
• Responsible for overall production support incidents.
• Worked on user management, security roles and user profile management.
• Work with business system analysts to create functional and report designs.

Confidential

Sr. SAP BW Lead Consultant

Responsibilities:

• Responsible for designing, leading and implementing Reporting solutions.
• Implementation of SAP BW LO modules - LIS Extractors using ETL process.
• Implementation of SAP BW Financial Accounting, COPA - AP, AR, GL and SL
• Collaborate proactively with various stakeholders and brand managers to gather requirements to recommend and develop solutions.
• Developed Data models and Data flow for Custom solutions for POSD and COT systems using UD Connect 7, DB Connect methodologies.
• Delivered complex forecast sales, budget and delivery analysis reports.
• Optimized report performance for statistics and implemented proposals for aggregate creations and indexing. Improved the report performance by 60%.
• Lead a development team and communicated status updates and issues with the functional and project teams.
• Defined the naming conventions, functional and technical specifications.

Confidential

SAP Technical Consultant

Responsibilities:

• Responsible for BW architecture, designed BW data models - Info cubes, DSOs, BOBJ Reports using WEBI, IDE Universe.
• Worked extensively on the ETL task of extracting huge volumes of master and historical sales transactional data.
• Defined the scheduling strategy for automated data extraction using Process Chains and Meta chains. Configured RRI to backend R/3 and Info Set Queries.
• Defined User level security and Data access controls for business specific and functionality specific Roles.
• Analysed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multiproviders.