Business Intelligence Solutions Architect

Eric Mackey

Dallas - Fort Worth, TX

Technical Solutions Leader

Innovative Data Solutions Architect and trusted leader with a track record of delivering complex, defect-free systems and driving digital transformation across diverse industries. Highly skilled at translating intricate business requirements into actionable technical solutions, mentoring teams, and fostering cross-functional collaboration to ensure successful project execution. Recognized for exceptional problem-solving skills, process optimization expertise, and a commitment to exceeding expectations while delivering measurable results.

Skills

ETL / Data Integration / Database Development

System Administration

Advanced SQL Developer

Technical Team Leadership

Data Architecture

AWS Cloud Fundamentals

Systems, Tools & Software

Teradata / SQL Server / Oracle

Azure Data Factory / MS Power BI

SSIS / Informatica

Actian DataConnect

Oracle Warehouse Builder

PL SQL / Transact SQL

PROFESSIONAL EXPERIENCE

CGI − Senior Consultant, Technical Architect assigned to the following projects: Actuarial Data Enhancements − New York Life, 7/2022 – 8/2024

• High-Impact Leadership: Personally requested by VP of Actuaries to address new reporting requirements due to prior delivery success.

• Accurate and Efficient Reporting: Translated complex actuarial instructions into precise technical code specifications, achieving 100% reporting accuracy through iterative SQL development and validation.

• Seamless Deployment: Partnered with IT teams to implement code modifications, ensuring smooth integration while delivering comprehensive knowledge transfer to empower client teams. ERP System Upgrade − State of Illinois, Office of the Comptroller, 12/2021 − 7/2022

• Seamless System Integration: Built sophisticated interfaces by quickly learning and using Actian DataConnect, enabling a successful ERP upgrade for the state’s accounting system.

• Scalable Solutions: Delivered reusable code modules and mentored junior developers to enhance team productivity and skill sets.

• Improved Communication: Authored detailed procedural documents and executive presentations, enhancing stakeholder understanding and engagement.

Relational Data Management Assessment and Finance Utility Project − Charter Communications, 10/2019 – 11/2021

• Strategic Evaluation: Conducted a comprehensive assessment of RDM tools (Semarchy and Informatica), delivering a detailed requirements framework and actionable recommendations.

• Innovative Development: Designed and led the creation of a robust utility billing system for 73,000 accounts, seamlessly integrating with SAP for efficient reporting and approvals.

• Process Automation: Automated labor-intensive manual workflows, accelerating review cycles and significantly improving data accuracy.

Supply Chain BI Implementation − Charter Communications, 4/2018 – 9/2019

• Enterprise Alignment: Migrated and upgraded a $2.3B supply chain reporting system to Teradata, ensuring alignment with enterprise BI standards.

• Resilient Delivery: Overcame upstream delays to achieve on-time delivery while enhancing developer autonomy, earning leadership recognition for individual team member improvement and overall exceptional execution. Eric Mackey Page 2

Multi-Acquisition BI Integration − Charter Communications, 2/2017 – 4/2018

• Post-Merger Data Unification: Consolidated sales data from three merged entities into a unified Sales Data Mart, adhering to new Master Data Management standards as well as Data Warehouse best practices.

• Technical Excellence: Led the development of the most complex processes, delivering a streamlined analytics solution that supported efficient post-merger operations.

Service Delivery Data Mart − Charter Communications, 2/2016 – 1/2017

• Optimized Reporting Efficiency: Designed and implemented data structures and load strategies in Teradata and Oracle to streamline reporting processes, ensuring accurate and timely insights for business users.

• End-to-End Data Analysis: Conducted extensive source data lineage analysis to identify and resolve inconsistencies, enhancing data integrity across multiple operational systems.

• Key Deliverables: Delivered over 150 critical business metrics, validated in collaboration with IT and business stakeholders, leading to successful User Acceptance Testing and improved decision-making capabilities. Ported Critical Invoicing System − Charter Communications, 10/2015 – 1/2016

• Flawless Execution: Delivered a 100% defect-free invoicing system on time, transitioning legacy Oracle processes to Teradata while optimizing data validation and resolving long-standing issues.

• Team Empowerment: Mentored developers and partnered with DBAs, cultivating trust and fostering effective teamwork in a new client environment, ensuring sustainable success. Integrated New Loan Processing System with Legacy Database − Pulaski Bank, St. Louis, MO, 5/2015 – 10/2015

• Project Turnaround: Rescued a struggling project by identifying critical planning gaps, standardizing complex SQL processes, and implementing Change Data Capture and logging for enhanced system functionality.

• Enhanced System Reliability: Collaborated with IT teams to develop and execute a seamless migration plan, ensuring robust validation, user acceptance testing, and successful deployment.

• Business Impact: Delivered a fully integrated loan processing system on schedule, reducing operational delays and earning high client satisfaction by exceeding original project goals. New Data Warehouse Implementation − Geisinger Health System, Danville, PA, 2/2015 – 5/2015

• Strategic Data Integration: Led the Informatica ETL design for a new Enterprise Data Warehouse, establishing a single authoritative data source with transparent business logic and standardized metrics.

• Mentorship and Skill Development: Trained team members with no prior Informatica experience, fostering a knowledgeable and effective development team.

• Scalable Deliverables: Delivered over 150 new data tables with robust ETL processes, enhancing reporting accuracy and responsiveness across the organization.

Earlier Career Experience

IT Manager − Navigator Systems, Addison, TX

Managed all aspects of IT infrastructure for a consulting services company; led a small team to design and implement a new local area network for an office relocation; administered critical systems and ensured high system up-time by maintaining servers and PCs.

Data Systems Officer

United States Marine Corps

Drove the roll-out of USMC Reserve's first nationwide network across 203 sites, automating 5,000+ account creations, enhancing operational efficiency with system automations, and developing policies, training, and a front-end interface for legacy HR systems. Education & Certification

University of Texas, Bachelor of Arts in Psychology AWS Cloud Practitioner Certification - (Amazon Web Services - AWS) – Obtained October 2023

Contact this candidate