Sr Software Engineer

• Aug 2019 - Present

Senior Software Engineer

• 2016 - Aug 2019

Project Manager: • Project Manager for eDRS Enhancement project and Option Year 2 • Coordinate project deliverables and staffing for minor project to design and implement enhancements to the existing reporting system • Create and maintain project documentation on SharePoint site • Create and maintain Weekly Status Reports for eDRS OY2 • Create and maintain Monthly Status Reports for eDRS OY2 Senior Software Engineer: • Design and update 47 existing reports… Show more Project Manager: • Project Manager for eDRS Enhancement project and Option Year 2 • Coordinate project deliverables and staffing for minor project to design and implement enhancements to the existing reporting system • Create and maintain project documentation on SharePoint site • Create and maintain Weekly Status Reports for eDRS OY2 • Create and maintain Monthly Status Reports for eDRS OY2 Senior Software Engineer: • Design and update 47 existing reports for Food Nutrition Service at USDA as part of modernization project for SNAP-QCS • Applied SSRS dataset modifications to allow reports to use SQL Server Stored Procedures as part of modernization efforts • Designed and Developed 10 new reports for Food Nutrition Service at USDA. • Applied Formatting changes to 20 existing Business Objects and Crystal Reports making all reports uniform • Engineered additional formatting changes, added USDA logo and ease of use and readability changes including alternating row shading and highlighting. • Applied additional formatting changes to existing Business Objects and Crystal Reports • Utilized Visual Studio 2010 for testing of the product and functionality of Business Objects and Crystal Reports • Designed and updated Instructional Guide providing a step by step set of instructions for running all Business Objects and Crystal Reports in system including screen shots and results of incorrect responses to user prompts Show less Project Manager: • Project Manager for eDRS Enhancement project and Option Year 2 • Coordinate project deliverables and staffing for minor project to design and implement enhancements to the existing reporting system • Create and maintain project documentation on SharePoint site • Create and maintain Weekly Status Reports for eDRS OY2 • Create and maintain Monthly Status Reports for eDRS OY2 Senior Software Engineer: • Design and update 47 existing reports… Show more Project Manager: • Project Manager for eDRS Enhancement project and Option Year 2 • Coordinate project deliverables and staffing for minor project to design and implement enhancements to the existing reporting system • Create and maintain project documentation on SharePoint site • Create and maintain Weekly Status Reports for eDRS OY2 • Create and maintain Monthly Status Reports for eDRS OY2 Senior Software Engineer: • Design and update 47 existing reports for Food Nutrition Service at USDA as part of modernization project for SNAP-QCS • Applied SSRS dataset modifications to allow reports to use SQL Server Stored Procedures as part of modernization efforts • Designed and Developed 10 new reports for Food Nutrition Service at USDA. • Applied Formatting changes to 20 existing Business Objects and Crystal Reports making all reports uniform • Engineered additional formatting changes, added USDA logo and ease of use and readability changes including alternating row shading and highlighting. • Applied additional formatting changes to existing Business Objects and Crystal Reports • Utilized Visual Studio 2010 for testing of the product and functionality of Business Objects and Crystal Reports • Designed and updated Instructional Guide providing a step by step set of instructions for running all Business Objects and Crystal Reports in system including screen shots and results of incorrect responses to user prompts Show less

Senior Consultant

• 2015 - 2016

Data Analyst: • Provided testing functionality prior to new software releases of the PE&PS estimation tool. • Developed Excel macros adding several tabs to the Effort Comparison spreadsheet to duplicate the Functional Allocation report. This spreadsheet and it’s variations is used to compare and verify testing results in the PE&PS software. • Conduct property-level data matching from multiple sources currently a manual procedure with the goal of automating and streamlining the… Show more Data Analyst: • Provided testing functionality prior to new software releases of the PE&PS estimation tool. • Developed Excel macros adding several tabs to the Effort Comparison spreadsheet to duplicate the Functional Allocation report. This spreadsheet and it’s variations is used to compare and verify testing results in the PE&PS software. • Conduct property-level data matching from multiple sources currently a manual procedure with the goal of automating and streamlining the process. • Develop processes required to replace the HFA data matching activities • Develop processes of retrieving source data to identifying properties with aligned funding sources. • Created database and procedures to show the feasibility of automating this process. Show less Data Analyst: • Provided testing functionality prior to new software releases of the PE&PS estimation tool. • Developed Excel macros adding several tabs to the Effort Comparison spreadsheet to duplicate the Functional Allocation report. This spreadsheet and it’s variations is used to compare and verify testing results in the PE&PS software. • Conduct property-level data matching from multiple sources currently a manual procedure with the goal of automating and streamlining the… Show more Data Analyst: • Provided testing functionality prior to new software releases of the PE&PS estimation tool. • Developed Excel macros adding several tabs to the Effort Comparison spreadsheet to duplicate the Functional Allocation report. This spreadsheet and it’s variations is used to compare and verify testing results in the PE&PS software. • Conduct property-level data matching from multiple sources currently a manual procedure with the goal of automating and streamlining the process. • Develop processes required to replace the HFA data matching activities • Develop processes of retrieving source data to identifying properties with aligned funding sources. • Created database and procedures to show the feasibility of automating this process. Show less

Associate

• 2008 - 2015

