Chad Layman Email & Phone Number

Fishers, IN, US

Indianapolis, Indiana, US

Atlanta, Georgia, US

• In Dec 2018, Genuine Parts Company (GPC) announced the merger of four subsidiaries—Balkamp, Rayloc, Heavy Vehicle, & Altrom—into the Automotive Supply Group (ASG). ERP consolidation projects followed.
• Promoted to oversee the migration of data from Rayloc’s legacy ERP, Dynamics AX 2012 (AX2012), to the ASG’s new ERP, Dynamics 365 for Finance and Operations (D365FO).
• Worked with Rayloc and Microsoft to identify all data tables and entities required for migration to D365FO.
• Created a repeatable workflow to 1.) migrate data from the legacy ERP to D365FO, 2.) identify data migration issues, and 3.) provide data load time estimates.
• Performed all data migration tasks during Rayloc’s go-live in Nov 2019.
• Collaborated with GPC and Microsoft Solution Architects to transition from Rayloc’s legacy reporting platform, TARGIT, to the ASG’s new reporting platform, Power BI.

• Worked with the EDI Vendor Compliance Team to create ad hoc reporting using Power BI Desktop to analyze errors generated by various EDI documents received from Balkamp’s vendors. Designed and constructed a prototype of.
• Optimized the base Qlik Sense extract process used to query data from Balkamp’s AS/400 by devising a way to perform incremental extracts against tables containing no fields commonly used for differential load operations.
• Refactored Balkamp’s 3 original Qlik Sense apps to conform to GPC Qlik Sense Enterprise development standards. Split QVF files that contained extract, transformation, and user interface objects into multiple files to.
• Materially optimized Balkamp’s largest Qlik Sense app in Feb 2018. Decreased the app’s memory usage by 50%. Decreased the app’s load time by 88%. Received acclaim from GPC’s Senior Architect of Business Intelligence.
• At the request of Balkamp’s President, created a Qlik Sense app to report Balkamp’s Lost Sales. Built a working prototype, demoed the prototype, collected feedback, and developed a production-grade app. Took the app.
• The VP of Supplier Business IT and Enterprise Infrastructure requested a Qlik Sense app to measure Balkamp’s EDI customer compliance. Built a working prototype, demoed the prototype, collected feedback, and developed a.

Carmel, Indiana, US

• Maintained key client relationships by providing strategic technology insights surrounding new and innovative product and service offerings within, but not limited to, the Microsoft technology stack.
• Presented an introduction and overview of Microsoft’s Power BI to local IT Directors through a series of company-sponsored Lunch and Learn training sessions.
• Implemented a Microsoft Power BI solution to provide insight into a healthcare client’s Software-as-a-Service help desk ticketing system. Assisted from conception to inception: connected to the cloud source data.
• Designed and deployed a banking services client’s implementation of Microsoft Power BI (PBI) for help desk ticketing insights. Automated a second PBI solution to report against data contained within files stored within.
• Served as both project manager and business analyst for a pharmaceutical company’s global deployment of its SharePoint 2010 cross-functional team product launch site. Collaborated with the end customer, a healthcare.
• Assisted with an assessment of a banking services client’s current state of technology—which included a review of both infrastructure and applications—and created a roadmap of proposed strategic initiatives for.

Carmel, Indiana, US

• Oversaw client deliverables by ensuring that quality, schedule, and budget were in alignment with customer objectives.
• Served as a client point-of-contact; interfaced directly with key customers to ensure that deliverables were meeting expectations. Communicated issues and risks that surfaced to both internal and client teams.
• Engaged in project management activities—including the creation of project plans and status reports, the allocation of project resources, and the general oversight of work performed—for infrastructure, SharePoint, and.
• Served as a business analyst by collecting and documenting requirements, communicating work to be performed, answering task-related questions, and addressing issues encountered.
• Reviewed deliverables produced for quality control purposes.
• Served clients in the following industries: banking, healthcare, automotive, pharmaceutical, regulated waste disposal and managed IT services industries.

Indianapolis, IN, US

• Provide oversight, direction and updates regarding multiple internal and customer-facing projects.
• Responsible for the effective oversight of all duties assigned under the title of Systems Manager.
• Supervised the company’s two IS Business Analysts.
• Worked with Senior Leadership during the planning and pilot stages of USIC’s QlikView Business Intelligence (BI) platform rollout. Collaborated with the BI implementation vendor and worked with the internal development.
• Analyzed and redesigned the interface process between USIC and a key customer’s reporting process in the Colorado market. The success of this initiative improved the goodwill between USIC and its customer.
• Played a key role in the new “Ticket Risk Assessment” business initiative in Indiana. Responsible for the system’s process flow. Worked with USIC operations management to define, test and implement the new process.

