Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Vamshidhar Reddy P

Hyderabad

Summary

  • Over 8 years of experience in software development, maintenance, and production support as an Oracle PL/SQL Developer.
  • Specialized in Oracle 12c, 11g, and 10g environments.
  • Hands on experience in Snowflake Database.
  • Hands on experience in data visualization using Looker Studio.
  • Proficient in PL/SQL, UNIX, and Shell Scripting.
  • Extensive expertise in the complete life cycle implementation of PL/SQL development for both OLAP and OLTP environments.
  • Exceptional abilities in writing complex SQL queries, stored procedures, functions, and triggers.
  • Skilled in performance optimization using ExplainPlan, SQL Trace, TKPROF, and Oracle Optimizer hints.
  • Proven track record of managing and optimizing database performance.
  • Experienced in providing robust production support and adhering to industry best practices.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Associate Consultant,Engineering

GOOGLE
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.
  • 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 tools like Tableau or Power BI.
  • 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: ATM Banking Database Data Migration
  • Led the data migration project for an ATM banking database, ensuring seamless integration and accuracy of financial data across multiple systems.
  • Utilized advanced PL/SQL techniques to extract, transform, and load (ETL) data while maintaining data integrity and security.
  • Implemented complex 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 and accurate compliance reports and customer name scanning.
  • Designed and implemented complex PL/SQL scripts and stored procedures to automate the extraction, transformation, and loading (ETL) of transactional data.
  • Integrated advanced name scanning algorithms to detect and flag suspicious activities, ensuring compliance with regulatory standards.
  • Collaborated with compliance and audit teams to define reporting requirements and optimize the AML detection processes.
  • Conducted rigorous testing and validation 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
05-2014

Skills

  • Oracle 12c/11g/10g, PL/SQL, LINUX, SQL, SNOWFALKE, DBT, LOOKER STUDIO,GOOGLE SQL, SQL SERVER, MYSQL, JAVA SCRIPT, PYTHON(Basic),NO SQL
  • TOAD, SQL DEVELOPER, PLSQL DEVELOEPR, COLAB
  • GitHub, Jira
  • Agile and Waterfall Software Development methodologies

Certification

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

Timeline

Associate Consultant,Engineering

GOOGLE
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 P