Edward Lee

adhxi2@r.postjobfree.com 781-***-**** LinkedIn: http://www.linkedin.com/in/EdwardLee1993 Summary

l Possesses 3 years working experience with relational analytics and visualization tools. Has worked within Fintech, Finance, and Capital Delivery domain as a Data Analyst. Has experience in all stages of the Data Analytics lifecycle including Data Collection, Database Design and Build, Data Cleaning, ETL Pipeline Creating, Data Manipulation, Statistics, Modeling, Data Visualization, and Reporting. Skills

l LANGUAGE: Python, R, PostgreSQL, T-SQL, MySQL

l TOOLS: Tableau, Power BI, MS Excel, MS Access, SQL SERVER, SSIS, SSRS l TECHNIQUE: Visualization, Statistics, Data Mining, Predictive Analysis Work Experience

National Grid Waltham, MA

Data Analyst Sep 2019 – Sep 2020

l Delivered and manipulated the data based on different business requirements by using MS Access (SQL query). l Provided the latest information, analysis results, and dashboards to the Capital Delivery team, assuring the budget is under control and the contract specialists have enough information to monitor vendors’ spending. l Analyzed invoice data, forecasted purchase orders for each vendor, queried abnormal spending, and supported the team to gather the required data.

l Created sustainable dashboards/models, such as monthly KPI dashboards and monthly spending dashboards

(Power BI, Tableau, MS Excel), which can automatically update monthly. l Gathered specific value from 20k+ excel files, which are in several different formats, by using MS Excel VBA. l Participated in the construction contractor renew/extension program analyzing the impact of applying a new pricing structure for the next fiscal year which resulted in a net 3% savings in costs. l Participated in T&E Reduction Program: Analyzed abnormal spending which increased from family T&E, adjusted and defined the misused units, and created dashboards for further tracking. l Supported accounting department and contract specialists handling invoices by managing duplicate, invalid, and missing data. (SQL)

Point Focal Boston, MA

Data Analyst Jan 2019 – Jun 2019

l Designed extracting, transforming, and loading (ETL) pipeline from different data sources including SQL Server, AWS (S3) and web-based data sources (API). l Product design module: connected the R or Python ETL Script in Spotfire Server with input and output and ensured script-running stability. Designed and delivered control panel and real-time reporting interface. l Participated in Optimal ATS Program: Analyzed ATS shares liquidity, built a prediction model, and created suggestion dashboards in R Shiny. Created a multiple radar chart in R, supporting users to compare the performance between each ATS and select the optimal ATS for stock trading. l Analyzed investor behaviors, such as preference industry, and delivered the insight to the marketing team, allowing the team to target investors to improve subscription and retention rates. l Provided business dashboard reports for supervisors, business analysts, and clients to support business strategy decision-making processes in different fields such as financial activity reporting and post-market surveillance. Xiamen Bank Xiamen, China

Analyst Intern Jan 2015 – Jun 2015

l Gathered and manipulated internal loan data and created KPIs dashboard in Excel in order to monitor and highlight potential credit risks.

l Loanee Behavior Analysis Program: Analyzed loanee behavior, providing useful insights in order to decrease risk and modify loan approval matrix.

l Maintained, evaluated and managed enterprise credit assessments for sub-branches to ensure data accuracy across reports.

Education

Northeastern University Boston, MA

Master’s in Analytics (Concentration: Evidence-Based Management) (GPA 3.822) Sep 2017 – Mar 2019 Fu Jen Catholic University Taipei, Taiwan

Bachelor’s in Finance and International Business (Concentration: Finance) Sep 2011 – Jun 2015