Dan Vibhagool Email & Phone Number

Bangkok, Bangkok City, Thailand

Greater Seattle Area

• Creates data pipeline (ETL) using Python and SQL store procedures.
• Designs and deploys dimensional data modeling by utilizing star schema framework, data dictionary, and complex SQL query
• Builds customize dynamic business logic in the reporting layer using tabular DAX measures.

Bellevue, WA

• Worked on a testing program of integrated customer facing and back-office applications for T-Mobile
• Worked independently with minimal guidance in a high-pressure environment to gather information and develop execution plan
• Gathered and managed the business and technical requirements and interviewed stakeholders to align goals and results.
• Utilized SQL to accelerate data preparing process. Developed test cases and prioritized testing activities. Executed test cases and report defects.
• Experienced in working in software engineering methods like Agile method, Waterfall Method.

Greater Seattle Area

• Created a labor model that improve MOD Pizza’s ability to optimally schedule their employees given a specific demand
• Conducted research on industry best practice to find potential solutions that is suitable to client’s needs
• Used traditional time studies to capture non customer facing time (Ex, Food preparation, and dish washing)
• Developed a simulation to capture customer facing time (Every tasks that occur in front of customers) to find optimal number of employee given different objectives such as employee’s utilization and customer wait time.
• Provided a final recommendation in term of how many entrée needed to earn one more employee hour

Greater St. Louis Area

• Developed a Cost Estimating Relationship model in Excel VBA using Optimization and Multivariate Regression to estimate unit cost, repair cost, and lead time of C-17 maintenance program. Utilize a backward elimination.
• Developed simulation models for different inventory segmentation levels to optimize fill rate of service parts and to find the scenario that is the most cost effective (maximize return on investment) and meet the.

Bangkok, Thailand

• Implemented business intelligence queries. Main tools include Excel, SAS and SQL
• Communicated with the marketing, finance, and risk management team in the implementation of the campaigns
• Performed advanced predictive analytics and conditional logistic regression in large quantitative data sets to predict customer’s spending behavior
• Analyzed credit cards holders’ purchasing data and created marketing campaigns that lead to 30% spending increase

Bachelor’S Degree, Industrial Engineering

High School