Chengqi Xie

adwoga@r.postjobfree.com (***) *** – ****

EDUCATION

Fordham University New York, NY

Master of Science August 2022

Business Analytics with Certification in International Business Shandong University of Finance and Economics Shandong, China Bachelor of Science May 2020

Computer Science and Finance

SKILLS

• Proficient with SAS, Python, Tableau, SQL, pandas and Microsoft Office Suite (Word, Excel, and PowerPoint)

• Excellent in Business Analysis, Supply Chain Management, Budget Management, Data Analysis, Data Mining, Data Visualization, Statistic Analysis, Financial Statement Analysis, Marketing Analysis, Machine Learning, Research, Project Portfolio Management, Programming, Project Management, Presentation, Problem Solving, Collaboration, and Communication

• Fluent in Chinese (Mandarin) and English

PROFESSIONAL EXPERIENCE

Clinpharma Clinical Research LLC New Jersey, NJ

SAS data analytics 12/2022 – Now

• Assisted to create SAS datasets for in-house post _hoc statistical analysis and used SAS data steps for large data processing for different project.

• Worked under supervision of senior SAS developers to manage large volume of structured and unstructured data as well as extracted and cleaned data to make it amenable for analysis.

• Create and maintain SAS programs to produce outputs to support the analysis and reporting.

• Identifying inconsistencies in the source data and report findings to the project lead.

• Document all the SAS programs developed and maintain documentation of the data as needed.

• Reviewed the existing SAS program and compared the SAS codes to identify the code logic difference.

• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/NETDRAW and SAS/MACROS for statistical analysis and data display.

Shandong Port Group Shandong, China

Finance Supply Chain Demand Analyst 09/2020 – 08/2021

• Ensured supply chain platform implementation success by analyzing client needs, designing user interface, building critical functionalities, preforming user acceptance testing, and supporting implementation integrations

• Served as a liaison between the technical development teams and clients to ensure project timeline and scope were on track. Successfully ensured the on-time and smooth delivery of supply chain solutions

• Provided strategic recommendations to the business through performing data analysis including data mining, hypotheses formulating and testing, and correlation analysis

• Delivered revenue forecasting analysis for the following year by conducting data gathering, data cleaning, data cataloging, and data modeling

• Contributed to client’s financial excellence by increasing revenue by 15 billion in Chinese Yuan within 1 year

• Queried target trading history in SQL and manipulated different table to improve efficiency for 10% Fordham University – Long Island Housing Price Prediction New York, NY Team Leader 09/2021 – 05/2022

• Extracted, compiled, and cleaned 10 years of real estate data from Zillow’s database utilizing Python PyQuery

• Collaborated with team members in building high quality data models through applying logistic regression, lasso regression, and Heatmap. Achieved 80% accuracy in pricing prediction

• Ensured project success by prioritizing maintaining effective communication within the project group

• Presented story telling data visualization using Python and received excellent feedback from professors and peers Fordham University – Deloitte March Data Crunch Madness Competition New York, NY Team Leader 01/2022 – 04/2022

• Guided team members in understanding the project strategy, challenges, and goals by translating business problems into analytical solutions

• Oversaw strategy design, project planning, scoping, resources allocation, and priority management for the team

• Developed, compared, and improved data models by creating and synthesizing different variables utilizing 5 different models including logistic regression, naive bayes, support vector machine, random forest, and XGBoost China Everbright Bank Shandong, China

Client Manager 07/2020 – 09/2020

• Assisted over 50 clients with ongoing financial planning and facilitated their purchase of financial products

• Guaranteed excellent customer experience by providing customers with detailed and comprehensive stock market analysis and recommendations

Contact this candidate