Oracle PL/SQL application development, production readiness assessment, and system integration at Legence, Honeywell, Liberty Check Printing, Edina Realty, and Ceridian.
Build out from scratch a dimensional data warehouse in Microsoft Azure. Primary source is IFS ERP based in the Oracle Cloud. De-engineering of Oracle views and packages to form warehouse dimensional model. IFS roll out to 22 companies under Legence. Reporting provided by Power BI.
Temporary Data Warehouse built on Azure SQL Instance. IFS tables replicated from Oracle Cloud to SQL Server through SSIS, Transact SQL and SQL Agent. More than 100 tables replicated to Azure allowing for development and delivery to production of Service, Finance and Executive Power BI Reports.
Honeywell, Inc.1998–1999
Lead analyst in the production readiness role, leading Oracle Financial modules into production. Within this role, as Financial modules were being tested and configured, prior to production a planned production readiness method would be developed and executed. Applications required for this effort were developed in Oracle OCI, PL/SQL and Visual Basic.
Lead analyst in the co-existence project linking Oracle Financials to a Service Management application based on Microsoft SQL Server. All applications developed through a mix of Perl scripts and PL/SQL procedures.
Liberty Check Printing, Inc.1996–2000
Extensive experience developing Oracle PL/SQL stored procedures used to report financial data for numerous credit unions. Oracle SQL Loader is used to read the data from the heterogeneous customer mainframe systems. Once loaded, the data is manipulated to closely represent the needs of the financial reports themselves. Entire system is driven by Oracle PL/SQL procedures with Oracle Forms and Report Writer providing financial reporting capabilities.
Edina Realty, Inc.1996–1998
Development of Oracle Call Interface manager application used to replicate data from an IBM RS6000 platform to numerous Novell platforms. The application, written in C, drives a third party tool (Infopump) distributing data to Novell instances.
Development of Oracle Call Interface ETL application to load data from ASCII data files into an Oracle database. The data, consisting of realty data and property photographs are loaded into Oracle seven times per day.
Development of a PL/SQL migration application used to migrate public record property data from a third party data feed into an Oracle database. The migration includes 900,000 properties across 9 counties on an annual basis for property data and a monthly basis for sales updates.
Ceridian, Inc.1991–1992
Lead analyst/developer in the development of an ETL application used to load legacy based energy data into the processing agent of an Oracle based hub and spoke energy management system. The protocol named Widenet manages data from 5 remote servers in a centralized server. An Oracle Call Interface application was developed to provide two way communication between the Widenet coordinating system and legacy systems.