yumin chen

DATA ENGINEER

NYC DOITT•  July 2018 - Present

• Develop and maintain ETL (Extra-Transformation-Load) processes in Informatica, Snaplogic, Python and SSIS • Build Python library for database connection, ftp connection and sending email etc. for whole team. • Create reports using OBIEE 11g • Maintain and upgrade Python scripts to retrieve data from public source, and automate version control with git for OBIEE metadata repository • Migrate on premise data to Azure SQL Database and create Azure Analysis Service • Manage access control and stored procedures in Azure SQL Database and Oracle • Collecting, Analyzing and interpreting data • Reporting the results back to the relevant members of the business using OBIEE (Oracle Business Intelligent Enterprise Edition) • Identifying patterns and trends in data sets • Working alongside teams within the business or the management team to establish business needs • Defining new data collection and analysis processes • Implementing ETL solution using Informatica, Snaplogic and Python • Implementing whole business solution using Microsoft Azure • Establish Airflow for Scheduling ETL processes and build new airflow operators for my organization’s need

City University of New York, Queens College

Computer Science, BE•  September 2012 - June 2018

I joined Army and pause the college for 3 years