Information Technology Professional with experience in logical and physical design, analysis, and programming of relational database systems for business applications. Recognized expert in maintaining and developing client relationships through high level technical expertise and finely tuned customer focus.

TECHNICAL EXPERTISE

Software: Oracle 11g, Oracle 10g, Oracle 9i, PL/SQL 9i, SQL Plus 9i, Oracle Designer 9i, Oracle 8i, AutoSys, Ultra Edit, TOAD 11.6.1.6, Microsoft Office 2003, 2010, Microsoft Excel, Microsoft PowerPoint, COBOL, OS JCL, ANSI SQL, Micro Focus COBOL, Teradata Administrator, Teradata Assistant, Oracle E-Business Suite Release 12.1, Microsoft Lync, Cisco WebEx conferencing, Putty, WinSCP, Oracle patchset.sh, Oracle Patch Wizard Utility, Oracle Discoverer, Oracle R12 Applications, TortoiseSVN, JIRA ACME Issue Tracking, My Oracle Support.

Operating Systems: Linux 5.5 X86-64bit, Sun Solaris 2.9, Digital UNIX V4.0F, AIX, UNIX, Windows XP,

Windows 7.

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator Senior Specialist

• Supporting Oracle Midtier Enterprise Business Suite R12.1.3 activities for the Financial Services Area. Support includes, User Management, Function Security, Patching, Cloning and Data Security in a Single sign-on environment.
• Member of 24 month 20 million dollar project called Building Financial Foundations. The main focus of this project is the consolidation of all External Reporting, simplification of Chart of Accounts, core Financial consolidation, External Reporting of 10Q and 10K information as well as being able to plan the Annual Budget on external reporting basis.

Confidential

Application Database Administrator

• Supported all database activities for Hartford Life Wealth Management area including on-call 24/7 support, problem fixes, work requests, data scripts and all database related issues. Developed and maintained effective and professional relationships with business partners and peers.
• Reduced Information Technology costs by aligning with The Hartford's Enterprise Oracle Program to rationalize data servers, database instances, implement oracle table space auto-extend and reduce storage usage
• Demonstrated technical expertise in support of all DBA daily activity as well as strategic efforts
• Effectively collaborated with Architects, Application Teams, Program Managers to develop and build
• high performing database designs
• Optimized database performance, reliability, capacity, availability, security and data quality for all Hartford Life Wealth Management applications
• Consistently adhered to all database compliance, governance standards and best practices
• Upgraded Document Composition databases to meet corporate initiative to upgrade all databases to Oracle 11g standard
• Followed architecture governance processes on Vista Upstream project to increase transparency around risk, recommendations and quantifiable impacts
• Met all database deliverables on supported projects within the specified timelines with quality and accuracy while following best practice standards

Consultant / Senior Oracle Developer

Confidential

• Provided day-to-day support for the Commercial Business Crop application which included data file extracts sent to the Risk Management Agency / U.S. Department of Agriculture.
• Mapped attributes between the new Livestock and old Livestock databases as a member of the Livestock Mortality System rewrite project
• Created SQL reports to identify and resolve differences between the new and old Livestock databases
• Developed and implemented database triggers to sync existing databases as part of the Livestock Mortality System rewrite project
• Provided production support for the Commercial Business Crop application, which consisted of many complex PL/SQL package/procedure code used to create data file extracts from an Oracle 9i database. The data file extracts were then sent to the Risk Management Agency / U.S. Department of Agriculture for validation as well as the actual external customer. The main 8,000-line PL/SQL build package included Oracle features such as Methods, Packages, Procedures, Functions, Ref Cursors, Bulk Collect clauses, Tables, Type Objects and Type bodies
• Rewrote Loss Control Reports using PL/SQL packages and procedures in order to reduce report run times. The Service Area Report run time dropped from 18 minutes to 3 minutes and the Country Wide Report run time went from not completing to completing in less than 10 minutes

Consultant / Senior Oracle Developer

Confidential

• Assigned to handle all new project work in support of the BKF Business Knowledge Facility claim information system residing on a Teradata database.
• Created a new monthly data feed of Specialty / Bond Name Address information and loaded it into an existing Teradata database
• Developed new User Load Rating tables for customer access and data entry in a production environment. Developed and maintained monthly Mainframe batch jobs using SQL to migrate the data from online User Loaded Rating tables to off-line Historical Rating tables
• Developed Teradata jobs on a Mainframe via CA-7 scheduler. Mainframe SQL steps were executed on NCR 4800 box using a direct line connection between NCR platform and Mainframe via BTQMAIN program

Consultant / Senior Oracle Developer

Confidential

• Supported day-to-day operations for bankruptcy unit. Developed and implemented programs to scrub data as part of three month project effort in the Commercial Lines area.
• Loaded bankruptcy information from many different types of source documents into Microsoft Access tables. PL/SQL programs were employed to clean and/or transform the raw source data prior to loading into the target Oracle 8i database
• Developed and implemented SQL and PL/SQL programs used in the migration of information from existing Commercial Lines Automation systems to a newly developed Siebel system module

Consultant / Senior Oracle Developer

Confidential

• Supported a variety of UNIX based Oracle production support systems for the Personal Lines Data Warehouse area.
• Developed and maintained PL/SQL, SQL Plus programs to populate Oracle 8i tables used to generate daily, weekly, monthly and yearly Personal Lines Insurance Company Marketing Reports posted on The Hartford Financial Services Intranet. Supported daily, monthly PL/SQL and SQL Plus load programs used to populate the Personal Lines Data Warehouse

Oracle Developer

Confidential

• Provided daily production support for a Risk Management system.
• Maintained a Risk Management system in a UNIX operating environment using Oracle software products
• Provided daily support of PL/SQL, SQL Plus and Micro Focus COBOL batch load jobs of Loss Data sent from the Claim Automation System mainframe application area
• Responsibilities included analysis, design, documentation, SQL Plus programming, PL/SQL programming, SQL Loader programming, UNIX Korn shell scripting, as well as directing other team members in the production support activities

Programmer / System Analyst

Confidential

• Daily production support provided for a COBOL IMS/DLI Mainframe environment
• Provided production support of a large commercial accounts retrospective insurance system using IMS/DLI and COBOL software in an IMS DB/DC environment