Oluwakemi Oyefeso

Oluwakemi Oyefeso

$15/hr
Data Analyst
Reply rate:
100.0%
Availability:
Full-time (40 hrs/wk)
Location:
Lagos, Lagos, Nigeria
Experience:
15 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.