Mike Fontaine Email & Phone Number

San Diego, California, Us

Responsible for the design, development, and maintenance of the backend software as it relates to the data infrastructure.Designed and developed the batch ETL software for a combination real-time/batch drug prescription analytic system (Intelligent Prescription - IRx) that informs both doctors (at the time of prescription) and pharmacists (at the time of fulfillment) of any potential drug interactions or complications based upon a patient's medical history and/or currently active medications.Designed and developed the batch ETL software for the next generation of IRx by implementing a new backend consisting of MongoDB and Python which replaces the old backend system of Oracle RAC, PL/SQL, and Python. Designed and developed a real-time messaging API for performance monitoring of Transcend Insights Analytic Software (developed as a consultant to Transcend Insights).

Tampa, Fl, Us

Responsible for the development of a performance monitoring system utilizing real-time messaging software adhering to the Advanced Message Queuing Protocol (AMQP 0.9.1).Designed and developed the python API utilizing the RabbitMQ Messaging Software. The API will be used to instrument current and future software applications developed by Anvita Health to monitor and log the performance characteristics of those software applications.

Sunnyvale, Ca, Us

Responsible for all development, maintenance and operation of the backend reporting and analytics infrastructure software for the Communications Data Engineering (CDE) group.Designed and developed the CDE Report Portal. A system that processes and aggregates raw Yahoo Mail and Instant Messenger data within the Hadoop environment which then transfers and loads the resultant data into Oracle for reporting and for further processing if needed.Designed and developed the Spam Reporting and Analysis System (SPARTAN). A system designed for the analysis of incoming and outgoing emails in an effort to understand spammer’s behavior.Developed software for transforming the denormalized SPARTAN data into a traditional data warehouse star schema format in order to load the data into Microsoft SQL Server OLAP cubes.Designed and developed ETL software for the Yahoo Music Campaign Management System.

Los Angeles, Ca, Us

Responsible for the content, transformation, and loading of data for the Capital Group’s Customer Relationship Management system (WISDOM) as it relates to the American Funds collection of mutual funds.Designed and developed Informatica mappings and workflows for the transformation and loading of customer data into WISDOM.Designed and developed Informatica mappings and workflows for the data conversion effort from Siebel 6.5 (one-to-many database) to Siebel 7.7 (many-to-many database).

Sunnyvale, Ca, Us

Responsible for the content, maintenance, operation, and development of the MusicMatch Data Warehouse as well as providing minor Oracle DBA support.Designed and developed data warehouse load software.Developed new Informatica mappings to facilitate easier royalty reporting to 75+ music labels.

Us

Responsible for leading a team of developers in the maintenance, operation, and development of the mp3.com Data Warehouse.Managed data warehouse content and developed daily load software.Designed the Enterprise Customer Relationship Management (ECRM) API to the data warehouse.Designed and developed ECRM daily load software providing denormalized customer data used for segmentation purposes when creating targeted emails.Provided SQL support to the analytics group.

Irvine, Ca, Us

Responsible for leading a team of developers in the maintenance, operation, and development of the Ingram Micro Data Warehouse. Remotely maintained Decision Support Systems (DSS) located around the world in eleven European countries, Canada, and the United States.Developed data warehouse and decision support systems (DSS) load software.Directed mainframe and client/server developers when implementing changes and additions to the data warehouse and various worldwide decision support systems.

Oslo, Oslo, No

Developed interface software for a financial budgeting application that integrated a Visual Basic user interface with an Oracle Express OLAP engine.Designed and developed an OLAP application for analyzing sales transactions.Designed and developed OLAP applications for leading healthcare providers.Designed and developed and OLAP application for analyzing satellite service activations.

Philadelphia, Pennsylvania, Us

Developed simulation software for the F/A-18 Weapons and Tactics Flight Simulator by interfacing with actual aircraft hardware.

Developed software and utilities for Computer Aided Design (CAD) workstations.