Indianapolis, IN, US

• Responsible for configuration of the mission-critical process of receiving work orders—referred to as “locate requests” or “tickets”—across 150+ email-based delivery feeds originating from 32 states and 1 Federal.
• Work with the Business Development and Billing Departments when a customer account is established or terminated. Also work with the one call centers used by the customer for proper email ticket delivery. In cases where.
• Manage all processes used to electronically transmit field work performed—known as “positive response”—to both one call centers and USIC’s customers, when required.
• Responsible for overseeing the continuity of both aforementioned processes when system changes are planned by external entities that affect any part of either process.
• Supervise the company’s IS Business Analyst.
• Worked on a team tasked to transition 22 states from USIC’s legacy ticket management system to the newly acquired system used by Consolidated Utility Services in 3.5 months to reduce the overhead costs and.

Indianapolis, IN, US

• Supervised and assisted both SQL Server database and C#.NET application developers working on new and existing process modification requests.
• Maintained the mission-critical process of receiving email locate requests using 100+ feeds originating across 25 states stored to 21 SQL Server 2005 databases.
• Worked with the Business Development and Billing Departments when a customer account was established or terminated. Also worked with the one call center used by the customer for proper email ticket delivery. In cases.
• Developed new and maintained existing T-SQL positive response processes required by 9 states and 22+ customers to generate detail of field work performed. Also maintained VB.NET applications used to transmit the.
• Played a key role in designing USIC’s next generation billing system. Responsible for managing the 1.5 year project, which consisted of design, development and company-wide implementation using SQL Server 2005 and.
• Solely responsible for up-scaling and integrating email locate requests from 16 states served by Central Locating Service into the ticket management system utilized by SM&P Utility Resources when the two companies were.

• Managed a contract software developer who created a custom C#.NET Windows service for the Payroll Department that generated output used to suppress insurance deductions for employees on RIF (Reduction in Force) when.
• Supervised and assisted with a SQL Server 2000 database integration project, where one district database was rolled into another.
• Managed a contract software developer who created a collection of reports using SSIS to be used in conjunction with the data collected by the Computer-Based Training system, which allowed the Director of Training.
• Designed and developed a VFP user-interface class library that was integrated into the centralized dispatch application, which was utilized to notify its users of dispatch, system and ticket reception issues.
• Assisted in amassing member codes for all customers in 12 states and engineered components of the ticket management system in SQL Server 2000 and VFP to store and track these codes on incoming locate requests. Worked.
• Provided 3rd tier software and systems support for T-SQL and VFP-based ticket management applications.

• Engineered, developed and integrated the footage process into the company’s VFP-based billing system.
• Architected and developed the Computer-Based Training web site using SQL Server 2000 and ASP.NET for administering tests and quizzes to approximately 1,500 field personnel.
• Designed and managed development of a new T-SQL and VFP process to automate the manual corrections of system-generated billing errors, which created efficiencies and cut the Billing Department’s labor costs.
• Supervised the company’s Helpdesk Technician.
• Provided 2nd tier software and systems support for T-SQL and VFP-based ticket management applications.

• Maintained, enhanced and scaled both the C4 ticket management system used by the corporate and district offices and the Mobile Dispatch client software—both written in VFP with a SQL Server 2000 backend—and used by.
• Designed, developed and integrated “per ticket” customer module into the company’s VFP-based billing system.
• Assisted in transitioning the 11 Underground Technology Incorporated (UTI) offices to the C4 and Mobile Dispatch software platforms after being acquired by SM&P. Also served as a liaison to UTI’s utility customers and.
• Developed and implemented processes and software to receive locate requests via FTP and email using VFP. At the end of the project, 17 modem-based ticket receiving applications transitioned to FTP using FileZilla.
• Provided 1st tier software and systems support for T-SQL and VFP-based ticket management applications.

• Designed and developed a stopgap server database and client application using Access 97 for RR Donnelley Seymour, Inc.—a printer of retail advertisements used in newspapers and “blow-outs” used in magazines—to track.
• Designed and developed an order reporting system using VFP that was used by the clients of Bindley Western Drug Company, a former wholesale distributor of pharmaceuticals based in Indianapolis, IN.
• Designed and developed a customer relationship management system for Huse Food Group, Inc., owner of the St. Elmo’s Steakhouse restaurant in downtown Indianapolis, using Access 97.
• Developed and maintained AMT’s first company web site.

Kokomo, IN, US

Bs, Information Systems

As, Computer Technology (Cpt)