Anna Liu Email & Phone Number

Buffalo, New York, United States

Structured analytics report based on ad-hoc request and pulled data using SQL. Played a key role in the 2023 database migration project, converting Hadoop scripts to SQL Server, ensuring integration, optimizing scripts for improved performance and addressing runtime constraints. Developed and managed tools for clinical operations. In response to observed needs, proactively developed the "Providers’ Patient List" self-service report, enhancing efficiency and unifying format in patient contact for intake teams, and requesters. Contributed to optimizing data sources, organizing documentation, and sharing helpful query as a team member. Actively participated in knowledge-sharing sessions, such as sharing insights on advanced SQL techniques, enhancing team efficiency and expertise.

Buffalo, Ny

Analysed bank account histories and status on clients' system platform for fraud patterns and verified fraud claims. Achieved apartment's top 3 with 100% accuracy on claim decisionCommunicated about fraud patten and account claims, suggested actions on investigation method and procedure.

Beijing China

Implement social media marketing plan and organized events to identify potential customersUsing Excel to manage customers information and analyzed user portrait with Pivot table and visualizationPerformed projects tracking to identify potential issues and opportunities with time manage reports. Identify potential problem and summon meetings for solutions

Beijing

Communicated with product-development partners to conduct competitive analysis (SWOT and Porter's Five Forces Model) Presented product information to clients, physicians, and hospital management team, demonstrated market data visual using ExcelManaged cross-functional department and stakeholders communication and foresaw potential problems on conference and presentation events with alternative solutions

Beijing

Audited clients financial reports with Excel model and tools, in charged for cash balance, account receivable, account payable and PP&E. Successfully located a falsely recorded large-amount-transaction on account receivableRequested and managed inquiry letter from bank and verified the balance with clients financial reportsPrepared slides for presentation with information and suggestion given by auditor in charge

Master Of Science - Ms, Business Analytics, 3.8

Coursework: Model Managerial, Predictive Analytics, Statistical Analytics, Data Visualization

Bachelor Of Science - Bs, Economics And Finance

Activities and Societies: Student Union Career Development Center, School of management, Tsinghua university