Oracle and SQL Server DBA

Supported Oracle and SQL COTS software, Asset Backed Securities and Collateral Analysis application by Lewtan Technologies, in North America and International Operations for Securitization Retail and Lease lines of business. International clients supported in: Australia, Canada, China, France, Germany, Mexico, New Zealand, Switzerland and United Kingdom. Executed daily and monthly batch cycles. Troubleshot application reporting issues through data analysis tools MS SQL Plus and MS SQL Server Query Analyzer. Created business requirement documents and test plans utilizing HP Quality Center. Executed software build testing and applied defect corrections. Applied database data fixes and Excel worksheet formula enhancements. Developed and maintained application processing scripts. Monitored Securitization team’s service desk through Peregrine Service Center, IBM Service Manager, HP Service Manager AMS1, and IBM Lotus Notes.- Enhanced calculation technique for data pool builds through statistical analysis saving 24 hours of processing time. - Developed supplemental data pool build concentration limit testing tool through MS Excel to meet business financial tolerance goals. - Consolidated US Retail manual input processing methodology saving month-end processing time to meet SLA reporting requirements. - Applied additional logic to client reports through Cognos Impromptu Administrator in behalf of COTS software developer to expedite reporting requirements. - Coordinated environmental data archiving and decommissioning activities within project schedule.

Supported on-line IMS and DB2 databases on mainframe legacy systems. Supported batch environment. Provided performance and capacity planning support activities. Managed multiple projects concurrently. Interfaced with application teams, vendors, and customers. Maintained source code written in VBScript, REXX & SAS. Monitored resource utilization through STROBE, OMEGAMON, RMF, BMC PATROL Visualizer and CA-BrightStor. Other tools utilized: DeltaIMS, Autogen, IMF, TSO, CONTROL-M/R, Endevor, SAP, TPNS, Lotus Notes, and the Microsoft Suite of Office Applications (Outlook, Excel, PowerPoint, Word, Project, Access, Visio, Internet Explorer, & NetMeeting). - Selected to be the Business Continuity Planning Coordinator for Solution Centre. - Chosen to be Capacity Management Global Representative for GMAC and MIC. Successfully ensured capacity was not exceeded and resources were allocated appropriately. - Became International Single Point of Contact for Software License Agreements. - Coordinated Y2K independent vendor validation of application software. - Participated in annual disaster recovery drills. - Provided financial resource forecasting and monthly variance analysis reporting. - Monitored and reported response time statistical metrics.

Supported on-line Transaction Processing Facility operating system. Applied operating system maintenance. Debugged system/application dumps. Interfaced with Application and Database support groups to resolve customer related concerns or enhancements. Assisted operations assistance center with procedures. Evaluated new hardware and software upgrades for operating system compatibility. Generated network communications terminal/printer definitions per customer request. Provided assistance to development system environments. Maintained software license inventory management system. Programmed in Assembler H, SABRETALK, REXX and PL/I computer languages.