Data Developer

Overview

As the motivated and ambitious Microsoft SQL Server Database Developer with more than six years experiences, I am capable of leading and working with a team as well as individually. I have the ability to accomplish tasks under minimal supervision and direction. Meanwhile, I am a hard worker with a desire to use my sharp T-SQL development skills in the fields to assist with achieving goals and objectives.

Professional Summary

Over six years of solid experiences in Database Administration, System Analysis, Design, Development and Supporting in Microsoft SQL Server 2012/2014, Microsoft SSRS Reporting fields, SSIS ETL process.

Strong experience in developing Transact-SQL(T-SQL) scripts, stored procedures, triggers and functions.

Experience in developing high performance data integration solutions with SSIS, including extraction, transformation, and load (ETL) packages for data warehousing.

In-depth knowledge of complex T-SQL. Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and functions.

Expert in creating indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012/2014.

Sufficient skills of monitoring and optimizing system performance by optimizing SQL queries, using report cache and snapshot.

Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.

Solid statistical knowledge and experience of data modeling and analysis utilizing SAS/R/Python.

Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

Technical Skills

Language:

T-SQL, Python, R, SAS, Stata, XML/Jason, C/C++/C#, PowerShell, Excel/VBA/Macros

Database:

MS SQL Server 2008R2/2012/2014/2016

Microsoft BI:

SSRS/SSAS/SSIS, Visual Studio 2010/2012/2013, SharePoint

Software Methodology:

Agile/Scrum, Rally, Git/Github, Subversion, Sublime

Platform:

Win7/2003/2008/2008R2/2012/2012R2/2016, CentOS Linux

Work Experience

10/2016 - Present

First Bank Denver, CO

Position: Sr. SQL Developer (SSIS/SSRS)

1.Senior database developer responsible for data warehouse ETL development and maintenance, SSRS report creation, and SQL query performance tuning.

2.Developed, enhanced, and supported processes using Transact SQL and SSIS which moved data from the Oracle system and other sources into the SQL Server warehouse. Assisted in conversion of ETL processes from Oracle to SQL stored procedures.

3.Developed SSRS reports and complex stored procedures for real-time benchmark and scoreboard display at Enterprise monitor dashboard. These reports retrieved data from OLTP SQL production databases and required extensive stored procedure tuning for rapid display.

4.Designed SSRS 2012 reporting system to share reports between plants eliminating the need to support multiple versions. Reports were deployed to SharePoint as well as remote reporting servers.

5.Investigated nightly ETL data integrity issues for business intelligence reporting. Corrected job errors, data access issues, and platform data type conversion conflicts.

6.Worked closely with end-users to collect requirements and test processes. Analyzed data and designed databases for importing data.

7.Wrote and enhanced complex stored procedures and user defined functions for web site database access. Mentored DBAs and developers in stored procedure design and data access techniques.

8.Approved database changes and moved into production systems. Analyzed and corrected SQL bottlenecks and poorly performing logic using SQL Profiler and query execution plans.

06/2014 - 09/2016

AT&T Mobility Richardson, TX

Position: SSIS Developer

1.Integrated Asp.Net with SSRS reports and also integrating them with SQL server Database. Possessed excellent skills in Data Modeling to create Star and Snowflake Schema using Erwin.

2.Performed data migration using tools like Data import/export, BULK INSERT and BCP between different heterogeneous systems and SQL Server. Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled DTS/SSIS Packages.

3.Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

4.Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs, SIT, UAT, Data Reconciliation and validation.

5.Created T-SQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans. Performed data profiling, data analysis to identify legacy data that needs to cleansed prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.

6.Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.

7.Supported 24X7 in production issues and User’s issues on applications.

10/2012 - 06/2014

Baxter Deerfield, IL

Position: T-SQL Developer

1.Created a Visual Basic/Access software system that used barcode to track the transfer of tapes to and from off-site storage. Developed a plan for monitoring the enterprise client/server software within the organization.

2.Designed Visual Basic/Access module and modified in-house UNIX process to monitor performance of email post offices.

3.Developed MS Word and Excel macros to create metric reports from UNIX program logs. Supported and enhanced mainframe file transfer systems.

4.Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.

5.Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.

6.Designed and developed reports using Microsoft SQL Server Reporting Services (SSRS) and Crystal Reports.

7.Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.

8.Responsible in Monitoring and Troubleshooting SQL Server Performance issues.

9.Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.

10.T-SQL development included queries using joins, subqueries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.

11.24/7 on-call support for the production environment.

Education

Master of Statistics and Operation Research

University of North Carolina at Chapel Hill Chapel Hill, NC

Lindsey Yang

Email – *******.********@*****.***

Cell Phone - 919-***-****

Contact this candidate