SUMMARY:

• Senior Oracle Database Administrator specializing in Application Performance Tuning / Monitoring with a track record of delivering complex, high risk, high value and highly optimized projects through design, development, re - factoring, implementation and maintenance of Enterprise Class Applications/RDBMS using Oracle 9i/10g/11g/12c, Real Application Clusters, Oracle Applicatons 11.x, Oracle Forms, Reports, Designer, .NET on Unix, Linux, IBM and PC platforms.
• Designed database architecture and processes with emphasis on using best practices to meet and exceed business requirements with flexibility and application performance a top consideration.
• Developed and established enterprise wide Best Coding Practices, PL/SQL and SQL coding and Tuning standards.
• Experience in data conversion, Migrations between various releases of Oracle and setup/maintaining data integrity via database design and constraints.
• Preparing process and requirements documentation (AIM Methodology) and user guides.
• Involved in the maintenance and tuning of new and existing programs, processes, interfaces, reports, investigated various production issue and providing highly optimized and scalable technical resolutions.

COMPUTER SKILLS:

Databases: Oracle 11g / 10g / 9i, Oracle Real Application Clusters, SQL Server

Languages: PL/SQL, SQL, Java, C, Pro*C, Visual Basic .Net

Tools: Oracle eBusiness Suite 11.x, Oracle Forms, Oracle Reports, Oracle Designer, Discoverer, Oracle Warehouse Builder Oracle SQL DeveloperSQL Plus, SQL-Navigator, TOAD, PL/SQL Developer, ERWIN.

Platforms: SOLARIS, Linux, SCO-Unix, OS/400, Windows

Hardware: Sun, Dell, IBM, IBM Compatible PC’s

RELEVANT EXPERIENCE:

Oracle Technical Team Lead

Confidential, Detroit, MI

Responsibilities:

• Leading the Confidential Oracle Technical team to proactively monitor and refactor problem areas to maximize Database performance and minimize outages
• Investigating the SmartAuction system to eliminate database bottlenecks and improve system scalibility

Senior Database Administrator

Confidential, Auburn Hills, MI

Responsibilities:

• Lead the Continuous Improvement Program, this group was responsible for enterprise wide performance and process improvement.
• Created password sync process to synchronize database user passwords from LDAP / AD to all of VW's enterprise databases
• Created process to assist with pro-actively manage database storage space and predict usage based on patterns
• Monitored & Automated Database Feature Utilization check to ensure compliance with Oracle License Agreements
• Partitioned existing Tables and Indexes to manage data more efficiently and assist with data purging activities
• Created database login triggers to track user logins in protected production systems
• Introduced Oracle Proxy Authentication to the VW enterprise to support legacy processes, Created management system to retain privileges when lower environments are refreshed with production data.
• Assisted the development resources with implementing database and application level security for compliance with the VWAG 2013-14 ITSP Initiative
• Streamlined the process of promoting database and application changes across the various database instances ( DEV / QA / Production )
• Implemented Virtual Private Databases to secure sensitive business and customer information, provided various user access levels based on roles in the organization
• Co-ordinated the database change meetings to review and discuss and plan changes to various database objects
• Assisted with the development of the Main Frame rewrite project, Redesigned the data model to accommodate current business requirements and platform changes
• Created a fast data load process for importing approximately 30 years of historical data the new Product Compliance and Warranty Claims Processing System in Oracle
• Created daily reconcillation process to balance North American Recall databases with feeds from VWAG
• Created a User Lookup tool to assist the VWGOA security team in identifying existing users across the enterprise databases / applications (Oracle / MySQL / SQL Server / SAP / LDAP / Active Directory) and predict new user names in the Confidential Group of America.
• Created data transfer application between LDAP / SAP / SAP-BW and VW's eTAG system
• Redesigned and developed the business critical AIM/VIM Vehicle Locate process used by dealerships in North America, Added several innovations to the backend code, including dealer query tracking, data generation for business analytics.
• Refactored several business critical Sales Reports based on Oracle Reports, reducing execution time and system IO
• Refactored queries and procedures for the MBO - DSO, Order Generator and Vehicle Allocation project.
• Designed & Developed a LDAP to HP Service Manager sync process, enabling the automated inclusion of new users to HP Service Manager
• Tuned the IT Services, SM9, Parts & Warranty Help Line modules of HP Service Manager, Achieved significant improvement in database performance and end user experience.
• Assisted the Confidential Group of America MDM Development Staff in optimizing the CII Database Search Interface
• Re-designed and optimized the TASKLIST scheduler process used by VCI
• Performed various DBA activities including but not limited to Creating Users, Resetting Passwords, Adding datafiles, Shrinking Tables, Rebuilding Tables / Indexes, Exporting / Importing database objects
• Mentored On-Site & Off-Shore DBA & Developer resources, performed several lunch-n-learn sessions to introduce coding standards, best practices and tuning techniques.
• Optimized several hundred queries across the Confidential Group of America Database environments
• Formulated best practices for quick data migration with minimal production outage during the Database Hardware upgrade from Sun T2’s to T3’s and Oracle 11.1 to 11.2
• Created database users, profiles, objects like tables, views, procedures, materialized views etc.
• Configured Virtual Private Database, policies and enterprise database security policies
• Maintained ASM Disk groups
• Performed database imports / exports
• Create automated process to manage database tablespace size and freedisks
• Operated as a backup for the VW Database Team Manager managing 80+ databases, onsite and offshore DBA resources

