Senior Oracle Database Consultant Resume NJ - Hire IT People

PROFESSIONAL PROFILE:

Over 10+ years of experience working on different projects as Lead Database Engineer/Data Analytics Consultant/Data Architect.
More than 5+ years of working experience on Agile/Scrum Team. Certified SAFe 4.0 Practitioner (SP).
More than 10+ s on Database, Big data, Hadoop, Spark, Python, Data Science, Machine Learning and Visualization technologies combined (attached to LinkedIn profile).
Extensively worked on Database designing, Data mining, Data Analysis, Data Visualization, Database Driven Operations. Designed and developed analytical methods and tools.
Demonstrated ability to work both in independent and team - oriented environments with well-developed organizational skills and excellent interpersonal and communication skills, self-starter and a quick learner.
Responsible for designing and implementing processes and complex analysis engine for large-scale data set.
Delivered data driven insights to various stakeholders to help drive better business decisions.
Brought data to life through effective visualization and presentation, reporting/dashboarding.
Have written complex analytical engines using different programming languages.
Coordinated with cross-functional teams to devise, build and implement or integrate solutions that advance technology roadmaps and organizational strategies.
Designed database standards, performance tuning, SQL optimization, Logical and Physical Schema Design.
Have good experience in Normalization and De-normalization for databases in OLTP and OLAP environment, Big Data, Hadoop and AWS cloud services.
Strong experience working with offshore and geographically distributed teams.

COMPUTER SKILLS:

Big Data: Hadoop, HDFS, Yarn, MapReduce, HBase, Spark, Pig, Hive, Oozie, Flume, Sqoop, HUe.

RDBMS: Oracle 12c/11g/10g/9i, Teradata 13, Sybase, SQL Server 2008/2010/2012 , SQLite, MySQL

Languages: SQL, Python, PL/SQL programming, SQR, Unix shell Script (sh, bash, sed, awk), HTML, XML, SAS, JavaScript, Core Java, R.

Packages/tools: TOAD, SQL developer, ER/Studio Data Architect, ERwin, Oracle Data Miner, eclipse Toad for Data Analyst, PuTTy, JetBrains PyCharm, Crystal Reports, SQL*plus, Oracle Forms 10g, Tableau 6.0, SAS EG 4.2/4.3, TFS, R Studio, Rally, Tableau 10.0/10.2

Cloud: AWS, EC2, S3, AWS - RDS, EMR, Redshift

WORK EXPERIENCE:

Confidential, NJ

Senior Oracle Database Consultant

Responsibilities:

As a part of scrum team worked in Agile/Scaled Agile environment, worked extensively with different teams and performed duties of Data Analytics consultant/Lead Database Engineer/Architect on different projects.
As a part of CDL-DDO team built common data layer for many different midstream applications using Hadoop ecosystem and AWS cloud services.
Worked with team to have same data truth for whole organization, built dashboards and applications for different midstream operations.
Delivered data driven insights using reporting and dashboarding to various stakeholders to help drive better business decisions.
Developed complex analysis engines, pressure calculations formulas using different programing languages.
Did code automation which saved lots of man hours.
Phillips66 has 900 million data points for pipeline attributes, internal and external metal loss, dents, cracks etc.
My job was to design analytical engine, which can predict anomalies and their criticality based on different factors to avoid risk of leak or failure.
We have used linear regression model to check confidence level in vendor stated anomalies vs actual found anomalies.
As a part of PT-DMS team designed Logical and Physical data models for OLTP as well as OLAP systems using ER Visual Studio Data Architect tool. Did database Normalization and De-normalization as per the environment needs.
Designed system using Oracle database technologies which can be integrated with big data technologies like SAP HANA and Hadoop.
Designed Universal Loader application to load millions of rows from vendor tool run data using ETL process and integrated large-scale data. Built complex data validation system for vendor data with simple programming design which will validate the data before loading into system.
Created database standards for project and did code review, built data dictionary for support team.
Did SQL code tuning, Query Optimization, database performance tuning. Built database tables, integrity constraints, indexes, table partitioning, PL-SQL packages, store procedures and functions.

We provide IT Staff Augmentation Services!

Senior Oracle Database Consultant Resume

NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship