Hi, I'm Joram Mwanyika

Customer Service & Automation Specialist

Streamlining business operations with no-code/low-code automation tools and technical expertise

Profile photo

About Me

I streamline business operations using no-code/low-code automation tools like Airtable, Zapier, and Make (formerly Integromat). Collaborating with diverse teams, I tailor automated processes to meet their unique needs through effective communication and teamwork. With technical expertise in HTML, CSS, JavaScript, Python (OOP), Flask, Excel, SQLAlchemy, and SQLite3, I ensure projects are efficient, accurate, and secure.

No-code/Low-code Automation Customer Service Process Optimization Technical Documentation Team Collaboration

Experience

Swahili Audio Transcriptionist

Dataforce | September 2024 – November 2024

  • Transcribed Swahili audio recordings with high accuracy and attention to detail.
  • Maintained strict confidentiality and adhered to project guidelines.
  • Ensured timely delivery while meeting quality standards.
  • Collaborated with the team to resolve inconsistencies and clarify ambiguities.

Automation Assistant

Kibo School, Remote | May 2024 - July 2024

  • Designed and implemented integrations using Zapier, Make (Integromat), and Google Sheets to automate workflows and improve efficiency.
  • Developed data synchronization processes between multiple systems, ensuring seamless data flow.
  • Collaborated with teams to optimize internal processes using low-code/no-code automation tools.
  • Created dashboards and reports using Google Sheets and Airtable for data-driven decision-making.
  • Maintained comprehensive documentation of automated workflows for scalability and knowledge sharing.
  • Gained hands-on experience with NetSuite custom reports, dashboards, and saved searches, supporting data-driven decision-making.
  • Built and maintained integrations between NetSuite, ClickUp, ActiveCampaign, and WooCommerce to enhance operational workflows.
  • Developed custom NetSuite dashboards and saved searches to streamline financial and customer data tracking.
  • Utilized Celigo to automate data flow across various CRM and accounting platforms.
  • Implemented API-based solutions to integrate Google Workspace tools with business applications.
  • Troubleshooting and optimized automation processes to improve reliability and performance.

NRF Hackathon Participant

May 2024 - June 2024

Gained skills in cybersecurity, network configuration, and software development using Django, Python, and React.js. Our innovation was based on Natural Language Processing.

Open Source Software Engineering Intern

FreeCodeCamp | April 2024 – June 2024

Worked under the guidance of David Walter to contribute to FreeCodeCamp, a charity site offering courses in computer science and technology.

Law Clerk (Customer Service and Support)

Orina & Company Advocates | April 2022 - August 2023

  • Developed a proofreading process for legal documents, reducing errors.
  • Introduced standardized templates for legal documents.
  • Trained new administrative staff, ensuring efficient office operations.

Featured Projects

Automated Patient Appointment Scheduling, Follow-Up and Feedback System

Problem

Managing patient appointments manually can lead to scheduling conflicts, missed appointments, and administrative inefficiencies. Additionally, managing follow-ups and collecting patient feedback manually is time-consuming and prone to errors.

Solution

I created an automated system that will handle appointment scheduling, follow-up communications, and patient feedback collection. This system will enhance efficiency and accuracy while providing a better solution for patient interaction management.

Education

Kibo School of Technology

Diploma in Computer Science | June 2023 - July 2024

New York, NY

Moi University

Bachelor of Engineering in Electrical and Communication | August 2023 - Present

Eldoret, Kenya

Mpeketoni Boys High School

Jan 2018 - Apr 2021

Grade: B+ | Lamu, Kenya

Skills & Additional Information

Technical Skills

Python, HTML, CSS, JavaScript, Flask, SQL

Tools

VSCode, Figma, PyCharm, Github

Certifications

Python (Programming Language), SQL

Other Skills

Problem solving, Verbal and written Communication, Critical thinking, Attention to details, Typing speed of 50 WPM

Languages

Swahili, English

Interests

Basketball, Gaming, Coding

Get In Touch

Contact Information

Feel free to reach out through any of these channels

jorammwanyika@gmail.com

+254794728645 / +254759375015

Eldoret, Kenya

WhatsApp

Instagram