PROFESSIONAL SUMMARY:

• Around 10 years of experience as a SAP BI/BO Hana Specialist with expertise in SAP BI, BW Data modelling, BI Reporting Specialist, SAP HANA, Composite providers, SAP BOBJ(WEBI, IDT, Design Studio Lumira reporting ), Tableau & SAP BW Archiving (NLS). Extensive ABAP coding for Enhancement of extractors & Variables & POS BAdI. Current role is Senior SAP HANA BW BO Consultant with exposure to SAP IS Retail & Consumer Packed Goods, Manufacturing Domain.
• Attribute Views, Analytical views, Calculation views creation and Projection, Join and Union creation in HANA calculation views in Native HANA modelling. Filters, restrictions, calculated measures, restricted measures in HANA views & Table Functions / Procedures and CDS
• Creation of HANA views, tables, views as design time objects.
• Created and worked on workspaces, local providers and ADSOs / Composite Providers/ Open ODS in BW MT
• Creation of Input Parameters, Variables and mapping them with BO reports
• Creation of Composite providers, Schema mapping in HANA studio for Export and Import transports from different lifecycle systems. Export and Import of HANA views between different lifecycle systems through Developer mode as well as through Delivery unit
• Tableau reports and dashboards creation on top of HANA calculation views
• Extracting data from different data sources and loading to HANA through BODS and SLT
• Worked on BW to HANA migration and worked on side car HANA live projects
• Has taken a lead role in achieving quality benchmarks throughout all assignments.
• Hands on Experience and Technical Proficiency in Data Modeling - Info objects, DSO, Info Cube, Multi-Providers, APD’s, Data Loading and Delta Management.
• Reporting using Confidential Analyzer such as Free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Exceptions, Filters, Conditions
• Extensively worked on different extractors (GDS, LO, CRM, HR PA, POSDM, CAR (0RT PA TRAN CONTROL) etc.) and enhancement of BAdI for POS DM
• Writing ABAP codes for Transformation routines, Confidential customer exit variables.
• Involved in various development, enhancement and upgrade projects.
• Performance tuning of info cubes by Compression, partitioning the cubes, BW statistics and Confidential query reporting.
• Extensively worked on BOBJ and created many complex reports in WEBI and Analysis for Excel.
• Created reports on Design Studio on top of Hana views, Confidential Queries.
• SAP BW Accelerator (BWA) and creation of BIA Indexes prior to HANA.
• Housekeeping activities like PSA deletion, change log deletion, BIA Index creation and deletion for Info cubes along with planning of BW Archiving via NLS
• Experienced in SAP DESIGN STUDIO along with reporting via Geomaps
• Generation of webservices for REST/SOAP/Odata/Fiori consumption via Confidential Easyquery/HANA XS/Gateway/HANA CDS views based on SQL modelling
• Worked with senior leadership teams for the reporting requirements along with generating web services to integrate them to Google home/Alexa etc..
• Led the projects for big companies by working in multiple roles.

TECHNICAL SKILLS:

Skills: SAP HANA,SAP BW on HANA, SAP BW 7.X SAP NLS IQ, SAP ECC, COM, SD, SAP BODS

Programming Languages: SAP ABAP, SQL

Reporting Tools: SAP BEx, BOBJ Webi, Design Studio, Tableau, IDT, Analytics, Lumira

Databases: DB2, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr SAP HANA/ BODS Consultant

Environment: SAP HANA, BO 4.2 (IDT, Webi), SAP BODS

Responsibilities:

