Database consultant Resume Jersey City, New Jersey - Hire IT People

SUMMARY:

Oracle, PL/SQL, ETL professional with 12 years of experience of leading & delivering software projects.
I have strong technical background of software development using oracle, PL/SQL and Informatica.
Committed to professionalism, able to see the big picture while paying attention to small details, and excellent communication skills.
I’ve been working on Oracle, Pl/Sql development projects for 12+ years and have got around 7 years of experience with ETL using Informatica.
Expert in leading both development and support projects using Oracle and PL/SQL.
Worked on both OLTP (5+ years) and data warehousing projects (6+ years).
Worked on Data Modeling in various projects.
Worked on performance tuning the database by using xplans, gather stats etc. to tune long running queries in database (7+ years).
Worked on partition exchange to update billions of rows of data.
Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re - Write.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Expertise in Dynamic SQL, Collections and Exception handling.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Creating UTPL SQL for unit testing the code and to follow test driven development approach (2 years).
Set and continually manage project expectations with team members and other stakeholders.
Strong documentation and project adherence to industry quality standards and reporting skills.
Excellent interpersonal, collaboration, and problem solving skills.
Strong understanding of SDLC.

TECHNICAL SKILLS:

Database: Oracle 10g, 11g, 12c (12 years)

ETL Tool: Informatica (7 years)

MDM: Master Data Management using Informatica (1 year)

Languages: SQL, PL/SQL (12 years)

Unit Test tool: UTPLSQL (1 year)

Version control tools: GIT Stash, SVN, Clear Case etc.

Autosys and Control-M tools: for job scheduling (6 years)

Build & Release tool: Jenkins and HUDSON

WORKING EXPERIENCE:

Confidential, Jersey City, New Jersey

Database consultant

Responsibilities:

Interacting with product owners/SMEs to understand requirements.
Create technical and analysis documents for the requirements.
Coding for the requirements which require deep understanding of oracle, pl/sql.
Unit testing of the code using UT PLSQL.
Build and install process using Stash and Jenkins.
Working on the CI-CD approach and helping team members to learn and implement the same.

S/w: Oracle, Pl/Sql, Control-M, UNIX, JIRA, Stash, Jenkins, UT PLSQL

DW Tool: Informatica

Confidential

Senior Associate

Responsibilities:

Interacting with client to gather requirements.
Coding the framework and working on complex tickets which require deep understanding of oracle, PL/SQL.
Mentoring team members.
Finding gaps if any on the technical or business side among team members and arranging trainings by discussing with my supervisor and learning and development division.

Confidential, NC

Software Engineer

S/w: Oracle, Pl/Sql, Autosys, UNIX, JIRA, Stash, UT PLSQL

DW Tool: Informatica (MDM)

Confidential, MA

Software Engineer

S/w: Oracle, Pl/Sql UNIX

DW Tool: Informatica

Confidential

Software Engineer

S/w: Oracle 10g, UNIX

DW Tool: Informatica

Confidential

Senior System Analyst

Confidential

Software Engineer

S/w: Oracle 11g, SQL Server 2000

Tool: SwisSql

Confidential, MT

Software Engineer

S/w: Oracle 10g Application Server, Pl/Sql, Web Tool Kit.

Confidential

Software Engineer

Confidential

Software Engineer

S/w: Oracle 9i, Oracle Pl/Sql, UNIX (Basic commands and debugging shell scripts

Confidential

Software Engineer

Confidential

Software Engineer

S/w: Oracle 9i, Forms/ Reports 6i.

We provide IT Staff Augmentation Services!

Database Consultant Resume

Jersey City New, JerseY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship