Glenn Gordon Email & Phone Number

Greater Denver Area

Wheat Ridge, Co

Investor Portfolio Tax Lot Accounting and ReportingMaintain, support, and enhance Performance Analysis and Portfolio Reporting (PAPR) component of Aspire Wealth SystemPAPR platform is Sybase DBMS on Unix, T-SQL stored procedures and Java interfaces and utilitiesCarried from Broadridge to Scivantage when they partnered with the goal of replacing Broadridge cost basis PAPR application with Scivantage’s Maxit productMaxit is Unix hosted PHP and Javascript front end with Java middleware and Oracle DBMSWorked on enhancements to Maxit to support better step up functionality, including web service lookup of fair market valueConversion extracts for clients moving from Broadridge PAPR to Scivantage Maxit, and more generic extracts for other cost basis systemsMoved two clients of the SIS back office version of the PAPR system to the BPS back office version of the PAPR system converting their PAPR data in placeDetailed analysis of code and data issues involved in separating the PA from the PR to support PA rewriteDetailed analysis of code lines and test result differences between them to merge a large and difficult client with a lot of custom code back into the PAPR mainline of developmentCreated new extract for statement producer/providers tracking customer portfolios and gain/loss informationMiscellaneous investigation, fixes, and enhancements

Greater Denver Area

Maintain, support, and enhance custom installation of AdvantEdge collections softwareAdvantEdge platform is Windows Server hosted SQL Server with front end web interface created by PowerBuilderMajor performance tuning and enhancements to support T-Mobile’s volume reducing daily cycle times from 20+ hours to less than 2.Designed and implemented a whole new tiered commissions invoicing of client OCAsDatabase design and refactoring, T-SQL queries, stored procedures, and triggersC# Web Services prototyping for next product generation

Team lead for many projects and functional areas including Access Billing, Credit and Collections, Usage Processing, and proprietary infrastructure maintenance and developmentPlanned, executed, and monitored projects in all phases, both as a leader and individual performerRecognized as a DB2 expert and data design authoritySuccessfully managed risks of on-shoring a system that had been offshore for 8 years and brought the project to successful completionImproved OCA account accuracy from 85% to 99% and identified the root causes and effects of all remaining known accuracy issuesRedesigned and simplified system work flow, resulting in 80% reduction of CPU resourcesRedesigned client web interface, enabling faster and more accurate responsesCode consolidation to bring multiple regional usage processing and billing systems to a common code base and common implementation of Toll Usage account matching and processing up to the billing cycleResearched and analyzed existing systems and recommended solutions to increase efficiencyResponsible for system performance, creation of metrics, identification of problem root causes, and process improvements.Created performance metrics, did risk assessments, initiated, led, and performed targeted performance improvements resulting in a 75% reduction of CPU resources and job run times, and 50% reduction in disk utilization for several major database tablesCreated metrics and root cause analysis which allowed targeted responses to eliminate recurring problem reports reducing problem reports to 1/3 of their previous numberRevision of database standards for DB2, and elimination of outdated database development tools. Decommissioning these tools resulted in significant reductions in developer effort, version control risks, and cost of changes

Greater Denver Area

Leased Worker placed by Modis, formerly The Blackstone Group

Greater Denver Area

Placements at American Management Systems and US West/Qwest