• Extensively Worked on designing SAP HANA data modelling objects using Native HANA SQL & Graphical Views, Scripted views, Procedures, Table functions
• Built Dashboards / BOBJ reports from scratch for Warehouse Efficiency, Inventory Shrink & POs, JDA by partnering with business teams to deep dive into requirements
• Monitoring/reviewing the quality and integrity of the reporting objects, including optimization of HANA model performance by analyzing Runtime Statistics, Plan Visualization Etc.
• Knowledge of BODS integration with data sources - Oracle, Teradata, Kronos, Geotab & built HANA Views for Analytics & maintaining the respective control tables
• Extensively worked in the replication technique using SAP BODS for creating workflows/data flows leading to Universe Design Tool & BOBJ Reports / Dashboards Understanding various KPI’s and its functionality and developed customized reports.
• Exposure to Microsoft EDW, Power BI, SSRS, SSIS to reconfigure the reports into a new environment.
• Prepared project documentation including Business Blueprints, configuration documents, Technical and Functional specification documents, documents and support documents.
• Exposure to HANA SDA & SDI & SAP BW/4HANA
• Worked on Transport of HANA/BW/BO/BODS objects from development
• Creation of reports using SAP AO (Analysis Office )
• Built Business objects Dashboards/ Webi reports out of HANA Data models both via HANA online and IDT.

Confidential

SAP BW HANA CONSULTANT

Environment: SAP BW 7.3, SAP BW 7.4 /7.5 ON HANA, BO 4.2, DESIGN STUDIO .

Responsibilities:

• Created & maintained Info Objects, custom data sources, Info Sources, communication Structures, transfer structures, transfer rules, update rules, info packages and scheduling the data requests and process chains
• Experience in HANA Pre and post migration upgrade activities, etc. worked on BW stack split upgrade, BW 7.3 to 7.4 migration, on plan for BW4HANA and POC for migration impacts when ECC was migrated to ECC 6.0 Ehp4 & F&R, BW/4HANA Migration of DSOs to ADSOs, BW MT tools with Eclipse based omodelling
• Performed extraction of data from SAP source systems using R/3, with delta and Generic data extractions.
• Identified SAP Notes which are relevant to HANA environment and implemented the same by thorough testing in non-production systems
• Built new HANA views for reporting out of Inventory Analysis along with data models for Planogram Space Planning, BW - BPC for financial systems.
• Created data models/queries using Composite providers leveraging standard HANA Views & BW models HANA views for reporting out MDX engine from SAP BW, thereby projecting it to SAP Gateway for FIORI UX data models.
• Worked extensively on categorizing HANA data models into multiple storage categories and archived them using BW NLS.
• Customization of BAdI for POSDM extractors & SAP ECC/CRM extractors for additional Analysis.
• Categorized data targets based on storage/volume and created DAP for BW archiving via NLS.
• Also tuned queries for Access to Odata/NLS/ Easy queries.
• Working on SAP BO Design Studio with parallelizing BW Queries & dash boarding.
• Prototyped HANA Datamodels using HANA Application Function Library (BFL & PAL ) leveraging Datamining options - Classification/Clusturing ABC etc..
• Extensively worked in the replication technique SAP BODS for creating ABAP data flows, information modelling tool HANA Studio to build HANA models, front end BO tools - IDT, Web Intelligence to create final report.
• Worked on BW workspace & integrated planning data foundation including data upload through Workspace Designer & BOBJ analysis for Excel for Analytics project. Also worked on creating Attribute views, Analytic views, Calculation view using graphical mode,
• Worked on the BW Work space & Workspace Designer for master data.
• Hands on experience in Data modelling, performance tuning, data extraction, Creation of custom datasources using ABAP etc.
• Worked on the integrated planning data foundation which includes Aggregation layer, filters, characteristic relationship & BOBJ Analysis for Excel for uploading transactional data
• Worked on the implementation of attribute views, Analytic views, Calculation view using graphical mode.
• Worked on the BW models in HANA, Transporting HANA views transport across different landscapes both via delivery unit & developer mode.
• Worked on creation of HANA Views using both graphical & SQL models
• Prototyped HANA CDS views for consumption via Odata.
• Prototyped HANA Service urls via HANA Advanced XS, Easyqueries & Gateway thereby facilitating AI using Google Home/ Alexa
• Worked on the SPOs to implement POS model.
• Developed a SAP DESIGN STUDIO report ERP/POS Sales Report details for managers - this report focuses on the topN details of Stores/Regions from cost,volume of orders,geography etc using the capabilities of the SAP DESIGN STUDIO application.
• Developed a BW statistics report on SAP DESIGN STUDIO - A report that displays the user activity on the system with query and database statistics details. The report also provides minute details highlighting the aspects that affect the performance of the system, YOY comparison of various activities in the system, top 10 active users, topN Queries used and top queries that spend more time on database.
• Created start/end routines, transformation routines for SAP BW Objects.
• Good experience in User exits for BW extractors.
• Data archiving to files and near line storage.
• Also prototyped on creating Data models created in BW with data from BODS
• Effectively communicated between the project team and the customer. Provided day-to-day direction to the project team and regular project status to the customer.

