Now you can Instantly Chat with William!
VB.Net, SQL Development, stored procedures, views, table design, indexing alond with years of experience designing and delivering
WEB and windows based applications for large commercial and military environments.... Show More
Data & Analytics
ATT Global Network Billing MSA Application
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.Show More Show Less
Skills.NET Core SQL Crystal Report
MIS Team Lead Reliance Test and Technology
Responsible for designing, capturing and supporting mission data to support the 96th 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.
Show More Show Less
Targeting By Engagement Level Project
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 includeShow More Show Less
SkillsCrystal Report SQL Visual Studio Code
MedExpress WEB Site Conversion
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.Show More Show Less
Skills.NET Core Visual Basic Crystal Report SQL