
Pavan Badi
Verified Expert in Engineering
SQL Developer
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
Experience
- Oracle - 10 years
- SQL - 10 years
- PL/SQL - 9 years
- Oracle PL/SQL - 9 years
- Oracle Application Express (APEX) - 9 years
- HTML - 9 years
- PostgreSQL - 5 years
- JavaScript - 5 years
Availability
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
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.
Oracle PL/SQL and APEX Developer
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.
Oracle PL/SQL and APEX Developer
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.
Oracle PL/SQL and APEX Developer
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.
Experience
BCR Management System
Smart Dashboard
Business Management System
PUMA RFQ
Estate Management
Education
Bachelor's Degree in Information Technology
Shivaji University - Jaysingpur, India
Skills
Libraries/APIs
Complex SQL Queries, REST APIs
Tools
Oracle Application Express (APEX), Oracle SQL Data Modeler, Oracle BI Publisher, Git, Toad, Microsoft Excel, Microsoft Power BI
Languages
SQL, Apex, JavaScript, HTML, CSS, HTM, CSS4, Go
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
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