Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Vamshidhar Reddy Ponnagandla

Hyderabad

Summary

  • 8+ years of experience in Development, Testing and Analysis on ORACLE SQL and PLSQL.
  • Having experience in cloud database Snowflake cloud database, Snow SQL, Snow Pipe.
  • Having experience on data visualization in Looker Studio.
  • programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Experience in Analyzing business requirements, and strong knowledge of Data warehousing Concepts, Business Intelligence.
  • Involved in migrating data from Oracle to Snowflake. Having Knowledge on DBT(data build tool) to perform the transformation and creating project, models in DBT tool.
  • Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQLPLUS, PLSQL Developer and SQL LOADER.
  • Hands on experience with SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQLPLUS, TOAD and SQL
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Developed Complex database objects like Stored Procedures, Functions, Packages using SQL and PL/SQL.
  • Developed materialized views for data replication in distributed environments.
  • Experience in Oracle packages, Dynamic SQL, Records and PL/SQL Tables.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Partitioned large Tables using range partition technique.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively External Tables and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Experience in SQL performance tuning. Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Experience in scheduling the DB jobs.
  • Hands-on experience with Snowflake utilities such as Snow SQL, Snow Pipe, Tasks, streams, Time travel, Tables, Views, Cloning and Data Masking.
  • Hands-on experience with Snowflake Insert, Update and Merge command. Bulk loading from the external stage (AWS S3) to the internal stage(snowflake) using the copy command.
  • Deep understanding in loading and unloading data from snowflake.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Associate Consultant, Engineering

GOOGLE(GLOBALLOGIC PVT LTD)
Hyderabad
12.2022 - Current
  • Google Ads Data Integration and Dashboard Development
  • Led a project to integrate Google Ads data into a database system and create insightful reports and dashboards for clients.
  • Converted the sql scripts and stored procedures into snowflake
  • Designed and implemented ETL processes to import and manage Google Ads data within the database
  • Developed and optimized SQL queries, stored procedures, and functions for generating detailed and customizable reports
  • Automated report generation and delivery, ensuring timely and accurate updates for clients to monitor campaign performance and track key performance indicators (KPIs)
  • Collaborated with stakeholders to understand their reporting needs and created interactive dashboards using tool looker studio
  • Provided real-time insights and visualizations, enabling clients to make data-driven decisions and effectively manage their Google Ads campaigns
  • Ensured dashboards were user-friendly and contained key metrics to enhance client decision-making capabilities.

Sr. Software Engineer (Lead)

Attra Infotech Pvt Ltd
Hyderabad
03.2022 - 12.2022
  • Project: Payments And Banking Database Data Migration
  • Led the data migration project for an Payments And banking database, ensuring seamless integration and accuracy of financial data across multiple systems
  • Utilized Snowflake and DBT techniques to extract, transform, and load (ELT) data while maintaining data integrity and security
  • Implemented SQL scripts and stored procedures to handle large volumes of transactions efficiently
  • Coordinated with cross-functional teams to align migration processes with business requirements and regulatory standards
  • Conducted thorough testing and validation to ensure the reliability and performance of the migrated database.

Oracle Lead

Wipro
Hyderabad
06.2019 - 03.2022
  • Project: AML (Anti-Money Laundering) Banking Reporting Services
  • Developed and maintained AML banking reporting services, focusing on generating comprehensive and accurate compliance reports
  • Designed and implemented complex PL/SQL scripts and stored procedures to automate the extraction and transformation of transactional data
  • Collaborated with compliance and audit teams to define reporting requirements and ensure alignment with regulatory standards
  • Optimized query performance to handle large data sets efficiently, enhancing the timeliness and reliability of AML reports
  • Conducted rigorous testing and validation to ensure data accuracy and report integrity.

Software Engineer

3i Infotech
Hyderabad
08.2016 - 05.2019
  • Project: AML (Anti-Money Laundering) Banking Reporting Services
  • Developed and maintained AML banking reporting services, focusing on generating comprehensive compliance reports and customer name scanning
  • Designed and implemented complex PL/SQL scripts and stored procedures to automate the ETL of transactional data
  • Integrated advanced name scanning algorithms to detect and flag suspicious activities, ensuring regulatory compliance
  • Collaborated with compliance and audit teams to define reporting requirements and optimize AML detection processes
  • Conducted rigorous testing to ensure data accuracy, report integrity, and the effectiveness of name scanning mechanisms.

Education

Bachelor's degree - Electrical And Electronics Engineering

Jawaharlal Nehru Technological University Hyd
Hyderabad, India
05.2014

Skills

  • Databases: Oracle 8i/9i/10g/11g/12c (SQL, PL/SQL),Snowflake database(cloud)
  • Cloud: Snowflake, AWS, GCP
  • Operating Systems: Windows7/10 & Windows XP, UNIX/Linux
  • Languages/Utilities: SQL, PL/SQL
  • Domain : Banking and Financial
  • Other Tools: Oracle sql developer, PLSQL developer, DBT, Snowflake, WebLogic, Jira, Github, Critique, Looker Studio, Colab, Parc Author, Cider, connect sales

Certification

  • Oracle Associate Certified (Plsql Developer)
  • Certification In Amlock (Anti Money Laundering) from ICICI
  • Certification in PLSQL from Wipro

Timeline

Associate Consultant, Engineering

GOOGLE(GLOBALLOGIC PVT LTD)
12.2022 - Current

Sr. Software Engineer (Lead)

Attra Infotech Pvt Ltd
03.2022 - 12.2022

Oracle Lead

Wipro
06.2019 - 03.2022

Software Engineer

3i Infotech
08.2016 - 05.2019

Bachelor's degree - Electrical And Electronics Engineering

Jawaharlal Nehru Technological University Hyd

Similar Profiles

CREATE PROFILE
Vamshidhar Reddy Ponnagandla