Software Engineer / Senior Oracle eBusiness Suite Developer / Technical Lead / Performance Architect

Confidential, Auburn Hills, MI

Responsibilities:

• Designed and Developed a web portal for Confidential hourly employees worldwide to access their work schedules and other time sensitive information interfacing with Oracle eBusiness HR and Scheduling modules.
• Partitioned several database tables to reduce contention, improve manageability and increase database performance for the Scheduling System.
• Developed a bridge between Oracle eBusiness HR and Active Directory to simplify and automate profile maintenance during Employee hiring and termination processes.
• Created an Excel publishing utility, similar to XML Publisher, using Oracle/Java for generating high-quality multi-language/character set capable Excel reports, with support for Pivot Tables, Conditional Formatting and various other features supported by Excel.
• Created a hybrid cube for increasing performance and reducing system burden for the KBACE/KBIR datawarehousing system interfaced with Oracle eBusiness HR modules
• Tuned Garnishment process within the ADP payroll system which interfaces with Oracle eBusiness Payroll module.
• Refactored the Oracle to KBACE/KBIR ETL process - dramatically increasing system availability and reducing the downtime required for system refreshes.
• Redesigned and tuned system processes to increase the overall system availability and increase application performance while reducing CPU consumption: Scheduling Workbench, Employee Availability Scheduling, OPES.
• Redesigned the inter-system data exchange for applications (HRMS and Scheduling). Configured and implemented Oracle Streams for effective and fast data exchanges/replication (Store Inventories, Scheduling, HRMS).
• Created a parser for cleansing and standardizing time sheet data received from worldwide inventory sites which resulted in a significant reduction of Help Desk tickets and manual technical resource intervention.

Senior Developer / Technical Lead

Confidential, Highland Park, MI

Responsibilities:

• Investigating & tested the implementation of Oracle 11g RAC on RH Linux.
• Designed and developed a Billing and Invoicing system for Confidential Dealers Advertising Association that funds the new vehicle catalog allocation program using Oracle 10g, Linux and Java.
• Architected the TAP Professional data warehouse system to be used for analysis of prescription trends, marketing and fulfilling merchandise, samples to physicians across the country. Created ETL processes for data manipulation. Tuned PL/SQL processes to improve system processes.
• Designed, Developed, Implemented Java stored procedures / functions in Oracle to interact with Linux and perform operating system level tasks.
• Redesigned / Re-Factored and Tuned PL/SQL Stored procedures & Functions for the Brand Management Platform - Confidential ’s flagship product for the Pharmaceutical Industry. Achieved 99.99% performance gain in the batch Transaction processing processes.
• Led a team of developers for investigating, securing and establishing a security protocol to be used enterprise wide for securing sensitive customer data in Oracle using Oracle Advanced Security and homegrown tools and utilites.
• Contributed to the development of Confidential ConsumerTrac data warehouse, redesigned the ETL process.
• Designed, Developed, Implemented & Maintained the DaimlerChrysler Literature Push system using Oracle 10g, Linux, PL/SQL, Stored Procedures, Triggers, Forms & Reports. Created PL/SQL Stored Procedures utilizing External Tables, Application Context, Expression Filters, Regular Expressions.
• Designed, Developed, Implemented & Maintained the Ford, Lincoln & Mercury Catalog Allocation system using Oracle 10g, Linux, PL/SQL, Stored Procedures, Triggers, Forms & Reports. Created PL/SQL & JAVA Stored Procedures utilizing External Tables, Application Context, Expression Filters, Regular Expressions.
• Designed, Developed, Implemented & Maintained the Ford Extended Service Plan Launch Kit Application using Oracle 10g, Linux, PL/SQL, Stored Procedures, Triggers, Forms & Reports. Created PL/SQL & JAVA Stored Procedures utilizing External Tables, Application Context, Expression Filters, Regular Expressions.
• Suggested many system improvements/problem resolutions/ideas to business and technical team to solve business and/or data issues.
• Created and updated business and technical documents using standard templates technical design documents, business design documents, system request documents.
• Created many database table triggers using Oracle 10g to perform actions based on events and business rules.
• Created SQL Scripts / Queries for testing code changes
• Transitioned work to team members and Mentored junior developers when required.
• Organized and Led Lunch-n-Learn sessions for Oracle 10g/11g new features and implementation.

