Business Intelligence Data Analyst
Resume:
.
.
PROFILES
EDUCATION
Master of Arts
Economics
Central Michigan University, Mount
Pleasant, MI
Dec. 2020
Bachelor of Science
Mathematical Science (Statistics)
University for Developing Studies,
Tamale, Ghana.
May 2011
CERTIFICATIONS
SAS Certified
Specialist: Base
Programming Using
SAS 9.4 –
Issued Aug 2020. (No
Expiration)
Certified Tableau
Desktop Specialist:
Issued July 2023. (No
Expiration)
Atlanta Georgia, United
States 30135
ady0cf@r.postjobfree.com
SHADRACK BENN
SUMMARY
A professional business intelligence developer with over 7+ years of experience in SQL and BI reporting tools such as Tableau, SSRS, SSIS. Currently seeking growth-oriented opportunities in Business intelligence in industries like Manufacturing, Health, Education, Logistics, Retail, Technology etc. Enthusiastic team player, dedicated to streamlining processes and efficiently resolving project issues with experience and understanding of SDLC.
SKILLS
Advanced: SAS, SQL, SQL Server
Integration Services (SSIS).
Data Visualizations (Advanced):
Tableau, Excel, SQL Server
Reporting Services (SSRS), SAS.
Data Warehousing
ETL Developer
SDLC
Warehouse Management System
(WMS).
Shipping Connects.
EXPERIENCE
DATA ANALYST
Globadigm Consulting (Consultant) – Saginaw, Michigan April. 2023 – Present
• Utilizes SAS, and other software, to provide ad hoc reporting, tables and listings and graphs for clinical trial data, regulatory submissions, Risk-Based Monitoring, and publications.
• Utilizes data visualization tools, including Power BI and Tableau, to provide an easy-to-understand interface to end-users for quick identification of key themes within data.
• Demonstrates strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Developed and executed a data analysis solution for a financial services client that boosted customer retention.
• Per client requirement, I design and create reports using Excel file, SQL Server, and Oracle databases.
• Develops and produces peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
.
.
LEAD DATA & BUSINESS INTELLIGENCE ANALYST
KeyBank – Cleveland Ohio April 2022 – March 2023
• Sourcing, manipulation, preparation, and validation of data consumption.
• Queries and data mining to produce reports and score carding involving moderately complex descriptive analysis that provide answers to questions.
• Reoccurring reporting and analysis of more complex data.
• Source data for reports/dashboards based on understanding of business partners garnered by proactive communication and asking the right questions.
• Automate and standardize reports/dashboards for production.
• Translate data into consumable reports / business intelligence solutions and answer the “why” question.
• Develop performance analytics, scorecards, and dashboard of internal KPIs & metrics.
DATA ANALYST/ TABLEAU DEVELOPER/ DATA VISUALIZATION State Of Michigan Project- Remote Mt. Pleasant, MI Mar. 2021 – Feb. 2022
• Designing and developing dashboards using Tableau for various ROI metrics.
• Developed reports indicating KPIs (Sales, Revenue, Profit, etc.,) for decision making by management or stakeholders.
• Provided ad-hoc reports and analysis to support business needs.
• Mastered the ability to design and deploy rich graphic visualizations with drill down and drop-down menu option and parameters using SSRS and Tableau.
• Worked extensively with advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics, and table calculations.
• Utilized tableau server to publish and share reports with the business users.
• Developing BI reports with SSRS and Tableau to assist business make critical and strategic decisions.
BUSINESS INTELLIGENCE ANALYST
Code Analytics – Remote (Part time) Dallas, TX Jan 2019 - Feb 2021
• Developing various SSIS packages for ETL in accordance with business requirements.
• Integrating different internal and external source systems (SQL server, flat files, XML files etc.).
• Performing database validation by developing complex SQL / TSQL queries.
• Performing data validation, integration and E2E testing.
• Designing and developing organizational and departmental business intelligence
(BI), data warehousing and reporting solutions.
• Understanding the organization systems and identifying opportunities for efficient data management and data integration.
.
.
• Developed SSIS packages to load data from multiple sources to data warehouse.
• Produced Ad-hoc SSRS Dashboard based on user requirements.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
• Strong Experience in creating Ad Hoc, parameterized reports, linked reports, Snapshots, Drilldown and Drill through reports using SSRS. GRADUATE RESEARCH ASSISTANT
Central Michigan University Mount Pleasant, MI Jan 2019 – Nov. 2020
• Collected, analyzed, and presented visualized data research on Dual Enrollment in Michigan to professors and the director of the College of Education and Human Services which increased enrollment by 35%.
• Prepared tables, graphs, fact sheets and written reports summarizing research results on projects assigned to my team.
• Arranged and entered data into Excel for tracking and modeling purposes.
• Prepare and deliver lectures to undergraduate or graduate students on topics such as econometrics, statistics, and mathematics. CREDIT ANALYST
J.O Microfinance Ltd Kumasi, Ghana. Sept. 2012 - Nov 2018
• Built dashboards to visualize core business KPIs (e.g., Operating Expenses, Active/Dormant Clients) saving hours per week of
manual reporting by branch management.
• Prepared financial ratios and spreads using computer programs (Excel, etc.) to evaluate customer financial status to enhance productivity of credit officers by 40%.
• Conducted data analysis in CRM to prepare forecasts and identify trends of customer needs for credit to assist the branch marketing team increase sales/clients in a dormant market by 50% within 4 months.
• Analyze applicants' financial status, credit, and property evaluations to determine feasibility of granting loans.
• Obtain and compile copies of loan applicants' credit histories, corporate financial statements, and other financial information.
Contact this candidate