Osaze Ogedegbe | Data Analyst & Power Platform Developer

Hi, I'm Osaze Ogedegbe

I build and setup simple, scalable solutions for complex business challenges.

Contact Me Read More

About Me

I’m someone who genuinely enjoys solving problems, especially the kind people and businesses don’t even know they have.

While I was in school, I explored so many fields including Python programming, networking and web development. I thought I was going to end up as a full-stack web developer so I went deep into it and built multiple web apps using Django (Python-based framework).

Towards the end of my third year, a series of consecutive events led me directly into the field of data which made me focus less on web development and more on data analytics with a touch of data science. This was when I learnt how to analyze data and build somewhat complex Machine Learning models using various libraries and frameworks.

I finished school with this momentum and started my career in data analytics which was really exciting. I worked my way up from an intern to a full-time data analyst at a consulting company where I use tools like Excel, Python, Power Query and Power BI.

Over time, I realized I didn’t just want to analyze problems, I wanted to fix them too and that realization came around the time I found the Microsoft Power Up Program. After I took the course and learnt all about the Microsoft Power Platform, I decided to keep learning more and implementing my knowledge at the consulting firm where I work.

Since then, I’ve been building business apps, automating processes and connecting systems to help my team work smarter, not harder. I’ve worked with the entire Power Platform stack to improve operations and remove bottlenecks and I've loved every bit of it.

Now I’m diving deeper into Dynamics 365, learning how to build and setup full business systems (CRMs and ERPs) that solve real-world challenges. I’m on a journey to become a full-stack Power Platform & Dynamics 365 Consultant, handling both the business and technical sides of implementation.

If you're looking for someone who loves challenges and solving problems with technology, that’s me.

Experiences

Simpletin Consulting

Data Insight Analyst

Prepare bi-weekly reports for LinkedIn engagement and present it to stakeholders with recommendations which has increased engagement by 150%.
Carried out an analysis on the website to identify bottlenecks and present recommendations which when implemented, increased the website speed by 40%.
Developed a Payslip Automation Solution that generates and distrubutes payslips which saves 30 minutes per employee every month.
Led the migration project that involved moving from Slack to Microsoft Teams which has boosted productivity by 20% due to the interoperability of Teams with other Microsoft tools.
Developed semi-automated hiring solution that automatically sends emails to applicants depending on the outcome of each stage, thereby saving 20 minutes per applicant.
Developed a mobile app for clients to monitor the progress of their project and chat with a company representative seamlessly which has boosted productivity amongst the team by 40%.
Developed scalable solutions to setup and monitor email campaigns effectively which has saved countless hours that would have been spent on manual outreach.
Implemented a data management strategy to centralize and control all data coming in and going out of the company.

Skills Used: Data Analysis, Data Modelling, Data Visualization, Systems Analysis and Development, Agile Project Management, Creative Problem Solving

July 2024 - Present | Abuja, Nigeria

Natview Technology

Data Analyst Intern

Cleaned and consolidated dispense reports of prescriptions over the period of some months for various healthcare facilities across Nigeria using various Python libraries
Trained a model to predict the number of deaths caused by obesity as a risk factor in African countries using random forest regression
Developed a real-time sign language alphabet dectection and translation system using random forest algorithm, alongside OpenCV for computer vision and MediaPipe Landmarks to convert positions hand landmarks to figures (arrays).

Skills Used: Analytical Skills, Python, Machine Learning, Microsoft Excel, Statistical Data Analysis

July 2023 - Sept 2023 | Abuja, Nigeria

Millennium Fellowship

Fellow/Campus Director

Launched a project called "Everyone can code Initiative" where we reach out to children and youths who don't have regular and easy access to computers and teach them foundational digital skills.
Responsible for securing the time and venue for Fellowship sessions on my campus.
Responsible for leading the Fellowship training sessions on my campus.
Responsible for documenting and submitting required materials in a timely matter to MCN.
Responsible for being as a liaison between MCN's global headquarters and Fellows on my Campus.

Skills Used: Team Management, Communication, Team Leadership, Report writing

July 2023 - Sept 2023 | Abuja, Nigeria

Projects

                
Payslip Automation Solution
                  Generation and distribution of payslips using Power Platform 
                
                Accomplishments
                Tools: Excel, Power Apps, Power Automate
Make edits like bonuses or deductions in Power App.
Click a button to send all payslips or send to one employee from Power App.
Power Automate flow creates payslip and sends to the email of the respective employee(s).

Event Management Solution
                  Pipeline to guide registration process using Power Platform
                
                Accomplishments
                Tools: Dataverse, Power Pages, Power Automate, Copilot Studio
Power Pages is used to create landing page for the event.
Registration form is embedded on the page.
Power Automate flow adds every registration entry to email list for follow up.
AI chatbot embedded in landing page can help answer FAQs and create the event on the user's calendar along with reminders.

Job Application Workflow
                  Pipeline to send emails after each stage of the application process using Power Automate
                
                Accomplishments
                Tools: Sharepoint, Power Automate
Power Automate is used to migrate applicant data from Microsoft Forms to a SharePoint List.
Once a choice is selected for an applicant at any stage (Passed or Failed), a flow is triggered that sends a corresponding mail to that applicant.

Email Campaign Solution
                  Automation and monitoring of emails for campaigns using Power Automate
                
                Accomplishments
                Tools: SharePoint, Power Automate
Power Automate sends out personalized email to everyone on the SharePoint list.
Email tracker created with Power Automate is used to monitor open rates.
Link tracker also created with Power Automate is used to monitor CTR (Click-through-rate).

Client Value Mobile App
                  Mobile app to communicate with clients and keep them in the loop using Power Platform
                
                Accomplishments
                Tools: Sharepoint, Power Apps, Power Automate
Clients can use the app to monitor their project through each milestone.
Clients can use the app to chat with a company representative logged on to another admin app.
Clients get push notifications when a chat has been sent to them or a document has been uploaded for them.
Clients can view any document uploaded for them in-app.
Clients can leave reviews about the app or any of their projects.

Jira Reporting
                  A report of the work being logged in Jira using Power BI and Jira Cloud
                
                Accomplishments
                Tools: Jira Cloud, Power BI, Excel
Pulled data with various filters from Jira using JQL (Jira Query Language)
Set up power queries to clean the data everytime the data is refreshed.
Created dashboard with important metrics and KPIs using the data on Power BI.
Set a schedule for dashboard to be refreshed when the report is due.

                Sign Language Translation in Video Conferencing Platforms
                
                Accomplishments
                Tools: NumPy, Pandas, Tensorflow, OpenCV, MediaPipe, Tkinter
The program begins with a to start and stop virtual camera connected to the model.
Once the virual camera starts, the webcam is accessed and the translation begins.
Users can join a video conference and select the virtual camera as their camera input.
Everyone in the video conference is able to see the user and subtitles of their signs in real-time.