David Bauer Email & Phone Number

Roswell, Ga, Us

Norcross, Ga

Lead Analyst/Developer for the Billing system replacement project which included:Replacement of an 18 year old DOS based system with a browser application and PL/SQL functionsGathering and documenting requirements from user sessions and analysis of the old systemDesigning and building User interface using Oracle Application Express (APEX)Designing and creating the database tables and functions to support the applicationDesigning and building inbound and outbound interfacesReduced month end billing process from 5 days to 2 daysLead Analyst/developer of application interfaces for the replacement DDA system, the FlexCube application from Oracle, including:Gathering and documenting requirements by analysis of the current systemAutomating the inbound interfaces from all internal and external sources, using PL/SQLDesigning and developing a User Interface for review and approval of inbound interfaces, using Oracle Application Express, eliminating all paper reports used for validation and balancingDesigning and developing outbound interfaces for General Ledger, Billing, and Audit, using PL/SQLCreating custom extracts for conversion of existing dataPrimary Analyst/Developer for multiple upgrades to supported systems

Participated as one of the Project Managers in the formation of the policies, procedures, and definition of the PMO as it was createdProject manager, analyst, and developer for the timely implementation of multiple small to medium effort projects, fulfilling all PMO and SDLC documentation requirements, including:Creation of a project charter, scope statement, and schedule for management approvalGather and document all requirements and system specificationsUnit test, promote, and support the application through QA and User Acceptance testingMaintain the schedule, document and track changes to scope, conduct management reviews as needed, and track all issues and risks related to the projectObtain all required approvals at each phase of the projectConduct post-implementation reviewsSuccessfully implemented a custom FAS 133 derivative pricing application which included: Gathering and documenting requirements from user sessions and analysis of the spreadsheet to be replacedMaking 5 years of historical spreadsheet data accessible and consistent Importing trade data from the data warehouse, applying pricing data supplied via spreadsheet, calculating month to month changes in values, and producing a file of transactions for an interface to the General ledgerFulfilling all PMO and SDLC documentation and reporting requirementsReplacing a multiple sheet spreadsheet and manual processes with a secure stable application, saving the users approximately 3 days work every monthProject manager for the preliminary effort to find a replacement DDA system. Coordinated with the business units to:Identify and contact possible vendorsCreate the RFP and send out to interested vendorsDevelop a scoring system for the RFP responsesProduce a decision matrix for management review Create a schedule for all phases of the project, including cost and resource projectionsPrimary Analyst/Developer for multiple upgrades to supported systems

Assumed a lead role in the implementation of the EastPoint (Pulse) application for DDA Participated in the design and led the development of all inbound and outbound interfacesCoordinated and tested all custom coding for interfaces and reports with the vendorDeveloped custom reports and extracts in SQR as part of nightly processing customizationLed two major upgrades to both Sybase and the application, along with providing primary support for the life of the applicationLead in-house developer for the consultant developed original version of the Customer Website (Bank4banks) using Versata.Lead In-house developer and analyst for the external applications and internal processes for the Affordable Housing Program using Versata including:Designed and developed batch reports.DDA and General Ledger InterfacesFHFB file creationDesigned and developed flexible scoring logic to allow past projects to be re-scoredPrimary Analyst/Developer for multiple upgrades to supported systemsPrimary support for Y2K testing and verification of supported systems

Provided primary or secondary support for multiple applications:General Ledger (Lawson)DDA (PowerBuilder/Sybase)MPF(SQL Loader, PLSQL, Oracle)Safekeeping (PowerBuilder/Oracle)Capital Stock (PowerBuilder/Oracle)Credit Workflow (PowerBuilder/Oracle)Advances (Cobol/VSAM)BillingAdministrator for the PVCS (Source control) applicationCreated Interface files for DDA and GL applications from various systems using COBOL

Lead PowerBuilder developer for a research and development team creating a client-server application for the health care industryTraining and supporting the team as they learned PowerBuilder and OracleConsulting on issues of design and deployment of the application

Maintained and updated Customer information, billing, and meter reading systems in an extensively documented mainframe Cobol/CICS environmentParticipated in the data and process modeling sessions, along with the initial development, of the client-server replacements (PowerBuilder/Sybase) for all systems

Managed various departments, including product ordering, scheduling, and management reporting responsibilities