Summary of qualifications

Over fifteen years of experience as a Data Architect and Database Administrator with a proven track record in performance tuning and troubleshooting on over dozens of high profile Oracle systems. Deep technical expertise in Database Modeling and Design. Strong technical, analytical, communication and organizational skills. Background also includes Data Warehouse Architecture, UNIX System Administration experience, and programming experience.

Technical Qualifications
Data Management ORACLE 11G, 10G, 9i, SQL Server, MS Access
Languages PL/SQL, SQL, C, Korn-Shell, C-Shell, Tcl/Tk, HTML, SAS, EXCEL
Oracle Products Real Application Clusters (RAC), Data Guard, ASM, Oracle Enterpsrise Manager 10g Grid Control, Server Manager, SQL*Plus, Pro*C, Oracle Streams, OID, Oracle Application Server Single Sign On, RMAN, Data Pump, Export, Import, SQL*Loader, SQL*Net, NLS utility, STATSPACK
Operating Systems UNIX (AIX, Solaris, HP_UX, AT&T System V), Windows (2003, 2000), Xwindows,
And Environments Hitachi Freedom 9980V Storage Subsystem, Sun F15K, Linux
CASE Tools TOAD, Quest Performance Analysis, Informatica, Ab Initio, Cayenne, BMC Patrol, BRIO,
And Software Erwin, S-Designor, NetBackup, EcoTools, Data Protector, Cognos

Professional experience

3/2011 – Present Data Architect Consultant, Confidential, IL
Environment Oracle 10g, 11g, RAC, Partitioning, Solaris10 on Sunx4600 attached to Hitachi-9990 Storage
Industry Financial

Data Architect providing technical leadership and a high level of expertise in Data Modeling, Database
Design, and Performance tuning in a very critical, high volume/high speed transaction processing
environment.

• Analyze and translate business requirements into detailed technical architecture and implementation plans.
• Lead analysis sessions to capture database requirements and data definitions.
• Create logical and physical Data Models using Erwin based on the requirements.
• Conduct Data model reviews with Developers and other Architects.
• Review Data Mapping documents and data transformation routines with DW Developers.
• Review and optimize process diagrams for Data Load routines with performance in mind.
• Support Database Warehouse team thought the duration of the project; help them troubleshoot performance issues, tune queries and optimize performance.

3/2006 – 3/2011 Senior DBA Consultant, Confidential, Deerfield, IL
Environment Oracle 9i, 10g, 11g, SQL Server, HP-UX 11i, EMC CLARiiON, Windows 2000, 2003, 2008.
Industry Pharmaceutical

Senior Database Administrator supporting various Oracle and SQL Server databases for TAKEDA Pharmaceuticals including validated systems. Created and executed IQOQ documentation to comply with regulations. Participated in System Audits ( both internal and external). Developed and implemented Business Continuity plans.

• Implemented Security Best practices for Oracle 10g at client site. Documented all security practices and created daily management reports.
• eSignature project (Sample Management System)

The goal of this project was to utilize the functionality of Siebel’s eSignature module to enable field representatives to capture sample transactions and electronic signatures via tablet PC and to improve the process of auditing and tracking sample activities to comply with Prescription Drug Marketing Act (PDMA). The environment consisted of two nodes Oracle 10gR2 RAC database running HP-UX 11i, utilizing ASM. Administered RAC nodes, performed Database Refreshes, helped to monitor and tune performance, monitored backups

• Takeda Data Warehouse

Successfully merged Legacy TAP and Legacy Takeda Data Warehouses. The new data warehouse was hosted in a 5TB+ Oracle 10g database. Successfully designed and implemented migration plan. Tuned the database for maximum performance utilizing the latest 10G features: Automatic Workload Repository, ADDM and SQL Tuning Advisor. Worked with the Informatica developers to optimize and tune ETL processes. Worked with BI team to design and tune Cognos cubes and upgrade the Cognos repository to 10G. Worked with the Data Warehouse team and Takeda IT Security team to establish database security policy and procedures.

• Created 11g concept environment for Sales Force Management system.
• IMany CARS, Medicaid and Government Pricing Databases
  Senior Oracle Database supporting IMany application for Contract and Pricing group
