ALEX ZHENG

Sr. SQL Server Professional

Email: acxbga@r.postjobfree.com

Cellphone: 321-***-****

Summary

Strong full Software Development Life Cycle experience who is innovative and produces work that demonstrates digital excellence whilst committed to maintaining the highest level of work in Microsoft SQL Server, T-SQL, Microsoft ETL/Business Intelligence and Testing. Solid hand-on skills on C# and .NET experience. I am looking for an ambitious company which will challenge my Microsoft stack development and problem solving skills and allow me to continue to develop my knowledge and potential.

Career Objectives

Microsoft SQL Server database developer

Microsoft BI Developer (SSRS/SSIS)

Tech-Skills Overview

Operating Systems :

Windows Server 2008/2008R2/2012

Language :

SQL/T-SQL, C/C#, PowerShell, Visual Basic/Matlab

Relational Database :

Microsoft SQL Server 2008 R2/2012/2014/2016

Development Tools :

Microsoft Visual Studio 2008/2012

SQL Server Tools :

SQL Server Management Studio (SSMS), SSRS, SSIS

Professional Summary

Experience creating large scale data models, DDL scripts to create database objects (tables, views, indexes, triggers, and constraints), and DML scripts to manipulate data.

Solid experience performing database design and code reviews to ensure compliance with database design standards.

A strong background in database management systems, data modeling, data architecture, validation, and various data movement techniques including the use of SSIS ETL technologies.

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.

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.

Experience in creating Index, Views, complex Stored Procedures, appropriate user defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.

Extensive experience in Microsoft SQL Server 2008R2/2012/2014 and solid hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server in Dev, Testing and Production environments.

Experienced with the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services, Bulk Insert, and Bulk Copy Program (BCP).

Extensive experience with writing T-SQL scripts, stored procedures, triggers and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.

A resourceful self-starter who is able to self-educate quickly, solve problems and convey solutions for the development teams.

Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

Education

Master Degree of Mechanical Engineering 08/2009-05/2011 Florida Institute of Technology Melbourne, FL

Project Experiences

Citibank Plano, TX 02/2015 – 09/2016

Position: Senior SSIS/SSRS Developer

Involved in Gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the Source to the Target Data Warehouse.

Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored Procedures, User defined functions, Indexes.

Created SSIS Packages using Control flow task, Execute SQL task, Data Flow task, Script task, Container, Precedence Constraints and Expressions, Data Profiling task, Data Flow Transforms, Data Conversion, Derived Column, Conditional split, union all, Merge Join, Sort, Aggregate, Pivot Transformation, Fuzzy Lookup, Term Lookup according to the business requirements.

Designed and developed Microsoft SQL Server 2014 database applications using SQL Server Integration Services, TSQL, Stored Procedures, UDF and triggers.

Primary technical resources in SQL tuning in SQL Server Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, and Oracle etc. to SQL Server using SSIS.

Performed code reviews, analyzed execution plans, and re-factor inefficient code Follows data standards, resolved data issues, completed unit testing and completed system documentation for ETL processes.

Collaborated with business analysts, source system experts, and other team members to determine data extraction and transformation requirements.

Collaborated with IT operations and testing organizations to ensure timely releases of projects and database environments are sustainable.

Collaborated with IT operations for support in problem resolution and root cause analysis. Supported IT staff and business users in the development, usage and troubleshooting of database-driven applications.

Participated in special projects as needed and performs other duties as assigned.

Provided on-call assistance as needed to ensure development follows the SDLC process.

Responsible to write very complex database queries, designed various SQL objects and applied performance tuning to enhance the accuracy of the data. Responsible for designing reports using Reporting Services 2014.

AT&T Mobility Richardson, TX 06/2013 – 02/2015

Position: MS SQL Developer

Performing source system analysis and development of ETL jobs to migrate data from the Source to the Target Data warehouse.

Worked as a key contributor to the design, development and implementation of critical projects within the Application Delivery organization.

Worked closely with the Data Architect, business users, application architects, and other developers to model, implement and improve databases used in mission-critical applications within the organization.

Responsible for the overall data architecture within the Application Delivery area.

Enabled/performed consistent development and maintenance of Microsoft SQL Server 2012 database designs for custom business applications in accordance with business, regulatory, and security requirements.

Transformed business requirements into logical and physical data models by conducting data profiling/analysis. Maintained and published data mappings of data elements across systems, and created and maintained relevant architecture artifacts.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Created complex analytic queries on very huge data sets; developed T-SQL stored procedures, triggers and user-defined functions.

Utilized software development principles and experiences to develop within the full life-cycle of the mission critical production application.

Managed MSSQL data warehouse, Wrote SSIS for ETL tools, SSRS for reports.

Provided data services to the support team (data scrubbing, inserting and updating customer data).

Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexes and Execution plans in MS SQL Server 2012.

John Hopkins Health Care Glen Burnie, MD 10/2011 – 05/2013

Position: MS BI Developer

Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.

Took the lead to enhance team development practices on SQL Server Data Tools, Visual Studio and Team Foundation Services.

Active participation in technical investigations and prototyping of various Data Warehouse projects based on MS BI stack.

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

Performed database management, design performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Extended Events, SQL Analyzer, and SQL Enterprise Manager.

Implemented the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Administered, monitored and supported SSIS Packages and ETL process. Wrote support documentation for SSIS packages/SSRS reports and Stored procedures

Created different types of Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart report and Sub reports in multiple formats using SSRS.

Analyzed and Developed Complex Stored Procedures, Functions, Index, Triggers, Cursor, Table, Constraints, Joins, Subquery and CTE in SQL to facilitate efficient data manipulation and data consistency.

Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.

References

Available on request.

Contact this candidate