Bhavuk Aggarwal, Developer in Patiala, Punjab, India
Bhavuk is available for hire
Hire Bhavuk

Bhavuk Aggarwal

Verified Expert  in Engineering

Database Developer

Patiala, Punjab, India

Toptal member since March 29, 2022

Bio

Bhavuk is a passionate developer with extensive experience in database management and delivering full-stack web applications. He specializes in SQL, PL/SQL, Oracle APEX, and Git. Bhavuk is a quality lover passionate about providing the best feasible solutions and always getting the job done. He worked with MNCs and multicultural teams around the globe integrating AWS S3 with Oracle and using Jenkins pipelines for CI/CD.

Portfolio

Oracle
GitLab, Oracle PL/SQL, Oracle Application Express (APEX), Oracle BI Publisher...
Siemens
Oracle PL/SQL, Oracle Application Express (APEX), Agile, Windows PowerShell...
Abacasys Corporation 2395
Oracle, Oracle Application Express (APEX), PL/SQL, Amazon S3 (AWS S3)...

Experience

  • SQL - 7 years
  • PL/SQL - 7 years
  • Oracle - 7 years
  • Back-end Development - 7 years
  • Oracle Application Express (APEX) - 7 years
  • RDBMS - 7 years
  • Agile - 5 years
  • Git - 4 years

Availability

Full-time

Preferred Environment

Oracle, Agile

The most amazing...

...project I've designed and developed is a database model capable of processing more than 300,000 records in a day.

Work Experience

Analyst Programmer III

2019 - PRESENT
Oracle
  • Created a due diligence application that allows users to generate reports utilizing Oracle BI Publisher and APEX.
  • Upgraded Oracle APEX to higher versions multiple times.
  • Created CI/CD pipelines using Jenkins and GitLab.
  • Implemented Oracle text search, also known as Oracle text indexing, to extract data from documents and reports on top of this extracted information.
  • Implemented Oracle parallel architecture to improve application performance.
  • Created background jobs using DBMS Scheduler for monitoring, automation, and process optimizations.
  • Recognized with the Best Employee of the Quarter award.
Technologies: GitLab, Oracle PL/SQL, Oracle Application Express (APEX), Oracle BI Publisher, Jenkins, HTML, CSS, JavaScript, Back-end Development, Database Design, Databases, Relational Databases, Performance Tuning, SQL Performance, Query Optimization, Database Development, Data Extraction, CSV, CSV Export

Systems Engineer II

2017 - 2019
Siemens
  • Developed a web-based application that allows site engineers to generate PDFs required for customers. This application was built with APEX and Latex.
  • Fixed database and application performance issues by creating indexes and materialized views, reviewing execution plans, and running stats gathering jobs.
  • Got the opportunity to train interns with Oracle PL/SQL and Oracle APEX.
Technologies: Oracle PL/SQL, Oracle Application Express (APEX), Agile, Windows PowerShell, LaTeX, Jira, SQL Stored Procedures, Database Development, CSV

Senior Software Engineer

2015 - 2017
Abacasys Corporation 2395
  • Worked on Oracle database, SQL, PL/SQL, and APEX as the senior software engineer.
  • Developed a web application for a retail organization. This project was built with an Oracle back end and an APEX front end. I also created charts to visually display daily, monthly, and yearly sales information.
  • Migrated ERP that was built with Oracle forms and reports to Oracle APEX. Added dashboards that would show different kinds of stats in the form of charts and reports.
  • Implemented a workflow using Oracle APEX in a public-facing web application that would allow immigrants to submit requests for work permits.
  • Integrated Amazon S3 services with Oracle database.
  • Implemented file handling using UTL_FILE API to store binary data over the servers.
  • Recognized with the Best Employee of the Year award.
Technologies: Oracle, Oracle Application Express (APEX), PL/SQL, Amazon S3 (AWS S3), Subversion (SVN), Data Modeling, Database Design, Database Development, CSV

Experience

Doorcounts

https://www.doorcounts.com/
Doorcounts is a web-based application that allows retailers to connect with their customers by analyzing their foot traffic and getting real-time sales results.

I worked as a full-stack developer on this project. This project was built with an Oracle back end and an APEX front end. I created forms, interactive reports, and charts to visually display information about daily, monthly, and yearly sales on the dashboards.

Tasks completed
• Integrated Amazon S3 services with Oracle database to send and store binary data over the cloud.
• Built dashboards that would show different kinds of stats in the form of charts and reports.
• Implemented file handling using UTL_FILE API to store binary data over the servers.
• Worked on performance tuning activities to resolve performance issues and implemented the best possible architectures.

Electronic Checklist

This is a web-based application that allows site engineers to store possible faults found during the inspection of the machinery, like turbines deployed at different sites. Further, allowing engineers to generate separate PDFs providing solutions to the customers.

Tasks Completed:
• Generated PDFs using BI Publisher.
• Made it possible to send encrypted emails directly from the database by integrating PowerShell and LDAP with the database.
• Created application pages and reports.

Responsibility Matrix

This is a web-based application where different kinds of responsibilities can be created and assigned to other users.

These responsibilities can be recursive or ad-hoc in nature. Once these responsibilities are logged, they are further shown on the calendar as daily, weekly, or monthly activities in the form of tasks.

Work Permit Application

Work Permit Application is a web-based application used by the government of a specific country to manage immigration-related applications received from people outside the country.

The workflow was implemented in the application that allows employees working in the work permit and labor clearance department to approve or reject these work permit applications.

Project Database

Project Database is a web-based application that is used to manage projects.

Users can log projects and ideas. Projects can be delivered by completing all of their milestones. Further, users can save documents, links, and issues and log and manage tasks on the Kanban board.

Education

2011 - 2015

Bachelor's Degree in Information Technology

Rayat and Bahra Institute of Engineering and Bio Technology - Mohali, Punjab, India

Certifications

JUNE 2022 - PRESENT

Oracle Certified Associate

Oracle University

Skills

Tools

Oracle Application Express (APEX), Subversion (SVN), Git, GitLab, Bitbucket, Jenkins, Jira, LaTeX, Oracle BI Publisher

Languages

SQL, HTML, Java, CSS, JavaScript

Paradigms

Database Design, Database Development, Agile

Platforms

Oracle

Storage

PL/SQL, RDBMS, Oracle PL/SQL, Databases, Relational Databases, SQL Stored Procedures, Amazon S3 (AWS S3), SQL Performance

Frameworks

Windows PowerShell

Other

Back-end Development, Data Modeling, Performance Tuning, Query Optimization, Data Extraction, CSV, CSV Export, Computer Science, Oracle REST Data Services (ORDS), LDAP

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring