Matthew Tornquist

adwnwk@r.postjobfree.com

908-***-****

EXPERIENCE

ORACLE BI PUBLISHER REPORTS DEVELOPER, AOI; REMOTE 12/22 - PRESENT Developed reports for the Government for Health Resources & Services Administration in Oracle 19c. Created reports in Oracle E-Business Suite BI Publisher and analytics. Reports consist of medicare patient finances reported to Health Resources and Services Administration for their future budgeting processes.

BUSINESS DATA ANALYST PL/SQL REPORTS LEAD, SANOFI; REMOTE 7/2018 - 10/2022 Oracle PL/SQL reports developer for submissions to health authority and regulatory events Oracle 19c. Created database programming scripts and cursors, triggers, procedures, functions, programming loops, and packages for Pharma business reporting. Experience in regulatory submissions and labeling data, and drug product information labeling for regulatory submissions. Developed System Unit Tests and project requirements needed. Consulted with RIM(Regulatory Information Management) of Oracle data in Vevva for reporting and development. Multitask with SQL Developer, and TOAD software regarding database development and administration. Oracle Business Intelligence publisher or(Power BI) reporting tools to support reporting and Dashboard creation, AWS/Cloud for reporting in Vevva database development. SAS software for analytics and data management. Created Manual User Testing, User Acceptance Test cases front and back end application functionality in system test cases for health authority submissions using Agile/Waterfall methodology SOP. Remediated data and migration updating from oracle database applications within the business of Sanofi. Lead system business solutions to upgrade products and data services.

ORACLE PL/SQL DEVELOPER, UNITED HEALTHCARE; REMOTE 4/2018 - 7/2018 Oracle 19c developer for united healthcare customers, insurance policies, and finance. Developed complex PL/SQL queries, extracts, exceptions, procedures, cursors, indexes, triggers, views, updates, migration, and functions scripting for insurance reporting. Data migration ETL using ODI software, Created database scripts for tuning database functionality and integrity . Developed power BI and Business intelligence reports. Created database table instructions, medical writing manuals, Tableau graphic visuals, and reporting for developers and application users within United Healthcare.

ORACLE PL/SQL APPLICATION ADMIN, SANOFI; BRIDGEWATER, NJ - 2013-2017

Oracle developer and configuration for application SHARE(submission to health authority and regulatory events). Managed and programmed updates to SHARE application. Developed backend programming logic, data extracts, and script tuning over a AWS cloud database environment. Supplied support with database PL/SQL programming, data migration, and data remediation to IDMP(identification medicinal products). Authored support and testing with SIT(system integration testing),UAT(user acceptance testing) documentation. Created application user Training documentation and upgrade procedure. Granted security roles to user groups. Troubleshooting technical issues with the users and customers making sure they are in compliance.

SQL/SOFTWARE ENGINEER, LOCKHEED MARTIN; SEATTLE, WA — 2010-2012 DBA and database developer for Lockheed Martin. Developed/maintained Oracle/Access databases using Toad Software and PL/SQL programming. Created intranet/internet web pages in Cold Fusion and software finance reports in Microsoft Access with C++/Visual Basic software programming linking Oracle Databases/Microsoft Access Databases for Sr. Budget Staff.

SQL/SOFTWARE ENGINEER, ARMY CORP OF ENGINEERS; SEATTLE, WA — 2008-2010 Administered Oracle and Microsoft Access Databases for Army Corp. of Engineers. Developed software programs for Colonel and Sr. Army Corp of Engineers Staff.

DATA APPLICATIONS PROGRAMMING/TECH SUPPORT, CACI; SEATTLE, WA— 2007-2008 Created Application programs for government budgeting in Cold Fusion/Microsoft Access using Visual Basic/ C++ Programming and Oracle Databases

NETWORK OPERATIONS MANAGER, TALK AMERICA; NEW HOPE, PA— 2005-2007 Managed/monitored network cluster of UNIX/Windows/Database servers of Oracle and Informix for Talk America network operation center.

EDUCATION

Bachelor of Science Degree in Computer Science Associates Degree in Business Administration

CERTIFICATIONS

Security +

Government Secret Clearance