Oluwaferanmi Amole

Oluwaferanmi Amole

$10/hr
Power BI Developer/Data Analyst
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Ikeja, Lagos, Nigeria
Experience:
3 years
OLUWAFERANMI AMOLE Mobile: - Email:-LinkedIn: https://www.linkedin.com/in/oluwaferanmi-amole/ Medium: https://medium.com/@Feranmi_Amole PROFESSIONAL SUMMARY A data analyst with 2+ years of experience working in the IT space. Hands-on experience in using various analytical tools to effectively convey complicated findings to a wide range of stakeholders, also creating user-friendly documentation and technical content that provides step-by-step processes involved in different projects to diverse audiences. PROFESSIONAL EXPERIENCE​ Hillfield Interactive, Lagos, Nigeria, ​ Data Analyst (Remote) ​ ​ June 2024 - Present ●​ Created detailed reports and dashboards with Looker to enable stakeholders to make informed decisions. ●​ Migrated Power BI reports to Looker due to change in the environment of the organization. ●​ Collaborated with stakeholders to define and document requirements for Looker dashboards, ensuring alignment with business objectives and creating comprehensive technical specifications. ●​ Created action filters, and custom fields using LookML to enhance the interactivity and functionality of Looker dashboards. ●​ Wrote and documented complex SQL queries on large datasets using Google BigQuery for backend data validation and frontend reporting providing clear explanations of data transformations and logic. ●​ Conducted data mapping and transformation using Google BigQuery to ensure data consistency and accuracy in Looker. ●​ Created data dictionaries and data lineage documentation to provide clarity on dataset definitions, transformations, and business rules. ●​ Developed and maintained ELT pipelines using dbt (data build tool) and Google BigQuery for data processing and transformation. ●​ Managed project tasks and code repositories using Azure DevOps, documenting development processes and version control practices to ensure efficient collaboration. ​ Babcock University, Ogun, Nigeria,​ ​ ​ November 2023 - October 2024 General Education Studies Department (IT Support) National Youth Service Corps (NYSC) ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ●​ Prepared the computer laboratories with the necessary hardware and software for the tests and examinations to take place. ●​ Assisted students in resolving computer-related issues such as hardware malfunctions, software problems, and login issues during computer-based examinations and tests ●​ Provided students with precise instructions on how to take the exam and what to do in case of any problems. Hillfield Interactive, Lagos, Nigeria, ​ Power BI Developer/BI Analyst ​ ​ December 2023 - May 2024 ●​ Developed comprehensive reports and dashboards using Power BI, enabling stakeholders to make informed decisions. ●​ Worked on the design, development, and analysis of requirements for Power BI reports. ●​ Created parameters and action filters to prepare Power BI dashboards. ●​ Wrote SQL queries on big datasets for frontend report validation. ●​ Did data mapping through Oracle DataBase to match the data in the Power BI schema. ●​ Used advanced Excel functions and pivot tables to analyze and visualize large datasets, providing key insights to stakeholders. ●​ Created ETL models with dataflows and Oracle DB for the development of semantic models in Power BI Service. ●​ Set up the Power BI environment, create app workspaces, and publish apps. ●​ Built an app in the Power BI service workspace to combine multiple reports. ●​ Utilized Python for data cleaning, preprocessing, and statistical analysis. ●​ Made use of Jira to monitor and give feedback on tasks assigned. Bredge, Lagos, Nigeria​ ​ ​ ​ ​ June 2023 - December 2023 Graduate Intern (Remote Data Analyst)​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ●​ Designed effective layouts and visually appealing reports with Power BI ●​ Updated pre-built dashboards and reports to make them look more appealing and make it easier to make informed decisions using Power BI. ●​ Exported calculated columns and measures from a Power BI report using DAX Studio. ●​ Implemented data governance measures and documentation to guide product usage and training. ●​ Designed Power BI Reports to inform inventory delays and delivery errors, leading to over 90% quick dispute resolution. ●​ Conducted exploratory data analysis using Excel to identify patterns, trends, and outliers. ●​ Developed SQL queries for data extraction and analysis. ●​ Participated in the implementation of Python scripts to automate routine data processing tasks. Jesulana Engineering, Lagos, Nigeria​ Project Manager (Undergraduate Intern) ​ ​ May 2021 - October 2022 ●​ Supervised several pile foundation projects and made sure employees followed all guidelines. ●​ Efficiently planned and distributed labor, supplies, and equipment to guarantee their proper handling. ●​ Close collaboration with suppliers was maintained to guarantee on-time material delivery as well as the proper amount and condition of each commodity. ●​ Ensured efficient communication with my employer, coworkers, and myself. I also provided daily reports to my company. ●​ Provided a safe working environment and established and implemented safety protocols. EDUCATION Federal University of Technology, Akure, Ondo State B.Tech. Applied Geophysics October 2016 - August 2023 Completed modules in: ●​ ●​ ●​ ●​ ●​ Differential Equations Vector and Tensor Analysis Comparative Programming Languages (Python and PHP) Statistics for Physical Sciences and Engineering Numerical Analysis and passed in all the modules. TECHNICAL SKILLS ●​ ●​ ●​ ●​ Microsoft Power BI SQL Microsoft Office Tools Python Programming STRENGTHS/PERSONAL SKILLS ●​ ●​ ●​ ●​ ●​ ●​ Effective Communication Networking skills Project Management Organizational and Time Management skills Leadership Skills Ability to lead and work in a team REFEREES Available upon request.
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.