Analyst
Resume:
Matthew Tornquist
********@*****.***
Linkedin ID -https://www.linkedin.com/in/smashquist
Professional Experience —
Alpha Omega Integration, HRSA, Data Analyst/Bi Publisher Reports Manager, Oracle PL/SQL Developer, 1/22 - PRESENT
•Developed EBS BI publisher reports for the Government Health Resources & Services Administration in Oracle 21c.
•Data involved in CMS (centers for medicare and medicaid services.)
•Oracle PL/SQL scripting and development for application analysis with SQL Developer and TOAD.
•Created Oracle Forms and reports in Oracle E-Business Suite BI Publisher and analytics.
•OLAP database (online analytical processing)
•ETL Informatica PowerCenter 10
•Data PL/SQL software code review testing implemented in testing environmental space.
•Working experience in Data warehouse, data sourcing, data mapping.
•Experience in Jira for debugging, testing, reporting, planning, and project management production.
•Tableau Dashboard datasets and publisher reports consist of Medicare patient finances to Health Resources and Services Administration for their future budgeting processes.
•Data Warehouse structure repository.
•Designed and implemented interactive Tableau dashboards, visualizing key metrics on Medicare patient financials, enabling HRSA stakeholders to make data-driven decisions for future budget allocation and resource management.
SANOFI, REMOTE Oracle Developer/ PL/SQL Reports Lead, Business Data Analyst 9/2018 - 1/2022
•Oracle PL/SQL reports developer for submissions to health authority and business regulatory events Oracle 19c implementing changes.
•Extensive testing environments used user acceptance testing and systems integration testing for database software data integrity.
•Created database programming scripts, PL/SQL tuning, cursors, triggers, procedures, functions, programming loops, and package creation for Pharma business reporting.
•Experience in business regulatory submissions and business labeling data and drug product information labeling for regulatory submissions.
•Developed System Unit Tests and Code Reviews documents for test environment implementation.
•Consulted with RIM (Regulatory Information Management) for business of Oracle data in Veeva for reporting and development.
•Multitask with SQL Developer, Data modeler, 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 VEEVA database development.
•SAS software application for data analytics and data reports development.
•Python development in data science analytics using PyCharm.
•Created Manual User Testing, UAT(User Acceptance Test) cases front and back end application functionality in system test cases for health authority submissions using Agile/Waterfall methodology SOP.
•Remediated business data from improving oracle database backend applications within the business of Sanofi.
•Led the design and development of interactive dashboards using Oracle Business Intelligence Publisher and Power BI, enabling real-time monitoring of regulatory submissions and business labeling data, improving decision-making processes for key stakeholders.
•Lead system data business solutions to upgrade business processes and data analytics.
•Lead change management control in data configuration, change control testing, data analytic reporting, and data migration efforts to Veeva.
United Healthcare, REMOTE Oracle PL/SQL Developer, 6/2018 - 8/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.
•ETL Informatica PowerCenter 10 for data cleansing, data format revision, and data duplication.
•Used GIT repository for code versioning processing.
•Created database table instructions, medical writing manuals, Tableau graphic visuals, and reporting for developers and application users within United Healthcare.
SANOFI, Bridgewater, NJ Oracle PL/SQL Developer, 11/2013-6/2018
•Oracle developer 12c and configuration for application SHARE (submission to health authority and regulatory events) in ODS (operational data store).
•Managed and programmed updates to SHARE application. Developed backend programming logic, data extracts, and script tuning over an AWS cloud database environment.
•Supported configurations with database PL/SQL programming, SQL tuning, data migration, manual ETL scripting, and data remediation to IDMP(identification medicinal products).
•ODI (Oracle Data Integrator) event driven medicinal product integration process.
•Used CVS repository for code versioning control system.
•Authored support and testing with SIT(system integration testing),UAT(user acceptance testing) documentation.
•Created code reviews and unit testing in critical test environments before production implementation.
•Created application user Training documentation and upgrade procedure. Granted security permission roles to user groups.
•Troubleshooting technical issues with the users and customers making sure they are in compliance.
Lockheed Martin, Seattle, WA PL/SQL Developer Data Analyst, 9/2009-10/2012
•Oracle Database developer for Lockheed Martin.
•Increased efficiency and strengthen business processes
•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.
CACI, Seattle, WA ORACLE REPORTS DEVELOPER/PROGRAMMER, 9/2008-9/2009
•Created Application programs for government budgeting in Cold Fusion/Microsoft Access using Visual Basic/ C++ Programming and Oracle Databases.
•Created Microsoft access data budget and financial reports.
•Developed reporting tools in Coldfusion and CCS.
ARMY CORP OF ENGINEERS, Seattle, WA Business Data Analyst Oracle PL/SQL Reports Developer, 9/2007-9/2008
•Administered Oracle and Microsoft Access Databases for Army Corp. of Engineers.
•Developed software programs for Colonel and Sr. Army Corp of Engineers Staff.
•Created fiscal year employee budgeting reports for chief financial officer.
TALK AMERICA, NEW HOPE,PA NETWORK OPERATIONS MANAGER, 7/2004-8/2007
•Managed/monitored network cluster of UNIX/Windows/Database servers of Oracle and Informix for Talk America network operation center.
• Troubleshooted issues with database
•Monitored and troubleshooted database hardware at the datacenter.
EDUCATION
Bachelor of Science Degree in Computer Science 2004
Associates Degree in Business Administration 2002
CERTIFICATIONS
Security +
Government Secret Clearance (expired) Government Public Trust Acquired (active)
Contact this candidate