OBJECTIVE:

Looking for a HANA Data Modeler, SAP BW on HANA, BW/4HANA, or S/4 HANA developer position

SUMMARY:

• 10+ years SAP BW, SAP BW on HANA, ABAP, 3 years HANA Modeler, 2 years Oracle PL/SQL and Oracle DBA, 1 year Tableau development and BODS experience.
• Strong SAP native HANA development experience in all phases of the projects lifecycles. Hands on experience with HANA 1 SPS 11 and closely following latest HANA 2 and S/4 HANA developments. Performed data warehouse design by following solid design principles, designed ETL from ECC and Hadoop with SLT and BODS, wrote procedures with SQLScripts, and built Attribute, Analytic, Calculation Views with HANA Studio, developed Analytical Privileges to secure models and data security.
• Solid RDBMS, Data Warehouse and Business Intelligence applications experience. Certified as HANA, BW, BOBI consultant and Oracle DBA.
• Familiar with SAP's R/3, mySAP, ECC6, and S/4 HANA implementations and received consulting certifications in following modules: MM, PP, SD, and FI/CO.
• Familiar with ERP concept and core business processes. Trained and certified with CPIM, CSCP, Lean 6 Sigma Green Belt, and PMP designations.
• Continuously enhance skill set. Recently completed Machine Learning course from Stanford University and Big Data training from Clodera. Taking SAP S/4 HANA, SAP Fiori, Software Development on HANA, and Extended Supply Chain on HANA training from openSAP.
• Familiar with SQLScript, ABAP, C, C++, Python, PL/SQL, SQL, and BODS.
• Good problem solving skill based on solid education foundation and hands on experience. Willing to go extra mile to find best solution sometime requires out of box thinking and new invention. Invented Common Database Reporting tool for NASA Johnson Space center.

EXPERIENCE:

System Architect

Confidential, Sunnyvale, CA

Responsibilities:

• Designed and Developed Open Electronic Health Record (EHR) system with OpenERP and Open Postgress DBMS.
• Built complex interactive dashboards and reports with Tableau.

HANA Technical Lead

Confidential, San Francisco, CA

Responsibilities:

• Perform HANA technical lead role to re - engineer BW system to BW on HANA for a leading fashion company in San Francisco.
• Designed Sales, Delivery, and Billing reporting system based on LSA++ best practice.
• Lead offshore development team to consolidate SD Sales, Delivery, and Billing functions from multiple BW systems on Teradata and SQL Server to a single BW on HANA platform. With the reengineered system, user will be able to view companywide consolidated reports from a single and consistent platform.

Sr. HANA Modeler

Confidential, San Jose, CA

Responsibilities:

• Performed End -to-End requirements gathering, data modeling, data provisioning, report generating, and user training tasks for HANA projects.
• Worked with SME to collect requirements for Creative Clout Subscriptions Management (CCM) reporting system. Modeled and Provisioned SAP ECC data with SLT and Hadoop data with BODS based on SAP LSA++ architecture.
• Wrote SQLScripts to transform and cleanse ECC raw data in EDW layer and populate data mart layer tables for reporting. Built BODS jobs to start SQLScripts as job scheduler and populate Hadoop data.
• Built HANA Attribute, Analytic, and Calculation Views for reporting and Analytic Privileges for row level security. Build HANA Analysis for Office and Tableau reports for end users.
• Migrated HANA content from development, testing environment to Production environment using Delivery Units.
• Performed root cause analysis of performance issue and tuned SQLScripts and Models based on SAP Best Practices. Utilized database partitioning, table partitioning, and break down complex queries to intermediate steps to resolve memory usage and performance issues. Utilized Explain Plan and Visualize Plan to fine tune procedure execution performance, identified and resolved bottlenecks.
• Built complex interactive dashboards and reports with Tableau.
• Proposed and built standard currency conversion mechanism for Adobe global usage. This mechanism standardized and simplified currency conversion for all the HANA projects in Adobe.

SAP BW and BO Consultant

Confidential, San Jose, CA

Responsibilities:

• Worked with SME to collect requirements for financial Actual vs Plan data reports. Architect BI, R/3, and Essbase data interface and modeled data structures.
• Designed and implemented ETL for GL, PCA, CCA, and ECCS data from SAP ECC system.
• Developed interface to export finance actual data in BI to Hyperion Essbase application for financial planning.
• Designed and developed data model in BI to extract and store financial planning data from Essbase application. Built Actual vs. Plan reports.
• Designed and developed Logistic reporting system for SD and MM based on LSA++ best practice.
• Utilized LO Cockpit to populate SD and MM data from ECC.
• Extended business contents extractors with SAP suggested new ABAP BADI method.
• Architected Logistic reporting system with Bex query and BOBI tools.
• Built Universes with IDT, reports with WEBI and dashboards with Xcelsius.
• Performed the performance tuning from both back end data structures and front end reporting tools based on SAP suggested best practices.

SAP BI and BO Employee and Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Led Confidential ’s new SAP BI application implementation team with 4 developers and performed project management.
• Worked with Basis team to install and configured BI 7.0, SAP Portal, and Business Object Enterprise 3.0.
• Setup development standard, naming standard, testing procedure, and support procedure document standards.
• Worked with SMEs to collect requirements, firmed up functional spec and unified terminology.
• Activated and extended Business Contents in FI/CO functional area. This includes GL, AP, AR, FA, PCA, COPA, and CCA data providers, Transformations, DTPs, Data Sources, extractors, and reports.
• Custom built COPA, PCA, and Special Ledger data providers and data extractors to report line level details.
• Developed FI/CO and QM reports with BEx, WAD, and BOBJ WEBI.

SAP Software Engineer

Confidential

Responsibilities:

• Architected and developed BW FI/CO, SD, MM, HR reporting projects. Participated in APO DP and SEM BPS reporting projects.
• Developed multiple BW projects end to end. Starting with collecting requirements from report owners. Searching business contents or custom built required objects. Extend SAP pre-built extracts or write custom built extractors based on best practice. Built reporting structures which include Multi-Provider, InfoCube, DSO, Transformation, DTP, InfoPackage, and Process Chain. Built BEx reports and WAD reports for end users.
• Performed User training and support team training.
• Performed performance tuning by using aggregates, indexing, and other best practices.
• Architected and developed LSI Customer Order Status report. Utilize Microsoft SQL Server DTS ETL tool to extract data to populate Oracle EDW layer tables. Wrote Oracle PL/SQL procedures to transform and cleanse raw data to populate Data Mart layer tables. The reporting layer was implemented with Confidential WebSphere by other team member.

Oracle DBA, Database Application Developer, Unix C and C++ Developer

Confidential, Houston, TX

Responsibilities:

• Developed multiple Oracle database applications using Oracle ProC.
• Invented Common Database Interface for NASA Johnson Space Center and received NASA innovation award.
• This innovation can significantly reduce database application development time, effort, and cost.