top of page
Data-Science-vs_edited.jpg
wn2161_edited.jpg

James (Wendi) Niu

Senior Data Engineer/Senior Data Analyst/

Financial Data Analyst

Phone:

Email:

Address:

1021 Legacy Oaks Cir

Roswell, GA 30076

Date of Birth:

April 20th, 1993

A Bit About Me

James is seeking to leverage many years of experience in Cloud technologies, ETL data pipelines, cleaning, integrating, visualizing data, machine learning, OCR, and NLP modeling, striving to optimize company efficiency by at least 25%.


Worked in various sectors and industries with exemplary capacity for independence and tenacious standards under pressure.


Possess exemplary communication skills as both a team player and team leader in extensive data projects with cross-cultural teams.

Work Experience

Dec 2022 -  Current

Jan 2020 - Dec 2022

Apr 2019 - Dec 2019

Oct 2017 - Oct 2018

Senior Data Engineer

Leadership Circle, Atlanta, GA (HQ Draper, UT) (Remote)

• Collaborate closely with stakeholders across departments for user requirements, documentation, scalability, and frequency of I/O access with appropriate masking in data democratization
• Refine continuous and rapid process automation with best practices to support data loading, extraction, and transformation in a modern ELT cloud infrastructure stack
• Explore avant-grade technologies to develop, test, and deploy a transformation layer migrating to a data warehouse sourcing from hundreds of databases and petabytes of data for research

Data Engineer

Medlytix LLC, Atlanta, GA (Onsite/Hybrid)

• Executed data QA daily on patient, insured, insurance, and other
health care data during production to bill 1000+ auto claims
through Electronic Data Interchange (EDI) and fax
• Constructed ML production to classify daily 1000+ auto claims
under first-or-third-party eliminating manual effort spent by 90%+
• Automated weekly formatted reports with supplement visuals for
front-end patient account placement and back-end claims filed
streamlining workload for business analysts by a third

Select Responsibilities:

Architected data ingestion and ETL pipeline for ASC X12
claim responses while communicating troubleshooting
guidance to different departments
• Processed daily 50-100 errors by cleaning
duplicates reducing employees’ resolution time by
at least 40%

• Liaised with clearing house on missing/invalid data
submissions saving weekly 3-4 hours for direct
supervisor
Communicated weekly unique client status reports and led
calls with team of 8 to address data issues
• Resolved daily 15+ missing and invalid accounts
info while automating residual to a report for
management
Developed and optimized scripts daily to streamline billing
of auto claims varying $ 200-20,000 each
• Enhanced data using vendor API to meet clearing
house specifications, such as 5- or 9-digit Zip
format and matching exact insurance names
• Built OCR to extract key information from cheques and W9s reducing manual data entry by 70%

Data Analyst

GeoAlliance Consultants Pte Ltd, Singapore, SG

• Visualize multi-layered financial models with dashboards for P&L items, staffing expenses, revenue studies, new ventures, and routine operations
• Collaborated weekly with IT team to conduct A/B testing for design of company’s publications, website landing page, and previous projects demonstrated through track record
• Provided technical training on GCP capabilities, Linux environment familiarity, and Advanced MS Office skills

Investment Banking Analyst

M Capital Group, New York, NY

• Constructed full-scale deliverables including working group
documents, blind teasers, offering memorandums, and
management presentations
• Built full-scale operating models with three-statement projections
and supporting depreciation, working capital, and debt schedules

 

Select transactions:
High yield ship finance of US$ 247.4MM for a Middle East
ship manager
• Modeled comparables from 27 LTM debt offerings
yielded a 3.3-5.6% coupon rate and a 6.3-8.7x
Debt/EBITDA
• Forecasted cash flow for each vessel type achieving
a Free Cash Flow of US$ 67.3MM over five years
Recapitalization buyout for a US$ 173.3MM Middle East
marine services conglomerate
• Constructed a consolidated financial model for the
three subsidiaries with valuation, debt schedule, and
IRR analysis

Education

2017 - 2019

2014 - 2017

2006 - 2011

MSc Operations Research, Specialization in Analytics and Optimization, GPA 3.7/4.0

Columbia University in the City of New York, Fu Foundation School of Engineering and Applied Science, New York, NY

Select Coursework, Project(s):
Data Analytics, Real Estate Descriptive and Predictive Analysis of NYC
• Cleaned missing values of over 12,000 data using multiple imputation method
• Predicted price per SQFT of a potential house on the market via the lasso regression, decision tree,
and KNN methods
• Implemented Clustering to make recommendations based on client preference variables
Business Analytics, Select Administration of Behavioral Therapy to Probationers

• Selected 15 relevant variables out of 149 influencing the reoffence rate of probationers

• Retrained and refined model to eliminate dependency of outcome on racial factors
• Concluded a cost saving of US$ 508 per person from a sample size of 3,092 probations using predictive analytics

Business Analytics Strategy, Investigating Profitability for a US private cloud-computing provider

• Compared customer value-gap offerings of six select competitors in the US across horizontal, vertical, and supplier markets
• Recommended organic growth and cost-based bottom line strategies based on the company’s referrals approach and dedicated sales force

 

Other Coursework:

Quantitative Corporate Finance; Global Capital Markets; Stochastic Models; Optimization Methods; Derivatives Pricing

BSc Economics, First-Class Honors

London School of Economics and Political Science, London, UK

  • First-year Coursework: Economics B, Statistical Theory, Mathematical Methods (95th percentile), Accounting and Finance (95th percentile)

  • Second-year Coursework: Microeconomic Principles II, Macroeconomic Principles, Introduction to Econometrics, Principles of Finance (95th percentile)

  • Third-year Coursework: Monetary Economics, Problems of Applied Econometrics, Further Mathematical Methods (95th percentile), Quantitative Finance (95th percentile)

Cambridge GCE A-Levels, 8As (99th percentile)

Raffles Junior College, Singapore, Singapore

  • H3 college-equivalent Economics (A), Economics(A),  Mathematics (A), Chemistry (A), Physics (A), General Paper (A), Project Work (A), Mandarin Chinese (A)

  • Raffles Diploma: Merit - Top 20% of cohort in contribution to societies and clubs

Leadership

Oct 2017 - Jan 2019

Oct 2017 - Sep 2018

Oct 2017 - Sep 2018

Jan 2015 - Dec 2015

Jun 2012 - May 2014

Engineering Graduate Student Council, Executive Committee

Columbia Engineering, New York, NY

Treasurer for Student Council:
Manage and approve budget funding of US$ 170,300 per annum for all 13 societies in the Engineering School

http://egsc.seas.columbia.edu

Resident Council, Board of Trustees

International House, New York, NY

Resident Trustee for Programs & Resident Life:
Plan programs and voice issues regarding policies that affect the general resident body

http://www.ihouse-nyc.org

Bible Group Leader, Columbia InterVarsity Team

InterVarsity Christian Fellowship/USA

Bible Group Leader for Groups Investigating Christ (GIC)

https://www.cc-seas.columbia.edu/student-group/intervarsity-christian-fellowship-ivcf

Accredited Student Tutor, Accounting & Finance

The London School of Economics and Political Science

Accredited Student Tutor for "Elements of Accounting & Finance" Coursework

Sergeant, Military Boot Camp

Singapore Army, Singapore, Singapore

• Promoted to Sergeant rank for being upper quartile of cohort
• Exhibited leadership by commanding 30-40 recruits and enforcing regimentation in military boot camp
• Conducted weekly vehicle camouflage lessons for 40-50 trainees regarding three types of military transports

bottom of page