We provide IT Staff Augmentation Services!

Owner/founder Principal Consultant Resume Profile

New York, NY

SUMMARY

Senior Oracle Consultant with diverse experience as an Oracle Architect, Oracle Developer/DBA, Oracle Portal Architect, Web Developer, Performance Tuning and migration specialist

TECHNICAL KNOWLEDGE

  • Software: ORACLE v6, v7, v8i, v9i, 10g, 11g RAC , 11g Fusion Middleware, WebLogic,10gAS, PLSQL, Java J2EE, JSP, XML, Oracle Portal, Oracle Data Warehouse, Oracle Reports, Oracle Designer, Oracle VPD, OID, OLAP, AWR, Discoverer, UNIX Shell, JavaScript, Analytic SQL, IBM DB2, ERwin, TOAD, VLDB, Oracle Enterprise Manager OEM, RMAN, Oracle Tuning Utilities, Oracle Data Migration Utilities
  • O/S: Sun Solaris, IBM AIX, Windows, HP-UX, Red Hat Linux

EXPERIENCE

Confidential

Owner/Founder Principal Consultant

Provider of computer services Oracle Consulting, Oracle Performance Tuning, Oracle Architecture, Oracle Design, Oracle Development, Oracle Troubleshooting, Oracle Strategies.

Confidential

Senior Oracle Architect

Tools: Oracle 11g RAC, 11g Fusion Middleware, Oracle 10gAS, Oracle Portal 10g, PLSQL, Erwin, Linux, Windows, OEM

  • Modified 22c2 PLSQL packages resulting in 75 time reduction for multi-million record trade loads.
  • Re-designed and partitioned billion-record trade analysis tables for better management and throughput.
  • Designed tables, schemas, workflow processes and developed Portal web interfaces for Audit Log application using Oracle Portal PDK, JavaScript, HTML and Portal Components.
  • Tuned PLSQL stored procedures, SQL and advised team on best coding practices of web-enabled Oracle systems.
  • Implemented Oracle VPD application context security policies to control Sungardclient access and provide fine grained access control to client ad hoc queries.
  • Migrated Solaris 11g Oracle Data Warehouse 22c2 to Windows Environment.
  • Upgraded Brokerage Group STCM 10gAS Reporting environment to 11g Fusion Middleware.
  • Acted as lead advisor and troubleshooter to all Oracle-related issues and solutions.
  • Created 22c2 physical standby database for disaster recovery effort.
  • Tuned PLSQL stored procedures and SQL for BBH and UMB application portals.
  • Assisted DBA in SQL load of Global Data System tables and GDS troubleshooting.
  • Implemented database connection and data feed between State St. and Sungard Oracle databases.
  • Tuned Brokerage Group's Oracle Financials OBS process
  • Maintained and Monitored Brokerage Group's Compass database system

Confidential

Senior Oracle Architect

Tools: IBM AIX, Oracle 9i, Oracle 9iAS, 10gAS, Oracle Portal 9i, 10g, PLSQL, PDK, UltraSearch

  • Developed portlet to search OID and NSLIJ proprietary tables for Physician and Employee records.
  • Created PLSQL procedure to mass upload photos for BLOB storage in Physician and Employee records.
  • Implemented XML RSS portlets for procuring and rendering WebMD headlines in HealthPort.
  • Set-up UltraSearch prototype within Oracle Portal for more efficient searching of hospital content.
  • Mentored team on Portal preferences, session storage and caching APIs and procedures.
  • Acted as 'go-to' person for all Oracle Database, Application Server or Portal issues.

Confidential

Senior Oracle Architect

Tools: IBM AIX, Oracle 10g, Oracle 10gAS, Oracle Portal 10g, PLSQL, Discoverer, Windows XP

  • Instrumental in all aspects of the SDLC requirements, design, development, deployment, documentation and training.
  • Co-architect for Oracle Data Mart relational model and table partitions assisted in design of dimensions and cubes.
  • Developed PLSQL ETL routines for loading the Oracle Data Mart 10g database.
  • Designed Oracle Portal layout, navigation and security implemented Discoverer portlets for 'Business Dashboard'.
  • Integrated Oracle E-Business Suite with Oracle Portal to enable Single Sign-On of multiple applications.
  • Assisted ADP technical team in installation and deployment of 10gAS and Oracle Portal.

Confidential

Senior Oracle Architect/DBA consultant

Tools: Red Hat Linux, Oracle v9i, 10g, IBM DB2, PLSQL, WebSphere 5.1, Java, JSP, Windows XP

  • Team participant in Oracle redesign of Starwood Rates Database Engine to support new reservations applications duties included optimization strategies data migration business rules implementation PLSQL/SQL development.
  • Redesigned rates query and doubled throughput from 90 to 180 tx/min halved avg. response time from 6 to 3 sec.
  • Optimized rates data updates and tripled throughput by applying PLSQL collections and bulk bind features.
  • Employed Analytical SQL and other data warehouse methods for use in access to multi-million row partitioned tables.
  • Developed Java application to apply updates to Oracle Rates Database from IBM DB2 source data.
  • Mentored junior developers on PLSQL and Oracle Analytic SQL coding techniques.

Hire Now