Objective:

• Seeking a challenging position where I can utilize my experience and strong problem-solving abilities in Application Development / Database Architecture Design/ Redesign / Data Security / Migrations / Business Intelligence / Data Warehouse and System Architecture Implementations as a Subject Matter Expert.

Summary:

• Over sixteen 16 years of IT experience in Application Development, Database Administration, Data Security, Metadata, Database Physical / Logical Design and Modeling based on Enterprise Wide Application Software Development Lifecycle. OLTP and OLAP database Architecture and Application Design with emphasis on Data Normalization and Query Optimization, Star and Snow Flake Schema setup for Data Warehouse applications using Oracle 11g, 10g, 9i and 8i databases.
• Lead several database migrations / integrations during Cingular / AT T acquisitions of other cellular companies. Experience in providing Tier III support to users and data integrity teams for bulk data manipulations. Acted as Scrum master using Scrum Agile Technology concepts for timely implementation of projects and resource utilization.
• Hands on Expert in PL/SQL programming using stored procedures, functions, packages for Oracle Forms, Reports and Discoverer. Data migration Expert using Customized PL/SQL code and Oracle Warehouse Builder OWB to establish data quality and customized source to target mappings in various Oracle database versions for EarthLink's MetaSolv Telecom application, AT T SIMS application and FDLE's Florida Department of Law Enforcement legacy fingerprint data.
• Excellent People Skills to communicate with all levels of stake holders in an organization to present mutually agreeable software solutions which are not only user friendly but also cost effective and forward compliant with reference to latest software and database technologies.
• Expert in Vendor negotiations. As Oracle License Manager, saved GE Power Systems over 18 Million USD by determining the best applications for the enterprise and aggregated all the database and application licenses for different sub organizations into one corporate deal.
• Extensive experience in Database Administration / Query Optimization of Oracle 11g/10g/9i/8i/8.x/7.x in UNIX, Linux and Windows environments.
• Experienced in Sybase, DB2 and MS SQL Server connectivity interfacing Oracle Database using Oracle Transparent Gateways.
• Experience in Oracle Database Installation, Creation, Tuning, Testing, Partition, Backup, and Migration. Database Performance monitoring, Troubleshooting and Recovery in Dev, Test and Production for UNIX, Linux and Windows environments.
• Developer group support for creating, managing and deploying Schemas, Users Access control and Security, database objects such as tables, sequences, indexes, stored procs, functions, triggers, packages and maintain them via Version change control SQL scripts.
• Data Security using audit schemas, Oracle Virtual Private Database VPD previously known as Fine Grained Access Control also called Row Level Security, Performance tuning under VPD. Setup of Oracle Database Vault in Oracle 11g for Corporate Governance Regulations which include Sarbanes-Oxley, PCI, HIPAA, Gramm-Leach Bliley, the Japanese Privacy Act, BASEL II, and much more.
• Database optimization for Multi TB VLDB high transaction OLTP and OLAP mixed databases using Oracle 11g's new features such as Interval based automatic partitioning, referential partitioning for child tables, Virtual function based columns and partitioning based on Virtual columns. Oracle 11g server's holistic tuning using SQL tuning sets in SQL Performance analyzer. Used Oracle 11g Optimal Flexible Architecture OFA setup features to minimize disk contention for I/O.

Skills/Tools:

RDBMS: Oracle 11g,10g, 9i/8i/8.x/7.x, Net8/SQL Net, Sybase, DB2 and MS SQL Server.

Tools: Oracle Enterprise Manager, Oracle MetaSolv Migration Tool MTT , RMAN, ISQLPLUS, SQL Plus, PL/SQL, Data Pump, SQL Loader, SQL Trace, Auto Trace, TKPROF, Export/Import, Server Manager, Developer , Forms, Reports, VSS, Clear Case, Oracle Designer, Discoverer Admin, and User, Oracle WebDB and Oracle Portal, JDeveloper, Oracle Warehouse Builder, Oracle Workflow, RConfig, TOAD, MS Office, MS Project, MS FrontPage, Dream Weaver, Actuate, Vi Editor / Emacs, JEDIT, Exceed, Putty, File Zilla, Scrum Technology.

DBMS Design Tools: , Oracle Designer, Erwin, Embarcadero ER/ Studio, VISIO

Operating System: Solaris, Red Hat Linux, Windows, DOS

Languages: PL/SQL, SQL, UNIX Bourne/ Korn Shell

Experience:

Project Name

Confidential

Duration

Confidential

Employer: Oracle Corporation

Role

Senior Oracle Consultant

Location

Confidential

Project Description

Requirement gathering, Source to Target Mapping, Customization / Optimization of Oracle's MetaSolv Migration Tool for data aggregation of two sources. BAR Business Analysis Reports generation using stored procs and Microsoft Excel.

Technologies Hardware, Software, languages, and tools used

MetaSolv App Version 5.2, 6.0. Oracle Databases 8i,10g Enterprise Edition on Sun Solaris, SQL Plus, PL/SQL, Oracle SQL Developer, MTT MetaSolv Migration Tool , FileZilla, Vi Editor and Putty.

Project Name

Confidential

Duration

Confidential

Employer: Nettraffic Inc.

Role

Lead Senior Application Database Architect

Location

Confidential

Project Description

Redesigned and optimized Nettraffic's Network Monitoring Products and increased efficiency form 15K records / 5 minutes Collection to 1.2 Million records / 5 Minutes Collection cycle. Optimized Reporting queries for Actuate Reporting.

Technologies Hardware, Software, languages, and tools used

Oracle 11g Enterprise Edition on Linux RHEL 4.0, Sun Solaris and Windows environments, SQL Plus, PL/SQL, Oracle Enterprise Manger, Embarcadero ER/ Studio, SQL Performance analyzer, TOAD, PL/SQL Developer, Actuate, Vi Editor and Putty.

Project Name

Confidential

Duration

Confidential

Employer: Florida Department of Law Enforcement

Role

Lead Senior Application Database Architect

Location

Confidential

Project Description

Complete Logical and Physical Database Redesign with Metadata Rewrite for 15 Seconds SLA for Each Candidate's Finger Print Verification Process.

Technologies Hardware, Software, languages, and tools used

Oracle 10g Release 2 on Linux RHEL 4.0, SQL Plus, PL/SQL, Oracle Enterprise Manger, Erwin, Oracle Warehouse Builder, Toad, Vi Editor and Putty.