Data Analyst Business Intelligence

MARIE-THERESE YAMEOGO

Mansfield, MA ***** 347-***-**** **********@*****.***

GitHub: https://github.com/Maitezagre Tableau: https://public.tableau.com/app/profile/marie.therese.yameogo

EDUCATION

Master of Science in Computer Science, Monroe University, Bronx NY, August 2020

GPA: 3.97/4.0

Master’s in Business Administration & Finance, Monroe University, Bronx NY, 2017

GPA: 4.0/4.0

Bachelor of Business Administration & Management, Monroe University, Bronx NY, 2014

GPA: 4.0/4.0

Associate of Occupational Studies, Business Administration-Accounting, ASA College, New York NY, 2013

CERTIFICATION

Tableau for Data Visualization- - Udemy

Microsoft Power BI Desktop for Business Intelligence - Udemy

SQL Certificate- Udemy

EXPERIENCE

Freelance Data Analyst- Remote (April 2023 – Present)

Pharmaceutical Sales Analysis – Power BI Project

Designed an interactive executive dashboard analyzing $11.8B in pharmaceutical sales across channels, cities, and product classes.

Built visualizations including year-over-year trends, sub-channel revenue breakdowns, and geographic sales concentration.

Used Power BI slicers, DAX, and Power Query to clean and model sales data, allowing dynamic user-driven analysis.

Delivered actionable insights on top-performing products, sub-channels, and market trends over a 4-year span.

Data/Financial Analyst

Lead a freelance project focused on financial data analysis for a client in the finance sector

Designed and developed interactive dashboards in Power BI to provide actionable insights into cash flow performance

Cleaned, transformed, and modeled large datasets using Power Query and DAX to support decision-making

Collaborated with stakeholders to define key performance indicators (KPIs) and deliver reports that meet business requirements.

OCD Tech, LLC – Braintree, MA (August 2022- March 2023)

Data Analyst

Subject Matter Expert in Tableau in charge of creating and analyzing dashboards for client

Maintained, enhanced, and built reports and dashboards that connect insights to business impacts

Proposed actionable strategies to client through prepared presentations using storytelling and data visualization to secure its data and avoid external threats

Conducted and maintained accurate inventory of all IT resources to assure data quality and integrity

Responsible for managing databases in Pre IT & Pro IT Asset Management environment

Helped drive decision-making by ensuring data are functional and up-to-date

Extracted, manipulated, and transformed raw data from internal sources to build data visualization using software such as SQL and Tableau

Cleaned, transformed, and connected SQL queries to Tableau for database completeness check

Refreshed and sent weekly Tableau reports to Mexico team

Garan, Inc – New York, NY (February 2022 – August 2022)

Planning/Finance Assistant

Maintained and run financial data using department’s Excel database as needed

Updated and distributed reports for sales, inventory, and margin performance

Spearhead tedious tasks that include item creation, item maintenance, and data cleaning in corporate systems through Simparel and Retail Link

Analyzed daily sales for Boys and Girls Department to provide actionable data/insights

Monroe University - Bronx, NY (June 2015 – March 2020)

Student Loan Consultant

Analyzed a minimum of 120 student loan records monthly using Borrower Connect

Managed and processed consolidation for all defaulted loan accounts

Performed financial literacy counseling and assisted in addressing payment challenges

Advocated on behalf of borrower for manageable payment plans with Federal Loan Service Providers and Collection Agencies

Researched student’s indebtedness and loan portfolio by accessing the National Student Loan Data System and other databases of the Federal Department of Education

DATA ANALYST FREELANCER PROJECTS

Hotel Revenue Data Cleaning & Analysis (June 2022 – July 2022)

Combined tables into one unified dataset using Union Function

Calculated and rounded Hotel revenue to analyze revenue growth

Merged tables by column using Left Join Function

Connected Power BI to SQL Database and visualized Data to find out if hotel revenue is growing by year

Financial Institution Data Calculation (March 2022)

Created reports to compute Loan Sum, Average Current Balance, Maximum Current Balance, and Minimum Current Balance by lender institution type

Nashville Housing Data Cleaning (January 2022 – February 2022)

Standardized date format

Populated Property Address Data & divided Address into individual column

Removed duplicates and deleted unused columns

Reorganized data into intelligible and coherent categories to benefit external readers

Covid-19 Data Analysis & Visualization (September 2021 – October 2021)

Created a database in SQL to analyze Covid19 data based on covid deaths and covid vaccinations over the world

Used joins, Temp tables, aggregate functions, data types conversion, and created views to explore the global data on confirmed covid19 deaths

Built a dashboard in Tableau by reporting my findings regarding the covid-19 exploratory analysis

Student Aid Data Cleaning (June 2021 – July 2021)

Created a new table to store the cleansed data

Identified “uncleaned” records from Original Data using ISNUMERIC Function

Filtered out “uncleaned” rows and records

Uploaded newly cleansed data into newly created table

TECHNICAL SKILLS:

Programming Languages: SQL, R, Python (Jupyter Notebook, Pandas)

Databases: MySQL

Data Visualization: Tableau, Power BI, Alteryx

Tools: Power Query, Excel (Vlookup/Xlookup, Sumif, Pivot Table), Word, Power Point, ServiceNow, Snowflake

CORE COMPETENCIES: Data Visualization, Data Cleaning, Business Intelligence, Data Mining, Financial Analysis, Asset Management, ETL

ORGANIZATIONS:

Girls in Tech

NABA (National Association of Black Accountants)

Contact this candidate