
Bhavuk Aggarwal
Verified Expert in Engineering
Database Developer
Patiala, Punjab, India
Toptal member since March 29, 2022
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
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
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
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.
Systems Engineer II
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.
Senior Software Engineer
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.
Experience
Doorcounts
https://www.doorcounts.com/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
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
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
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
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
Bachelor's Degree in Information Technology
Rayat and Bahra Institute of Engineering and Bio Technology - Mohali, Punjab, India
Certifications
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring