Evelyn Liu Email & Phone Number

2001 6Th Ave, Seattle, Wa 98121

As a big data engineer, I lead a team to build big data analysis services to process business intelligence in real time. Our technology uses NLP to simplify the user interface for querying data. We are responsible for the construction of the cloud database, as well as the platform optimization and update of the exchange. Improve platform security, optimize user data processing, and analyze and mine data.

2001 6Th Ave, Seattle, Wa 98121

Fully involved in ETL process including user requirement collection, data analysis and validation, ETL process design, stored procedure, SSIS Package, Report development, QA testing, performance tuning and maintenance • Communicate with client to collect requirement and design standardized client data questionnaire to improve logic collection process that speed up new client onboarding process by 50%• Build multiple scheduled ETL process with Python that reads, cleans, transforms and aggregates data from Vendor API, flat file to target database • Design and develop stored procedures, views and other database objects to complete data transformation and loading from raw table to destination table• Design and develop common used stored procedure for group to manage database object with validation and error handler that reduce execution errors by 40%• Develop customized interactive reports and dashboards based on user requirement• Perform SQL query performance tuning and query optimization following SQL Best PracticeDesign and develop automation solutions and database applications to improve efficiency and maximize accuracy. Utilize solid design and best technology to quickly create solutions that met immediate needs, yet are flexible enough to grow with business • Involve in all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation and maintenance• Design Robotic Process Automation(RPA) workflow using Auto IT script to capture data, trigger responses and interact with client’s systems, reduce operation time from 8 hours per week to scheduled automatic job• Develop Python and Shell script to facilitate the creation of utilities to automate day-to-day workflows and turn manual process into schedule task

2001 6Th Ave, Seattle, Wa 98121

- Committer for Apache CloudStack and active contributor to the Citrix CloudPlatform product.- Refactored CloudStack API by separating data persistence and data view presentation to greatly improve list performance on large-scale cloud data.- Designed and developed a flexible backup storage object storage plug-in framework to enable CloudStack to systematically manage and configure various types of backup data storage from different vendors, such as AWS S3, Basho Riak-CS, Cloudian, SolidFire, Ceph , NetApp, etc.- Data analysis and data mining for exchange and access management (IAM) systems- Upgrade CloudStack to use VMware vSphere Web Services SDK 5.1 to support all versions of VMware vSphere servers

Building 24, Science And Technology Oasis, Lane 1999,

Fully participate in the overall data management solution, including requirements collection, database modeling, ETL implementation and back-end operation development, to empower cloud-based (Azure) related applications• Design and develop back-end database structure to support cloud(Azure) based application • Create standardized, parameterized stored procedure(T-SQL) with batch loading, error handler and logging management to automate ETL process for huge amount dataset• Build ETL data pipelines that cleans, transforms and aggregates unorganized and messy data into target database• Design and develop stored procedures, views and other database objects to complete data transformation and loading from raw table to destination table• Performed SQL performance tuning by creating index and analyzing execution plan• Develop and maintain SSIS package to support multiple clients and migrate data from raw to final destination• Upgraded code to support restartability and recoverability feature, automatically found the last steps of execution, decided to roll back and redo or continue execution based on option