Data Sql Server

Sunny Shen, **TH ST Bellingham, WA *****, 360-***-****

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

SUMMARY

. 10+ years of experience in data analysis, business analysis, reports

development and report management, 6 + years of experience in SSIS/ETL

and 5+ years of experience in ERP application development

. Experienced with full project life cycle, Agile and/or Scrum

methodologies. Strong experience in relational database, data warehouse

design, and data modeling.

. Excellent experience in developing ETL packages using SSIS, BCP, Bulk

Insert, and other 3rd party tools to load data into different

destinations from a variety of data sources including SQL Server,

Oracle, Excel, XML, Access, and flat files.

. Advanced skill in T-SQL, PL/SQL, stored procedures, functions and

experience with MDX.

. Proficient experience in developing reports and to drill down/drill

through function with SSRS, Crystal Reports, Excel, and other report

tools including: Tabular Reports, Matrix Reports, Parameter Reports, and

KPI Reports dashboard with charts.

. Proven ability to approach problems effectively, prioritize and complete

multiple tasks.

. Experience in health care, retail, wholesale, bank, and manufacture

accounting analysis reports

. Quick learner, takes initiative, and hard worker. Willing to take

responsibilities.

COMPUTER SKILLS

Database: SQL Server 2012/2008/2005/2000, Oracle11g, Access 2007, 2012,

BI/Data model tools: SSIS, SSAS, SSRS, Crystal Reports, SharePoint, Power

BI, Erwin

Language: SQL, T-SQL,PL/SQL, Visual Basic, JAVA, C++, C#, MDX

Application: SAP, Clinical Management, Ztax, Frx, PDI,

CERTIFICATES

Microsoft Certified: MCDBA, MCSE SCJP (SUN Certified Java

Programmer)

CPA (Certified Public Accounting) CIA (USA Certified Internal

Auditor) (passed 4 exams of 5)

EDUCATION

Bachelor of Science in Computer, Bachelor of

Accounting,

INDUSTRIAL EXPERIENCES

Sr.BI developer TRUONEX, Inc. (2012.9- 2014.12 )

. Created ETL packages using SSIS to extract data from SQL Server, Oracle,

XML, CSV, ADO, ODBC and cleans up the data using Data Quality Service

(DQS), Fuzzy Grouping, and transformed data using various dataflow

components (i.e.: lookup, union, merge, merge join, conditional, splits,

derived column, script component, etc.) and inserted the cleaned and

transformed data into different destinations using Change Data Capture

(CDC) for incremental loading.

. Generate periodic reports based on the statistical analysis of the data

from various time frame and division using SQL Server Reporting Services

(SSRS).

. Increase the performance of Reports by Query Optimization, logging file

analysis, Report server setting and report schedule.

Selected three of complete projects in last two years

1. As a developer, worked with a retail company IT and sales department:

Tested and modified existing SSIS packages, created new SSIS packages,

built a SSAS cube, and developed reports

2. As a consultant, worked with a health care company IT and accounting

department: Wrote complex SQL Queries, Stored Procedures, Triggers,

and Views to resolve two application system data differential

problems. Modified current SSRS reports to increase performance.

3. System Migrations: Migrated legacy applications to new ERP system

successfully without adverse effect on business. I did project

technical data migration documentation, created ETL packages, and

migrated legacy reports.

BI developer Universal Delaware Inc., Newark, DE (2009.8-2011.4)

(Managed 46 retail gas stations)

. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived

Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task,

Data Flow Task, and Execute Package Task to import multiple source data

to data warehouse.

. Built business analysis reports, monthly KPI reports, and built daily

reports that includes: item sales, receiving, adjustments, item audits,

cash over/short, and site analyst.

. Implement Testing and troubleshooting by debugging, configuring logging,

and even handling.

Selected Work with project group to complete projects

Developed Data Center (Data warehouse) to Manage 46 gas stations data. In

the project, I developed 128 SSIS Packages to transfer to different

multiple source data, to Data Center, and I built cubes and generated 39

analysis reports. Used SQL server BI (SSIS, SSAS, and SSRS).

Sr. Systems Analyst Universal Marketing Inc. (Wholesale) New Castle, DE

19702 (2007.2-2009.8)

. Consulted managers and users to gather and interpret functional

specifications and user requirements; analyze user requirements,

procedures, and problems to improve existing systems and workflows.

. Analyzed current system, installed and insured new ERP systems in all

functional areas

. Provided expert technical consulting and effective leadership direction

across different applications that ensure valued solutions supporting

organizational objectives and priorities.

. Built ETL packages, defined integration flow, imported daily outsource

data which includes: supplier price, sales price, supplier invoice,

vendor invoices, EFT, credit card, bank statement, etc.

. Developed financial reports such as: Current Period and YTD Cash Flow,

Revenue Analysis reports, Pricing analysis reports, etc. in Crystal

Reports

Oracle Database Developer, Ritztech Co, Gaithersburg, MD (2004.11-2007.1)

Developer & Consultant for Financial System Software, DaHan Co., 65 Fujian

Rd, Nanjing, Jiangsu Province, P.R.C(1999.1-2002.5)

Contact this candidate