Legence,Inc

• Build out from scratch a dimensional data warehouse in Microsoft Azure. Primary source is IFS ERP based in the Oracle Cloud. Dengineering of Oracle views and packages to form warehouse dimensional model. IFS roll out to 22 companies under Legence. Reporting provided by by Power BI.
  Temporary Data Warehouse (pipeline instance) built on Azure SQL Instance. For speed of delivery IFS tables replicated form Oracle Cloud to SQL Server through SSIS, Transact SQL and SQL Agent. More than 100 tables replicated to Azure allowing for the development and delivery to production of Service, Finance and Executive Power BI Reports.
  Power BI reports built for Finance, Service, Program Management and Excutives. Reports include Finance (General Ledger Trial Balance, AR/AP Aging, Billing Support, and Customer Invoice Analysis), Service (Contract Pricing, Contract Cost, Contract Revenue and Work Order Analysis), Program Management (Job Cost Detail, Material and Labor Detail), Executive (Purchase Order Audit, Rate Agreement Audit, Billed hours Audit).
  Deengineering of IFS data model to build a dimensional data model. Oracle Cloud views and packages analyzed to drive a 120 dimension, 35 fact table data warehouse. Warehouse hosted in Microsoft Azure Fabric with Data Factory as the tool to provide ETL.

Honeywell,Inc

• 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

• 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

• 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 a ASCII data files into an Oracle database.  The data, consisting of realty data and property photographs are loaded into Oracle on a seven times of 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

• 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.  Widenet provides a common protocol for the 5 remote servers and single central server to communicate.  An Oracle Call Interface application was developed to provide two way communication between the Widenet coordinating system and legacy systems.