SUMMARY

• Expertise in analytics, software design, project management and data quality control for mission critical and regulatory data.
• Unique skill sets for root - cause analysis, troubleshooting, fixing problems cross data pipelines. Know-how to improve App health and to keep the Business Running (KTBR) by creating data quality systems, such as monitors and alerts.
• Extensive working experience in modeling and transformation, innovating new approaches and methods based on data mining, statistical analysis and prediction models with SQL and Python.
• Original design for Confidential Cost of Sales Tools (iCOST), EDW subject areas, SAP modules and other information systems. BI system architect for inventory control, auto-reconciliation, cost analysis, financial reporting, demand forecasting, shipment, Intransit and RMA.
• Leadership roles in SDLC, including Sr. business Analyst, Sr. data Analyst, Sr. system analyst, project manager, chairman of change-control board, scrum master, leader of global team, data pipeline integrator and owner for systems cross enterprise.
• Capable to work with cross-functional teams, multi projects and multi tasks simultaneously. Closely working with different business clients, defining scopes, transforming requirements, creating system solutions, managing projects and leading teams
• Award winning for FP& A, auditing, and SOX Control. Outstanding knowledge about enterprise financial info systems, rules, regulations and processes. Passed license exam for Series 24, 27, 7 and 66

TECHNICAL SKILLS

Programming: SQL, Python, HTML, SAS, R

Databases: MySQL, SQL Server, Oracle, Teradata, MS Access

App System: BI, SAS, SAP, Salesforce, EDW, Hadoop, Spark, MS Office

OS & platforms: Windows, Mac OS, Linux, VM, Docker, Kubernetes, OpenStack

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Responsibilities:

• Guided research and design intelligent MES, for robotic-operation factories; integrated with planning application systems for completely automation and optimization; minimized human being involvement.
• Conducted Salesforce systems integrations, streamlined data flow and usability across data pipelines from MES based on IBM’s DB2, Oracle ERP, SAP shipment and invoice.
• Reengineered CDW and analytics, funneled data through entire data pipeline from opportunity, quotation, pricing, and discount analysis, order entry, order management, logistics, returns, generating revenue.
• Designed and developed an early warning system to strengthen the communication between customer and factory. Synchronized ecosystems, including inventory and financial analysis, discount-analysis for sales incentive, cycle time and inventory aging.

Senior Financial Systems Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Originated the design logic and specs for the $100M+ iCOST ( Confidential Cost of Sale Tool) system based on SQL Server, used for cost evaluation and financial reporting of $4 billion in monthly revenues. Cut closing processing time from 7 to 5 days, producing consistent high DQ for better business decisions.
• Managed projects of mitigating risks and potential risks; Owned SOX control areas (ID 21, 101 and 118), passed audit testing with zero defect. Earned approval from finance managers & controllers, successfully and legally closed financial book on time each month. Samplings, modelling, predicting and statistical analysis were conducted by Python and SQL.
• Conducted research, designed prototypes, and created the data models and process logic for Confidential ’s Unit Reconciliation (UR) system, enabling automatic troubleshooting of data quality (DQ) issues and proactively mitigating risk.
• Pioneered the SAP HANA and SAP re-platform projects, validated sales transaction data flow from SAP SD through Business Warehouse (BW) into EDW, CIBR and iCOST without any quality degradation, where EDW is based on Teradata, CIBR on Oracle and iCOST on SQL server.

Senior Systems Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Designed and created EDW based on Teradata, defined EDW subsystems (subject areas) for transaction, inventory, mfg-flex, cost, planning parameters, Item-BOM-Route (IBR), sales distribution and shipping notification. Collected data from source systems, ETL (extracted transferred and loaded) into EDW.
• Conducted statistical analysis based on data in EDW, generated the business intelligence and created solutions for RMA and other services. Designed and developed Monitors and proactive alerts to point out any critical and potential issues
• Supervised the India-based team; reviewed and validated data model and code changes in each release of CIBR and IRS.

Senior Data Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Designed Inventory Reconciliation System (IRS) and replaced manual data reconciliation effectively, made IRS as an essential tool for automatic risk management and quality control, and eliminated man-made inconsistence and ghost feeling.
• Created data models and algorithm for MFG Flex, which becomes enterprise standard system. User community can derive optimal results from MFG Flex to achieve high quality and low cost, by min TPT and max mfg yield.
• Re-designed DemdPro, coupling demand with supply chain systems; auto alignment crossing application ecosystem; and auto-rebalancing MPS whenever demand signal changed.

Senior Business Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Created the automatic scorecard tracking system for supplier performance and quality for the purchasing department during contract negotiation and long-term planning.
• Created an internal integrated system that automated routine business operations with 3 modules
• Corporation Inventory Business Repository (CIBR) system for inventory control, Equivalent Shippable Units (ESU) for forecasting supplies, and IMPACT for what-if analysis.