Summary
Overview
Work History
Education
Skills
Activities
Interests
Personal Information
Personal Traits
Timeline
Generic

Vishal Pandey

ORACLE PLSQL DEVELOPER
Haldwani,Uttarakhand

Summary

Experienced Oracle PLSQL Developer with 7.4 years of experience on Oracle 10g/11g/12c/19c platforms. Skilled in all phases of project life cycle, from requirement gathering to implementation and support. Proficient in creating SQL and PL/SQL database objects like Functions, Procedures, Packages, and Triggers. Specialized in advanced PL/SQL concepts such as Cursors, Indexes, and Dynamic SQL. Familiar with Agile methodologies and code management tools like SVN/GIT/Bitbucket. Recognized for strong analytical and communication skills, delivering high-quality work and valuable suggestions for improvement.

Overview

8
8
years of professional experience
6053
6053
years of post-secondary education
2
2
Languages

Work History

Senior Software Engineer

Vodafone Intelligent Solutions
Remote
12.2021 - Current
  • VPS is a vendor processing system designed for Vodafone sales managers in Germany to create Assignments for sales agents. This system is used to manage sales agents and assign them work as per their availability and area.
  • Requirement gathering from business and planning it on sprints.
  • Planning the development and logic creation along with technical documents.
  • Oracle PLSQL development and creation of liquibase scripts.
  • Helping QA team with testing work by data creation etc.
  • Helping the team with post deployment sanity checks.
  • Analysing and resolving prod issues.
  • Helping and guiding other team members with their development work if needed.
  • Reviewing pull requests created by others and suggesting changes if needed.
  • Resolving Prod/ CI CD deployment issues if any comes pertaining to our project.
  • System demo to stakeholders for features implemented by team.
  • Helping projects to Interview sql candidates.
  • Helping other teams(under my manager) with sql work if needed.
  • Taking charge of required business / Train calls in absence of Team Lead

Senior Project Engineer

Credit Suisse
Pune
01.2021 - 01.2022
  • Defferred Compensation is a global system that resides in Zurich enabling each region's human resources financial group to accurately and efficiently manage the booking to general ledger of employee deferred compensation awards. This is designed to process allocation of stock shares by plan to members of executive board.
  • Requirement gathering from business and planning it.
  • Creating a blueprint to accomplish the feature technically and along with plan document.
  • Oracle PlSQL development along with creation of technical document.
  • Unit testing of implemented feature.
  • Helping QA team as well as business team with testing work by data creation etc.
  • Creation of deployment scripts.
  • Helping the team with post deployment sanity checks.
  • Analysing and resolving prod issues.
  • Helping Ops team on business queries and data.

Student(WASE)

Credit Suisse
Pune
05.2017 - 07.2020
  • PAS is an application which is used to calculate the salary as well as Other expenses like equipment, premises, VAT etc incurred for a particular staff and then is combined together as a department and was then sent to downstream for GL posting.
  • Requirement gathering from business and planning it.
  • Creating a blueprint to accomplish the feature technically and along with plan document.
  • Oracle PlSQL development along with creation of technical document.
  • Unit testing of implemented feature.
  • Helping QA team as well as business team with testing work by data creation etc.
  • Creation of deployment scripts.
  • Helping the team with post deployment sanity checks.
  • Analysing and resolving prod issues.
  • Helping Ops team on business queries and data.
  • Helping team in creation of required service now tickets for change requests and their approvals.
  • Presenting our change in front of CAB team and taking approvals from them.

Student(WASE)

Credit Suisse
Pune
05.2017 - 07.2020
  • VIPS is an application that is used to process invoices for vendor of CS like TCS, WIPRO, COGNIZANT etc based on the data received in TIMESHEETS filled by employees in OnePPM application. Vendor have two category I.e. contractor and consultant.
  • Requirement gathering from business and planning it.
  • Creating a blueprint to accomplish the feature technically and along with plan document.
  • Oracle PlSQL development along with creation of technical document.
  • Unit testing of implemented feature.
  • Helping QA team as well as business team with testing work by data creation etc.
  • Creation of deployment scripts.
  • Helping the team with post deployment sanity checks.
  • Analysing and resolving prod issues.
  • Helping Ops team on business queries and data.
  • Helping team in creation of required service now tickets for change requests and their approvals.
  • Presenting our change in front of CAB team and taking approvals from them.

Education

MTech -

BITS Pilani
Distance
12.2020

BCA -

Graphic Era University
Bhimtal, U.K
07.2016

Intermediate -

Nirmala Convent School
Kathgodam, U.K

Matriculation - undefined

Nirmala Convent School
Kathgodam, U.K

Skills

Advanced PL and SQL programming

Performance tuning techniques

Error handling and debugging

Partitioning and indexing

SQL development

Oracle performance tuning

Activities

Participated and Awarded for winning Photography event held in College.

Interests

Photography & Videography
Writing
Travelling
Trekking

Personal Information

  • Date of Birth: 02/14/96
  • Nationality: Indian

Personal Traits

  • Focused dedication
  • Creativity
  • Innovative thoughts
  • Managing, coordinating and organizing skills
  • Communication and counselling skills
  • Keen learning interests
  • Problem solving and decision-making skills
  • Teamwork

Timeline

Senior Software Engineer

Vodafone Intelligent Solutions
12.2021 - Current

Senior Project Engineer

Credit Suisse
01.2021 - 01.2022

Student(WASE)

Credit Suisse
05.2017 - 07.2020

Student(WASE)

Credit Suisse
05.2017 - 07.2020

Matriculation - undefined

Nirmala Convent School

MTech -

BITS Pilani

BCA -

Graphic Era University

Intermediate -

Nirmala Convent School

Similar Profiles

CREATE PROFILE
Vishal PandeyORACLE PLSQL DEVELOPER