PROFESSIONAL SUMMARY:

• 5+ years of experience in SAP, Includes HANA 1.0, BW/BI 7.3 & 7.5 data warehousing, BOBJ 4.2. Involved in 4 End to End implementation Project (design, development, and deployment). Having Support experience as well.
• Has versatile experience in areas of requirement gathering, gap analysis, design, implementation, validation and has played the roles of HANA/BW/BI/BO Application Developer.
• Played Role as SAP HANA Consultant in End to End Implementation project as Application team lead.
• Played Role as SAP BW Senior Consultant in End to End Implementation project as Application team member.
• Implemented SAP HANA models and developed custom attribute views, analytical views and calculation views.
• Implemented Std Cubes, DSO and developed Custom data flows as per the requirement
• Fair knowledge on ABAP, which enables to implement various coding and debug custom functionalities in BW
• Experience in SAP HANA Data Modeling and Data Provisioning using BODS and SLT.
• Experience in building dashboards using the front - end tools SAP-Lumira, Design Studio and Tableau

SAP HANA Expertise:

• Strong experience in designing SAP HANA Models
• Implemented: Create database schemas, Attribute View, Analytic View, Calculation View, develop scripts and establish data feeds (SLT)
• Modelling of SAP HANA objects and developed Attribute Views, Analytic Views with various join conditions and calculation views using both Graphical and SQL script-based methods.
• SAP HANA programming including SQL, SQL Script, and CE Script.
• Creating Functions and Stored Procedures using SQL the Editor
• Working knowledge of HANA LIVE

SAP BI/BW/BO Expertise:

• Involved in End to End implementation Project in MM, FI, AP, AR, GL, WM, FI-CO, IM, Profitability, AA, HR and CRM (TPM). (Design, Development, and Deployment).
• Extensive experience in implementation, Development as well as Production Support projects
• Experience in Creating and Enhancing DSO, Cube and Master Data Objects.
• Worked on queries using BEX Analyzer, extensively used structures, variables, exceptions, conditions, restricted and calculated Key Figures and customer exit Variables in reporting.
• Proficient in OLTP extractions of SAP LO-Cockpit, FI, MM, HR and CRM, generic extraction, flat files.
• Experience on ETL Tools to extract source data & Data profiling, Transformations and loaded into target repository and checking the data quality of the loaded data in the warehouse

TECHNICAL SKILLS 

ERP: SAP R/3 ECC 6.0, MM, IP, APO, FIGL, AP, AR.

Data Warehousing: SAP Net Weaver 2004s and BW 7.0, 7.3, 7.4 & HANA 1.0.

Reporting Tools: BOBJ 4.0/4.1, Query Designer, Analysis, Design Studio, Power BI, Spotfire

PROFESSIONAL EXPERIENCE:

Confidential

HANA Lead Consultant

Module: SAP BW on HANA, SAP BPC, SAP Native HANA as Side Car, SLT, BODS and SAP BO Analysis Office, SAP Dashboard, SAP-Lumira, Design Studio and Power BI, SAP Business Workflow

Responsibilities:

• Developed Custom SAP Workflow object to meet business requirement, Approval workflow to release entity contact created by Sales Team
• Developed ABAP and ADMP method and extensively reuse them in ABAP program to get performance benefit of HANA.
• Create and maintain financial reports in BPC using the EPM Excel Add-in.
• Working directly with clients to meet their business and technical challenges.
• Developed OData services to integrate CRM entity/contact with Microsoft Outlook.
• Extensively worked in implementing SAP HANA 1.0 SP09.
• Loaded Data into SAP HANA from ECC using SLT and Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Worked on SQL scripts using Calculation View and to debug the issues.
• Integrated Tableau with HANA Virtual models.
• Developed the SAP HANA models in the SAP HANA environment.
• Integrated SAP BO Analysis Office with SAP HANA models for operational reporting.
• Assess different customizing options for SAP HANA models for customer-specific scenarios.
• Worked on FI-AP, AR, GL and Profitability modules real time reporting using data load with SLT to SAP HANA and design virtual models.
• Imported BW in-memory DSO in to Native HANA as analytical views by push method.
• Worked on WM, IM and Field Sales modules non-real time reporting using BW on Hana data loads and design virtual models.
• Hands on experience in developing and modelling the various modules of SAP and non-SAP related in HANA Studio.
• Enhanced the SAP delivered existing HANA Models based on the requirement.
• Developed Calculation views (joining more than two views and Standard tables).
• Created Variables on Calculation views to restrict the data based on requirement.
• Created Input Parameters on Calculation views to pass the logic dynamically to the views.
• Loaded the data from ECC to HANA Data base by using SLT.
• Integrated HANA views in BO Analysis office and Power BI as frontend tool/presentation layer.
• Developed the SQL scripts to load the data in to staging tables to increase the virtual data model performance.
• Developed delivery execution dashboard using SAP Lumira.
• Developed Vendor and Customer accounts payables and receivables dashboard using SAP Lumira
• Developed Disputes dashboard using SAP Design studio.
• Developed planned vs actuals dashboard by integrating the data into SAP HANA data using Power BI

