Chun-Hung Chen Email & Phone Number

Columbus, Oh, Us

Created Delivered On-Time and In-Full (DOTIF) PowerBi Report for Transportation Management System to deal with data visualization and analysis on freight and delivery data through Microsoft SQL Server.Created Scheduled On-Time and In-Full (SOTIF) PowerBi Report for manufacturing plants production scheduling with inclusion of optimization metrics and various other KPIs.Created Deleted Deliveries Analysis PowerBi Dashboard Report and Celonis Process Mining Dashboard to deal with deleted order changes on the impact on supply chain from production to delivery from SAP data.Currently building Back Order Reschedule (BOR) Dashboard on Celonis Process Mining Software to deal with process analysis on automation optimization versus manual customer order fulfillment from SAP data.Versatics North America Warehouses Center of Gravity Research Project – Conceptualized from theoretical design to 1,000+ lines of R programming calculations using machine learning clustering methods to build optimum geographic location placements for new warehouse locations based on customer demand and various GIS data including delivery ports and manufacturing plants. Built geographic leaflet maps and presented through PowerBi Visualization Dashboard.Participated in various data science and database related work activities including simulation modeling along with addressing data related issues.

Columbus, Oh, Us

UIPlanner Regulatory Model System Administrator (Regulatory, Financial, & Accounting Forecasting System) UIPlanner Customer Revenue Model System Administrator (Customer Rates, Pricing, and Taxation System)PlannerDash System Administrator (Regulatory Model and Customer Revenue Model Dashboard System)Worked on large databases including data transfers and data creations (100 gigabyte plus datasets)Worked on addressing various data feed issues and technical issues including data cleansingCollaborated with Customer teams and Regulatory teams on various IT projectsResearch various state utility commission regulatory filings along with state and local tariffs and taxes.Worked on pricing analysis dealing with cost of service along with market databases (Moody’s Analytics)

I am currently a Senior Regulatory Demand Forecast Analyst for NiSource. Besides the duties of the forecast analyst found in the descriptions below, I also oversee several major regulatory case filings on an annual basis. These regulatory case filings include Columbia Gas of Maryland, Columbia Gas of Virginia, Columbia Gas of Pennsylvania, Columbia Gas of Massachusetts.I am now a representative on behalf of NiSource and NIPSCO Electric to Purdue University's State Utility Forecasting Group (SUFG) sponsored by the State of Indiana on the forecast of electricity consumption, prices and resource requirements.

Built demand forecast models, financial forecast models, risk forecast models, and operational forecast models. Provide regulatory and statistical analysis for strategic planning and demographic research. SAS, MAINFRAME and VBA programmer along with database analysis.Experience building natural gas demand forecasts for:(1) Columbia Gas of Kentucky (2) Columbia Gas of Maryland (3) Columbia Gas of Ohio (4) Columbia Gas of Pennsylvania (5) Columbia Gas of Virginia (6) Columbia Gas of Massachusetts (7) Northern Indiana Public Service Co. (NIPSCO)Experience building electric demand forecasts for:(1) Northern Indiana Public Service Co. (NIPSCO)Rate Case Filing - Weather Normalization & Test Year Witness for Columbia Gas of Maryland for the State of Maryland Experience building accounts receivable forecasts.Experience building meter-to-cash charge-offs forecasts.Experience building and updating weather normalization.Experience building monthly variance analysis and reporting.Experience building monthly Energy CHOICE demand curve along with SCO models.Experience building price elasticity models, saturation models, and attrition models.Editor for the annual demand forecast methodology booklet.Provide support to multiple rate cases and attend rate case hearings.Data programmer using SAS, MAINFRAME, EXCEL w/VBA, ACCESS, and MetrixND.Experience and training in rate design for various state public utility commissions.Subject matter expert in natural gas and electricity for various energy markets.

Cleveland, Oh, Us

Organized project teams, grading, assisted instructor in curriculum, maintained contact between project sponsors and teams. Assisted in the teachings of Six Sigma and Lean Management.

Akron, Oh, Us

Built sales production forecasting models from Goodyear time series data. Used sales forecasts to create presentations for management.

Managed and maintained international client relationships on various wholesale product orders. Worked with manufacturers on developing clients' product orders.

Minneapolis, Mn, Us

Maintained flow of merchandise from point of delivery to the sales floor or backroom. Responsibilities include receiving, unpacking, processing, organizing, and storing of merchandise.

Prepared and served meals for university students and faculty.

Assisted high school librarian in organizing library resources and making them available to users. Collected and lend books, periodicals, videotapes, and other materials.

Worked in a chinese restaurant serving customers as host and waiter.

Master Of Science In Management (Msm), Operations Research And Supply Chain Management

Master Of Arts (Ma), Financial Economics

Bachelor Of Science (Bs), Economics

Bachelor Of Arts (Ba), International Studies - Specialization: World Economy And Business - Minor: Japanese

School-College Articulation Program (Scap)

Education record

Education record

Education record

Education record

Education record

Master Of Science (Ms) (Incomplete)(Completed About 1/3 Of The Required Classes), Analytics