SCOTT MUNROE

*** ********* **** ********, ** ****7 · 516-***-****

adzgh9@r.postjobfree.com

EXPERIENCE

NOV 2022 – AUG 2023

SR FINANCIAL ANALYST, RESIDEO

Managed cross-collaboration projects between Finance, QA/QC, ISC, PMO and other support groups to ensure required data was collected for generating visual reports required by senior management.

Utilized the following skills and tools for data transformation and consolidation from multiple sources including legacy tools:

oAdvanced programming in Microsoft Visual Basic for Applications (Office Automation) with Excel and Power Point

oTableau Server and Desktop tools

Advanced tooltips with simplified explanation of complex calculations along with highlighting so executives and non-technical persons could easily understand (eg: Gross Margin YoY variance due to mix % change)

oAlteryx Workflow for integrating data (ETL) from several systems, including SQL SQL databases, SAP HANA and Excel files.

oDesign and maintenance of SQL Server Stored Procedures, Functions and Database Views

Database Management responsibilities included creating and optimizing SQL Server database views to be used for reports and visualization and Stored Procedures used for advanced calculations and processes not natively supported in tools.

Responsible for data mining sales and inventory data used for vendor compliance audits and litigation.

FEB 2019 – OCT 2022

PROCESS ENGINEER, RESIDEO

Software Architect for team which maintained the Sopheon Accolade PPMS tool, used for gathering and presenting data used by senior management for making business decisions regarding projects to invest in, including time tracking and expense collection.

oCreated documentation and provided training on-site and remotely.

Managed cross-collaboration projects between Finance, QA/QC, ISC, PMO and other support groups to ensure required data was collected for generating visual reports required by senior management, including Say-Do, KPI Dashboards and 3-On reports (On Time, On Schedule, On Spec).

Team leader for data visualization and reports, utilizing the following skills:

oMicrosoft Office Automation for Excel and Power Point using Visual Basic

oTableau Server and Desktop tools

oJavaScript programming for updating pages in web based PPMS tool

oDesign and maintenance of SQL Server Stored Procedures, Functions and Views

oCross-Functional and multi-cultural team leadership.

Responsible for data migration between various instances/versions of PPMS tool in addition to developing, or coordinating the implementation of, interfaces between various tools and databases used across the business.

Developed and maintained an Excel Smart Template using Visual Basic to interface with a web-based tool, providing a simplified user interface for multiple functions to maintain data, while also including complex calculations for financial KPIs used for P&L analysis, including working capital changes for A/P and A/R.

oCreated documentation with simplified explanation of complex calculations and processes for non-technical and non-financial users. Also provided training on-site and remotely.

FEB 2000 – JAN 2019

SOFTWARE ENGINEER, Honeywell international

Cross-Functional Collaboration with various functions including R&D Engineering, Sourcing, Project Management, Manufacturing, Finance, Product Cyber Security, and senior management to determine business needs and develop technical requirement documents.

Designed, developed and implemented automated solutions and tools for engineering using C#, Visual Basic and legacy tools, either independently or as part of a team. Coordinated with IT to manage large projects where needed.

oDigital PAC Tool for managing R&D engineering projects and expenses

Designed and coordinated with IT team for larger development. Programmed using C# and SQL Server stored procedures

Required Cross-Functional Collaboration to determine customer needs

oAccolade PPMS configuration and customization (COTS replacement for Digital PAC Tool)

Created new, and customized existing, web pages using JavaScript and SQL

Created SQL queries, stored procedures and functions to meet the reporting needs of multiple functions and senior management

oBOM Cost Analysis Tool

Using Visual Basic, developed and implemented an Excel based tool used across multiple sites globally for determining manufacturing costs based on a Bill of Material.

oMechanical Tool Capacity Planning System

Using Visual Basic and SQL, developed an Excel based tool for monitoring the inventory, capacity planning and cycle count of company owned tools which were maintained at vendors. Required collecting forecast and production data from ERP system using SQL queries

oMulti-Site Data Visualization System

Using C#, Visual Basic and SQL, designed, developed and implemented a data visual management system for displaying various reports and live files (Excel, Power Point, MS Word and HTML pages) on large monitors installed in key locations across multiple sites.

Certified as a Six Sigma Green Belt (DMAIC & DFSS)

Trained as a Six Sigma Black Belt (not certified)

JUL 1995 – FEB 2000

SOFTWARE ENGINEER, ADEMCO

Designed, developed and implemented automated solutions and tools for engineering using C#, Visual Basic and legacy tools, either independently or as part of a team. Coordinated with IT to manage large projects where needed.

oeMatrix/Enovia PDM System

Configuration and customization requiring programming in Perl, C, Java and MQL.

oOracle Agile PLM System

Using Visual Basic and SQL, migrated data for eMatrix PDM system

Developed data management plans to collect, manage, and analyze data from various tools and systems

JAN 1992 – JUN 1995

TEST ENGINEER, ADEMCO

Collaborated with stakeholders to address technical issues and develop effective resolutions for automated testing of security and fire systems in a mass production environment.

Involved with business acquisitions to determine Test requirements and coordinate with Test Engineering, Production Planning, Sourcing, Manufacturing and Quality Assurance both during transition and ongoing support, including process improvements and material changes to reduce costs and improve product quality.

Provided field support of commercial video products, including matrixed analog systems and networked IP solutions for schools, DOTs (highways) and airports in addition to setup and participation in trade shows. Liaison with Design Engineering, Quality Assurance, and Manufacturing to investigate and resolve customer and production issues

Implemented and administrated the Derby Statistical Quality Control (SQC) system running on the UNIX platform with an Oracle database and operating across multiple countries.

oUsing C,, developed custom data interfaces for various test equipment used in manufacturing.

oImplemented visual system for collecting repair data on production and customer failures.

oUsing Visual Basic and SQL, created reports based on data collected for trend analysis and manufacturing dashboards showing work orders in process, First Pass Yield and Throughput Yield along with percentage completed.

AUG 1989 – JAN 1992

REPAIR TECHNICIAN, ADEMCO

Tested and repaired diverse consumer electronic devices, developing knowledge of products.

Implemented a database tool for collecting data on customer returns. Interfaced with Quality Assurance and Design Engineering departments to improve new product development using knowledge gained.

Troubleshot and repaired test equipment used for validation of customer returns, including automated test equipment. Coordinated with Test Engineering as needed.

EDUCATION

1988

oHICKSVILLE HIGH SCHOOL

EXCELLENCE IN COMPUTER PROGRAMMING

oLEVITTOWN MEMORIAL EDUCATION CENTER, VOCATIONAL PROGRAM

EXCELLENCE IN MICROPROCESSOR/COMPUTER REPAIR

1989

Grumman Data System Institute

oELECTRONIC TECHNOLOGY

oCOMPUTER SERVICE TECHNOLOGY

SKILLS

Team Leadership

Configuration Management

Technical Requirement Documentation

Training

Teamwork, Empath, Adaptability, Work Ethic

Problem-Solving with Collaboration

Data Extraction and Migration [ETL] (MS SSIS, Alteryx, SQL)

Data Visualization (Tableau, Excel, SQL)

Programming (C#, Visual Basic for Applications, Java, JavaScript, SQL)

Advanced Excel skillset including VBA

Contact this candidate