Learn Data Skills
Beta
Olugbenga Ajiga

Olugbenga Ajiga

Student

Masterschool | United Kingdom

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Analytical pioneer, exploring uncharted territories in the world of data.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to ChatGPT

course

Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Masterschool SQL

Masterschool Data Analysis Fundamentals

Masterschool Descriptive statistics

LinkedIn Learning Excel-Data Analysis

Free code camp organization Data Analysis with Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

E (Gas & Electricity) Ltd | Jun 2023 - Present

SQL Developer

Improved Data Accuracy and Processing Efficiency: Implemented SSIS to automate and optimize data workflows, reducing manual tasks and human error. Achieved a 20% improvement in data accuracy, ensuring reliable data-driven decisions, and a reduction in processing time for increased operational efficiency. Advanced-Data Ingestion and Pipeline Construction: Utilized advanced data ingestion techniques and cloud ETL tools, including Azure Data Factory, to construct efficient data pipelines. Leveraged Azure Data Factory to design and build efficient data pipelines, resulting in a 25% increase in data throughput and accuracy, crucial for data-driven decision-making. Comprehensive SQL, SSRS, and Power BI Expertise: Formulated SQL queries, created reports with SQL Server Reporting Services (SSRS) and Power BI, and executed ELT/ETL migrations from 10+ data sources using SSIS. Seamless Data Migration and Optimization: Executed seamless data migration from on-premise to Azure cloud, optimizing code and enhancing performance with a 25% improvement in processing time. Automated Data Quality Checks and Audits: Automated data quality checks processes prior to report loading, reducing data errors by 40% and ensuring accurate insights. Conducted spontaneous data quality audits within Customer Relationship Management (CRM) systems, maintaining a 95% accuracy rate and data integrity. Multi-language Data Manipulation and Analysis: Manipulated and analyzed large datasets using T-SQL, C#, Python, and R, resulting in a 20% rise in data accuracy and enabling data-driven decision-making for a 15% increase in operational efficiency. Diverse Data Set Processing and Compliance: Processed diverse data sets, including smart meter customer targeting, customer service call handling metrics, commercial insights, and regulatory reporting to Ofgem and government agencies. Ensured 100% compliance with industry standards, lowering data mistakes. Efficient Data Modeling with DBT: Employed DBT (data build tool) for data modeling, enhancing data build processes, and streamlining data transformations. Achieved a 30% reduction in data processing time, ensuring faster data transformation crucial for real-time data-driven decisions.
Show More

Allied Worldwide Ltd | Aug 2022 - Present

Data Engineer

Efficient Data Extraction and Transformation: Extracted, cleaned, and transformed large data sets with 95% accuracy using Python and Google BigQuery NoSQL, resulting in a 30% faster processing time. Proficient Python Automation and GIT Version Control: Demonstrated proficiency in Python and its libraries (pandas, NumPy, Scikit-learn, TensorFlow, PyTorch, Keras, spark) to automate data processes, achieving a 20% increase in efficiency. Proficient use of Python to automate data processes, reducing the need for manual intervention and human errors. A 20% increase in efficiency signifies tasks are completed more quickly and accurately, saving resources. Implemented GIT for version control, collaborating with cross-functional teams to maintain codebase integrity and achieving a 15% increase in development productivity. Utilized GIT for version control to manage codebase changes effectively and collaborate across teams. A 15% increase in development productivity demonstrates the efficiency of code management, leading to faster project delivery. Customer Feedback Sentiment Analysis and Continuous Integration: Part of the team that conducted sentiment analysis of customer feedback using natural language processing (NLP) techniques, resulting in a 25% enhancement in customer satisfaction scores. Developed and implemented continuous integration and development pipelines using Azure DevOps, leading to a 25% reduction in deployment time and improved code quality. Created and executed continuous integration and development pipelines within Azure DevOps. The 25% reduction in deployment time indicates faster software delivery and code quality improvements. Statistical Analysis and Data Quality Monitoring: Deployed statistical analysis to identify key factors affecting customer satisfaction and critical errors, leading to a 15% increase in customer satisfaction and a 10% decrease in agent errors. Monitored data quality and removed corrupt data, using tools and techniques to visualize cleaned data, resulting in a 10% increase in data accuracy. API Integrations and Data Exchange Enhancement: Established RESTful and GraphQL API integrations to facilitate data exchange between systems, improving data access and analysis capabilities, and enabling the creation of dynamic dashboards. Implemented RESTful and GraphQL API integrations to enable seamless data exchange between systems. These integrations improved data access and analysis capabilities, allowing the creation of dynamic and interactive dashboards for better insights. Data Profiling and Application Integration: Performed data profiling and quality assessments, tracking down data irregularities and errors, resulting in a 25% improvement in data precision and comprehensiveness. Partnered with the software engineering team to incorporate developed models into the client-facing application, reducing the time taken to review redemption cases by 80%. Seamless Integration of Tableau and Power BI with Azure Synapse: Orchestrated seamless integration of Tableau and Power BI with an Azure Synapse data warehouse, enabling real-time data access and analysis, resulting in a reduction in reporting latency. Successfully integrated Tableau and Power BI with an Azure Synapse data warehouse, allowing stakeholders to access and analyze data in real time. The reduction in reporting latency means that critical insights are delivered faster, improving decision-making and business responsiveness.

