Data Analyst Business Intelligence
Resume:
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
*********.**@*****.***
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