Confidential, Lexington, KY

HANA Senior Consultant.

Module: SAP HANA Live as Side Car and SAP Lumira, SAP BO, SAP Dashboard, SAP BODS and SAP ECC.

Responsibilities:

• Extensively worked in implementing SAP HANA 1.0 SP06 as a side car for SAP ECC.
• Loaded Data into SAP HANA from ECC using BODS and Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Worked on SQL scripts using CE functions for Calculation View and Procedures.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Integrated SAP Lumira with SAP HANA models for operational reporting.
• Assess different customizing options for SAP HANA models for customer-specific scenarios.
• Enhanced Financial Statements reporting scenario using SAP HANA virtual data models.
• Hands on experience in developing and modelling the FI related HANA Models in HANA Studio.
• Enhanced the SAP delivered existing HANA Models based on the requirement.
• Developed the attribute views, analytical views.
• Developed Calculation views (joining more than two views and Standard tables).
• Developed the script-based calculation views and used the CE functions
• Created Functions and Stored Procedures using SQL the Editor
• Created Variables on Calculation views to restrict the data based on requirement.
• Created Input Parameters on Calculation views to pass the logic dynamically to the views.
• Loaded the data from ECC to HANA Data base by using SLT and BODS.
• Worked on analytical privileges to grant the access or restrict the access on views.
• Integrated HANA views in Lumira as frontend tool/presentation layer.
• Implemented New GL (Replacing Special Ledger), AR, AP, AA and IM

Confidential, Fresno, CA

SAP BW/BI Senior Consultant.

Module: SAP BW, SAP BEX, SAP Dashboard, SAP ABAP, SAP CPM, SAP BO-Webi and SAP ECC.

Responsibilities:

• Involved in Discussions with the client regarding Business Requirements.
• Identified and installed the BI content objects related to Billing, Inventory, and Budget (COPA).
• Extracted data from ECC using the Logistics procedure for Sales and Inventory.
• Extracted historical MSSQL data for Sales and Budget using the UD Connect.
• Involved in writing Start Routines, Field Routines and end routines.
• Enhanced the Billing and Inventory data Sources according to requirements.
• Developed Queries using RKFs, CKFs, Exceptions, Variables, Conditions, Cell editor, Replacement path, Formula collusion etc.
• Developed ABAP Code for Year-to-Date and Period-to-Date in CMOD.
• Transported all the ECC and BI Objects from Development to Quality and Production Systems.
• Created, Scheduled and Monitored Process Chains for the above flows.
• Involved in UAT with the Business Users in BI Quality system.
• Re-designed the Objects and made changes to the Flows and Reports to meet Requirements after UAT.
• Configured the OLAP Connection for BW server on the Central management Console (CMC).
• Created the Data foundation, Business layer and published the universe to Webi.
• Created the Reports Using the BO Webi tool on the universes.
• Created the BO Webi reports by calling the Bex Queries using BICS connectivity.
• Created the Tab - wise reports for on the Sales and Billing in Webi.

Confidential, San Diego, CA

SAP BW/BI Consultant.

Module: SAP BW, SAP BEX, SAP Dashboard, SAP CPM, SAP ABAP, SAP BO-Webi and SAP CRM.

Responsibilities:

• Involved in design, analysis and end to end development on identifying KPI's and gathering requirements for Sales, Revenue, enhancing multiple standard and generic extractors
• Created user-exit variable for Planning periods based on user entry, developed expert routines and end routines.
• Worked on multiple enhancements in within BI and CRM source system.
• Developed new/enhanced custom Transactional/Master data Extractors, Info Objects, DSOs, Info cubes, Multi Providers, Transformations, Info Packages, DTPs and scheduled the load via process chains
• Enhanced data sources using User Exits, extracted data from CRM system from Data sources and generic extractors, ran Delta update with Numeric Pointer, Timestamp and Cal. Day.
• Enhanced SD extractors and relevant objects adding a new partner function and modified existing reports to accommodate new fields and functions
• Converting high-level design specifications to detailed functional and technical specifications.
• Used Administrator Workbench to create Data Sources, Info Objects, and, Info Cubes, DSO objects, Info sets, Multi-providers, update rules and transfer rules.
• Data extraction from CRM source system and Flat files.
• Created generic data sources to extract data from various data sources to achieve end-user requirements.
• Excellent communication and management skills and ability to work as part of a team
• Used Process Chain and the Reporting Agent to automate data loading, delta uploads, Performance tuning, printing and Exception reporting.
• Designed aggregates for performance improvement of existing queries.
• Scheduling, Monitoring and transporting objects in Dev, QA, Prod systems.
• Developed queries using Bex analyzer. Create variables, calculated and restricted key figures, filters and conditions in Bex query designer.
• Automated the error handling which triggers the email to the intended recipients in case of the erroneous records.