Daniel Opiyo

Lead software developer

RIARA UNIVERSITY.   Nairobi, KE  | April 2023– Present

Key Achievements ;

• Designed and implemented a cutting-edge web-based certificate generation system integrated with QR code technology. This innovative solution significantly enhanced operational efficiency for Riara University and streamlined the process for students enrolled in short-term courses.
• Developed and deployed a robust online student onboarding system, leveraging web technologies. This system revolutionized the university's service delivery by improving efficiency and simplifying the admission process for students, resulting in enhanced user experience and satisfaction.
• Gathered requirements and built customized applications that met the core needs of the business, resulting in improved operational efficiency.
• Created user manuals and training materials that effectively guided end-users in utilizing applications, resulting in increased user adoption and reduced support requests.
• Played a key role in the design, development, and maintenance of the university website, ensuring a visually appealing and user-friendly online presence.
• Designed and implemented a groundbreaking integration system that seamlessly connected the university's student financial system with the Canvas Learning Management System. This achievement automated student account activation upon fee payment, streamlining processes and enhancing the learning experience for all stakeholders.
• Participated in User support

Tools Used: SQL, Spring boot, Angular, Node & Express, WordPress, PHP

Senior Software Engineer & POD Lead

ANDELA NEW YORK, US  | Jun 2021 – Mar 2023 

Was responsible for data analysis and visualization.

• Developed reports and analyses
• Revamped the reporting infrastructure, leveraging advanced analytics tools and data visualization techniques; implemented automated data pipelines, reducing manual effort by 60% and enabling real-time reporting and insights.
• Supported the data warehouse in identifying and revising reporting requirements
• Was responsible for operational efficiency and effectiveness of the teams
• Ensured the team meets all contractual SLA targets
• Monitored performance, identified improvement areas, implemented action plans
• Managed dispute resolutions by engaging the QC team and Policy Engagement functions
• Addressed or escalated workflow, modeling, and policy clarifications

Tools Used: SQL, AWS, Google Big Query, Spring boot, Angular, Java

Software Engineer | Data Analyst

INDEED SAN FRANCISCO, USA  |  Jul 2021 – Dec 2022 

Worked on data analysis and visualization and as an IHP report writer.

• Built complex SQL queries to extract and manipulate data, enabling in-depth analysis and reporting.
• Developed and implemented low-code applications using Google AppSheet, enhancing team productivity and communication.
• Developed reports and analysis using tools such as Tableau, MS PowerPoint, and Excel, presenting data in a visually appealing and informative manner.
• Transformed complex business data from structured databases using SQL, enabling its utilization in applications.
• Orchestrated the design and management of a comprehensive reporting environment, integrating diverse data sources; streamlined data analysis processes, resulting in a 40% reduction in report generation time and increased data accuracy by 25%.
• Manipulated data with Google BigQuery, leveraging its powerful capabilities for large-scale data processing and analysis.
• Retrieved real-time data from the database and displayed it in PowerPoint using ODBC enabling up-to-date reporting and analysis
• Utilized Salesforce and Seismic to handle report generation, streamlining the process and improving efficiency.
• Collaborated with internal teams and external clients to understand their reporting needs and created customized reports accordingly 

Tools Used: AWS, SQL, ,Google Big Query, AppSheet, Tableau, Python, MS. PowerPoint,   Excel 

ICT & Computer Studies Trainer

MINISTRY OF EDUCATION, SCIENCE & TECHNOLOGY.  Nairobi, KE   | Feb 2020 – Dec 2021

As a senior technical trainer and ICT Technical head in Borabu TTI,

· Provided training on data structures and algorithms, basic programming concepts, and programming subjects in various object-oriented languages (Java, JavaScript, Python and C++) to learners.

Software Engineer Intern

ICT AUTHORITY Nairobi, KE | Jul 2019 - Jun 2020

Interned as a software engineer intern at the ICT Authority under the Presidential Digital Talent program.

• Redesigned the NCPB website using WordPress
• Developed a farmers’ portal
• Maintained and supported users on the NCPB ERP system (Microsoft Navision)
• Developed a self-risk assessment test for COVID-19
• Participated in analyzing user requirements and creation of software specification doc.

Tools Used: Angular, Node js, Spring boot, Java, SQL, Postgres

Systems Librarian (Volunteer)

RONGO UNIVERSITY Migori, KE | Sep 2018 - Jun 2019

Volunteered at Rongo University Library (ICT section).

• Designed the library website using WordPress
• Deployed the institutional repository running on Dspace
• Deployed an integrated library management system running on Koha
• Maintained the library computer labs and ensured they were connected to the internet

Tools Used: WordPress (PHP), Dspace, Koha, OJS,  Spring boot, Java, MySQL, Postgres

Junior Software developer

SYNCHRONY TECHNOLOGIES Nairobi, KE | Aug 2017 - Sep 2018

Worked as a junior software developer on building a client portal.

 Supported the existing clients.

• Designed an Online Quiz system
• Designed RESTful APIs
• Designed the Bank of Kigali Insurances online portal
• Maintained the company’s website

Tools Used: Angular, Node js, Oracle

KCA UNIVERSITY Nairobi, KE

April 2023 - Present

MSc. Data Science (Data Engineering)

PURDUE UNIVERSITY Indiana‎, US

Feb 2022 – Feb 2023

Associate in Postgraduate Program in Data Engineering

• Big Data Hadoop Spark Developer 
• AWS Technical Essentials
• Big Data on AWS Azure Fundamental 
• Azure Data Engineer
• Data Analytics 
• Scala & Pyspark

RONGO UNIVERSITY MIGORI, KE

Aug 2013 - Dec 2017

Bachelors of Science in Computer Science