Yi Angie Wang

Experience

1. Legal Operations Analyst

   J. Zhang & Associates P.C

   Oct 2024 — Present

   Legal Data Management: Designed and maintained structured data tracking systems using Excel and SQL to manage case progress, billing records, and compliance documentation. Implemented standardized data entry protocols and automated reporting templates, enabling attorneys to quickly access key case details, improving data accuracy and operational efficiency. Workflow Optimization: Streamlined legal document processing by implementing automated templates and workflow tracking tools, reducing manual processing time by 2%. Integrated case management software to enhance contract tracking, filing deadlines, and document organization, improving operational efficiency. Process Automation & Reporting: Developed automated tracking and reporting tools using Excel VBA, Power Query, and Pivot Tables to streamline case status updates, filing deadlines, and client intake processes across multiple legal practice areas, including immigration, litigation, corporate business, family law, real estate, and intellectual property. Created customized data dashboards that provided attorneys with real-time insights into pending cases, document turnaround times, and workload distribution, improving decision-making and resource allocation.

Education

• New York University

  Master's degree, Management of Technology

• NYU Shanghai

  Master of Science - MS, Management of Technology

• Washington State University

  Bachelor of Arts - BA, Marketing