SUMMARY

• Seeking excellent opportunities in Data warehouse/Business Intelligence / Enterprise Analytics with SAP HANA, SAP BW, Google Cloud Platform with Big Query, Data Flow/Data Prep and Microsoft BI.
• Consulting and industry experience as technical architect engineer at top companies
• 10+ years of solid professional experience in Database/Data warehouse/BI design, development, and data modeling in SAP S/4 HANA, Enterprise HANA, SAP BI / BW, Tableau, Business Objects, and MS SQL Server
• 15+ years of combined experience in software design/development in SQL with HANA SQL, T - SQL .NET, C#, VBA, JavaScript

TECHNICAL SKILLS

• Solid SAP HANA experience with 7 full HANA Enterprise implementations, a prototype of S/4 HANA embedded analytics, a BW on HANA project, an Oracle to SAP HANA data migration project. Solid experience in HANA data modeling and performance tuning.
• SD, MM, FI, CRM, SRM, Supply Chain, IS-Oil, ISU. Experience in system integration with SAP and other systems. experience in data modeling, ETL, and reporting with SAP BW 3.1, 3.5, BI 7.0, 7.3, 7.5
• Google Cloud Platform, experience in Cloud Storage, Cloud Data Flow, Cloud Data Prep, Big Query and Security.
• Hadoop with Horton Works and HIVE.
• Microsoft SQL Server: experience in database design, data modeling, T-SQL and stored procedure, SSAS, SSIS, and SSRS with MS SQL Server 2000, 2005, 2008R2 and 2012.
• Full life cycle experience in database/data warehouse system design and development, including user requirement gathering, business process and data mapping, blueprint, Entity-Relationship and multi-dimensional modeling, BI solution development, testing, go-live and support.

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Architect

Responsibilities:

• Architected, designed and developed new customer credit score calculation system with comparison of Gradient Boosted Decision Tree (GBDT)and Logistic Regression (LR) models. Project includes develop SAP HANA procedures to process Experian customer profile in JSON format using HANA JSON Document Store, HANA procedures to populate the features table, call HANA Predictive Analysis Library (PAL) procedures to calculate credit scores, integration with Sales Force and SAP CRM/ISU for further processing.
• Designed and developed HANA models to store and migrate data for Business Partners and Customer Interaction Records (IRECS) with data from SAP CRM, SAP ISU, SAP BW, and Sales Force.
• Designed and developed HANA models for GL line items reporting with data from SAP ISU and BW.
• Performance analysis and tuning for data models of IRECS, GL Line Items by optimize model designs and analyze HANA execution plans and visualized plans, memory consumptions, etc. Resolved out of memory issues due to huge data volumes and improved performance from 8 minutes to around 5 seconds.
• Tuned and improved of features table loading HANA procedures by debugging and identify the critical improvement points, reduced the procedure run time from 5+ minutes to about 3 seconds.
• Replicated data from SAP CRM and SAP ISU to HANA using SLT.

Confidential

BI Architect

Responsibilities:

• Installed and configured SAP HANA 2.0 Express Edition, Designed and developed SAP HANA data models and reports for the distribution center with data from SAP, MS SQL Server, and PKMS and Hadoop with Smart Data Access (SDA) from Hadoop and SQL server. The system includes HANA models and Tableau reports for inventory and delivery tracking, shipping status, shipping price impact, shipment by customer, by channel, by brand, by profit center, etc.
• Architected, designed and managed the Gross Margin Reporting project - the first true enterprise analytical solution for the company. Project analyzes information about how various KPIs contribute and impact the gross margin, such as total sales, invoiced sales, returns, markdowns, rebates, royalties, etc. Project extracts data from SAP ECC, SAP BW, move into Google Cloud Storage, data transformation and modeling with Cloud Data Flow / Data Prep, load into Cloud Big Query, then build reports and dash boards with Tableau.
• Architected, designed and managed the Global Pricing Reporting project - including price alignment with plant, price change impact analysis, what if analysis, data reconciliation with Periscope (a third-party pricing tool) etc. Data were extracted data from SAP ECC, SAP BW and Periscope, loaded and modeled in the Google Cloud Platform and visualized with Tableau.
• Architected and designed Gross Margin reporting project with on premise Hadoop system, including multi-server cluster setup, data loading and transformation into HIVE tables in staging, transform and reporting layers, Tableau reporting, Hadoop system monitoring, tuning and administration.
• Evaluated and compared big data solutions with SAP HAHA vs. Hadoop on premise vs. GCP and different cloud systems such as AWS and GCP. Recommended the future BI/analytic architectures and roadmaps to company executives
• Managed on premise Hadoop cluster, GCP and Tableau servers including security management, performance monitoring, trouble shooting, license and key management, etc.

Confidential

SAP HANA and Data Modeling Architect

Responsibilities:

• Business requirement gatherings and clarifications
• Hands-on architect, design, and develop end-to-end SAP HANA analytical solutions in multiple business domains in:
• Supply chain management: design and develop HANA models for Order to Cash (OTC) dashboards from SAP ECC data sources. The solution provides the live-view of full business cycle of OTC process, including sales order, delivery, invoicing, and account receivable.
• Procure To Pay(P2P) and supplier relationship management (SRM): Design and develop HANA models for P2P and SRM analytics with SAP ECC and SAP SRM data sources, Including:
• Real-time requisition status reporting and analysis - provides the live view of shopping cart status and helps the client to address any issue for the requisition.
• Real-time requisition work flow step and cycle time analysis: this provides real-time data for work flow steps in the whole acquisition process and cycle time between each steps, with comparison of the average time by employees, business units, etc.
• Monitor and identify HANA system performance problems, tune and improve HANA model and reporting performances.

Confidential

Lead SAP HANA Data Model and ABAP Consultant

Responsibilities:

• Evaluate S/4 HANA Simple Finance and Simple Logistics for the client.
• Evaluate, design and prototype S/4 HANA data models and analytics using HANA Cloud Platform, ABAP CDS views, OData Services, SAP Web IDE.
• Design and develop multiple SAP HANA data models for the client's supply chain and billing systems with large data volumes and multiple functional areas.
• Business workflow: design and develop client’s data download/upload process using SAP HANA XS engine, SAP UI5 and HANA SQL procedures
• KPI Calculation: evaluate, design, develop and optimize SQL HANA SQL procedures for 2000+KPIs with complex dependencies and calculations. Improved the KPI calculation performance from 60 KPIs/40 sec. in POC to 770KPIs/50 sec.
• Reporting: Design SAP Business Objects / Qlickview / SAP UI5 reports
• Amazon AWS HANA Server Management, Monitoring and trouble shooting.

Confidential

Sales Support as SAP BI / HANA Lead

Responsibilities:

• Provided business and technical support for multiple big data & analytics project proposals, including a healthcare company, a banking company, an insurance company, and an investment management company.
• Architected, configured and designed a Procurement Spend Analysis POC using SAP HANA Cloud Platform, XS ODATA Service, SAP UI5 and JavaScript.
• Architected, designed, and developed 3 HANA data models with a very aggressive timeline. Led the team and provided HANA solutions with complex business requirements, such as fast performance, multiple hierarchy levels, complex KPI calculations, complex calculation views and SQL procedures, and integration of HANA with Business Objects, etc.
• Administrated SAP HANA Enterprise systems, such as system monitor, trouble shoot, version, user and security management.