| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Shirley Sheng
Street Address
PHONE NUMBER AVAILABLE / EMAIL AVAILABLE
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 2000-2005-2008, 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
|
