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 sourcesConceptualized, researched, designed, and developed in-house solutions to save the company over $100K annually at the direction of the Chief Data OfficerPerformed Power BI Service administrative tasks such as creating workspaces, managing access rights for users, scheduling refreshes, and investigating and fixing issuesMet with stakeholders to gather requirements and review work performed for their data and reporting requests

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 rotation

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 Services (SSRS)Created visualizations and dashboards using Microsoft Power BI DesktopCreated pivot tables, charts, and graphs using Excel 2016Met with stakeholders regularly to gather requirementsAgile/Scrum environment , 2-week sprints

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 procedures, functions, tables, views, and indexes for ETL and reporting solutionsCreated pivot tables, charts, and graphs using Excel with PowerPivotCreated visualizations and dashboards using Microsoft Power BI DesktopGathered requirements from stakeholders in an Agile/Scrum environment

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 Oracle web applications using Oracle Application ExpressResearched, analyzed, and rationalized information from multiple sources into multiple databasesDeveloped SQL scripts and procedures using Oracle SQL and PL/SQL and used database tools such as TOAD, SQL Developer, and MS Access to perform quality control of data deliverables.Developed and maintained technical reports

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 which included some programming to solve conversion issuesProvided some database administration of the Treasury department's databases (running MS SQL Server 2000)

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 formal company training on developing software using Rational Rose Real-Time, Object-oriented analysis and design, and the Java programming language

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