Responsible for converting legacy analytics and ETL processes into optimized Databricks SparkSQL

* Integrated Cash Assistance and SNAP(a.k.a., Food stamps) submissions between Access HRA web service and POS applications* Parsed JSON and XML through PLSQL procedures* Incorporated middleware API to streamline data flow and processing between various city applications* Developed ETL process to migrate data between inter agency applicationsMisc:* Interviewed potential candidates for PLSQL position and provided evaluation to the hiring manager/director

Database Developer: * Designed new data mart and created new objects including table, function, procedure, and trigger* Created complex views to incorporate data aggregation and conversion for non technical users* Developed ETL frameworks for routine data migration from over 10 different sources* Assumed DBA role to perform database backup using Oracle Enterprise Manager and utilized database expdp for schema dumpOracle APEX Web Service:* Developed a functional front end web services using Oracle APEX* Created user authentication module* Integrated database objects with APEX to display user data and to enable user to update their informationData Analyst: * Generated academic and fund reports to aid decision making among various key stakeholders such as advisors, admission office, finance/accounting, and the dean* Conducted both quantitative and qualitative analysis* Created Tableau interactive data visualization for academic research initiativeshttps://public.tableau.com/app/profile/joe.chen0315/viz/Dashboard_1236/MHC_StoryMisc:* Helped facilitate various activities during graduation commencement

Back-end support for JPMC FX businessTook part in regulatory requests for ESMA and ASIC as part of Dodd Frank Act

Participated in NJ Motor Vehicle Commission MATRX project to migrate existing mainframe application to JAVA and Oracle Database. Translated business ETL requirements into Oracle DB codes.