Brian Rafferty Email & Phone Number

Chicago, Illinois, United States

-Successfully led the integration and end-to-end testing and change management of client deployments- Developed custom training materials for clients to execute UAT scripts and document findings -Created test plans for client configured software/hardware solutions including UAT- Worked in client discovery and requirement gathering sessions to prepare for deployment-Collaborates with Project Managers and Sales drafting SOW and RFPs-Identifies functional gaps needing escalation to the Product Team during upcoming sprints-Develops annual Quality Assurance goals based on corporate KPIs-Builds and maintains Quality Assurance processes, standards, and documentation-Works with customers to create customized testing procedures for inbound/outbound integrations-Documents and escalates severity of defects and bugs within Jira ticket to prevent deployment delays-Delivers quality presentations across multiple client implementations for trends

-Successfully managed a team of 16 auditors responsible for auditing gas pipeline construction and O&M activities in accordance with PHMSA Part 192 regulations-Consolidated various systems of record to create an auditing ranking system to drive priority of construction audits-Administered access to the auditing QAQC system for PGL and NSG-Monitored O&M and Capital budgets to ensure compliance with internal guidelines-Communicated annual program trends and identified areas for improvement, leading to increased efficiency and effectiveness of training programs -Regularly reviewed and updated auditing checklists in accordance with QAQC Administrative Directive, ensuring compliance with industry standards and regulatory requirements.-Rebalanced auditing needs based on internal and industry trends of deficiencies observed-Implemented work stoppages when severe audit findings were discovered during auditing-Coordinated with state and federal regulatory agencies during regular visits-Reported monthly and quarterly findings to Operations and Executive Leadership-Conducted annual crew refresher training for Field Employees on observed trends-Reviewed auditors findings, addressed field disputes, and approved/rejected all follow up responses from Operations-Managed the auditing of Contractor Programs to ensure compliance with their OQ Action Plan-Investigated incidents and developed standards to improve Pipeline Safety and ensured that investigations were handled in a timely and efficient manner-Managed server migration planning, and testing of the QAQC program and SSRS Reports-Provided support for state, federal, and external auditing group questions and data requests, ensuring compliance with industry standards and regulatory requirements-Led a system consolidation project for auditing systems, including data migration from the retired system

Capital Construction Project Management-Implemented process improvements using SSRS exception reports to swiftly address construction operations issues-Created exception SQL reports to regularly analyze budget data from multiple sources-Supervised union workforce in developing scopes of work and schedules-Conducted line of lay walks with contractor workforce and reviewed design drawings-Approved final asbuilts for entry into GIS-Managed iPad hardware and user profiles for onboarding new devices/employees-Piloted a pre-construction service marking form using ArcGIS Survey123-Maintained a Microsoft Access database for a 10-person service installation team for installation record gathering and team reporting

Capital Construction/Process Improvement-Developed a data repository utilizing FME and SQL reports to track engineering design, permitting, field construction, and as-built completions by integrating 6 systems of record-Created dashboard reporting with SSRS to evaluate construction’s progress for 150 active users -Led the planning and implementation of a mobile as-built application and procedures for documenting field restoration and main installation for 100 users-Conducted migration of pending construction orders during implementation of a Customer Information System-Developed reports to manage restoration/complaints and monthly extracts submitted to the City of Chicago-Led the implementation of a field data gathering restoration tool in ArcGIS Collector for 40 users-Created system enhancements for user requests with additional reports (ArcGIS, Navigate, ARM Web Portal)

Business Support and Systems Integration - Associate Engineer-Developed and conducted training for operations groups to locate gas facilities -Created functional and regression tests for work management and accounting systems -Coordinated with developers and administrators to communicate issues with systems of record -Gathered functional specifications for operational reports -Determined leak survey investigations using SQL to evaluate facility records-Drove operations groups using analysis of asset records using SQL

-Supported project management during the startup of food and beverage production lines -Worked with equipment vendors to create budget estimates for future projects -Developed Process Line Controls to integrate new conveyor systems into production lines -Created as-built drawings for existing facilities and packaging designs in AutoCAD

-Aided project management and design teams for industrial and military facility upgrades -Created Process and Instrumentation Diagrams (P&IDs) -Supported process engineers with Fluid Mechanics, Heat Transfer, and Thermodynamic calculations -Assisted HVAC groups by creating engineering design layouts using AutoCAD and MicroStation