Worked on multiple large-scale projects and programs in the development organization of the Property and Casualty and Institutional Markets business units with CNA. Major initiatives include:Serving as development DBA and Oracle SME on several initiatives providing development support, database SQL tuning, best practices, and inventive solutions to team members.Creating innovative solutions using existing/new architecture to solve and/or reduce cost in a wide variety of ways including:Leveraging COBOL and Oracle to generate code that produced data files for a major conversion effort under significant time constraints and large monetary penalties. Lead to delivering conversion 3 weeks early.Designing and implementing interface architectures around a vendor system to standardize interface development/maintenance and reduce the cost of future development and support efforts by 20%.Created support infrastructure pieces for multiple applications to aid with access, reporting, and operations. Received seven CNA FOCUS recognition awards for work on various projects.

Led a development team in a multi-million dollar replacement of core financial recording and reporting systems. Key roles/responsibilities included:Planning and managing the development process for the Financial Warehouse component utilizing a mixed model of onshore/offshore development. This included detail design, code/unite test, user acceptance testing, performance engineering and deployment phases.DD/CUT phase was delivered 3 weeks early and with reduction of 2 offshore resources. All other phases on time and in budget.Assisted with QA test case creation, execution, and results analysis.Aided in creating physical data model for performance, maintenance, and recoverability resulting in exceeding expectations for performance and usability.Assisted in providing debug analysis for ETL and database issues.Received three CNA FOCUS recognition awards for work on this program.

Served as Oracle SME/Application DBA and application architect on several high visibility projects. These included:The Database design, COM component design, and distributed processing for remote laptops on a custom contact management/quoting system. Managed the challenges of multiple project owners and changing specifications on the overall architectural design.Played a major role in designing, testing, and implementing multi-threaded batch processing in the on-time, in budget, implementation of a major annuity system.

Played a significant role in the on-time implementation of a large institutional markets contract management system. Developed a high-volume print approach that reduced overall processing costs and increased print throughput. Debugged vendor product issues in UNIX and Oracle processes and recommended or developed solutions. Managed database objects including sizing, backup methodology and tuning.

Worked as a DBA on a $6.5 million enhancement project for part of their master purchase order system. Primary duties included database creation, object management, performance tuning, security and backup/recovery implementation. Architected a change to the proposed method of loading data from IDMS journals that saved over 1200 hours or development time.Developed a custom UNIX based scheduler that focused on Oracle processes and ETL that reduced total time to extract/build the database by 50%.For TriMark Technologies; served as DBA for the $3.5 million conversion of a commercial annuity application from Btrieve to Oracle. Primary duties included database creation, client database installation procedures, performance tuning, capacity planning and architectural design.Directly responsible for on-time and in-budget delivery of all database commitments in a very deadline intensive environment.Served as Sun Solaris system administrator, in addition to DBA duties, when resource was unavailable and project deadline was in jeopardy.Developed capacity plans for clients, including sever layout, file system layout, and database configurationsCreate the entire Sun load process using Sun packages for client deployments

, I worked on the development of a large system used to collect and validate veteran application data. In this position I served as developer and also architected several integral components.Created a process to link the Expert System engine into message processing.Built the process used to generate letter output based on information provided by the expert system and appropriately route/compress/save the output using OLTP messaging and the RDBMS

, was responsible for operating initiatives aimed at reducing operational costs by 40%.Worked on linking file and report processing across heterogeneous platforms using network technologies. This allowed for the use of shared resources and the reduction in maintenance and equipment costs by over $100 thousand annually and a headcount reduction of 2 FTE. Received recognition for modifying existing processes to effectively utilize mailroom printers and folders/inserters to both reduce labor and save over $50 thousand annually in postage.Awarded for architecting universal console management, integrating offsite tape management processing, print distribution automation, and operational efficiencies resulting in a reduction of approximately 4 FTE.As a Developer