Glenn Fitzpatrick Email & Phone Number

Washington, Dc

Led development of an executive information system used to monitor the status of federal agency regulations and rulemakings across multiple departments.Led development of a risk-based nationwide model used to rank and prioritize pipeline unit segments for inspection.Led development of an application to analyze facility addresses, improve address data quality, retrieve geocodes for mapping locations, and to continuously improve data quality through incremental… Show more Led development of an executive information system used to monitor the status of federal agency regulations and rulemakings across multiple departments.Led development of a risk-based nationwide model used to rank and prioritize pipeline unit segments for inspection.Led development of an application to analyze facility addresses, improve address data quality, retrieve geocodes for mapping locations, and to continuously improve data quality through incremental updates.Subject matter expert for IBM Watson analytical models and Tableau visualizations of Hazmat and pipeline incident and enforcement activities.Managed system architecture documentation, system security assessments, and contingency planning.Represented team interests as a member of the administration-level Change Management Board.Performed requirements gathering, developed system mock-up designs according to user feedback, led user acceptance testing, provided training, and led presentations given to agency CIO, office director, and division chiefs.Fulfilled Hazmat Intelligence Portal (HIP) / Pipeline Data Mart (PDM) requests through data analysis and ad-hoc Oracle Business Intelligence Enterprise Edition (OBIEE) report development. Show less

Washington, Dc

Fulfilled Hazmat Intelligence Portal (HIP) / Pipeline Data Mart (PDM) requests through data analysis and ad-hoc Oracle Business Intelligence Enterprise Edition (OBIEE) report development.Developed a proof-of-concept screening process to identify suspected “chameleon” motor carriers and wrote report to Congress summarizing the technical system.Analyzed and improved domestic and international address data quality, leading to increased Dun & Bradstreet company matching accuracy and… Show more Fulfilled Hazmat Intelligence Portal (HIP) / Pipeline Data Mart (PDM) requests through data analysis and ad-hoc Oracle Business Intelligence Enterprise Edition (OBIEE) report development.Developed a proof-of-concept screening process to identify suspected “chameleon” motor carriers and wrote report to Congress summarizing the technical system.Analyzed and improved domestic and international address data quality, leading to increased Dun & Bradstreet company matching accuracy and the geocoding of company address data for use in other reporting and monitoring systems.Took ownership of Hazmat and Special Permit company address database daily operation and maintenance tasks.Took ownership of role as single point-of-contact for PHMSA / FMCSA stakeholders.Developed reports to notify management of new HAZMAT incident records, and identify incident records with data issues.Developed dashboards for management review of high-level key performance indicators.Performed requirements gathering, developed system mock-up designs according to user feedback, led user acceptance testing, provided training, and led presentations given to agency CIO, office director, and division chiefs. Show less

Acted as point-of-contact for internal account managers and external contracting officers as part of Enterprise & Government Finance. Constructed and reviewed Teradata SQL queries to automate and streamline access of customer account details from data warehouse. Ensured that accounts payable are calculated accurately, reviewed for compliance, and paid on schedule.- Calculated, reviewed and paid in excess of $126.7MM to vendors. (February 2011 – present)- Recovered approximately… Show more Acted as point-of-contact for internal account managers and external contracting officers as part of Enterprise & Government Finance. Constructed and reviewed Teradata SQL queries to automate and streamline access of customer account details from data warehouse. Ensured that accounts payable are calculated accurately, reviewed for compliance, and paid on schedule.- Calculated, reviewed and paid in excess of $126.7MM to vendors. (February 2011 – present)- Recovered approximately $325,000 in payments issued in error. (February 2010 – present)- Designed and developed a tracking system for use by Wide Area Workflow payments team to monitor status of invoices and available funding. (February 2012 – July 2012)- Received commendations from an external customer for efficient reporting and payment processing, where required information was provided more than a month earlier than ever previously received. (October 2011)- Received commendations from an external customer, as well as two internal Associate Directors, regarding timely and accurate Q4 payments and reporting. (March 2011)- Led training course for team members on designing, modifying and running SQL queries for data warehouse access. (February 2011)- In partnership with Contracts Compliance Team, discovered an error where a fee paid to a customer did not accurately reflect the fee described in the customer's contract, leading to the recovery of $77,144 that had been paid incorrectly since October 2009. (September 2010)- Managed and consolidated team process knowledge within a Microsoft SharePoint installation to create a single source for data warehouse query logic, and a single reference site with requirements and instructions for submitting payments to vendors. (July 2010) Show less

Served as point-of-contact and subject matter expert for desktop system processes, requirements and enhancements related to National Government / Federal Accounts. Performed system maintenance as necessary per end-user requests. Performed user acceptance / bug testing of sales and customer service systems in development. Collaborated with Training, Communication and Operations departments to produce required support and reference materials.- Deployed an Ariba PunchOut e-commerce system… Show more Served as point-of-contact and subject matter expert for desktop system processes, requirements and enhancements related to National Government / Federal Accounts. Performed system maintenance as necessary per end-user requests. Performed user acceptance / bug testing of sales and customer service systems in development. Collaborated with Training, Communication and Operations departments to produce required support and reference materials.- Deployed an Ariba PunchOut e-commerce system and self-serve customer portal, working with internal project and sales teams and their external customers. Captured project requirements, assisted with demonstration of system capabilities, and provided customer feedback to development team and stakeholders. (August 2009 – February 2010)- Discovered a flaw in how certain discounts could be self-provisioned, allowing a potentially large number of ineligible users to receive discounts in error. Designed and promoted a series of steps to research and verify eligibility, correct accounts, and prevent further loss of revenue. (October 2009) Show less

Provided superior customer service to resolve federal, state, and local government account escalations for various levels of management, accurately, compliantly, and within required deadline through account reworks and negotiation. Acted as liaison between government agencies, sales, and senior management. Researched and identified departmental process improvements to reduce customer dissatisfaction and decrease overall churn and escalation rates.- Recognized throughout Federal Accounts… Show more Provided superior customer service to resolve federal, state, and local government account escalations for various levels of management, accurately, compliantly, and within required deadline through account reworks and negotiation. Acted as liaison between government agencies, sales, and senior management. Researched and identified departmental process improvements to reduce customer dissatisfaction and decrease overall churn and escalation rates.- Recognized throughout Federal Accounts department for providing consistently detailed and accurate resolutions to customer issues. (June 2009)- Developed decision support system to assist with manual rework calculations, improving accuracy of billing processes and saving over $90,000 / year in increased team productivity. (March 2009) Show less

Provided critical customer care services to high-profile federal, state and local government accounts within 24-48 hours as part of Internet Response Team.- Awarded for a top quality score average of 97% on team for the first six months of 2008.- Selected to train and assist new employees at the Government Service Center's newest location in Huntsville, AL. (October 2007)

Provided retail support through account maintenance, billing assistance and accessory sales.

Provided technical assistance and classroom support for an undergraduate course on digital photojournalism. Educated students on use of photographic technique, equipment and software, while also providing input, feedback and encouragement. Designed, constructed and maintained an online gallery for class submissions. Collaborated with instructor on lecture material and provided additional material for online discussion to reinforce classroom teachings.

Ms, Information Systems Management

Cumulative GPA: 3.40

Certificate Of Achievement, Six Sigma Green Belt

Bs, Information Systems Management

Cumulative GPA: 3.158

Undergraduate Studies, Information Systems Management

Activities and Societies: Lambda Chi Alpha Fraternity