Oluwakemi
Oyefeso
PROFILE
I am a skilled virtual assistant with over 15 years of experience in
administration, data collection, and processing. I have worked for
top-level executives and helped them make informed decisions about cost
analysis, consumer behavior, and client behavior, among other things. As
a self-motivated and disciplined professional, I bring a wealth of
knowledge to the field of data analysis.
With over 3 years of experience managing WordPress websites, On-Page
SEO, and Inbound marketing, I have developed a keen eye for detail and a
creative approach to problem-solving. My organizational skills have been
honed from years of serving as a virtual assistant, making me a perfect
candidate for managing and analyzing data.
Driven and autonomous, I am exceptionally flexible and efficiently
manage time and tasks. I am eager to transition into an entry-level data
analyst role and am confident that my extensive administrative
background, commitment to excellence and acquired technical skills will
enable me to excel in my new role.
If you are looking for an analytical thinker with experience in
administration, virtual assistance, and technical knowledge, I am the
ideal candidate for your team.
Phone: -
Address: Block 10 Plot 13
Gbolahan Bakare Street,
Magodo GRA Phase 1, Isheri,
Lagos 100214 Nigeria
email-
SKILLS
Software & Tools:
●
Familiarity with Microsoft SQL, PowerBI, Tableau, and Python for
data analysis and visualization
●
Proficient in Excel and Google Suite
●
Skilled in HubSpot, Trello, Monday.com, and Zoom
Marketing & Content:
●
Experienced in Yoast and On-page SEO, social media
management, customer service, and support
●
Proficient in inbound marketing techniques, content writing,
blogging, video conferencing, and email marketing tools such as
MailChimp
●
Skilled in Canva for graphic design
Website Management:
●
Skilled in WordPress and WooCommerce website creation and
management
●
Proficient in file and inventory management, light bookkeeping,
form building, and appointment scheduling
Team Management:
●
Experienced in community management and project
management
●
Proficient in team management, Slack, and the Superhuman
email tool
Soft Skills:
●
Organized, attentive to details, and efficient individual with
strong work ethics
●
Enthusiastic about helping others, confident, and empathetic
●
Research-minded, tech-savvy, analytical, and resilient individual
●
Sociable, a team player, and adaptable to different environments
●
Effective communication skills, versatile, able to multitask, and
have a positive attitude
●
Always ready to learn and teach, self-motivated, and takes
responsibility
●
Conflict resolution and community management skills
Industry Experience:
●
E-commerce, with experience in managing online stores and
driving sales
●
Financial services, with expertise in financial analysis and
reporting
●
Health & Fitness, with knowledge in personal training and
nutrition
●
Education, with experience in curriculum development and
teaching
●
Fashion & Beauty, with in-depth understanding of the latest
trends and styles
●
Retail & Consumer Goods.
WORK EXPERIENCE
Data Analyst | Project Experience
●
Utilized MySQL for data cleaning, creation of tables, joins, unions, aliases, temp tables, data modifications,
queries & subqueries.
Exercises can be found at https://github.com/OluwakemiO/MYSQL
Project 1: Conducted data exploration (https://github.com/OluwakemiO/DataExplorationProject)
Project 2: Completed data cleaning using SQL (https://github.com/OluwakemiO/NashvilleHousingProject)
●
Advanced use of formulas in Excel, data cleaning, generating pivot tables, and charts. Experience with
creating data visualizations and dashboards with Excel.
Project 1: Implemented data cleaning, data visualization, and dashboard creation in Excel
(https://github.com/OluwakemiO/Byke-Sale-Project-Excel)
Project 2: Conducted data analysis, data visualization, and dashboard creation with Excel
(https://1drv.ms/x/s!AvAD4GQYgJMkijr_wjWjHNaD0O6K?e=J0IfCM)
Project 3: Developed and utilized multiple use cases for Excel formulas
(https://github.com/OluwakemiO/Excel-Formulas-Project)
Project 4: Conducted data cleaning using Excel, including removal of duplicates, filtering data, sorting
data, and organizing data. See project at https://github.com/OluwakemiO/Data-Cleaning-In-Excel.
●
Use of Tableau for creating visualizations, calculated fields, bins, and joins.
See Tableau projects at https://public.tableau.com/app/profile/oluwakemi.oyefeso.
●
Proficient use of Power BI for data analysis. Power Query and managing relationships, DAX functions,
drill-down, conditional formatting, bins and lists.
Project 1: Data visualization using stacked and clustered column charts :
(https://github.com/OluwakemiO/Project1-PowerBIViz)
Project 2: Creating DAX functions create calculated fields using COUNT and SUM, SUMx, WEEKDAY and IF
formulas: (https://github.com/OluwakemiO/DAX-Functions-Project)
●
Familiar with Python variables, data types, comparison, logical and membership operators in Python, IF
ELSE, FOR Loop, and While Loops statements, Functions, and converting data types.
●
Understanding of categorical variables, visualization techniques, mean, median, and mode, numerical
variables, frequency distributions, cross tables and scatter plots, skewness, variance, standard deviation,
covariance, and correlation in Statistics..
Exercises can be found at : https://github.com/OluwakemiO/Statistics-Projects
Sales & Business Administration Executive |Kesabeso Enterprises: E-commerce Business
July 2020 - Present
●
Generated leads and managed CRM.
●
Managed social media accounts.
●
Sourced products and liaised with suppliers and logistics partners.
●
Conducted product pricing and branding.
●
Maintained stocktaking and inventory control.
●
Provided customer service by resolving queries, disputes, and tickets.
●
Managed email marketing and blogging.
●
Maintained website by updating product images, descriptions, and quantity.
●
Ensured proper store display to drive sales.
●
Facilitated staff employment and training.
●
Represented the company at trade shows and events.
Customer Service Manager | UP IN THE AIR LIFE: Travel Agency
February 2022 - March 2022 (20-30 hours per week)
●
Managed customer relationships, resolving queries, disputes, and tickets.
●
Managed email and phone inquiries, making calls and sending text messages.
●
Scheduled meetings and kept records.
●
Managed workflows and collaborated with the team.
Medical Virtual Assistant | Ayinke Maternity Hospital
June 2019 - July 2020 (Virtual and Part-time)
●
Communicated with patients and maintained patient/doctor relationships.
●
Conducted calls, text messages, and emails.
●
Scheduled meetings, antenatal, and postnatal appointments.
●
Kept and updated records.
●
Conducted accounting and billing.
●
Supported medical personnel.
Accounts & Administrative Officer | ANS Energy Services: Upstream Oil & Gas Consulting Firm
August 2018 - July 2020
●
Provided virtual administrative and accounts support.
●
Utilized Sage 50 Cloud Accounting Software.
●
Managed transactions and bank account reconciliations.
●
Maintained electronic and paper filing systems.
●
Coordinated logistics, such as travel plans, hotel, and car rentals.
●
Conducted data entry into accounting software.
●
Generated P&L statements and balance sheets on Sage 50 Accounting Software.
●
Maintained efficient office operations.
●
Prepared and submitted PAYE and VAT returns.
●
Prepared financial reports for accurate decision-making.
Finance Administrative Manager | MANOR CONCESSIONS LTD.: Financial Services Firm
April 2006 - July 2018
●
Provided virtual administrative assistance and accounts support.
●
Utilized Microsoft Excel spreadsheets.
●
Designed project-specific spreadsheets and graphics to display the company's gross and net profit.
●
Conducted bank and transaction reconciliations.
●
Tracked petty cash receipts.
●
Prepared monthly and quarterly ledger closures and financial statements.
●
Generated graphical presentations and reports to aid the chief executive in decision-making.
●
Supervised staff members.
●
Coordinated efficient accounts payable and receivable operations.
School Administrator | BEDROCK PRIVATE SCHOOL: Elementary School
December 1999 - November 2006
●
Conducted administrative responsibilities, including staff development and training, advertising,
recordkeeping, and budgeting and annual financial reports.
●
Managed school operations and filled in for teachers to deliver lessons when absent.
●
Complied with educational standards and directives as stated by the government monitoring board.
●
Conducted continuous assessment of the effectiveness of the curriculum and teaching methods.
●
Liaised with parents concerning the welfare of their ward and with the Ministry of Education.
System Analyst | MARINDUS GROUP: Upstream Oil & Gas Consulting Firm
December 1997 - November 1999
●
Executed complex migrations, upgrades, installations, and configurations.
●
Conducted staff training on the use of computers and programs.
●
Tested, maintained, and monitored computer programs and systems.
●
Troubleshot and resolved problems encountered by individual users.
●
Maintained programs and hardware systems.
●
Provided support to business stakeholders on critical business applications.
●
Frequently communicated with end-users of oil spill equipment about incidents and problems.
EDUCATION
Bachelor of Science, Computer Science Dec 1997 University of Ilorin
1993 - 1998
(Ilorin, Kwara, Nigeria)
(Graduated with second-class honors)
CERTIFICATIONS
DIPLOMA IN DATA PROCESSING & DESIGN| THE UNIVERSITY OF LAGOS
-
ACCOUNTING TECHNICIAN CERTIFICATE I & II | ICAN
Mar.1993 & Mar 1994.
CERTIFICATE IN COMPUTER GRAPHICS | NIIT
May 2006
CERTIFIED SYSTEM ENGINEER | NIIT
Jan. 2006
WRITING CUSTOMER SERVICE EMAILS | LINKEDIN
NOV. 2021
DE-ESCALATING CONVERSATIONS FOR CUSTOMER SERVICE | LINKEDIN
NOV.2021
LEARNING HUBSPOT CRM | LINKEDIN
NOV.2021
CUSTOMER SERVICE FOUNDATIONS | LINKEDIN
NOV.2021
CUSTOMER SERVICE: PROBLEM-SOLVING AND TROUBLESHOOTING | LINKEDIN
NOV.2021
INBOUND CERTIFIED | HUBSPOT ACADEMY
DEC 2021
INBOUND SALES CERTIFIED | HUBSPOT ACADEMY
DEC 2021
POWER BI: DASHBOARDS FOR BEGINNERS|LINKEDIN
APRIL 2023
BUILDING A CREATIVE ONLINE COMMUNITY|LINKEDIN
APRIL 2023
WORKING FROM HOME: STRATEGIES FOR SUCCESS|LINKEDIN
APRIL 2023
INTRODUCTION TO CAREER SKILLS IN DATA ANALYTICS
APRIL 2023
DATA VISUALIZATION: STORYTELLING
MARCH 2023
VOLUNTEER WORK
AT MY ALMA MATER: MAYFLOWER SCHOOL, IKENNE, OGUN STATE.
MY PURPOSE IS TO HELP MY ALMA MATER GROW AND DEVELOP BY GIVING BACK FINANCIALLY. AND
SPONSORING PROGRAMS AND PROJECTS THAT AFFECT YOUNG STUDENTS' LIVES AND ACADEMICS.
POSITIONS HELD IN THE ALUMNI:
CHAIRPERSON (84/90 SET) | MAYFLOWER OLD STUDENTS ASSOCIATION, IKENNE: May 2011 - January 2015
SOCIAL SECRETARY
| MAYFLOWER OLD STUDENTS ASSOCIATION, IKENNE: January 2015 - January 2017
VICE PRESIDENT 1
| MAYFLOWER OLD STUDENTS ASSOCIATION, IKENNE: January 2019 - January,2023