SUMMARY:

• 12 years of IT experience including over 10 years of implementing full cycle Business intelligence solutions in various industries.
• In the last 3 years she focused on Big Data solutions such as SAPHANA, Hadoop and NoSql, where she has been a thought leader & speaker on implementation of Big Data Solutions with Cloud Integration. She has been both implementation architect and solution architect leading an international team.
• Chemical, Communications, Consumer - Products, Pharmaceutical, Telecom, Commercial, Construction, Services, Automotive & Oil and Gas.

TECHNICAL SKILLS:

Hadoop: Hortonworks, Cloudera, Datameer, Datastax

HANA: BW on HANA and HANA Enterprise

Lumira: Storyboard, Extensions

Business Object: BI 4.1, 4.0, XI 3.1, XI 3.0, Basis, Database Architect, BO tools Universe (MDX), BI Analysis, Desktop Intelligence, Web Intelligence Reports (Webi), Interactive Analysis, Xcelsius (5.0, 5.1), Dashboard Builder, Crystal 12.1, Crystal 2008, Crystal 2011, Crystal Enterprise 4.0, Rapid Mart, Mobility. Installation and Security

Business Warehouse: FICO (AR, AP, PA, CCA, IP, SL, COPA ), SD, SM, CRM, MM, HR (ECM, PA, PD,OM, PACM, TM) and PS. BW on Hana

Business Objects Data Services: BODS 4.0 XI 3.2

Basis: BOBJ (All), BW (Support) and HANA (Support)

SAP Versions: R/3 - ECC 6.0, 4.7;6.0 BW - 3.5, 7.0;7.3 BO - 3.1, 4.0, 4.1

Languages: Basic ABAP, SQL; C++; HTML; Java Script; MDX; Macro, Visual Basic

RDBMS: MS SQL Server 2000; Windows 2003/2006; MS Access; Apache Tomcat, Linux

Other Skills: Proficient with Microsoft Office (exceptional skill in Excel and Access Database), Pivot Tables, Macros, MS Project, Outlook, Visio, Share Point Portal and Linux Distributions.

Speaking Language: Fluent in Chinese, English and sufficient in Spanish

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect

• Lead 6 people team from end to end implementation of internal inbound marketing tool utilizing web SEO, Marketing tools, Social Media. Increased traffic on average 265% per Month
• Program Manager for ATCG Near-line storage Solution: End to End Hadoop and HANA cluster.
• Co-Author Big Data Magic Quadrant Ebook 2015
• Secure partnership with Hortonworks, Datameer & Datastax

Confidential

• Patch and Upgrade BW 7.3 APO
• Phase B and C Release for 5 report (DC & 4R Lead Time Report, ISTO/STO, COGS, Inventory Report)
• Testing Report and transport through landscape
• Fixed high level metadata layer issues for the upgrade.
• BW/ ECC on HANA migration Strategy, Security model, Phase 1 estimation complete.
• In charge of all transport through Charm and fixed charm technical issues.

Confidential

Functional/ Strategy Lead, Lead Architect Developer, Basis HANA and BW support and Security Architect

• Lead Phase 0, Phase 1, Phase 1a, Phase 1b part of the project.
• Size BW and HANA environment and advice the client on architecture. Proposed 3 migration strategy and change management plans
• ETL in HANA Studio from /bic* tables and created reports using bi 4.1 tools.
• Enterprise HANA Development over BIC table for real time inventory reports
• Schedule HANA Job to run nightly
• Lead Optimization phase of BW before moving to HANA. Implemented Analysis Security (Rsecadmin) model in BW. Clean up legacy 3.5 data flow to 7.3 utilizing functionalities such as DSO look up. Reduced daily process chain run time from 9 hours to 3.5 hours.
• Hands on and lead PCA activity and other post migration activities. Clean logs, compressed data, cleaned up inconsistency in the environment.
• Lead the Lo cockpit loading activities for each environment.
• Manually backed up Hana environment while client procure HP products.
• Moved top 50 used reports, info-providers and data flow to the new BW on HANA system. Optimized data flow for reporting.
• Connected BOBJ environments to BW on HANA system and exposed top 50 reports in MS analysis and webI.
• Found issues with existing BW architecture, advice client to user timestamp instead of create on date for generic extractor because that field in ECC table is optional.
• Created Connection between New BW on HANA environment ECC environment (Sm59). Created partner profile and Idoc type.
• Activate BW on HANA standard content
• Connect BPC and DB connect (karmak database) to BW o HANA
• Created Users in Hana Studio and POC creating views off backend tables.
• Support phase 2a and 2b of the project. Estimating resources and create architecture for the Confidential dashboard (parts and services only).
• HANA BASIS Support: Monitor Hana backup in and troubleshoot the system in Putty. Due to our log space was filled quickly in the beginning of the project, Changed log location from /usr/…. to a mounted disk location. Schedule Data backup in DB13. Responsible for cleaning the log and backup config file. Train client basis team on HANA support.
• Install ODBC Drivers and connected to HANA /BIC tables for reporting and create HANA views off backend table.
• Leading Phase 2a BOBJ Executive Dashboard for Parts Services and Warranty. Leading through Development and UAT.
• Support all Basis transports and Notes and patches

