← All profiles

Anna (Yating Li) Lee

IT Consultant - Associate Director

📍 Los Angeles Metropolitan Area1 connections1 followersphoto: yes#253 · navid-aub

Skills (3)

MySQLPerlVisual Basic .NET (VB.NET)

Experience (5)

  • Workplace
    STRV
    Role
    IT Consultant - Associate Director
    Duration
    Nov 2021 - Present · 1 yr 3 mos
    Workplace Location
    Description
    IT change management/ IT transformation project • Assisted in reorganizing a leading technology company’s IT department and developing new IT strategies to prepare a merger/acquisition.• Assisted in redeveloping the organizational chart and due diligence guide.Financial risk and compliance project• Analyzed customer information for a global bank to assess money laundering risks.• Conducted due diligence on customer background information, and data analysis on customer financial transactions to look for trends and patterns, to identify high-risk customers.Customer Information System (CIS) implementation project• Assisted data migration/conversion work stream. Developed SQL scripts to extract client data for validation purposes and to host small data sets on the cloud to facilitate testing/training.• Business analyst on reporting work stream to support business report development. Managed client report inventory (Crystal and Oracle OBIEE 10g reports) and interviewed report users across business units and ranks to gather requirements.• Assisted report specification development (OBIEE 11g, BI Publisher) and data warehouse redesign.Healthcare regulatory reporting automation• Performed current state analysis to understand client’s existing reporting capabilities and processes by conducting client interviews and reviewing gathered documentation.• Developed use cases for operational metrics reporting to support regulatory reporting needs.• Designed and created a demo data quality dashboard using mock data as a prototype to demonstrate the capabilities of the BI system (MicroStrategy) to be implemented.SAP ERP implementation• Assisted the data team of an SAP implementation for a large global company, on tasks such as data validation, data cleansing, data management, etc.
  • Workplace
    STRV
    Role
    Data center operation and maintenance engineer
    Duration
    Mar 2020 - Feb 2022 · 2 yrs
    Workplace Location
    Description
    • Lead a team of managers and engineers to maintain end-user uptime in B&M and WAH environments.• Develop support plans, Service improvement plans planning, and IT budgeting in alignment with overall IT strategy.• Lead the functional delivery team of highly available and scalable end-user IT infrastructure and end-user services (eg, network, telecom, data center, cloud computing, 24x7 system monitoring, remote & onsite tech support, device management, access management, asset management, and patching)• Contribute to and ensure adherence to IT governance and compliance processes• Lead the selection, implementation, and management of IT Service Management technologies and associated service catalog• Develop and lead IT end-user support management processes to ensure the appropriate cross-functional internal and vendor resources are engaged, timely service restoration, and drive the remediation action plans• Implement structures to proactively identify and remediate service continuity risks• Work through internal and partner resources to proactively drive continuous technology, service, and process improvement• Ensure infrastructure and end-user technologies and services are deployed and maintained in a secure manner and meet client requirements.• Lead the development, implementation, and maintenance of standards and processes to ensure services are well-defined, effective, and efficient• Front-end client and internal compliance audit and associated requirements.
  • Role
    Assistant Director - Senior Software Engineer
    Workplace
    Ali Cloud Investment · Full-time
    Duration
    May 2015 - Feb 2019 · 3 yrs 10 mos
    Workplace Location
    Hangzhou, Zhejiang, China
    Description
    • Responsible for helpdesk related work。• support for the national office intranet user operating system, including troubleshooting, • installation and configuration, • responsible for the connection of network requirements, technology selection, • network planning and implementation of each branch and subsidiary.• Responsible for monitoring and maintaining the company's intranet, • and providing services to ensure its normal operation. • Responsible for network architecture design and optimization. • Troubleshooting, summarizing problems, • and writing operation and maintenance automation scripts. Responsible for the establishment and maintenance of internal services. （AD Domain Controller, DNS, Group Policy, Shared Folders, NAS, Authentication, Access Compliance, Proxy, Crawler, VPN, etc.）
  • Workplace
    Alibaba Group
    Role
    Database Administrator
    Duration
    Apr 2013 - Jun 2015 · 2 yrs 3 mos
    Workplace Location
    Description
    • Manage/configure database servers/clients including SQL Server 2008R2/2012, Oracle 10g/11g and MySQL on Windows, Linux and OS.• Design/review logical and physical database structure and conduct database installation, configuration and security control.• Automate database routine backup/restore and data migration using SSIS and SQL Agent.• Perform database tuning including indexes creation, SQL queries optimization, memory/disk management, tempdb isolation.• Perform database monitoring/maintenance using tools including Windows Performance Monitor, SQL Profiler and SQL Sentry.• Design data warehouse to assist reporting, including building and deploying cube using SSAS.• Manage disaster recovery database server by database replication and transaction log shipping.• Co-operate with and provide technical support to project teams and associates.
  • Workplace
    Alibaba Group
    Role
    Operations Engineer Assistant
    Duration
    Apr 2012 - Apr 2013 · 1 yr 1 mo
    Workplace Location
    Description
    • Linux server maintenance• Shell script development• Participate in project implementation and training services• Responsible for system demand research and later system operation and maintenance services, etc• Research and focus on Chia project ecology

Education (2)

  • Institute
    Yale University
    Degree
    Master's degree, Computer Science
    Duration
    2009 - 2011
    Description
    Grade: 3.91/4.00
  • Institute
    Chongqing University
    Degree
    Bachelor's degree, Computer Software Engineering
    Duration
    May 2005 - Jul 2008
    Description
    Grade: 3.89/4.00

Interests (4)