I'm Andrew M. McGrath, an information technology professional with over 20 years of experience across design, development, testing, and production support. More recently, I have focused on data analysis and quality assurance, bringing a well-rounded perspective to teams and projects. I thrive on turning complex data into actionable insights and on contributing to key initiatives as both a practitioner and a small-team leader. Throughout my career I’ve helped organizations improve reporting, optimize processes, and deliver on-time results by applying ITIL practices, agile methodologies, and hands-on technical skills. I’m committed to continuous learning and to leveraging my diverse background to drive value for stakeholders and customers alike.

Andrew M. McGrath

I'm Andrew M. McGrath, an information technology professional with over 20 years of experience across design, development, testing, and production support. More recently, I have focused on data analysis and quality assurance, bringing a well-rounded perspective to teams and projects. I thrive on turning complex data into actionable insights and on contributing to key initiatives as both a practitioner and a small-team leader. Throughout my career I’ve helped organizations improve reporting, optimize processes, and deliver on-time results by applying ITIL practices, agile methodologies, and hands-on technical skills. I’m committed to continuous learning and to leveraging my diverse background to drive value for stakeholders and customers alike.

Available to hire

I’m Andrew M. McGrath, an information technology professional with over 20 years of experience across design, development, testing, and production support. More recently, I have focused on data analysis and quality assurance, bringing a well-rounded perspective to teams and projects. I thrive on turning complex data into actionable insights and on contributing to key initiatives as both a practitioner and a small-team leader.

Throughout my career I’ve helped organizations improve reporting, optimize processes, and deliver on-time results by applying ITIL practices, agile methodologies, and hands-on technical skills. I’m committed to continuous learning and to leveraging my diverse background to drive value for stakeholders and customers alike.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
See more

Language

English
Fluent

Work Experience

Data Analyst at Charter Communications
June 1, 2022 - December 1, 2024
Managed data with a central tool, improving reporting by 20%. Generated ~20 Excel-based reports weekly for daily financial and headcount analytics, contributing to a 35% improvement in report accuracy. Used SQL and reporting tools to manage enterprise data. Implemented an Alteryx workflow to create a softlink from a Teradata DB to an Excel file for the bonus compensation project.
Consultant Data Analyst II at Beacon Hill Consulting
March 1, 2022 - June 1, 2022
Handled data with a central tool and conducted SQL work on an MS Access database backed by MS Excel data for the Goals 2022 bonus project. Analyzed business needs and proposed forward-looking solutions with the bonus goals in mind.
Systems Analyst at Consolidated Edison
August 1, 2020 - March 1, 2022
Part of the PL/SQL application development team supporting a key app/db for electrical engineering, interfacing with the CGI vendor. Delivered 99% error-free code. Batched and updated L2 cross-reference tables to ensure correct project billing. Designed and implemented 10 ad-hoc projects on time and under budget. Created a user manual for code migrations.
Application Support Engineer (L3) at KPMG (Contract)
January 1, 2020 - March 1, 2020
Admin member of the Level 3 Windows admin support team, supporting KPMG products. Performed backup and restore operations on key engagement files. Created, worked on, and resolved Service Now tickets.
Discovery Engineer at JPMorgan Chase & Co
June 1, 2013 - November 1, 2019
Discovery support team member using analysis, shell scripting, Oracle SQL development, Windows and Red Hat Linux. Monitored BDNA Fit and Prod server farm of 80+ hosts. Managed production and Fit core UNIX Oracle servers and Windows hosts for Enterprise Software Asset Management. Led a datacenter move with server relocations, expanding capacity and reducing costs. Improvements in SLA and knowledge/documentation. Coordinated 500GB disk additions across four DB servers in Prod BDNA; led ITSM, PRIME, and Unix/SAs teams for space planning. Early production deployment of BDNA 7.7.1 and development of dedupe automation. Coordinated NA BDNA scanning timing and produced multiple hot fixes and ITRC items for risk management.
IT Senior Specialist / IT Engineer / IT Specialist at PepsiCo - Pepsi Beverages Company
July 1, 2002 - February 1, 2013
Member of the application support team with a specialty in Korn shell scripting and Oracle SQL development and reporting. Provided 24/7 support for the Customer Payment System, managing accruals for field programs across 4,000+ users and delivering Break and Fix duties for the centrally managed Enterprise Application.

Education

Bachelor of Science, Computer Science at Manhattan College (now Manhattan University)
January 11, 2030 - December 10, 2025

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Professional Services, Energy & Utilities, Telecommunications, Retail, Software & Internet