Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
TreI Alexander

TreI Alexander

Las Vegas,NV

Summary

Versatile Software Engineer & Data Analyst with 10+ years of experience delivering data-driven solutions across healthcare, government, and enterprise settings. Skilled in SQL, Python, ETL development, and dashboard design using Tableau and Power BI. Combines technical expertise with leadership to drive business insights, automate processes, and mentor cross-functional teams. Certified in AWS, Microsoft, and Tableau, with a strong track record of turning complex data into clear, actionable outcomes.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Healthcare Data Analyst

HHUNY
06.2024 - 04.2025
  • Developed automated ETL pipelines using SQL Server Integration Services (SSIS) and scripted logic in T-SQL for efficient care management data loading
  • Designed and maintained dynamic Tableau dashboards for visualizing client outcomes, program enrollment trends, and performance indicators
  • Built stored procedures to populate assessment tables (Care Plans, HML, Crisis Plans) from raw extracts via Netsmart-linked server
  • Troubleshot care plan errors by testing data pipelines, verifying MAPP export file alignment, and identifying gaps in logic
  • Partnered with business and IT teams to map care workflows into SQL logic and enhance visibility through calculated KPIs and slicers
  • Conducted data validation by reconciling enrollment records with billing data to ensure claim eligibility.
  • Collaborated with QA teams to test backend procedures and support billing system upgrades.
  • Created user guides and documentation for internal staff to support consistent data entry practices.
  • Tools used: SQL Server Management Studio (SSMS), SSIS, Redshift, Tableau Desktop/Server, Snowflake, Azure, ServiceNow, Netsmart, Excel, ShareFile, OneNote and Python (for automation scripts)

Part-Time Data Scientist / Data Science Professor

Rel8ed.to Analytics
09.2021 - 01.2025
  • Led and mentored a cross-functional team of interns and junior analysts on real-world projects involving Python, Tableau, Power BI, and SQL
  • Built custom dashboards and automated reports using Power BI and Tableau to track project KPIs and performance outcomes for external clients
  • Delivered weekly lectures and workshops at partner institutions, including University of Rochester, RIT, Brock University, and Buffalo State
  • Led development of IBM SkillsBuild and Open P-TECH training initiatives; integrated certification tracking with company LMS
  • Conducted 1-on-1 mentoring sessions to support project development and career prep for interns.
  • Audited project data for inconsistencies and coached teams on improving data quality and reporting clarity.
  • Tools used: Jupyter Notebook, Power BI, Tableau, GitHub, Excel, SQL Server, Python (pandas, seaborn, sklearn, bs4), OpenRefine, Orange3, Neo4j, Apache Airflow, Docker, Monday.com and Redshift

Clinical Informatics Analyst (Overnight)

Excellus
03.2022 - 03.2024
  • Analyzed claims and clinical data to identify anomalies
  • Delivered HIPAA-compliant reports using HL7 and FHIR systems
  • Automated reporting with IBM Cognos and Excel macros
  • Collaborated with health IT on care system troubleshooting and user experience
  • Flagged anomalies in HL7 feeds and escalated integration issues to appropriate technical teams.
  • Developed quick reference guides for providers to explain common data transmission issues.
  • Participated in weekly standups to review backlogged medical data issues and implement fixes.
  • Tools Used: HL7, FHIR, Excel, Sharefile, Secure FTP, Microsoft Outlook, Citrix, Remote EMR Access, Epic Systems / Epic Bridges, Healthshare and Splunk

Operations Supervisor, Case Management Department

New York State Department of Health
04.2020 - 02.2022
  • Supervised a large remote team of contact tracers, case investigators, and data entry specialists throughout the COVID-19 pandemic
  • Trained and onboarded over 80 staff on systems such as Dayforce (HR & scheduling), Amazon Connect (telephony), CommCare (case tracking), and state health portals
  • Led daily huddles and performance reviews to ensure adherence to CDC compliance, data accuracy, and customer service standards
  • Developed metrics dashboards in Excel and Power BI to monitor call volume, team productivity, contact rates, and outcome resolution
  • Authored and maintained SOPs, training manuals, and QA forms to standardize case documentation and reduce error rates by 37%
  • Drafted daily operations reports for executive teams summarizing outreach metrics and contact rates.
  • Created training modules for staff on telephony tools and HIPAA-compliant documentation.
  • Implemented a tiered ticketing system to triage support requests and reduce turnaround times.
  • Tools Used: Excel, Power BI, Dayforce, CommCare, Amazon Connect, Microsoft Teams, Outlook, SharePoint, Jira, SAS Studio, Microsoft Dynamics and Smartsheet

Business Analyst /Corporate Event Sales Manager

