Harsha Vardhan Phone: +91 8886822383
PLSQL Developer Email:harshabanala01@gmail.com
Professional Summary
Having 3+ years of Experience in Application development and maintenance Support
projects using SQL, PLSQL with good understanding of different Application
development tools and technologies.
Experience Summary
Having good experience in SQL and PLSQL development using ORACLE 10g,
ORACLE 11g and ORACLE 12c
Experience in Creating Tables, Views, Constraints, Sequences and Synonyms.
Good experience in creating complex database objects like stored procedure, Functions,
Packages, and Collections.
Good understanding of the functional flow in customer Finance domains.
Knowledge in SQL Query tuning and performance tuning.
Good in the Concept of Exception handling mechanism in various scope and visibility.
Experience in Agile/Scrum development methodology.
Having Good Knowledge in Client-Server application development using
Oracle 11g/10g/12c, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Basic Knowledge of UNIX Commands and Oracle Database.
Perform tests after deployment in the applications and provide evidence document to the L3.
Involved in client calls for major support of application for the enhancement of application.
Providing the training and certification status to management as an additional task in day-to-day
work.
A highly motivated, energetic individual and a team player with excellent analytical &problem-
solving skills, communication skills and interpersonal skills.
Technical skills
Operating System Windows 7/10, Linux, Unix
Languages SQL, PLSQL,
Tools Used Toad, PUTTY, SQL Developer, GIT Extension.
Version Control/Repository GIT
Methodology Agile/SCRUM
RDBMS ORACLE 10g, 11g, 12c, SQL*LOADER
Office Packages JIRA
Education
B. Tech Mechanical Engineer (2019) from N.B.K.R Institute of Science Technology, Nellore
, Andhra Pradesh, India.
Highlights:
Received on the spot appreciation award from client for best work delivered.
IT Experience:
1) Company name: Epsilon
Experience: April-2023 to till date
2) Company name: ROCK TECHNOLOGIES PRIVATE LIMITED
Experience: Dec-2020 to March-2023
Project-1
Project Name : TD Bank, Us Client Role :
Team Member/PLSQL Developer
Environment : Oracle 12C, SQL, PLSQL, GIT Extension
Description: This system keeps track of day-to-day bank operations like deposits,
withdrawals, demand drafts, different types of loans (mortgage business) for the customers as
well as the employees. You’ll have easy access to your money, when and where you need it,
and an experienced Client Service team focused on you. Plus, you’ll partner with
professionals who understand your goals and will work with you to help you reach them,
utilizing the latest mobile and online technology to facilitate it all.
Roles and Responsibilities:
Involved in full development cycle of Planning, Analysis, Design, Development,
Testing and Implementation.
Designed logical and physical data models for star and snowflake schemas using
Erwin.
Wrote sequences for automatic generation of unique keys to support primaryand
foreign key constraints in data conversions.
Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data
conversions.
Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and
exception handling.
Creating indexes on tables to improve the performance by eliminating the fulltable
scans and views for hiding the actual tables and to eliminate the complexity of the
large queries.
Fine-tuned procedures/SQL queries for maximum efficiency in various databases
using Oracle Hints, for Rule based optimization.
Project 2 (Dec 2020 to Mar 2023)
Project Name : E-health care system
Role : Team Member/Oracle SQL Developer
Environment : Oracle 11g , SQL, GIT Extension
Description:
The main feature of E-Knowledge in health care system is to provide the browser to get
appointments from a doctor through internet instead of going there and fixing an appointment.
In Doctor’s side they can view their appointments and prescribe medicine for their patients.
E-Knowledge in health care system maintains patient’s prescriptions so that their
medical details are always available in internet, which will be more convenient for the patients.
This will be more comfortable for the patient. Patient details and prescriptions are maintained
confidentially.
Roles &Responsibilities:
Coordinating the Developing activities with the development team And QA team
Requirement gathering from the Business Team.
Involved in Creation of events handlers within the SQL packages.
Development for the new Creation of Tabular, Chart, Sub Reports, as per end user
requirements.
Every month need to run audit process followed by company process and company process
merging.
Interact with Business Team for developing reports to the clients as per their requirement
Wrote stored procedures in management studio to fetch data for reports
Loading data that has been extracted from Excel Sheet and Flat Files. Once data is loaded
to master tables we are loaded the data into corresponding Dimension tables using SSIS
tool.
Personal Details
Name : Harsha Vardhan. B
Father’s Name : Krishnaiah. B
Date of birth : 10/06/1998.
Language known : Telugu, English.
Declaration
I hear by declare the above given particulars are true to the best of my knowledge and my self.
Date: (Harsha Vardhan)
