SUMMARY

• A senior SAP Analytics consultant with 10+ years’ experience designing and implementing Business Intelligence solutions for 6 BW/BW on HANA, 1 Native HANA, 2 SAP Analytics Cloud and 1 BPS full - lifecycle projects.
• Led a BI implementation team of 5 developers to provide global reporting and analytics supports 1,000+ international BI end-users across Europe, North America and Asia over 5 years.
• Consistent in proactive engagement with global customers/stakeholders and delivering high customer satisfaction in all projects.

TECHNICAL SKILLS

SAP HANA: Strong in Native HANA information modeling, performance tuning, SQL Script programming and the integration between HANA, SAP BW and SAP Analytics Cloud platform.

SAP BW/BW on HANA: Technically sound in SAP BW modeling, data provisioning. Designed and developed InfoProviders, InfoObjects, Transformations, Process Chains, Data sources, BEx Queries.

SAP ABAP: Good working knowledge of SAP ABAP related to BW, including customer exits, BADI enhancement, generic data sources.

Reporting tools: SAP Analytics Cloud, Design Studio Dashboard, WEB Intelligence, Power BI.

Functional Skills: SAP CRM, SAP ECC, BPS/BW-IP.

PROFESSIONAL EXPERIENCE

Senior SAP BW/HANA Consultant

Confidential

Responsibilities:

• As a project lead, engaged with stakeholders and product owners to identify project scope in different phases and provided detailed efforts estimation. Assisted scrum master in Sprint planning. Worked very closely with developers, and other related parties to make sure our projects will go-live in accordance with its defined scope and timeline.
• As an expert in the Service delivery area, discussed and provided suggestions to customers about the complicated KPI definition, authorization control and combination of current and historical data.
• Improved performance from 1 minute to 30 seconds running time by remodeling backend tables and HANA.
• Guided developers implementing BW objects (ADSOs and Composite Providers) in Eclipse, data extraction and ETL logic, HANA modeling, and SAC dashboard.
• Implemented generic data source, HANA views and procedures for complex authorization control.
• Got a BIG THANK YOU letter from customer for enabling them to create further transparency with the premium engagement delivery process and to find optimization potential.

Senior BW Consultant SAP

Confidential

Responsibilities:

• Migration to SAP One Analytical Platform aims to build central corporate data by consolidating system data from different sources. After our migration, SAP internal colleagues can access trusted data with a single source of truth which makes them easier delivering smart insights to enable steering excellence at SAP.
• Acted as a solution architect for setting up the reporting framework involving CRM table creation, SLT replication from CRM system to BW HANA, HANA native data warehousing, BW virtual reporting layer, SAP Analytics Cloud frontend. The new reporting framework helped the business with real-time info.
• As the Information Owner, overall mastered both business and technical info and actively shared knowledge with other BI team members to guide the team to expand the collective knowledge of the global BI team.
• Involved in extensive collaboration and discussion with other clusters and other departments to decide the strategy and timeline of the migration.
• Provided solution governance and delivery management for a team of 5 developers.
• Demonstrated solid knowledge of cross-business process topic including service order, service contract, sales order, case management, escalation, complaint, and incident management.
• Implemented ABAP programs/FMs for CRM table creation and update, HANA calculation views and BW modeling. Pioneered in using Operational Data Provisioning (ODP) data sources.
• Prepared cutover plan, coordinate with the Global BI team during the cutover period of monthly BI release.

BW/BPS Support Consultant

Confidential

Responsibilities:

• Premium Engagement and Enterprise Support SO Delivery Dashboard offers flexibility regarding the KPI and Dimensions to be analyzed. Without the report, accurate investment planning is impossible. It can also balance the workforce and identify long-running services.
• Analyzed business requirements together with product owners and business users, actively discussed the design of the dashboard interface and provided refinement feedback.
• Provided a prototype prior to the build phase and was involved in drafting the overall solution document.
• Responsible for the pilot project of implementing the very first SAP Analytics Cloud dashboard.
• Utilization Report will provide information about the contingent consumption within a Premium Engagement contract and the forecast capacity to SAP TQMs, EAs and Managers.
• Designed the architecture for the Contingent and Utilization Project, which will combine SAP CRM and ERP data together and realize the near real-time request.
• Communicated interactively with business users about the complex logic of the reporting and how to realize the huge amount of formulas by BW/HANA modeling and BEx queries.
• Developed some of the most complex business rules by means of transformation/start routines and HANA scripted calculation views.
• Designed front-end reports via SAP BEx query, used Restricted and Calculated Key Figures, Variables, Exceptions, and Conditions.
• According to the business, this report helped them save about 50% of the time dealing with utilization analysis and it has been the only report which has been used continuously for more than 4 years.

BW/BPS Support Consultant

Confidential

Responsibilities:

• The Quality Assurance Reporting is designed to provide an overview of service delivery quality assurance status which can inform business in which service orders are not compliant and define methods to ensure compliance in the future.
• This is a native HANA project and also a pilot project for SAP HANA modeling. Hana views were built in the CRM system directly which can provide real-time data.
• Complex scripted calculation views were implemented to realize complicated KPIs and table joins. Procedures were built to fill the HANA tables. On top, a WEBI report was built for the operational data.
• Involved in projects facilitated in requirements gathering and managing stakeholder’s expectations. Analyzed and validated new CRM Service Delivery business workflows and drafted the technical blueprint.
• Redesigned and optimized the current data model according to the new business workflows and with better performance.
• Enhanced data sources with new transaction types and new fields, migrated some BW 3.5 flows to 7.0 flows, implemented ETL logic, and completed BEx query migration. Validated the new migrated queries.
• As the project lead, worked closely with the product owner, business requester, and developers to ensure high quality, less maintenance effort and in time delivery. The total number of tickets regarding the development error is less than 5 Guided team members to provide production hyper-care support, user training and help with the operational transition.