JINYUE JI (JESSI)
SAN FRANCISCO, CA • 408-***-**** • ac0gc9@r.postjobfree.com
WORK EXPERIENCE
Toronto Hydro, Toronto, ON, Canada January to August 2015 Senior Technical Student (Meter Data Management group)
Analyzed large billing activity data on monthly basis to allocate electricity charges for high-usage clients using complex Excel spreadsheet functionality.
Consolidated meter data and prepared consumption reports for 46 commercial buildings each month; audited data to identify inoperable meters and created spreadsheet for automatically calculating electricity distribution losses.
Prepared budgeting reports for monthly manager meetings by analyzing Ellipse financial transactions.
Streamlined new data meter tracking using Excel VBA code to effectively locate exact coordinates of over 1,000 individual meters.
Implemented accurate billing cycles partnering with meter installation company on new projects. Certified Public Accountants - Zhonglian Mindu Shu Lun Pan, Tianjin, China January to March 2013
(Part of BDO International network – “The earliest, largest and most influential CPA management Co. in China”) Auditor Assistant
Audited financial statements ensuring accuracy of cash and accounts receivables.
Tested internal controls by tracing disclosed amounts to supporting records.
Reconciled fixed assets depreciation schedules ensuring their accordance with physical assets. EDUCATION
Data Analytics Program, 2016
General Assembly, San Francisco, CA
Certificate of Completion
Excel: Performed market analysis on Airbnb investments by analyzing demand, revenue, property types, and locations.
SQL: Wrote queries to extract, cleanse, and analyze over 500,000 test records and 4,000 user surveys to provide recommendation on area of Firefox to improve.
Tableau: Blended data from multiple sources and built visualizations on a geographical map comparing job density across different counties to their housing prices. Bachelor of Arts, Economics, 2013-2016
York University, Toronto, ON, Canada
GPA: 8.55/9.00, Summa Cum Laude, Member of Dean’s Honor Roll Activities: President of Finance for Global China Connection club SKILLS
Excel • SQL • Tableau • R • Stata • Minitab • Eviews • Ellipse
Bilingual in English and Chinese (Mandarin)