Divya Raghupathy
Summary
Experienced PL/SQL Developer with a strong background in Oracle database development, specializing in writing efficient and scalable PL/SQL code. Experienced in developing and optimizing stored procedures, triggers, functions, and packages to streamline data processing and improve system performance. Proficient in query optimization, performance tuning, and debugging to ensure high database efficiency. Adept at collaborating with teams to design and implement robust database solutions that align with business requirements.
Overview
5
5
years of professional experience
1
1
Certification
Work History
PL/SQL Developer
Pfizer F&BO ad Managed markets
10.2019 - 01.2021
- Developed and maintained PL/SQL Packages, Procedures, Functions, and Views for enterprise data processing
- Optimized SQL queries using joins, CTEs and windows function using TOAD for Oracle to extract deployment and access reports
- Worked on Unix shell scripting for bug fixing and automation of ETL function
- Developed stored procedures, functions and packages using PLSQL to support the application development needs.
- Optimize queries to improve performance and reduce processing time
- Provided deployment support using Serena Dimensions and maintained Unix servers via Putty
- · Worked closely with clients on Jira requests and involved in functional testing , code walkthrough and verify the results by implementing UC4 jobs Was responsible for preparing TD, FD, Test scripts and moving code changes to production on estimated time and resolving the RFC.
System Analyst
CIGNA
01.2022 - Current
- Played a vital role in Healthcare Payer Operations involving all phases of development & support
- Worked extensively on development of SAS codes for report generation using a tool - SAS Enterprise Guide, Teradata, Toad for Oracle
- Hands on experience on customization of code to generate the reports as per the requested layout
- Developed ProcSQL code for extracting data for analysis, generating reports and identifying patterns
- Utilized SQL to write SQL queries to join multiple tables, perform calculations and apply filters to extract relevant data for analysis
- Performed query analysis and back tracking of legacy and CCW table using crosswalk and mapping document
- Handled Development & Production Support for enterprise reporting
- Handled Ad-hoc requests on various data systems
- Responsible for setting up and managing the linux servers, including configuration and maintenance, ensuring availability and performance of servers by monitoring system logs, optimizing resource usage, and regularly applied patches and updates to ensure system stability
- Developed a python script to automatically extract data from multiple sources, perform data cleansing and import it to the database, saving significant manual effort and time
- Utilized python libraries like pandas and Numpy for data analysis and manipulation
- Involved in development of driver code for the automation of TC reports through inventory approach
- Hands-on experience in Oracle PL/SQL development – writing, optimizing, and debugging stored procedures, triggers, and packages
- Expertise in database object creation – tables, indexes, sequences, synonyms, and DB links
- Strong understanding of ETL concepts, data modeling, and query optimization techniques
- Worked on database performance tuning, query optimization, and indexing strategies
- Involved in root cause analysis (RCA), defect fixing, and functional testing
- Experience in version control and CI/CD pipeline integration using Jenkins
Education
Bachelor of technology - IT
Valliammai Engineering College
01.2019
Skills
Database Technologies:Oracle PL/SQL, MySQL, Oracle forms and reports
Programming Languages: SQL, PL/SQL, Unix Shell Scripting, python
Reporting & BI Tools:Tableau, Power BI, SAS Enterprise Guide
ETL & Data Processing: ETL Testing, Data Warehousing, Data Migration
Tools & Technologies: TOAD for Oracle, Serena Dimensions, Jenkins, Putty, Git hub
Operating Systems:Windows, Linux
Job Title
Application Development Senior Analyst
Experience Years
5
Roles And Responsibilities
- Hands-on experience in Oracle PL/SQL development – writing, optimizing, and debugging stored procedures, triggers, and packages.
- Expertise in database object creation – tables, indexes, sequences, synonyms, and DB links.
- Strong understanding of ETL concepts, data modeling, and query optimization techniques.
- Involved in root cause analysis (RCA), defect fixing, and functional testing.
- Experience in version control and CI/CD pipeline integration using Jenkins.
Accomplishments
· Automated data extraction & transformation workflows using PL/SQL, reducing manual effort by 40%.
· Designed and implemented reporting solutions that improved business decision-making.
· Worked extensively on query analysis and legacy table backtracking using crosswalk and mapping documents.
Certification
- Oracle Cloud Infrastructure Foundations, 2023
- AZ-900: Microsoft Azure Fundamentals
Timeline
System Analyst
CIGNA
01.2022 - Current
PL/SQL Developer
Pfizer F&BO ad Managed markets
10.2019 - 01.2021
Bachelor of technology - IT
Valliammai Engineering College
Similar Profiles
Kevin S. GeorgeKevin S. George
Associate Director of Oncology National Accounts at MJH Life Sciences / AJMC Managed MarketsAssociate Director of Oncology National Accounts at MJH Life Sciences / AJMC Managed Markets
Katherine MaggsKatherine Maggs
Director, Strategic Accounts at Managed Markets Insight & TechnologyDirector, Strategic Accounts at Managed Markets Insight & Technology
Tristan MARTIALTristan MARTIAL
Technicien préparateur/analyste en microscopie électronique à transmission analytique (META) at AD-LAB Environnement - https://ad-lab-environment.comTechnicien préparateur/analyste en microscopie électronique à transmission analytique (META) at AD-LAB Environnement - https://ad-lab-environment.com
Aykhan AdigozalovAykhan Adigozalov
Oracle Developer. SQL , PL/Senior SQL Developer at TSYS International Global Payment CompanyOracle Developer. SQL , PL/Senior SQL Developer at TSYS International Global Payment Company
NEETIJIT NAYAKNEETIJIT NAYAK
SQL/PL SQL Developer at AccentureSQL/PL SQL Developer at Accenture