Data Analyst Manager
Resume:
Lew Mills, MBA
Peoria, AZ *****
*************@*****.***
Experienced Data Analyst/Project Manager working for a Fortune 100 company in an Agile work group with a track record for managing, creating and delivering value added data analysis and reporting with Tableau visualizations dashboards that exceed customer expectations.
Professional Skills
Proficient as Tableau artisan and administrator
Experienced using MS SQL Studio in creating, modifying and automating tables, queries and views
Proficient with Excel, Access and visual basic scripting
Knowledgeable with Python, RDBMS and Big Data
Proven track record for working independently and communicates effectively with customers at all levels and functions
Professional Experience
Manager Sr. Project ISC/Data Analyst Honeywell 09/2018 - 06/2020
Delivered software solutions quickly and iteratively to stakeholders.
Created data sources using SQL tables, queries and views that fed customized front end applications.
Developed Tableau visualizations that segmented data into actionable information for consumption at all levels of the organization.
Expertise in working with product owners to translate their vision into a minimum viable product quickly, then building and publishing dashboards and stories from Tableau Desktop and Tableau Server.
Created and updated SQL tables, queries and views to support the builds and testing phases.
Knowledgeable with Alteryx, SSIS packages, stored procedures, Visual Studio, and SQL Management Studio.
Developed and published COVID-19 Tableau Dashboard for affected suppliers and impacts to the supply chain with summary and detailed analytics.
Collaborated on a web based input tool, SQL table back-end and a front-end Tableau dashboard for tracking $50M+ of supplier claims and contributions.
Teamed to develop an SQL based back-end paired with multiple Tableau dashboards for segmenting and prioritizing $4B in contract expirations with drilldown capabilities.
Designed and produced Tableau dashboards used in tracking and managing Temporary Engineering Change Orders by owners, managers, directors and vice presidents and segmented by buckets of time until expiration.
Analyst Lead Operational Excel ISC Strat Solutions Honeywell 01/2017 - 09/2018
Worked with the Aero-Analytics team to develop, maintain and distribute standard reporting across sites.
Developed standardized reports using SAP, Excel, Access, and VBA scripting.
Scheduled automated daily and weekly reports to be delivered to multiple sites.
Worked with site experts through entire process from concept to production to ensure reports were actionable, accurate and delivered at the appropriate times.
Developed reporting solutions using Tableau software for Aerospace past due by key process indicators.
Co-developed and project managed an Aerospace wide project that included 40+ global sites for factory utilization data collection from start to finish including interface design, management of change, training videos and Tableau dashboards. The minimum viable product was completed in a little over a month and rolled out to both OEM and R&O sites.
Analyst Lead Operational Excellence Honeywell 01/2006 - 01/2017
Collaborated with Finance, Value Stream Managers, Cell Leads, Procurement Manager, Materials Manager and Site Leader to provide metrics and analysis.
Facilitated data collection for Aerospace leadership reviews.
Created and modified mechanisms for sharing, storing and retrieving information which was timely, relevant, accurate, reliable and useful.
Contributed to the success of the Integrated Supply Chain strategies and business decisions.
Served as administrator for Rapid Response (aka webPLAN Advanced Planning and Scheduling software) training, macro upkeep, automated alerts and help desk.
Assimilated and maintained monthly metrics packages for the Materials group.
Used Excel macros to convert manual reporting processes into automated processes, which contributed to savings of 2,000 yearly hours of manual intervention.
Quality Engineer Corrective Action Honeywell 01/2004 - 01/2006
Responsible for the overall site corrective action system including chairing the corrective action board.
Served as a process leader and administrator for the Electronic Corrective Action Tracking System.
Facilitated root cause determination and effectiveness reviews.
Provided training on root cause and corrective action.
Used the Honeywell Cause Analysis Mistake Proofing, and Apollo Root Cause Analysis method to resolve quality issues.
Completed special project to develop and organize structure for in-house processing in compliance with NUCAP standards.
Certified as an in-house process auditor for brazing, welding, coating and chemical processing to ensure NUCAP compliance.
Integrated Supply Chain Business Analyst Honeywell 01/1997 - 12/2003
Managed overall implementation of an advanced planning and scheduling software package (webPLAN), including hardware and software procurement, PC upgrades, data validation, initial training and user group development.
Accountable for gathering data and reporting site metrics on a monthly basis.
Special projects have included working with cross functional groups to create Access databases for our Import/Export process, manpower and equipment capacity, R&D inventory tracking, government property stores, transition of Eatontown tooling, and supply chain education and training.
Education
Master of Business Administration
University of Phoenix
Bachelor of Science
Northern Arizona University
Contact this candidate