Erick Nyagilo

Experience

• 

  News Uncensored

  Jan 2018 - May 2019

  Tech bloger

  Blogged on tech related equipment.

• 

  Kenya Metrological Department

  May 2019 - Aug 2019

  Attache

  Research and Development division- Updated Rainfall data on the database using CLIMSOFT. Then verified the same rainfall data to ensure accuracy - Performed data cleaning on rainfall data of the 39 stations. Through replacing the missing data (NA) using the medium of each set of data either column-wise or row-wise.- Using data integration techniques I was able to match different data frames.- I meted data to long format, merging data, and also casting data to wide formats.- Through data visualization techniques, where I was able to produce good visualization of the Rainfall data and gave inferences.- Plotted networking diagrams using Network D3 in R. IT division- Participation and assistance in the organization of training of staff on ICT issues- Conducted maintenance of an up-to-date inventory of software and hardware- Handle periodic maintenance of hardware and software- Troubleshoot equipment such as printers and scanners - Take telephone calls from users and attempt to assist them with their information technology questions and problems- Install the software, antivirus and maintain software and cleaning of all computer systems. - Providing IT Support and network set-up and maintenance- Conduct electrical safety checks on computer equipment- Replace the networking cables by crimping new cables with new RJ45 clips. Show less

• 

  Zindi

  Jan 2020 - Nov 2020

  Data Analyst

  I have participated in the following projects:- 1). Computer Vision projects:- a. Radiant Earth Computer Vision for Crop Detection from Satellite Imagery. b. Spot the Mask Challenge. 2). Predicting Urban Air Pollution in Uganda. 3). Xente products purchase prediction based on a customer's purchase history. 4). COVID-19 Tweet Classification Challenge; Can you identify tweets about coronavirus without using keywords? 5). South African COVID-19 Vulnerability Map; predicting the percentage of households that fall into a particularly vulnerable bracket.https://zindi.africa/users/Erick_Nyagilo/competitions/certificate Show less

• 

  Telesim Solutions

  Jun 2020 - Oct 2020

  Web Developer

  As a Front End Developer, My role is to write and style the front-end components that meet the requirements of our mocks and fulfill our user stories.I also monitor and process pull requests for production deployments. Technologies used: Angular, React, JavaScript, ES6, TypeScript, SASS

• 

  RYANADA LIMITED

  Oct 2020 - Jan 2021

  Intern

  Design and built 50+ single-page website templates for Olitt.com platform. Constantly improving and adding features to the= platform through integrating new features such as intercom, Facebook post embedding, Social media share Buttons, YouTube and Google maps integration.Performing usability improvement bested on customer feedback.

• 

  InterIntel Technologies Limited

  Jan 2021 - May 2021

  Implementation Engineer

  Designed all job requirements and specifications.Managed all communication with implementation analysts and resolve all issues and develop all programs according to client requirements.Performed various tests on process with help of test cases and prepared documents for same and coordinate with manager to resolve all issues within required timeframe and inform management of any delays.Collaborated with development team to design new programs for all client implementation activities and managed all communication with department to resolve all issues and assisted other implementation members to manage all production data.Performed research on all client issues and documented all findings and implemented all technical activities with help of metadata registry.Prepared and maintained all technical and business documents and collaborated with clients and IT department to provide support to all issues.Established all technical project requirements and maintained effective professional relationships with all clients and organize all project materials.Assisted clients to monitor all software implementation lifecycle and assist make appropriate customization to all software for clients.Trained client technical staff on all hardware and software issues and identified all issues in processes and provided solutions for same. Show less

• 

  Kenya Tea Packers Limited

  May 2021 - now

  Database Administrator: Bi and Analytics

  • Develop analytical platforms that will be used to avail data to end users for exploration, advanced analytics and visualizations for day-to-day business reporting.• Implement ETL processes using tools such as Mage AI, or custom scripts to extract, transform, and load data from various source systems. • I manage Qlik Sense environment and facilitated report authoring through QMC (Qlik Management Console), improving report generation efficiency by 50%. • Designing and implementing efficient database structures, schemas, and data models to meet application needs while optimizing performance and scalability. • Constantly monitor database performance, identify bottlenecks, and optimize queries, indexes, and configurations to enhance system efficiency and responsiveness. • Configure Azure Site Recovery for DR and Azure backup on-premise and on our Azure Cloud environment. • Perform regular database maintenance tasks, such as backups and Azure Cloud DR tests. • Administration duties including Windows Active Directory object maintenance, troubleshooting and repair tasks on Active Directory, Windows Servers, Domain Controllers, DNS, user authentication and other operational systems as needed. • Implementation of tools to aid in improving operation efficiencies in monitoring and infrastructure management (tool like ESET Endpoint Security, ManageEngine Endpoint Central, Datrktrace and Sophos Firewall). • Monitor the performance of storage systems to ensure optimal performance and identify potential bottlenecks or issues. This includes tracking metrics such as throughput, IOPS (Input/Output Operations Per Second), latency, and capacity utilization. • Provision storage resources to meet the needs of various applications and users within the organization. This involves creating, configuring, and allocating storage volumes, LUNs (Logical Unit Numbers), and file systems. • Administration of Virtualized environments including VMware Virtualization platform. Show less