FREDERICK OKWAMPAH ANAAFI

USA+1-614-***-**** ad33vs@r.postjobfree.com linkedin.com/in/frederick-anaafi DATA ANALYST PROFESSIONAL SUMMARY

● Data Analyst with 10+ years of experience in performing data analysis, market analysis, and sales analysis in the gaming and lottery industry

● Successfully led a cross-functional sales team to onboard new clients resulting in monthly revenue growth of GHS 13,000+ and quarterly profitability boost of up to 7%.

● Proficient in Microsoft Excel, Power BI, and SQL for data analysis, visualization, and reporting.

● Seeks to leverage expertise in data analysis, business intelligence, and strategic decision-making to drive company growth and optimize performance.

SKILLS

Technical skills: PowerPivot, PowerQuery, PowerBI, Data Visualization, Database Management, Sales Analysis Sales Forecasting, Budgeting, Project Management

Software skills: Microsoft Office Suite (Excel, Word and PowerPoint, Sway, Teams), Tableau, R, SQL. WORK EXPERIENCE

Head of Business Development & Business Analyst, National Lottery Authority, Ghana. Apr 2022 – Present

● Drives a cross-functional sales team of 30 to prospect and onboard at least 4 new clients monthly through P2P marketing, resulting in monthly revenue of GHS13,000+ and quarterly profitability boost of up to 7%.

● Leads quarterly coaching sessions for 3 departments on data analysis and presentation efficiency using essential Microsoft Excel tools. Reduced report submission time by 28 days.

● Liaised with the Director of Strategic Business Improvement to develop and secure board approval for a market penetration strategy. Market size and revenue improved by 15% and 8% respectively in 2 weeks.

● Oversees new market initiatives by collaborating with 3 departments to increase brand awareness and revenue by 5% by implementing various sales strategies.

● Develop Power BI and Excel reports and models to deliver strategic insights to the Business Development Manager and top management, meeting reporting deadlines and addressing daily business questions.

● Facilitated and collaborated with a team of 4 individuals to streamline the Strategic Business Improvement department's budget preparation sessions, resulting in the achievement of the yearly revenue target of GHS 2M.

● Collaborated with 10+ member budget Team weekly to create a 15-page strategic guide outlining strategies to meet and effectively manage a GHS 250M budget and expenditures for the year 2022.

● Supervises the Draw Team and chairs the weekly Lotto Draw process for 5000+ point of sales terminals, and mobile phone transactions for sales Revenue worth GHS1M+. Certified Microsoft Trainer, Fredexcel Consult, In-person and Remote. Jan 2015 – Present

● Onboards up to 4 corporate and 30+ individual clients by working with a cross-functional team of 5 to present sales proposals to up to 20 prospective clients yearly. Up to GHS50,000 revenue generated annually.

● Partners with the team to organize an annual hybrid training session for up to 50 new graduates on the efficient use of Powerpoint, Excel and Word at the workplace. Trainees averaged 90% in a post training assessment. National Sales Manager & Business Sales Analyst, National Lottery Authority, Ghana. May 2019 – Mar 2022

● Spearheaded an annual sales revenue portfolio of GHS360M reaching 10+ million tickets purchased weekly across 7,000 point of sales terminals.

● Supervise 16 regional managers to manage 8+ sales reps each to deliver average monthly sales of GHS30M by communicating weekly with lotto marketing companies operating 4500+ daily point of sales terminals.

● Liaised with sales managers to develop annual regional sales budget worth GHS 380M utilizing a customized Excel template with DAX Functions and PowerPivot to collate monthly sales data of 100+ sales executives.

● Revamped the monitoring and evaluation process after a TSP shutdown, for the deployment of 2000+ point of sales terminals across 16 markets using a custom-made Excel tracker. 80% of business revenue was saved.

● Increased revenue by 15% and attracted 500+ new retailers by working with 2 Technical Service Providers to introduce instant payments for easier ticket liquidation.

● Slashed reporting time by 80% by developing 5 sales templates to capture all retailer activities and performed predictive analysis on daily sales metrics with Pivot tables.

● Automated data reporting with an ETL process by creating an Excel data pipeline to analyze 1M rows of sales data with Power Query and Power BI enhancing visibility of key performance indicators by 65%.

● Boosted quarterly retailer base by 200 and maintained an existing base of 5,800 by organizing sales workshops for 100 team members on recruitment and retention in collaboration with 4 department heads.

● Supported the marketing department to develop and execute a thorough launch plan to create marketing materials, train sales teams, and coordinate with retailers. This upped product launch success rate by 5%.

● Boosted regional sales by 3.5% by reviewing monthly reports and providing coaching to regional sales managers on customer relationship management and building a strong clientele base.

● Built an in-house digitized database profiling 2,000+ retailers used to offer tailored advice on revenue generation and succession planning, leading to a 3% increase in retailer customer satisfaction. Southern Sector Manager & Sales Business Analyst, National Lottery Authority,Ghana. Aug 2013 – Apr 2019

