SUMMARY

• Seasoned SAP BW/BO/HANA consultant with 17 years of IT experience. 11 years working in SAP environment with Extensive end to end full life cycle implementation experience deploying SAP BW/HANA/ BO using ASAP/Agile methodology
• Strong knowledge of SAP BW/4HANA / S/4HANA, ABAP - programmed CDS views in Gateway Front End and Back End, HANA Live Content, SAP Analytics Cloud, SAP Smart Data Access, SDI, SAP SLT replication, Monitoring/reviewing the quality and integrity of the reporting objects, including optimization of HANA model performance by analyzing Expensive Statement Trace, SQL Plan Cache, Runtime Statistics, Plan Visualization Etc.

AREAS OF EXPERTISE

• Requirements Gathering and Documentation (Functional/Technical)
• Transports Management
• Transforming Business Requirements into system solutions
• Incident management
• Design, creation, configuration, maintenance of SAP BW/HAN/BO back end and front end artifacts
• Process chain monitoring and administration
• BW/HANA related ABAP programming
• End-user training and support
• ETL expertise from SAP and Non-SAP sources
• Strong ODATA services and Fiori Knowledge
• Debug, tune, and optimize data loads and reports for performance
• Strong conceptual, analytical and problem-solving skills
• Change management processes administration
• Functional knowledge of SAP modules including FI-CO, SD, HCM, MM, PS, and PM
• Administration of housekeeping activities
• Production support and incidents management

TECHNICAL SKILLS

SAP BW Modeling: Data Marts, Data archiving, Semantically Partitioned Objects (SPO), Info Cubes, Info Objects, Data Sources, Info Sources, Classic DSO's, Advanced DSO, Composite providers, Open ODS Views, Multi Providers, Info Sets Transformations, Data Transfer Process, Info Packages and Process chains

SAP BW Extraction: Data Marts, Standard Extraction, LO Extraction, and Generic Extraction

SAP BW Reporting: Bex query designer, Bex query Analyzer, and Bex Web application designer

SAP BW Operations: Data Load Management (Full/Delta Up-Load), Event Processing, Scheduling Start Process and Process Chains, OLTP Data Extraction, and Monitoring

SAP BW Optimization: Aggregates, Cube partitioning, Line-Item dimensions, Cube Compression, BW Statistics, DB Statistics, Semantic partitioning, Secondary Indexes and OLAP Cache

SAP ABAP: User Exit Functions, ABAP Enhancements in ECC Generic Extractions, BI Data Modeling (Start Routines, Transformation Routines, Expert Routines, End Routines, and Customer Exit Variables)

SAP BO 4.x, 3.x: SAP BI Designing

SAP BI Admin: CMC, CMS, and FRS

SAP BI Report: Webi, Crystal reports, Dashboards, and Design studio

SAP BI: QAWS, Live Office, Design Studio, Lumira, and BODS

SAP HANA: Information views (Calculation Views Graphical and Scripted, Attribute Views and Analytical Views), Reporting on HANA information views in SAP BI/BW suites of applicationsVirtual Tables, SDA, Table partitions, stored procedures, Calculated Columns, restricted columns, Input parameters.

SAP BW/4HANA / S/4HANA - Strong Knowledge and deep understanding of: ABAP-programmed CDS views in Gateway Front End and Back End, HANA Live Content, SAP Analytics Cloud, SAP Smart Data Access, SDI, SAP SLT replication, Monitoring/reviewing the quality and integrity of the reporting objects, including optimization of HANA model performance by analyzing Expensive Statement Trace, SQL Plan Cache, Runtime Statistics, Plan Visualization Etc.

BODS: Data extraction and transformation from SAP and Non-SAP sources

SAP BPC: Develop input schedules, manage applications and processes

PROFESSIONAL EXPERIENCE

Confidential

SAP Analytics Consultant

Responsibilities:

• Performed requirements gathering, created Functional and Technical documents, designed and developed BW/BI data model to fill out CRA forms T2200 (Declaration of Conditions of Employment) and GST 370E (Employee and partner GST/HST rebate application) electronically, following tasks were performed to fulfill reporting requirements.
• Requirements gathering, as-is analysis, fit gap analysis.
• Enhancement of HCM data sources, Creation of Generic data sources, Data model design and development in BW to feed data to Crystal report
• Performed requirements gathering to design and develop HR Metrics and measures dashboards, various dashboards are needed to analyze workforce demographics, staffing and recruitments, retention, work life balance and health and safety
• Developed BEX queries to feed Design studio dashboards to fulfill HR metrics business requirements
• Developed workforce demographics dashboard and various views to analyze Max headcount by Generational breakdown, Tenure and by Gender for last 3 years
• Work in progress for staffing and recruitments, retention, work life balance and health and safety dashboards.

Environment: SAP BW 7.4, SAP ECC 6.0, BI 4.2, Chamelon, Class, eforms, Infor, Max,Google Analytics and Team Budget etc.

Confidential

SAP Analytics Consultant

Responsibilities:

• Developed end to end data flow for National Composite providers, downstream objects required were Regional Composite providers, Calculation Views, Virtual Tables, and Open ODS Views
• Created National Wholesale Daily (RSC & DSD & GI) Bex reports based on National Composite provider
• Data model for National Composite providers were constructed for Catch Weight Quantity and Promotion Situation List DSOs.
• Designed Generic extractors to extract forecast information data from WAHD, MAPR and PROW ECC tables, developed upstream data flow to populate SCM aDSOs
• Constructed data model to send weekly extracts of POS Liquor sales data for West Region Data modeling tasks performed were
• Created Open Hub destination based on CTM Retail Profitability Infocube, destination type third party tool (i.e. Data services)
• Project, batch jobs and all relevant dataflow tasks were created in Data services designer to import open hub extracts from BW source into target Flat file in data services
• Managed Unit testing, System testing, defects fixes and Transports in ALM (HP)

Environment: SAP BWoH 7.4, SAP HANA, SAP CPM, SAP SCM, SAP SRM, SAP ECC 6.0, BI 4.2, BODS 4.2

Confidential

SAP BW/HANA Consultant

Responsibilities:

• Administered, monitored and managed process chains, identified and fixed data load failure issues
• Resolved assigned Incidents related to minor enhancements and break fixes within promised SLA
• Performed BW back-end and front-end enhancements to meet business requirements
• Analyzed and fixed data reconciliation issues between ECC and BW environments
• Performed housekeeping activities to optimize data load and reports performance
• Executed, documented report layout validation, data validation to ensure that the business requirements are met
• Prepared BW reference documents to capture enhancements, issues, and resolutions
• Developed Attribute Views, Analytic views and Calculation views to fulfill reporting requirements in COPA, Sales and Margin, PLM
• Extracted data from SAP ECC (COPA Tables) and Legacy systems through SLT and BODS jobs
• Designed the data model for COPA retail and franchisor P&L reports in HANA
• Developed various P&L repots (COPA) to analyze data by Entity, responsibility, periods, and regions
• Enhanced various standard PLM reports for additional fields to fulfill business requirements
• Performed report layout validation, data validation for the reports generated in HANA to ensure the business requirement are met.

Environment: SAP BW 7.1, SAP HANA, SAP CRM, SAP SCM, SAP SRM, SAP ECC 6.0, Micro strategy