• Design workflow process and dashboard prototype for management team to streamline servicesand set up quality and timeliness metrics measurements. Communicate complex ideas with dataanalysis to leadership and clients to improve quality and efficiency of data collection and delivery.• Prepare comprehensive health care information analysis by using SQL skills to create ad hocreports for internal and external customers on utilization trends, financial performance, qualitymanagement, etc.• Evaluate data from various sources and identify patterns and trends to solve various businesscases and provide root cause analysis and insights for data-driven decision making.• Design, develop and implement the automation solutions for reporting purpose.• Design ETL processes and develop source to target mappings by using Alteryx.• Design and develop Coaching Moment Tracker by using MS Access and VBA to track problemsfound in customer service processes and improvement progress with internal training program.• Build detailed data test plans and data integrity reports to ensure data quality for providersystem implementation.

Collected, documented, analyzed and translated customer business requirements intospecifications.• Led the ERP installation and implementation projects for customers in retail industry. Developedproject scopes and objectives, built a detailed project plan to track progress and coordinatedinternal resources and third-party vendors for project execution.• Designed and developed reports using Power BI for business analysis. Mapped and migratedmaster data from legacy system to new system for both UAT and Production environments, andmapped tables, views, and store procedures based on the specifications with SQL.• Worked with technical resources to provide insight during solution development and documentfunctional test scenarios and UAT plan and criteria.• Actively managed and participated in weekly client meetings to determine areas of improvementwithin current programs, proactively identify potential problems and devise effective solutions,and facilitate deliveries of milestones to smooth the processes, ensuring common goals andcustomer satisfaction.

• Collected requirements from focus group and designed algorithms through analysis for Androidapplication, and developed test scenarios and tested application performance.• Collected and processed questionnaire answers and conducted ANOVA analysis with SPSS forExergame project.

• Created unit test documents and systematically tested system performance according tospecifications.• Gathered requirements from travel agency clients and created design documents used for ERPcustomizations.• Used T-SQL and self-developed tool to process master data and import data to productionenvironment.• Implemented and configured Microsoft Dynamics AX 2012 for training. Provided solutions andmade demonstration for master data management.

Cooperated with IT department to analysis wholesale business process, designed an internal system to facilitate Credit Application Guideline checking from the manual CA-inputting and analyzing process into a computerized process; optimized the internal and external audit process and avoided potential risks. Established wholesale database to set up a benchmark to evaluate new dealers according to the data provided by dealers and comprehensive marketing data.Managed transactions of financing applications of dealers; analyzed and rated the debt feasibility, repayment period and default probabilities of dealers according to the balance sheets generated by the systems and determined the length of inspection period about dealers according to financial condition; concluded finance analysis and forecasted credit risk; oversaw financing operations of 16 dealers and 3 groups. Made weekly department work report to department head; monthly credit limit report to General Manager.

Searched order information in Asia via the LOOM system; reported the sales data to finance controller and helped with budget plan. Helped sales team make sales campaigns; collected sales information via existing channels and determine the price for long-reserved cars. Compared the financial products between Volkswagen Finance and Ping’an Bank; facilitated cooperation with Volkswagen Automobile Finance and develop long-lasting partnership; designed the special financial product for Lamborghini. Took charge of the venue arrangements such as Group Night and Press Conference and the service of the MIP of Lamborghini Italy in the 15th Shanghai International Automobile Industry Exhibition.