Post Job Free

Resume

Sign in

Data Analysis, IT system Analysis, Python, R, SQL, Excel

Location:
Hayward, CA
Posted:
February 17, 2018

Contact this candidate

Resume:

Alex Cheng

650-***-**** ac4ikb@r.postjobfree.com Hayward, CA 94541

https://www.linkedin.com/in/cheng-alex/

Data Analyst

Data Analysis & Finance professional with comprehensive knowledge of IT

Analytical professional whose background uniquely combines financial analysis and supply chain management with a strong IT and business acumen. Expertise in building data systems, analysis, modeling, policies, and processes to enable business operations and support improvements in accounting process.

Areas of Expertise

Cost/Benefit Analysis Modeling Budgeting Financial & Operational Data Analysis and Reporting

Quality Management Root Cause Investigation & Corrective Actions Variance & Trend Analysis

Logistics & Supply Chain Management Process & Procedure Development Performance Monitoring Database Development

Proficient in Microsoft Excel, Oracle MySQL, PostgreSQL, Python (including CherryPy and Django) and R,

Professional Experience

Kaiser Permanente Pleasanton, CA Nov 2017~Present

Senior Data Analyst (Contractor with InsightGlobal)

Working with various interdisciplinary team for analyzing the data regarding the Kaiser Permanente system. Key functions:

Gather requirements for reporting business metrics.

Analyze business data and puts analysis into reports which indicate the performance of the IT department.

Represent analysis outcomes in template reports and presentations.

Based on analysis, make recommendations on improving or correcting metrics and operating performance.

S.F. Express USA South San Francisco, CA Apr 2013~Nov 2017

U.S. branch of the largest express company in Asia-Pacific area with 650,000 employees worldwide. U.S. operation has 180 employees and reached $55 million in revenue in 2016.

Senior Data Analyst/Project and Customer Solutions Manager (Feb 2017–Nov 2017)

The major role of this position is to replicate efficiencies in international operation and adapt processes and procedures for the U.S. market.

Work with the data and quality center department for evaluation of its performance and provide necessary training and instruction.

Working to optimize AR/AP processes and resources for 4 warehouses in California, New York, and Delaware handling shipments internationally. Key initiatives:

oAnalyze and improve standard financial and operations procedures.

oIntroduce automation to minimize human error.

oEvaluate resources at each location and identify staffing needs based on current/forecasted volume.

Aligned international IT systems to enable standard financial reporting and seamless communication of data.

Elevated customer satisfaction by launching initiative to better understand customers’ needs, standardize shipment handling processes, and educate customers on company’s capabilities.

Data Analyst/Senior Data Analyst/Head of Data and Quality Center (April 2013–Feb 2017)

Brought on board to support company’s expansion into the U.S., working effectively in a startup environment. Generated reports for management across all departments, including finance, operations, human resources, customer service, marketing, and IT.

Supported finance department in preparing budgets by forecasting operational volumes and costs.

Generated a variety of operations and financial reports, including volume reports, revenue reports, and QC reports.

Created various modeling excel tools for financial team.

Enabled regulatory compliance by developing invoice verification system for auditing purposes.

Built new data structure and system to enable company operations, including creating backend database and maintenance/extraction tools, developing internal website for shipment billing, setting up data exchange interface for clients and vendors, and designing all data collection policies and procedures.

Handpicked to establish and manage the Quality Control Team. Interviewed and hired team of 9 employees, including analysts, programmers, QC specialists, and assistants.

Developed logistics tracking and alert system database including inventory control function using Linux/MySQL (later upgraded to PostgreSQL) with 100+ tables and 200 million event records.

Promoted continuous improvement to logistics by reviewing operational processes, analyzing failures, identifying root causes, and developing corrective actions.

Contributed to profit growth by building financial tool that analyzed revenues and costs for multiple partners.

Fiona Wang and Associates Accounting Firm Hornsby, NSW, Australia Jan 2011–Jan 2013

Accounting firm with 33 employees providing accounting, tax, audit, and financial consultancy services.

Assistant Accountant

Reviewed internal control process and prepared audit reports for corporate clients, including mid-sized logistics companies. Prepared and filed business activity statements, financial statements, and personal tax returns.

Trusted to handle clients’ complex accounting duties on behalf of the firm’s Chief Accountant and CPA.

Education

MACQUARIE UNIVERSITY graduated 2011 Sydney, NSW, Australia

Bachelor of Commerce in Professional Accounting, Major in Accounting and Business Management

TAFE NSW Hornsby, NSW, Australia

Advanced Diploma in Accounting

Languages

Fluent in English and Mandarin



Contact this candidate