Jones He

Cell Phone: 979-***-**** E-mail: ac1lyg@r.postjobfree.com

ABOUT ME:

I am a highly skilled business intelligence professional with over 6 years' extensive experience in the Microsoft Business Intelligence stack using SQL SSIS/SSRS/SSAS tools. I have solid experience in SSRS Report development, SSIS package development, dashboard design and development using Microsoft BI developer tools. Now I am responsible for building large-scale big data processing systems and served as the expert in data warehouse design, integration of start-of-the-art Big Data technologies, and acceleration of Big Data processing requirements. My biggest asset is attention to detail. I am an honest, hard working individual who goes above and beyond what is expected in order to get the job done and to provide quality service to my clients.

OBJECTIVES:

Microsoft SQL Server Developer

Microsoft Business Intelligence Developer (SSIS/SSRS/SSAS)

Database Engineer/ Data Scientist/ Big Data Engineer

PROFESSIONAL SUMMARY:

Over 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 Life Cycle (SDLC) and core area of experience in validating end-to-end business scenarios of B2B (Business to Business) applications and enterprise applications.

Expert knowledge connecting Microsoft Azure-based Power BI to various data sources

Consulted with business partners and made recommendations to improve performance of Big Data systems, improve analytics systems, and prescriptive analytics systems.

Capable of extracting data from existing data warehouse system, design and implementation of data warehouse system by using Big Data technologies and tools.

Extensive coding experience, including JAVA, SPARK, C#, POWSHELL, Shell Scripting, SQL.

In-depth experience with Microsoft Business Intelligence Suite (Microsoft SSAS, SSIS,SSRS) and Power BI.

Extensive experience with Software Development Life Cycle (SDLC) (Feasibility, System Studies, Design, Coding, Testing, Implementation and Maintenance).

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.

Having over 8 years of strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS.

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

Experience in writing parameterized queries for generating tabular reports, formatting report layout and sub reports by using Global Variables, Expressions, Functions, Sorting the data, Defining data source and subtotals for the reports through SSRS 2008R2/2012/2014.

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

Experience 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).

Strong experience with SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.

TECHNOLOGY SKILLS

DATABASE

Microsoft SQL Server 2012/2014/2016, Oracle, MySQL, HBase, HDFS, Postgres, Hive, Teradata, DB2, NoSQL

PROGRAMMING

T-SQL, C/C++/C#, PowerShell, Java, HTML5/CSS/JavaScript, ASP.NET, .NET, Spark

MS BI STACK

SSIS, SSRS, SSAS, PowerBI

DEVELOPMENT

MS VSTS 2013/2015, Agile/Scrum, JIRA/Railly, SVN, Git/Github

PLATFORM

Windows 2012R2/2016, CentOS/Redhat Linux

EDUCATION BACKGROUND

Master Degree in Engineering - Texas A&M University, 2011 College Station, TX

WORK EXPERIENCES

01/2017 – present Management Science Associates, Inc. Pittsburgh, PA

Sr. Database Engineer (Big Data)

Designed and developed Big Data analytics platform for processing structured and unstructured data using Spark, JAVA, Hadoop, Hive and Pig

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

Created Spark ETL jobs to load Big Data into Hadoop File System (HDFS) and aggregated and integrated into Postgre database system.

Integrated Hadoop into traditional ETL jobs, accelerating the extraction, transformation, and loading of massive structured and unstructured data.

Lead several data extraction, warehousing design and analytics initiatives that enhance ETL progresses and performance.

Extensive experience in writing T-SQL Scripts, Stored Procedures, Triggers and Functions, creating SQL Server Jobs/Alerts, and Scheduled Tasks to automate tasks.

Experience with monitoring, troubleshooting and resolving database issues in 24 7 production environment.

09/2015 – 12/2016 State Street Bank Boston, MA

Sr. MS SQL Server and SSIS Developer

Responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses.

Developed accurate and scalable data models that can be successfully implemented for optimal production use.

Worked closely with Enterprise Architecture on data architecture standards and conventions to ensure that data architecture standards and conventions are appropriately applied within application development solutions.

Exposure to setting up and configuring Power BI related Gateways and related data connections

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 following 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 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.

Experience in generating Drill through and Drill down reports with drop down menu option, sorting the data, and defining subtotals in Power BI.

Experienced in creating DAX expressions.

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

May 2013 – August 2015 AT&T Richardson, TX

Microsoft SQL Server and SSIS Developer

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, created and maintained relevant architecture artifacts.

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

Experience in generating Drill through and Drill down reports with drop down menu option, sorting the data, and defining subtotals in Power BI.

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, and SSRS for reports.

Developing Batch scripts that were integrated in the SSIS packages using .NET and C#

July 2011 – May 2013 American Bureau of Shipping Houston, TX

Microsoft SQL Server Developer

Consulted with the business analysts and business users to determine logical design for new business solutions according to existing data architecture.

Designed and maintained invoice extract applications and file matching applications using T-SQL language following the client software development lifecycle.

Developed complex Stored Procedure, Views and User Defined Functions on MS SQL Server; identified weaknesses in T-SQL code and then improved those weaknesses for future release.

Collaborate with developers and QAs. Set up SQL/database mails to produce database health reports and other alerts.

Created and maintained documentations for all related projects; performed detailed code reviews, and created automated build and deployment scripts.

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.

Set up SQL/database mails to produce database health reports and other alerts on the production environment; monitored production databases for performance, availability and data integrity.

Experience in generating Drill through and Drill down reports with drop down menu option, sorting the data, and defining subtotals in Power BI.

Provided support to team member on a daily basis.

http://dlweb.cti.depaul.edu/main/CoursePage.asp?classid=7224&quarterid=25&instructorid=40746

REFERENCE Available upon request

Contact this candidate