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
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
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