Summary
Overview
Work History
Education
Skills
Qualifications
Accomplishments
Websites
Timeline
Generic

Ryan Vuong

Pittsburg,CA

Summary

Reliable Database Developer known for overseeing workflow processes, database object creation and security implementation. A diligent employee with expertise in high availability SQL Server solutions. Ready for a new position that involves creating solutions that solve complex business problems. Well-qualified Business Intelligence Developer with demonstrated success in taking complex requirements and building efficient, successful systems. Knowledgeable about machine learning, programming and complex statistical analysis. Prepared to offer 10 years' experience in field to dynamic new position at Sutter Health.

Overview

27
27
years of professional experience

Work History

Senior Database Developer

HCA Healthcare Physician Services
Campbell, California
10.2019 - Current
  • Install and maintain MS SQL Server 2019 on Windows Server 2019
  • Perform databases replication, backup, recovery, DB security setup/maintenance
  • Set up and configure 2016 SQL Server Reporting Services server
  • Migrate and convert hundreds of 2005 SSRS reports to 2016 SSRS reports
  • Data extract and execute ETL process according to formats/requirements provided by quality tool vendor for care measurement and improvement
  • Convert and upgrade MS-Access Remittance Advice to 2019 SSRS report for viewing and printing.

Reporting Data Analyst II

HCA Healthcare Physician Services
Campbell, California
04.2019 - 09.2019
  • Create, schedule, and maintain reports primarily in SSRS and SQL Server
  • Monitor jobs run through SQL Server or PPMSI scheduler and correct any anomalies
  • Create and manage project plan/documentation(s)
  • Facilitate necessary meetings and prepare necessary status reports to ensure project tasks are being completed in a timely manner
  • Create required reference material and technical documentation as needed
  • Document processes and maintain report request or helpdesk logs
  • Participate in team design sessions and code reviews
  • Ability to interpret customer requirements, analyze data and identify trends and variance analyses
  • Ability to adapt to shifting priorities, and multitasking for client requirements
  • Maintain constant knowledge of application changes and industry changes to improve processes
  • Keep upper management informed of system and operational issues
  • Ensure quality of reports
  • Coordinate testing of system enhancements/implementations.

Business Intelligence Developer II

SelectQuote Insurance Services
San Francisco, California
05.2008 - 10.2018
  • Designed and published web-based applications utilizing SSRS, Visual Studio and SQL
  • Developed and built data visualization dashboards with Tableau Desktop
  • Generated and created Agent Sales Performance analysis report
  • Scheduled and executed monthly sales and finance reports using Business Object/Crystal and SQL
  • Strong troubleshooting on reporting issues, data and debugging codes
  • Automated data upload from external file and ETL processes utilizing SSIS packages
  • Collaborated with business users to define project requirements, prioritize reports and ad hoc requests
  • Updated and logged BI tasks in JIRA
  • Familiarized with SSAS cubes, Python, Machine Learning and R.

Data Analyst

NSC/Intera Communications
Pleasanton, California
01.2005 - 04.2008
  • Assisted Asset Portfolio Manager developing, implementing, and maintaining the adherence to company standards concerning public phones profitability and the commission process using Microsoft 2000 SQL Server
  • Replicated, created, and updated database, tables, views, and store procedures to a dedicated server from an external data and live production database for data warehouse, data mining/integrity, ad hoc queries, and enable users to access data via Total Coin Management application in real time
  • Uploaded Customer's monthly data from external files using SQL Server Import and Export Data
  • Interpreted and communicated financial data analysis to Senior Management
  • Scheduled and automated daily/weekly/monthly reports sent via Outlook Email in an attachment files
  • Prepared technical design, reports, applications and data upload process documentation
  • Ensured the integrity/quality assurance of underling data.

Applications Engineer

EveryPath Inc.
San Jose, California
09.1999 - 12.2004
  • Developed, converted and mobilized internet websites into wireless applications on Palm PDA,WAP-enabled WML/HDML smart phone, BlackBerry Rim Pager, Pocket PC and regular Telephones using XML, JAVA and Oracle backend to enable users to access data in real-time from anywhere.
  • Developed and demonstrated proof-of-concept demos/pilots on prospective customer websites on short notice in order to win business. Never missed a deadline in the process.

Applications Developer

Sutter Health
Emeryville, California
10.1996 - 09.1999
  • Developed, designed and implemented web based applications using JAVA and JDBC enable pharmacist to access physician and patient data.
  • Responsibilities included database programming in SQL/ISQL, improving and implementing data infrastructure in data warehouse, data extracts to new databases, tuning, data aggregation, and SAS interfaces to SYBASE.

Education

Bachelor of Science - Statistics

Universit of California, Davis
Davis
06.1995

Certificate - Data Science

DataQuest

Skills

  • Automation
  • Production Support
  • Performance Metrics
  • Report Writing Skills
  • Testing
  • Proficient in SQL
  • Troubleshooting
  • Code and Quality Standards
  • Source and Version Control: Git, , Visual Source Safe
  • RDMS Development and SQL
  • Object-Oriented Programming
  • Teamwork and Collaboration
  • Testing and Debugging
  • Application Development
  • Product Development
  • JIRA
  • Debugging and Troubleshooting
  • Technical Writing
  • Testing and Deployment
  • Project Documentation
  • Requirements Gathering
  • Data Warehousing
  • Analytical Thinking and Problem Solving
  • Dashboard Creation
  • Cross-Functional Teamwork
  • Code Reviews
  • HTML
  • XML
  • Crystal Report
  • Power BI
  • Knowledge of Python

Qualifications

  • Built self-served dashboards using reporting services SSRS, Crystal Reports and Power BI.
  • Extracted, transformed, and loaded patients/providers data into Cozeva Quality Care website portal.
  • Software application development and GUI design using JAVA, SQL and Unix.
  • Excellent troubleshooting and debugging codes.
  • Exceptional analytical and problem-solving skills.
  • Excellent communication skills.

Accomplishments

  • Mapped, extracted, and loaded patients/providers data into Cozeva Quality Care portal. Results: Providers can access patient data in real-time to improve the care of human life.
  • Upgraded 500+ of 2005 SSRS to 2019 SSRS. Results: All departments can access to self-served reports platform at anytime.
  • Automated, executed and validated monthly Sales Agent's compensation process. Results: Director of Finance and Payroll able to analyze & review and approve the compensation data in timely manner.
  • Daily, weekly, and monthly reports were automated and scheduled to be sent via Outlook. Results: Executive management to monitor/analyze coin revenues and profits on their owned public pay phones.
  • Developed and GUI designed applications using JAVA and JDBC. Results: Physicians, Medical Economics group, Executive Management, and internal users have seamless access to patient information.

Timeline

Senior Database Developer

HCA Healthcare Physician Services
10.2019 - Current

Reporting Data Analyst II

HCA Healthcare Physician Services
04.2019 - 09.2019

Business Intelligence Developer II

SelectQuote Insurance Services
05.2008 - 10.2018

Data Analyst

NSC/Intera Communications
01.2005 - 04.2008

Applications Engineer

EveryPath Inc.
09.1999 - 12.2004

Applications Developer

Sutter Health
10.1996 - 09.1999

Bachelor of Science - Statistics

Universit of California, Davis

Certificate - Data Science

DataQuest

Similar Profiles

CREATE PROFILE
Ryan Vuong