SUMMARY:

• Oracle 7 thru Oracle 12c database development and management.
• UNIX Systems (HP/UX, Oracle Solaris, AIX, Linux) administration. Shell scripting and UNIX utilities.
• ETL, data cleansing and mining.
• Data modelling: Logical and Physical database design for OLTP and Data Warehouses.
• Performance tuning of SQL, PL/SQL and RAC, T - SQL.

Languages: PL/SQL; SQL; UNIX Scripts; PowerBuilder; VBA; VB; ASP; Delphi; Java; XML; HTML; C; Pro*C; Perl; Cobol.

RDBMS: Oracle 7.3 - 12c; SQL Server; MySQL; Access.

Oracle: SQL*Plus; Oracle; SQL*Loader; Oracle Text; Oracle Spatial; OEM; Oracle Developer; Oracle Designer; RMAN; DataGuard; RAC; GoldenGate; Editions; Change Data Capture (CDC).

OS: UNIX AIX, HP, Solaris, Linux, RHEL, Oracle Linux, Red Hat Linux; Open VMS; Windows.

Storage: NetApps; Veritas, EMC BCV.

EDI: EDI ANSI x12; EDIFACT; GEIS; EDI*Express.

Software: Informatica; TOAD; PI; Erwin, Rational Rose; ClearCase; SAS; Crystal Reports; SharePlex; TIBCO; Data Junction; Reflection; Cognos; Amazon EC2 and S3; PVCS; VSS; Eclipse; Perforce; Agile

PROFESSIONAL EXPERIENCE:

Confidential, Beverly Hills, CA

Senior Oracle Consultant

Responsibilities:

• Maintenance and enhancements of Clinical Data warehouse on Oracle backend and related ETL processes.
• Java procedures, PL/SQL, triggers, materialize views, external tables, shell scripts for implementation of new features and maintenance. Monitoring of ETL processes, fixes and adjustments.
• Cloning of Oracle 11g, 12c schemas to various environments as needed. Loading of initial data sets (> 1bil records). Partitioning, compression and parallel loading.
• Data modeling: Logical and Physical design of new tables and processes. Performance tuning of Oracle and SQL Server SQL, PL/SQL and T-SQL. Reporting on SQL Server, MYSQL.

Confidential, Universal City, CA

Senior Oracle Consultant

• Support for implementation of JAVA / Oracle 11g based OLTP application for release into production. Debugging of applications and databases. PL/SQL, functions, procedures, triggers, shell scripting.
• Maintenance of Linux Oracle 11g databases. Cloning of databases and schemas of Prod/Dev/Test environments. Monitoring of system events and proactive adjustments. Performance tuning of SQL, PL/SQL, partitioning and system parameters.
• Automation of comparison of Schemas in same database and different databases. Reporting differences.

Confidential, Woodland Hills, CA

Senior Oracle Consultant

• Credit Card processing system: AMEX, MC, VISA, ACT-0010, Captures, Sales, Chargebacks, Retrievals; Mnemonics; RISK - maintenance, new developments and tuning.
• Oracle 11G. Design, documentation, PL/SQL coding, tuning, sizing, implementation, maintenance of database and processes for legacy and new databases: OLTP and Data warehouse.
• Maintenance of RISK SQL Server Database with T-SQL transformations using Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL.

Confidential, San Ramon, CA

Application Architect

• Smart Meter Hourly Foundational Repository and Validation / Aggregation Engine.
• Oracle 10G. Design, documentation, coding, tuning, sizing to fit on a laptop, implementation, maintenance and user training.
• Work closely with Electrical and Gas Engineers. Heavy use of analytical functions and partitioning.

Confidential, Southern, CA

Oracle Developer

• Managing a PL/SQL reporting system, which produces files and/or reports 24x7? Using multiple servers and databases for data selection with terabytes of data. Use of materialized views and partitioning. Referential integrity, lookups and external tables. Triggers and auditing. Tuning of SQL, PL/SQL. Scheduling of DBMS JOBs and scheduler jobs (in thousands).
• Reporting based on SQL Server data. Crystal Reports, T-SQL, VBA, Access, Excel, MySQL.

Confidential, Northridge, CA

Oracle DBA

• Managing SQL Server (50+) and Oracle Production and Development Databases (15): 9i to 11g versions both OLTP and Data Warehouse database under AIX, Linux, Windows, and VMware using scripts and Oracle Grid Control: 10g and 11g.
• Maintainance, debugging and fixes of Tivoli TSM backups for Oracle RMAN and SQL Server Databases.
• Provided DBA support for Oracle Applications: JD Edwards, Demantra, Hyperion, OBI teams in ongoing installations and setup. RMAN, Grid Control.
• Development and implementation of backup and recovery procedures; tuning of OLTP and Warehouse databases for SQL Server and Oracle.
• Monitoring, AWR, ADDM, Statspack. Recovery of SQL Server and Oracle databases. Loading of data.
• SharePlex data replication of Oracle databases.

Confidential, Alhambra, CA

Oracle Developer

• Implemented PW accounting Operational Data Store (ODS) and Fleet management Interface. Logical and physical database design. UNIX shell scripting / PL/SQL / Perl ETL processes for data loading from eCAPS to ODS and backward. Performed capacity planning and on-going maintenance of database.
• Maintained and created ASP.NET web applications under supervision of Manager and Principal Developers ( Invoice Payment Status Inquiry, etc.).
• Performed on-going departmental tasks using ColdFusion, C#, HTML, COBOL, PowerBuilder, GIS.
• Setup of test, staging environments for ODS. Documentation. Implementation of standards for testing and version control.
• Participated in creation of Data Mart for PW purchasing using PL/SQL / UNIX shell scripts / COGNOS.
• Created, modified, tested and debugged Oracle objects: packages, procedures, tables, indexes, etc. for database and web applications. Performed tuning of PL/SQL code, database, ETL processes and complicated SQL statements.

Confidential, Burbank, CA

Oracle Developer / Data Architect

• Supported MARS Digital Asset Management system. Implemented Oracle Text for efficiently querying of free texts and tables and wrote sudo-code requirements for GUI implementation by 3rd-party Company. Setup of Oracle Jobs to collect data, sync, index and rebuild index. Data modeling for Web Portal. SQL tuning. Transfer of knowledge and training of team members.
• SDLC development for multiple projects: Database Design, Installation, Tuning and Optimization, Documentation, ETL, and Source Control. Support of development and support teams. Troubleshooting of real-time problems.