Summary
Overview
Work History
Education
Skills
Certification
Industry Experience
Timeline
Generic

DINESH BHATT

Monmouth Junction,NJ

Summary

Results-driven and highly skilled Data Architect with over 15 years of experience designing and implementing robust data solutions. Proven expertise in translating business requirements into scalable and efficient database structures, data models, and architecture. Adept at leveraging cutting-edge technologies to optimize data storage, processing, and retrieval.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Senior Specialist/Data Architect-Data Engineering

LTI
04.2014 - Current
  • Architecting Data Lake and Data Lake house solutions using Delta Lake on Oracle Cloud Infrastructure.
  • Building Data Model for Business users to expose sales data using Self Service Data platform.
  • Building Data Mesh solution to support data governance, data-as-product, self-serve data and data decentralization.
  • Building cost optimized, secured, distributed, scalable Data Lake solutions on Oracle Cloud Infrastructure.
  • Leveraging Delta Sharing and OCI Cloud links to share data securely with different systems.
  • Migrating existing ETL processes from Oracle PL/SQL to Oracle data flow(Spark based processing engine) for in-memory distributed data processing.
  • Processing high volume data on Oracle database using optimized queries and parallel processing.
  • Preparing analytical data for business and pushing it across different cloud storage services.
  • Implementing REST API based services using Oracle Rest data Services for secured and faster data sharing.
  • Developing OAuth2.0 authentication mechanism for REST API using Oracle Rest data services.
  • Streamline exiting streams and jobs to achieve higher performance. Achieved 80% reduction on run time.
  • Developing CI/CD pipeline to automate complete Database DevOps process using Red-gate, Git and Jenkins.
  • Developed Report Scheduler to automatically send approximately 1500 monthly reports to business users using Oracle Job Scheduler.
  • Developing Database migration strategy from On-Prem to Cloud and Migrating Database to higher database versions.
  • Performance Tuning existing database queries. Raising SR with Vendors for any Bugs/Issues found with software tools.
  • Responsible for creating Kanban dashboard for Jira tracking and documenting project using Confluence.
  • Developing proof of concepts for hierarchical data analytics using Oracle analytics Views
  • Developing proof of concepts for Oracle Analytics Cloud (OAC) to provide business analytics solution
  • Developing proof of concept for Oracle managed Autonomous Data warehouse (ADW) service for self-deploying, self-healing, self-securing data warehouse
  • Training and mentoring other team members.

Senior Software Engineer

WIPRO
02.2011 - 04.2014
  • Involved in core development of system which extracts data from OLAP cubes and show data to end user/business
  • Experience in OLAP Cubes, Dimension designing and loading data into cubes or dimensions
  • Involved in user interface implementation of system where in reports will be extracted from OLAP cubes based on user requests and reports will be generated
  • Automated OLAP reports to pull data from cubes and send reports to business
  • Programmed stored procedures, views, queries for reporting purpose
  • Preparing dimension or cube data which will be loaded into OLAP cubes
  • Involved in migrating Oracle Database from 11g Exadata for data warehouse applications including OLAP database.

Senior Application Developer

BNY Mellon - (Formally iNautix Technologies India Pvt. Ltd)
05.2010 - 02.2011
  • Responsible for creating Technical Specification and delivering it to customer for new Requirement and sharing same with Front-End team
  • Responsible for creating design document before code implementation
  • Coding new Requirements & Code Review
  • Responsible for ensuring that technical solution meets performance, reliability, and other requirements
  • Responsible for Migrating Oracle PL/SQL procedures with Middleware and further migrating Middleware application with Front End
  • Responsible for post implementation defect fix to ensure that developed system goes live without any defects
  • Responsible for implementing new loading jobs to receive files from Mainframe system and load same into Oracle application.

Programmer Analyst

Cognizant Technology Solutions
06.2007 - 05.2010
  • Creating Technical Specification and delivering it to customer for new Requirement and creating design document before code implementation
  • Coding new Requirements & Code Review
  • Experience of implementing QUEST Architecture for Oracle based application
  • Responsible for performing Unit level testing, Assembly Level Testing and System Level Testing
  • Debugging existing system to identify root cause for existing system issues and troubleshooting complex technical issues on project
  • Experienced working with Oracle PL/SQL, Oracle Forms, MF-COBOL, UNIX and Mainframe systems.

Education

Master of Computer Applications -

VIT University
India
05.2007

Skills

    • Oracle PL/SQL, SQL, Oracle 19c
    • OCI (Oracle Cloud Infrastructure)
    • OCI Data Flow(Apache Spark), SQL Endpoint, OCI Data Lake, OCI Data Integration Service, OCI Events, OCI Notifications
    • Oracle REST data Services, Python Flask
      • AWS S3, Redshift
      • Delta, Iceberg, Hudi, Parquet, JSON
      • Jira, Confluence
      • Git, Jenkins

Certification

  • Oracle Certified Architect Associate-2021
  • Oracle Certified AI/ML Specialist-2021
  • Oracle Certified Foundation Associate-2021
  • Microsoft Certified AI Fundamental-2021

Industry Experience

  • Media and Entertainment
  • Insurance

Timeline

Senior Specialist/Data Architect-Data Engineering

LTI
04.2014 - Current

Senior Software Engineer

WIPRO
02.2011 - 04.2014

Senior Application Developer

BNY Mellon - (Formally iNautix Technologies India Pvt. Ltd)
05.2010 - 02.2011

Programmer Analyst

Cognizant Technology Solutions
06.2007 - 05.2010

Master of Computer Applications -

VIT University

Similar Profiles

CREATE PROFILE
DINESH BHATT