Sql Server Data,SSIS, SSAS,SSRS,T-SQL

Ziyang(Fred) Guo 312-***-****

******@****.***.***

Dynamic IT Professional with 5 years of experience in SDLC and possess experience in Database technologies like MS SQL Server 2012 (SSIS/SSRS/SSAS), Tableau Report, Advanced Excel, T-SQL, Google Analytics (With GAIQ Certification), MS Office within a progressive organization.

Illinois Institute of Technology, Chicago, IL 2012-2014

Master of Public Administration

Guangdong University of Foreign Studies, Guangzhou, China 2008-2012

Bachelor of E-Commerce (Electronic Commerce)

BA Technolinks, Corp. Chicago, IL Oct 2014-current

MS BI Developer (SSAS,SSIS)

SQL Server Analysis Service

Created OLAP cubes, identified dimensions, attributes, hierarchies and calculating measures and dimension

members in SQL Server Analysis Services (SSAS 2012 R2).

Calculated measures and dimension members using multi-dimensional expression (MDX), mathematical

formulas, and user-defined functions.

Created and configured Data Source & Data Source Views, Dimensions, Cubes, Measures, using SQL Server

Analysis Services (SSAS 2012 R2)

T-SQL

Created Stored Procedures, Triggers, Tables, Views and other T-SQL code ensure efficient data retrieval

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production

database code as well as T-SQL code from developers and QA

Wrote T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Cloudeeva, Chicago, IL Mar 2014-Oct 2014

MS BI Developer (SSIS/SSRS)

SQL Server Reporting Service

Designed and deployed reports with cascading parameterized, Drill Down, Drill Through and Drop down

menu option and parameterized and Linked reports using SSRS 2012

Used Reporting Service (SSRS) to generate drill-down and drill-through reports for the default accounts and

the accounts with the higher risk

Deploying and scheduling Report subscriptions using SSRS to generate all daily, weekly, monthly and

quarterly Reports including current status

SQL Server Integration Service

Designed and developed SSIS Packages to extract data from various data sources such as Oracle, and flat

files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations

provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts

T-SQL

Created Stored Procedures, Triggers, Tables, Views and other T-SQL code ensure efficient data retrieval

Wrote T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

National Association of Asia American Professionals, Chicago, IL 2013-2014

Business Analyst

Analyzed the existing tool and participated in meetings with the business users to gather Requirements and design goals of data warehouse. Using MS Visual Studio to build the business entities’ relationship

Created Pivot Table to build two dimensional pivot tables that allowing extracting significance from large data set. Then Created Pivot Chart to visualize the result through clustered column etc.

Council of International Programs (CIP), Chicago, IL May 2013-Dec 2013

Data Analyst Intern

Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns,

eliminated redundant and inconsistent data, normalized tables, established joins and created indexes

wherever necessary

Excellent hands on experience in using Excel to do data analyzing such as what if analysis, correlation,

regression analysis and do data cleansing by using H-lookup and V-lookup.

China Import and Export Fair, Guangzhou, China Mar 2012- Aug 2012

MS SQL Server ETL Developer

Migrated data from Excel Database to MS SQL Server 2012 using OLE DB connection by creating various

SSIS packages and created SQL server configurations for the same

Used various transformations in SSIS like multicast, Fuzzy Lookup, Copy Column

References Available Upon Request

Contact this candidate