Pavan Badi, Developer in Doha, Qatar
Pavan is available for hire
Hire Pavan

Pavan Badi

Verified Expert  in Engineering

SQL Developer

Location
Doha, Qatar
Toptal Member Since
September 20, 2022

Pavan is a software engineer and developer with 9+ years of experience in different phases of the software development lifecycle. As an Oracle PL/SQL and APEX developer, he created, upgraded, and supported various applications, reports, and visualizations while working independently and within a team across retail, logistics, service, and finance domains. Pavan is an active member of the Oracle community who enjoys helping others solve their issues and queries.

Portfolio

Ministry of Interior
SQL, Oracle, Oracle PL/SQL, PostgreSQL, Oracle Application Express (APEX)...
Kahramaa
SQL, Oracle PL/SQL, Oracle Application Express (APEX), JavaScript...
Tata Consultancy Services
SQL, Oracle, Oracle PL/SQL, Oracle Application Express (APEX), JavaScript...

Experience

Availability

Full-time

Preferred Environment

Windows, Ubuntu, Linux, Batch Scripting

The most amazing...

...thing I've developed is a web application to release building substation contracts, approve workflow, and manage progress.

Work Experience

Senior Software Engineer

2020 - PRESENT
Ministry of Interior
  • Developed a centralized authorization system for all applications.
  • Contributed to a web-based CRM solution, allowing CR creation, approval, and price discovery. It enabled users to log in and select the desired BCR type, such as BCR or DCN.
  • Developed applications to keep detailed information about the patrol members and their activities.
Technologies: SQL, Oracle, Oracle PL/SQL, PostgreSQL, Oracle Application Express (APEX), Ubuntu, HTML, CSS, Git, Git GUI, Oracle SQL Developer, Oracle SQL Data Modeler, Entity-relationship Diagrams, HTM, CSS4, Database Modeling, Data Modeling, Data Architecture, Relational Database Design, Relational Databases, Database Architecture, Query Optimization, Query Composition, Performance Tuning, Go, Back-end, Oracle Cloud, REST APIs, Data Analytics, Data Analysis, Data Engineering, PL/SQL, Linux, Oracle Database

Oracle PL/SQL and APEX Developer

2016 - 2020
Kahramaa
  • Designed a central CRM dashboard for reports on the move-in or out, ownership transfer, and meter complaints, reducing the time for preparation from several days to a few minutes.
  • Developed a web application used for releasing building substation contracts, approving workflow, awarding tenders, and managing progress.
  • Created a dashboard to display monthly electricity and water consumption, bills, connections, and other details.
  • Developed a notification system that showed the data available in the database, split it out as multiple PDFs with the help of BI Publisher, and emailed it to designated authorities.
  • Built a centralized dynamic list of application values to avoid redundant data used in multiple applications.
  • Developed back-end logic using React Native for Android and Oracle APEX for web-based applications used by the meter reading team to note meter readings and generate monthly billing for customers.
Technologies: SQL, Oracle PL/SQL, Oracle Application Express (APEX), JavaScript, Oracle BI Publisher, PL/SQL, Apex, Git, Git GUI, Oracle SQL Developer, Oracle SQL Data Modeler, Entity-relationship Diagrams, HTM, CSS4, Toad, Database Modeling, Data Modeling, Data Architecture, Relational Database Design, Relational Databases, Database Architecture, Query Optimization, Query Composition, Performance Tuning, PostgreSQL, Data Analytics, Data Analysis, Data Engineering, Microsoft Excel, Oracle Database

Oracle PL/SQL and APEX Developer

2015 - 2016
Tata Consultancy Services
  • Built a system for a web-based order management solution, allowing order creation, approval, price discovery, and filing and enabling users to log in and select a product type, such as fuel oil or gas.
  • Enabled various activities in the system, including pulling emails from the shared mailbox, distributing the invoices to global operations for approval, coding, approving invoices, and creating accounting booking entries.
  • Created an application that allowed users to manage parking ticketing.
  • Developed applications for Trafigura, one of the world's biggest trading organizations.
Technologies: SQL, Oracle, Oracle PL/SQL, Oracle Application Express (APEX), JavaScript, PL/SQL, Apex, Oracle SQL Developer, Entity-relationship Diagrams, HTM, CSS4, Toad, Database Modeling, Data Modeling, Data Architecture, Relational Database Design, Relational Databases, Database Architecture, Query Optimization, Query Composition, Performance Tuning, Data Analytics, Data Analysis, Microsoft Excel, Oracle Database

Oracle PL/SQL and APEX Developer

2014 - 2015
Agile IDC
  • Contributed to Avnet's Unity Estate Management software engine to allow companies to update their understanding of IT estate cost-effectively.
  • Tracked bugs with Bugzilla and performed versioning using SVN.
  • Reduced the response time by tuning SQL queries that took a long time to process a request using Oracle explain plan and hints.
Technologies: SQL, Oracle PL/SQL, Oracle Application Express (APEX), JavaScript, HTML, CSS, Oracle SQL Developer, Entity-relationship Diagrams, HTM, CSS4, Database Modeling, Data Modeling, Relational Database Design, Relational Databases, Database Architecture, Query Optimization, Query Composition, Performance Tuning, Data Analytics, Data Analysis, PL/SQL, Oracle Database

BCR Management System

A tender announcement system that Kahramaa uses if it wants a substation. Vendors can also use it to apply for tenders after the authorities have issued technical and commercial approvals. The system is also used to award one of the tenders and maintain progress.

Smart Dashboard

A smart dashboard is a one-stop solution for any finance and HR-related reporting and visualization of KPIs. It consists of reports such as performance appraisal, hiring targets, and employee information. This application also facilitates an email notification system that notifies designated parties of events.

Business Management System

The business management system (BMS) is a product developed with Oracle APEX for all businesses to manage day-to-day business activities. It consists of an easy point of sales system installed at every branch of the business unit and features that are centrally connected with the Oracle APEX technology stack.

PUMA RFQ

The system is a web-based order management solution, allowing order creation, approval, price discovery, and filing. Users can log in and select the product types they will be working with, such as fuel oil or gas oil. They can also choose multiple products or change the selection during the day. These product types act as filters when presenting an order list or creating an order. The orders in the list depend not only on product type but also on the order type, status, and user role. These rules are defined in the available actions table, and all use cases subject to these rules refer to them. The available actions table is one of the key containers of the business rules defined for this system.

Estate Management

Avnet's Unity Estate Management software engine allows companies to update their understanding of IT estate cost-effectively. Unity is a software suite that improves processes, reduces or avoids costs, sells additional services, and resells a product to customers to help them understand and manage their IT estates. It can handle a multi-vendor estate, spanning numerous products from multiple vendors and across many locations and currencies. Unity creates a single master database and a single view of purchasing, deployment, and compliance. The output is valuable information that helps in making recommendations and business decisions.

Languages

SQL, Apex, JavaScript, HTML, CSS, HTM, CSS4, Go

Tools

Oracle Application Express (APEX), Oracle SQL Data Modeler, Oracle BI Publisher, Git, Toad, Microsoft Excel

Paradigms

Entity-relationship Diagrams

Platforms

Windows, Oracle, Oracle Database, Ubuntu, Linux

Storage

PL/SQL, Oracle PL/SQL, Oracle SQL Developer, Database Modeling, Relational Databases, PostgreSQL, Database Architecture, Oracle Cloud

Other

Data Modeling, Relational Database Design, Query Optimization, Query Composition, Data Analytics, Data Analysis, Git GUI, Data Architecture, Performance Tuning, Data Engineering, Batch Scripting, Back-end

Libraries/APIs

REST APIs

2007 - 2012

Bachelor's Degree in Information Technology

Shivaji University - Jaysingpur, India

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