Senor Business Intelligence Consultant

MACLEAN ASANTE

Mesa AZ ***** 508-***-**** *******.*******@*****.***

PROFILE

Analytical and motivated Business Intelligence Analyst with skills in business data analysis, stakeholder management, business Intelligence, Reporting and database development. I work with a sense of determination and purpose to help drive business growth and success. I have worked on data projects, utilizing my strong knowledge of business operations to monitor, measure and appraise sales, marketing and operational performance; I have built reports that have influenced strategic business decisions leading to decent return on investment. CORE COMPETENCIES

Years of experience in Retail, health, inventory management employee information management and client billing

Working data analytics and reporting experience using PowerBI, SSRS and Excel

Years of experience building ETL packages/pipeline for data load into data warehouses and data marts

Advanced – Level experience in building data models, dimensional models, and Data Vault methodologies

Excellent customer service skills, thrive in both independent and collaborative work environments.

Good leadership, organizational, oral/written communication, interpersonal, analytical, and problem-solving skills.

Knowledge in health industry

AREA OF EXPERTISE

T-SQL

SSIS

SSRS

Data Warehousing (dimensional/data

vault)

Snowflakes

Power BI

DAX

Microsoft Excel

Matillion

Data modelling

Data Warehousing

API Interactions

PROFESSIONAL EXPERIENCE

Infogain/Leslies Pool-Mart Phoenix, AZ Oct/2019 – Present Senior Business Intelligence Engineer

Collaborated with cross-functional teams to gather and understand data integration requirements.

Integrated data from diverse sources, ensuring data quality and consistency throughout the pipeline.

Identified and resolved performance bottlenecks in Matillion ETL jobs and Data Vault models.

Migration of Data marts from 2008 SQL Server to Snowflakes

Building ETL pipelines using Matillion (cloud base) to load data into snowflakes

Developed ETL packages using SSIS to extract data from daily files across multiple Data source, transformed and consolidated.

Developed predictive analysis Power BI Dashboard based on weather driven data.

Created multiple stored procedures, functions and views to support data reporting and data load into our data Warehouse

Migration of SSRS Accounting Reports to Power BI to meet SOX compliance.

Migration and refactoring of SSRS reports into Power BI.

Help and streamline the process of loading data in our snowflakes Datawarehouse

Proven ability to work in an agile environment and meet project deadlines. Valore Partners Tempe, AZ Jan/ 2019 Oct/2019

Business Intelligence Consultant (Cable One & SRP) PAGE 2

Developed ETL packages using SSIS to extract data from daily files across multiple Data source, transformed and consolidated.

Developed multiple operational dashboards and reports using SSRS to gain actionable insights into client progress reports.

Created multiple stored procedures, functions and views to support data reporting and data load into data marts

Developed and maintained high profile decision support dashboards and reports using Power BI for billing and employee time tracking processes.

Writing complete DAX formula to support our Power BI Reports and cubes

Help and implement the process of loading data in our Datawarehouse Zion Compassion Care LLC Mesa, AZ 2015 – 2018

Business Intelligence Analyst

Developed ETL packages using SSIS to extract data from daily files across 10 group homes, transformed and consolidated into a data mart.

Developed multiple operational dashboards and reports using SSRS to gain actionable insights into client progress reports.

Created multiple stored procedures, functions and views to support data reporting and data load into data marts

Developed and maintained high profile decision support dashboards and reports using Power BI for billing and employee time tracking processes

Designed and delivered employee weekly work schedule reporting solution in Microsoft Excel

Developed and managed excel reports that reconcile employee actual hours with scheduled hours; Built visualizations that provides trends and outliers for further analysis

Create data models in Excel to consolidate data from multiple systems and create interactive reports using pivot tables and charts for employee time sheet reconciliation purposes

Performed root cause analysis using SQL to uncover underlying data issues in SSRS and Power BI reports General Electric Phoenix, AZ 2012 – 2014

Field Supervisor (Contractor)

Managed projects that involved recalled products across the country. This involved appointment scheduling and service technician repairs

Trained technicians on product installation, documentation and emergency repair procedures

Built process to manage product inventory. Delivered weekly reports on product inventory

Ensured timeliness of repairs for recalled products Bank of America. Charlton, MA 2007 – 2012

Credit/Financial Analyst

Analyzed credit and financial statements to determine the degree of risk involved in extending credit

Prepared reports that include the degree of risk involved in extending credit

Completed and submitted loan applications to loan committees for approval.

Consulted with credit association and other business representatives to exchange credit information EDUCATION

Data Analytics Certificate 2020, University of Arizona Phoenix, AZ Bachelor, Computer Science, 2012, Worcester State University Worcester, MA

Contact this candidate