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