Responsible for designing, capturing and supporting mission data to support the 96^th Test wings readiness. This includes the support of existing applications, updates to the applications, designing and coding database objects stored procedures, views, functions, triggers for capturing the mission data.

Responsible for the JOCAS billing process to correct any database issues related to the data capture and the integrity of the files sent for processing to the Government Accounting Office.

Additional development work with creating new Web Applications using Microsoft c# with a SQL back end to support / capture mission activities, data administration and support

Create associated application documentation for continued maintenance and end user Knowledge support. Additional responsibilities include working with the Government’s CMMI process for software development using Microsoft Team Foundation Server.

Responsible for designing Crystal Reports to support multiple business functions. This includes design and coding database objects stored procedures, views, functions for the underlying report data sources. Assist with handling support tickets for reports managed by internal WEB application. Additional work with Business Objects Server administration and support. Create associated report and application documentation for long term maintenance and user Knowledge base. Additional responsibilities include

Responsible for conversion of a Windows Smart Client application to a Web AJAX application that handles the management of prescription drugs for patients from the initial ordering thru shipping. Designed the initial aspx pages with VB.Net using AJAX with stored procedure calls via a data services layer to a SQL Server 2008 database. Created and Modified existing and new stored procedures from the existing database model to support the new application users controls. Designed a WEB based reporting utility using Crystal Reports XI R2 to support the requirements for tracking drug requirement and productivity information. Developed all underlying business logic classes to support transporting the data from the database to the WEB Pages and back for updating of member information.

Designed a Windows based billing system with a SQL database and custom reporting that collected the data from various ATT locations, processed the text file data, filtered it by the business rules and loaded it into a relational database. The billing analyst were taking three weeks to produce billing statements for the MSDN charges for ATT's larger customer base. The MSA application took over a year to develop and deliver to the business allowing a single analyst to run the monthly billing in less than five minutes and have historical data available with reports if needed.

Designed a Computer File management system using Microsoft Visual Basic and Microsoft Access tofacilitate CAD design files. The new application managed CAD drawings for any given projectacross various engineering disciplines in a client server architecture.

Designed and implemented a Plot Management System using Microsoft Visual Basic to manageAutoCAD and Microstation CAD Plots for Novell and NT Operating Systems. The application allowedengineers to plot CAD design files from a menu interface without having to open the design file in aCAD environment.

Designed a Visual Basic Application to read in ASCII data files and graph Well coordinates withcontamination areas for Hydrogeology Engineering group.

Developed an Engineering Cost estimate application using Microsoft Visual Basic and MicrosoftAccess. Core Data was downloaded from Oracle Views. The application used additional third partyActiveX controls for spreadsheet functions to calculate cost from various accounting cost codes.

Developed an Internal Intranet using Lotus Domino, Javascript, HTML and LotusScript (Active ServerPages) for a 1200 user base environment. Additionally, processed orders to a back end data ordermanagement system using DB2 tables from Lotus Script Server Agents.

Developed B2B e-commerce shopping cart and WEB interface for customer ordering.

Designed and developed an internal phonebook using Crystal Reports from an underlying DominoDatabase.

Designed and developed an internal Job Postings System from MS SQL Server Database to supportall phases of posting, reporting and job tracking.

Developed an electronic billing application using a Microsoft Visual Basic front end with MicrosoftAccess backend to process monthly telephone and ISDN usage. Crystal Reports generated the finaldocuments.

Developed an application to download and process American Express billing information and createregional billing summaries from the data for internal account billing and auditing.

Designed and developed a reporting warehouse using Seagate Crystal Reports with SQL Serverquerys as the report data object. Exported the reports thru VB COM objects to Adobe PDF formatand and mailed them to the respective clients using a customer lookup recordset object.

Designed and developed a front end billing interface using Visual Basic with MS Access as the datawarehouse. Used Ado as the data provider and Crystal Reports as the reporting tier.

Designed and developed a back end reporting solution utilizing Microsoft OLAP data cubes withMicrosoft Excel as the OLAP client.