Senior Applications and Database Analysis/Design/Architect/Developer

Vincent Scorsone Professional Resume

Location Abita Springs, Louisiana 70420

Phone +1-504-***-****

Email **********@*******************.***

LinkedIn www.linkedin.com/in/dataforceconsulting

Summary

Seasoned IT professional with 20+ years of experience, including 15+ years of consulting in public and private sectors. Led technical teams across multiple industries through all phases of the software development lifecycle, from requirements gathering to maintenance. Specializes in designing, modeling, and architecting OLTP and OLAP enterprise data systems, with expertise in ETL and ELT pipeline development and integrating data systems through APIs. Extensive experience in developing and customizing COTS and proprietary implementations of accounting, ERP, HRM, and CRM systems. Strong operational expertise in database administration, enterprise software installation/configuration, and database security/OS-level hardening. Recognized for solving complex problems, making mission-critical decisions, quickly adapting to project and team standards, ensuring user satisfaction, and mastering new technologies and methodologies. Technology

●Databases & Data Warehousing: Oracle Database (on-premise/autonomous), Microsoft SQL Server, Oracle Enterprise Manager, SQLite, MySQL, PostgreSQL, Quest TOAD, Oracle SQL Developer, Oracle Warehouse Builder, Informatica PowerCenter, Talend, Jitterbit, Skyvia.

●Programming & Development: JavaScript, HTML, CSS, Python, PL/SQL, T-SQL, XML, JSON, Visual Basic, UNIX Shell, SFDC/VF/Apex, PeopleSoft SQR, Perl.

●Data Modeling & Integration: Oracle SQL Developer Data Modeler, CA ERwin, IBM Rational System Architect, Microsoft SSIS, Talend Open Studio, Data Mart/ETL/ELT pipeline development.

●Cloud Platforms & Middleware: Oracle Cloud Infrastructure (OCI), Oracle APEX, Oracle SOA Suite, Microsoft Azure, VMware vSphere, Fusion Middleware.

●Enterprise Applications: Salesforce (Administrator/Developer), FinancialForce, Ellucian Banner, Oracle EBS, Oracle HCM, PeopleSoft Financials/HRMS.

●Reporting & Business Intelligence: Power BI, Oracle BI Publisher, Informatica, Noetix Views, SQL-based dashboards, and custom reporting.

●Virtualization & Operating Systems: MS Windows Server, Linux, UNIX, Oracle VirtualBox, VMware vSphere, UTM virtualization.

●Project & Version Management: Azure DevOps, TFS, Github, Broadcom Rally, Serena Dimensions, Tortoise SVN, Quest STAT.

●Cybersecurity: CompTIA Security+ certified, DoD 8570.01 IAT Level 2 compliance, database and OS-level cybersecurity.

●Methodologies & Practices: Agile (Scrum, Kanban, SAFe), CI/CD, DevOps, Waterfall, UML, Kimball DW/BI Lifecycle. Experience

Data Integration Engineer/Contractor at ACS, Austin, TX.Sep 2023 – Dec 2024 Fixed contract/freelance basis. Exporting, importing, and integrating Shopify online e-commerce orders to invoices for existing Zoho Books accounting system; Development and ongoing maintenance of automated scheduled data control and data flow mapping processes developed using Skyvia Cloud Integration Platform and SQLite.

Oracle APEX Developer/Contractor at Federal Deposit Insurance Corporation (FDIC), Washington, DC.Aug 2021 – Jun 2023 Operations/maintenance and enhancement support, providing rapid development of FDIC’s portfolio of front-end receivership and resolution applications, using Agile project management and CI/CD via MS Team Foundation Server, working closely with business stakeholders in implementation, roll out, migration, integration, upgrades, testing, performance tuning activities, and facilitation of all levels of testing including UAT; Application development in Oracle DBMS 19c, Oracle APEX 22.2, PL/SQL, JavaScript, and HTML/CSS.

Data Engineer/Contractor at Tulane University, New Orleans, LA.Mar 2020 – Jul 2020 Maintenance and development of Tulane’s MS SQL Server based Enterprise Data Warehouse (EDW); design, execution, and testing of ETL operations via MS Visual Studio, MS SSIS, MS SSMS, MS T-SQL, staged from Oracle based user systems, including Ellucian Banner Oracle HCM and Oracle EBS; Data modeling, data analysis, data integrity, and assisting QA testing; led design efforts of enterprise data mart to be used via MS Power BI reports and dashboards for data consumption by the user community; performed Data Architecture Team training, and assisted with evaluating data-management technologies; Agile project development management via MS Azure DevOps/Broadcom Rally. Data Integration Specialist/Subcontractor at Rebel Athletic, Carrollton, TX.Nov 2017 – Dec 2018 Fixed contract/freelance basis. ETL/Integration of WooCommerce e-commerce orders and customer information into existing Salesforce CRM and FinancialForce Accounting Systems, using Talend Open Studio for Data Integration. Fully automated global context/parameter driven services real-time sales order transfer from websites using multiple e-commerce-based systems with process-driven error handling, exception file generation, and reporting via email alerts. Talend Open Studio installation and deployment on Windows Server 2012 R2 and MacOS/Linux platforms, implemented in separate dev/test/prod environments, and generated, built, and executed from standalone Java packages.

Data Integration Developer at Ochsner Health, New Orleans, LA.Oct 2017 – Mar 2020 Manage data analysis and data integration of disparate systems. Design, model, and build dimensional DW architecture for system wide Enterprise Data Warehouse. Build extensible data acquisition and integration solutions using Informatica 10.2 to meet functional and non-functional requirements. Develop quality standards to ensure data quality and integrity across various Oracle 12c database systems. Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment. Develop custom online user applications using Oracle APEX development environment. Salesforce Developer at Ellis Marsalis Center of Music, New Orleans, LA.Jan 2017 – Nov 2017 Provide services on a volunteer basis via participation in the Salesforce.org NPSP community, including custom development on Salesforce CRM used for managing school semester enrollment, students, attendance, classes, curriculum, sessions, donations, and tuition payment processes, and booking of music venues throughout the facility. Responsible for development of Salesforce custom objects, Apex classes using SOQL data queries, Visualforce pages, dashboards, and reports to manage payments and receipt of school tuition, facility fees, and services, and to facilitate donation rentals and bookings of school facilities. Senior Data Analyst/Contractor at U.S. Department of Navy, New Orleans, LA.Aug 2015 to Sep 2016 Data modeling, conversion, migration of interfaces, and consolidation of all transactional processes and reporting of U.S. Navy personnel and military records for all enlisted and active duty officers, and officer candidates of the U.S. Navy Reserve, and Naval Reserve retired personnel into the NSIPS PersMod PeopleSoft ERP. Data analysis, data modeling and documentation for DoDAF using CA ERwin and IBM Rational System Architect, and Oracle database design and development using Toad, SQL, and PL/SQL, for custom report and interface design and development, identifying data dependencies, source-to-target data mappings, and ETL development for migration of legacy COBOL/DB2 flat-file database system consolidation into existing customized Oracle based PeopleSoft ERP. Data Center Consolidation DBA/Contractor U.S. Department of Navy, New Orleans, LA.May 2012 – Apr 2015 MS SQL Server, and Oracle database installation, assess and implement cyber-security technical database and network assurance updates (STIGs), conversion, administration, integration and support for U.S. Department of Navy, SPAWAR Systems Command for application rationalization, modernization, virtualization, data migration, data hosting, business process re-engineering and integration of more than 100 Navy data centers to Windows Server, Linux, and Oracle Solaris based Download latest version of this document Page 1 of 2 Rev. 2025.04.28.16.12.45 Vincent Scorsone Professional Resume

servers installed within VMware virtualized server environments. Installation and patching of Oracle EBS r12, Oracle Fusion Middleware - Oracle Forms and Reports, and Oracle WebLogic, in shared development, testing and production environments. Senior Engineer at Globalstar, Covington, LA.Nov2010 – Sep 2011 Oracle EBS 11i BI/Reporting and Technical Lead, RICE Specialist, supporting GL, AR, AP, FA, INV modules. Company-wide Oracle EBS 11i administration, technical support, and end user financial report development, including XML/BI Publisher, FSG development of GL account hierarchy structures and company trial balance and financial statement of operations. Administration and end user support of Oracle BI Discoverer financial reporting repositories, and installation and administration of Noetix views.

Oracle Applications Technical Consultant at RAMWare, Baton Rouge, LA.Feb 2010 – Oct 2010 Clients included Tulane University, and Edgen Murray Corporation. Served as a Consultant/Oracle Developer, leading the conversion of legacy COBOL-based payroll and budget processes to an Oracle-based solution, eliminating hundreds of mainframe programs. Developed custom reports and multi-currency integration for Oracle EBS Payables and Receivables modules using Oracle Reports and BI Publisher. Managed full lifecycle development of a GL JE Oracle 11g data warehouse prototype and created interfaces from legacy systems using Oracle SOA, JDeveloper, and BPEL Process Manager. Utilized Oracle 11g, SQL*Loader, PL/SQL, and SQL Developer across both Windows and UNIX environments. Chief Software Systems Engineer at SAIC, San Diego, CA.Oct 2007 – Jan 2010 Clients included Entergy and Allergan. Performed installation, maintenance, and performance tuning of Oracle 10g and 11g databases, including table tuning, indexing, and SQL optimization. Developed system database and schema installation scripts using SQL*Plus. Analyzed and gathered system requirements to update PeopleSoft HCM and eRecruit in compliance with EEOC guidelines and standardized data across environments. Designed, built, and managed data warehouse models and ETL processes for regulatory and scorecard-based reporting systems, integrating data from Oracle, SQL Server, MS Access, and spreadsheets. Managed conversion of PeopleSoft HCM processes and external HR vendor interfaces for system migrations. Provided technical architecture, infrastructure design, and ETL strategy for clinical and development data warehouses and portals. Produced work estimates and analysis documents, ensuring alignment with business requirements and data integrity.

Data Warehouse Architect/Contractor at U.S. Department of Navy, New Orleans, LA.Feb 2007 – Oct 2007 Oracle PL/SQL HR process/maintenance and ETL and Design of full lifecycle of SPAWAR CIMS Analytics data warehousing system, sourced from PeopleSoft HCM using Business Objects Reports.

Data Warehouse Architect/Contractor at U.S. Department of Energy, Germantown, MD.Sep 2003 – Feb 2007 Design, ETL, and full lifecycle development and maintenance of data warehouse and reporting system for I-MANAGE integrated Data Warehouse, implemented within an Oracle Application Server 10g Portal environment for DOE’s Office of Management, Budget, and Evaluation. Sources include Oracle EBS 11i, PB Views, and various custom systems.

Senior Business Intelligence Consultant at Appsability, Atlanta, GA.Apr 2002 – Sep 2003 Clients included Bollinger Shipyards Inc, Orleans Parish School Board, Paragon Casino Resort, and Louisiana Department of Health & Hospitals. Developed and designed custom databases and data warehouses to centralize and streamline data collection and distribution from various sources, including Oracle EBS 11i, Oracle Projects, MS Access, and Primavera. Converted and tested HR/Payroll Data Mart from test to production, including build and load scripts. Led the design and full lifecycle development of custom data warehouses, including Oracle EBS 11i RICE conversion of custom forms, modules, and objects. Delivered integrated solutions within Oracle NBI/EAC and EBS environments to improve data accuracy and project tracking. Oracle EBS Technical Developer/Contactor at U.S. Postal Service, Minneapolis, MN.Feb 2002 – Apr 2002 Oracle EBS 11i RICE implementation custom reports development Receivables Module. Development included custom schema and reporting for Receivables Accounting Statements, Invoices and Dunning Letters with interfaces, custom print generation to Mainframe systems using UNIX Shell scripts, and Oracle EBS 11i object migration and concurrent manager setup.

Senior Principal Consultant at Oracle Corporation, Redwood Shores, CA.Jun 1996 – Jan 2002 Clients included U.S. Department of Navy, U.S. Postal Service, PacWest, Alside, Continental Airlines, agentGO.com, Nortel Networks, Kerr-Mcgee, TIGI Products, Texas Instruments, Texas Parks and Wildlife Department, and Texas Natural Resource Conservation Commission (TNRCC). Extensive experience as a consultant and technical lead specializing in Oracle EBS 11i, Oracle Business Intelligence, and data warehousing. Expertise includes developing and customizing RICE components (Reports, Interfaces, Conversions, and Extensions) for order management, receivables, inventory, and financial systems. Successfully implemented Oracle BIS and EBS across financial, operational, human resources, and manufacturing modules. Led the design and development of custom data marts, ETL processes, and reporting schemas, including performance tuning and debugging PL/SQL scripts. Designed logical and physical data warehouse builds and automated schema generation. Delivered end-to-end Oracle BI and EBS solutions, including custom workflows, alerts, and notifications. Proficient in Oracle database administration, Oracle Designer, and Oracle Enterprise Manager across multiple industries, ensuring system integrity, scalability, and enhanced business intelligence.

Education & Certifications

●Bachelor of Science, Computer Information Processing w/ minor in Business Administration, Loyola University, New Orleans, LA.

●Jitterbit Foundations Certified - level 1, Jul 2017.

●Salesforce Certified Platform Developer 1 - 17091395, Apr 2017.

●Salesforce Certified Administrator - 17022753, Mar 2017.

●Scaled Agile Framework SP - SAFe Practitioner, Oct 2015.

●Certified as Cybersecurity Workforce in accordance with DoD 8570.01 M Information Assurance Technician (IAT) Level 2, 2014-2015.

●Oracle Database 11g Administrator, Certified Associate - 22359215, Jul 2013.

●CompTIA Security+ CE - 001*********, Mar 2013.

Honors & Awards

●SAIC/Entergy: SAIC Success Stories – Recognized in role as Technical Team Lead on RAI project at Entergy Corporation.

●Oracle Consulting: Firefighter Award - Federal Civilian, Consultant of the Month - South Central (3 time recipient), Consultant of the Quarter - South Central. Download latest version of this document Page 2 of 2 Rev. 2025.04.28.16.12.45

Contact this candidate