Solution Architect And Project Manager
Trevose, Pennsylvania, Us
Developed vision and strategy to support the DOE's industrial energy management program. Collaborated with academics and engineers to design calculators, scorecards, and assessment tools. Mentored junior engineer in converting tool designs into software specifications and testing plans. Architected and developed detailed design for integrated software toolkit to deliver resources as SharePoint components, downloadable tools, mobile applications, and custom Excel Add-ins. Led team of six software developers in developing individual tools, calculators, and scorecards in .NET and Java.Led team of developers and business analysts implementing process modernization program for the Federal Energy Management Program. Designed new system architecture and data upgrade methodology. Developed detailed recommendations for remediation and enhancements to underlying business processes.Led team of 10 developers to produce a sophisticated system for NOAA for agency-wide planning, programming, budgeting and execution system (PPBES) in a short period of time. Prepared and ran user focus groups to refine the system requirements. Designed system and database architecture, and developed dynamic data layer using PL/SQL and XML.Designed streamlined data structure to support DOE’s environmental remediation project tracking system. Designed data validation, transformation and migration methodology. Oversaw team of 13 database developers refactoring all existing application code, stored procedures, and migration processes.Designed database structures in SQL Server and Oracle for an EVM reporting system, a custom CRM tool, and a database to support a computational linguistics algorithm for computing phonetic similarity. Coordinated and oversaw the design, development, and debugging activities of teams of up to 6 junior database developers. Conducted performance analysis and tuning. Rewrote a mission- critical data migration process and reduced operating time from 24 hours to 1 hour.