EDUCATION

WhiteHat Security Certificate

Diploma in Information Technology

Web development

Systems Administration)

Professional Diploma in E-Technology

Computing

Web Programming

Designing

Honors Diploma in E-Technology

Computing

Business Application Programming

Certificate in E-Technology Computing

JOHANNIES MILLS-BEALE

BUSINESS INTELLIGENCE ENGINEER/DATA ANALYST

CONTACT

+1-470-***-****

ad4zz3@r.postjobfree.com

WORK EXPERIENCE

PROFILE

Data-driven analyst with 10+ years of experience transforming raw data into actionable insights. Skilled in SQL Server development (stored procedures, views, etc.) and performance optimization for efficient data retrieval. Utilize Tableau to create compelling visualizations that drive informed decision- making. Passionate about data security and maintaining the integrity of sensitive information.

Aspen Dental JULY 2023 - DEC. 2023

Senior Data Engineer

Transformed complex data into actionable insights using industry- leading BI tools like Tableau Desktop, Power BI, SSRS, and Crystal Reports.

Leveraged MDX and DAX to develop intricate calculations and dynamically reference dimensions and measures within dashboards. Streamlined business intelligence processes by migrating reports

(dashboard) to new platforms (e.g., Teradata to GCP, Azure, Oracle to SQL Server, SQL Server to GCP), improving data accessibility and efficiency.

Collaborates with data architects to design and develop data models and ETL processes for efficient data loading into new data structures. Ensured data integrity and accuracy in new and existing database environments through meticulous data validation techniques. Designed and developed optimized dimensional and relational data models to support efficient data storage, retrieval, and analysis. Enhanced data accessibility and efficiency by optimizing dashboards and backend SQL queries, enabling streamlined editing of SQL Server databases and improved data source monitoring.

Charles Schwab Corporation APRIL 2022 - AUGUST 2023 Lead BI Developer

Created interactive drill-through reports using Tableau, SSRS, Looker, and Power BI, enabling users to seamlessly navigate from high-level summaries to granular details across various data sources. Leveraged DAX and MDX to develop insightful calculations and dynamic fields displayed within dashboards, enabling advanced data analysis and user exploration.

1

JOHANNIES MILLS-BEALE

BUSINESS INTELLIGENCE ENGINEER/DATA ANALYST

Collaborated closely with clients to understand their specific needs and translated them into user-friendly dashboards utilizing Tableau, SSRS, Looker, and Power BI.

Leveraged DAX expertise to create advanced calculations and metrics, while simultaneously implementing RLS (Role Level Security) to ensure granular data access control within Power BI models. Migrated existing Teradata-based dashboards to leverage GCP as the data source, ensuring seamless data access and enabling continued functionality for business users.

Expertly analyzed and enhanced Teradata SQL code, resulting in significant performance gains and improved system efficiency. Successfully translated Teradata SQL code to align with GCP big query standards, ensuring seamless functionality and data compatibility within the cloud environment.

Executed comprehensive Teradata SQL code conversion to ensure compatibility with GCP's Big Query dialect, leveraging syntactic and structural optimization techniques.

Bank of America SEPT. 2022 - MAY 2023

Data Visualization Engineer

Leveraged my expertise in Tableau, Looker, Power BI, and Crystal Reports to design compelling reports that effectively communicate data insights for informed decision-making.

Designed and implemented cloud-based applications in Power Apps, leveraging CDS for centralized data management, SQL for backend data manipulation, and Forms and SharePoint Online for user interaction within the Microsoft ecosystem.

Utilized advanced DAX functions and expressions to develop dynamic calculations and metrics, driving the creation of comprehensive dashboards and reports integrated seamlessly within Power Apps. Effectively communicated reporting changes, enhancements, and modifications to team members through clear verbal explanations and detailed written documentation.

Provided leadership for design projects, managing cross-functional teams to develop and maintain critical BI applications. Bridged the gap between business and technology by translating business needs and requirements into actionable system requirements, data mapping strategies, and well-designed data and semantic models.

Wells Fargo SEPT. 2021 - MAR. 2022

Senior BI Developer

TECHNICAL SKILLS

Operational Systems

Windows Operating System

Macintosh Operating System

Databases

SQL Server

My SQL

PHP My SQL

Microsoft Access

Oracle Database

GCP Google Cloud Platform

Programming Language

Python

PHP

T-SQL

P/L SQL

MySQL

Shell

HTML

CSS

Java Script

Reporting Tools

Tableau

Power BI

SSRS

ETL

SSIS

ADF

QDI

SSAS

Project Management

Jira

Axosoft

Salesforce

2

JOHANNIES MILLS-BEALE

BUSINESS INTELLIGENCE ENGINEER/DATA ANALYST

English (Fluent)

LANGUAGES

Developed comprehensive cloud migration procedures and implemented best practices for data backup and recovery. These procedures empowered us the developers with efficient and reliable processes to safeguard and restore data whenever necessary. Facilitated regular meetings with stakeholders to gather and refine system requirements, ensuring alignment with user needs. Expertly planned, designed, and crafted application database code objects, including stored procedures and views, to ensure optimal data functionality and efficient application performance. Leveraged Tableau's diverse visualization capabilities (cross maps, scatter plots, geographic maps, etc.) to create data-driven narratives that effectively communicate insights and inform decision-making. Leveraged analytical skills to identify trends and anomalies within generated operational statistics, proactively communicating potential problems to the management team, fostering informed decision- making.

Developed and maintained comprehensive reports documenting process implementations, improvements, and potential security risks. These reports facilitated continuous improvement and proactive risk mitigation strategies.

Translated client requirements into actionable data visualizations by developing custom dashboards in SSRS, Tableau and Google Looker. Leveraged PL/SQL expertise to construct a robust data integration module, facilitating the efficient transfer of third-party data into the company database, adhering to data integrity standards. Leveraged performance tuning techniques to enhance the speed and responsiveness of Looker, Tableau, Power BI, and SSRS dashboards, facilitating faster data visualization and analysis. Leveraged strong SQL proficiency to design and implement efficient database code objects, including stored procedures for complex data manipulation and well-structured views for optimized data retrieval, ensuring optimal application performance and data integrity. Designed user-friendly interactive dashboards capable of processing large data volumes from SQL Server, Oracle, spreadsheets, and other sources. These dashboards empowered users to navigate and analyze complex data intuitively, leading to informed decision-making. Developed interactive SSRS reports with drill-down and drill-through functionalities, empowering users to navigate hierarchical data structures and access detailed information seamlessly. Examworks JULY 2017 – MAY 2021

Lead BI Developer / Data Analyst

Cloud

GCP

AWS

Web Bug Tracking Tool

Soap IU

Methodologies

Agile

MS Office Applications

MS Word

MS Excel

MS PowerPoint

MS Access

Web Development Applications

Dream Weaver Series

Adobe Flash Series

Adobe Fireworks

Sothink DHTML Menu

Graphic Design Applications

Adobe Photoshop Series

3

Contact this candidate