SUMMARY

• More than 10 years of experience in Oracle Development versions 7, 8i,9i,10g,11g, and 12c combined with good development skill.
• Solid knowledge of data modelling and Logical and Physical database design; performance tuning of SQL and PL/SQL.
• Working knowledge and programming experience with various Oracle features: external tables, XML DB, bulk load, analytical functions.

TECHNICAL SKILLS

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

RDBMS:  Oracle 7.3 - 12c; Teradata; 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

Senior Oracle Consultant

• ETL; Transformations; Loading of data warehouse; performance; partitioning; analysis; PL/SQL; Clarity.

Senior Oracle Consultant

• Support for implementation of JAVA / Oracle based application.
• Oracle 11G. Maintenance. Performance tuning. Database comparison automation.

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, 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.

Application Architect, Consultant

• 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.

Oracle Developer / Architect

• Documentation and research of Application tracking Releases and Repertoire for UMG. VPD (Virtual Private Database), nested triggers, XML.

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. 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.

Oracle DBA

• Managing SQL Server (50+) and Oracle Production Databases (15): 9i to 11g versions both OLTP and Data Warehouse database under AIX, Linux, Windows, and VMware. Oracle Grid Control: 10g and 11g, Production and Development. RMAN backup to Tivoli TSM for Oracle and SQL Server Databases. Provided assistance to JD Edwards, Demantra, Hyperion, OBI Teams in ongoing development and installation of new versions. Development and implementation of backup and recovery, tuning of OLTP and Warehouse databases for SQL Server and Oracle. AWR, ADDM, Statspack. Used SharePlex in standalone environment. Tuning of SQL Server and Oracle databases to improve performance; tuning of Tivoli backups for SQL Server and Oracle. Recovery of SQL Server and Oracle databases. Loading of data. Creation of Alerts for Oracle Applications. Installations.

Oracle Developer

• Migrating legacy Public Works (PW) accounting data into Countywide Accounting and Purchasing System (eCAPS).
• Implementation of PW accounting Operational Data Store (ODS). Logical and physical database design and implementation. Coded UNIX shell scripts / PL/SQL / Perl ETL processes and used Informatica for data loads from eCAPS to ODS and backward. Performed capacity planning and on going maintenance.
• 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 and working closely with COGNOS developers.
• Create, modify Oracle objects: packages, procedures, tables, indexes, etc., using PL/SQL for web application developers. Data modeling. Performed tuning of SQL statements, PL/SQL code, and database and ETL processes for application developers.

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 Optimizations. 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.