Joe Mcguire Email and Phone Number

Worked with an incredibly skilled team of data professionals and business partners to reign in Data Chaos and Reduce Friction across our datascape at Alteryx.Our small but mighty team drove high value business outcomes through our main four pillars:Data Communication, Enablement, and EvangelismData Quality ManagementImprove and Automate Business Processes Enterprise Data Harmonization- Including System to System Data MovementKey areas of impact include: Increased efficiency of GTM/Marketing/Sales processes (measured in $xxM) through better managed third part data asset acquisition and management, smart automations and data integrations (Google Analytics, Marketo, Salesforce, Sales Loft, Gainsight, Dun and Bradstreet D&B, Leadspace, ZoomInfo, Clearbit, Forbes, LinkedIn, Boomi MDH, MDM 2.0)Improved Customer Experiences (measured by feature adoption, NPS score) by exposing key account and usage data through our Cloud Products by developing API Endpoints (Boomi, AWS Lamdba) to serve curated assets and extend core system integrations. Lead data programs around improving Customer Support and Success data quality and usability.Seeded and grew a data centric culture (improved internal Data NPS) through Data Domain Councils, Data enablement/education activities, governance oversight, and Data Quality Management. Team build Data Quality Management System (DQMS) utilizing AWS (Lambda, SQS, RDS, EC2), Great Expectations, AYX Designer, Gitlab CI/CD, Tableau, PowerBI. This instrumentation is essential for knowing where to focus data programs to provide the biggest value as well as being able to measure outcomes continuously over time.Led enterprise data movement and system integration group. Built and maintained systems (Boomi, AYX) that connected 30 major systems with hundreds of point to point and event driven listener processes. Implemented large scale Master Data Management solution to centralize and synchronize key data domains.

Ford Motor Co is a different company compared to the day I started and I have been a key catalyst to this transformation.  Myself and a core team of data scientists unleashed insights using “any means necessary” analytics (mild to wild).  Our successes were quickly recognized and the few grew into a full skill team of ~1,000 data professionals armed to change the way we see, know and act as a company.· Led team of twelve data scientists globally to deliver analytic projects that have touched nearly every aspect of Ford· Delivered $50M of documented value (est. billions undocumented) by managing product complexity. The effect of this work stream drives corporate fitness and is well publicized in Forbes, automotive news and many other major news outlets.o  Led the solution cross functional team, designed the architecture and built many solution componentso  Solution stitched, scored and analyzed data from 45 disparate systemso  Interfaced with analytics R&D nested logit demand models to better describe customer patterns to drive profitability· Assessed new analytics tech and did the dirty work to make them living, breathing and adopted solutions (Alteryx, qlikview, Data Robot, Anaconda, ESRI, Kinetica, Greenplum, Attunity, others)· Defined how we would operate using a new solution framework, business engagement model, and data science best practices· Created reusable data products to promote continuity between groups and increase the speed of future solution delivery· Member of the geospatial center of excellence that aligned Ford’s geospatial strategy (providers, asset retention, etc)· Fostered analytic democratization through trainings, roadshows, and doing “quick builds” with professionals across the business with varying skill levels to demonstrate that analytics is within their reach· Presented often to top-level executives, at Ford’s annual analytic conference, and external venues  such as the Great Lakes Business Intelligence conference

• Performed duties as the lead SQL developer on a conversion of our major collection systems to a SQL Server 2005 based platformo Managed the timeline of the data conversion processo Coordinated the conversion process with developers from our new vendoro Divided and assigned tasks to members of my teamo Wrote main java program to extract data from our legacy system that was built on a Cache databaseo Wrote scripts to transform the data so it can be used in the new system’s database schema• Designed, built and maintained an automated solution to electronically handle credit reporting disputes using EDI with e-Oscaro Complete writing a Java program to read in “dispute” data, find corresponding account information from main collection system, write both set of data up to a relational database (SQL 2005)o Design and create relational database to house dispute, collection system, and response datao Design and create stored procedures and functions to provide for accurate response generationo Implement a database maintenance plano Design and create a front end for end user to pull up disputes, the historical data from the collection system, and response data for use in legal challenges• Designed, built and maintained a system to process purchased data into a standardized file to be imported into our collection systemo Front end built in C#.net to allow users to import, translate, and export a standardized fileo Multiple complex stored procedures required to perform the sophisticated cleaning and calculations required by the process• Supported SQL Based Business Applicationso Provided day to day support for the Kronos time keeping application, MS SQL 2000 environmento Developed maintenance plans to ensure the system would perform and be reliable o Provided day to day support for Navision our general ledger and accounts payable system, MS SQL 2000 environment

• Supported and maintained existing MS Access white sheet database for the accounting departmento Gathered business requirements for their database archival processo Wrote code in .Net to automate their archive process o Made changes to data structure to allow for longer GL codeso Modified existing export code and queries to support the new formato Modified existing code to the front end to accept the new formato Coordinated these modifications with changes made in Navision• Provided support for the Clients database o Worked with management to determine the specifics of what information needed to be generated from the existing databaseo Created new complex queries to base a revamped set of New Purchase reports off ofo New system allows for clean export into MS Excel• Worked with head member of infrastructure to develop and maintain a uniform solution for remote access into all contracted agencies’ system for auditing purposeso Gathered business requirements from Forwarding Agency Department to incorporate into remote access systemso Created in accordance with our network security policyo Set up conference calls and meetings with agencies to discuss our requirements and draft and implementation plan• Made recommendation to replace scanning and filing system with an electronic process.o Implemented new software and procedures o Trained current users on the newly developed methods of remote access and automated scanning and filing procedure

Enhanced logistics management system through system automation, stabilization of processes (semaphore based stored procedures, data processing) and direct communication to clients

• Cultivate positive relationship between Hewlett Packard and technical stores, primarily Microcenter in Madison Heights, Mi• Perform trainings of sales employees at Microcenter to keep them on the cutting edge of Hewlett Packard products and support• Worked directly with customers to enhance Hewlett Packard’s reputation and increase their overall sales• Advance my own knowledge of current technical breakthroughs by attending technical trainings from Hewlett Packard• Maintain and setup store display units and perform general merchandising duties• Acted as a direct liaison between Hewlett Packard and Microcente

• Provided internet access technical support to end users by phone• Generated sales through enhancing users’ accounts by adding anti-virus and internet acceleration services• Provided telephony support to end users and properly escalated issues to dispatchers who would in turn alert ground crew members to act

• Created system to organize, route, and track help desk tickets submitted by end users• Provided first level support of hardware and software• Maximized end users’ efficiency by performing upgrades and reallocating hardware• Reported to management on future requirements to include in budget expectations