Business Analyst, Data Analyst, Data Analytics, Database, SQL, Python

Weiting Chen

*S, *** Main Street, New York, NY, *0044 +1-929-***-**** *************@*****.***

SKILLS

Languages: Python, R

Database: SQL, MySQL

Strengths: Linear Regression, A/B testing, Predictive Modeling, Data Visualization, Regression Algorithms, Classification Algorithms, Clustering Algorithms, Data Preprocessing, ETL process, Relational Database, Project Management, Agile

EDUCATION

New York University New York City, NY

Master of Science in Management and System

09/2016 – 09/2018

Tianjin Foreign Studies University Tianjin, China

Bachelor of Literature in English (International Journalism) 09/2018 – 06/2015

Graduated with 3rd Class Scholarship

WORK & LEADERSHIP EXPERIENCE

Business Analyst Intern Sep 2018 – Now

North Windsor Inc Princeton, NJ

• Collaborated with financial reporting and IT team to develop initiatives and strategies that optimize client’s business goal

• Conducted meetings with clients, stakeholders and technology team for business requirement discussion, responsibilities clarification and project schedule alignment

• Monitored operational dashboards and coordinated across project deadlines, responsibilities, stakeholders, IT staff and agencies to ensure a successful transition to new system

• Maintained system program for data extraction, validation, data manipulation, presentation, and reporting

• Edited testing documents and assisted in debugging according to the business requirements Marketing Analyst Intern Feb 2017 – May 2017

Shoo-in, LLC New York City, NY

• Conducted research, gathered data of customers, competitors and market condition and analyzed demographic characteristics in customer profiles

• Converted complex customer data into tables and visualized graphs in Excel based on business requirements

• Developed marketing strategies, defined operational metrics and expanded promoting channels through online campaign, speech, online course, and campus tour activity

• Monitored marketing budget distribution, measured ROI of online and offline advertising campaigns and reported on marketing KPIs including leads, conversion rates, website traffic and social media engagement

• Coordinated with third-party marketing agencies and negotiated contracts with business partnerships

IT Consulting Analyst Intern Oct 2014 – Mar 2015

Accenture (China) Co., Ltd Beijing, China

• Participated in the digital marketing transformation project for the biggest diary SOE in China – Mengniu Diary Co., Ltd. that strive to achieve seamless customer experience and drive the integration of intelligent customer habits tracking monitoring

• Diagnosed business problems in E-commerce development process, gathered requirements, leveraged analytics to determine the key influential metrics, designed IT imperatives, delivered technology innovation, and implemented solutions that support client’s business requirements and strategic plan

• Led project intern team, assigned tasks and deadlines, and micromanaged the project delivering

• Reported on weekly project achievements, existing problems and future plan and gave presentation to internal teams, clients and agencies

• Involved in full testing cycle: identified testing requirement; assisted in tracking data migration progress; participated in UAT and SIT in Agile project environment; continuously revise testing docs; performed connection testing and tested new functions on integration platform and QA environments; debugged and tracked with Techs with multi-products

PROJECTS

Database Design for Ritz-Carlton (Oracle SQL Developer Data Modeler, MySQL) Sep 2017 – Nov 2017

• Suggested the company’s business model, business problems, business goal and end-users of the database to decide the deliverables of the database

• Identified the enterprise data models, entities, attributes in each entity, relationship and cardinalities between entities according to the business requirements and rules

• Constructed conceptual enterprise data model by Oracle SQL Developer Data Modeler

• Converted the conceptual data model into logical E-R diagram filled with attributes including primary key, foreign key and data type in each entity

• Constructed physical data model in MySQL by using SQL scrips to create tables, relationships, and insert data

Apple Store Profit Optimization (Python, A/B testing) Feb 2018 – Mar 2018

• Identified potential monetization opportunity to improve total revenue by around 5%

• Analyzed user’s historical behavior and performed actual purchase funnel through exploratory data analysis in Python

• Discovered strong correlation between user conversion rate and form of payment

• Set up experiment with case/control group and built A/B test in store purchase flow by building interactive and scalable Python dashboard and calculating statistical significance to measure the impact

• Derived 10.7% increase of revenue in case group and made recommendation of running experiment to incentivize user to purchase gift card

Real Estate Price Estimate for Zillow (R) May 2018 – Jul 2018

• Verified and imported real estate data collected from Zillow’s website

• Conducted exploratory data analysis to understand data distribution, volume of missing values and correlations

• Built regression models to predict real estate price and identified important features that impact the price using R

• Analyzed residual plot to detect violation of assumptions and added transformed features to improve model performance

Credit Card Fraud Detection (Python, Classification Algorithms) Sep 2018 – Nov 2018

• Validated and imputed Credit Card Transaction Records collected from external resources

• Performed exploratory data analysis (EDA) to check the data distribution

• Checked missing values and implemented data preprocessing, including outlier identification and imbalanced data analysis

• Conducted feature density plot to observe the distribution of different features for legitimate and fraudulent transactions and decide the good selectivity

• Built different classification algorithms to observe the feature importance and predict fraud transaction

Contact this candidate