Tod Stewart Email & Phone Number

Santa Rosa, California

Greater Milwaukee Area

Data Warehouse Support, Analysis, DevelopmentKnowledgeShare, PowerShareOracle 10G, SQLLotus Notes

Advised client with regard to AdBase (Oracle 10G) advertising system schema, table relationships, table descriptions, field content and values.Assisted with AdBase setup and System Administration.

Designed, Developed Software to extract data from a SQL Server database and create a series of XML data files for an external vendor. The program was written in Visual Basic .NET, ADO.NET using Visual Studio 2008.Documentation and support.

Designed and created interfaces from/to the Advertising System to the Credit Card Payment Vendor and an interface from/to the Advertising System and the Telecheck SystemCreated a web export utility process application that was highly configurable including an Ad Hoc format designer module that was very robust to replace a slow and unaccommodating vendor solutionDeveloped Digital Command Language (DCL) command procedures that extracted information from several flat files that were used within VB applications to place this information into SQL databases, exported to external vendors, create batch credit card payment schemesDesigned and developed DLL's for VB, .NET applications using ActiveX Data Objects (ADO) for database applications for using communications via ODBCDevelopment of Visual Basic programs Development of Dynamic Link Libraries (DLL?s) for Visual Basic applications using Digital Visual Fortran and MS-VB, .NET for date/time transformations, Blowfish encryption algorithm, FTP processes and Database communicationsSupported Mactive AdBase support and development (Oracle) that includes; page layout, configuration of applications, troubleshooting, correction of data errors, purging expired .eps files and Mactive vendor interface tools; Tearsheet Exporter, ALS Importer, AdMission Manager, AdBase XML ImporterImplementation of customer facing AdBase Web Order ApplicationDocumentation and support

Designed and developed the Clinic Information System database to schedule patient hours, bill insurance companies, and generate reports as required by state law for 22 outpatient clinics, and one inpatient facility using DataEase, a RAD (Rapid Application Development) tool for data intensive PC applicationsDesigned and developed the Contract Management System database as a tool to manage insurance claims in a Managed Care environment. This tool is used to track all inpatient and outpatient stays for several large insurance companies and HMO's. Some of the major reports include utilization statistics by Age, Sex and Facility; Provider "Report Cards", manage patient authorized visits and most importantly keep track of used patient benefitsMade modifications and upgrades to designed databaseDesigned and developed external tools to view Patient Data in a GIS environment by displaying demographic information, Diagnostic Information, Age Distribution on a graphical map interface using MS-FORTRAN, MS-CDocumentation and support

Designed and developed meteorological and utility applications to add data to a file, correct existing data, view data within a file using MVS-FORTRAN, MS-FORTRAN, MS-C, ISPF and TSO Designed and developed a Lake Effect Snowfall Estimation application for Federal Express using FORTRAN in the McIDAS (Man-computer Interactive Data Access System) environment presenting information in textual and graphical formats for Pilots to check estimations of snowfall based on temperatures, wind directions etc for lake effect snowfall Developed a Flight Path Calculations application that allows pilots to access National Weather Service forecasts based on the pilot's flight pathOther Applications: Thermodynamic Diagrams (Graphics), Meteorograms (Graphics), Customized Terminal Forecasts (Text Input), Upper Air Wind analysis to determine best flight paths for airplane fuel savings, GRID format decoder, Satellite bit stream decoders, NOTAM decoder (Notice to Airmen), Pilot and flight crew advisory applications, GIS and map applications software, Documentation and software bug corrections

Development of interactive methods to display, alter, and update upper air weather in text and graphics format. IBM RS/600, UNIX (AIX), FORTRAN, C National Oceanic and Atmospheric Administration (NOAA)

Improve and maintain satellite based meteorological products for operational users. These include satellite image loop analysis to determine cloud displacement over time, the application could then determine wind speeds in the upper atmosphere in data sparse areas, especially over the open oceans; improving cloud height calculations IR absorption calculations with several infrared channels and true stereo using two satellites. MVS-FORTRAN Establish new interactive processing capabilities. These include methods to track hurricane trajectories, flooding analyses, manual cloud height applications. MVS-FORTRAN GIS Applications, satellite/earth location transformation routines, map transformation routines (Mercator, Conformal, Polar Stereographic). MVS-FORTRAN User defined software for specific applications in particular Sea Surface Temperature analyses. MVS-FORTRAN Weather forecasting

Designed and implemented interactive computer software. These include satellite image loop analysis to determine cloud displacement over time, the application could then determine wind speeds in the upper atmosphere and in data sparse areas, especially over the open oceans; A similar algorithm to perform the same task without manual intervention. MVS-FORTRAN Numerical Analysis Algorithms using many data sources as input...i.e. wind analyses, moisture analyses, pressure analyses, temperature analyses to produce models to calculate vorticity, divergence and surface analyses for time periods out to 48 hours. MVS-FORTRAN. Project Management for Data Systems Tests (DST) 1 and 2.Train new employees in application procedures and technique development on McIDAS. Participated in the Global Weather Experiment

Bachelor Of Science, Meteorology, Mathematics, Classics

Activities and Societies: American Meteorological Society, Zeta Beta TauAtmospheric and Oceanic Sciences, Physics, Mathematics, Classics

Mathematics, Physics

Physics, Mathematics