Data Analyst Web Developer

David Hoang

Mc Farland • WI • ***** • United States • 860-***-****

Email: **********@*****.***

Objective

A dedicated and adaptable professional with many years of experience as a Programmer Analyst, Data Analyst, Web Developer, Service Information Developer, Production Support, and System Maintenance. Adept at managing and analyzing large datasets, implementing ETL solutions, and providing web-based technical solutions in diverse environments. Experienced in working with cross-functional teams to design, develop, and maintain solutions that drive business success. Seeking to contribute expertise in data management, software development, and system support.

Skills

Programming Languages & supporting tools:

SQL Python Asp.Net JavaScript XML Java

DataStage C# MySQL PL/SQL SAS STATA

Operating Systems:

Windows UNIX/AIX Linux

DBMS & Database Graphical User Interface tool sets:

Microsoft SQL Server MySQL AS400 PostgreSQL Oracle IBM DB2 UDB

Reporting Tools:

Business Objects Crystal Report Reporting Services (SSRS) SSIS

Work Experience

SpartanNash – Byron Center, Michigan 10/2022 – 09/2024

SSIS Developer (Contract)

Created and managed SSIS packages for data extraction, transfer and loading (ETL) into the data warehouse on a daily basis.

Supported the Project Wisconsin for the Supply Chain Application, especially in the Forecasting and Procurement functions.

Developed and maintained SSIS package reports using Business Intelligence, ETL Integration Services, and Reporting Services.

Created SQL queries for reporting applications, ensuring accurate data delivery.

Uploaded and validated spreadsheet data into Master Data Management (MDM) for customers, vendors and items.

Delivered SSRS and SSIS reports to enhance .NET and ASP.NET applications for various clients.

Conducted program reviews, rewrote programs, and made revisions to improve efficiency and meet evolving requirements.

Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.

Increased the quality and quantity of automated processes.

Technical environment: Toad for Oracle, SSIS, SQL, DataStage 8.5 & 9.1, SSRS, Control-M, UNIX, WinSCP, Putty, Citrix, Python, Snowflake

Sabre – Orlando, FL 03/2022 – 10/2022

SQL / Asp.net Developer

Migrated SSIS Packages from old to new versions during data migration.

Used ETL methodologies and best practices to create SSIS ETL Packages. Followed and enhanced programming and naming standards.

Based on business requirement, developed complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implementing the business rules and transformations.

Created alerts, notifications, and emails for scheduled SSIS packages execution.

Supported software development of existing functions including rewriting small parts of the system, improving system quality.

Modified the existing SSIS packages to meet the changes specified by the users

Technical environment: SSIS, Oracle SQL Developer, SoapUI 5.7.0, IIS, C# .Net, Python

Fisher Barton – Watertown, WI 07/2021 – 03/2022

IT Programmer and Developer

Supported on existing applications as well as creating new applications.

Managed multiple IT projects while prioritizing and scheduling tasks.

Technical environment: Visual Studio 2019, ASP.NET, C#, VB.Net, PHP, WordPress, SQL Server, Epicor, ERP, and Linux

University of Wisconsin, IRP – Madison, WI 10/2019 – 10/2020

Data Scientist (Contract)

Analyzed and processed large data sets using statistical software.

Cleaned and manipulated raw data to prepare it for analysis.

Compared different data models using statistical performance metrics, ensuring robustness and accuracy in data analysis.

Supported the Medicaid Evaluation, Research, and Technical Assistance (MERTA) activities within the Institute for Research on Poverty.

Conducted data programming, data management, and analytic tasks using data from Medicaid program enrollment and health care claims, and link the data to other datasets.

Technical environment: SAS, STATA, Python, R, SQL, Business Objects, Linux.

University of Wisconsin, CTRI – Madison, WI 05/2018 – 02/2019

SSIS Developer (Contract)

Developed complex SSIS ETL solutions using various transformations such as lookup, merge, derived column, data conversion, conditional split and aggregate.

Wrote SQL Scripts for data insertion, update and deletion in MS-SQL databases.

Migrated complex applications from MS Access to ASP.NET MVC 5 in C#.

Generated different types of reports (Tabular /Matrix) using MS SQL Server Reporting Services (SSRS).

Designed and created SQL Server Reports with drill-down and drill-through capabilities using SSRS.

Worked with researchers and intervention program staff to design data collection systems and interactive systems that coordinate workflow processes across team members as new projects and needs emerge.

Technical environment: Visual Studio 2017, C#, Business Intelligence, JavaScript, SQL Server Management Studio (SSMS), SQL, Access, Excel, Reporting Services (SSRS), SSIS, Python

IBM – Monroe, LA 03/2017 – 04/2018

Application Development Specialist

Supported and built technical solutions for CenturyLink, including application design, testing, and troubleshooting.

Identified program issues, documented defects, and worked with developers to resolve them.

Developed and executed test plans, ensuring compliance with standards and replicability.

Technical environment: Eclipse, Java 1.7, J2EE, JSP, XML, JavaScript, Linux/AIX/Unix, Oracle SQL Developer Version 4.1.5.21, Struts, Hibernate, JBoss, Serena Dimensions, IBM Rational Build Forge, WPC.

Data Dimensions – Janesville, WI 06/2015 – 07/2016

SQL / Data Integration Developer

Designed, implemented, and supported innovative solutions to solve complex technical or business problems.

Created SSRS reports for numerous clients.

Technical environment: Microsoft Visual Studio 2014, SQL Server 2014 Management Studio, Stored Procedures, Agile Development, Visual Studio Online, Delphi, C#, VB Script, Reporting Services (SSRS), Java

Education

Master of Science in Computer Information Technology

Central Connecticut State University, New Britain, CT. GPA 3.72 / 4.00

Bachelor of Science in Computer Science

Central Connecticut State University, New Britain, CT. GPA 3.46 / 4.00

Bachelor of Arts in Mathematics with minor in Computer Science

Central Connecticut State University, New Britain, CT. GPA 3.56 / 4.00

Contact this candidate