Nicky Sun

484-***-**** ac9pwa@r.postjobfree.com

About me

I have experience in the Microsoft Business Intelligence (BI) stack by using SQL, SSIS, SSRS tools. Skilled in ETL/SSIS package development(5 years), Transaction SQL (6 years) script creation and using Microsoft BI developer tools. I like challenging different solutions and get more ideas from challenging to improve my skills. I also like to learn new things in order to catch up technology and to provide quality service to clients.

Objectives

Microsoft Business Intelligence Developer(SSIS/SSRS)

Microsoft SQL Server T-SQL Developer

Professional summary

Six years of work experience in Database Design, Coding and Testing of various Microsoft Data Warehouse and Business Intelligence Projects.

Complete understanding of Software Development Lifecycle and core area of experience in validating end-to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS.

T-SQL working experience and very strong knowledge/skills of stored procedures, user-defined functions, complex queries with joins/window function, triggers, views, and ETL/SSIS packages.

Experience in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse(Star Schema/Snowflake Schema) / Data Mart, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.

Deep understanding of Microsoft SQL Server 2014/2016 database and Azure SQL Databases maintenance processes such as pertaining to Statistics, Indexes, Performance Analysis.

Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)/SSDT, Microsoft Azure, SQL Profiler, Performance Monitor.

Experienced using SSRS reporting to facilitate development, establish baseline data sets, assist in testing.

Experience in an Agile development environment. Extensive knowledge of business intelligence best practices, processes, tools, standards, and methodologies.

Ability to understand business requirements and transform user requirements into queried reports / stored procedures as well as Data Warehouse solutions as needed.

Technical Skills

DATABASE: Microsoft SQL Server 2012/2014/2016

MS BI STACK: SSRS, SSIS, SSMS, SSAS, Azure SQL, ADF, PowerBI

PROGRAMMING: T-SQL, C/C#, Python, Java, PowerShell

DEVELOPMENT: Agile/Scrum, DevOps, Visual Studio 2012/2013/2015, Microsoft Azure, .NET

PLATFORM: Windows Server 2012/2016

Working Experiences

Wells Fargo

Sr. Microsoft Business Intelligence SSIS Developer

Charlotte, NC

2017.7 – 2019.4

As a member of the Business Intelligence team, I am responsible for managing the design, development, implementation, management and support of critical enterprise BI reporting. I also lead the designing phase of solutions to develop ETL solutions with SSIS or T-SQL or ADF to populate the data warehouse from source systems and transform unstructured and disparate source data into clean data for downstream analysis.

Collaborated with the Data Analysts to develop data conversion SSIS packages that meet business rules.

Supported Risk Team on developing different credit risk models.

Involved in the design of data marts using star and snowflake schema and Kimball Methodology.

Partner with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2014.

Formulated plans and guides the development and implementation of software solutions including language, coding, platform, resource requirements, testing, and documentation. Specifically related to SQL writing/debugging of stored procedures in Microsoft SQL Server 2014.

Designed, developed, and executed SSIS ETL packages or Azure Data Factory to convert multiple external data source(including Azure SQL Database) using stored procedures, user defined functions, and SQL scripts in a Microsoft SQL Server/Microsoft Azure environment.

In ETL packages, building Scrip Task and Script Component by using C# under the .NET framework instead of existing tasks or components to improve the performance.

Performed performance optimization and tuning on new and existing data warehouse and SSIS ETL operations.

Identified and analyzed complex T-SQL stored procedure by using the Extended Events, SQL Profiler, SQL analyzer, created the necessary indexes and SQL hints to improve query performance in both production and development/QA databases.

Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.

Provided day to day support of data warehouse and troubleshooting of existing process and procedures.

Created and maintained of documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reporting.

Verizon

Microsoft SQL Server Developer

Highlands Ranch, CO

2015.1 – 2017.7

Created various SSIS packages to process data from ODS database to EDW data warehouse and other data marts.

Working as one of the primary T-SQL Developers in the team to design and develop SQL Server 2012 Databases, Tables, Indexes, Stored procedures, UDF, Views, and Triggers.

Troubleshoot and research data anomalies and recommend/implement corrective actions for the data conversion from ODS database.

Provided application enhancement and upgraded support, including any re-engineering due to changes of file and table structure of source systems.

Monitored for timely and accurate completion of data processes and scheduled jobs in Microsoft SQL Server Agent.

Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.

Supported internal customers in investigation of data issues, working with business and source system application owners to identify root cause.

Prepared accurate and detailed requirement specifications documents, work flow analysis, user guides, and functional specification documents.

Involved in creating Source-to-Target mapping documents that provide details on transferring data from the Logical Data Model to the Physical Data Model.

Assisted in the creation of new reports based on business requirements.

DaVita

Microsoft SQL Server Developer

Denver, CO

2013.8 – 2014.12

Worked in a cross-functional team comprised of managers, supervisors, business analysts, and other developers to ensure the delivery of application software solution on MS SQL Server platform as planned.

Composed various T-SQL stored procedure, views and user-defined functions on SQL Server (2008R2 and 2012); identified weaknesses in T-SQL code and improve SQL script performance.

Consulted with business users to design and implement updates to the BI Data Warehouse.

Responsible for designing, coding, and implementing database solutions using Agile/Scrum development methodology and T-SQL development environment, including table design, stored procedures, UDF, triggers, views, CTE and window functions.

Responsible for coding, testing, debugging and implementation into production.

Designed, developed, tested, tuned, and implemented Microsoft SQL Server 2012 database objects and T-SQL scripts using stored procedures, functions, triggers, views, window function and data manipulation scripts and ETL/SSIS packages.

Responsible for validating data, performing cross reference checking between various source data and reporting outputs.

Built reports in SSRS for errors generated by SSIS Packages, generated Reports using Data Source Views in Report Builder, created Drill Down, Drill Through, linked and sub reports using SSRS.

Education Background

Lehigh University

Master

Electrical Engineering

2011.8-2013.5

Bethlehem, PA

Contact this candidate