Sql
Monday Oshoikpor
San Leandro,California
Summary
Highly organized and self-motivated professional experienced in project management, team development and process improvement. Skilled in developing and implementing strategies to increase efficiency and performance. Passionate about driving business growth and creating positive work environment.
Overview
15
15
years of professional experience
Work History
ASSOCIATE DIRECTOR, DEVELOPMENT OPERATIONS
Alameda Health System Foundation
07.2023 - Current
- Implemented PowerBI reporting, designing dashboards to accelerate operational processes, reducing task delivery timelines by 1 week
- Automated PowerBI dashboards for timely weekly reports, improving stakeholder communication and task deliveries
- Utilized SQL queries and Blackbaud query capabilities for rapid and accurate data retrieval, addressing over 1000 requests for mailing lists, reports, dashboards, and data analyses
- Maintained 99.9% data integrity and compliance, ensuring high standards of accuracy and reliability in reporting requisites
- Led 3 database clean-up projects, overseeing 500+ updates, contributing to enhanced data cleanliness and organization in data analytics.
SENIOR DATA ANALYST
MAAL Analytics – Freelance
01.2022 - 06.2023
- Helped an e-commerce start-up company attract new investors by building an OLAP Cube in SASS from MySQL Data, which attracted an additional investment of $2 million
- Wrote SQL queries in BigQuery to extract data, analyze company performance and monitor trends, which reduced the time spent on analysis by 1 hour per project on average
- Delivered new business insights to clients by managing projects and tables on the Google Cloud Platform (GCP) and using GCP data to create dashboards in Tableau, which led to 2 additional contracts.
DATA SCIENCE & ANALYTICS LEAD INSTRUCTOR
Thrive DX
03.2022 - 01.2023
- Taught various courses covering topics in data science, machine learning, and analytics for four different colleges and universities, where 95% of students passed the course
- Delivered a student-centered learning experience that prepared students for data careers, which resulted in performance reviews of 90%+ by students and mentor instructors
- Provided suggestions for improvement of the course materials that were used to update the curriculum and resulted in an increase in student satisfaction of 20% after implementation.
SAP FINANCE CONTROL (FICO) CONSULTANT
VRIT Labs, Inc.
08.2020 - 09.2021
- Identified clients’ financial status by comparing and analyzing actual results with plans and forecasts with 90%+ accuracy
- Studied proposed changes and provided a list of recommended actions for clients using the SAP FICO software to interpret data and conduct comparative analyses
- 80% of the recommendations our team provided were adopted by clients
- Developed a cost analysis process for the team that documented a standardized set of policies, procedures, processes, and techniques that reduced the onboarding time for new team members by an average of 2 days.
CEO/OWNER
Tonette-J Mart Limited
01.2009 - 01.2019
- Oversaw the daily operations of the business, including business development, purchasing, and marketing strategy, which generated an average revenue of $200,000 annually
- Onboarded and managed a team of 10 on average with a low turnover rate of one employee each year because of high employee satisfaction
- Implemented internal quality control policies and information systems to maintain a high degree of data integrity, which resulted in no financial or accounting errors in ten years of ownership.
ANALYTICS MANAGER
Xerox
01.2009 - 01.2016
- Monitored the team’s strategic, financial, and operational decisions to ensure projected business outcomes were achieved, which led to the Outstanding Business & Sales Strategist award for the year
- Used SPSS, Excel, and SQL to conduct focus group research on various products in the business unit and develop a new printers & scanners sales strategy, which resulted in an 8% increase in conversion, an increase in sales by 11%, and recognition as Employee of the Month
- Partnered with business leaders to analyze internal operational and financial metrics, including quick ratio, cash conversion cycle (CCC), and account receivable turnover with the goal of reducing costs
- The operational adjustments we recommended led to cost decreases of 17% in the following fiscal year.
Education
Data Science Immersive -
General Assembly
San Francisco, CA11.2021
Doctorate, Business Administration and Management -
Westcliff University
Irvine, CA06.2020
Master of Science, Operations Research -
University of Lagos
Lagos, Nigeria06.2014
Bachelor of Science, Actuarial Science -
University of Lagos
Lagos, Nigeria06.2009
Skills
- Microsoft SQL Server Management Studio, Microsoft Excel, Tableau, PowerPoint, Pandas, NumPy, SK-learn, Drawio, Microsoft Word, SPSS, Dbeaver, MySQL, Postgres, SQLite, Outlook, SharePoint, Asana, Blackbaud Raise Edge NXT, Raise Edge Database View
- SQL, Python
- Data Analysis, Data Cleaning, Data Mining, Data Visualization, Data Management, A/B testing, Qualitative & Quantitative Research, Market Research, Business Strategy, Requirement Gathering, Risk Analysis & Decision Making, Leadership, Change Management, Database Design, Data Quality
Portfolio Website
https://monday-oshoikpor-phd-data-analyst-consultant.square.site/
Projects
COVID-19 ANALYSIS IN TABLEAU, 09/2022, 10/2022, Conducted an Exploratory Data Analysis using SQL and Microsoft Server Management Studio to understand better COVID-19 infection rates by country, continent, and project future infection rates, which identified 3 new insights for the client., Trained the client on the data analysis process used to allow them to conduct it independently, which reduced the time spent on data analysis in-house by 2 hours a week on average., Developed a Tableau dashboard to present data that allowed the client to make several business decisions regarding traveling and selecting markets for future products, which resulted in 2 new engagements for the client. DATA CLEANING PROCESS DEVELOPMENT WITH SQL, 09/2022, 10/2022, Used SQL to clean datasets, identifying four new business opportunities for a start-up., Created queries and Views for efficient data cleaning in Excel, saving approximately 2 hours per project., Trained the client in Microsoft SQL Server Management Studio for data-cleaning processes, saving an estimated $70,000 on hiring a full-time data analyst. TRAFFIC ACCIDENT ANALYSIS TABLEAU PROJECT, 05/2022, 06/2022, Contracted to conduct an exploratory data analysis to identify connections between traffic accident count and various factors including environmental, time of day, and public works projects, that resulted in the identification of two new trends., Provided an analysis of accident counts in other states to allow the client to compare traffic accidents in their community with similar neighborhoods in other areas of the United States, which led to the addition of three new accident comparables that strengthened the client’s business pitch deck., Developed a Tableau dashboard to present trends and recommendations, which the client used to make four presentations to city municipalities and earned them one new contract to date.
Gym, Live Music,PickleBall
I'm a Gym ethusiates, love attending live music and festivals.I play pickleball
Software
Python
Powerbi
Tableau
Asana
Excel
Drawio
Mysql
Powerpoint
Sharepoint
Timeline
ASSOCIATE DIRECTOR, DEVELOPMENT OPERATIONS
Alameda Health System Foundation
07.2023 - Current
DATA SCIENCE & ANALYTICS LEAD INSTRUCTOR
Thrive DX
03.2022 - 01.2023
SENIOR DATA ANALYST
MAAL Analytics – Freelance
01.2022 - 06.2023
SAP FINANCE CONTROL (FICO) CONSULTANT
VRIT Labs, Inc.
08.2020 - 09.2021
CEO/OWNER
Tonette-J Mart Limited
01.2009 - 01.2019
ANALYTICS MANAGER
Xerox
01.2009 - 01.2016
Data Science Immersive -
General Assembly
Doctorate, Business Administration and Management -
Westcliff University
Master of Science, Operations Research -
University of Lagos
Bachelor of Science, Actuarial Science -
University of Lagos