Data Engineer

Stephanie Liang

Data Engineer

Kenton, Ohio 419-***-****

*********.******@*****.***

SUMMARY:

I started my career as an Automotive Engineer in Nissan Motor Company, where I developed strong logical thinking and global leadership ability. I made a career switch to Data Engineer in 2019. I worked in a team to build, and test a data platform tailoring to the client’s business needs. I am looking to continue to pursue a Data-related position. SKILLS

Technical:

ETL pipelines, Google Could Platform, PostgreSQL, Python (Pandas, Numpy, Matplotlib), C language, Google Analytics, Google Search Console, Salesforce, Talend, Tableau, Rundeck, TortoiseSVN, Advanced Excel (pivot tables, formulas, V-lookup) Language: Business level Proficiency of English and Japanese, Native Fluency of Mandarin Other: Project Management (2 years), Vehicle Assembly Engineering, Quality Assurance EXPERIENCE:

Brainpad Inc. (Japan), Data Engineer May ’19 – Mar ’20

● Assisted Project Management to define business requirements of Data Warehouse by meeting directly with clients to discuss and understand their business needs.

● Worked on extracting custom data from Google Analytics API, Google Search Console API, and Salesforce API by using Talend (ETL tool).

● Worked on Transforming and Loading data from Google Analytics (10 objects), Google Search Console (2 objects), Salesforce (30 objects), and on-premise (40 objects) into Google Cloud SQL Data Warehouse by creating jobs and writing PostgreSQL queries and Java code in Talend.

● Defined ETL job flow by performing in-depth analysis of all possible risks in Operation and Maintenance stages of the project.

● Created and scheduled ETL jobs using Rundeck (job scheduler).

● Designed Unit Test cases to assure the quality of each ETL job created in Talend.

● Created job definitions, file definitions, and table definitions.

● Connected Data Warehouse with Tableau and generated reports by using Tableau (BI tool).

Nissan Motor Company (Japan), Vehicle Assembly Quality Engineer Apr ’12 – Mar ’19

● Analyzed vehicle raw data and used logical thinking on vehicle assembly troubleshooting such as gap and finish, engine control unit calibration concerns.

● Led project of 7 members in building a new Alliance Quality Assurance Standard of vehicle assembly for Nissan and Renault (Nissan Alliance Company located in France) by analyzing the data of past vehicle assembly concerns while directly collaborating with Renault members by email/teleconference/international travel to France.

● As a Nissan vehicle assembly quality expert, independently conducted monthly teleconferences with engineers from 20 plants worldwide in order to improve each plant’s vehicle assembly quality.

● Traveled internationally to Mexico, China, and France, as well as domestically within Japan to ensure a successful implementation of my team’s new Quality Assurance Standard. EDUCATION:

Nanchang Aeronautics University (China) B.S. (Electrical Engineering) Sep ’05 – Aug ’09 Fukui University (Japan) M.S. (Electrical Engineering) Apr ’10 – Mar ’12

(In Fukui University, I spent 2 years researching index fund investments by using a genetic algorithm I programmed in C)