Kola Ademola

KOLA ADEMOLA DATA ANALYST | ANALYTICS ENGINEER | BUSINESS INTELLIGENCE ANALYST -| - | linkedin.com/in/kolaademola | https://kola-ademola.github.io SKILLS DATABASE, SOFTWARES & PROGRAMMING: dbt, Snowflake, Python, MS Excel, R, Git, MySQL, MS-SQL, BigQuery, PostgreSQL, Googling VISUALIZATIONS/BI TOOLS: Power BI, Tableau, Looker DATA SCIENCE: Data Modelling & Transformation, Analytics Engineer, Data Visualization, Business Intelligence, Financial Analysis, Advanced Excel. SOFT SKILLS: Problem solver, Critical thinking, Analytical thinking, Fast Learner, Attentive listener, Team Player EXPERIENCE BUSINESS INTELLIGENCE ANALYST, Business Analytics Consultancy Jamaica, Remote | 10/2024 • • • Working closely with Lead Analyst & Data Scientist to understand the business objectives and translate them into actionable insights. Automated Financial reports in Power BI with power data transformation and data model which reduced dashboard creation, data cleaning and reporting time by 60%. Analyzed and visualized financial data/statements with Power BI to show important KPI’s for Income Statement, Balance Sheet and Cash Flow statements and DCF models which helps stakeholders make informed business decision 45% faster and efficiently. DATA/DIGITAL MARKETING ANALYST, Smart Digital Data US, Remote | 07/2024 • • • Conducted thorough data cleaning procedures in Google Sheets on digital marketing and web traffic data from GA4, including date transformation, removing duplicates, missing values, and outliers, resulting in a 65% increase in data completeness and validity before analysis. Utilized efficient data wrangling techniques to transform web traffic and digital marketing data from different channels into a clean and structured format, resulting in a 75% reduction in data processing/transformation time. Analyzed and visualized web traffic and marketing data from GA4 with Looker studio to show important KPI’s and data points which helps stakeholders make informed business decision 25% faster and efficiently. DATA/BUSINESS ANALYTICS INSTRUCTOR, 10Alytics Canada, Remote | 10/2024 • • • Designed, led and instructed data/business analytics courses (Excel, SQL & Power BI) for numerous students, achieving a 100% course completion rate. Developed hands-on projects and real-world datasets, resulting in a 40% increase in student engagement and satisfaction. Conducted tailored assessments, leading to an average 30% improvement in students' data analysis skills and performance. DATA ANALYTICS INSTRUCTOR, SpitalLabs, Nigeria | 05/2023 • • • Designed, led and instructed data analytics courses (Excel, SQL, Power BI, Tableau & Python) for numerous students, achieving at least 80% course completion rate. Revamped the curriculum, incorporating hands-on projects and real-world datasets, resulting in a 65% increase in student engagement and satisfaction. Monitored student progress and conducted assessments, leading to an average 20% improvement in students' data analysis skills and performance. DATA ANALYST, SANICLE.US US, Remote| 06/2023 – 11/2023 • • • Conducted thorough data cleaning procedures in Microsoft Excel on sales data, including removing duplicates, missing values, and outliers, resulting in a 20% increase in data completeness. Utilized efficient data wrangling techniques to transform sales data from different channels into a clean and structured format, resulting in a 50% reduction in data processing time. Analyzed and visualized sales data with Power BI to show important KPI’s and data points which helps stakeholders make informed business decision 15% faster and efficiently. Sales Data Analyst, Xpress Superstore, Nigeria | 11/2019 – 02/2021 • • • Collaborated with a Database Admin using SQL to optimize inventory management, resulting in a 30% increase in sales and a reduction in overstocking. Developed impactful charts and automated reports using Microsoft Power BI, providing actionable insights on sales trends, inventory levels, and product performance to inform data-driven decisions. Streamlined inventory ordering process to ensure all items were stocked at the right quantity, eliminating issues with out-of-stock and overstocked items and improving the store's profitability. OTHER PROJECTS: In my portfolio I show case experience and proficiency in a variety of other analytics tools like; • Tableau: Experience in data modeling and utilizing LOD expressions to analyze data at different levels of granularity. • MS Excel: Skilled in using VLOOKUP, XLOOKUP, and pivot tables to analyze large datasets and create comprehensive dashboards. • SQL: Proficient in optimizing queries using CTEs, joins, and window functions to extract data from relational databases. • Dbt: Proficient in dbt for ELT tasks. I know how to build models from the “staging” level to “data_marts” models while applying the necessary transformations and data quality checks. • Data Warehousing: Proficient with tools like BigQuery, GCP and Snowflake. • Git: Experience in version control and collaborating with team members to manage code changes. Link to my portfolio: https://kola-ademola.github.io EDUCATION BACHELOR OF SCIENCE(BSc) in Statistics University of Cross River | Calabar, Nigeria CERTIFICATIONS GOOGLE DATA ANALYTICS CERTIFICATE, UDACITY NANODEGREE PROGRAM ALX-T DATA ANALYST INTEREST Games, Anime, Football, Music, Food.