Sales Data

Edward Huang

Email: *****@****.***

Cell: 312-***-****

Summary:

** **** ********** ** **** and business analysis, Tableau reporting developer(8/9), system implementation, Various database operation, statistic modeling and data mining, Strong finance accounting and reporting knowledge and skills, Active CPA license(DC and Colorado), OLAP investment analysis, investment project analysis, SOX compliance, SEC regulation, Public Company Reporting(10K/10Q), strong communication and team working in the very dynamic environments, eager to create value for organization.

Strong knowledge and skills with data mining, modeling, analytic and providing highly scalable solutions using Tableau and Power BI.

Experience in designing, developing, scheduling reports/dashboards using Tableau 8/9, integrate tableau reporting with various databases.

Experience in creating tables and SQL query in SQL server, Oracle, MySQL, and Hive.

Expertise in optimization and performance tuning of complex T-SQL /PL-SQL solid understanding of indexes and window functions with large scale databases

Strong foundation in data warehousing concepts including source to target data mapping, slowly changing dimensions and star schema mapping

Intensive experience in data modeling and data mining with SSAS, Tableau and PowerBI.

Running online real-time analysis with Essbase, Cognos and JD Edward.

Understand Hadoop ecosystem, Hive, Pig, Mapreduce, Sqoop, Spark, HDFS, Cloudera manager.

Understand OLAP finance system such as Bloomberg Terminals / Sales force

Strong finance and accounting knowledge for IT project planning and forecast, project cost analysis, project justification and agile development.

Hands on experience on Python scientific and analysis models Anaconda/ Enthought Canopy (Numpy, Panda, Seaborn etc)

TECHNICAL SKILLS:

Reporting Tools SSRS,Tableau, PowerBI

ERP SAP FICO/JDEdward/Hyperion/Essbase/Cognos

Databases DB2, SQL server, Oracle, MySQL, Hbase, Cassandra, Teradata

Data Modeling&Analysis SSAS, Tableau, PowerBI and Scientific Python

Developmental Tools Visual Studio, Microsoft projects

Presentation MS Powerpoint and MS word

Coding Languages T-SQL, P/L-SQL, Python, Shell Script

OLAP: Bloomberg Terminal / Hadoop

Certification:

CMA: Certified Management Accountant ( Certified in New Jersey, US)

CPA : Certified Public Accountant (Licensed in Washington DC, and Colorado state)

Education: MBA in accounting, Marharishi University of Management, 2013, Fairfield, IA

Master of Information Technology, University of North American, 2016, Vienna, VA

Professional Experience:

JLG industry, Hagerstown, MD ( 2012/7 -2016/3)

Business and Financial data Analyst / Tableau developer

Project:

JLG is No. 1 global equipments manufacturing and sales networking company, Operating in more than 40 countries. data platform integrates structured data from ERP and BI platform system and unstructured data from website browsing and Social media data to improve operation as following :

Improve business forecasting

Support of customers service

Real-time control on manufacturing and operation activity

Supplier Chain and Sales analysis

Technology structure

SQL server, Access, JD Edward, Cognos BI, Essbase, Microsoft Networking, SAP, JDBC, DB2, Oracle database, Enterprise data warehouse, T- SQL, Tableau 8/9, Python analysis module, Unix, Teradata.

Responsibility:

Installed and configured BI and ERP (JDEdward) Assisted in performance tuning.

Transferred business and operation requirement as software functions implementation to maximize software functionality.

Rebuild and streamline business processing with software operation to improve working efficiency and accuracy.

Developed scalable data ingestion pipelines to consume intelligence data from various feeds into Essbase.

Understand business and management team expectation, build dashboards to reflect KPI and track KPI change with Tableau in weekly and monthly manner.

Extensively used Tableau as data mining tool to discover data pattern and conduct linear and regress analysis to provide forecast on major business operation

Built analysis with Python module ( Numpy, Panda, Seaborn)

Write complex SQL to pull out products and project cost and revenue data from DB2 and SQL sever database to model operation data.

Worked with implement team to develop schema and data cube to support various business demand.

Developed algorithm in tableau to perform relevant analysis across stocks.

IT Auditing expense and production data to make sure operation and accounting data integrity in the system to meet regulation and compliance.

Manage investment analysis, justify investment in finance perspective (IRR, Payback, NPV,PE, dividend per share and other index)

Aeron Lifestyle Technology, Fairfield, IA ( 2010/9 -2012/6)

Assistant Controller of Financial analysis and Business

Project:

Aeron is leading company in household flagrance products in US and Canada, operating in North American and Asian market.

The project is to develop manufacturing control information system on inventory production cost and manufacturing planning and integrate with ERP and BI reporting tool to improve cost control, inventory monitoring, AP/AR tracking and accounting monthly closing.

Technology structure

SQL server, Access, Sage manufacturing, Microsoft BI tooling, Microsoft Networking, SAP, JDBC, Microsoft three ties structure, T-SQL, data warehouse cube.

Responsibility:

Implementation Sage manufacturing system to control production working order and tracking products cost.

Design management report to catch up all important index to address management concern.

Integrate and configure Sage manufacturing with SAP system and feed manufacturing information into ERP system to support finance and accounting cycle.

Tracking down purge and downtime in production modules and generate report and feed into SQL server database.

Design process to track AP/AR and outsourcing production tooling to manage working capitals with software function and

Assist accounting team to finish Monthly closing

Project budget and cost forecast, planning, analysis and controlling

Min-metal, China 2005/4 -2009/12

Controller of Finance and Business

Min-metal is leading material and metals products in world, one of 300 future companies.

Project:

This project is to develop distributed sales,purchase and inventory control system to manage sales, purchase, and inventory in multiple locations to provide real-time transaction information and feed information into ERP system and BI report

Setup client interface in sales and warehouse spots, through local lane or internet to connect main server ( AS400 main frame) and feed all sales, purchase, inventory and operation expense, and integrate with ERP and data warehouse, also provide various management reports

Technology structure

SQL server, Customized distributed operation system, Microsoft reporting tooling, Microsoft Networking, SAP, JDBC, T-SQL, data warehouse cube, local lane and internet, Advance excel, Access, lambda structure( real-time and batch processing)

Responsibility:

Implementation distributed operation system to control sales and tracking sales cost in different location in real-time manner.

Design management report to catch up all important index to highlight management concern.

Integrate and configure distributed operation system with SAP system and feed operation information into SAP system to support accounting monthly closing and finance reporting.

Tracking down operation information and feed into SQL server data warehouse.

Design form and process based on IT system feature to supervise AP/AR account age.

Project budget and cost forecast, planning, analysis and controlling.

Provide financial analysis on product margin, inventory turnover and AR/AP operation.

Contact this candidate