XAVIER B. HEMMINGS
PROFESSIONAL SUMMARY
Data Engineer and Automation Specialist with 10+ 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.
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
PROFESSIONAL EXPERIENCE
Head of Global Insights & Data Infrastructure Lead (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 Data Engineer / BI Developer
Digicel Jamaica | September 2018 - Present
- Developed complex ETL processes in Oracle SQL for transforming subscriber data from multiple source systems
- Built automated reporting pipelines using Oracle PL/SQL jobs and Power BI Service, eliminating manual report generation
- Designed and maintained data models supporting customer value management and geographic analytics across 1M+ subscribers
- Implemented incremental data refresh strategies optimizing processing time for large-scale datasets
- Created Power Query functions and custom M code for reusable data transformation components
- Developed DAX measures and calculated columns for advanced analytics in Power BI semantic models
- Optimized SQL queries reducing report generation time by 70% through query tuning and indexing
- Built data quality checks and validation rules ensuring accuracy of customer segmentation and targeting
- Integrated geographic data sources with subscriber information, creating enriched datasets for spatial analysis
- Maintained 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 | Recent Project
- 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
TECHNICAL SKILLS
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
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 1M+ 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
EDUCATION & CERTIFICATIONS
BSc. Business Administration - University of the West Indies (In Progress)
Professional Certificate in Data Science - Harvard University & MIT EdX, 2016
- Query Relational Data, Use Code to Manipulate and Model Data, Machine Learning Fundamentals
Microsoft Certified Power BI Data Analyst Associate - April 2022
SQL for Data Science - University of California, Davis, 2019
Certificate in Modular Computer Studies (CMCS) - UTEC Scit, 2012
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
- Championed development of in-house software solutions through data-driven insights and technical leadership
- Recommended by C-suite executives as data infrastructure lead on 20+ strategic initiatives