Confidential, BI Team Lead for 6 person team

Functional Lead, Lead Architect Developer, Basis BW support and Security Architect

• Define scope of Brock Project in HR, SD, FI, and CO and laid out roadmap of future BW/ BOBJ landscape.
• Key decision maker on BW/BOBJ tool selection set the naming convention for global and regional reports and security strategy.
• Conducted blue print workshops to define necessary reports in operations (customer service management (SD,CS,MM), PS, PUR), Finance (AP,AR, GL, Asset Accounting, COPA, RA), and HR (PACM, Payroll, Benefit, CATS)
• Consolidated report requirements from multiple legacy systems.
• Estimated WRICEF effort, hired and trained new BI team members on shore and offshore.
• BW System Migration from Sandbox to Dev. BDSL all objects and reload the system
• Created demo in SAP BI 4.0 Sandbox to clarify capabilities of BI 4.0
• Installation of Business Objects 4.0 server and end user tools. Configured single sign on.
• Implemented 4 layer BI/BOBJ Security, leveraged BW security for authorization and BOBJ security for authentication.
• Delivered and tested 7 Xcelsius dashboards and 25 BOBJ MS Analysis reports concurrent with initial system go live. Each dashboard has backup detailed reports supporting the aggregated data. Each Analysis report has 4 views.
• Implemented 4 backup webI reports and ops dashboard onto BI mobile after upgrading BOBJ server to BI 4.0 SP5. Expose all reports and dashboards to IPAD and Iphone for the fields.
• Cleansed historical transactional data within Business Objects Data Services for HR headcount, salary information, and Service order/ Contract amounts. Created direct connection in BW and loaded historical data to reporting cubes and multiproviders.
• Created crystal reports billing backup against ECC tables and using ABAP ALV.
• Created training documents for end users and super users for MS Analysis, BI launchpad and Xcelsius
• Updated all documentation in solman and sharepoint.
• Setup BBR server for testing within a weekend and load all data to be ready for testing in ITM2 cycle.
• Upgraded BOBJ server from XI 3.1 SP2 to BI 4.0 and BI 4.0 SP 4 and 5. Migrated reports and Dashboard to SP 5.
• Changed Dashboard and universe design after portal implantation to take advantage of direct connection.

Confidential

Managing Consultant

• Responsible for BOBJ section on all bid and proposal and onsite presales for clients including: Kraft, Ebay, BMS, Confidential, Confidential, Honda and Maple Leaf.
• Created Internal dashboards for internal sales team that displayed all product offered in different sector, status, detail information about the product, main contact person, and major clients.
• Help building BO practice for Confidential by conducting phone and in person interviews
• Conducted Training Classes for BW consultants on BOBJ
• Support major BOBJ implementations on multiple projects remotely as SME.
• Implemented Rapid Mart POC

Confidential

BW and BOBJ Developer

• Evaluate current Wyeth architecture and complete gap analysis and recommend future architecture after the merge with Confidential .
• Lead a team of 5 and merged data from 5 historical databases and 48 extremely complicated finance reports using Webi/Crystal. Worked with a global team in China, Britain, Canada, and the US. Created a Butterfly format in WebI for all the reports display current period, current quarter and same period last year.
• Fine tuned universe and BW backend data model to improve performance. Decreased report rendering time from 5 min to 20 seconds.
• All WebI reports were drill through to crystal reports using opendoc statements
• Enhanced Special Ledger cubes to satisfy reporting requirements such as 445 calendar, international lag, Parallel trade macro interface, and HFM adjustments.
• Created BOBJ GME Workshop material and led workshop for all Confidential BI employees.
• Created BOBJ methodology and process for Confidential and leveraged the existing Confidential BW change control process.
• Supported APO BW Development