ALETHEIA DILIGENCE GROUP | Mar 2021 - Jul 2022

Bussiness Intelligence Developer

Quantitative Analysis and Statistical Modeling: Conducted comprehensive data analysis on large datasets using SQL, Google BigQuery, and Python, identifying trends, patterns, and opportunities for optimization. Agile Project Management: Actively contributed to agile teams using Scrum and Kanban methodologies, ensuring smooth project delivery and alignment with business objectives. a) Actively participated in agile teams, promoting the use of Scrum/Kanban methodologies for project management. b) Ensured that project delivery was smooth and aligned with business objectives, enhancing the organization's agility. Data Visualization and Reporting: Developed and maintained interactive dashboards and reports using Tableau, translating complex data into actionable insights for executive stakeholders, leading to a 20% improvement in decision-making efficiency. Presented findings and actionable recommendations to senior management, contributing to strategic planning and resource allocation processes. Cross-Functional Collaboration: Collaborated cross-functionally with departments including Sales, Marketing, and Operations to gather requirements, design analytical solutions, and address key business challenges. Automation, Data Quality and Integrity: Led initiatives to enhance data quality and integrity, identifying and rectifying inconsistencies, resulting in improved accuracy of analytical findings. Automated regular reports, reducing manual effort by 50% and ensuring timely delivery of insights to stakeholders. Mentorship and Team Enhancement: Mentored junior developers, providing guidance, support, and training to foster their professional growth. Enhanced team knowledge and efficiency, resulting in a 20% increase in junior developer performance. a) Provided mentorship to junior developers, helping them grow professionally and improve their skills. b) A 20% increase in junior developer performance reflects the effectiveness of mentorship and its positive impact.

Dangote Fertiliser Ltd | Aug 2020 - Mar 2022

Senior IT Officer (Data Analyst)

Quantitative Analysis and Statistical Modeling: Conducted in-depth data analysis using advanced statistical techniques and predictive modeling. Developed pricing optimization models, leading to a 5% increase in revenue and improved profitability. Data Visualization and Reporting: Designed and created intuitive data visualizations and interactive dashboards for cross-functional teams. Implemented Tableau for reporting, improving data accessibility and comprehension among non-technical stakeholders. Data Cleaning and Quality Assurance: Led data cleaning and preprocessing initiatives, reducing errors and enhancing data consistency. Implemented automated data validation processes, resulting in a 20% reduction in discrepancies. Business Impact: Team up with the marketing team to optimize customer segmentation, achieving an increase in the effectiveness of targeted campaigns. Provided data-driven insights that contributed to a 10% reduction in operational costs. Conducted cohort analysis leading to a pricing strategy change, increasing yearly revenue by 5%. Data Quality Control Initiatives: Administered data profiling and quality assessments, improving data accuracy and completeness. Executed a data unification strategy, harmonizing information from diverse sources. Implemented quality control measures to enhance data accuracy and support the global expense audit process, saving the company thousands annually. Led data architecture and modeling initiatives, implementing facts and dimensions, materialized views, and optimizing data structures for enhanced query performance. This resulted in an improvement in data retrieval times: a) Took the lead in designing data architecture and modeling, organizing data for efficient analysis. b) A 40% improvement in data retrieval times means that data is more accessible and queries are executed faster, supporting timely decision-making.