Developer

Confidential, Madison Heights, MI

Responsibilities:

• Analyzed, Designed, Developed and Implemented RMS - Raw Material Pricing forecasting system to efficiently manage and forecast pricing changes of raw materials and finished products for Confidential ’s North American operation using ORACLE 10g PL/SQL, Forms & Reports.
• Designed ETL and Mining processes to extract data for this system from Confidential ’s Mainframe data warehouse.

Developer

Confidential, Troy, MI

Responsibilities:

• Designed, Developed, Implemented & Maintained the Confidential Service Contracts system, featuring a unique copy screen logic to copy information from DaimlerChrysler systems to BBDO’s data entry screens.
• Designed, Developed & Implemented ETL procedures for the Confidential CRM Data warehouse - PROFILER.
• Designed, Developed, Implemented & Maintained the Jeep Columbia Edition Website backend programs involving order processing & fulfillment, returns & de-dupe.
• Designed, Developed, Implemented & Maintained the Fulfillment Automation system for fulfilling prospective customers request for product information on various DaimlerChrysler Brands
• Designed, Developed, Implemented & Maintained backend processing for BrookStone Gift Certificate Test Drive program featuring unique and complex de-dupe logic.
• Designed, Developed, Implemented & Maintained Scoring De-Dupe program for filtering excessive & repetitive product information requests from prospective customers.
• Designed, Developed, Implemented & Maintained Test Grid programs to produce a data grid used to verify the setup of various marketing programs.
• Designed, Developed, Implemented & Maintained ShowTracker GUI front end data upload programs to load data from external sources to Oracle & AS/400.
• Maintained the GLMS system, created new and modified existing inquiry modules / programs / reports.

Developer

Confidential, Auburn Hills, MI

Responsibilities:

• Researched and documented system requirements for conversion of the existing S-36 - RPG - II System
• Prepared analysis and design documentation for CIS system configuration and business processes
• Designed the database architecture for converting the existing S36 - RPG - II system to AS/400 - RPG IV ILE
• Designed an interface between the AS/400 & VAX
• Re-Designed, Developed & Maintained the Real Time Inventory control system, HATEBUR operational and scheduling system, Truck scheduling system, Scrap Control and Recycling system.
• Data Migration from System 36 to AS/400
• Design & Development of programs, procedures, screens and reports.

Senior Programmer

Confidential

Responsibilities:

• Researched and documented system requirements for creation of a case tool to convert and migrate Confidential ’s existing AS/400 RPG application code base and data to Oracle PL/SQL and XMAP-III
• Designed, Developed and Maintained a case tool (clPORT) to convert CL/400 and OCL code to ORACLE PL/SQL, PRO-C with XMAP GUI Interface and ACP calls.
• Developed modules for the case tool rPORT to convert RPG II and RPG III code to ORACLE with XMAP GUI Interface and ACP calls for DB Connectivity using PL/SQL, PRO-C.
• Designed, Developed & Maintained source scan routines & reports to be used during the pre-processing stage using PL/SQL and Oracle Reports.
• Create