Wei Xuan

Summary:

Over * years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (SQL Server Integration Service, SQL Reporting Service, SQL Analysis Service)

Adept in installation, upgrade, troubleshooting and configuration of MS SQL Server 2012/2008/2005. Fluent in all aspects of database development, designing, data normalization and optimization

Strong technical knowledge in Integration and Analysis Development including Performance tuning, Reporting, Designing logical/physical databases, Troubleshooting, Maintaining Backup, and Recoverability.

Experienced in Extracting, Transforming and Loading (ETL) tasks using SSIS including and its application such as BCP utility, DTS and SSIS (2005 / 2008) Packages with proper control & data flow elements.

Excellent experienced in using transformations such as Aggregate, Lookup, Data conversion, Merge Join and other necessary transformation tasks.

Experienced in SQL Server DTS and SSIS (Integration Service) package design and deployment

Sound Experience and understanding of SSAS, OLAP Cube, Dimensions and Architecture. Expert in creating the MDX queries to access data cubes and dimensions.

Good knowledge of Datasets, Data Marts, Data warehousing, FACT and Dimensions Data Modeling, Star Schema Modeling, Snow-Flake Modeling.

Expert in SQL Server 2005/2008 OLAP database development including KPIs, Data mining, and Slowly Changing Dimensions.

Resolved SQL Reporting Services issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Summary, Form, and Sub reports.

Created and deployed SSRS Reports from SSAS cubes and various data sources on the portal for the user accessibility.

Extensively worked with Team Foundation Server.

Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization, Proficient in creating Transact-SQL (DDL, DML, and DCL), Indexes, Views, Table Variables, Complex Stored Procedures, User and System defined functions to facilitate efficient data manipulation and consistent data storage.

Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent strong team player with an ability to quickly adapted to new roles

Education: Master in Engineering

Skillset:

MS SQL Server 2012/2008/2005, SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL server reporting Services(SSRS), Crystal Reports XI/X/9.0, Import/Export Wizard, BCP, MS Office Suite, Oracle 11g/10g/9i/8i, DB2, Windows, SQL, C, VB.NET, DTS, XML, ER-Designer, TFS, ODBC.

Projects Summary:

HCSC-BCBS, Naperville, IL 02/2014- Present

MS SQL Developer/Data analyst

Health Care Service Corporation (HCSC) is the largest customer-owned health insurance company in the United States. HCSC offers a wide variety of health and life insurance products and related services, through its operating divisions and subsidiaries. Operating through its Blue Cross and Blue Shield.

Executing Stored Procedures to get data.

Fix procedure caused issues in monthly release

Writing T-SQL statements maintain Data.

Using Visual Studio to review .net and update script.

Responsible for maintain data by writing complex dynamic SQL commands.

Solving tickets.

Solving Issuance members rates, subsidies, claims and membership issues by generate SQL Queries and work in TFS updated script.

Trouble shooting the Zena jobs which is similar with SSIS SQL jobs, maintain the database.

Script catch errors

Trouble shooting the data issue causing by different reasons.

Data analysis from table to table to solve claims.

Used SQL Server profiler for auditing, analyzing and performance improving events occurring during particular time horizon and stored in script.

Environment: MS SQL Server 2008 (SSMS), Microsoft Visio 2013, MS SQL Server Reporting Services 2012, Visual Studio 2012/ 2008, MS Office Suite, MS SharePoint Workspace 2010

Young Innovation, Inc. Algonquin, IL 11/2013- 1/2014

MS SQL/BI Developer/DBA

Young Innovations, Inc. is a medical devices company. The company is engaged in the development, manufacturing, and supply of dental equipment. Discovery is a product which contains all the data files and is hosted by AFS. User downloads the data files and update their install. The Discovery is built and maintained by using SSIS and SSAS.

Responsibilities:

Utilized Extract, Transform and Load process in SQL Server Integration Service (SSIS) to migrate databases from Heterogeneous data Sources (Excel and flat files) to a centralized destination.

Used various SSIS transformations like Derived column, Lookups, Conditional split, Fuzzy lookup, ect.to cleanse and organize the data according to requirements.

Used Active-X scripting in SSIS for transformation of data into staging tables and performed multitask data pump in SSIS/ETL.

Responsible for Developing, Monitoring, Configuring and Deploying SSIS packages.

Writing Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL statements.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views.

Created, managed and utilized KPIs’ properties to determine business performance.

Responsible for writing the calculations for the OLAP Cube, partition of the tables, and custom each cube in the project within the requirement.

Responsible for deploying cubes, use Cube synchronization to migrate cube between different servers.

Created automatic nightly jobs to process cubes by using SSIS and deployed the package to SQL server.

Trouble shooting the SQL jobs, maintain the database.

Used MDX calculations to support analysis needs and fast data retrieval. Expressions included Calculate, Group, Filter, Parameterize, and Format the contents according to business requirements.

