Shirley Sheng

***c Hana Road, Edison, NJ *****

815-***-**** / acpe09@r.postjobfree.com

SUMMARY

4+ years of experience in Analysis, Design, Documentation, Development, Testing and

Implementation in Client/Server applications using Microsoft SQL Server and BI Suite for

various Business domains.

Experienced with all phases of SDLC(Requirement, Analysis, Design, Development,

Testing and Maintenance).

Expertise in RDMS using SQL Server 2000/2005/2008.

Expertise in Data Extraction and Transforming and Loading(ETL) using SQL Server

Integration Services (SSIS) in MS SQL Server 2005.

Expert in generating drill down Reports in SSRS 2005/2008.

Created and modied attribute hierarchies within SSAS for accurate reporting purposes.

Expertise in using BI Reporting Tools like SSRS, Performance Point Server.

Strong skills and experience in Object-Oriented Programming.

Expertise in dealing with complex data models and object relational database mapping,

while producing complex reports.

Strong experience in developing Stored Procedures, Triggers, Indexes to improve

performance of the site and to decrease the number of server side scripts to implement the

business logic.

Experience interacting with clients, gathering requirements, design, development and

deployment of various functional documents.

Ability to work independently and collaborate with team members.

Accustomed to complex, fast-paced, distributed environments.

TECHNICAL SKILLS

Computer Languages: C/ C++, Java, SQL

Web Technologies: ASP.Net, ASP, HTML, JavaScript, Web Service

Scripting and Markup Languages: JavaScript, HTML, CSS, XML

ProjectManagement:MS Project

Databases: SQL Server 200*-****-****, Oracle 9i/10g, MS Access

Reporting Tools: SQL Server Reporting Service 2005

ETL Tools: SSIS (MS SQL Integrated Services)

Business & Portal Technologies: Microsoft Ofce 2010, Microsoft SharePoint 2010

IDE: Visual Studio 2005/2008/2010, Visual Studio 6

Operating System: Windows XP/7/8, Mac OS and Unix

EXPERIENCE

SQL Developer, SmartWorks, NJ, 2014-2015

Performed Server installation and conguration using SQL Server 2008.

Wrote queries to generate reports for analysis of data.

Experience in creating joins for complex queries involving multiple tables.

Design, Implement and maintain Database Schema, Entity relationship diagrams, Data

modeling, Tables, Stored procedures, Triggers, Constraints, Indexes, Functions, Views, Rules,

Defaults and complex SQL statements.

Created automated stored procedures for day end operations using SQL Server agent.

Coordinated with front-end for implementing logic in stored procedures and functions.

Performance tuning of SQL queries and stored procedures using SQL Proler and Index

Tuning Wizard in SSAS and SSIS.

Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat le, to

MS SQL Server by using SSIS services.

Involved in building and improving data model (physical/logical) to serve different fund

types involved in the module.

Involved in SQL Server Mirroring and Database optimization.

Used scripts and variables, email notications for ETL process using Data Integrator in

SSIS, SSAS.

Transferred data from at les and Excel spreadsheets to SQLServer.

Involved in project planning, scheduling for database module with project managers.

Environment: MS SQL Server 2005/2008, SSIS 2008, Visual Studio 2008, PL-SQL, MS Access.

Database Analyst, Northern Illinois University, IL, 2012 - 2014

Performed data modeling and SSAS data mining.

Congured and maintained Report Manager and Report Server for SSRS.

Responsible for ETL Operation which extracts and transforms the data to Data

Warehouse using SQL Server Integration Services (SSIS)

Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008

Integration Services (SSIS).

Transferred data from various sources like MS Excel, MS Access, and SQL Server using

SSIS and then created reports using this data using SSRS.

Created SSIS packages for Data Conversion using data conversion transformation.

Built the SSRS reports from SQL Server.

Experience in conguring and deploying SSRS reports onto Microsoft Ofce SharePoint

Server.

Created data loads and upgrade scripts for data migrations and validations.

Analyzed the Previous Data and predicted the forth coming Results.

Experience in analyzing and improving existing dashboards, reports and reporting

systems.

Involved in debugging and testing support of Module in all environments and

coordinating with QA on defects and performance issues.

Environment: SQL Server 2008, SSIS/SSRS/SSAS 2008, Visual Studio 2008, PL-SQL, TSQL,

MS Access.

SQL Developer, Hefei Top Technology, China, 2011- 2012

Created database objects such as tables, procedures, triggers, constraints, indexes and

views, user security management.

Dened Check constraints, Business Rules, Indexes, and Views.

Completed the modeling architecture of the SQL server 2000 database.

Developing stored procedures, triggers, views and adding/changing tables for data load

and transformation, and data extraction.

Conguring, tuning, and optimizing SQL server 2005.

Performance testing on stored procedures, indexes, and triggers.

Tested to optimize the procedures and triggers to be used in production.

Created SQL scripts for tuning and scheduling.

Continuously interacted with users to gather business requirements.

Designed, developed and troubleshoot the SSIS packages that implement complex ETL

processes in the environments.

Designed and developed SSIS Packages to extract data from various data sources such as

Access database and Excel spreadsheet into SQL server 2008 for further Data Analysis and

Reporting.

Congured the report viewing security for various users at various levels using Report

Manager.

Performance tuning of SQL queries and stored procedures using SQL Proler and Index

Tuning Wizard.

Documentation of all processes involved in maintaining the database for future reference.

Environment:MS SQL Server 2005, Windows Server 2003, MS SQL Server Integration Services

(SSIS)2008, MS SQL server Reporting Services(SSRS), Microsoft Visual Studio 2008, MS

Visio.

SQL Developer Intern, Afliated Hospital of Anhui Medical University, China, 2010 - 2011

Completed the modeling architecture of the SQL server 2000 database.

Developing stored procedures, triggers, views and adding/changing tables for data load

and transformation, and data extraction.

Working on client/server tools like Query Analyzer to administer the SQL server 2000.

Conguring, tuning, and optimizing SQL server 2000.

Performance testing on stored procedures, indexes, and triggers.

Use of Insert, Delete, and Update statement as needs of business requirement.

Created database objects such as tables, procedures, triggers, constraints, indexes and

views, user security management.

Tested to optimize the procedures and triggers to be used in production.

Involved in analyzing and designing disaster recovery / replication strategies with

business managers to meet the business requirements.

Involved in Performance tuning, query-inventory, analysis and optimization.

Environment:MS SQL Server 2005, MS Access, MS Excel, SQL Query Analyzer

EDUCATION

Master of Operation Management and Information Systems from Northern Illinois

University, IL

Bachelor of Computing Sciences and Information Technology from Anhui University of

Architecture, China

Contact this candidate