● Executed 10 regional visits annually to train 9 regional/district managers on customer experience and data analysis using MS Excel essentials leading to a 5% revenue increase for regional/district managers.

● Worked with 15 sales managers to prepare annual sales targets of up to GHS 380M using a custom-made Excel template, PowerPivot and Power Query communicating targets to each market within ~3 months.

● Partnered with the ICT department to conduct quarterly maintenance of ~6,000 point of sales terminals across 10 markets, improving turnaround time(TAT) by up to 10% and saving GHS 18M in repairs.

● Teamed up with 80+ regional sales team members to introduce 1500 point of sales terminals within 5 months across 10 markets, generating revenue of GHS 75M.

● Coordinated with 2 HR team members to prepare Annual Target Performance Assessment and Appraisals in Excel to measure performance and determine bonuses and promotions for 10 regional/district managers.

● Coached 5 Regional and 4 District Managers to recruit new retailers in order to generate 68% of the total yearly sales revenue.

● Conducted 4+ field retailer visits monthly to gather insights on challenges and facilitate prompt resolution, improving retailer loyalty and commitment.

Corporate Sales Analyst, National Lottery Authority, Ghana. Apr 2011 – Jul 2013

● Facilitated decision-making by performing sales data and market trend analysis, for access to top market revenue generators and each market's contribution, resulting in an 86% achievement of sales forecast.

● Generated GHS32M in revenue within 3 months by designing a custom Excel template in 3 days, compiling data from 2,000+ point of sales terminals and retailer details nationwide.

● Managed the Retailer Register using Excel and Power Query for proper capture of retailer information and point of sales terminal location for easy data tracking and prevent incorrect sales commission payments.

● Prepared an annual strategic plan for 15 regional/district markets and supported the formulation of GHS380M budget by using Excel, Pivot tables, and conditional formatting to gather vital market information.

● Leveraged Power Pivot and Power Query to create detailed and informative monthly sales performance reports, resulting in a 20% increase in sales efficiency.

● Led the implementation of the Annual Sales Conference for 85 Sales Executives across 55 zones to obtain field updates, brainstorm business improvement solutions and communicate needs to business owners.

● Successfully organized quarterly off-site sales conferences for 15 regional and district sales managers, and Department directors to discuss business challenges and improvement solutions.

● Communicated high-level sales updates to participants through delivering insights on key performance indicators and management expectations for sales staff via Powerpoint presentations.

● Improved visibility of key revenue drivers by designing weekly and monthly custom sales dashboard for Sales Executives to record and graphically present daily and weekly sales per point of sales terminal. SPEAKING ENGAGEMENTS

Attendee, UK D365 and Power Platform User Group, London, UK Jun 2023 Attendee, Microsoft New Speakers Community Day, Manchester, UK May 2023 Volunteer Organiser, Global Power Platform Bootcamp, Washington DC, USA. Apr 2023 RESEARCH WORK

Macroeconomic Volatility and Foreign Direct Investment (FDI) in Ghana May 2014 Management of Investment Portfolio of Insurance Company – Using Modern Portfolio Theory May 2010

EDUCATION

The Power BI Dashboard & Data Course Excel Campus Nov 2018 – Dec 2018 Power BI A-Z SuperData Science Jan 2018 – Jun 2018 Certified Business Analysis Professional(CBAP) Simplilearn Apr 2017 – Jun 2017 Data Visualization and Communication with Tableau Coursera Sep 2016 – Nov 2016

Business Metrics for Data-Driven Companies Coursera Aug 2016 – Oct 2016 MBA Finance University of Ghana, Accra, Ghana. Aug 2012 – Jun 2014 MSC Industrial Mathematics Kwame Nkrumah University of Science and Technology, Kumasi, Ghana.

Jul 2008 – Jun 2010

BSC Mathematics Kwame Nkrumah University of Science and Technology, Kumasi, Ghana. Sep 2001 – May 2005 LICENCES/CERTIFICATIONS

Microsoft Certified-Power BI Data Analyst Associate Jan 2023 – Present CompTia Security+ Jan 2023 – Jan 2026

CompTia Data+ Nov 2022 – Nov 2025

Logical Operations Modern Classroom Certified Trainer(MCCT) Apr 2022 – May 2025 Microsoft Certified Trainer May 2023 – May 2024

Microsoft Certified Trainer May 2022 – May 2023

Power Platform Fundamentals Jan 2023

Security Compliance and Identity Fundamentals Dec 2022 Microsoft Certified Azure Data Fundamentals Oct 2022 Microsoft Certified Trainer May 2021 – May 2022

Microsoft Powerpoint Expert(Microsoft 365 Apps & Office 2019) July 2021 Microsoft Excel Expert(Microsoft 365 Apps & Office 2019) May 2021 Microsoft Excel Expert(Office 2016) Apr 2021

Contact this candidate