We provide IT Staff Augmentation Services!

Lead Oracle Developer Resume

Jersey City, NJ

SUMMARY:

  • IT engineer with total 25 years of experience, working mostly in the Confidential business area as well as in Retail, Telecommunication and Medical Insurance areas.
  • Software developer, data architect, database designer, Oracle DBA.

SKILLS:

  • SQL, PL/SQL, T - SQL, NZPLSQL;
  • C++, Oracle Pro*C, JAVA/JDBC/SWT;
  • UNIX shells: Korn, BASH, Bourne;
  • Object Pascal, VBA;
  • DHTML, JavaScript;
  • Oracle 7.0 - 12c; 22 years of experience;
  • MS SQL Server 2008; 3 years;
  • Netezza 7.2, DB2 - less than 1 year;
  • TOAD, Oracle SQL Developer, SQL Server Management Studio, Aginity Workbench for Netezza;
  • Oracle Data Modeler, Oracle Designer, ERWin;
  • Eclipse, Borland Delphi;
  • Oracle Forms, Oracle Reports, Oracle APEX;
  • Oracle Data Integrator, Oracle Golden Gate;
  • Cognos 7.0, Oracle OLAP;
  • Downloaded from Cloudera and tried a Hadoop cluster on VMWare;
  • Tested Oracle Big Data connectors in DEV environment;
  • Glass Fish, Tomcat, Weblogic;
  • Windows;
  • LINUX: RedHat, Ubuntu, Oracle Linux 7;
  • UNIX: Solaris, AIX, HP-UX;

EXPERIENCE:

Confidential, Jersey City, NJ

Lead Oracle Developer

Responsibilities:

  • Managing a group of 5 developers;
  • Providing source code quality control and deployment management;
  • PL/SQL development, SQL performance tuning;
  • Troubleshooting and resolving production issues on on-going basis;

Environment : Oracle 12c;

Confidential, New York, NY

Senior Oracle Developer (consultant)

Responsibilities:

  • Database design for Confidential Risk Data datawarehouse - a 50 TB database holding historical “stress-test” modeling results for the Confidential portfolio positions in Fixed Income, Currencies and Commodities sectors.
  • Supporting risk modeling C++ application;
  • Back-end software development for the Credit Risk data warehouse using PL/SQL (Oracle), T SQL (MS SQL Server) and NZPLSQL (Netezza);
  • Developing metadata manipulation scripts - Python;
  • Troubleshooting and resolving issues on on-going basis;

Environment : Oracle Exadata 11g, MS SQL Server, Netezza;

Confidential, New York, NY

Data Architect (consultant)

Responsibilities:

  • Created a conceptual design of the new “Data Bridge” repository to store metadata describing:
  • Source databases, their schemas, tables and columns;
  • Mapping of reference data model to actual source database structures;
  • SDLC information - about data model changes and progress of their deployment onto participating source databases;
  • Software development.
  • PL/SQL and JAVA coding for:
  • Extracting data dictionary metadata from the source databases - Netezza, Teradata, Sybase and Oracle - and for storing it in the “Data Bridge” repository hosted in Oracle;
  • Generating “integration layer” views that were to make each source database look alike;
  • Finding dependencies between queries/views and their data sources; wrote a SQL parser capable of parsing any legitimate SQL query in Oracle, Netezza and Teradata SQL dialects with the goal to find underlying tables/views;
  • Testing Oracle tools for working with Hadoop data.
  • Installed and configured Oracle Big Data connectors for, created external tables based on HDFS data files and performed a number of experiments querying and loading Hadoop data into Oracle with various levels of parallelism, gathering Oracle wait event statistics at the same time.

Environment: Linux, Oracle 11g, Netezza, Teradata;

Confidential, New York, NY

Lead Application Developer, Information Architect (consultant)

Responsibilities:

  • Lead a group of developers working on this project.
  • PL/SQL development - created a number of PL/SQL packages to implement complex data processing logic of resolving and enriching Transactional and Balance data feeds coming to Confidential data warehouse from external data providers - Trading Platforms, Brokers and Custodians;
  • Data migration - created scripts for extracting legacy data from MS SQL Server database and loading it into new Oracle environment;
  • Design of data structures in support of new functionality - created tables and views as needed.
  • Data processing automation using AutoSys, Korn shell, Perl.

Environment: Linux, Oracle 11g;

Confidential, Jersey City, NJ

Lead Application Developer (consultant)

Responsibilities:

  • Review and perfect functional specifications for ETL processes and other data maintenance procedures.
  • Develop PL/SQL programs as well as Unix shell scripts, review and troubleshoot PL/SQL code developed by others.
  • Fix performance-related issues in PL/SQL and SQL code.
  • Design tables, views and PL/SQL API procedures in support of newly added functionality.
  • Confidential was a set of tables and PL/SQL API on top of them for storing so-called “Preference Lists”. A Preference List was a collection of Items. Both the Preference Lists and their Items had few fixed attributes and extendable number of “dynamic” attributes that Confidential users could add/delete as they wanted. Confidential had access control mechanism that defined 3 levels of access: “read”, “write” and “administer” to the Preference Lists by the Users and User Groups.
  • The main use of Confidential was for BoA data warehouse Clients to maintain their “Subscription Portfolios” - lists of Financial Instruments they wanted to monitor. Detailed information about all the events in the “life” of those Financial Instruments (price changes, trading volumes, splits, merges, dividend payments, etc.) was sent to the Clients from the data warehouse in accordance with their Subscription Portfolios.
  • Developed a “Data Refresh Framework” - a set of tables and PL/SQL procedures to automate and simplify complex processing of large amounts of data. The tables stored metadata describing the steps of data transformation processes. PL/SQL procedures were of 2 kinds: 1) for orchestrating work by launching new data processing threads via DBMS SCHEDULER and for monitoring their progress and 2) for implementing particular data transformations; the latter ones were called from the data processing threads;

Environment: Linux, Oracle 11g, Oracle Golden Gate;

Confidential, Jersey City, NJ

Lead Application Developer

Responsibilities:

  • Review and perfect functional specifications for ETL processes and BI reports;
  • Design and document BI data presentation procedures for Crystal Reports developers;
  • Develop ETL and data presentation procedures (PL/SQL);
  • Review and troubleshoot PL/SQL code and Crystal Reports templates developed by foreign consultants; fix performance-related issues and inconsistencies with the functional specifications.

Environment: Solaris 10, Oracle 11g, Oracle OLAP, Oracle Golden Gate;

Confidential, Lyndhurst, NJ

Oracle DBA (consultant)

Responsibilities:

  • Oracle DB administration and configuration, including Streams AQ and Oracle MGW;
  • SQL and PL/SQL development and performance tuning; Shell scripting;

Environment: AIX, Oracle 10g;

Confidential, New York, NY

Oracle DBA, lead developer

Responsibilities:

  • SQL and PL/SQL development and performance tuning (OLTP and ETL);
  • Oracle Data Integrator: installation, configuration and development;
  • ETL process management using Control-M;
  • Logical and physical DB design of Confidential e-Commerce data warehouse;
  • Oracle DB administration: 10g and 11g; backup, recovery (RMAN)

Environment : Solaris 10, Oracle 10g and 11g;

Confidential, New York, NY

Oracle developer

Responsibilities:

  • Development and optimization of the software for data consolidation and cleansing (PL/SQL, TOAD), including performance tuning;
  • Physical DB design (tables, indexing, partitioning);

Environment : Sun OS 5.9, Oracle 9i (9.2.0.7)

Hire Now