Provided customized web and desktop applications to extend functionality of construction management software products.- Built web application to generate invoices for multiple contracts linked to construction project, simplifying out-of-the-box invoice workflow and reducing time and resources used to complete recurring multi-invoice process. - Developed validation tests for complex business rules, ensuring records met all required criteria before entering database.- Created generic applications to integrate company software with third-party services (such as DocuSign), enabling customized integration products to be easily adopted by multiple clients.

Developed and maintained large commercial websites and internal component-based e-commerce web application.- Designed database schema and optimized SQL queries, facilitating quick access to large volumes of data and rapid load speeds for data intensive pages displayed on financial website.- Addressed and resolved security issues for existing e-commerce site of new client by filtering potentially malicious user input, parameterizing all SQL queries, and cleaning corrupted data.

Developed statistical and data management applications for imaging and printing group.- Served as SAS team lead for project to build SAS data mart. - Programmed algorithm using set of tables to store source and target metadata, permitting single SAS program to dynamically generate queries to load records into any table and guaranteeing scalability by making new and altered tables easy to integrate into data mart. - Assembled comprehensive collection of use cases for QA team with step-by-step instructions, identifying all calculation issues and providing time to correct and retest before release to production. - Incorporated error handling system to validate all incoming data and immediately send detailed email alert for invalid values, allowing quick investigation of problematic data.- Developed interactive website that merged contributions from multiple departments to publish bi-annual report, streamlining report generation process, freeing resources for other tasks, and increasing accuracy.

Converted web-based SAS application to alternate architecture using ASP files and Informix database. Fully documented SAS programs to educate developers without SAS skills to replicate program functionality and gathered information required to convert SAS application tables to corresponding database tables.

Developing and maintaining web-based report tool for the Imaging and Printing Group. Tasks include creating design documentation for new components; coding and maintaining HTML pages that provide the user interface and display report output; coding and maintaining JSP pages and JavaScript that manage dynamic content; writing java code to handle web server functions; writing SAS SCL code to generate report graphs and tables; and providing ongoing user support.

Constructed SAS programs to automate computation of rating curves for culvert, pump, and spillway type structures to consolidate multiple time-intensive tasks, eliminate redundant coding, and simplify maintenance.

Replacing SAS version 6.12 AF components in the Bureau of Forestry Timber Sales application with SAS version 8 equivalents. In addition, making extensive code additions/modifications to improve performance and add new functionality, revising all documentation, and correcting numerous unresolved problems with the original version.

Working on multiple projects to facilitate automation of acquisition, processing, and maintenance of hydrologic information. Evaluating current production database to identify anomalous/invalid data and design issues; resolving performance problems and extending functionality of a group of integrated SAS/fortran/C data analysis and reporting tools; and designing, coding, and testing a Java application to automate revision/testing of their principal flow estimation application.

Upgrading SAS version 6.12 code/data sets for the Bureau of Forestry Timber Sales application to run under SAS version 8, creating a data archive for storage and processing of terminated sales data, modifying/expanding output reports and bid proposals, and adding option to view annual reports on the web. Replacing SAS version 6.12 AF components in the Bureau of Forestry Timber Sales application with SAS version 8 equivalents. In addition, making extensive code additions/modifications to improve performance and add new functionality, revising all documentation, and correcting numerous unresolved problems with the original version.

Preparing, processing, and validating large volumes of customer/transaction data for statistical analysis. Assisted with development of web-based user interface for generating and accessing customer reports using SAS/AF and SAS Java-based/HTML web development tools.

Integrating statistical reports into an existing SAS/AF application. Also developing/modifying utilities to expand application functionality and improve performance. Participated in development of automated process to convert output to HTML format for display on company intranet.

Created SAS applications to replace current procedures for model building and scoring of customer data, enabling multiple models to be scored simultaneously.

Developing SAS application to assess and monitor the quality of their reservation forecast system. Programs use historical data to evaluate the accuracy of predictions made over a fifty-two week period and produce tabular and graphic reports of the results. Responsible for the design, coding, testing, and documenting of SAS programs and UNIX scripts. In addition, investigated Oracle database for inconsistencies and omissions in the historic record.

Developed interactive programs using SAS/AF and Oracle Forms to provide additional functionality and supplementary reports for their Automated Rating Calibration Program. Projects included updating of database model for collection of measurement data, designing and building GUI screens, writing SCL (SAS/AF) and PL/SQL (Oracle Forms) code to run the applications, and providing documentation for each program.

Worked on the Data Warehouse Statistical Analysis and Reporting (DSAR) project. Responsible for designing the DSAR prototype, developing SAS coding standards, writing SAS programs to generate reports and graphs, and applying SAS/Intrnet tools to enable the transfer of information between SAS and the Java-based user interface.

Developed programs to automate computation of rating curves for culvert, pump, and spillway type structures. Worked in a Unix environment to link output from fortran programs with SAS macros for statistical analysis and preparation of graphs. Programs automatically retrieve and analyze information stored in the organization's Oracle database.