Sql Server Data
Resume:
Jolin Sun
Business Intelligence Developer
Atlanta, GA 30041 Email: *****.***@********.*** Phone: 412-***-****
BI developer with more than 6 years’ experience of SQL Server 2008/2012, Oracle 10g/11g, Access 2007/2010 database and Data Loading and Reporting tools such as: SSIS, SSAS, SSRS and Crystal Reports 2008/2011.
Hands-on experience of most advanced SQL Server 2008/2012 Database server installation, login and user creation, role and permission configuration with an emphasis on T-SQL, stored procedures, functions and optimization.
Strong data management and reporting experience on quantitative analysis, including report migration from Crystal Reports to MS SSRS.
Professional experience on loading a variety of large volume data files from different sources into SQL server 2008/2012 database tables, migrate Oracle tables into SQL Server 2008/2012 database tables and generate Report with SSRS and Tableau.
Experience on high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including designing extraction, transformation, and load(ETL) process for star schema data warehousing.
Strong team player with great verbal, written communication and interpersonal skills. Proven ability to approach problems effectively, prioritize and complete multiple tasks. Quick learner, take initiator, and hard worker.
SKILLS
SQL Server, Oracle, Access, Microsoft BI stack(SSIS, SSAS, SSRS), Tableau Desktop, SAP Crystal Reports 2008/2011, Excel VBA, Visual C#, Visual Basic, Microsoft Project, Outlook, office suites, TFS(Team Foundation Server), GIS(Geographic Information System), Adobe Design Suites(Photoshop, Illustrator, Indesign) etc.
Business Intelligence Developer
January 2015 to Present - Architectural and Engineer Company - Atlanta, GA
Create ETL packages using SQL Server 2012 SSIS Designer to extracted data from multiple sources reformat the data and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio(BIDS).
Develop projects using SQL Server 2012 SSAS, created data source/data source view/cube with measures and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using MDX.
Collect business requirements from interior and exterior users, generated a variety of business reports using SQL Server 2012 SSRS and Tableau including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server.
Design new database for plotting project, create database tables with various constraints including primary key, foreign key, etc. Loaded data from flat files into SQL Server 2012 database tables using bcp, bulk insert and and table export/import. Worked closely with the application developers to achieve the automation of plotting and saved half of the project plotting budget.
Business Intelligence Developer
August 2013 to May 2014 – Carnegie Mellon University - Pittsburg, PA
Worked in the data team to monitor, Error handling, trouble shooting of ETL process in data warehouse for the payroll department. Extracted OLTP data, clean and reformate data and transfer data through several staging tables to destination tables. Incrementally load data to dimension tables using slowly change dimension, CDC, control table, T-SQL and visual C#.
Work on distributed SQL server. Loaded large volume Excel files, XML files and flat files from different departments into SQL Server 2012. Manage metadata, create views, stored procedures, user defined functions, indexes in database.
Migrate more than 100 reports from SAP Crystal Report, excel to SSRS, created features, parameters and filters in SSRS.
Business Intelligence Developer
January 2012 to July 2013 – Shanghai MIIIS Group - Shanghai, China
Shanghai MIIIS Group is a large digital company. I worked in this company to gather data from 5 business districts and worked closely with the managers from different departments. I gathered business requirements from interior and exterior users to generate ad hoc and weekly, monthly, quarterly, yearly reports for Sales, Marketing, HR and financial departments using MS Excel, Tableau and SSRS.
Load data from flat data files and excel sheets into Oracle database using SQL*Loader and SQL Developer. Use advanced SQL queries with multi-table joins, group functions, subqueries and CTE.
Business Intelligence Consultant
January 2011 to November 2011– Anran Top Wood Industry - Shanghai, China
Anran Top Wood Industry is a large floor company. I worked in this company as a Business Intelligence Consultant to build data warehouse in the IT support team. I created the fact tables and dimension tables. Created 30 SSIS packages and design the parent-children pattern.
Data Analyst Consultant
March 2011 to June 2012– SMIC Private School - Shanghai, China
Created variety of tables in SQL server 2008R2 including student tables, teacher table, department tables, courses tables etc. Loaded data from excel and access to SQL server.
Data Analyst Consultant
June 2009 to June 2010– Zhejiang Solid Building Decoration Engineer co., LTD - Hangzhou, China
Collect requirements from interior users and generated reports using excel with Vlookup and pivot table. Imported excel files to access. Come up with creative solutions for feature engineering and storage; make data from various sources easy to access.
EDUCATION
Pursuing second Master degree in IT Project Management in Harrisburg University 9/2015-8/2017
Master of Science from Carnegie Mellon University. 2013-2014
LANGUAGES: English & Chinese
REFERENCES: Available upon request
JOB LOCATION REQUIREMENT: Ok to relocate
Contact this candidate