SUMMARY

• Over 6 years of working experiences as MS SQL Server developer and BI developer using MS SQL Server 2012/2008.
• Familiar with database normalization in database designing. Adept in creating ER diagrams and mapping the data into database objects.
• Expert in creating tables, indexes, views, procedures, triggers and user - defined functions by using T-SQL.
• Experience in developing reports using SSRE. Adept in creating tabular and parameterized reports, chart reports, drill down reports by using SSRS.
• Experience in creating standard subscriptions and data driven subscriptions for delivering reports to others using subscription report wizard.
• Utilized control flow items such as execute SQL task, execute package task, script task, for each loop, file system Task in SSIS.
• Experienced in creating packages with SSIS. Using ETL tools for data extraction from other data sources including heterogeneous and homogeneous data sources. Good at data migration from Excel, Flat file, Oracle to MS SQL Server by using SSIS. Able to combine or split data by using merge, conditional split and data conversion.
• Experienced in creating check points and setting break points for debugging in SSIS packages.
• Experienced in providing logging, error handling by using event handler, and custom logging for SSIS packages.
• Experienced in adding configuration files to deploy SSIS packages across different environments. Get new values of the property from the configuration.
• Familiar with data warehouse modeling by creating OLAP cubes with multiple fact measures groups, star and snowflake schemas and multiple dimension hierarchies using SSAS.
• Strong communication skills; Good at team work and cooperate well with team members; Able to work under pressure; with excellent analytical skill and problem solving abilities.

TECHNICAL SKILLS

• MS SQL Server (2008/2012)
• Visual Studio (2008/2010/2012 )
• SSIS
• SSAS
• SSRS
• Power BI
• SAS with Advanced Certification
• Matlab
• Minitab
• Python
• R
• R Studio
• SPSS
• Latex
• Excel
• Fluent in English
• Chinese
• Basic knowledge in Japanese.

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

MS SQL BI Developer

Responsibilities:

• Involved in data warehouse design. Created OLAP cubes, built star schema and snowflake schema with dimensions by using SSAS.
• Created views to easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created procedures, views and functions to move data across client and server, to move data into temporary tables for further manipulation.
• Created triggers to raise error messages.
• Generated result sets from various of database objects such as views and functions to create parameterized reports using SSRS.
• Created drill down reports, adding subtotal after grouping and then sort the result. Created summary reports using SSRS.
• Create chart reports including histograms and scatter plots that show the profit of different payment methods.
• Scheduled the subscription reports with the subscription report wizard and delivered the reports to people internally within the project.
• Created SSIS packages using lookup, merge, sort, derived Columns, condition Split, aggregate, execute SQL task, and data flow task to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data marts.
• Participated in configure the SSIS package for run time parameters and configured files as well as developing the documents for logging, error handling for SSIS Packages.
• Created SSIS packages that loops through the various files stored in a folder and moves them to a destination folder depending upon the file name using script task.

Environment: SQL Server 2012, SQL Server Data Tools for Visual Studio 2012: SSIS, SSRS, SSAS

Confidential, Boston, MA

MS SQL BI Developer

Responsibilities:

• Participated in data warehouse design. Created OLAP cubes, built star schema and snowflake with dimensions by using SSAS.
• Created views to restrict what the customers can see in order to protect personal information.
• Created DML triggers to prevent data to be modified and show warning massages when certain event occurs.
• Created user-defined functions and procedures to return values that facilitate analysis.
• Created parameterized reports and drill down reports based on the result of views. Scheduled the subscription reports with the subscription report wizard and delivered the reports to people internally within the project.
• Created SSIS packages for data integration using SSIS from various sources such as XML, flat-file, Excel and other data sources.
• Integrate data from different departments such as Research Center, Medical Records Department and Management Department. Generated reports based on the result sets.
• Used transformations like lookup, aggregator, sort, derived column, union all and OLE DB command to implement the transformation logic and load the target tables in SSIS.
• Worked on event handlers to do event handling on error at the package.
• Used data conversion to return error rows to files in SSIS.
• Added configuration files to deploy SSIS packages and get new values of the property from the configuration.

Environment: SQL Server 2012, SQL Server Data Tools Visual Studio 2012: SSIS, SSRS

Confidential, Chicago, IL

MS SQL Developer

Responsibilities:

• Created user-defined functions with multiple parameters and returns values that helped in deciding the customer’s payment method.
• CreatedSQLServer Reports using SSRS. Developed query for generating drill down reports and add subtotal in SSRS.
• Generated reports using variables, expressions and functions. Used query to create parameterized reports in SSRS.
• Participated in response for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client's workstation.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLE DB to SQL Server using ETL Tool.
• Created packages for data integration using SSIS. Used merge to combine data from disparate sources to create new tables that meet the requirements.

Environment: SQL Server 2012, T-SQL, SQL Server Data Tools Visual Studio 2010: SSIS, SSRS

Confidential, Las Vegas, NV

MS SQL Developer

Responsibilities:

• Found the relations between entities in the database and drew ER-diagram.
• Migrated data from Access to OLE DB source using SSIS. And inserted, updated the information of tables in database by T-SQL.
• Created new table by union or join tables. Selected useful information, group and sort the data then create views by using T-SQL for customers.
• Created user-defined functions by T-SQL and returned values for calculating the expenses.
• Added row sum and column sum to tables by grouping and then sorted the data.
• Used data conversion in SSIS package to export error rows and return the rows to customers. Used conditional split to separate data in different conditions.
• Creates the SSIS package and use data flow to load data from OLE DB source and transfer the new data sets to Excel.

Environment: SQL Server 2008, T-SQL, Access, SQL Server Data Tools Visual Studio 2008: SSIS

Confidential

MS SQL Server Developer

Responsibilities:

• Participated in decide which table to use in a certain analysis and drew the ER-diagram.
• Migrated the data in Excel to SQL Server Management Studio and then insert or update new data. Delete data that does not meet the requirements or may highly influence experience results after analysis.
• Created tables, indexes, views, procedures and functions facilitating analysis.
• Used the SSIS package to load data from OLE DB source and transfer the new data sets to Excel. Sent the new data in Excel to experiment center for further experiences.
• Selected all useful information from the analysis results and insert the data to excel.

Environment: SQL Server 2008, T-SQL, MS Excel, SQL Server Visual Studio 2008: SSIS