Mehar Kamesh Mallavarapu

As a skilled and experienced programmer with over 6 years of experience in the analysis, design, and implementation of business applications using the Oracle Relational Database Management System (RDBMS), I offer expertise in the following areas:

1. Oracle Database Design and Development: I possess exceptional experience in designing and developing Oracle databases and possess a working knowledge of data modeling and management tools. I am proficient in using TOAD, SQL Developer, and have worked with Oracle 11g, 12c, and 19c versions.

2. Data Modeling and Architecture: With 3 years of experience in data modeling and architecture, I have worked on logical and physical data modeling using normalizing techniques and have created Tables, Views, Constraints, Index (B Tree, Bitmap, and Function Based).

3. Database Object Development: I have experience in developing complex database objects like Stored Procedures, Functions, Packages, and Triggers using PL/SQL. Additionally, I have worked with Oracle supplied packages, Dynamic SQL.

4. Performance Optimization: I am knowledgeable in SQL performance tuning using Cost-Based Optimization (CBO) and possess a good understanding of key Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes.

5. Data Loading and Partitioning: My experience includes loading data into Oracle Tables using SQL Loader, partitioning large Tables using the range partitioning technique, and creating Packages and Procedures to automatically drop table indexes and create indexes for the tables.

6. Functional/Domain Expertise: I possess strong functional/domain experience in Cards & Payments domain and Banking domain.

7. Agile Methodology: I have experience working with Agile Methodology and working on releases in an Agile manner.

8. Language Conversion and Migration: I have successfully converted or migrated code from various functional languages in Oracle to MYSQL to POSTGRESQL.

9. Communication and Collaboration Skills: I possess strong communication and collaboration skills to work effectively with cross-functional teams, including developers, data scientists, business analysts, and project managers. This includes the ability to explain complex technical concepts in non-technical terms and present findings and recommendations to stakeholders.

Overall, my goal is to contribute value-based knowledge and seek training and guidance from proficient seniors that will help me grow my skills and achieve my goals for the organization.

• Honors & Awards , Spot Award - Jocata Feb 2021 MALLAVARAPU MEHAR KAMESH - page 3