Environment: SAP BW 7.4 and SAP Hana Modeler.

Confidential

SAP BW developer

Environment: BI 7.X, SAP Confidential Query Designer & Confidential Analyzer

Responsibilities:

• Extensively involved in Activating the Business Content for Info cubes, Data Sources, Multiproviders
• Created Open Hub Destinations to transfer data from Info Providers to Flat Files & to databases.
• Configured Confidential Queries for Free Characteristics, Calculated and Restricted key figures
• Worked extensively on LO Extractors and update modes
• Performed various data load (Init, Delta, Full & Repair full and Repeat of last Delta).
• Created several Info provides & Queries based on requirement
• Created process chains, scheduled Daily/Weekly/Monthly data loads and monitored the loads
• Involved in performance tuning activities using Aggregates, Rollups, Compression, Change Log Deletion, BW statistics and Confidential query reporting.
• Identified several performance bottlenecks and resolved them.

Confidential

SAP BW developer

Environment: SAP BW 7.X,SAP ECC

Responsibilities:

• Extensively involved in Activating the Business Content for Info cubes, Data Sources, Multiproviders
• Developed the data model for Personnel Actions (0PA C01), Benefits (0PABN C01) & Organizational management (0PAOS C01).
• Developed the reports under modules like Personnel Actions, Benefits & Organizational Management.
• Configured Custom cubes, Transformations, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workbooks.
• Worked on Personnel Actions (0PA C01) and generated reports on the same.
• Created process chains, scheduled Daily/Weekly/Monthly data loads and monitored the loads.
• Worked with Open Hub Destinations & Analysis Process Designer to transfer data from Info Providers to Flat Files & to databases.
• ABAP coding for user exits, enhancement of data sources.
• Designed queries in Confidential Query Designer and created workbooks in the Confidential Analyzer using conditions, exceptions, structures, calculated and restricted key figures, characteristic variables, formula variables and text variable with manual, replacement path, SAP exit and customer exit processing types.
• Worked on Transport of BI objects from development landscape to Development and Quality landscapes.

Confidential

SAP BW developer

Environment: SAP NETWEAVER 7.3

Responsibilities:

• Got Trained in SAP BI (ETL, Confidential Query Designer & Confidential Analyzer)
• Exposure to Standard cubes and its reports in BI contents on various functional areas (Sales & FI).
• Understanding various KPI’s and its functionality and developed customized reports from the standard.
• Designed queries in Confidential Query Designer and created workbooks in the Confidential Analyzer using conditions, exceptions, structures, calculated and restricted key figures, characteristic variables, formula variables and text variable with manual, replacement path, SAP exit and customer exit processing types. ABAP coding for user exits, enhancement of data sources.
• Prepared project documentation including Business Blueprints, configuration documents, Technical and Functional specification documents, documents and support documents.
• Designed queries in Confidential Query Designer and created workbooks in the Confidential Analyzer using conditions, exceptions, structures, calculated and restricted key figures, characteristic variables, formula variables and text variable with manual, replacement path, SAP exit and customer exit processing types.
• Worked on Transport of BI objects from development landscape to Development and Quality landscapes.
• Monitored and implemented the solutions to the errors in the Production System effectively and efficiently.