EXPERIENCE SUMMARY:

• 10+ years of IT experience as SAP BW/BI (HANA) Consultant Focused on Implementation, supportRoll - Outs, Migration and Maintenance.
• Very good exposure to Data Warehousing principles and practices.
• Involved in requirement gathering with different region clients.
• Extensively worked on BW 3.5/7.0/7.3/7.4
• Experience in Native HANA and created Views as per requirements.
• Experience in BW on HANA objects like ODP, HANA Optimized objects, ADSO,ODS, Hybrid Providers, Transient, composite providers & SPOs.
• Proficient in Data staging using DSO before transferring the DSO contents to the Info cube.
• Proficient in loading data into Persistent Staging Area both from flat file and SAP R/3 systems.
• Experienced in creating Views, Data sources in SAP R/3 and replicating them to BW in the process to load Generic R/3 Data into SAP BI.
• Extensively used all BI 7.0/7.3 functionalities like creating transformations, Data transfer process, Data store objects, Query designer, Workbooks, Start and end routines.
• Extensive Experience in Transportation of objects to different systems and Process chains Creation and maintenance.
• Experienced in Data - Modeling, Data Extraction, Generic Extraction, Data Loading Scheduling, Monitoring, Info-cubes, DSOs, Info Packages, DTPS, LO Cockpit and V3 updates.
• Proficient Performance tuning using Aggregates, Rollup, collapse, Partition.
• Extensively worked on APDs (Analysis Process Design) and Open Hubs.
• Involved in end-user training and documentation.
• Involved in various testing procedures, user training, on-site support and maintenance.
• Customizations - Extract structure enhancements, generic extractors, user exits, and customized delta built up for the data sources.
• Having Good experience in ABAP on BI related like Start routines, End routines and User Exits, Function Modules and Debugging.
• Hands on SAP HANA native created views (Attribute, Analytic views and calculation views (Graphical and SQL Based).
• Experience on Composite providers and Open ODS.
• Support & Development experience in SLT data provisioning with Operational data sources and table replication. Also Worked on SDI/SDA (Smart Data Access/Integration) Hands on experience.
• Good understanding of LSA++ architecture.
• Good understanding skill of current system designs to review/change design to improve performances.
• Very good experience in Analysis authorization and Analytical Privileges.
• Knowledge on Stored procedures and functions.
• Experience in working with SAP applications like MM, SD, VIM (Vendor Invoice Management), PP, QM, FICO, C4C, COPA, WH, CRM, BPC (BW related activities), POS DM and HR.
• Extensively worked on Cloud for Customer (C4C) with system connection, Extraction and reporting.
• Trained and having practical knowledge on SAP BPC-EPM.
• Experienced in developing BeX, Web reports, web items, customized web templates using web application designer (WAD) and query designer.
• Experienced in SAP BO (Webi and Universe design) and Design Studio.
• Experience in creating Ad Hoc reports from different data sources using Business Objects tools - Web Intelligence & Design Studio.
• Experience in Lumira, In creating data sets, Visualization and in Story/compose. Also created custom hierarchies in report level. Used BW-BeX as source and Flat-file data as data sets.
• Hands on experience on SDI/SDA (Smart Data access). Data extracted from Non-SAP systems to SAP by using SDI/SDA s.
• Hands on SAP BO Data services. Worked on Projects to data export to SAP systems.
• Worked on Master data Migration from Non-SAP source system to SAP system.
• Worked on Delta enable, Data cleansing and validation.

SKILLS:

Primary Technical: SAP BW, BW4HANA, BW on HANA, SAP BOBJ(Webi), Hana Native, Analysis for office, Design Studio, Lumira, SAP ABAP (BW related).

Secondary Technical Skills: SAP BODS, S4 HANA.

Trained in: Tableau.

SAP Modules Knowledge and Extraction: MM, SD, VIM (Vendor Invoice Management), PP, QM, FICO, C4C, COPA, WH, CRM, Pricing - Rebates ( Confidential ), BPC (BW related activities), POS DM and HR.

EXPERIENCE:

BW4HANA LEAD Consultant

Confidential, Denver, CO

Responsibilities:

• Working on SAP-QM migration from Non-SAP to SAP. Developed reports, related to top down list of components in ROCKETS. Used SLT&SDI to extract data from SAP and Non-SAP Systems to BW4HANA system. Also Used remote connections for relevant scenarios.
• Done a few POCs to prove the solution to meet the business requirements.
• Developed multiple HANA views(Graphical & SQL based), Designed BW objects ADSO, ODS, Composite providers, OPENHUBS, HANA ABAP CDS & External Views. Used BeX, Analysis for office and Webi for reporting.
• Requirement Gathering, Documentation, Development, UATs, Issue Fixes (Post Go-Live)

Primary-Technical: SAP BW4HANA, SAP-ECC, SDI, SLT, SAP-QM, MM, PP

HANA Analytics Consultant

Confidential, Chicago

Responsibilities:

• I am responsible for requirement gathering, need to prepare FS/TS and have get sign offs from business.
• Also, I am responsible for Solution design and time plan.
• Involved in requirement gathering, documentation and responsible for requirement/Design analysis approval from business.
• Worked closely with in-house team to develop Customer rebates reporting using Confidential -Models.
• Developed using Hana Views (Attribute, Analytical and Calculation views), ADSOs and Composite providers. Analysis for office and SAP-webi Used for Reporting.
• Involved in requirement gathering, documentation and responsible for requirement/Design analysis approval from business.
• Using CDS and AMDP. Developed reports on Customer Rebates using Confidential models.
• Reporting tool used for reporting and Fiori for front end.
• Developed Pricing analysis with forecast data (business rules) using HANA views.
• Requirement gathering, Analysis, Design solutions, Developer, Testing, documentation.

Primary-Technical: BW on HANA, HANA Native, S4 HANA.

Tech Lead

Confidential

Responsibilities:

• I was onsite Technical Lead for FI, COPA, CRM and C4C modules, Shipments and Vendor Invoice Management. Solution implemented in BW on HANA, BW and HANA native. Used multiple reporting tools.
• Responsible for Requirement gathering, FS/TS preparation, CCB approvals, Time plan, Budget estimation, User training, should develop 80% from my side and handled offshore team.
• Developed multiple DSOs, CUBES, MPs, SPOs, Open-Hubs, Custom Data sources, Enhancements which includes DS and Reports.
• Worked on enhancements to improve the performance of existing models.
• UAT and User trainings are my responsibility of any development or CR.
• Collected Transports and created new process chains for new developments/CRs.
• I was responsible for Post go live support.
• Existing models migrated from SAP BW to SAP HANA native views and used BW on HANA info providers. Created attribute, Analytical, Calculation views, ADSOs & Composite Providers.

Primary-Technical: SAP BW, SAP BW on HANA, HANA studio, SAP Bex, BO-Webi, Design Studio and Analysis for office, SAP ABAP.

TECH Lead

Confidential

Responsibilities:

• I was Technical lead and travelled to client location for Knowledge Transfer.
• Worked on POSDM module and System upgradation projects.
• During my time we had P1 issue for POSDM solution and resolved on time.
• I was part of SLT and BW system support team.
• Created BW Objects like ADSO, CP, SPO, Process chains. Responsible for Transports the Objects.

Primary-Technical: SAP BW on HANA, SAP SLT, SAP POS DM. (both are in BW system)

TECH Lead

Confidential

Responsibilities:

• I was Technical lead and handled off shore team.
• Also, I have taken part into BODS team for Master data Migration.
• Worked on Vendor and Material master data migration.

Primary-Technical: SAP BW on HANA. BO, SAP BODS