Senior Application Analyst - Data-Driven System Optimization

John O’Meara

313-***-**** *********@*****.*** https://www.linkedin.com/in/jromeara/

SUMMARY

Senior Application Analyst with 10+ years of experience supporting, optimizing, and enhancing enterprise systems across higher education and corporate environments. Expertise in CRM and SIS platforms (Technolutions Slate, Ellucian Banner) with a strong focus on system performance, data integrity, and cross-functional collaboration. Proven track record of resolving complex system issues, improving workflows, and delivering data-driven insights that enhance operational efficiency and user experience. Known for bridging technical and business teams to drive reliable, scalable solutions. CORE COMPETENCIES

● Enterprise Application Support &

Optimization

● CRM/SIS Administration (Slate,

Banner)

● System Integration & Data Flow

Management

● Advanced Troubleshooting & Root

Cause Analysis

● SQL Development & Data Analysis

● Reporting & Dashboarding (Power

BI)

● Workflow Automation & Process

Improvement

● Cross-Functional Collaboration (IT,

Admissions, Operations)

● End-User Support & Training

● Data Integrity, Governance &

Compliance (FERPA)

PROFESSIONAL EXPERIENCE

Lead Systems Business Analyst 2022 – Present

Wayne State University – Detroit, MI

● Lead support and optimization efforts for Slate CRM and Banner SIS, ensuring reliable system performance across admissions operations

● Own resolution of complex application and data issues (integration failures, data mismatches, processing errors), reducing operational disruptions

● Partner with Admissions, Registrar, and IT teams to enhance system functionality and improve end-user experience

● Perform data audits, validation, and reconciliation to maintain high levels of data accuracy across enterprise systems

● Develop SQL queries and analytical reports to diagnose issues and support strategic decision-making

● Design and maintain Power BI dashboards to monitor system performance, data quality, and enrollment metrics

● Drive process improvements by documenting workflows, standardizing troubleshooting procedures, and identifying automation opportunities Software Application Analyst 2022

Taft Law – Southfield, MI

● Software Application Analyst 2022

● Supported and maintained enterprise applications, ensuring system reliability and high user satisfaction

● Diagnosed and resolved application issues while identifying root causes and implementing long-term fixes

● Developed process documentation and support standards to improve operational consistency

● Maintained compliance with data security and governance requirements Applications Technical Analyst 2021

Wayne State University – Detroit, MI

● Provided technical and application support for enterprise systems supporting remote learning environments

● Assisted with system implementations, upgrades, and integrations across institutional platforms

● Troubleshot performance issues and collaborated with IT teams to resolve incidents and improve system stability

Senior Systems Integrator 2016 – 2021

Wayne State University – Business Technology Solutions

● Senior Systems Integrator 2016 – 2021

● Managed and supported multiple enterprise applications across campus systems

(housing, access control, dining, parking)

● Monitored system performance and led resolution of application and integration issues

● Supported SQL databases and data-driven applications, ensuring reliability and performance

● Delivered reporting solutions and documentation to support operational decision-making

● Maintained high system availability across 1,000+ connected devices and systems Senior Business Analyst (Contract) 2015 – 2016

Blue Cross Blue Shield of Michigan – Detroit, MI

● Supported enterprise applications through SQL-based reporting and data validation

● Ensured data accuracy and integrity across large, regulated datasets

● Delivered insights to support operational improvements and business decisions TECHNICAL SKILLS

● Applications & Platforms:

Technolutions Slate CRM, Ellucian

Banner SIS

● Data & Reporting:

SQL, Power BI, Excel, Access,

Cognos

● Compliance:

FERPA, Data Security &

Confidentiality

● Systems & Tools:

CBORD (CSGOLD), ASSA ABLOY,

Pharos, iParc

● Databases:

SQL Server, Oracle (basic)

● Operating Systems:

Windows (advanced), Linux (basic)

● Automation & Integration:

Power Automate, ASP, PHP, LDAP

EDUCATION

● Bachelor of Arts – Siena Heights University

Contact this candidate