• Successfully merged Legacy Takeda and Legacy TAP databases.
• Implemented security controls to comply with JSOX requirements
• SQL Server DBA responsibilities
• Installed and configured SQL Server instances.
• Created databases, managed security, configured backups.
• Contributed to SQL Server architecture and capacity planning activities.

6/2002 – 3/2006 Oracle DBA, Confidential,Northbrook IL
7/1997 – 6/2002 ORACLE DBA Consultant, Confidential, Northbrook, IL

Environment Oracle 8,9i,10g, Sun E10K, Sun F15K servers attached to Hitachi Freedom 9980V Storage.
Industry Insurance, Financial

Oracle DBA for Allstate Financial Technology (AFT)
Senior Oracle DBA for various applications within Allstate Financial Division, including life system, annuity system, claims and disability systems. Performed new product evaluations, project estimates, capacity planning, physical design of the databases, performance tuning and backups.
Most of these applications reside on Designed Business Resumption plans for mission critical applications. Utilized Oracle Data Guard to create failover environments.

• Created physical database design for Asset Liability Management (ALM) group to store various kinds of information for Earning at Risk analysis and VA Hedging analysis. This database was created in Oracle 10g on Sun Fire F15K server. AbInitio and PL/SQL were used for data extraction, transformation and loading. End users accessed the data via Business Objects. Integrated many 10g new functionalities into the physical design for manageability and performance: AWR, Grid Control, Data Pump, Bigfile tablespaces.
• Designed, Developed and Implemented database backup strategy. Utilized both RMAN and custom Korn Shell scripts. Used Hitachi split mirror option to create a reporting environment.
• Developed a custom Korn Shell scripts to create a Regression database using Hitachi ‘hot split’ functionality.
• Created user profiles, database roles and custom triggers to comply with the requirements of the Sarbanes-Oxley Act.
• Allstate Financial Marketing Database (AFDW)

The goal of this project was to integrate data from Allstate Financial’s operational systems in a centralized place and provide Marketing Department with decision support system as well as analytical and data mining tools to uncover patterns in customer behavior and to develop statistical predictive models for up-sell, cross-sell and customer retention initiatives.

• Created a physical design of the Operational Data Store system based on the logical model
• Provided guidance and support for the application developers on their daily activities, including tuning of code written in SQL, PL/SQL and AbInitio.

Oracle DBA , Confidential,

Allstate Enterprise Campaign Management (ECM)
The scope of this project was to design, develop and implement a DataMart to store customer and prospect information for campaign processes and measurement.

• Worked to identify system and data requirements and develop logical and physical design.
• Created Database objects including locally managed tablespaces, partitioned tables and indexes, materialized views, and function-based indexes
• Helped developers with SQL tuning: generated and analyzed execution plans,

utilized unrecoverable loads, direct load inserts and parallel DML processing.
Decision Support International ( DSI)
Participated in the design, development and implementation of decision support system for Finance, Claims, Marketing and Policy departments in Germany, Japan and Italy.

• Created Logical and Physical Database Designs
• Performed Database migration from Oracle 7 on RS6000 to Oracle8 on Sun 10K
• Worked on Euro conversion analysis and created a project plan for preparing the DSI system for the conversion
• Wrote a C program to convert Umlauts from EBCDIC into ASCII
• Worked with Unicode and National Language Support (NLS) technology
• Managed Metadata and Brio Repository

Data Warehouse project for the Special Investigations Unit (SIU)
Participated in the design, development and implementation of a system that assisted SIU Analysts in
Identifying fraudulent activity.

• Created physical model of the SIU Data Mart based on the logical design
• Sized and partitioned tables and indexes for better availability, manageability and performance
• Helped Desktop team to build, tune and optimize Brio queries
• Helped to create and optimize various parts of the Data Mart load programs using

SQL*Loader and Pro*C

6/94 – 6/97 DBA/ System Administrator, Confidential,Arlington Heights, Illinois
Environment Oracle 6, Oracle7, AIX, SunOS, and AT&T System V,
Industry Manufacturing

• Performed database administration services (installations, upgrades, performance monitoring and tuning) for over 60 ORACLE databases including Distributed and Parallel Server options for mission critical applications.
• Configured UNIX machines as Oracle database and application servers
• Performed Backup and Recovery of UNIX filesystems using asbs and NetBackup .