| EMPLOYMENT HISTORY Dell Computer Corporation, Round Rock, Texas 04/00 - Present Finance Consultant (11/03 - Present) " Core team design, deploy and maintain Outlooksoft Everest GA, 4.1, 4.2 SP1 / SP2 implementation for single-server and tiered environment deployments. Provide day-to-day support for WWOPS Finance OPEX ( PG, IT & WWP ) teams during quarterly forecast cycle period to ensure forecast cycle data accuracy and process efficiency. Working with GFS/IT team and participating Everest migration to IT Server Farm project. " Design, deploy and migrate legacy PG Finance Monthly Closing process to Outlooksoft 4.2 environment following the project management process. Consolidate and establish repeatable monthly closing process, increase business efficiency and reduce technical support needs by 50%. " Completed PG/ESG Order Summary Reporting process migration to GPL2 and new weekly validation sheet against WWPW. Performed and trouble shoot weekly reporting process to ensure weekly reporting reliability. Communicate with users and partners proactively for any process or source data related issues or changes to ensure reporting consistency. " Design, deploy and maintain Free Promo Reporting process to determine appropriate revenue allocations to Imaging & Printing group for impact of free promos campaigns. Deliver quarterly comprehensive and customized metrics reporting capabilities to show revenue attribution for single and multiple (bundle) free promo items. " Working with Storage Finance team, research and define EMC Solution Purchase reporting process for world wide ( 4 regions ) to present EMC/Enterprise product solution purchase value, display P/L impact and opportunity. " Provide on-going feedback to GIS/D3 team to ensure company wide reporting data consistency and accuracy. " Serve as a subject matter expert to LOB analysts, provide guidance and training for reporting generating and support multiple ad-hoc reporting requests. Project consultant (04/00 - 11/03) " Define, design and deploy key measurement metrics to combine multiple on-line off-line data sources. Deliver comprehensive and customized metrics reporting capabilities to measure the success, effectiveness and benefit savings of projects and initiatives. " Lead and drive eSupport web metrics data transition from a non-standard solution to a corporate standard solution ( i.e. Clickstream). Utilized BPI techniques and strategies to improve the technical support metrics. " Provide over sight management of requirements and specifications for metrics accumulation and validation, serving as the technical liaison between business and multiple internal and external (IT) development organizations. " Provide analytical consultation and project planning/performance analysis for BPI initiatives, multiple program teams as well as regions during program development following the MFS process. " Gathered and synthesized information from Dell Data Warehouse. Additionally, designed the After Point of Sale (APOS) revenue reporting process providing close-rate and traffic efficiency analysis. " Developed comprehensive training for new team members, multiple internal customers and partners to provide a clear understanding of support and service measurement, metrics, benefit savings, and calculation guidelines. This supports initiatives to standardize metrics measurement across organizations. Halliburton Company / Dresser Equipment Group Austin, Texas 09/97- 04/00 Production Data Center Administrator " Created and maintained executive dashboard. Provided and analyzed charts, reports and presentations regarding production efficiency, employees' productivity and projects status for management as required using mathematical Statistics theory. " Developed, redesigned and transferred multiple legacy databases to be Y2K compliant and data warehouse ready base on Starflake schema. " Developed and modified production data flow procedures, applications and assisted network upgrade to be Y2K and ISO compliant. Addax Computer Corp. Dallas. Texas 12/96 - 09/97 Computer consultant / database application developer " Designed and implemented of database projects using Oracle Forms 3.0, SQLplus* " Provided hardware and software support to individuals. Assisted in correcting network and database problems associated with software and hardware upgrades. Oklahoma City Univ. dept of computer science, Oklahoma City, Oklahoma 09/96 - 12/96 Programmer / tutor " Designed university apartment management database with retrieve, insert, delete, and update data functions. Created boarding student profiling, room assignment algorithm and process deployment. " Designed department course scheduling and classroom allocation by using Intelligent Database model Tunghai University, dept. of mathematics, Taichuang, Taiwan 07/93 - 06/94 Teaching assistant " Supported and assisted computer Lab and LANs deployment. " Assisted students with programming assignments and served as a mentor. EDUCATION / CERTIFICATIONS M.S in Computer Science Oklahoma City Univ. Oklahoma City Univ, Oklahoma B.S in Mathematics Tunghai University Taichung , Taiwan Microsoft Certified Database Administrator Microsoft Certified Systems Engineer, Microsoft Certified Professional + Internet. ( MCSE 4.0, MCP+Internet ) PROFESSIONAL SKILLS / TRAINING " Project Management : Project Management Principles, Tools & Techniques. " BPI Greenbelt training. " MS SQL 2000, Analysis Services. " Oracle 8 database administration. " Oracle 7.0 PL/SQL, Oracle SQLplus*, MS Access. " Strong in RDBM and data warehouse design, Starflake schemas, multidimensional schemas and clickstream data webhouse design. " Proficient with PC hardware configurations and fluent in Mandarin and English. AWARDS Dec. 2000 Dell Computer Corporation 3rd quarter MVP award Oct. 1998 Wayne-Dresser 3rd quarter Teamwork/Leadership award REFERENCES Available upon request, willing to travel. |