Summary
Overview
Work History
Education
Skills
Software
Certification
Timeline
Generic
RaviTeja Pemmaraju

RaviTeja Pemmaraju

Pune

Summary

Associate Principal Consultant offering 12 Years of expertise in building high-performance database products, aligning systems with business requirements, policies and regulatory requirements. Results-Oriented individual contributor in Oracle Database Development (DB), Scrum Master (SM) Product Owner (PO), Business Analyst (BA) and Site Reliability Engineer (SRE) currently working in an Insurance domain (Allstate India) as Associate Principal Software Engineer (Role)/Associate Engineering Manager (Designation).

  • 12 Years of expertise into building Oracle SQL and PL/SQL RDBMS systems under various Oracle versions 11g/12c/18c/19c/21c. Strong experience in Data Warehousing concepts and Data Modelling (Physical and Logical).
  • Experience with data flow diagrams, data dictionary, database normalization techniques, entity relation modelling and DB design techniques. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Extensively worked on objects like Indexes, Views, Materialized Views, Stored Procedures, Functions, Packages, Triggers, Synonyms, Sequences. Expertize in Advanced Oracle Concepts like Table Functions, Table Partitioning, Collections, analytical functions, Query Re-write and Dynamic SQL.
  • Good knowledge of key oracle performance related features such as Query Optimizer, Execution Plan and stats. Experience with Performance Tuning using Explain plan and hints.
  • Knowledge on data replication tools like Data guard, Golden Gate and Reflection. Manage Disaster Recovery (DR) and data Migration (DM). Strong DB CI-CD experience using Liquibase.
  • Ensuring DB stability, reliability and performance as per industry standards and requirements. Manage and provide solutioning to DB application teams across different products.
  • Adequate knowledge in UNIX shell Scripting and schedulers like BMC Control-M. Experience with MS T-SQL, MySQL.
  • Extensive knowledge on source control tools like TFS, SVN, GIT, Mercurial, Clear Case. Adaptive to DEV-OPS culture & SAFe Agile development in distributed teams.
  • Agile Practitioner for more than 10+ years. Managed teams as Scrum Master and Product Owner along with technical expertize.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Associate Principal Consultant/Software Engineering Associate Manager

ALLSTATE
Pune
02.2023 - Current
  • Building applications and functionalities based on Oracle SQL, PL/SQL object oriented programming.
  • Building Oracle DB functionalities using Functions, Procedures, Packages, Views, Indexes, Triggers and other objects.
  • Provide solutions for performance turning and other enterprise related designs.
  • Solutioning and re-designing complex RDBMS systems into separate transactional and historical DB's.
  • Provided technical guidance and advice to other developers in developing complex queries and troubleshooting issues related to SQL and PL/SQL programming.
  • Monitored database performance using built-in tools like Profiler and Performance Monitor.
  • Tuned SQL queries for better performance by analyzing execution plans and modifying query structure or adding appropriate indexes where needed.
  • Managed security roles within the database environment including granting permissions to users and groups as per their access rights requirements.
  • Conducted regular reviews of existing database architecture and recommended improvements as needed.
  • Normalize Disaster Recovery (DR) Simulation with very minimal downtime from 8 Hours to just 90 Min
  • Reduced product rollout time by 68% using effective multitasking on design, engineering and maintainable.
  • Remediate compliance issues related to Oracle RDBMS with respective to account remediation, Schema Locking and timezone dependencies.
  • Addressed design challenges and evaluated alternative design models to meet project requirements.
  • Integrated architectural and engineering drawings to create cohesive packages - Data Modelling.
  • Performed concurrent design and engineering, reducing time required to bring product enhancements to LIVE.
  • Manage over more than 8 resources, coach them over organizational vision and self learning.
  • Practicing SAFe Agile model of development software life cycle.
  • knowledge of PDB and CDB architecture.

Assistant Vice President/Senior Software Development Engineer

WELLS FARGO
Hyderabad
06.2020 - 02.2023
  • Expertise on Retail Banking Delivery System (RDS) Debit Cards, Authorizations and Settlements.
  • Strong hands On experience of PL/SQL programming, Oracle Database. Proactively looking for opportunity to rationalize DB and its objects.
  • Developed complex Oracle PL and SQL packages, procedures, functions and triggers to support application development.
  • Analyzed existing database objects for performance issues and implemented tuning solutions.
  • Created technical design documents for Oracle stored procedures and functions.
  • Developed shell scripts to automate the daily maintenance tasks of the databases.
  • Performed code reviews, debugging, optimization and fine-tuning of SQL queries and PL and SQL programs.
  • Provided technical support for the development of reports with tools such as SQL Plus and TOAD.
  • Design authority and Individual contributor for database migration of Wells Fargo using Authentic product to NCR AU proprietary 5.3.0.06.
  • Experience in Golden Gate (GG) replication on Active-Active data-center configuration.
  • Expertise in CI-CD Integration DB deployments using LIQUIBASE.
  • AZURE Fundamentals Cloud certified.
  • Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.

