PROFESSIONAL SUMMARY:

• Goal oriented project manager with a diverse background leading information technology (IT) and production teams in fast paced startup environments. Proven lean operations manager in supervisor roles for large and small organizations. Experienced data driven business intelligence analyst providing real - time situation analysis.
• Exceptional at clearly communicating evolving operations requirements to management teams. Excellent in both team and independent work settings for optimal efficiency. Highly skilled in translating abstract technical information into concise business insight.

TECHNICAL SKILLS:

• Jira Query Language (JQL)
• Jira Software Developer
• Tableau Data Visualization
• Microsoft Power Automate
• Lean Operations Management
• Agile Project Management Leader
• Microsoft SQL Server Analysis Services (SSAS)
• Active Directory Administration
• ActiveBatch Workflow
• Looker LookML (YAML) Scripting
• Looker Software Developer
• Atlassian Confluence Developer
• SAP BusinessObjects Business Intelligence Suite
• TIBCO Jaspersoft Studio
• IBM Cloud Foundry
• Statistical Analysis and Forecasting
• Strong Problem-Solving Ability
• Business Intelligence Analytics
• IBM Cognos Business Intelligence Suite
• Microsoft Power Business Intelligence (Power BI)
• Change Management and Process Improvement
• Kanban Service Delivery Manager
• Okta Administration
• Kaizen Continuous Improvement
• PDCA Team Management
• Microsoft SQL Server Management Studio
• Transact-SQL (T-SQL)
• GitLab Knowledgebase
• TIBCO Jaspersoft Reports Server
• IBM Watson Assistant

PROFESSIONAL EXPERIENCE:

QA PROJECT MANAGER

Confidential - Dublin, OH

Responsibilities:

• Supervising 50+ person operations team in addition to managing project quality assurance activity.
• Error checking 300+ performance reviews each week for reporting deliverables.
• Data cleansing all raw data generated by project operations teams.
• Creating data visualizations for project stakeholders displaying individual and team critical performance metrics using Microsoft Excel pivot charts.
• Process owner for QA program management of all project operations teams.
• Coaching team leaders on critical project KPI data reporting.
• Leading QA process improvement to meet evolving aggressive project schedule using Microsoft Project.
• Developing QA program curriculum for project operations team.
• Designing corrective action plan and documentation using PDCA lean operations method.

DATA ANALYST

Confidential, New Albany, OH

Responsibilities:

• Created client specific schemas in Microsoft SQL Server Management Studio.
• Internal auditor for ISO re- documentation.
• Led quality management documentation project for ISO re-.
• Created T-SQL queries for client employees who were not SQL literate, and trained them to use them.
• Programmed an automated “smart script” in python to map, filter, and reduce raw data files into a compatible format for uploading to the SQL database.
• Created Microsoft Excel macros to automate CSV file reformatting for customer service team.
• Coded data models, views, and explores using LookML for client data reporting dynamic dashboards.
• Produced client operations reports using Microsoft SQL Server Reporting Services. (SSRS)
• Created client financial trend forecasts using Tableau, and Microsoft Power BI software.
• Mentored new team members on Looker software, data visualization methods, and best practices.
• Amazon Web Services (AWS) cloud practitioner .
• Completed Tibco product for advanced users provided by Tibco support team.
• Created Jaspersoft data visualizations for clients using Tibco business intelligence suite.
• Produced ad hoc operations reports for clients using SAP Concur software as a service (SaaS) platform.
• Created financial forecast models using SAP BusinessObject business intelligence suite.
• Produced client travel spending analysis reports using SAS Visual Analytics and SAS Visual Data Mining & Machine Learning software.
• Created internal logic chains for customer service AI chatbot self-service app using IBM Cloud Foundry.
• Led development team meetings presenting project milestones to client leadership.

INVENTORY DATA ANALYST

Confidential, Dublin, OH

Responsibilities:

• Change request backlog grooming for MRP system and SAP data reporting.
• Drove revitalized vendor relationship management process to build rapid supplier engagement.
• Created strategic procurement plan for production critical components and raw material purchasing.
• Supported the project engineer for all active limited production run projects of 1-3 months and $500K-$2M budget using Microsoft Project.
• Recognized by upper management for exceptional work ethic and performance.
• Reduced total raw material costs 15% through predictive analytics during fiscal years using Microsoft Excel pivot charts.
• Increased on-time delivery performance from 62% to 91% fiscal year using agile program management Kanban workflow.
• Project lead developing a custom machine learning high fidelity image and text capture software.
• Built raw material cost forecasting for Honda NSX project using Excel pivot tables and VBA scripting.
• ISO documentation process co-owner for supplier corrective action and vendor relationship management.
• Kanban EDI customer demand data administrator.
• Project owner for facility Microsoft Windows Server network hardware and data backup.
• Led vendor management for all limited production Honda prototype project critical supply chain procurement.

TEAM LEAD

Confidential, Lockbourne, OH

Responsibilities:

• Developed Jira based self-service tools for vendor fulfillment, and product services team members.
• Created and presented weekly S&OP metrics to management team using Tableau data visualization.
• Built dynamic dashboards displaying peak demand operation metrics and cost forecasting using Power BI.
• Ohio facility data team for internal business intelligence workgroup.
• Created process control documents for Atlassian Jira workflow management system and Jira query language (JQL) using confluence software.
• Jira workflow management system subject matter expert (SME) for the Vendor Operations group.
• Technical advisor to the Product Managers and the Technical Change Manager for continuous improvement.
• Developed first-generation product services division curriculum for change management process using Microsoft Visio and Microsoft PowerPoint.
• Created product services division sales and operations metrics using Tableau data visualization software.
• SAP BusinessObject Business Intelligence suite administrator for Ohio operations team under the Vendor Operations Manager.
• Active Directory user authentication administrator for Ohio operations teams.
• Okta cloud platform module administrator for problem solving team.
• Jira administrator for the first-generation product services division operations team workflow.
• ActiveBatch advanced user for Confidential “Kaizen” (continuous improvement) project Ohio team.

INVENTORY CONTROL II

Confidential, Lockbourne, OH

Responsibilities:

• Reduced inventory loss / theft 17% during fiscal year by designing internal security procedures.
• Identified high value inventory loss through new use case of existing hardware sensor dataset.
• Subject matter expert to division security director for security plan redesign.
• System migration team from Kayako and deployment of Jira as primary workflow platform.