Business Intelligence Power Platform

Brian Louis McVey

Arlington, TX 817-***-**** ***********@*****.*** https://www.linkedin.com/in/brian-mcvey-69504221/

Summary

Experienced Business Intelligence and Data Analytics professional with over 16 years of expertise in Oracle and SQL Server databases, data warehousing, BI reporting, and automation solutions. Proven track record of driving business insights and operational efficiencies by leveraging advanced data technologies including Azure Synapse, Power Platform (Power Apps, Power Automate, Power BI), SAP and ETL tools. Adept at collaborating with cross-functional teams to translate complex business needs into technical solutions that enhance decision-making and process automation. Seeking to leverage strong analytical, programming, and leadership skills in a program analyst role to deliver data-driven strategies that drive organizational success.

Experience

Humana

Senior Business Intelligence Engineer May 2023 - August 25, 2025

●Lead Azure Synapse Analytics backend transitioning and automation initiatives to modernize reporting processes.

●Developed scalable Power Platform applications and Power Automate workflows replacing manual processes, improving accuracy and efficiency.

●Delivered critical projects including Point of Care Alerts (POCA) incentive provider communications and payment attestation workflows across national markets.

●Automated distribution of over 300 personalized POCA incentive payment summaries to providers, streamlining Accounts Payable validation.

Humana

Business Intelligence Engineer 2 – IT/DG – (Remote) April 2021 – May 2023

●Partnered with business and IT teams to identify reporting needs, perform comprehensive data analysis, and close data gaps conducive to informed strategic decisions.

●Managed multiple priorities to meet project milestones and deliver actionable insights aligned with business objectives.

●Defined data requirements for system enhancements ensuring seamless integration and operational efficiency.

HealthCare Support December 2020 – April 2021

Senior Consultant (Contract - Remote)

●Collaborated with Humana stakeholders to identify key Genesys data elements and reporting requirements supporting Avaya to Genesys Pure Cloud migration.

●Conducted detailed business user interviews to translate operational reporting needs into technical specifications.

Voxai Solutions September 2015 to December 2020

Senior Genesys Reporting Consultant (Coppell, TX)

●Provided expert troubleshooting and solution design for complex Genesys DB, ETL, and call routing architectures in high-availability environments.

●Delivered custom reporting solutions and coordinated upgrades of Business Objects environments across major clients including USPS.

●Developed and supported real-time and historical Genesys reporting for tier-3 managed services, enhancing client operational visibility.

WRHowell LLC February 2015 to September 2015

Lead Developer/IT Manager (Ft. Worth, TX)

●Solely responsible for all IT development and management initiatives in a startup engineering firm.

●Designed and developed proprietary Access and Oracle Apex applications supporting HR time tracking, purchase requests, and engineering data access.

●Maintained Active Directory domain, user management, and IT purchasing coordination for efficient operations.

DBG Loyalty October 2014 to February 2015

Database Developer (Irving, TX)

●Developed and optimized Oracle PL/SQL stored procedures and database objects supporting loyalty program modules and online retail initiatives.

●Led requirements gathering and schema design for client-specific customizations, interfacing directly with major clients like American Airlines and Bank of America.

Earthbound Trading Company February 2014 to April 2014

IT Support (Grapevine, TX)

●Supported corporate IT operations to enhance nationwide store performance and technical troubleshooting.

●Developed advanced SQL scripts to identify transaction type errors, improve reporting accuracy, and resolve hardware/software issues.

●Partnered cross-functionally to improve store environments and elevate customer service experiences.

Robert Half Technologies February 2014 to February 2014

Database Developer

●Developed and maintained an Auto-Ordering application using Microsoft Access 2010, increasing order accuracy and speed.

●Collaborated with clients to define project scope and specifications, ensuring alignment with business objectives.

●Successfully completed and deployed Phase I ahead of schedule, accelerating client reorder cycles and boosting daily revenue.

Intellisoft Technologies Incorporation December 2012 to April 2013

Database Developer

●Executed development tasks aligned with technical specifications and business requirements.

●Created comprehensive technical design documents and performed unit testing for database deliverables.

●Coordinated testing with Quality Assurance, accelerating defect resolution.

●Maintained thorough documentation and promptly addressed production issues.

Cash America International August 2009 to September 2012

Technical Systems Analyst (Fort Worth, TX)

●Designed and implemented PL/SQL packages, procedures, and views supporting data conversion and reporting processes.

●Enhanced ETL workflows by developing dynamic validation procedures and generating Oracle 10g reports for BI teams.

●Trained new personnel on production systems and provided expert troubleshooting and process support.

●Delivered Tier 3 support to resolve complex networking, database, and system anomalies during transition to centralized database architecture.

●Conducted business requirements gathering, process modeling, and data analysis in OLTP and OLAP environments.

Cash America International August 2009 to February 2011

Programmer III (Fort Worth, TX)

●Served as programmer responsible for the design, development, documentation and business requirements for a time tracking system (TMS), using Visual Studio, C# on an Oracle 10g database.

●Developed a prototype for approval of TMS application and produced the final version using complex PL/SQL procedures and functions.

●Generated reports and user interface forms in a Windows 2007 environment.

●Performed testing on web services using SOAP UI 2.0 & 2.5.

Education

●University of Texas at Arlington

Bachelor of Science (BS) in Information Systems

Bachelor of Business Administration (BBA) in Management

Contact this candidate