MATTHEW BARTLEY
Monroe,North Carolina
Summary
An experienced Data analytics Manager with an extensive background in electrical engineering, software engineering, and IT Vendor management at the enterprise level. Specializing in many diverse areas such as digital analytics, project coordination, manufacturing processes, Vendor management, continuous improvement and developing/ modifying databases to create insights. Analytical problem-solver with a detail-oriented and insight-driven methodical approach. Prepared to offer 8 years of related experience; including 5 years of management experience to a dynamic new position with room for advancement. Excellent communicator with proficient skills in a diverse range of development languages.
Overview
9
9
years of professional experience
Work History
Manufacturing/ Supply Chain - Data Analytics Lead
Albemarle
04.2024 - Current
- Enhanced data-driven decision making by implementing advanced analytics tools and techniques.
- Coordinated with supply chain management staff to validate materials availability based on projected demand levels.
- Collaborated in development of manufacturing budgets and provided regular updates on expenses compared to forecasted amounts.
- Recommended production scheduling enhancements to improve system and PM performance.
- Reduced inventory holding costs through effective demand planning and supplier management strategies.
- Analyzed transportation costs to identify opportunities for optimization through carrier consolidation or route adjustments.
- Led cross-functional teams to design, develop, and implement data analytics solutions.
- Reduced stock discrepancies with thorough investigation of variances and prompt resolution of issues.
- Enhanced forecasting accuracy, utilizing advanced analytical tools to monitor demand patterns and optimize stock levels.
- Conducted advanced analytics; finding root cause analysis on production issues. Driving corrective actions to prevent future occurrences.
- Reduced lead times for key products through strategic CSR Reporting.
- Enhanced supply chain visibility, utilizing advanced tracking tools and real-time monitoring solutions.
- Conducted data analysis to identify bottlenecks in supply chain and develop solutions to optimize operations.
- Minimized process discrepancies by creating Dashboards that spearheaded budget, staff accountability, controlling inventory and supply management.
Sr. Data Analytics Manager (Remote)
SnapOne
04.2021 - Current
- Played key role in driving a $1.5M project slated to improve product quality efficiency and reduce product returns, 10% reduction in returns on a 2% goal in 2021 and approximate $5M annual savings. 25% reduction on a 10% goal; adding an additional $17M in annual savings for 2022.
- Participates in Quality QBR's for business leadership and provided quality review of overall products and summary of associated cost, RMA's, Incoming/Outgoing Inspection, Supplier Functional testing etc.
- Developed improved financial data modeling (cross-functional) to streamline efficiency that contributed toward generating 15% improvement in allocated revenue and partner compliance.
- Worked in an agile-based scrum model, managed and coordinated within cross-functional teams and got the user stories delivered to the client on time within the sprints.
- Provide product analysis for customer complaints/return material authorization (RMA) process.
- Established new forecasting, tracking and management reporting system to improve availability and accuracy of financial data triggering a 12% increase in accuracy.
- Implementation of SDLC standards to develop ETL programs using Informatica to implement the business requirements. Utilizing the integration into reports across multiple departments for continuous improvement; highlighting active projects, targeted department initiatives, personnel training, utilized systems for projects, etc. Aimed to improve accountability on projects as well as improving key processes.
- Provided models to aid in decision-making for product R&D, monetization strategies, third-party contracts, and other ad hoc analyses.
- Led a workshop of 35+ employees on metric/ KPI improvement initiatives as well as data democratization initiatives within Power BI; which impacted considerable improvements across multiple departments. Notably, Increased sales productivity by 35% and quality control by 60%.
- Design and build ETL workflows using (T-SQL) MS Access/Oracle and (SQL) SSIS/SSMS for systems integrations and BI analytical software.
- Maintained contact with 30+ third-party vendors and partner companies to develop new and existing technology and statements of work to present to customers.
- Developed governance to structure and monitor supplier performance in alignment with contracted SLA conditions as well as engineering and product criteria to meet business requirements within SOX Compliance.
- Implemented vendor score cards, conducted vendor reviews, dispute/issue resolution and escalation, audit/compliance management process.
- Leverage unstructured/ structured data as well as legacy data from Azure BLOB Storage, SSIS, Databricks, Oracle and Snowflake Data Warehousing to enhance the implementation of key metrics as well as process metrics that help enable the use of performance analytics/ predictive analytics in QlikView, Power BI, and Tableau within Sox Compliance.
- Compile and liaison product information with international vendors on the functionality, implementation, as well as development of market analysis using Power BI tools to allow practitioners access to real-time operational data.
- Understand tech trends/ data and how they affect the roadmap. Subject matter expert on competitive analysis and technical challenges.
- Guided Vendor/Customers to technological advances and prioritization of data, resulting in merging data as well as creation of ETL pipelines using Airflow for successful project outcomes.
- Creating and overseeing various views (Scorecards, Dashboard, Embedded Analytics, and Discovery Boards) through Workday.
- Spearheading efforts into recent development of blockchain (enables devices across the Internet to send data to private blockchain network (IoT) and innovation in the way we process data-from registrations/ records of ownership) and AI (AI-powered customer support product feature working in conjunction to IoT; enabling the customer to develop deeper product insight and build a better user experience.).
IT Software Developer Lead
Bonitz Inc.
04.2020 - 12.2020
- Implemented vendor score cards, conducted vendor reviews, dispute/issue resolution and escalation, audit/compliance management process.
- Interpreted financial data/statements and analyzed sales revenues, costs, expenses, tax rates for business unit dashboards involving 7 client accounts. Provided recommendations on short and long-range ROI.
- Boosted efficiencies and accessibility to data by presenting drill down techniques in Power BI/ QlikView reports to deliver better overall user experience within Sox Compliance.
- Develop and establish strong business relationships with onshore and offshore Vendors, Suppliers, and partners to ensure overall growth, product performance, and stability of products longevity.
- Managed the vendor relationship, vendor consolidation and established the vendor KPI’s, process metrics and quality metrics.
- Developed quality return merchandise authorization compliance report; Reviewing targeted suppliers not currently adhering to product arrival policies within the agreed 90 day compliance; identifying supplier currently withholding product and contractors not staying up to date on certs.
- Established vendor performance monitoring & dashboards, reporting, vendor quality audits, process governance, control and risk management.
- Collaborated cross-functionally with Supply Chain, Quality, Product, Engineering, ML, and Legal. Spearheaded incorporation of operational Compliance metrics to review Supplier quality/ process metrics; ensuring dealers adhere to established protocols and product regulations.
- Contributed to an 15% year-over-year growth by developing strategic recommendations for leadership surrounding long-term goals.
- Gathered and defined Finance/ Operations/ and customer requirements to develop clear specifications for project plans.
- Prepare analysis and interpret results related to inventory costing Collaborated with colleagues on the creation of a new pricing strategy to increase profitability as much as possible – 15% increase within one year.
- Performed regular audits (Quarterly and Annually) on business metrics and processes across the organization. Generating a list of suggestions based on thorough research that improved efficiency by 85%.
- Understanding and knowledge of HR policies and procedures Development of metrics to better track and assist within HIPPA Standards.
- Participation in widespread User Acceptance Testing (UAT) for various data modeling/ data warehousing changes before rolling into production.
Data Process Engineer
Corning Incorporated
09.2018 - 04.2020
- Provide financial support to Business/ Functions, and assist in decision-making, contributing to a 13% growth trend by developing strategic long-range planning recommendations for executives.
- Developed operating productivity metrics; such as Equipment Utilization, Machine Downtime, Reels per Day etc. All derived from raw company data to track improvements in organizational efficiency (Power BI/ Qlikview).
- Implemented vendor score cards, conducted vendor reviews, dispute/issue resolution and escalation, audit/compliance management process.
- Report data and findings of ad hoc analyses to key stakeholders and leadership in meetings 2 times per month.
- Displayed a high level of critical thinking in bringing resolution to high impactful, complex and /or cross-functional problems.
- Provided operational test plans and test cases.
- Utilize quantitative methodologies to model business problems and develop recommendations for improvements.
- Provided decision making support with predictive modeling by utilizing analytical tools and techniques to model potential outcomes of alternatives and perform economic feasibility analysis for alternatives being considered.
- Volunteered as a mentor for Kaizen event leaders; Participated in holding Kaizen awareness meetings which helped improved team morale and focus on plant efficiency.
- Collaborated on various improvements via Continuous Improvement Methodologies and tools (Lean, Six Sigma, and Theory of Constraints (ToC).
- Spearheaded 15+ pilot machinery implementations for the roll-out of new plant adoption before expansion project.
- Completed detailed reports and informed managers and executives about the progress of the assigned projects, and maintained the plant operational/ process database.
- Led sitewide Continuous Improvement Initiative, including the development of balanced KPI and carrier scorecard, resulting in a gain share revenue boost of 8%.
- Created custom reports with Workday for business end users to access on homepage/ favorites as well as web services.
- Design and build ETL workflows using (T-SQL) MS Access/ Oracle for systems integrations and BI analytical software using SDLC Standards.
- Creating various dashboards for senior leadership within Business Operations and Finance to enable tracking and monitoring of KPI’s and metrics.
- Process improvements utilizing Lean Six Sigma Methodology
- Profound knowledge of Root Cause Analysis , Product life cycle, ITIL, Six Sigma, and CHAMP
- Contribute to improving efficiencies and performance as well as providing quality financial information (e.g. report dashboard and VC/BC productivity).
- Utilized six sigma methodology for process improvement (Kaizen’s) and operational excellence projects with a focus on cost savings as well as improving efficiencies.
- Carried out various projects implementing ETL for machine forecasting and establishing new plant KPI's within HIPPA Standards.
- Mentored junior engineers and new hires to better improve competency and efficiency of all staff.
- Developed database objects, including tables, views and materialized views using SQL.
Test Engineer/ Metrology Engineer/ Programmer
MGM Brakes
09.2016 - 09.2018
- Assisted with preparation of briefs, including Operational Test Readiness Reviews (OTRR) and other technical briefs.
- Collaborated with scientific, engineering, and technical personnel to resolve testing problems and system malfunctions.
- Provided operational test plans and test cases.
- Created test measures from requirements documents, best practices, and user interviews.
- Utilized electrical engineering experience to manage and broaden the scope of testing functionality to harsh real world challenges as well as constant changes in industry standards.
- Creating and overseeing various views (Scorecards, Dashboard, Embedded Analytics, and Discovery Boards) through Workday.
- Implemented vendor score cards, conducted vendor reviews, dispute/issue resolution and escalation, audit/compliance management process.
- Liaison between vendors, IT and Engineering regarding operational issues.
- Connected HR data with testing departmental data to increase project allocation and productivity. Created Advanced/ Matrix report types as well as Trending/ Composite reports in Workday.
- Created dashboards for automobile financials, product testing, and third-party market analysis data to improve product performance (Power BI).
- Wrote SQL code in addition to modified existing software to correct errors, adapt to new improved performance.
- Designed, developed, deployed, and maintained software tools to spring tensile strength, injection molds in engineering for supply chain.
- Perform operations for metal stamping as well as multiple die setups.
- 6 months of Hydraulic Press Operating Experience
- Developed data analytics dashboards for operating test equipment. Metrics derived from raw company data to track improvements in organizational efficiency.
- Collaborated on 25+ pilot product implementations for the roll-out of new consumer products.
- Continuous improvement on part implementation and product design
- In-depth knowledge of production assembly process.
- Investigated advanced metrology methods, including multi-sensor CMMs, non-contact inspection systems, and advanced sensors and gauging methods.
- Conducted metrology specifications on new and existing parts using calibration methodologies (technical and departmental SOP) for compliance with internal and external policies Project Planning including cost (time and material) and labor.
- Conducted various internal quality audits.
- Developed quality policies and procedures related to calibration.
- Tracked scrap and rejections for cost reduction purposes.
- Improved training methods to align with ISO 9000 Standards for quality and procedure.
- Created and managed comprehensive test plans, test reports, and use cases to support testing objectives.
- Wrote PLC logic and modified existing software to correct errors, adapt to new hardware and improve performance.
- Developed electrical schematics and wiring diagrams for automated corrosion test chamber.
Electrical Design Engineer
McVeigh & Mangum Engineering
10.2015 - 08.2016
- Interpreted schematic blueprints, wiring diagrams, performance specifications and service manuals.
- Design development and implementation of high/ low voltage systems, electrical and mechanical equipment in accordance with the National Electric Code.
- Maintained and stayed up to date on electrical code as well as sought out new technological advances within the electrical equipment industry.
- Created design layouts and part drawings using orthographic 3rd angle projection.
- Interpreted drawing markups and implemented drawing revisions provided by engineers.
- Developed CADD drawings for newly acquired facilities, updating, and maintaining existing facility documentation.
- Prepared specifications of electrical systems and topographical maps to ensure that installation and operations conformed to standards and customer requirements.
- Assisted in engineering projects for application and distribution lighting and power systems.
- Designed and approved power distribution requirements for the construction of multifamily, office enclosures, and manufacturing facilities.
Education
Bachelor of Science - Electrical Engineering
North Carolina Agricultural And Technical State University
Greensboro, NC06.2015
Skills
Knowledgeable in:
AWS/ Azure/ Databricks/ Snowflake
Change Management/ Leadership Assessments
Quality/ Sales QBR
User Acceptance Testing (UAT)/ Data Validation
Data Analysis/ Trend Data Analysis
Dashboarding/ Data Reports
Big Data analytics with Hadoop
Workday/ Workday Prism
Data Extraction/ Data Mapping/ Data Profiling
Business Acumen/SSMS
Product Knowledge/ Program Management
Star Schema/ Statistical methods
MS Office/ Excel / Pivot tables/ SharePoint
SQL Server Reporting Services/ PostgreSQL
Data Visualizations/ Compiling Data
Microsoft Access/ Apache Maven
MySQL/ MongoDB/ ETL
Cost Savings/ Creative Solutions
Sales and Quality Support
Executive-Level Presentations
Managing Multiple Projects
Assisted in Data Governance
Training Junior Team Members/ Team Meetings
Team Member Development
Technological Growth/ Business development
Google Analytics/ Adobe Analytics
Linux/ IBM Cognos BI/ QlikView
Power BI/ Tableau/ Informatica/ Epic
Continuous Improvement / Quality assurance
Machine learning/ Statistical techniques
HTML/CSS/Bootstrap
Java/ Python 3/ API Interactions
D3js/ Geomapping with Leafletjs
Apex/ Visualforce/ Lightning
Hadoop Ecosystem/ Splunk/ Airflow
Statistics Modeling/ forecasting
D365 ERP/ Salesforce/ Sage/ Jira/ Confluence
Database Management/ Data Warehousing/ Query tools/ Data and Analytics
Geographic Trend Tracking
Troubleshooting and debugging
Product Performance Goals
MATLAB/ Shell Scripting
Allen Bradley, Beckhoff
Wiring Schematics
Autodesk/ Revit
Product development/ Inventory Accuracy
Agile/ Scrum Framework
Project Management
SAGE/ SAP S/4 HANA/ Salesforce
Jira/ Confluence
Alteryx/ Apache Airflow
Relevant Experience
Data analytics Boot Camp
UNC Charlotte - June 2019 through November 2019
- A part-time 24 week program focused on acquiring practical technical skills needed to solve data problems
- Gaining proficiencies on a host of marketable technologies like Excel, Python, SQL Databases, Tableau, MongoDB, ETL, Hadoop and web visualizations
- Building and creating in depth real-world projects
- Certificate upon completion
Timeline
Manufacturing/ Supply Chain - Data Analytics Lead
Albemarle
04.2024 - Current
Sr. Data Analytics Manager (Remote)
SnapOne
04.2021 - Current
IT Software Developer Lead
Bonitz Inc.
04.2020 - 12.2020
Data Process Engineer
Corning Incorporated
09.2018 - 04.2020
Test Engineer/ Metrology Engineer/ Programmer
MGM Brakes
09.2016 - 09.2018
Electrical Design Engineer
McVeigh & Mangum Engineering
10.2015 - 08.2016
Bachelor of Science - Electrical Engineering
North Carolina Agricultural And Technical State University
Similar Profiles
Andrew DrozdAndrew Drozd
Capital Projects Quality Assurance Representative at AlbemarleCapital Projects Quality Assurance Representative at Albemarle
John Patrick SandersJohn Patrick Sanders
Chemical Plant Operator at AlbemarleChemical Plant Operator at Albemarle
John ProulxJohn Proulx
R & T Technician at AlbemarleR & T Technician at Albemarle