Associate/Senior Software Engineer

J P MORGAN CHASE
Hyderabad
06.2016 - 06.2020
  • Expertise in Consumer Banking Services (CCB)- Credit Cards, Supply Management System and Financial Crimes.
  • Developed database structure and architecture to accommodate user requirements.
  • Provided technical support for end users by resolving complex SQL queries and optimizing their performance.
  • Worked with clients across multiple verticals, including software, banking, public policy and consumer data.
  • Established functional knowledge on Credit Cards, Financial Crimes, Client Screening and its operational techniques including transactional life cycle.
  • Owns Delivery Management for critical products like CHASE SAPPHIRE CC, develop and deployment process.
  • Sufficient knowledge on Client Screening techniques, rules and regulations with US legal regulatory authorities like LexisNexis .
  • Having good understanding over TDD, BDD and SRE
  • Created user stories, acceptance criteria, and developed technical solutions for software projects.
  • Implemented Agile practices such as Scrum, Kanban, SAFe, CI and CD.

System Engineer Analyst

ACCENTURE
Hyderabad
06.2015 - 05.2016
  • Established strong hands on PL/SQL programming.
  • Optimized existing queries to improve performance of the system.
  • Created stored procedures, triggers, tables, views and functions using SQL, PL/SQL.
  • Created complex database structures using Types and Collections.
  • Provided technical support for end users by resolving complex SQL queries and optimizing their performance.
  • Developing complex WEB applications on Oracle APEX 4.2.2 software.
  • Personalized Oracle and organizational analysis framework forms for application to specific business use cases.
  • Developed and customized Oracle reports and forms to meet functional business requirements.
  • Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.

Senior Systems Engineer

INFOSYS
Hyderabad
12.2011 - 06.2015
  • Developed PL and SQL stored procedures, functions and packages for data extraction, transformation and loading.
  • Performed database tuning and query optimization to improve performance.
  • Analyzed user requirements and designed logical models using Oracle Database Designer.
  • Implemented complex SQL queries, views and materialized views for data analysis purposes.
  • Managed version control systems such as Git and SVN for tracking changes in source code files.
  • In depth knowledge on Airline Revenue Accounting System which is heterogeneous amalgamation of dualistic systems falling under two different airlines (United Airlines and Continental Airlines)
  • Individually migrated conventional revenue accounting Database structure to object oriented structure that is centralized, consolidated to house all passenger ticket sales, settlement and refund information for combined airline
  • Experience in developing front-end .NET framework in C# , ADO and ASP to help airlines to statistically view accounts.

Education

Bachelor of Technology (B.Tech) - Electronics and Communications Engineering

Marri Laxma Reddy Institute of Technology
Hyderabad

Skills

  • Oracle DB, SQL, PL/SQL
  • Performance Tuning
  • Database Design
  • Data Modelling
  • Database CI-CD
  • Architectural and Design Engineering
  • UNIX Shell Scripting
  • Agile Software Development
  • MS AZURE
  • Annual reviews
  • Project Management

Software

Oracle SQL, PLSQL 11G, 12C, 18C, 19C, 21C

ORACLE GoldenGate and Reflection

Oracle APEX

Liquibase, Oracle Cloud Deployment

Crucible, Fisheye, JIRA, ITSM, ServiceNow, HPSM, ALM

GIT, SVN, TFS and ClearCase

Control-M, Tivoli

MS SQL, C#, ASPNET

Certification

  • Airline Industry Financial Accounting
  • Airline Industry L200
  • Agile Delivery Model Foundation Level
  • Oracle 11g Certified Associate
  • EXXIN DEV-OPS Foundation
  • AZURE FUNDAMENTALS AZ-900

Timeline

Associate Principal Consultant/Software Engineering Associate Manager

ALLSTATE
02.2023 - Current

Assistant Vice President/Senior Software Development Engineer

WELLS FARGO
06.2020 - 02.2023

Associate/Senior Software Engineer

J P MORGAN CHASE
06.2016 - 06.2020

System Engineer Analyst

ACCENTURE
06.2015 - 05.2016

Senior Systems Engineer

INFOSYS
12.2011 - 06.2015

Bachelor of Technology (B.Tech) - Electronics and Communications Engineering

Marri Laxma Reddy Institute of Technology

Similar Profiles

CREATE PROFILE
RaviTeja Pemmaraju