Print Setup

Xavier B. Hemmings

Data Engineering | ETL & Automation | Database Optimization

Kingston, Jamaica | +1 (876) 507-6645 | x_hemmings@yahoo.com | XavierHemmings.com

PROFESSIONAL SUMMARY

Data Engineer and Automation Specialist with 15+ years of experience building scalable data pipelines, ETL processes, and workflow automation solutions. Expert in data transformation, database optimization, and developing automated reporting systems across Oracle SQL, Power Query, and Python. Proven track record of architecting enterprise data infrastructure supporting global operations and implementing automation solutions that reduce manual effort by 60-70%. Strong background in data quality management, schema design, and building self-service analytics platforms.

15+ YearsData Engineering & Automation

2M+ Records/DaySubscriber Data Processed via ETL Pipelines

6,500+ UsersServed by Global Data Infrastructure

70%Faster Query Performance via Optimization

PROFESSIONAL EXPERIENCE

Workforce Management Manager & Head of Global Insights (Consultant)

Support Services Group | September 2021 - September 2024

Architected and implemented enterprise-wide data infrastructure supporting global operations across NA, CALA, EMEA, and APAC regions
Designed standardized data collection pipelines using Power Query and Power BI, processing data from 125 lines of business
Built robust ETL workflows for aggregating and transforming operational data from 6,500+ agents across multiple source systems
Developed data warehouse schemas and dimensional models to support executive reporting and analytics requirements
Implemented data governance frameworks ensuring data quality, consistency, and accuracy across multi-region operations
Created automated data refresh schedules and monitoring systems using Power BI Service and custom logging procedures
Optimized query performance through indexing strategies, partitioning, and database tuning
Established data validation processes and error handling mechanisms for production data pipelines
Developed documentation for data architecture, transformation logic, and maintenance procedures

Senior Business Intelligence Analyst

Digicel Jamaica | September 2018 - Present

Developing complex ETL processes in Oracle SQL for transforming subscriber data from multiple source systems
Building automated reporting pipelines using Oracle PL/SQL jobs and Power BI Service, eliminating manual report generation
Designing and maintaining data models supporting customer value management and geographic analytics across 2M+ subscribers
Implementing incremental data refresh strategies to optimize processing time for large-scale datasets
Creating Power Query functions and custom M code for reusable data transformation components
Developing DAX measures and calculated columns for advanced analytics in Power BI semantic models
Optimizing SQL queries to reduce report generation time by 70% through query tuning and indexing
Building data quality checks and validation rules to ensure accuracy of customer segmentation and targeting
Integrating geographic data sources with subscriber information, creating enriched datasets for spatial analysis
Maintaining version control and deployment processes for database objects and Power BI artifacts

Automation Developer & Solutions Engineer (Contractor)

VMBS (Victoria Mutual Building Society) | Various Projects

Designed and implemented Power Automate workflows for automated reporting, reducing manual effort by 60%
Built automated Excel report generation system with scheduled email distribution to stakeholders
Developed data transformation logic for extracting, cleaning, and formatting data from legacy systems
Created comprehensive technical documentation for automation solutions, including architecture diagrams and deployment guides
Implemented error handling and logging mechanisms for production automation workflows
Conducted data quality audits, identifying and correcting systematic data integrity issues in financial systems
Developed data validation scripts ensuring regulatory compliance for financial records
Built reusable automation components and templates for future solution deployments

Data Solutions Architect

Symptai - CIBC Project | June 2023 - January 2024

Designed comprehensive data architecture including database schema, entity relationships, and data flow diagrams
Defined data storage strategies, indexing approaches, and query optimization techniques for scalability
Developed technical specifications for ETL processes and data integration requirements
Collaborated with development team on implementation of data layer and API data access patterns
Ensured data architecture aligned with security, compliance, and performance requirements

Key Projects & Achievements

Enterprise Data Platform - Support Services Group

Built from scratch a global data infrastructure serving 6,500+ users across 4 regions
Reduced report generation time from days to hours through automated ETL pipelines
Achieved 99.9% data accuracy through comprehensive validation and quality checks

Automated Reporting System - VMBS

Eliminated 60% of manual reporting effort through Power Automate workflows
Created self-maintaining Excel reports with automated data refresh and distribution
Implemented data quality audits identifying critical system issues before regulatory impact

Customer Analytics Platform - Digicel Jamaica

Processed 2M+ subscriber records daily through optimized ETL pipelines
Reduced query execution time by 70% through SQL optimization and indexing
Integrated multiple data sources (billing, CRM, geographic) into unified analytical database

Database Performance Optimization Initiatives

Triggered clean-up and maintenance of database schemas improving query performance
Generated comprehensive logs of automation procedures for monitoring and troubleshooting
Implemented indexing strategies reducing report load times from minutes to seconds

Technical Implementations

Data Pipeline Orchestration: Designed multi-stage ETL workflows with dependency management and error recovery
Incremental Loading: Implemented change data capture patterns for efficient large-scale data updates
Data Quality Frameworks: Built automated validation checks, anomaly detection, and data profiling routines
Performance Optimization: Achieved 70%+ improvement in query performance through indexing, partitioning, and query refactoring
Automation Logging: Developed comprehensive logging and monitoring systems for production data pipelines

Professional Highlights

Architected data solutions for 3 of Jamaica's top 10 organizations generating significant revenue impact
Consistently recognized for extracting value from latent data stores through innovative automation solutions
Led implementation of data-driven processes across organizations with non-data-driven cultures
Directed development of in-house software solutions through analytics findings and technical leadership
Recommended by C-suite executives as data infrastructure lead on 20+ strategic initiatives

TECHNICAL SKILLS

Core Competencies

ETL/ELT Pipeline Development
Data Warehouse Architecture
Database Design & Optimization
Workflow Automation
Data Quality & Governance
Power Query & M Language
Oracle PL/SQL Development
Python Scripting & Automation
Power Automate Workflows
Scheduled Job Management
Data Pipeline Orchestration
Performance Tuning

Tools & Technologies

Databases & SQL: Oracle SQL (Advanced), Oracle PL/SQL, MySQL, SQLite, SQL Server, Database Design, Query Optimization

ETL & Data Integration: Power Query, M Language, SSIS concepts, Data Pipeline Design, Incremental Loading, Change Data Capture

Programming & Scripting: Python, VBA, JavaScript, PowerShell, Bash scripting

Automation Tools: Power Automate, Power BI Service, Scheduled Jobs, Task Automation, Workflow Orchestration

Data Modeling: Dimensional Modeling, Star Schema, Snowflake Schema, Data Warehouse Design, Normalization

BI & Analytics: Power BI (DAX, Power Query), Tableau, Excel (Advanced formulas, Power Pivot)

Cloud & Platforms: Power Platform, Azure concepts, Oracle Database Server, Linux/Unix environments

Development Practices: Version Control (Git), Documentation, Code Review, Testing & Validation, Performance Monitoring

EDUCATION

Executive MBA in Business Analytics - Commencing 2026

Business Administration Studies - University of the West Indies (UWI)

Certificates & Coursework

Microsoft Power BI Data Analyst Associate Coursework

Master BI Data Storytelling - BI Brainz

SQL for Data Science - University of California, Davis / Coursera

Harvard/MIT edX Professional Program in Data Science

Modular Computer Studies - UTech SciT