Sap Analytics Consultant Resume
PROFESIONAL 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.
- 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 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 BI Designing: Universe Designer, Information Design tool, SQL and PL/SQL, and Design studio
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, SDI, 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:
- Perform requirements gathering, create Functional specs and Technical documents,
- Design and develop BW/BI data models in order to deliver BW/BI reporting solutions
Confidential
SAP Analytics Consultant
Responsibilities:
- To develop BW/HANA Modeling and ETL Objects to virtualize data from regional BW HANA’s into National BW HANA
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:
- To perform activities related to support and development
Environment: SAP BW 7.1, SAP HANA, SAP CRM, SAP SCM, SAP SRM, SAP ECC 6.0, Micro strategy
Confidential
SAP BW Consultant
Responsibilities:
- To develop BW backend objects, and modify objects for HANA optimization to support BW migration from 7.0 to 7.5 on HANA.
Environment: SAP BW 7.5, /BI 7.0, SAP IS-U, SAP CRM, SAP SCM, SAP SRM, SAP ECC 6.0, SAP BI 4.1
Confidential
SAP BW/BO Consultant
Responsibilities:
- To develop reporting solutions, provide support, and perform administration tasks
Environment: SAP BW7.3/BI 7.0/BW 3.5, SAP ECC 6.0, SAP BI 4.1
Confidential
Sr. Information Systems Analyst (SAP BW)
Responsibilities:
- To integrate two separate reporting systems into a consolidated financial reporting system and to upgrade from BW 7.0 to BW 7.3 so that new features could be leveraged
Environment: SAP BW 7.3/BI 7.0/BW 3.5, SAP ECC 6.0, SAP BPC, AS400, Flat Files
Confidential
SAP Consultant
Responsibilities:
- To work on multiple projects to integrate Lawson legacy system into existing BW, ECC FICO environment
Environment: SAP BW 7.0, SAP BI 4.0, SAP ECC 6.0, Hyperion, and SAP BPC
Confidential
SAP BW/BO Developer
Responsibilities:
- To implement Account Receivable Line Item/Transactional Figures reporting solution and to migrate required data from legacy system into BW/BO.
Environment: SAP ECC, BW/BO, CRM, and Solution Manager 7.0, Oracle 9i, 10g, MAXDB, Microsoft SQL Server, UNIX HPUX, Solaris
Confidential
SAP BW/BO Consultant
Responsibilities:
- Assisted in deploying Inventory Management BW reporting solution for reporting purposes using existing ECC as a data source
Environment: SAP ECC6, BI 7.0, BOXIR3
Confidential
SAP BW Developer
Responsibilities:
- To implement fill rate reporting solution to provide ability to analyze and monitor rate at which sales orders are being filled within 24 hours window.
- This solution would be used in investigating root causes of performance problems and in improving fill rate performance
Environment: SAP BI 7.0, ECC6, SD.MM, SCM, FI