Resume

Experience

Senior Business Analyst                                                                 July 2017 – Present

Walgreens Company

Technical Product Development

• Synthesized product requirements with stakeholders in cross-functional teams to build partnerships, assess technical capabilities, acquire data feeds for model use, and maintain the roadmap
• Initiated and facilitated meetings with teams across the company to analyze and develop solutions and build model architecture
• Created measurement metrics to track development progress
• Visualized process flow, detailed model logic, product technical specs, and database relationship diagrams

Model Optimization,  Business Analytics & Operations Support

• Collaborated on labor-related initiatives with business teams including engineering, operations, and process optimization
• Reengineered operating hours revenue model and holiday closure recommendation store list by optimizing EBIT using R and SQL
• Presented monthly labor budget to executives in budget planning and audit meetings by conducting financial analysis, conveying business insights, and reviewing monthly initiatives
• Forecasted weekly sales volume for all retail stores monthly to feed into the model
• Interviewed business analysts/engineers in the hiring process

IT JDE Business Analyst                                                               Sep 2014 – Jul 2017

Federal Signal Corporation

System & Product Development, Operations Support

• Managed launches of full lifecycle system development projects by redesigning product configurations to eliminate SKUs and improving end-to-end order processes, from planning, requirement gathering, development, user testing, to deployment and refinement
• Secured key stakeholder buy-in including engineers, operations manager, VPs, solutions managers, finance managers, and product managers for adopting new applications in JDE to optimize UX/UI experience and business processes
• Resolved production and process issues for multiple manufacturing facilities with prioritizing by interviewing users and stakeholders, synthesizing information, testing applications in JDE
• Educated internal and external consultants on product configuration models to help the company smoothly upgrade its JDE version
• Represented the company IT team at Oracle Quest Collaboration 2016 and Kronosworks 2016 to survey technology trends and find solution partners

Business Analytics Lead

• Consulted business owners and analytics users on ERP best practices and analytical tools at all levels
• Administrated analytics modules, monitored ETL processes, reconciled manufacturing activity records with third-party partners
• Developed dashboards and analytical reports using SQL and OBIEE to track sales and operations status for executives across the company

Supply Chain and Logistics Professional Intern                   Jun 2014 – Aug 2014

The Walt Disney Company

• Cleaned raw data using VBA: including three years of logistics transactions and financial data for all business divisions of Orlando Disney World Parks & Resorts
• Performed gap analysis of the logistics and supply chain system between Orlando Disney World and Paris Disneyland
• Built logistics dashboard demos using OBIEE for Orlando Disney World collaborating with external database consultant

Graduate Student Researcher & Consultant                         Feb 2014 – Apr 2014

Purdue University – Technical Assistance Program

• Facilitated initial interviews, plant visits, and bi-weekly status update meetings with two local clients and a team of 5
• Identified clients’ needs regarding operation and product management processes, and clarified product proposals and project scope
• Recommended three ERP systems using a scorecard to help the client determine the ideal system upgrade based on strength/weakness analysis of 10 ERP solutions

Reliability Engineer Intern                                                          Jun 2013 – Aug 2013

Rockwell Automation, Inc.

• Remodeled a system-level reliability forecasting model to statistically predict the failure return rate of all new products using VB.NET
• Tested and simulated the model in Minitab by writing macros and applying Monte Carlo Simulation and Weibull prediction

Contact

Email: juegumyers@gmail.com

Expertise

Data & Analytics 7+ Yrs

Product Development 6+ Yrs

Database & System Tech 6+ Yrs

Skills

Notable Competencies:

Problem Solving, Product Lifecycle, Analytics & Business Intelligence, Data Modeling, Data Wrangling & Visualization, Project Management, Stakeholder Management, Requirement Gathering, Lean Six Sigma

Analytics & Data Tools:

Excel, VB/Macros, R, ggplot2, leaflet, Python, Pandas, NumPy, matplotlib, SciKit-Learn, Power BI, Tableau, Google Sheets

Product & Creative Tools:

InVision, Sketch, Balsamiq, Miro, Canva

Marketing & Organization Tools

Typeform, Mailechimp, SEO, SEM, Trello, Jira, Slack, Agile & SCRUM

Programming Languages & Syntax:

R,Python, SQL(Microsoft SQL Server, Hive, Oracle SQL, Teradata SQL), VB, C, Shell script, HTML/CSS, Javascript

Certifications

Full Stack Product Manager (Product Leader) – Product School 2020

Product Manager – Product School 2020

Fintech Applications & Technologies – University of Pennsylvania & Coursera 2020

Scrum Master – Scrum Alliance 2020

Level 4 Foundation Diploma in Purchasing & Supply – CIPS 2009

Education

Master’s degree focusing on Supply Chain Technology & Analytics) – Purdue University – Aug 2014

Double Bachelor’s in Mechanical & Manufacturing Engineering in Shanghai & Dayton, OH (3+1 program)- University of Dayton & Shanghai Normal University – Jul 2011

Publications

Co-authored two conference proceeding papers on Biometrics Analysis (ICITA 2013) and Six Sigma in High Tech (ATMAE 2013)

Activities

UNICEF Unite Midwest Council Lead – Since 2018

UNICEF USA event active volunteer & summit committee – Since 2017

Walgreens Annual Talks Committee (TedEx Style) – 2018 & 2019