William B.

William B.

Friendly Team Oriented SQL / Web Developer with excellent Reporting Skills

Destin , United States

Experience: 25 Years

William

Destin , United States

Friendly Team Oriented SQL / Web Developer with excellent Reporting Skills

72000 USD / Year

  • Immediate: Available

25 Years

Now you can Instantly Chat with William!

About Me

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

Portfolio Projects

Description

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

Description

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

Show More Show Less

Description

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

Description

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