Sql Server Development

Qing Sun

Phone: 858-***-****

E-mail: *********@*******.***

Overview

. Extensive professional experience in Business Intelligence

architect, development and implementation

. Highly productive and focused IT professional with excellent

problem solving and communication skills.

. Design, development and implementation experience with Oracle

Hyperion Essbase, Oracle EPM (Hyperion Planning, HFM, BIPlus,

Shared Services, Workspace, and BPMA), Microsoft BI (SSIS,

SSAS, SSRS, BIDS), Business Object (Crystal Reports), and

Microstrategy

. Advanced experience in Oracle Hyperion development and

administration

. Advanced skills in SSIS development, ETL design and SQL

programming

. Experienced in data modeling using Erwin 7.3

. System installation, configuration and administration experience

with Oracle EPM, Oracle Hyperion Essbase, and SQL server 2005

and 2008

. Demonstrated leadership and team building skills

. Have been a technical/project lead in several projects

. Proficient in conducting demonstrations and presentations to customers

. Experienced in project management

Experience

Business Intelligence Architect July 2008 -

Present

PETCO, San Diego, CA

. Installed and configured Oracle Hyperion Essbase and Oracle

EPM 11, Hyperion Planning, HFM, BPMA, Calculation Manager,

Shared Services, Workspace, and BIPlus services

. Designed, configured and implemented BPMA Interface Tables to

support metadata uploads for Hyperion Planning and HFM

. Designed and implemented ETL processes for BPMA Interface

Tables

. System administration experience with Hyperion Essbase

(Oracle Hyperion OLAP).

. Experienced in design and development of Essbase

dimension/data load rules, calculation scripts, calculation

rules, MaxL, Esscmd, and VBA/batch scripting

. Designed Essbase database cubes to support

budgeting/forecasting processes for sales, administrative

expenses, and capital expenses. Designed Essbase cubes to

support financial reporting using Hyperion Financial Reports

and Web Analysis.

. Designed and implemented partition between Essbase budgeting

and reporting cubes.

. Familiar with Star Schema and Data Warehouse concept

. Participated in data warehouse migration from Oracle to

Netezza

. Performed unit testing of ETL processes for Netezza data

warehouse in Unix environment

. Migrated 20+ DTS packages to SQL 2008 SSIS packages that

support the dimensional and fact table loads for data

warehouse

. Implemented SSIS configuration tables in SQL Server 2008

. Performed unit testing and data validation of Microstrategy

reports against Netezza data warehouse

. Developed operational reports using Crystal Reports, SQL

Server Reporting Services Report, .Net technology, and

Microstrategy

. Installed and configured SQL 2005 and 2008 servers

Financial Reporting Analyst Nov. 2005 - May

2008

Scripps Health, San Diego, CA

. Developed and implemented a Business Intelligence Dashboard

using Lawson BI technology

. Worked as system administrator for Business Intelligence

Dashboard, Hyperion Essbase and SQL Server

. Developed Hyperion Essbase cubes for Accounts Payable, Labor

Expenses, and Income Analysis.

. Created Excel VBA templates for data retrieval and reporting

from Essbase

. Developed Crystal Reports to support G/L transaction

analysis, labor expenses, accounts payable detail, P&L trend

analysis, and census analysis. Deployed the reports through

Lawson BI dashboard

. Utilized Microsoft SQL server DTS/SSIS packages, stored

procedures, views, and user defined functions in ETL

development

. Development experience with Arcplan

Software Engineer

Mar 2000 - Oct 2001, Epic Cycle Interactive Inc., San Diego, CA

. Participated in the development of Marketing Infrastructure

System for Cobalt Networks Inc using J2EE and Oracle database

. Worked as a technical consultant for OnsiteRx for a multi-

tiered public kiosk application using J2EE and SQL server

. Participated in operational reviews and investigations

including HR and IT system security

Professional Training

Hyperion Financial Management (HFM) 11 Administration and

Reporting

Hyperion Planning 9.3.1 Create and Manage Applications

Hyperion BI Plus Reporting & Analysis 11.1 Administration

Hyperion System Administration for Essbase 9.3.1

Hyperion Financial Reports Development

SQL Server 2005 Business Intelligence Application Development

Microsoft SQL Server Programming

Erwin Data Modeling

Data Mining for Business Applications

Crystal Reports XI Design Advanced

Essbase Advantage Bootcamp

Essbase ASO Fundamentals

Essbase Spreadsheet Toolkit and VBA Programming

ArcPlan Application Development and Maintenance

Business Intelligence Application Development and Implementation

Certified Java Programmer

Education

Master of Science in Accounting

San Diego State University, San Diego, CA

Bachelor of Science in Medicine

Capital University of Medical Sciences, China

Contact this candidate