Cecily Chen 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, Yishan Road, Minhang District, Shanghai

Fully involved in overall data management solution including requirement collection, database modeling, ETL implementation and backend operation development to empower cloud (Azure) based healthcare related application • 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

4309 Emperor Blvd, Durham, North Carolina 27703, Us

•Created, prioritized, and executed test cases based on business requirements, product design specifications, and wireframes for Java-based Online Billpay web application.• Developed functional automation testing scripts using Rational and Mercury testing software, and assisted management to develop the direction and policy of automation testing.

4309 Emperor Blvd, Durham, North Carolina 27703, Us

- Worked closely with Quality Analyst teams to analyze, design and implement the requirements- Designed and implemented test case for black box and white box test- Generated testing report for developing team- Hands on experience in loading test result into database and analyze testing result

Master Of Science - Ms, Data Science

Bachelor'S Degree, Computer Science