Pulling data from client data sources, reorganizing, and migrating into Hubspot CRM.

- Create ETL and database oriented business processes using mySQL, ETLworks, PowerBi, APIs, and warranty industry specific tools- Onboard and build client ETL and data management needs. Re-engineered several to create conformity.- Support Visualization team with database / schema development and ETL service

Using mySQL, Php, HTML, Python, Linux, and other tools - Design database oriented business processes, scripts, stored procedures - Resolve process and data issues - Create internal business user forms to interact with data- Improve and manage web scraping processes- Create ETL processes for 3rd party and internal data sources, resolve issues and maintain systems and associated coding- Daily use of SQL for analysis, problem solving, and building and maintaining tables

- Financial reporting and design with Power BI and other tools for strategic planning department.- Built hierarchal forecasting and budget system covering 125 world wide business locations. - Built dynamic P&L Statement for all business locations and regional aggregations using Power BI, Excel, and PowerShell- Built a myriad of reports using Excel & Power Query pulling from a several source typesCovid Layoff

- Queried and reorganized data for migration to new accounting / CRM platform- Interviewed stakeholders then pulled, cleaned, and organized data sets from 3 databases to complete templates for migration- Adhoc Access and Excel reports

- Develop adhoc reports using Power BI / Query, Excel, and Jira for Oracle installation team- Used Power BI and Excel to automate previously manual reports and model data for new report set

Recovered from sports injury where I broke cartlidge in my hip and couldn't sit and other things for over 6 months.

- Manage Packaging and Shipping departments to include schedules, personnel, inventory mgt. and supporting processes- Work with railroad, trucking, chemical suppliers, and transloader companies to ensure raw material and finished goods flow- Plan and purchase production materials, evaluate suppliers, and utilize supplier strengths to manage issues- Automated some of my reporting processes with Power Query / BI

Business Information Analyst• Developed reporting and basic ETL solutions for corporate finance: Access, SQL Server, Visual Studio/SSDS, and Excel Power BI• Initiated use of SQL Server Data Tools (SSDT) package of Visual Studio to design / deploy ETL solutions• Studied and documented department data flows and processing. Used MS Access and Power Query to eliminate numerous hours of manual processing / transformations and human error +Contract position

- Returned 5 electronic repair production lines to run at capacity using Lean methodologies, coaching, data analysis, and Kaizen events- Redesigned production cells removing non-value-add actions, reducing kickbacks (90% reduction), and upping operator engagement- Developed KPI metrics dashboard with Power BI and an reporting system using Access ODBC to the MRP system- Installed Kanban system, parts harvesting organizers, poke-yokes, and revised work instructions +Contract position

8th Grade Science Teacher

Built and Managed Kitting Department to include:• Designing and quoting production per product, staffing, maintenance, inventory management, developed production support processes, production scheduling• My actions directly grew the business from 2 shifts on 1 production line to 3 shifts of 3-4 lines+ Left to get Masters in Teaching

• Design high speed production lines including process docs, layout, training, costing and quoting, and troubleshooting• Reengineering of business, production, and production related processes. • Leader of Production Re-Org Project. Personally designed floor layout. Trained Production leads in Lean Mfg.• Last 10 months: 2nd Shift Superintendent: Responsible for all activities of production, quality, and materials groups on my shift +/- 100 employees+ Loss of major customer resulted in layoff of my whole shift

• Changed assembly operation from job-shop to one piece flow Lean Line: Worked heavily with floor assemblers, engineers, and supervisors to build, refine, and operate the lean line to include requirement planning, training, time studies, station design-build, Kanban mapping, and culture change• Development and oversight of plant-wide 5S program+ MBA Internship

- Directed facility EH&S and 5S program. Kaizen events- Management and Reporting of Title V, SWPPS, SARA, TSCA, - 25% reduction of wastes and disposal costs per year. Reduction of Title V air status / requirements.- Supervision of waste water treatment facility and assisted supervision of plating department- Enforced contractor EH&S compliance for $4 million in construction projects and asbestos removal - Incipient Fire, Hazmat, Safety Committee, and Medical Response champion; EH&S trainer