# Allan Smith

Allan Smith is a remote worker on Himalayas, SQL/ Power BI Developer at Colaberry Inc., based in United States.

Source: https://himalayas.app/@allansmith1

```text
Senior BI & Power BI developer building real-time, decision-ready intelligence with SQL and automation.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | United States |
| Authorized to work in | United States |
| Job categories | Power BI Developer, Power BI Developer, Business intelligence Engineer, Data Analyst, SQL Developer, Senior Power BI Developer |
| Skills | Data Warehouse, Microsoft SQL Server, SSIS, SSAS, Power BI, DAX, Microsoft SSRS, T SQL, SQL, Python, R, Dimensional Models, Data Marts, I Cubes, Data Modeling, Data Validation, Data Quality, Workflow Automation, SQL Tuning, Query Optimization, Indexing Strategies, Execution Plans, Stored Procedures, Views, SharePoint, Access, Mandrill, Baton, Canva, Core Data, Microsoft Visio, Excel, Stata, Performance Optimization |
| Portfolio | https://allansmith.my.canva.site/portfolio |

## What I'm looking for

```text
I’m looking for a role where I can build scalable BI and automation systems—turning enterprise data into real-time KPIs, optimizing SQL performance, and partnering with stakeholders to deliver measurable improvements.
```

## About

```text
I’m a senior-level Business Intelligence and Automation Engineer who builds high-impact data systems that turn raw enterprise data into real-time, decision-ready intelligence. I specialize in designing and scaling SQL Server, SSIS, SSAS, and Power BI ecosystems that automate ETL, power executive KPIs, and drive measurable improvements in accuracy, efficiency, and profitability.

I’m focused on making analytics fast, reliable, and operational. With expertise in SQL performance tuning, advanced data modeling, and DAX-driven analytics, I deliver reporting that works across complex OLTP and OLAP environments—backed by strong stakeholder collaboration, requirements gathering, and executive-level presentation.

In my current role, I engineered enterprise-grade Power BI and SSRS reporting ecosystems with DAX-driven KPIs and executive dashboards, designed scalable SQL Server data models and ETL pipelines, and built AI-powered grading and validation automation using Python and SQL Server. I also implement end-to-end automated workflows (including structured business rules, error handling, and Mandrill email delivery) to reduce risk, eliminate manual work, and create consistent business results.
```

## Experience

### SQL/ Power BI Developer (current)

Colaberry Inc.. Jan 2024 - Present

```text
Engineered Power BI and SSRS reporting systems with advanced DAX KPIs and executive dashboards to improve operational visibility and decision-making. Built scalable SQL Server models and SSIS ETL pipelines, and developed Python/SQL Server AI-powered validation and grading automation to reduce turnaround time from days to minutes.
```

Skills: Power-BI, DAX, SQL-Server, T-SQL, SSIS, ETL, Stored-Procedures, Views, Data-Validation, Data-Quality, Python, Query-Optimization, Indexing-Strategies, Execution-Plans, Email-Delivery-(Mandrill)

### Sr. Account Analyst

Ketcham Fitness Center. Aug 2021 - Dec 2023

```text
Tracked, validated, and maintained membership, billing, and attendance data to support revenue forecasting, churn analysis, and customer retention reporting. Built membership performance reports and improved record accuracy by 30% through data reconciliation and duplicate detection.
```

Skills: Attendance-Reporting, Revenue-Forecasting, Customer-Retention, Reporting, Data-Reconciliation

## Education

### Certification (provider not specified)

Certification in Data Analytics, Data Analytics

```text
Completed a Data Analytics certification in 2025.
```

### Certification (provider not specified)

Certification in Power BI, Power BI

```text
Completed a Power BI certification in 2025.
```

### Jimmy Swaggart Bible College

Bachelor of Arts, Theology

```text
Earned a Bachelor of Arts in Theology from Jimmy Swaggart Bible College in Baton Rouge, LA.
```

## Tech stack

- Microsoft SQL Server
- Microsoft Excel
- Canva
- SQL
- Core Data
- Microsoft Visio
- Stata
- Score
- Remote
- Baton

To contact Allan, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Alok Patel](https://himalayas.app/@alokpatel1): Power BI Developer, BMO Harris Bank
- [Madhavi Kotha](https://himalayas.app/@madhavikotha): Senior Power BI Developer, Medline Industries
- [Ian Jacobs](https://himalayas.app/@ianjacobs): Senior Data & BI Consultant, Praesto Consulting
- [Ali Mavani](https://himalayas.app/@alimavani): Senior BI Developer, EnchantedRock
- [Yemi Ade](https://himalayas.app/@yemiade1): Business Intelligence Developer, Salelytics
- [SAI KIRAN](https://himalayas.app/@saikiran12): SQL / Power BI Developer, Mercy Healthcare
- [Amy Masters](https://himalayas.app/@amymasters): Credit Bureau Reporting Technical Analyst, M&T Bank
- [Paula Nanna](https://himalayas.app/@paulananna): Data Analyst / Power BI Developer, CSAA
- [Samik Amin](https://himalayas.app/@samikamin): Business Intelligence Analyst, Adtalem Global Education
- [Ria Lal](https://himalayas.app/@rialal): Sr. Power BI Developer, StoneX Group Inc.