Database/SQL/PL/SQL Developer, Data Analyst, System Analyst

Jing Teng Liu

***********@*****.*** 312-***-****

Linkedin: https://www.linkedin.com/in/jingtengliu

Summary

• Two years in manipulating Visio and Microsoft SQL server to design ER-diagrams and implement databases

• Two years in implementing physical databases and using SQL queries

• One year in designing dimensional models and fulfilling ETL processes

• Experience in handling large datasets about 10GB with Hadoop ecosystems on AWS

• Summer internship experience as a software developer intern in a global company in Germany

• Hold the certification, Oracle Database SQL Certified Expert(1Z0-047) starting in Feb. 2016

• Graduation with distinction

Technical Skills

• Programming Languages: SQL, PL/SQL, Python, Shell, Object-oriented programming

• Relational Databases/Data Warehouse: MS SQL Server, Oracle, SQL developer ETL, OLTP, OLAP

• NoSQL databases: MongoDB, Hadoop, Cassandra

• Software: Microsoft Office, Visio, Tableau

Working Experience

Graduate Assistant DePaul University, Chicago Apr. 2016 – Jul. 2016

• Graded papers, programming assignments and lab assignments

• Checked and responded to emai l correspondence with assigned professors Software Developer Intern Ancosys GmbH, Germany Jul. 2015 – Aug. 2015

• Used PL/pgSQL to implement the new triggers in the database

• Integrated the updated database into the current system with Java and Vaadin framework System Testing Engineer Askey, Taiwan Feb. 2012 – Sep. 2012

• Set a testing environment and designed a testing plan

• Analyzed the performance of testing routers and proposed improvement plans Projects

Hadoop ecosystem performance comparison

• Used Amazon web services(AWS) to build a Hadoop Ecosystems including MapReduce, Hive, Pig and Mahout

• Executed MapReduce calculation on 10GB datasets via Python and Linux commands

• Executed SQL queries on HIVE and compared the performance by running time NoSQL database implementation – Chicago crime data analysis

• Set and installed MongoDB on Windows system and Mac system

• Compl ied MongoDB queries on 500MB documents in JSON format (Chicago Crime Data2009-2012)

• Used MongoDB aggregation commands to rank, calculate and retrieve the required documents to do analysis Fulfillment of data warehouse

• Applied Visio to design ER diagrams and dimensional models

• Employed Microsoft SQL Server Integration Services(SSIS) to implement ETL process

• Designed the process condition to filter the source data Video rental store database design

• Imported data and created tables with PL/SQL on Oracle SQL developer

• Used PL/SQL to implement functions providing searching, filtering and updating

• Designed triggers to prevent from inappropriate manipulations Customer ordering application design

• Used Microsoft visual studio to design the user interface and system architectures (windows apps) with C#

• Implemented functions including menu cl icking, transferring dataflow and class object

• Integrated the windows application with database in SQL server to record and retrieve data Education

Master of Science in Information System Sep. 2014 – Jul. 2016

• DePaul University, Chicago, IL, US

Bachelor of Science in Computer Science

• Chang Gung University, Taoyuan, Taiwan Sep. 2006 – Jun. 2010

Contact this candidate