Sql Server Mechanical Engineering

Shuokun Liu

*** * ****** *** *** *** Chicago IL *0657, Tel: 201-***-****, **************@*****.***

EDUCATION: Stevens Institute of Technology, Hoboken, NJ 2012-2014

Master of Engineering in Mechanical Engineering GPA: 3.86

Qingdao University of Science and Technology, Qingdao, China, 2006-2010

Bachelor of Engineering in Mechanical Engineering and Automation GPA: 3.10

SKILLS: Microsoft SQL Server Management Studio 2012, 2008R2 (SSMS)

Microsoft SQL Server Integration Servers (SSIS)

Microsoft SQL Server Reporting Servers (SSRS)

Basic Knowledge of Microsoft SQL Server Analysis Servers (SSAS)

Tableau Dashboard 10.1

WORK AND RELEVANT EXPERIENCE:

Mindshare USA LLC, Chicago, IL

Senior Developer (Fulltime Employee)

Jan 2017 NOW

Participate in a full Data Mart development lifecycle including: Planning, Architecture Design, Development, Testing, Migration and Production support

Develop and enhance ETL processes for performance and scalability

Build and optimize SSAS Cubes

Create complex stored procedures to load business data from client into dimension tables and fact tables.

Create Tableau Dashboards and reports

Fix different issues in the development environment and production environment, such as modifying stored procedures, checking source data with step by step.

Design and build highly visible Visualization, Dashboard and reports for both Internal and external clients

Assist and participate in Interacting with the business stakeholders to provide the best solution and insights to their business problems and challenges

Participate in a full Data Mart development lifecycle including: Planning, Architecture Design, Development, testing, migration and production support

Marlabs Inc, NJ

(Client: Mindshare)

Programmer Analyst (Contractor for Mindshare)

Feb 2016-Jan 2017

Build highly visible Data Marts for both Internal and external clients

Develop and enhance ETL processes for performance and scalability

Build and optimize SSAS Cubes

Develop Business KPIs

Create Dashboards and reports

Implement test cases and processes to ensure data quality

Design and build highly visible Visualization, Dashboard and reports for both Internal and external clients

Assist and participate in Interacting with the business stakeholders to provide the best solution and insights to their business problems and challenges

Participate in a full Data Mart development lifecycle including: Planning, Architecture Design, Development, testing, migration and production support

Kacee Technology Services Inc, NY

(Client: Mindshare)

BI Developer (Contractor for Mindshare)

Nov 2015-Feb 2016

Build highly visible Data Marts for both Internal and external clients

Develop and enhance ETL processes for performance and scalability

Build and optimize SSAS Cubes

Develop Business KPIs

Create Dashboards and reports

Implement test cases and processes to ensure data quality

Design and build highly visible Visualization, Dashboard and reports for both Internal and external clients

Assist and participate in Interacting with the business stakeholders to provide the best solution and insights to their business problems and challenges

Participate in a full Data Mart development lifecycle including: Planning, Architecture Design, Development, testing, migration and production support

First Tek (Cloudeeva). Inc, NJ Nov 2014-Nov 2015

BI Developer (Intern)

Help design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.

Schedule and monitor all maintenance activities using SQL Server 2012 including database consistency checks and index defragmentation.

Maintain all records of project status and followed changes as per control procedures.

Generate test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Time Series analysis and forecasting modeling using financial data.

Cost benefit analysis of projects implementations

Masswell Development Group Inc,NY

Aug 2014-Nov 2014

Mechanical Engineer (Intern)

Working closely with design engineers, internal machine shops, and external vendors to ensure specifications are met

Contact this candidate