Jonathan Won Email & Phone Number

Salem, OR, US

Portland, Oregon, US

Created, modified, and maintained Power BI reports/dataflowsCreated, modified, and maintained SQL Server T-SQL scripts, stored procedures, views, and functions for Power BI reports/dataflows, SSRS reports, ETL processes, and ad hoc data requestsCreated and maintained Python scripts for automating ETL solutions originating from databases and web API data.

Salem, Oregon, US

Designed and developed automated ETL solutions using Microsoft SQL Server 2012/2014/2016 Integration Services (SSIS) for the Data Solution and Engineering departmentCreated T-SQL scripts and adhoc queriesMaintained and modified numerous existing ETL processesUsed Python as a data analysis toolProduction Support - Troubleshooted and fixed issues24/7 on-call.

Beaverton, Oregon, US

Designed and developed automated ETL solutions using Microsoft SQL Server 2016 Integration Services (SSIS) for the credit union’s day-to-day operationsCreated T-SQL scripts and adhoc queries, stored procedures, functions, tables, views, and indexes for ETL and reporting solutionsDesigned and developed reports using Microsoft SQL Server 2016 Reporting.

Designed and developed automated ETL solutions using Microsoft SQL Server 2012 Integration Services (SSIS) for onboarding new data for consumption by the companyDesigned and developed reports using Microsoft SQL Server 2012 Reporting Services (SSRS) for the Portfolio Management, Accounting, and Sales teamsCreated T-SQL scripts and adhoc queries, stored.

Hartford, Connecticut, US

Developed automated ETL solutions using Microsoft SQL Server Integration Services (SSIS) for the Data and Production Management group in the IT Medicaid divisionCreated SQL scripts, adhoc queries, stored procedures, functions, tables, and indexes for data imports/exports using T-SQLProvided production data and application support in a high volume environment

Developed and maintained custom scripts, packages, procedures, functions, and triggers using Oracle SQL and PL/SQL

Fairbanks, Alaska, US

Developed and maintained custom scripts, procedures, functions, and triggers using Oracle 10g/11g SQL and PL/SQLPerformed database administrative tasks such as importing and exporting data, creating database structures, creating users, and assisting senior DBA with database installations, monitoring logs, and database securityDeveloped and maintained.

Developed client/server applications and reports using Sybase PowerBuilder 8.0 and Oracle 9i/10g SQL and PL/SQLCreated ad hoc reports using TOAD, MS Excel, and MS AccessHelped maintain the Foundation's Intranet applications written in Microsoft Active Server PagesProvided software training and other technical training for UH Foundation's 75+ staff members

Provided support and administration of treasury department software applications and application servers (running MS Windows 2000 Server), including the newly purchased Foreign Exchange & Money Market applicationEvaluated the Foreign Exchange & Money Market application prior to purchase and took charge of the technical aspects of the conversion process.

Developed client/server applications using Sybase PowerBuilder 7.0 and Oracle 8iProvided software support for St. Francis application users

Provided technical support to customers (mainly software developers) using Rose Real-Time (the leading visual modeling and software development tool for embedded software at that time)Helped customers achieve their software development and business goals by researching, troubleshooting, and documenting development issues on a case-by-case basisReceived.

Developed and supported applications for the company's billing systemDeveloped reports using MS Access

Provided software support for manufacturing system applications written in COBOL running on an IBM MainframeProvided support for ViewCAD, a web-based interface to a database containing diagrams to technical schematics for Freightliner's trucks

B.S., Computer & Information Science

B.S., Psychology

Major, Psychology

Education record