Sql Server Data

JUNQIAN GUO

*** ********** ****, ***# **, Oak Park, IL 60302

Cell: 708-***-**** **********@*****.***

OBJECTIVE Business Analyst / Financial Analyst / Report

Developer/ Database Analyst

SUMMARY

? M.S. Of Finance with more than six years experience of

SQL Server 2008, Oracle, Access 2007 database and Data Loading and

Reporting tools such as: SSIS, SSRS and Crystal Report 2008.

? Strong data management and reporting experience on quantitative

analysis.

? Experience on database Management, such as SQL Server

2008 Database server installation, login and user creation, role and

permission configuration.

? Load variety of large volume data files into SQL server 2008

database, migrate Oracle tables into SQL Server 2008

database tables, and generate Report with SSRS.

? Experience on high performance data integration solutions-

Microsoft SQL Server Integration Service (SSIS), including

extraction, transformation, and load (ETL) packages for data

warehousing.

? Strong MS Access and Excel skills with Pivot tables.

? Team player with great verbal, written communication and

interpersonal skills.

? Proven ability to approach problems effectively, prioritize and

complete multiple tasks.

? Quick learner, hardworking, and strong sense of responsibility.

SKILLS

Technical Skills:

Database: SQL Server 2008, Oracle, SSIS, Access 2007, SAS 8.2, SAP

R/3

Reporting: Access 2007, SSRS, Crystal Report 2008

Language: SQL, T-SQL,PL/SQL, Excel, Visual Basic, C

Network: MS SharePoint, Novell V4.3

MS Office: Word, Excel, PowerPoint, Access

Team Skills:

Managed 6 people in finance department and support more than 200

employees in Mutual

Fund; Managed 11 people in IT department and support more than 600

employees in

Securities Company

Participated in hiring new IT personnel

Promoted Company social interactional

Managerial Skills:

Negotiated and solicited bids from vendors to ensure cost savings

Participated in company budget management

Work Experience

+ Database Developer / Software Developer / Business Analyst

Twenty Four Consulting Group, New York

08/2011 --- Present

Used SQL Server Integration Services (SSIS) tool including: Used SQL Server

2008 SSIS Designer to create ETL packages, such as: extract, reformat, and

insert data from flat file into fact table; Loaded different types of

dimension and fact tables into data warehouse; Deployed SSIS packages or

solutions into production system.

Used SQL Server Analysis Services (SSAS) tool including: Created data

source, view, and cube with measure or dimensions, configured attributes of

dimension table with hierarchy relationships; Modified cube or dimensions;

Deployed KPIs on SSRS and created different metrics; Added new measure

groups and dimensions; Created data-mining solutions in BIDS; Deployed

solutions to SSAS instance; Drained the model and queried the model using

DMX.

Used SQL Server Reporting Services (SSRS) tool including: Generated

variety of business reports, such as: 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 and SharePoint; Built Performance Points

Dashboards in SharePoint 2010.

Used Oracle SQL 10g/11g/11gR2 database and configured parameter files to

adjust the memory usage and file size.

Used T-SQL or PL/SQL functions and advanced SQL queries with multi-table

joins, group functions, subqueries, set operations.

Used Crystal Report 2008, sql query, Excel 2007 to generate variety of

business reports.

+ Financial Analyst

First-Trust Fund Management Co., LTD, Shanghai, China

01/2007 --- 06/2011

Use SQL Server Business Intelligence Development Studio (BIDS) including:

Created database tables with various constraints including primary key,

foreign key, etc.; Loaded data from flat data files into SQL Server 2008

database tables using bcp, bulk insert, and table export/import; Loaded

data from flat data files and excel sheet into Oracle database using

SQL*Loader and SQL Developer; Extracted data from SQL Server 2008 database

tables and Oracle database tables into flat data files and Excel sheet.

Used SQL*Loader and SQL Developer to loaded data from flat data files and

excel sheet into Oracle database.

Used SQL, T-SQL or PL/SQL get queries with multi-table joins, group

functions, subqueries, set operations.

Used sqlplus, Excel, SSRS SQL queries to generated variety of business

reports.

Used SSRS, Crystal Report 2008, Excel 2007, and SQL Server 2008 sql query

to generate variety of business reports.

+ Quantitative Analyst

First-Trust Fund Management Co., LTD, Shanghai, China

01/2005 --- 01/2007

Used: SAS 8.2,SQL,Excel and C language.

Built models of transaction on exchange, risk structure and hedging

strategies.

Analyzed a solid data and logical reasoning, searched algorithms, used data

mining, and managed database.

+ Manager of Network Administration / Database administrator

Wuzhou Securities Co., LTD, China (bought by Donghai securities Co., LTD in

2005) 05/1995 --- 01/2005

Installed software: Novell4.3, Windows NT/2000 Server; Moved data from one

server to another.

Used SQL language, SAP language to generate delivery order in stock

exchange.

Supported client and Local Area Network (LAN) systems.

EDUCATION

M.S. In Finance Engineering

07/1998 07/2000

Shanghai University of Finance and Economics, China

B.S. In Computer Science & Engineering 07/1992

07/1995

Luoyang Institute of Science and Technology, China

Contact this candidate