Guo Zimeng

Data extraction · Analysis · Technical documentation

I turn messy sources — PDFs, scanned pages, screenshots, spreadsheets — into clean data and documents people can actually use. Most of the material I work with was never meant to become data. Getting it out is the job.

Hire me on Fiverr GitHub

What I do

Data extraction

Structured records pulled out of PDFs, scanned pages, screenshots and photos into clean Excel or CSV. Read by hand, not by a raw OCR pass.

Data analysis

Sales trends, customer segmentation and RFM, product concentration, returns and exception review — written up as findings, not just charts.

Technical documentation

Manuals, operating procedures, SOPs and reports built from source material, with numbered steps, tables and annotated figures.

Selected work

Data extraction

Screenshots and scans into structured data

A scoring table that existed only as a set of screenshots was rebuilt into a structured dataset, then reconciled against a 238-page handbook and two hours of screen recording.

  • 61 screenshots transcribed into 723 scored rows
  • Each row carries its own acceptance criterion and point value
  • Chinese and English source material handled in the same job
  • 62 annotated interface figures produced alongside the data
Screenshots converted into a clean Excel table
Sales analysis

541,000 transactions, ten findings

A full year of online retail transactions cleaned, segmented and analysed — with the conclusion placed before the detail.

  • Top 1% of customers produced 30.5% of revenue
  • One promoted product carried a 95% return rate
  • Three autumn months carried 37% of the year
  • Zero transactions on any Saturday, all year
Sales analysis dashboard with trend, RFM, product and timing charts
Documentation

Handbook into an operating procedure

A 238-page equipment handbook, a folder of interface screenshots and two hours of recording were turned into a document a new operator can follow unaided.

  • 93-page operating procedure with numbered steps and tables
  • 24-page printable checklist built from the same source
  • Every step paired with its target value and how to confirm it
Technical operating procedure document

By the numbers

541k
rows analysed
723
rows extracted by hand
93
page procedure produced
62
annotated figures

Open source

movesmith-blender

A free Blender add-on for baked cinematic camera moves and first-frame export for AI video generation. The full version adds depth and normal passes and batch export.

View on GitHub →

Skills

SQL Python (pandas) Excel — advanced functions, pivot tables MySQL Data cleaning RFM segmentation OCR and document extraction Technical writing Chinese ⇄ English material

Background

2025 – 2026
iFLYTEK — E-commerce data and AI model data support

Monitored core e-commerce metrics daily and diagnosed abnormal fluctuations. Rebuilt the performance reporting logic, cutting maintenance effort by 30%. Prepared and cleaned datasets for AI model iteration.

2019 – 2025
Hunan Normal University (Project 211) — BSc, Computer Science

Coursework in Python, probability and statistics, data analysis and AI. Study was interrupted by two years of military service.

2020 – 2022
Chinese People's Liberation Army — Conscript

Daily training and duty, plus network and information security study. Awarded Outstanding Conscript and “Four Haves” Outstanding Soldier; part of a team recognised for data analysis at a cyber contest.