Bowlero
09.2017 - 03.2020
  • Spearheaded $850K+ in corporate event sales by cultivating high-value client relationships and creating tailored B2B engagement strategies across regional venues.
  • Managed end-to-end event operations—from proposal development to logistics execution—ensuring seamless delivery of conferences, corporate retreats, and social functions.
  • Collaborated with engineering teams to implement hardware/software patches, conduct remote resets, and mitigate system vulnerabilities during off-peak hours.
  • Utilized platforms such as Salesforce, Dayforce, Oracle Hospitality, and Amazon Connect to coordinate communications, scheduling, and case resolution.
  • Designed reporting templates for revenue forecasting across multiple regions and event types.
  • Trained new hires on CRM usage and pipeline tracking best practices for B2B sales.
  • Maintained communication with clients from proposal through post-event reporting to ensure satisfaction.
  • Tools Used: Salesforce, Oracle Hospitality, Microsoft Excel, Outlook, Amazon Connect, Adobe PDF Tools, SAP BusinessObjects, Power BI and HubSpot

Technical Support Supervisor

Verizon
05.2014 - 08.2017
  • Supervised a team of Tier 1 and Tier 2 technical support analysts, overseeing workflow distribution, ticket escalation, and shift coverage for 24/7 operations.
  • Diagnosed and resolved technical problems across various platforms, including DSL, FiOS, mobile broadband, routers, and set-top boxes.
  • Collaborated with network engineers and field techs to escalate outages and contribute to root cause analysis on recurring service issues.
  • Utilized CRM tools and platforms such as Verizon’s VZAccess Manager, Salesforce, and proprietary diagnostics dashboards to document case resolutions and customer notes.
  • Developed an internal wiki for documenting recurring technical issues and fixes for analyst reference.
  • Audited service tickets weekly to track SLA compliance and reduce response time variability.
  • Facilitated cross-team training between tech support and engineering to reduce escalation volume.
  • Tools Used: VZAccess Manager, Salesforce, Excel, DSL diagnostic tools, Verizon ticketing platform, Outlook, ServiceNow and Cisco AnyConnect

Systems Analyst

Big Brothers Big Sisters Of Greater Rochester
06.2009 - 03.2014
  • Developed custom internal software tools using Excel macros and basic scripting to automate donor tracking, volunteer onboarding, and match reporting processes.
  • Managed and maintained databases for program participation, grant compliance, and case management, improving data accuracy and reducing report preparation time by 40%.
  • Collaborated with program managers and IT vendors to troubleshoot software issues, deploy updates, and ensure data integrity across departments.
  • Supported grant application efforts by compiling program statistics, cleaning datasets, and assisting with data-driven narratives to meet funding requirements.
  • Played a key role in migrating legacy data into a modern CRM system, ensuring a smooth transition and minimal service disruption.
  • Oversaw nightly ETL batch jobs to migrate and clean legacy donor and case data into new CRM.
  • Built custom reporting dashboards for grant compliance and board presentations.
  • Provided cross-department training on new tools and workflows to ensure smooth adoption.
  • Tools Used: Excel (macros), Access, Salesforce, proprietary CRM, Outlook, SharePoint, SQL Lite, Salesforce and Power Query

Education

Bachelor of Science - International Business

SUNY Empire State College
Saratoga Springs, NY
06.2022

Associate of Applied Science - International Business / Mass Communication

Monroe Community College
Rochester, NY
06.2015

High School Diploma -

Charlotte High School
Rochester, NY
06.2010

Skills

    SQL Python Tableau Power BI Excel SSIS EMR Systems AWS Azure IBM Cognos HL7/FHIR Salesforce Git Jupyter Data Visualization ETL Development Data Warehousing Technical Support Cloud Platforms Network Diagnostics

Certification

AWS Certified Solutions Architect – Associate
Microsoft Certified: Data Analyst Associate
Tableau Desktop Specialist
Google Data Analytics Professional Certificate
CompTIA A+ & Network+
SAS Programming for R Users (Parts 1 & 2)

Timeline

Healthcare Data Analyst

HHUNY
06.2024 - 04.2025

Clinical Informatics Analyst (Overnight)

Excellus
03.2022 - 03.2024

Part-Time Data Scientist / Data Science Professor

Rel8ed.to Analytics
09.2021 - 01.2025

Operations Supervisor, Case Management Department

New York State Department of Health
04.2020 - 02.2022

Business Analyst /Corporate Event Sales Manager

Bowlero
09.2017 - 03.2020

Technical Support Supervisor

Verizon
05.2014 - 08.2017

Systems Analyst

Big Brothers Big Sisters Of Greater Rochester
06.2009 - 03.2014

Bachelor of Science - International Business

SUNY Empire State College

Associate of Applied Science - International Business / Mass Communication

Monroe Community College

High School Diploma -

Charlotte High School

Similar Profiles

CREATE PROFILE