Oracle SQL/PLSQL Data Engineer

NISHKARSH SHARMA

DATA ENGINEER / DEVELOPER

Pleasanton, CA *********.******@*****.*** +1-201-***-****

PROFESSIONAL SUMMARY

Data Engineer/Developer consultant with 19+ years of experience supporting Oracle-based analytics, reporting, data warehousing, ETL/ELT, and database development platforms across Oracle, federal, finance, healthcare, and consulting environments. Strong hands-on background in Oracle SQL, PL/SQL, data modeling, tuning, production troubleshooting, and stakeholder-facing delivery.

Experts in platforms requiring Oracle SQL/PLSQL, Informatica ETL support exposure, dimensional schema modeling, Python, Trino/Presto, large data lake querying, Kafka/Autosys-adjacent orchestration, and upstream/downstream dependency analysis. Building AI ready pipeline at scale.

KEY ACHIEVEMENTS

Oracle SQL/PLSQL Engineering

Built packages, procedures, validation checks, reconciliation logic, and reporting queries for enterprise analytics.

ETL and Warehouse Delivery

Integrated 120+ source databases into EDW models and delivered 80+ reports for 2,000+ daily users.

3NF and STAR Schema Modeling

Designed normalized source models, dimensional marts, semantic layers, and source-to-target mappings.

Reduced Runtime From Hours to Seconds

Reduced selected report/query cycles from 1-2 hours to under 30 seconds.

Reduced Reporting Errors by 92%

Implemented SQL/PLSQL validation, anomaly checks, and reconciliation controls.

Production Support Ready

Mapped dependencies, triaged defects, supported releases, and worked with business and technology teams.

WORK EXPERIENCE

Principal Member of Technical Staff - Data Platform & Analytics Engineering Aug 2020 - Present

Oracle Corp Pleasanton, CA

Develop and support Oracle-based analytics and reporting capabilities for enterprise data integration and operational decision-making.

Build and tune Oracle SQL/PLSQL logic, including complex queries, views, PL/SQL packages, stored procedures, validation rules, and reconciliation checks.

Support ETL/ELT production operations across source-to-target mappings, data quality rules, pipeline defects, and release readiness.

Design and support 3NF source models, STAR schema marts, dimensional models, semantic layers, and governed reporting datasets.

Improve critical Oracle analytics workloads, reducing selected report runtimes from 1-2 hours to under 30 seconds.

Analyze upstream/downstream dependencies across source systems, curated models, dashboards, reports, and operational workflows.

Query and validate large datasets using SQL, PL/SQL, Python, PySpark, Trino/Presto-style distributed query patterns, and Kafka/event ingestion concepts.

Support production delivery with Jenkins, Airflow/Autosys-style scheduling, QA validation, defect triage, release readiness, and stakeholder updates.

Analytics Team Lead (Enterprise BI & Reporting) Dec 2014 - Aug 2020

USDA - Harmonia / ASRC Federal Kansas City, MO

Led a 6-member BI/data team delivering EDW, ETL, reporting, and dashboard capabilities for federal analytics.

Integrated 120+ source databases into governed models and delivered 80+ reports for 2,000+ daily users.

Designed 3NF and STAR-schema data models, dimensional marts, semantic layers, and source-to-target rules.

Modernized legacy Windows reports into web analytics, improving supportability, governance, and reliability.

Coordinated requirements, ETL design, data modeling, report development, tuning, QA, release, and support.

Mapped upstream/downstream data dependencies and moved recurring analysis to governed same-day dashboard review.

Resolved performance bottlenecks for high-volume reporting, large extracts, and 5M+ row data workloads.

Associate Manager (BI & Data Systems) Nov 2012 - Dec 2014

Accenture Atlanta, GA

Improved sales commission reporting and saved approximately $200K annually by reducing manual reconciliation.

Built Oracle SQL/PLSQL validation and anomaly checks, reducing reporting errors by 92%.

Led 300+ table SQL Server-to-Oracle migration, removing duplicate data and saving approximately 500GB of storage.

Managed a 5-member offshore team across 3 client projects with weekly stakeholder reporting and production support.

Earlier Roles-

Lead BI Consultant - HCL Technologies - May 2010 - Nov 2012

Senior Software Consultant - M-Tech / Satyam - Oct 2008 - May 2010

Software Engineer - 3i Infotech - Nov 2006 - Oct 2008

Software Engineer - ESS - Aug 2005 - Oct 2006

CORE COMPETENCIES

Oracle SQL/PLSQL

Oracle Database, SQL Developer, TOAD, complex SQL, PL/SQL packages, stored procedures, query tuning, explain plans

Informatica & ETL

ETL/ELT development, Informatica support exposure, source-to-target mapping, workflow monitoring, restart/recovery

Data Warehousing

3NF models, STAR schema, dimensional modeling, data marts, semantic layers, source dependency mapping

Data Lake & Python

Python, PySpark, Spark SQL, Trino/Presto, large data lake querying, partition-aware validation

Production Support

Autosys-style scheduling, Kafka/event ingestion concepts, Jenkins/Airflow, QA, defect triage, stakeholder communication

CERTIFICATION

Google Certified Professional Data Engineer

Oracle Certified Data Engineer

MIT Applied Data Science / AI Program

EDUCATION

Master of Computer Application Bachelor of Science

RGPV, BHOPAL, INDIA JIWAJI UNIVERSITY, GWALIOR, INDIA

From year - 2002-2005 From year - 1998 - 2001

Contact this candidate