Daniel Mullings Email & Phone Number

United States

• Maintain and support the online Corporate Event Reporting System (CERS) in PowerBuilder 2022 and Oracle 19c. The system is the central repository/management tool for event information for American Airlines mainline and regional airline operations. It also serves as the critical incident notification vehicle for irregularities involving safety, security, or medical issues pertaining to daily airline operations. • Added tracking of user actions within the CERS Client application to help determine what features were being used. Modifications to the extension class were made to track various object actions like window/tab open, datawindow click/right click, button clicks, etc.• Replaced Internet Explorer ole object with new Chromium web browser object for internet website interactions. • With the web browser change, spellchecking was added to mitigate the need for users to copy and paste notes into MS Word to check spelling. It also fixed a long-standing issue with Word’s special characters failing to save in the Oracle database.

United States

• Migrated PowerBuilder source code from TFS to a Git repo so that development could take advantage of DevOps enhancements. Also created Build and Release pipelines in Azure DevOps to facilitate CI/CD for the 3 Middle Tier server and Desktop Client applications.• Developed an automatic update feature for the desktop client application that checks the Oracle DB at startup for a new version and prompts the user to download and install. This has saved the Product Owners, helpdesk, and developers countless hours troubleshooting installation problems. It also increases speed of deployment so that users receive bug fixes and enhancements in a timely manner.• Migrated CERS from PowerBuilder 12.6 to PowerBuilder 2019R2 while adding additional features and bug fixes to enhance product useability.• Rewrote Sabre Data Access in CERS to use REST API with PowerBuilder 2019R2. A feature flag in the Oracle Database determines if the desktop client and middle tier applications access sabre data from the mainframe or from webservices.• Tech lead for employee data migration load. Rewrote Unix and Oracle SQL scripts to process XML files instead of CSV files to load data into the CERS Oracle database.• Led project to migrate the CERS application from PB 7.03 to PB 12.6. Removed dependency of distributed Sabre Server application and embedded that functionality into the CERS client. Also integrated new message server to mimic the mail server functionality without the distributed dependencies.• Assured CERS compliancy with the Single FOS Partition initiative which combined the US Airways entity into the American Airlines Corporation.

United States

• Maintained and supported the batch and online Clearance and Compensation (CNC) system in PowerBuilder 12.5.2 and MS SQL Server 2008. The system tracked payments to Vendors who air commercial spots on the radio stations that operate for Cumulus Media Networks.• Migrated data from Cumulus database to an intermediate database at Westwood One for all the radio stations utilizing the ETL process. This included using SSMS to write stored procedures, queries, SQL jobs, and SSIS packages to complete the project within the project’s timeframe. This saved Westwood One hundreds of thousands of dollars by removing unnecessary facilities. • Led project to migrate the CNC application from PB 6.5 to PB 12.5 and MS SQL Server 2000 to 2008. Also split batch application functionality from database server to application server which tripled the performance of the batch procedures at night.• Created interface between a .NET Web application and the CNC application to send/receive station affidavits. This eliminated an outside vendor that was performing this function which saved Cumulus Media Networks $35,000 per month.• Assisted in move of CNC system to a new database server which quadrupled batch processing times. This allowed for other server maintenance jobs to be run at night which kept the servers running at peak performance.

United States

• Provided software systems technical support, enhancements, and maintenance for internal web/batch applications that supported Employee Benefits, Job Staffing, Vehicle and Personal Injury, Employee Appraisals, and Tuition Assistance. Participated in and led projects that involved changes that required the applications to go through the entire SDLC. Supervised offshore resources in the resolution of incidents and the implementation of software changes. Interfaced with customers to resolve these incidents.• Primary lead for support, enhancements, development, and maintenance on the Verizon Benefits Information System (VBIS). This application was originally written in PowerBuilder 5 with an Oracle 8.1.7 database. Performed migrations from PowerBuilder versions 6.5 thru 9 and upgraded Oracle 8 thru 10g during tenure at Verizon.• Coordinated design and development of a rewrite of VBIS with offshore resources due to Verizon’s consolidation of development tools. The batch system was written in PowerBuilder 9.0 and was redeveloped with Visual Basic .NET 2003 and an Oracle 8.1.7 backend.• Worked on a team to convert portions of the VBIS system from PowerBuilder 9.0 to Visual Basic .NET 2003 and ASP.NET, so the application could be ported into a web environment. This saved the support team time and money since the benefits process was more streamlined and centralized.• Led team and participated the design, development, and implementation of an N-Tier distributed architecture to support VBIS using PowerBuilder 9.0, EAServer 5.0 with Oracle 8.1.7. This was a rewrite of the original BFIS system to support added personnel in remote locations and the increased volume of the merged GTE and Bell Atlantic companies into the Verizon Corporation.• Participated on team that developed and reengineered the Health and Welfare benefits application for GTE from FoxPro to PowerBuilder 5.0 using Oracle 7.3. Designated as the SME on benefits business policy

United States

Migration app that converted Mainframe CICS code to PowerBuilder. We fixed underlying issues and code errors to make the customers Migration off mainframe to windows PCs more seamless.

United States