Data Sql Server

Chengxi Gao

219-***-**** *******.***@*****.***

OBJECTIVE With over 4 years’ experience of MS SQL Server Development/Administration, and 3 years’ experience as Advanced Software Support Specialist. Seeking a full-time position in SQL Server/Business Intelligence Developing fields, which can effectively utilize my solid knowledge of Data and experience in fields like T-SQL, PL/SQL, ETL, SSIS, SSRS, SSAS, SQL profiler, SQL tuning advisor, Tableau, MicroStrategy, Linux, advanced Excel, PowerShell, Python, C++, VB.net and etc.

PROFESSIONAL EXPERIENCE

COMCAST CABLE (FreeWheel, STRATA) Chicago, IL Database Developer/Administrator (Devops Team) Jan.2016 - Present

Responsible for helpdesk responsibilities as responding to troubleshoot, resolving daily problems and requests forwarded by Client Service representatives. Working on day to day support activities, resolve system bugs, assist business staff with questions, investigate issues.

Involving in help desk and client service responsibilities of assisting in quality assurance testing for STRATA’s Agency software products.

Participating in the full software development lifecycle with requirements, solution design, QA implementation, and product support using Agile methodologies.

Implementing multiple projects simultaneously. Working with complex software integrations with client facing experience. Assisting in quality assurance testing for STRATA’s Agency software products.

Developing and maintaining data structures, tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax. Developing complex queries using T-SQL.

Providing DBA Support responsibilities to application development teams (Development, testing, & production installation). Install and Maintain Database software, including high availability, Disaster Recovery and Backup Recovery Plan and perform database software upgrade, patch, vulnerability remediation. Providing Microsoft SQL Server database administration as required for data warehouse and data marts operation, performance monitoring, user account maintenance, job scheduling and monitoring, issue tracking/resolution, and user assistance with acceptance testing.

Monitoring and fixing the TV advertising orders data transforming process issues in the issue tracking software on a daily basis

Responsible for deploying ETL jobs to the development, testing and production servers. Schedule and Monitor those ETL jobs after deployment.

Supporting and developing various ETL transformations to perform data calculation, data cleansing and data verification.

Monitoring the overall performance of the data movement process to recommend and initiate actions to improve/optimize performance (OLTP).

Documenting customer feedback concerning software use, needed application adjustments, and enhancement requests. Responsible for technical flow chart

Hub Group Oak Brook, IL

MS SQL Database/Data Warehouse Developer April.2015 -Nov.2015

Provided technical support on OLTP/OLAP environments/applications with various SQL components (i.e. SSIS, and SSAS). Was responsible for database/data warehouse designs, upgrades, patches, problem diagnosis, performance monitoring, database maintenance, process automation, evaluation, and tuning recommendations; develop, implement and support backup/restore, disaster recovery and data replication procedures and exercises.

Designed and implemented warehouse and data mart concepts; worked with Data Architects to implement data modeling solutions

Worked with the ETL developers to process data via integration tools, scripts, and stored procedures. Extracted data from multiple systems, applications, and other sources (3rd party databases, APIs, Excel, txt files, XML etc), and loading data into Hub Group enterprise warehouse.

Provided activities of data migration from production systems to lower environments. Including data ETL (Extraction, Transformation, Loading), data cleansing, database design and development via T-SQL and SSIS.

Utilized data monitor, Diagnose, and Optimize tools such as SQL Profiler and Database Engine Tuning Advisor to perform T-SQL tuning and optimization.

Developed and improved solutions spanning data processing activities from the data lake (stage) to schemas and reporting view’s / tables and finally into SSAS.

Developed and improved Microsoft Analysis Services cubes

Provided on-call support on a rotating basis for all production-related problems, including support during non-business hours.

Globalfoundries Santa Clara, CA

MS SQL Server /BI Developer Nov.2014 – April.2015

Wrote and edited queries that read, manipulate, and analyze data from relational databases, data warehouses, and data cubes using the SQL, MDX, and DAX languages Designed, implemented, and maintained data warehouses using SQL Server Replication, SSIS, SSAS, and T-SQL scripting.

Worked with financial team to generate and maintain reports in Tableau and Power BI using multiple data sources (relational and SSAS).

Achieved data visualization via Tableau. Generated and delivered weekly and monthly key performance indicators (KPI) reports. Created visualizations, charts, tables, and other report part objects for use by non-technical users in self-service reporting tools.

Involved in Multi-Dimensional Data Warehouse designing and implementation for Globalfoundries data warehouse schemas (cubes, dimensions and associated measures and attributes), presentation of data to business and management personnel, and communication of issues and business developments.

EDUCATION

Valparaiso University Valparaiso, IN

Master of Science in Information Technology & Management May. 2014

CERTIFICATIONS

MCSA: SQL Server 2012/2014 Microsoft Certified Solutions Associate Jan. 2018

Data Visualization with Tableau Specialization Nov.2017

TECHNICAL SKILLS

Databases / Platforms: MS SQL Server 2014/2012/2008 R2/2008/2005, MySQL, Oracle, Linux and Windows.

Languages: SQL, T-SQL, PL/SQL, MDX, Python, Power Shell script, VBA, .NET and HTML5.

Development Tools: SQL Developer, SQL Server Management Studio, Pentaho Data Integration, Pentaho Business Analytics, Business Intelligence Development Studio (BIDS), SQL Server Agent, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), SQL Profiler, SQL Tuning Advisor, Erwin Data Modeler, MS Visio, MS Access, SharePoint, PowerPivot, Power View, Advance Excel, Excel VBA, Excel macros and etc.

Other Applications / System: Github, Confluence, Jira, Mantis, SalesForces, Window Active Directory, Agile software development, Team Foundation Server (TFS), ServiceNow, Jira, SharePoint, RDBMS, Data Warehousing, Entity Relationship Diagrams (ERD) and etc.

Methodologies: Agile Development, Business Process Modeling Notation (BPMN), Software Development Life Cycle (SDLC), Kimball methodology and etc.

Contact this candidate