Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Divya Joshi

Bengaluru

Summary

Dynamic PL/SQL Developer with over four years of experience, excelling in database optimization and performance tuning. Proven track record in translating complex business requirements into effective solutions, enhancing operational efficiency. Strong communicator and collaborator, adept at leading cross-functional teams to deliver impactful results and improve data processing capabilities.

Overview

5
5
years of professional experience
1
1
Certification

Work History

PL/SQL DEVELOPER

PSI METALS INDIA
Bengaluru
04.2023 - Current
  • Results-driven PL/SQL Developer with over four years of hands-on experience in designing, developing, and optimizing database solutions using Oracle PL/SQL.
  • Proficient in writing complex queries, stored procedures, triggers, packages, and performance tuning to support business-critical applications.
  • Strong background in working with cross-functional teams in Agile environments to deliver scalable, high-performing database solutions.
  • Developed and deployed around 50 interfaces, integrating PSI MES and APS applications with L2 and SAP systems to streamline data exchange and enhance operational efficiency.
  • Designed and developed 40+ custom PL/SQL packages, translating complex business requirements into scalable technical solutions that improved data processing and reporting capabilities.
  • Led the collection and analysis of over 50 business requirements from cross-functional stakeholders, translating them into detailed technical specifications that enabled the successful design and implementation of the current project.
  • Authored a comprehensive knowledge base of 10+ self-learning documents, accelerating new team member onboarding, and reducing training time by an estimated 30%.
  • Led and delivered 15+ training sessions for internal and external stakeholders, empowering users with a deep understanding of application modules, and increasing user adoption by 25%.
  • Optimized system reliability by resolving 80+ production issues, documenting root cause analysis, and implementing preventive measures that reduced recurring incidents by 30%.
  • Implemented automated reporting mechanisms that generate and distribute over 10 daily and over 15 monthly reports, saving manual efforts.

Trainee Analyst

PPD, THERMOFISHER SCIENTIFIC
Bengaluru
01.2021 - 04.2023
  • Performed exploratory data analysis (EDA), data cleaning, transformation, and extraction on datasets exceeding 1 million records, improving data quality and consistency by 30% prior to database integration.
  • Utilized complex SQL queries to extract, manipulate, and prepare data from relational databases, supporting over 20 reports and dashboards used for trend analysis, business decision-making, and downstream processing.

Education

BE - COMPUTER SCIENCE

Rao Bahadur Y Mahabaleshwarappa Engineering College
Ballari
08-2020

Skills

  • PL/SQL
  • SQL
  • Python - NumPy, Pandas
  • JIRA
  • Git, TortoiseSVN
  • SQL developer, Toad
  • Unit testing
  • Web services
  • IT integration
  • ETL process development
  • SQL query optimization
  • Performance tuning
  • Database optimization
  • Data integration
  • Communication
  • Team collaboration
  • Problem solving
  • Business requirements
  • Project management
  • Agile methodologies

Certification

  • Microsoft Azure Data Fundamentals DP-900
  • Upgrad Certified Data Analyst

Languages

English
First Language
Hindi
Upper Intermediate (B2)
B2

Timeline

PL/SQL DEVELOPER

PSI METALS INDIA
04.2023 - Current

Trainee Analyst

PPD, THERMOFISHER SCIENTIFIC
01.2021 - 04.2023

BE - COMPUTER SCIENCE

Rao Bahadur Y Mahabaleshwarappa Engineering College
Divya Joshi