Jenny Cui

Apex NC ***** acxk9a@r.postjobfree.com

OBJECTIVE: BI Developer, Data Analyst / Reports

SUMMARY

Computer Science with 5 years experience of SQL Server 2008, SQL Server 2012, Oracle, Access 2010 database and Data Loading and Reporting tools such as: SSIS, SSRS, SSAS and Crystal Report 2008.

Successful installed WMware Player, Microsoft Window Server 2008R2, SQL Server 2008, SQL Server2012 and SQL Server 2014.

Configuring a new Microsoft SQL Server database, migrating data and objects from an established database into the new database utilizing a sustainable process.

Implements new features and change requests based on requirements and technical design specifications; develops and maintains ETL mappings and T-SQL and PL/SQL scripts to retrieve data for troubleshooting, analysis and reporting; builds and maintains meta data that captures mappings and transformations between target and source data models.

Work with architects, analysts and developers to design and develop robust ETL applications that meet user and architectural requirements, understand data models, and follow ETL best practices.

Creates technical documentation: software requirements and technical design specifications.

Created ETL packages using SQL Server 2012 SSIS Designer to extracted data from flat file,

Strong data management and reporting experience on quantitative analysis.

Professional experience of most advanced SQL Server 2008 and 2012 Database server installation, login and user creation, role and permission configuration.

Professional experience on load variety of large volume data files into SQL server 2008,2012 database tables, migrate Oracle tables into SQL Server 2008,2012 database tables and generate Report with SQL Server Data tool SSRS.

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

Robust MS Access and Excel skills with Pivot tables.

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

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

Quick learner, take initiator, and hard worker. Willing to take responsibilities.

COMPUTER SKILLS

Database: SQL Server 2012, SQL Server 2008, Oracle, SSIS, SSRS, SSAS, Access 2010

Reporting: Access 2010, SSRS, Crystal Report 2008

Language: PL/SQL, T-SQL

Internet: MS Sharepoint

MS Office: Word, Excel, PowerPoint, Access

EDUCATION

Computer Science Xi'an University of Finance and Economics, Xi'an, China

Major: Computer Software

Database Management USALaotu International Institution, Silicon Valley, CA

SELECTED ACHIEVEMENTS ON BUSINESS INTELLIGENCE

reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS and SQL server data tools).

Developed projects using SQL Server 2012 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using DMX.

Generated variety of business reports using SQL Server 2012 SSRS including 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.

SELECTED ACHIEVEMENTS ON SQL SERVER 2008, SQL SERVER 2012 DATABASE AND ORACLE DATABASE

Creates software system and integration test plans.

Triage, debug and troubleshooting software issues; found in development & production

Configuration Management: creates, extends and configures utilities for configuration and deployment of software components.

Executes software test plans for system and integration testing.

Configured SQL Server 2008, SQL Server 2012 and Oracle SQL 10g/11g/11gR2 database parameter files to adjust the memory usage and file size.

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

Loaded data from flat data files into SQL Server 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.

Power user of advanced SQL queries with multi-table join, group functions, subqueries, set operations and T-SQL or PL/SQL functions.

Generated variety of business reports using SQL queries, sqlplus, SSRS and Excel.

Generated variety of business reports using SQL Server 2008 sql query, SSRS, Crystal Report 2008 and Excel 2007 Pivot table.

RELEVANT WORK EXPERIENCE

Healthy Start Corps Pembroke NC

Data analyst, ETL developer (since 2006 -present)

Assisted on the database design and management for the Healthy Start Corps Information

System. Healthy Start Corps is a national health initiative funded by the Health Resources and

Services Administration (HRSA), U.S. Department of Health and Human Services

Maintained and updated perinatal service forms - referral forms, infant immunization, service

delivery and tracking together.

Analyzed data using statistical analysis tool Statistical Analysis Software (SAS), especially PROC

SQL.

Designed ETL processes for dynamic load data from source to destination using user Variables, Parameters and System Variables

SQL Server Agent Jobs

SSIS

Configured a Foreach Loop Container on the Control Flow designer, inside the loop configured

an Execute SQL task to modify data in the EmployeePayHistory table

Designed Data flow to extract employee pay data, used a Lookup task to determine the last time

each employee received a pay increase, and increase pay based on time of service

Created an SSIS package that enumerates a list of files, imports all the data in each file, and,

finally, renames and moves each file to a new location

Used the Slowly Changing Dimension task to load a new special offer dimension

Loaded fact table using Lookup transforms

SSRS

Created report using a matrix with collapsible rows and columns

Created matrix report that use parameters from a list of available values and default values

Built a report using the MDX Query Designer and pulling data from a Cube

Built various reports with cascading parameters, dynamic columns, dynamic images,

LookUpValue, CustomCode_PageBreakRowNumber, and from report template

Lumberton Chinese School, Lumberton, North Carolina, Principal & Teacher

Teach Chinese language, Mathematics, Computer Knowledge and Database skills (6 years since 2008 )

I have developed documentation and prepared step-by-step lab procedures and materials guiding my students to install successfully software programs, including WMware Player, Microsoft Window Server 2008R2, SQL Server 2008, SQL Server 2012 and SQL Server 2014, assuming enterprise environments. Students of my class learned

1) configurated a new Microsoft SQL Server database system, and supervised students to use SQL server Data tools and SQL server management visual studio;

2) with the use of dummy data technique, migrated data and objects from an existing database into a new database;

3) designed ETL projects for loading Excel platforms into databases, plus mapping data types and troubleshooting issues; and

4) generated reports using SSRS and implemented star schema database cubes using SSAS.

Navigation Technology Research Institute, Xi’an, China, Software Engineer

Database management and information technology for implementing radar systems, GPS and weapon system.

8086, 8087, 8255, 8251, 8253, 8259 coding skills (13 years)

LANGUAGES English, Chinese

CITIZENSHIP United States

REFERENCES Available upon request

Contact this candidate