Chunhui (Cathy) Liu

Alpharetta, Georgia *****

Cell: 732-***-****

Email: adguzs@r.postjobfree.com

PROFESSIONAL SUMMARY:

•Extensive familiarity with data management principles and best practices to properly store, migrate, and structure data for multiple applications.

•Advanced technical knowledge and background in the areas of data mart, data management, data quality, data governance, data integration and data security.

•Deep understanding of relational databases (e.g., SQL Server, MySQL, Oracle) and data warehousing.

•Extensive experience translating business requirements into data structure requirements and logical and physical model.

•Extensive experience of engaging cross-functional business units, stakeholders, and vendors to communicate and implement technical solutions.

•Database Administration and Development for very large and complex databases in SQL Server 2008 through 2016.

•Extensive Experience of SQL server database administration, database security management and database migrations.

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

•End to end experience in designing, developing, and deploying data visualizations using Tableau, Power BI and Qlik sense.

•Experience of SSAS cube configuration, security management and troubleshooting.

•Experience of ETL development with Azure data storage solutions, Azure data processing solutions, and Azure data security and compliance.

• Self-motivated, strong critical thinking, problem solving, analytical and interpersonal skills.

• Excellent judgment and ability to analyze issues quickly and to take appropriate actions.

•Team-oriented, technically motivated with a high degree of flexibility and the desire to serve.

• Extraordinary ability to work effectively with both business and technical stakeholders.

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

• Strong project management, organizational and time management skills.

PROFESSIONAL EXPERIENCE:

UPS, Atlanta, Georgia

Business Intelligence & Analysis (BIA) department

February 2015 to Present, Sr. Database/BI/ETL Developer

Work with business stakeholders to gather conceptual view of business requirement and create logical views of business models to meet the business objectives, and eventually translate the business logic into code.

Database design, development & support of MS SQL Server in SQL Server 2008 through 2016.

Development and deployment of all procedures, function, tables, SSIS packages, power BI reports which interface with multiple applications across the company.

Write Complex Stored Procedures, Indexed Views, DDL/DML Triggers and User defined Functions for data consistency and manipulation.

Design, develop, configure, and fine-tuning ETL workflows in SSIS.

Security management of SQL server databases, SSAS cubes, and power BI reports.

Work on migration of SQL databases, SSIS packages, and jobs across SQL servers and to Azure cloud.

Design, develop ETL processes with Azure data storage solutions, Azure data factory and Azure data security and compliance.

Work on SSAS cube configuration, security management, maintenance, and troubleshooting.

Proven strong capabilities in troubleshooting and bug fixing on databases and applications, resolving issues without excessive downtime or data loss.

Proactively work with business stakeholders to move forward the implementation of data visualization tools like Tableau, Power BI to provide insights on business performance.

Involves in the development and management of project plans, monitor the project progress, and provide project status report to management teams.

Johnson & Johnson, Raritan, New Jersey

September 2009 to December 2014 SQL Server DBA/Developer

Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects.

Involve in planning, defining, and designing database based on business requirements and provide documentation.

Install, configure, and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.

Determine database management needs and recommended system upgrades, as necessary.

Ensured that databases are restored in a timely and efficient manner in the event of system failure.

Manage Database Administrator procedures for monitoring database performance, testing, archiving, and optimizing.

Defined and created database objects (tables, views, stored procedures, indexes, functions, and jobs).

Identified and resolved database performance issues.

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

Involved in development, deployment, enhancement, testing and tuning of ETL in SSIS.

Technical Skills

• Development Tools: Microsoft Visual Studio, Microsoft Management Studio

• SQL Server (9 years)

• MySQL (5 years)

• Oracle (4 years)

• Tableau Server (3 years)

• Azure SQL Database (3 years)

• SSRS (3 years)

• SSAS (4 years)

• SSIS (8 years)

• Tableau Desktop (3 years)

• Power BI (3 years)

• Qlik sense (3 years)

• T-SQL (10+ years)

• PL/SQL (5 years)

• PowerShell (4 years)

• Visual Basic (4 years)

• MS Office (Project, Excel, PowerPoint, Word) (10+ years)

• Data Warehouse (7 years)

• Requirements Gathering (10+ years)

• Scripting (9 years)

• Data Modeling (6 years)

• Azure Data Factory (3 years)

• Azure Data Lake (1 year)

EDUCATION: BS in Applied Mathematics, Jilin University, Changchun, China

Contact this candidate