Venkatrami Reddy Durgempudi
Hyderabad,
Summary
Oracle PLSQL developer/Data Analyst with 9+ years of experience in the IT industry. Proficient in Oracle architecture and database design. Skilled in designing and developing applications using Oracle 10g, SQL, and PL/SQL. Knowledgeable in Oracle tools like SQL PLUS and SQL Developer. Experienced in utilizing PL/SQL, SQL, Oracle 11G, UNIX Shell Script and Python throughout the SDLC. Strong analytical skills with a basic understanding of Python, GCP, and AWS Cloud.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior PLSQL Developer/Data Engineer
Mango Sciences
Hyderabad
08.2022 - Current
- Developed PLSQL scripts to create and transfer data between Source and Report Tables.
- Created and maintained Tables and Data to meet diverse Reporting requirements
- Conducted data analysis to compare Reporting data and Client provided data, updating scripts accordingly
- Ensured seamless implementation of stakeholder requirements and changes throughout necessary areas.
- Resolved Jira tickets pertaining to Data and Code related issues
- Provided assistance to the Operations team in successfully addressing report management issues.
- Implemented enhancements to various database objects used in the pipeline to optimize overall performance.
- Developing and enhancing UTL Loader SQL loader packages for efficient processing of data from Flat files to tables
Senior PLSQL Developer
DvSum
Bangalore
12.2021 - 08.2022
- Played an integral role in the development of DB Objects for Pipeline using PLSQL and Centerprise ETL Tool (Old) Python (New)
- Successfully migrated oracle DB data (CSV) files to Google Cloud Storage
- Developed external tables and authorized views to support advanced analysis.
- Proactively utilized data validations to identify any issues in the pipeline.
- Interacted with stakeholders to gather and implement new requirements or changes.
- Successfully addressed Jira tickets involving data and code concerns.
- Created and implemented validation queries as rules to prevent the recurrence of known issues.
- Enhanced efficiency of database objects in the project pipeline through performance tuning.
- Developed and implemented UTL Loader SQL loader packages for efficient file loads from flat files to tables and exports.
- Developed and implemented SQL, PL/SQL, and SQL Plus programs for efficient data retrieval utilizing cursors and exception handling.
- Updated procedures, functions, triggers, and packages in response to change requests.
- Built complex queries using SQL and wrote stored procedures using PL/SQL.
- Contributed to the improvement of table performance by working with indexes, reducing reliance on full table scans and concealed views, and simplifying complex query structures.
PLSQL Developer
Tata Consultancy Services Ltd
Hyderabad
03.2020 - 11.2021
- Collaborating in the complete software development process encompassing planning, analysis, designing prototypes as well as testing and implementing final products.
- Utilized SQL Plus, PL/SQL, and SQL Loader scripts to efficiently execute data conversions.
- Utilized cursor-based processing with exception handling in SQL, PL/SQL, and SQL Plus to access necessary information.
- Updated procedures, functions, triggers, and packages in response to change requests.
- Built complex queries using SQL and wrote stored procedures using PL/SQL.
- Optimized tables by implementing indexes to enhance performance and eliminate full table scans.
- Utilized SQL loader to transfer data from flat files to staging area tables.
- Created and modified multiple Unix shell scripts based on evolving project needs and client requirements.
- Streamlined daily file processing operations by writing UNIX shell scripts that automated tasks such as renaming files, extracting dates, unzipping files, and eliminating unwanted characters before loading data into base tables.
Database Analyst/PLSQL Developer
Tata Consultancy Services Ltd
Chennai
11.2014 - 02.2020
- Engaged in daily interactions with stakeholders to gain insights into expectations, requirements, and modifications to current solutions.
- Enabled customer-specific requirements in the tool.
- Provided customers with necessary insights into data using stored procedures and packages.
- Regularly delivered comprehensive business reports to stakeholders, showcasing the status of various Key Performance Indicators. Utilized automated scripts and intricate SQL queries, combined with PL/SQL stored procedures.
- Collaborated with billing managers to gain insight into newly launched products and devised configuration solutions for the DB.
- Expanded tool's scope to various segments and business units through extending reconciliation capabilities.
- Identified potential undercharging and overcharging cases, minimizing revenue leakage and improving the Customer Satisfaction Index.
- Enhanced efficiency in Contract Management by developing automated solutions using VBA Macros and Shell Scripts.
- Analyzed exceptions and initiated corrections in Telstra Billing systems.
- Built complex queries using SQL and wrote stored procedures using PL/SQL.
- Enhanced performance by efficiently optimizing slow-running queries.
Education
B.Tech - Electronics And Communications Engineering
JNTU
Kakinada05-2014
Skills
- Oracle SQL
- Oracle PL/SQL
- Performance Tuning
- UNIX Shell Scripting
- Data Warehousing
- ETL
- Jira
- VBA
- Basics of Python
- Basics of GCP
- Basics of AWS
Certification
Oracle PL/SQL Developer Certified Associate (OCA)
Timeline
Senior PLSQL Developer/Data Engineer
Mango Sciences
08.2022 - Current
Senior PLSQL Developer
DvSum
12.2021 - 08.2022
PLSQL Developer
Tata Consultancy Services Ltd
03.2020 - 11.2021
Database Analyst/PLSQL Developer
Tata Consultancy Services Ltd
11.2014 - 02.2020
B.Tech - Electronics And Communications Engineering
JNTU
Similar Profiles
Emiliano GarciaEmiliano Garcia
Front Team at Mango MangoFront Team at Mango Mango
Kayla stewartKayla stewart
Bartender at Mango MangoBartender at Mango Mango
Yi LuoYi Luo
Dessert Shop Kitchen Helper at Mango Mango DessertDessert Shop Kitchen Helper at Mango Mango Dessert
DEEPAK VISHWANATH DHOLEDEEPAK VISHWANATH DHOLE
Data Engineer | Analytics | PLSQL Developer Lead at Tata Consultancy ServicesData Engineer | Analytics | PLSQL Developer Lead at Tata Consultancy Services
MARLTON SOLIVENMARLTON SOLIVEN
Systems Analyst-PLSQL Developer/Data Engineer/Lead at Philippine Savings Bank (Strongest Savings Bank)Systems Analyst-PLSQL Developer/Data Engineer/Lead at Philippine Savings Bank (Strongest Savings Bank)