Confidential

Business Objects SME

• Created 3 supply chain dashboards include Cash to Cash cycle time, Global Spend, and Cash Region Roll up all with BW as the backend

Confidential

Business Object Lead

• Led sizing effort for Business Objects environment at Kraft, and recommended portal and security setup for business objects to the technical team.
• Created integrated solution leveraging Xcelsius and Webi for the sales team. Created a dashboard that 5000 sales field agents could access on their tablets to get their daily sales (Webi Report). Pass on all the parameter selected in Xcelsius to the Webi report using opendoc
• Created proof of concept reports in WebI, Crystal and Xcelsius for Finance and Sales Process Team. Passed on parameters from tool to tool to show interaction between Business Objects tools.
• Led blue printing sessions and worked with overseas technical team to deliver 12 Asset Accounting reports using Crystal and WebI.
• Assist Basis team to stabilize business objects environments
• Used widgets to expose dashboards to Iphone for internal sales team.
• Conducted technical knowledge transfer to the Kraft technical team.

Confidential

Sr. Business Objects Developer

• Led blueprint of Xcelsius dashboard with senior management and executives from Asia, Germany, Mexico and the US to fine tune requirements for 25 global financial dashboards.
• Led Business Objects architecture design meetings and project scoping effort (sizing, tool selections, portal, and security architecture)
• Led the development of Executive Dashboards, worked with senior executives in design and development of dashboards using BO tools. Key metrics: Order Accuracy, OTD, Backorders, Inventory Balance, Global Vendor Spend Analysis, Productivity, AP Balances, AR Balances, and Global Headcount
• Hands on development of financial ad hoc reports in WebI, Canned reports in Crystal, and executive dashboards in Xcelsius
• Fine tuned report’ performance by methods such as optimizing Universe, building aggregates, and optimizing query design.
• Single point of contact for the portal team to publish dashboards on SAP Enterprise Portal.
• Responsible for backend architecture of Business Objects connections to BW.
• Train the trainers on BOBJ reports in Asia in Chinese and successfully deployed training to more than 400 users.

Confidential

Business Warehouse Developer

• Lead BI HR project: scope, design, implement and support complex HR database modeling.
• Key resource for BI FICO implementation. Responsible for activate, configure and customize BI Content for AR, AP, PA, and CCA.
• Support for Titan Separation (Business was sold to a third party).
• Responsible for all transports from Dev to Con to Production.
• Estimated size of BW project using the SAP QuickSizer.
• Managed for Security Testing and Data Validation Efforts, Go-Live, System Stability and Change Management activities.
• Wrote ABAP Routine in the transfer rule to change the orientation of data before loading into Cube.
• Wrote user exits in CMOD for PTD, QTD and YTD
• Monitors Daily Process Chain in BIA and fix or refresh the blades when needed.
• Support BI and SAP Support Pack and Enhancement Pack installation.
• Research and implement SAP OSS notes for work around and communicate to basis for fixes.
• Provided knowledge transfer to the business and conduct Business Object and BI Training.

Confidential

SAP BI/ FICO Consultant

• Configured BW System (FICO-CCA & COPA) and conducted training in BW queries (FICO) to the clients.
• Configured of SAP R3 CO, SAP workspace, and Open Text in various projects.
• Configuration of SAP project system (PS) configuration: Backend master data, Network, Activity, and WBS Structure.
• Internal Project include: Share point Administrator, Participate in Share point (MOSS 2007) Migration effort, and consultant spend tracking tool using VBA.
• Ensure completion of project deliverables and adherence to timelines and budgets.
• Worked with oversea Consultants around the clock (Dallas, Shenzhen China, Pakistan and India).
• Support the sales Team, Prepared presale material, participate in customer meetings and responsible for post sale review with the customer.

Confidential

Technical Writer

• Worked with VP of Software Production on release of Enterprise Resource Planning (ERP) Supply Chain Tower software and complete documentations (user guides, product release notes and technical user manuals)
• Project Lead of global requirement tools project including scoping, researching and implementation, internal using testing and go-live.
• Generated customer satisfaction analytical report in Excel for VP and CTO