Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

Ben Mensah

Data Analyst
Round Lake,IL

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

21
21
years of professional experience
2
2
years of post-secondary education
1
1
Language

Work History

Data Analyst contractor

Freelancer
05.2016 - 12.2019
  • Providing expertise in data storage structures, data mining, and data cleansing
  • Translating numbers and facts to inform strategic business decisions
  • Analyzing sales figures, market research, logistics, or transport data
  • Creating and following processes to keep data confidential
  • Coming up with solutions to costly business problems
  • Converted data into actionable insights by predicting and modeling future outcomes
  • Utilize MS SQL, Tableau and Power BI for data intelligence and analysis
  • Researched and resolved issues regarding integrity of data flow into databases.
  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Developed tables, views and materialized views using SQL.
  • Produced monthly reports using advanced Excel spreadsheet functions.

Mathematics and Statistics Professor

College of Lake County
Grayslake, IL
01.2013 - Current
  • Teach transferable mathematics courses, online and in class, such as Statistics, Algebra, Finite Math, and Calculus
  • Tools used for Statistics: Evaluate measures of central tendency, measures of dispersion, measures of position, probability distributions, confidence intervals, hypothesis tests, and correlations with Excel spreadsheets, Python, R, SPSS, SAS and graphing calculators
  • Assess sampling methods and graphs
  • Differentiate between descriptive and inferential statistics
  • Calculate and interpret multiple linear and logistic model regressions
  • Analyze the basic concepts of probability
  • Describe a probability distribution and calculate probability values using postulates, rules of probability and various probability distribution tables
  • Assess hypotheses about the population parameters by using appropriate distributions and constructing confidence intervals about the mean, standard deviation, and proportion
  • Analyze distributions using ANOVA
  • Encouraged class discussions by building discussions into lessons, actively soliciting input, asking open-ended questions and using techniques to track student participation.
  • Graded quizzes, tests, homework and projects to provide students with timely academic progress information and feedback.

Analyst Store Care

Walgreens Co
Deerfield, IL
05.2017 - 06.2021
  • Manages the end-to-end deployment of store care programs (interior/exterior maintenance or energy programs) that are aligned with Company strategies, budgets, and expectations, among key stakeholders, including:
  • Individual and departments within the organization
  • Service providers, vendors, and/or contractors
  • Manufacturers and/or suppliers
  • Coordinating, and managing the activities, scheduling, planning, and program of the immediate staff within the guidelines of authorized Company policies, budgets, laws, and good business ethics
  • Used Tableau, Power BI, and SQL to track and analyze unit sales, profits, inventory, and “Brand” throughout the overall development and protection of store assets to boost revenue
  • Collaborating several streams simultaneously, on the successful implementations of a key projects, initiatives, or rollouts, etc
  • Reporting, forecasting and financial analysis
  • Reporting with advanced level skill in Microsoft Excel (for example: using AVERAGE function, merging, centering cells, printing centered page and/or creating a pivot table and VLOOKUP, XLOOKUP etc.)
  • Experience establishing and maintaining key relationships with internal (peers, business partners and leadership) and external (business community, clients, and vendors) within a matrix organization to ensure quality standards for service
  • Experience analyzing and reporting data to identify operational issues, trends, or exceptions to drive improvement of results
  • Resolved concerns with products or services to help with retention and drive sales.

Web-Service Support & Network Operator

Information Technology, Eastern Illinois University
Charleston, IL
01.2004 - 12.2007
  • Participated in research to improve and expand Eastern Illinois University (EIU) Web services and publishing home page links
  • Additionally, maintaining the database: Worked with PHP, SQL, HTML and XML to create modules for use on the synapse system
  • Assisted in maintaining system resources and support office moves and site technology
  • Support and maintenance of hardware, software, voice, and data network infrastructure at the direction of the core technology team and/or corporate IT
  • Moreover, supported the Disaster Recovery Plan as an active member of the Disaster Recovery Team.

Teaching Assistance Instructor

Eastern Illinois University
Charleston, Illinois
08.2005 - 07.2006
  • In Mathematics courses such as College Algebra, while tutoring statistics during summer sessions.

Education

Master of Science Degree - Data Analytics

Western Governor University
12.2019 - 12.2021

Master’s Degree - Mathematics and Statistics

Eastern Illinois University

Bachelor’s Degree - Mathematics and Computer Science

Eastern Illinois University

Associate Degree - Engineering Science

Lake Land College

Skills

Database management using queries with Structured Query Language (SQL), MySQL, MS SQL, Postgres Data Visualization: Tableau, Power BI, Excel, Matplotlib Knowledge and usage of open-source data science and statistics packages such as Python, R, SAS, SPSS etc Modeling: Logistic regressions, multiple linear regressions, decision trees Leadership Experience Fluent in French

undefined

Affiliations

National Dean’s list (Lake Land College) Member of Kappa Mu Epsilon and Honorary Mathematics Society 2

Timeline

Master of Science Degree - Data Analytics

Western Governor University
12.2019 - 12.2021

Analyst Store Care

Walgreens Co
05.2017 - 06.2021

Data Analyst contractor

Freelancer
05.2016 - 12.2019

Mathematics and Statistics Professor

College of Lake County
01.2013 - Current

Teaching Assistance Instructor

Eastern Illinois University
08.2005 - 07.2006

Web-Service Support & Network Operator

Information Technology, Eastern Illinois University
01.2004 - 12.2007

Master’s Degree - Mathematics and Statistics

Eastern Illinois University

Bachelor’s Degree - Mathematics and Computer Science

Eastern Illinois University

Associate Degree - Engineering Science

Lake Land College
Ben MensahData Analyst