Jane Sun

Boca Raton, FL acyprh@r.postjobfree.com

Objective: BI Developer/Database Reporting Analyst/ Data Analyst

SUMMARY

Master degree of Science, Bachelor degree of Medicine, years of experience with SQL Server 2008/2012, SSIS, SSAS,SSRS, SAP Crystal Reports 2008/2011, Oracle 11g/12c, MS Access 2007/2010 and Excel, Finance-Accounting Certificate

Professional experience on high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.

• Professional experience on variety of business reports using SQL Server 2012 SSRS including matrix reports, dynamic/parameter reports, cascading reports, dashboard reports, chart reports, list report.

• Professional experience on customized KPIs reports and data mining models to support decision making with SSAS cube

Knowledge of HIPPA and HEDIS

Strong team player with great verbal, written communication and interpersonal skills.

Proven ability to approach problems effectively, prioritize and complete multiple tasks.

Quick learner, and hard worker, reliable, willing to take responsibilities.

COMPUTER SKILLS

Database: SQL Server 2008R2/2012, Oracle 10g/11g, MSBI 2008/2012 SSIS, SSAS, Access 2007/2010

Reporting: SSRS, SAP Crystal Reports 2008/2011, Access 2007/2010

Language: SQL, T-SQL, MDX, Excel Visual Basic

MS Office: Word, Excel, PowerPoint

EDUCATION

M.S, Science, Chinese Academy of Medical Sciences, China 1995.9 – 1998.7

M.D. Medicine, China Medicine University. China 1990.9 – 1995.7

SELECTED ACHIEVEMENTS ON BUSINESS INTELLIGENCE

• Created an SSIS package that uses a Foreach Loop container to loop over a list of files. As the package loops over each file, it uses a data flow to import the data into a database and finally moves the file to a new location as an archive.

• Developed projects using SQL Server 2008 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships.

• Built cascading parameter reports, with a dataset query containing parameters, stored procedure, alter query with split function, alter dataset property parameter expression.

• Created database tables with various constraints including primary key, foreign key, etc.

• Migrated database from SQL Server 2008 R2 to SQL Server 2012 by attach/detach; loaded data from flat data files into SQL Server 2008 database tables using bulk insert, extracted data using bcp, move data by export/import method.

• Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL functions.

• Generated variety of business reports using Crystal Report 2008 and Excel 2007 with v lookup function and Pivot table.

EXPERIENCE

Report Developer, 911 Software Inc, 2014.7 – 2016.7

• Create selling detail reports

• Provide customized summary reports weekly, monthly and yearly upon requests with SQL, Excel, Access and SSRS

• Create dynamic matrix report to compare the product sales between any selected year and the prior year; show the sales variance for the month selected and also the total sales variance with Inscope function.

• Provide customized KPIs reports to show sales gross profit status and trend.

• Use data mining models to find out potential customers for new products (decision tree algorithm) and predict sales, inventory, staffing levels in the near future (time series algorithm) to support decision making with SSAS cube.

• ETL from source database to a data warehouse dimension table with data flow task, Slowly Changing Dimension task to satisfy end user’s need.

•Extract data from data warehouse with star schema, snow flake schema diagram to build reports ;load fact table and dimension tables to data warehouse.

• Automation job schedule with SQL server job agent; database migration - back up, restore and import database

Data Analyst, Palm Beach Chinese Academy, 2016.8-current (part-time)

• Extract/Transform/loading (ETL) data and generate Reports:

ETL excel data with SSIS and create matrix report, dashboard reports with SSRS related to class attendance and so on.

Data Report Analyst/Research Technician, State University of New York at Stony Brook, NY, USA 2009.5-2012.6

• Retrieve and ETL data using SQL Server2008 and BIDS and create dynamic/parameter reports, dashboard reports and other matrix reports.

• Edit Excel file for ordering and ETL data to database and created matrix reports.

Lab Manager/Research Specialist, University of Pennsylvania, Philadelphia, PA,USA 2000.10-2008.6

• Edit Excel file for ordering and inventory and create reports with Excel, MS Word.

Research Associate, Department of Research, Beijing Ditan Hospital, Beijing, China 1998.8-1999.9

Contact this candidate