Information Security Data Analyst

Xiaoxiang (Shawn) Wu

**** ***** ***** **, ******, TX, 75206 469-***-**** ***********@*****.***

SUMMARY

Insightful and skilled business analyst professional with solid educational credentials and professional experience in software asset management, information security and marketing strategy planning. Acknowledged for high- quality data mining, statistical analysis, and database management using SQL Server, SAS, R, and other software. Superior interpersonal and communication skills to enhance the prompt and accurate delivery of quality services with the ability to manage multiple projects simultaneously. CORE COMPETENCIES

Attention to Detail

Business Analytics

Marketing Research

Database Management

Metrics and Reports

Trouble shooting Support

Process Improvement

Flexibility

Strategic Vision

EDUCATION

UNIVERSITY OF TEXAS AT DALLAS Richardson, TX

M.S. in Business Analytics

HARBIN UNIVERSITY OF COMMERCE Harbin, China

B.E. in Mechanical Design, Manufacturing and Automation B.S. in International Economics and Trade

PROFESSIONAL EXPERIENCE

CITI Irving, TX

IT Business Analyst June 2018 – Present

• Managed complex product portfolio ($100 million) to oversee requisition and inventory management for key software vendors (SAP, SQL, Mongo DB, etc.)

• Retrieved and aggregated data from multiple database sources and compiled it into an actionable format

• Reconciled and analyzed product & customer data to generate monthly BAU report to identify trends, help in decision making and recognize cost saving opportunities

• Measured the productivity metrics and dashboard for software usage, suggested and tracked improvements to these metrics

Data Analyst September 2016 – June 2018

• Processed endpoint security software (AppSense) to over 6000 global customers

• Enhanced user process documents to ensure effectiveness and user friendly customer experience

• Developed weekly and monthly metrics for analysis, global reporting and to measure performance

• Consolidated and analyzed user data and generated metric reports for senior management

• Provided information security customer metrics, dashboards, and KPIs for key initiative project RESEARCH PROJECTS

UNIVERSITY OF TEXAS AT DALLAS Richardson, TX

Analytics Practicum January 2016 – April 2016

• Performed logistic regression on 25 million observations and developed a decision tree that predicts with over 85% accuracy whether the customer will receive reimbursement from an insurance provider

• Conducted a RFM (recency, frequency, monetary) analysis and found that Attending Physicians had the highest denial rate and that the top medical service being denied was Surgical Orthopedics

• Applied multinomial logistic regression that most denials resulted from duplicate claims

• Recommended relevant strategies for hospitals to increase net revenue by 1%-2% SKILLS

Analytical Tools SAS (Enterprise Miner), R Studio, MS Excel (Analytic Solver, XL Miner) Programming SQL, SAS Programming, R Programming, STATA Software SAS, SPSS, Tableau, Power BI, MS Office Suite (Excel, PowerPoint, Access, etc.) Database MySQL, MS Access, Teradata

Languages English (full professional proficiency), Chinese (native proficiency)

Contact this candidate