Mike Collins

• Managed AI and BI team of nine employees.
• Computer vision solutions
• Product/SLA reporting
• TBD
• TBD

• Developed strategic initiatives to enhance operational efficiency and reduce costs.
• Led cross-functional teams to implement process improvements across departments.
• Streamlined project management workflows using advanced collaboration tools and methodologies.
• Mentored and coached junior staff, fostering professional development and enhancing team performance.

• Managed IT infrastructure and application team of eight.

• IT architect for Tavant warranty implementation on Salesforce platform.

o Designed ERP interfaces for claims processing, install base, and product information

with 2-way communication

o Configured Salesforce partner community logins based on dealer hierarchy

• IT architect for Ecommerce application consolidating multiple brands under one site

o Documented and cleansed master data related to parts sales (customers, items, pricing, etc.)

o Created data mappings between ERP source and Ecommerce data structures

o Setup customer creation API via ERP web services

• Designed and implemented sales funnel process within Salesforce to capture potential Salesforce opportunities from external dealers, tracking multiple brands and targeting potential growth orders.

• Project lead for ERP implementation for internal company transferring from NetSuite to JDE.

• Piloted Power BI reporting for ESG data lake utilizing Snowflake cloud data warehouse and a focus on vehicle analytics.

• Served as IT lead between ESG and parent company with regard to managed services and common areas of consolidation.

• Led a team of five ERP analysts, report developers, and data integration specialists. Responsible for application support, maintenance, budgeting, consulting, and configuration for six companies.
• ERP system modules included AR, AP, GL, Sales, Purchasing, Inventory, Warranty, Engineering, and Manufacturing. Managed enterprise level applications including JDEwards EnterpriseOne, Salesforce, SAP Business Objects, Configurator, SharePoint, NetSuite, Vertex, and Automated Data Collection.
• Managed adherence to Sarbanes-Oxley audit controls related to financial applications, access control, and segregation of duties.
• Participated in formation of a monthly IT Process and Governance Council to review business needs and project requests across the enterprise.
• Architected the technical build of new configurator solution spanning PLM, CPQ, and ERP. Defined future state for AWS cloud data lake to merge telemetry data with vehicle information. Sr. Data & Solutions Analyst, 2015 – 2017
• Integrated multiple systems (JDEwards, Windchill, Salesforce CRM, ConfigureOne CPQ, and Ecommerce) to transmit master data and transactions through SQL, web services, and standard EDI processes.
• Maintained data integrity throughout systems with a combination of alerts, integrity reports, and automation.
• Automated sales forecasting process within Salesforce to compare against actual sales in ERP and generate projected shipment dates based on book date, which was then used to schedule against plant capacity.
• Supported legacy web applications (warranty, scheduling, inventory, and quality) through maintenance and understanding of SQL Server back end logic.

• Responsible for 8+ SQL database servers and 50 databases, performing backups, restores, logging, index rebuilds, and query optimization for reporting and data warehousing scripts.
• Setup Change Data Capture and replication for advanced dashboards and automated jobs.
• Developed visual signage for display throughout manufacturing facilities showing real-time status of production units across product lines, leveraging data from automated data collection system.
• Integrated off-site inventory with standard ERP inventory management and synched nightly update of inventory counts.

• Implemented and upgraded SAP Business Objects XI with Crystal Reports and Web Intelligence ad hoc reporting capabilities using SAP Universes to combine data sources across ERP, CRM, and external data.
• Created “Vapor to Ice” forecast tracking to provide visibility of orders from opportunity through shipment to customer.
• Designed and developed Sales and Manufacturing data warehouses for aggregated reporting, translating ERP naming conventions into business nomenclature.
• Developed Warranty module of ERP using business specific product structure to track Install Base, Contracts, Registration, and Warranty Claims.

• Successfully migrated legacy ERP data from acquired companies, mapping common data and business processes between multiple companies.