Developed Report Models using report builder and distributed reports in multiple formats using SQL Report Manager in Server Reporting Services (SSRS).

Used SQL Server profiler for auditing, analyzing and performance improving events occurring during particular time horizon and stored in script.

Backup the database and restore.

Using export and import tables between servers to servers

Worked on error handling a module consisting of sensitive data from banking, transactions, investments, regions, etc.

Used role based Security to control access to folders, reports and resources.

Environment: MS SQL Server 2012/2008 (SSMS), MS SQL Integration Services, MS SQL Server Analysis Services 2012/2008, MS SQL Server Reporting Services 2012, Visual Studio 2012/2008, MS Office Suite, Team Foundation Server

Northern Trust Corporation, Chicago, IL 1/2012- 10/2013

MS SQL/BI Developer

Northern Trust is a leading provider of asset management, fiduciary, banking, asset servicing and fund administration solutions for individuals, families, corporations and institutions worldwide. Risk Management Department of the bank is responsible for helping the business of the bank grow while account for potential harmful consequences of unexpected event. Under Credit Risk management division, the project involved achieving company’s financial goal with usage of SQL Server Integration Service and SQL Server Analysis Service for the purpose of maintaining business continuity and risk analyzing.

Responsibilities:

Utilized Extract, Transform and Load (ETL) process in SQL Server Integration Service (SSIS) to migrate databases from Heterogeneous data Sources (DB2, Access, or Excel) to a centralized IT destination.

Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS. Used Event Handlers for Exception Handling in SSIS packages.

Used various SSIS transformations like Derived column, Lookups, Conditional split to cleanse and organize the data according to requirements.

Experienced in Developing, Monitoring, Configuring and Deploying SSIS packages.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets.

Used MDX calculations to support analysis needs and fast data retrieval. Expressions included Calculate, Group, Filter, Parameterize, and Format the contents according to business requirements.

Created, managed and utilized KPIs’ properties to determine business performance.

Experienced in implementing complex dynamic SQL commands such as Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL statements.

Generated reports on banking activities, risk calculating information, accountholder’s information, research reports using drill through, parameterized.

Converted Reports from Crystal Reports Services into Reporting Services (SSRS) using Crystal Migration Services

Developed Report Models using report builder and distributed reports in multiple formats using SQL Report Manager in Server Reporting Services (SSRS).

Used SQL Server profiler for auditing, analyzing and performance improving events occurring during particular time horizon and stored in script.

Worked on error handling a module consisting of sensitive data from banking, transactions, investments, regions, etc.

Used role based Security to control access to folders, reports and resources.

Performed daily tasks including backup and restore by using tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2012/2008 (SSMS), MS SQL Integration Services, MS SQL Server Analysis Services 2012/2008, MS SQL Server Reporting Services, MS Office Suite, Visual Studio 2012/2008

Capital One, Richmond, Virginia 6/2010-12/2011

MS SQL/BI Developer

Capital One is a major American financial services company based in New York, NY. Treasury Vision is a unique web-based cash management tool for corporate treasurers to achieve visibility of their cash position, enabling management of global liquidity and risk across the enterprise. Involved in Design, Development phase of Data Modeling, Analyzing using Analyzing Services and generating reports using SSRS.

Responsibilities:

Created and implemented package using SQL Integration Services (SSIS) from various database into different file system.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.

Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS. Used Event Handlers for Exception Handling in SSIS packages.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.

Developed report specifications, created and modified reports using SSRS 2008. Involved in creating and implementing Parameterized and Cascading Parameterized Reports according to business needs.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard .

Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.

Planned a complete backup on the database using tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Visual Studio 2008.

Health First, Rockledge, FL 10/2008-06/2010

MS SQL/BI Developer)

Health First is one of the majoring growing health care service providers in the United States. Its businesses include providing insurances for underinsured or non-insured people, alliance with local hospital as well as research for mortal diseases. The project was to extract data from various servers and load the data in OLAP system and also to create reports and BI Cubes for requires details of insurance policy holders in order to track the business progress from Insurance provider division.

Responsibilities:

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. Implemented various tasks and transformation to cleanse and fine-tune the data system.

Experienced in writing VB.net, C#.net code for SSIS 2005 packages in scripts.

Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

Created facts, dimensions, and data models, star schema representation for the data mart of OLTP and OLAP databases. Generated business critical KPIs using SQL Server Analysis Services (SSAS) to improve business performance.

Created parameterized reports and ad-hoc reports using Report builder. Generated Daily, Weekly, Monthly, Subscriptions reports for the analysis of managers and end users by using SSRS.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).

Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.

Used Report manager to deploy reports, schedule reports, and created groups and users. Used role based Security to control access to folders, reports and resources. Worked in creating and modifying data driven subscriptions, fine-tuning of standard subscriptions.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS Analysis Services 2005, T-SQL, Crystal Reports 8.5, Windows 2003, C#

Contact this candidate