Skip to content
Andi Phipps

Andi Phipps

Professional
Raleigh, North Carolina, US AI Regular User
Open to Work Job Seeker
QR Code

💼 Work Experience

IT Business Analyst

Argo Group Full Time

Apr 2024 - Dec 2025 • Insurance

Responsibilities

Owned SOX‑compliant User Access Review (UAR) and Infrastructure Access Review (IAR) databases—supporting 35 in-scope applications and all infrastructure environments—and oversaw manual access reviews for 12 applications, partnering with application owners and business stakeholders to identify process gaps and develop more efficient solutions.
Improved the UAR/IAR master data source and increased automation by 19%, including converting 3 applications from manual to automated processes, saving approximately 20 hours per review cycle.
Led ETL and data analysis for quarterly access reviews using SQL, Excel, Snowflake, and Power BI to pull, transform, validate, and reconcile data from multiple sources.
Analyzed and improved IAM workflows across 40+ enterprise applications transitioning 500+ monthly tickets from application teams to IAM, establishing standardized processes that reduced approximately 40 hours of monthly work for application teams.
Partnered with HR and business teams using Workday to support employee lifecycle processes, including onboarding, offboarding, and organizational changes affecting application access.
Gathered requirements, supported testing and implementation, and developed process maps, SOPs, and training materials while serving as a liaison between business stakeholders, application owners, and technical teams.

SQL Business Analysis Excel User Access Review Infrastructure Access Review Automation UAT Process Mapping Process Improvement Workflow

IT Governance Risk and Compliance Analyst

Argo Group Full Time

Sep 2023 - Apr 2024 • Information Technology

Responsibilities

Developed and maintained ITGRC Microsoft SharePoint site with PowerBI dashboards to support IT compliance, risk assessments, and remediation projects. Sharepoint site acted as landing site for any IT audit requests from the external/internal audit teams, as well as storage for any documentation submitted by the application teams for their IT controls.
Owned reporting and presentation processes for senior IT stakeholders on audit timelines, documentation requests, and ongoing remediation projects.
Reviewed audit documentation for 5 IT SOX controls and worked with application teams in order to ensure completeness before submitting to external auditors or completing walk-throughs.

Sharepoint Risk Assessment Power BI Communication Remidiation Planning Business Analysis SOX Compliance Reporting

IT Analyst

Argo Group Full Time

Jul 2021 - Sep 2023 • Information Technology

Responsibilities

Utilized SQL to perform ETL on 25,000+ rows of data, validate data changes, and generate reports for quarterly user access reviews of 20 applications in the automated process and 9 manual reviews.
Implemented and led problem management meetings to identify pain points and remove roadblocks, lowered backlog from 35+ items to 0 over the span of 1 year.
Cultivated relationships with third party vendors and managers across the organization to operate SOX compliance controls successfully, as well as automate the Identity Access Management and User Access Review processes.
Collaborated with third party vendors and other business units to automate and add error-handling to operational tasks cutting down data fix times and errors in reviews.

SQL ETL Automation Process Improvement Communication Cross-Functional Collaboration SOX Compliance

🎓 Education

Bachelor's - Technology Management

Texas A&M University

2016 - 2021

Also received minors in Business and Cybersecurity

Skills & Expertise

SQL 50%