Andy Lee Email & Phone Number

Columbus, Indiana, Us

Provide strategic and project leadership to Business Analytic team.• Develop BI strategy for newly founded Data Analytics team to align with overall business strategy. Promoted two team members and built a team to streamline the process and provided better support to the organization. • Served as Subject Matter Expert for BI related inquiries from leadership. Provides advisories for proper data/tool to be used for BI reports/dashboards. My team built over 400 reports/dashboards annually. • Personally built and maintained over 30 BI reports/dashboards using various digital tools (SQL, MS Power BI, MS Office 365, Oracle BI). Including an executive dashboard for senior leadership to monitor Top 10 KPIs.• Led efforts on Data quality and integrity efforts to ensure “one source of truth”. • Launched an ERG (Employee Resource Group) for Asian employees and chaired the group. We hosted multiple events to raise cultural awareness, mentoring group members and help develop career plans for the members.

Columbus, Indiana, Us

Provided leadership on Finance Functional Excellence works.• Led a major ERP transformation project for the region with 50+ sites. The outcome was recognized by senior leaders and received “Exceed Expectation” for the year.• Served as liaison between business and finance team interpreting finance data and operational data. • Led process improvement works with regional controllers.

Columbus, Indiana, Us

Held P&L responsibility for a $10M Planned Maintenance Business.• Developed operation reports using existing sales data. Achieved 10% annual Sales growth from 2014 to 2017.• Drove Customer Service Excellence initiative for the organization. Improved overall NPS scores from average 7.8 to 8.9.

Columbus, Indiana, Us

Oversight for Functional Excellence for Planned Maintenance Operations.• Developed standard operations procedures and contract management process. Delivered training to 20 team members including both Sales and Contract coordinators. • Reduced unapplied cash for PM operation from $460K to $20K.• Improved warranty recovery rate from 85% to 95%.

Columbus, Indiana, Us

Oversaw Strategic partnership between internal customer and business unit.• Facilitated monthly Executive meetings with senior leaders from both customer and support team. Monitor and follow up with both organizations on supply/product/sales issues.• Working with global regional General Managers on balance supply plan to both external OEM and internal OEM customers. Improved overall profitability 10% over 3 years.• Led negotiation internal transfer pricing. Achieved market-based transfer pricing for internal OEM customers.

Columbus, Indiana, Us

Managed Center of Excellence for Power Rent Global Operations and Led implementation of $1.5M Rental System for Global business.• Six Sigma champion for Power Rent Global Business.• Create Center of Excellence document in the first 6 months to be executed for 5 global regions. • Developed global standard utilization reports and tracked global fleet utilization. The report helps to improve utilization by 7% globally.

Columbus, Indiana, Us

Served as Quality Champion to help business area finding cost saving opportunities in Sales and Marketing.• Project: Improve On-Time completion percentage at Sheet Metal/ Fabrication department (Internal supplier).• Project: Improve Order Management Process | Project: Reduce responsive time for customer inquiries.• Project: Improve Marketing Spec Sheets publishing process | Project: Improve Communication efficiency.• Project: Improve fleet utilization for North America Rental Fleet.

Columbus, Indiana, Us

Managed logistics for National Fleet of rental business. The fleet consists of 600+ units and at asset value of $150M.• Identified sale opportunities and conduct sale activities for used equipment. Achieved sales of USD $2M for used equipment in one year.• Implemented e-business initiatives for rental business and Rental Management System in 3 months.• Led product development for containerized gensets. Introduced 3 models in first year and 2 in second year.• Supported distribution network in general rental business issues. Obtain Excellent rating 2 years in a row.

Columbus, Indiana, Us

Overall profit/loss responsibility for Genset Assembly operations at Beijing. • Established start-up operations for Generator Sets Assembly Plant. Commission production in 3 months.• Introduced new products to China Domestic Market. From 3 models in first year to 10 models after 3 years.• Improved annual production from $2M in the first year to $6M after 4 years.• Implemented an ERP system (Movex) for both Distributor and Manufacturing in 9 months.• Implemented ISO 9000 certification process. Obtained ISO 9002 certification in 6 months.• Led warehouse operations at factory with inventory level at $1.5M. Achieved inventory turns of 3 per year.

Columbus, Indiana, Us

- Developing a $3M operation plan for China Assembly Plant.- Developing capacity management tool for shop operation.- Developing simulation model by using simulation software to assist manufacturing process design.- Developing process documentation for manufacturing processes.

Plymouth, Mi, Us

Operations Manager 2/1991-7/1993- Coordinating and supervising in-house engineering projects. Supervise 10 engineers of which 8 of them have graduate degree in Engineering.- Writing technical reports and communicating with customers.- Designing training programs for in-house engineers. The programs successfully trained entry-level engineers into proficient level within three months.- Administrating employees' legal status settlements. Help more than 15 employees settle their permanent residences in United States.Contract Engineer 11/1988-1/1991- Developing a generic model for a car component, which was able to provide the flexibility for design procedure. The model was able to shorten design and analysis time by 50%.Project Engineer 1/1988-10/1988- Setting up network for in-house workstations.- Developing an innovative PC base customized software, which was used for designing manual transmission shaft.

Business Analytics

Master Of Business Administration (Mba), Operations Management, Finance

Master Of Science (Ms), Mechanical Engineering