pengfei
chen

Average Review

0.00

Reputation

Finished gigs

Finished jobs

Website

Not specified

Country

Not specified

Specialization

Data Entry & Web Scraping & Data Analysis

Hourly rate

$35/hr

Preferred payment options

USDT

USDC

BNB

About me

I specialize in building automated Excel/data workflows for operational and analytical tasks — from complex formula systems (SUMPRODUCT, SUMIFS, LET, IFS) to Python-based data extraction scripts that pull from web APIs and consolidate multi-source data into clean reports. My background is in energy sector data operations, where I've built decision-support spreadsheets involving price forecasting, position tracking, and rule-based recommendation logic, as well as Python scripts that automate multi-day data exports from web systems (via API reverse engineering from HAR files). I'm reliable, detail-oriented, and comfortable working with messy or technical data. Available for small-to-medium tasks — happy to clarify scope before starting to make sure the deliverable matches your needs.

Work experience

CECEP

March 2025 – Current time

Job title

Electricity traders & full-stack engineers

Work experience & achievements

I specialize in Excel automation and Python-based data processing for operational and analytical reporting. Excel Decision Support Dashboard: Built a multi-layer Excel tool for daily trading position tracking and price forecasting - cumulative position tracking (SUMPRODUCT/SUMIFS), 5-point linear regression forecasting, rule-based recommendation logic (IFS) with profit thresholds, and boundary detection using historical data. Consolidated a multi-step manual process into one automated workbook, cutting processing time significantly. Automated Data Export (Python): Built a script automating bulk data extraction from a web reporting system - reverse-engineered the API via HAR file analysis, then automated multi-day exports into a clean Excel report. Turned a repetitive manual task into a single run, cutting retrieval time ~300x. Detail-oriented, comfortable with messy technical data, clear on scope before starting. Open to small tasks or larger analytical work.