• 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.• Partnered with the GPC Cloud Team to devise a method for moving historical reporting data from SQL Server to Azure SQL using Azure Data Factory.• Built a reporting POC in Power BI and Azure SQL using sample reports. Refactored the POC into a prototype, then hardened the prototype into a production environment.• Migrated the reporting platform from TARGIT to Power BI during Rayloc’s go-live in Nov 2019.• Configured an Azure SQL database as part of a larger initiative to replace a custom VB.NET app used to make border crossing documents with a PowerApp as part of Rayloc’s go-live.• Oversaw the data migration of Heavy Vehicle's transition from AX2012 to D365FO. This included developing new data extract scripts, as well as importing data before and at go-live.• Performed all data migration tasks during Heavy Vehicle’s go-live in Apr 2020.• Oversaw the data migration of Balkamp's transition from its legacy AS/400-based ERP, DPS, to D365FO. This included the development of new data extracts and the iterative uploading of data in preparation for Balkamp's go-live scheduled for H2 2021.

• 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 the Balkamp EDI Scorecard app using Qlik Sense Desktop. Iteratively demoed the prototype to business users, collected feedback, and enhanced the app until user acceptance was achieved.• 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 separate each logical reporting layer.• 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 through the GPC Qlik SDLC for production deployment in Aug 2018.• 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 production-grade app. Took the app through the GPC Qlik SDLC for production deployment in Dec 2018.• Offered multiple Qlik Sense training sessions to all Balkamp employees as part of a larger initiative to move users away from legacy ERP push reporting to Qlik Sense Enterprise. Afterwards, conducted training session surveys and received an “Extremely satisfied” rating of 93%.

• 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, configured visuals and reports, made available online for shared/mobile access, and automated data refreshes.• 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 the organization’s SharePoint Online site.• 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 communications company, and Aura’s internal resources to plan, design, develop, test, stage, and deploy the site and its contents.• 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 2016/2017.• Served as project manager for the relocation of a local data center for a client in the Interscholastic Athletics Industry. Compared the benefits, drawbacks, and costs of multiple options and assisted with the selection process.• Provided various clients with information regarding the features, benefits, and costs of leveraging the Microsoft Azure Cloud to host a testing and/or production environment.

• 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 application development-related projects.• 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.

• 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 team to establish a daily export process to provide production data to QlikView. Assisted with the initial design of various QlikView reports. Increased awareness and enthusiasm by promoting and demonstrating QlikView’s reporting features to select Regional and District Managers.• 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.• Served as the hiring manager for the company’s newly created, second IS Business Analyst position.• Integrated the 3 utilities serviced by Damage Prevention Services, Inc. (DPS) in SC and NC after being acquired by USIC. Served as a liaison to DPS’s utility customers and the one call centers used by these customers to transition email locate requests to USIC.

• 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 district.• 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 3rd party ticket management systems are employed, collaborate with the customer and/or software vendor to insure an accurate and functional transition.• 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 inefficiencies in reporting associated with operating two systems in parallel. Responsible for importing configuration data into the target system, as well as ensuring that email locate requests would be processed properly. Worked directly with select customers post-transition to ensure that existing data transfer and reporting processes were still functional.• Worked on a team tasked to integrate 9 “overlap” states in 6 weeks after the acquisition of Consolidated Utility Services. Orchestrated the transition of email locate requests to aid in the reduction of redundant operational expenses.• Reengineered and implemented an updated positive response process for USIC’s largest customers using T-SQL to increase the accuracy and effectiveness of generating detail of field work performed.

• 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 where 3rd party ticket management systems were employed, collaborated with the customer and/or software vendor to insure an accurate and functional transition.• 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 generated data.• 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 C#.NET. The new system created efficiencies that reduced the Billing and Dispatch Department’s labor costs and increased the effectiveness of generated output.• 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 concurrently purchased by USIC, effectively doubling the throughput of the existing system. Served as a liaison to the utilities and the one call centers used by these customers to transition locate requests to USIC.• Designed, developed and integrated a VFP class library into ticket receiving applications to interact with a geo-routing web service, which allowed locate requests to be automatically routed to field technicians by referencing custom map-based polygons.

• 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 imported into the company’s ADP system.• 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, District Managers and Trainers to monitor technicians who had not taken mandatory continuing education exams.• 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 with a developer who altered the Mobile Dispatch client software to display the relevant member codes captured for each locate request to field technicians.• 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 approximately 1,500 field technicians and supervisors to trade, download, sort and complete locate requests.• 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 the one call centers used by these customers to transition locate requests to SM&P.• 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, while 8 modem-based ticket receiving applications transitioned to email processed by a VBA script running in MS Outlook 2000/2003.• 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 jobs on each of its 4 printing presses. The solution superseded the company’s existing application, which was not Y2K compliant, and created more efficiency and less printing press contention.• 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.