SUMMARY:

• Oracle 7 thru Oracle 12c database development and management.
• UNIX Systems (HP/UX, Oracle Solaris, AIX, Linux) administration. Shell scripting, sed, awk and others.
• 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.
• Knowledge of Oracle external tables, XML DB, bulk load, analytical functions and other features.

TECHNICAL SKILLS:

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

RDBMS: Oracle7.3 - 12c; SQL Server; MySQL; Access.

Oracle: SQL*Plus; Oracle; SQL*Loader; Oracle Text (CTXSYS); Oracle Spatial Data (MDSYS); OEM; Oracle Fusion Middleware; Oracle Developer; Oracle Designer; RMAN; Editions.

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; Erwin, Rational Rose; ClearCase; SAS; Crystal Reports; SharePlex; TIBCO; Data Junction; Reflection; Cognos; Amazon EC2 and S3; PVCS; VSS; Eclipse; Perforce; Agyle.

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 scripting 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) with help partitioning and parallel loading.
• Data modeling: Logical and Physical design of new tables and processes. Partitioning, compression, performance tuning of SQL and PL/SQL. Reporting on SQL Server, MYSQL.

Confidential - Universal City CA

Senior Oracle Consultant

Responsibilities:

• Support for implementation of JAVA / Oracle 11g based OLTP application for release into Production. Debugging of errors from application server and database. PL/SQL, functions, procedures, triggers, shell scripting programming.
• Maintenance of Oracle 11g databases on Linux. 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

Responsibilities:

• Credit Card processing system: AMEX, MC, VISA, ACT-0010, Captures, Sales, Chargebacks, Retrievals; Mnemonics; RISK - maintenance, new developments and tuning.
• Oracle 11G. Design, documentation, 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, Consultant

Responsibilities:

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

Confidential - Southern CA

Oracle Developer

Responsibilities:

• 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. Usage and implementation of materialized views. Partitioning of tables for performance and maintenance. Referential integrity for lookup and operational tables. Triggers for logic and auditing. Optimization of PL/SQL packages, procedures and SQL statements (hints, indexes, etc.). Scheduling using DBMS JOBs and scheduler jobs (in thousands). Reporting based on SQL Server data. Crystal Reports, T-SQL, VBA, Access, Excel.
• Loading MySQL databases. Optimization of reports and ETL for European and Asian offices.

Confidential - Northridge, CA

Oracle DBA

Responsibilities:

• 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.
• Maintained, debugged and fixed backups to Tivoli TSM for Oracle RMAN and SQL Server Databases.
• Provided assistance to JD Edwards, Demantra, Hyperion, OBI Teams in ongoing setup / development and installation of new versions of Oracle Applications using scripts and 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.
• Data replication of Oracle databases using SharePlex in standalone environment.

Confidential

Oracle Developer

Responsibilities:

• Implemented PW accounting Operational Data Store (ODS) and Fleet management Interface. Logical and physical database design. Coded UNIX shell scripts / PL/SQL / Perl ETL processes for data loads 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 App. Developer, example: Invoice Payment Status Inquiry.
• Performed on-going departmental tasks using ColdFusion, C#, HTML, COBOL, PowerBuilder, GIS.
• Implementation of test, staging environments for ODS. Documentation. Implementation of standards for testing, version control, and implementation of changes.
• 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 for application developers.

Confidential - Burbank, CA

Oracle Developer / Data Architect

Responsibilities:

• 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 Optimizations. Transfer of knowledge and 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.