Business Objects Developer; • Converted Universes and Reports from Business Objects 3.1 to Business Objects 4.0. • Documented changes in Business Objects’ versions included in Business Objects 4.0. • Validated report integrity and accuracy during the conversion process. • Validated the Security Model insuring Security in version 4.0 adheres to the Security Model standards established in the prior version. • Converted multiple Crystal Reports into Business Objects Web… Show more Business Objects Developer; • Converted Universes and Reports from Business Objects 3.1 to Business Objects 4.0. • Documented changes in Business Objects’ versions included in Business Objects 4.0. • Validated report integrity and accuracy during the conversion process. • Validated the Security Model insuring Security in version 4.0 adheres to the Security Model standards established in the prior version. • Converted multiple Crystal Reports into Business Objects Web Intelligence reports. • Designed new report functionality replacing legacy systems through multiple brainstorming and requirements gathering sessions with the client. • Developed Business Objects Universes using the Information Design Tool to support these reports and add requested design and functional changes. • Upgrade from Business Objects 3.1 to Business Objects 4.1. • Documented changes in Business Objects’ versions included in Business Objects 4.1. • Validated report integrity and accuracy during the conversion process. • Validated Security Model insuring Security in version 4.1 adheres to the Security Model standards established in the 3.1 version. • Converted .unv universes to the newer .unx format. Show less Business Objects Developer; • Converted Universes and Reports from Business Objects 3.1 to Business Objects 4.0. • Documented changes in Business Objects’ versions included in Business Objects 4.0. • Validated report integrity and accuracy during the conversion process. • Validated the Security Model insuring Security in version 4.0 adheres to the Security Model standards established in the prior version. • Converted multiple Crystal Reports into Business Objects Web… Show more Business Objects Developer; • Converted Universes and Reports from Business Objects 3.1 to Business Objects 4.0. • Documented changes in Business Objects’ versions included in Business Objects 4.0. • Validated report integrity and accuracy during the conversion process. • Validated the Security Model insuring Security in version 4.0 adheres to the Security Model standards established in the prior version. • Converted multiple Crystal Reports into Business Objects Web Intelligence reports. • Designed new report functionality replacing legacy systems through multiple brainstorming and requirements gathering sessions with the client. • Developed Business Objects Universes using the Information Design Tool to support these reports and add requested design and functional changes. • Upgrade from Business Objects 3.1 to Business Objects 4.1. • Documented changes in Business Objects’ versions included in Business Objects 4.1. • Validated report integrity and accuracy during the conversion process. • Validated Security Model insuring Security in version 4.1 adheres to the Security Model standards established in the 3.1 version. • Converted .unv universes to the newer .unx format. Show less

Business Objects/Crystal Reports Developer

• 2002 - 2008

Business Objects Developer; • Developed Crystal Reports and Cognos Reports on a Proof of Concept project converting a DOS based FoxPro system into an Oracle 9i Data Warehouse. • Migrated DB2 database to SQL Server using SQL Server views and Stored Procedures. • Develop reports for several different clients using Crystal Reports/Seagate Info. • Develop Production and Financial Reports in Lawson database environment. • Primary Technical Lead in the Report Writing effort for… Show more Business Objects Developer; • Developed Crystal Reports and Cognos Reports on a Proof of Concept project converting a DOS based FoxPro system into an Oracle 9i Data Warehouse. • Migrated DB2 database to SQL Server using SQL Server views and Stored Procedures. • Develop reports for several different clients using Crystal Reports/Seagate Info. • Develop Production and Financial Reports in Lawson database environment. • Primary Technical Lead in the Report Writing effort for three major client implementation projects utilizing Crystal Reports and Seagate Info. • Developed MSSQL views, system tables, user-defined tables, metadata information, stored procedures and triggers to support the reporting efforts for multiple implementation projects. • Provided MSSQL DBA troubleshooting assistance with implementation and post-implementation database issues including setup, software upgrades, hardware upgrades, database tuning and optimization. • Provided Oracle 8i DBA assistance setting up and implementing Oracle8i and DataMart to support Reporting from ‘Banner’ system, SCT’s package used in the Education sector. Show less Business Objects Developer; • Developed Crystal Reports and Cognos Reports on a Proof of Concept project converting a DOS based FoxPro system into an Oracle 9i Data Warehouse. • Migrated DB2 database to SQL Server using SQL Server views and Stored Procedures. • Develop reports for several different clients using Crystal Reports/Seagate Info. • Develop Production and Financial Reports in Lawson database environment. • Primary Technical Lead in the Report Writing effort for… Show more Business Objects Developer; • Developed Crystal Reports and Cognos Reports on a Proof of Concept project converting a DOS based FoxPro system into an Oracle 9i Data Warehouse. • Migrated DB2 database to SQL Server using SQL Server views and Stored Procedures. • Develop reports for several different clients using Crystal Reports/Seagate Info. • Develop Production and Financial Reports in Lawson database environment. • Primary Technical Lead in the Report Writing effort for three major client implementation projects utilizing Crystal Reports and Seagate Info. • Developed MSSQL views, system tables, user-defined tables, metadata information, stored procedures and triggers to support the reporting efforts for multiple implementation projects. • Provided MSSQL DBA troubleshooting assistance with implementation and post-implementation database issues including setup, software upgrades, hardware upgrades, database tuning and optimization. • Provided Oracle 8i DBA assistance setting up and implementing Oracle8i and DataMart to support Reporting from ‘Banner’ system, SCT’s package used in the Education sector. Show less