Data Sql Server

Catherine He

th

Address *** *** *** ****** ** Bellevue, WA 98005

Contacts ***************@*****.*** 518-***-****

SUMMARY

• Experienced in SQL Server Development and BI development with extensive knowledge in

OLTP, OLAP, snow/star schema.

• Proficient in creating, modifying, and managing relational databases, multidimensional

databases, and data warehouse.

• Extensive experienced in managing large amount of data with table partitions, writing

complex T-SQL queries and sub-queries to retrieve information from multiple tables with

millions of rows and linked server.

• Professional in creating different types of indexes, stored procedures, user-defined functions,

views, temp table, CTE and so on in SQL Server management studio.

• Experienced in creating ETL packages, data quality process and improve ETL performance

to transform millions of data into defined places using SSIS 2008/2012 and do large amount

data extractions and loading with insert/update/delete operations.

• Expert in using Microsoft Excel, Power BI tools like Power Pivot and Power View to analyze

data with virtualization and create Pivot tables with KPIs, calculated columns, slicers,

hierarchies and charts etc.

• Excellent in creating reports and dashboards using Tableau and Qlikview to achieve data

virtualizations.

• Excellent in designing multi-dimensional cubes using SSAS with fact tables, dimensions and

measures, hierarchies etc.

• Professional in writing MDX queries with various functions and filters to retrieve data from

cubes.

• Excellent in creating drilldown reports, drill-through reports, matrix reports, parameterized

reports, graphical reports using SSRS 2008/2012 for advanced business analysis.

• Professional in using Hadoop Hive to extract data and analyze data.

Education:

Rensselaer Polytechnic Institute, Lally School of Management and Technology, Troy, NY

Master of science in Management, concentration in Information System GPA: 3.50 09/2013 –

05/2014

University of Xi’an Jiaotong, Xi’an, China

Bachelor of Information Technology, GPA: 3.70, 09/2008 -06/2012

Technical Skill

T-SQL, SQL Server Management Studio (SSMS) 2008/2012, Microsoft SQL Server Integration

Services (SSIS) 2008/2012, Microsoft SQL Server Reporting Services (SSRS) 2008/2012,

Microsoft Server Analysis Services (SSAS) 2008/2012, Power Pivot 2013, Power View 2013,

Tableau, Qlikview, Hadoop Hive, Google Analytics, Onmiture, DAX, MDX, MS Excel, MS

Power Point, MS Word

PROFESSIONAL EXPERIENCE

Cloudeeva, East Windsor, NJ 05/2014-11/2014

BI Developer internship

Responsibilities:

• Involved in creating and optimizing employee information databases using SQL Server

Management studio and generating business requirements.

• Created stored procedures, clustered and non-clustered indexes. Wrote complex T-SQL

queries such as sub-queries, temp table, CTE, to retrieve data from large tables with millions

of rows.

• Designed ETL processes to perform bulk insert and large amount data extractions using

lookup transformation and conditional split transformation data using SSIS 2012.

• Created drilldown, drill through, matrix reports with parameters and filters to display

company employees’ information using SSRS 2012.

• Created SSIS packages and use foreach loop container to load groups of flat files into SQL

Server databases.

• Created Power Pivot reports with slicers, hierarchies, measures, KPIs, charts on daily basis.

• Created dashboard virtualizations using Tableau and Qlikview to read data in meaningful

ways.

• Built OLAP cubes using SSIS 2012 and wrting MDX queries to retrieve information and

analyze data.

• Involved in designing data model, data warehouse structure and optimizing the databases.

Bank of China, Shannxi Branch 07/2011-08/2013

SQL Server Developer and BI developer

Responsibilities:

• Gathered requirements from business analysts, built customer information data model and

data warehouse based on these requirements.

• Created financial reports with various data virtualizations using Tableau and Qlikview.

• Created table partitions, stored procedures, functions, indexes, views and modified existing

code to produce accurate results for meaningful uses.

• Created dynamic SSIS packages for data integration from Flat Files into SQL Server

databases using Foreach Loop Container.

• Created financial product reports and customer payments reports with drilldown, drill

through, matrix, charts, virtualizations and parameters using SSRS 2012 and Tableau.

• Used SSIS 2012 to create complex ETL processes involving variables and expressions for

various control flow options and data flow transformations, such as Conditional Split,

Derived Column, Lookup, Union All, Sort etc.

• Created OLAP cubes by importing data from multidimensional databases and defining its

dimensions, attributes, measures, calculations, and hierarchies using SSAS 2012.

• Communicated with users, managers, and other resources in conceptualizing and developing

reports and analytical tools that meet their needs

• Created sales performance dashboard with filters using Tableau, Qlikview.

Project Experience 02/2014-05/2014

The project was about creating the RPI student information management system, and analyzing

the RPI students’ employment rates and students performance, such as GPA, with different

backgrounds, cultures, majors, courses and so on. I worked in a team and was mainly

responsible for creating students performance reports with various visualizations using Tableau

and creating Power Pivot reports with KPIs and measures. I created a summarized report in

dashboard to explain the relationships of students’ performance with possible factors.

Contact this candidate