Dangote Oil Refinery Co. | Jul 2015 - Aug 2020

Principle IT Officer (Data Projects)

Data Analytics and IT Infrastructure Projects: Delivered some challenging data analytics and IT infrastructure projects, such as data migration, data-driven application designs, data warehouse implementation, and data visualization providing valuable insights for both management and end-users. End-to-End Data Management: Managed end-to-end data requirements gathering, scoping, migration, design, implementation, deployment, and presentation using dashboards, while interpreting findings and insights for management and end-users for planning, which increased revenue. ETL Migrations and System Re-engineering: ETL Migrations, existing system re-engineering, coordinated the migration of MS Access systems to MSSQL Server, saving cost and improving efficiency. Third-Party Application Assessment and Supervision: Assessed and evaluated third-party applications before implementation, providing expert oversight and supervision to multiple IT projects, ensuring completion within established timelines and budgets. Metric Requirements and Project Efficiency: Partnered with project leaders to define and oversee metric requirements, resulting in an improvement in supplier evaluations and an increase in project efficiency assessments. SQL Server Data Warehouse Implementation: Orchestrated some Datawarehouse implementation projects, from gathering business requirements and designing data models to setting up ETL jobs using SSIS, resulting in serving up to several thousand queries per month. Key Accomplishment: Completed 10+ challenging data analytics and IT infrastructure projects, such as data migration, data-driven application designs, data warehouse implementation, and data visualization providing valuable insights for both management and end-users. Saved resources by developing in-house data analytics solutions instead of procuring from a third party and achieved annual savings of millions of dollars through efficient allocation of resources during the construction stage.

Longterm Global Capital Ltd | Dec 2011 - Jun 2015

Bussiness Intelligence Analyst

InfoWare Cloud-based Trading Application Deployment: Led the deployment of the InfoWare Cloud-based Trading Application, resulting in a 20% reduction in costs through efficient management of client accounts. In-Depth Financial Analysis and Forecasting: Conducted in-depth financial analysis, forecasting, and trend analysis to support executive-level reports, resulting in a 10% improvement in the accuracy of financial projections. Advanced-Data Visualization Implementation: Implemented advanced data visualization techniques using Power BI and Tableau, transforming complex financial data into visually intuitive dashboards and reports, enhancing data accessibility and understanding. Automation of Financial Reporting Processes: Led the automation of routine financial reporting processes, saving over 15 hours of manual effort per week, and ensuring real-time access to critical financial information. Insights into Market Trends and Competitive Analysis: Provided insights into market trends, competitive analysis, and financial benchmarks, aiding senior management in identifying growth opportunities and mitigating financial risks. Notable Achievements: Awarded "Outstanding Analytical Excellence" for consistently delivering high-quality financial analyses that informed critical business decisions. Recognized for leading the successful implementation of a company-wide business intelligence platform, resulting in improved data governance and enhanced financial reporting capabilities. Actively participated in continuous learning and professional development initiatives, staying up-to-date with the latest industry trends and technologies in financial analytics.

My Education

Take a look at my formal education

Data Analysis in Data AnalyticsMasterschool | 2023
Master in Information Technology in Information Technology University Of Lagos, Nigeria | 2013
Bachelor of Engineering in Electrical/Electronic EngineeringFederal University of Technology Akure, Nigeria | 2007

About Me

Olugbenga Ajiga

Data Analytics | Python | SQL | IT Project Management | WV1 3EJ

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free