Data Supply Chain

Amy Si Dou

Location: Cupertino, California Cell: 408-***-****

https://www.linkedin.com/in/amysidou Email: ********@*****.*** Summary

Information technology professional with extensive experience in relational database and data warehouse development and support. Expertise in implementing complex system interfaces/data integration/data quality analysis/BI reporting/SAP BW solution. Excellent analytical troubleshooting and problem solving skills, result-oriented, and a quick learner with outstanding dedication to customer services.

• Database technology / SQL programming /data warehousing

• Database Administration / Application administration

• SAP BW / BI analytics / Data quality analysis / dimensional data modeling

• Business Application Development / Application support Expertise Relational Database /data warehousing, ETL process, Programming/Application Support/problem solving, system interface design/integration/ system migration/business reporting, requirement analysis, SQL performance tuning, dimensional data modeling, DBA (i2 DP)

Languages T-SQL, PL/SQL, Ksh scripting, ABAP, R, C, HTML Software SQL server, SSIS/DTS, Oracle (Sqlplus, CTL, store procedures), Informatica, Toad,, i2 demand planner, Hyperion, SAP BW (infocube/DSO/PSA, data source, open hub, BW Bex reporting/ BO), HANA, Tidal scheduling, SAP R3, SAP APO, SCRM, ESSBASE Operating

system

Windows, Unix/Linux

Senior system developer/analyst, Global IT, Hewlett Packard, 2008- 2016

• HP company split project: completed SAP BW system interface testing and data loading from various interfacing systems, splitting Unix scripts for global and Americas SAP BW system, testing various SFTP interfaces

• SAP SCRM implementation, PL-SQL programming on sourcing Master data, interface design /development between SCRM and SAP BW, BOM data analysis, create SQL solution for complex BOM handling.

• Design and implement SAP BW/APO supply chain planning reporting solution (Bex/BO)

• SAP HANA migration system/BW application layer testing

• Supply chain visibility project: lead on Master data sourcing from ODM partners and design solution to combine multiple sources to enable business reporting.

• Data analysis and interface design and development between different BW systems and oracle applications for planning projects.

System Analyst/developer, Image Printing Group IT, Hewlett Packard, 2003- 2008

Design and implement Regional SAP BW/APO supply chain

Data analysis and interface design and development between different systems, include extracting data from Oracle data warehouse to SAP, sending SAP to Oracle data warehouse.

Responsible for move to production and post-

and analyze system data quality issues and resolve them.

Writing complex Oracle sql views to transform the data into the format that required by receiving system SAP.

Database developer/analyst, Consumer Business Org, Hewlett Packard, 1999- 2003

Data warehouse migration: one of the two key developers who completed migration of SQL server data warehouse into oracle data warehouse including related application interfaces (recoding 100+T-SQL scripts/store procedures into PL-SQL and unix shell scripts)

Develop, implement and maintain interface between Data warehouse (based on SQL server) and i2 Demand planner application

SQL store procedure performance tuning: reduce nightly reporting processing time from 8 hours to 1 hour.

Write store procedures, triggers and DTS packages for business rules, responsible for data transformation/extract, import/export and archiving

Develop Oracle9i Portal reference table maintenance too analytical platform implementation in the division

Application Administrator and DBA for i2 Demand Planner application

Implement and code changes on Data warehouse processes based on business requirement

Troubleshoot data warehouse operational problems and analyze data integrity issues

Maintain Web reporting program written in ASP

data warehouse processing

Previous work experience:

Enterprise software implementation specialist /technical Support, Hewlett Packard

Design solution and implement Brio client/server reporting solution on HP order fulfillment architecture for Asia Pacific, Latin America, Canada order processing users

Implement Dealer Price Decrease program to Latin America and Canada users

Manage and implement major business software release and patches

2nd tier IT/user support for HP worldwide order fulfillment users and Conduct user training

Software testing and assist in software specification

Provide technical and application support for HP order fulfillment systems for entire Asia Pacifica region

Manage move to production upgrades and software installation

Manage production job scheduling and application production account ensuring security and control are in place under HP IT guideline

Team lead for Geographic support team and mentor new members Education

Master in Information Science, University of New South Wales, Australia

Bachelor in Computer Science, Northeast University, Shenyang, China Awards

CIO excellence awards 2013 (for the most recent position) Foreign Languages

Fluent in Chinese

Publications

80+ essay/articles published in Singtao Daily Newspapers and Qiaobao Newspapers (2007-2012)

Contact this candidate