Banner Image

Skills

  • Google Sheets
  • Automation Anywhere
  • Google App Script
  • Advanced Excel
  • Automated Emails
  • Automation
  • Data Analysis
  • Data Cleaning
  • Data Entry
  • Data Extraction
  • Gmail
  • Google App Scripts
  • Python
  • SQL

Services

  • Data Analysis and Automation

    $6/hr Starting at $50 Ongoing

    Dedicated Resource

    I provide expert services in advanced Excel, Google Sheets, Snowflake, and Python, including data cleaning, entry, analysis, and automation. I build dynamic dashboards, automate reports with Google Apps...

    Advanced ExcelAutomated EmailsAutomationData AnalysisData Cleaning
  • Google Sheets Email Data Extractor

    $5/hr Starting at $40 Ongoing

    Dedicated Resource

    I offer a custom Gmail to Google Sheets Email Data Extractor that automates the process of extracting specific data (such as sender, subject, date, message content, attachments, and more) from Gmail and...

    Automation AnywhereData ExtractionGmailGoogle App ScriptsGoogle Sheets

About

Turning raw data into smart decisions, I deliver accurate, automated, and efficient Excel, Google Sheets, and Snowflake solutions tailored to your business needs.

Hello! I'm Shadrack Kiprop, a passionate Data Specialist with over 3 years of experience transforming complex, raw data into clear, actionable insights for businesses, government agencies, and nonprofits.

My journey began while working with the Ministry of Education in Kenya, where I was involved in data collection, analysis, and reporting. I saw firsthand how quality data and well-designed dashboards can influence key policy decisions. From there, I was hooked — I dove deep into Excel, data visualization, and automation tools to make data more accessible and meaningful for others.

As I advanced, I worked on projects with organizations like Green Planet and Earthbanc, helping to automate data flows from ODK Central to Google Sheets, and developing monitoring dashboards for climate projects and field nurseries. These projects taught me the importance of building systems that are not just functional but user-friendly and sustainable.

Today, I specialize in:
Excel and Google Sheets automation
Data dashboards (Excel, Streamlit, Power BI)
Google Apps Script solutions
Snowflake SQL and Streamlit dashboards
Python scripting for scraping and analysis
Email data extraction from Gmail to Sheets
Data collection automation using ODK and APIs

What sets me apart is my commitment to clarity, automation, and impact. I don’t just work on your data—I help you understand it and make it work for you. My goal is to take the manual burden off your team’s shoulders and replace it with smart, automated systems.

⚡ Core Values I Bring to Every Project
Clarity – Clear communication, clean code, and easy-to-understand reports.
Efficiency – Automating repetitive tasks to save time and reduce human error.
Integrity – I treat every project like it's my own. Deadlines and data privacy are non-negotiable.
Continuous Learning – I’m always sharpening my skills and staying updated with the latest tools.

🧠 A Few Fun Facts
I’m passionate about environmental sustainability and recently started exploring carbon analytics and GIS tools.
I enjoy building things from scratch—whether it’s a data app, a Google Sheet system, or a mobile form interface.
Outsideof tech, I love cycling, exploring nature, and teaching digital skills to youth in my community.

💬 Let’s Work Together
Whether you're a small business looking to streamline your operations, a nonprofit trying to track field data, or a startup needing a live dashboard—I’m here to help you unlock the full power of your data.

Let’s connect and build something smart together!

Work Terms

I am available Monday to Monday, I’m flexible with time zones and can adjust my working hours to accommodate client needs in the US, UK, Europe, or other regions.

I prefer using SafePay (Guru Escrow) for secure and transparent transactions. Depending on the nature of the project, I offer flexible billing options—including per milestone, hourly rates, or fixed-price agreements. I strive to respond to all client messages within 24 hours, and I’m open to handling urgent tasks with same-day delivery when needed. My work includes unlimited revisions within the agreed project scope to ensure your complete satisfaction.

For communication, I’m available through Guru messaging, email, WhatsApp, or Zoom/Google Meet for live discussions or demos. I maintain a clear, timely, and professional communication style, providing regular progress updates and proactively suggesting improvements when appropriate. I am fluent in English and committed to keeping communication efficient and client-focused.