Learn Data Skills
Beta
Nigel Amaya

Nigel Amaya

Certified

Business Intelligence Analyst

Dynasoft Business Solutions Limited | Nairobi, Kenya

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Track

Associate Data Analyst in SQL (previously Data Analyst in SQL)

My New Course

Introduction to Python

Insights conductor, orchestrating a symphony of knowledge from data streams.

My Work

Take a look at my latest work.

DataLab

Competition - Supply Chain Analytics

DataLab

Using Joins to Analyze Book Sales in SQL

DataLab

Course notes: Data Manipulation with pandas

DataLab

Project: Analyzing Students' Mental Health

DataLab

Competition - Supply Chain Analytics

My Certifications

These are the industry credentials that I’ve earned.

SQL Associate

SQL Associate

Other Certificates

Microsoft Microsoft Certified: Azure Fundamentals

Microsoft Microsoft Azure Data Fundamentals

Microsoft Microsoft 365 Fundamentals

Microsoft Microsoft Dynamics 365 Fundamentals

DataCamp Course Completion

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

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Kisumu Water and Sanitation Company Limited | Feb 2024 - Present

Business Intelligence Analyst

N/A

Dynasoft Business Solutions Limited | Mar 2020 - Jul 2023

Business Intelligence Analyst

• Managed database systems to ensure storage optimization, implemented compression techniques, maintained high availability, enforced security measures, and controlled data access. • Collected and cleaned data from various sources, ensuring accuracy and completeness. • Implemented data quality checks and assurance processes to maintain data accuracy and consistency. • Performed in-depth data analysis to identify trends, patterns, and anomalies. • Utilized SQL for custom data queries, transformations, and business logic within the database. • Ensured data quality through validation procedures. • Building and deploying BI solutions using Microsoft Power BI. • Created visually appealing reports and dashboards using Power BI. • Created and maintained comprehensive technical documentation for database systems and analytical applications. • Performed in-depth data analysis to identify trends, patterns, and anomalies. • Collaborated with system implementers to enhance deployed ERP systems.
Show More

Kenya Medical Research Institute | Mar 2019 - Mar 2020

Data Officer

Supported statistical analysis of stored data to assist customized report generation. • Provided informational resources regarding data-related access, storage, and security issues. • Conducted quality assurance, quality control and protocol validations to maintain efficiency. • Played a role in data architecture and design, including schema creation and evolution. • Led database management, development and analysis to meet organizational goals for information integrity. • Controlled users and access levels for each segment of given database. • Worked with project teams to coordinate the development of each database based on the established scope and limitations.

Jaramogi Teaching and Referral Hospital | Dec 2018 - Mar 2019

ICT/Data Intern

Devised customized hospital data report formulas and delivered reports to management as specified. • Performed data analysis, cross-referencing and consolidation. • Created standard queries, verified data quality and pinpointed inconsistencies and missing data. • Documented complex procedures deployed in data management. • Collaborated with staff and vendors to contribute to documentation of data, metadata and systems architecture. • Trained users and junior support staff in proper use of hardware and software. • Set up equipment based on staff needs and IT capabilities. • Participated in data quality checks and assurance procedures to maintain data accuracy. • Supported non-technical users by quickly investigating and resolving hardware and software issues

My Education

Take a look at my formal education

Bachelors of Business Information Technology in Information TechnologyJomo Kenyatta University of Agriculture and Technology | 2018

About Me

Nigel Amaya

I have honed my skills using a diverse set of tools including Python, SQL, Excel, and Power BI. My journey in the world of data doesn't stop there; I'm currently exploring the exciting realm of Data Engineering.

Powered by

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