Resume

Sign in

Data Sql

Location:
Alpharetta, Georgia, 30005, United States
Posted:
November 02, 2018

Contact this candidate

Resume:

Chunhui (Cathy) Liu

732-***-****(C)

Email: ac7k5y@r.postjobfree.com

PROFESSIONAL SUMMARY:

• Extensive experience in database design, development & support of MS SQL Server thru to 2015.

• Proficient in creating database objects e.g. tables, views, procedures, functions and triggers etc.

• Extensive experience in creating complex SQL queries, stored procedures to meet business requirements.

• Strong experience extracting, transforming and loading (ETL) data between homogenous and heterogeneous

Systems using MS SQL Server Integration Services (SSIS).

• Extensive experience in creating, designing, developing, configuring and fine-tuning ETL workflows in

SSIS.

• Experience migrating SQL Server databases and SSIS packages across SQL servers.

• End to end experience in designing, developing and deploying data visualizations using Tableau and SSRS.

• Working knowledge of Tableau server and architecture.

• Self-motivated, good critical thinking, analysis and interpersonal skills

• Team-oriented, technically motivated, user oriented with a desire to learn client's business requirements.

• Strong inclination for finishing jobs before project deadline.

• Flexible, versatile and readily adaptable to new environments and projects.

TECHNICAL SKILLS:

• RDBMS: SQL Server, Oracle, Tableau Server, CRM

• BI/Reporting/ETL: SSRS, SSAS, SSIS, Tableau Desktop, Excel

• Languages: T-SQL, PL/SQL, Visual Basic

• Development Tools: Microsoft Visual Studio, Microsoft Management Studio

• Office Tools: MS Office (Project, Excel, PowerPoint, Word)

PROFESSIONAL EXPERIENCE:

UPS, Sandy Spring, Georgia June 2013 - Present

SQL/BI Developer

• Worked with business stakeholders, application developers to identify business needs and discuss

solution options.

Designed databases, stored procedures, reports, and data input interfaces using SQL Server 2005, 2008, 2012.

• Created and developed complex stored procedures, tables, indexes and other T-SQL Code in

Development and Production environments.

• Performed SQL query performance tuning by creating/modifying indexes, setting transaction isolation

levels, and changing query structured(used CASE to reduce table scans; used CTE and inline

calculation to replace sub-query-involved functions; used temp tables to reduce repeating retrieving,

etc.).

Imported, exported and manipulated large data sets in multi-million-row databases under tight deadlines.

Created/modified ETL processes to achieve weekly loading requirements.

Created SSIS Packages for integrating data using OLE DB connections from heterogeneous

sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations in SSIS.

Pulled data across multiple database servers (Oracle, SQL server, Access etc). Connected data sources

by Business intelligence tools (SSIS etc). Linked database objects (linked server etc) and inline

queried (OPENQUERY etc).

Migrated Databases, SSIS packages, SQL agent jobs from SQL servers 2005 to the SQL servers 2012

(DEV, UAT, and PRD etc). Involved software installation, database backup/restore, SSIS package

configuration files, linked server settings and agent job settings.

Design, develop, test, and implement SSRS reports and dashboard with multi-parameter, chart, drill-down, drill-through, and interactive sorting capability.

Develop complex data visualization reports and Tableau dashboards. Build dashboards, automated reports and report templates using advanced Tableau functions.

Johnson & Johnson, Raritan, New Jersey September 2009 to June 2013

SQL/BI Developer

Participated in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.

Built and maintained SQL scripts, indexes, and complex queries for data analysis an extraction.

Developed and deployed complex T-SQL codes, stored procedures, views, functions, triggers and jobs to support clinical data.

Wrote complex T-SQL queries, stored procedures and optimized the performance of queries with modification in SQL queries, eliminated redundant and inconsistent code, established joins and created indexes as needed.

Developed and built SSRS by using BI solution including cross-tab reports, matrix report, parameter report, dashboard with charts and drill through function

Coordinated and executed database migration to newly consolidated SQL Servers.

Installed, configured and maintained SQL Server Integration Services (SSIS).

Involved in designing, developing and testing of the ETL strategy to populate data from various source systems using SSIS.

Created and customized SSIS packages to populate and transform data from difference sources.

Ortho Clinical Diagnostics, Raritan, New Jersey September 2005 to September 2009

Clinical Data Specialist

Worked closely with Clinical developers on the design, testing and implementation of study databases.

Overseen data-management lifecycle of large clinical trials, composing and verifying reports and results.

Developed clear clinical data sets enabling the standardized collection and analysis of massive amounts of cross-boundary data content in a timely manner and with a high level of accuracy.

Tracked progress of clinical studies, ensuring projects meet timelines and quality expectations.

EDUCATION: MS in Chemistry, Rutgers – The State University of New Jersey

BS in Chemistry, Jilin University, Changchun, China



Contact this candidate