Summary
Overview
Work History
Education
Skills
Personal Information
Languages
Hobbies and Interests
Disclaimer
Sql Technical Skills
Sql Training Details
Timeline
Generic

Abhishek Shukla

Ahmedabad

Summary

Accomplished Software Developer with expertise in Oracle PL/SQL and database management, honed at Bankai Informatics. Proven ability to optimize backend solutions and mentor teams, enhancing performance and efficiency. Skilled in debugging and designing relational schemas, demonstrating strong analytical and problem-solving capabilities.

Overview

13
13
years of professional experience

Work History

Software Developer

Bankai informatics PVT. LTD. (Formarly known as Acute Informatics PVT. LTD.)
Ahmedabad
04.2024 - Current

- Developed backend solutions for data insertion with validation and managed API request processing using PL/SQL.
- Optimized and debugged PL/SQL code while designing schemas and managing data operations.
- Created APIs in PL/SQL, covering all methods for comprehensive functionality.
- Designed and optimized relational database schemas, including tables, indexes, and constraints.
- Demonstrated proficiency in Oracle PL/SQL, specializing in banking sector applications.
- Utilized Oracle 19c, Visual Studio Code, and Postman to develop JSON-based API services.
- Mentored new employees on SQL and PL/SQL best practices for improved team performance.

Software Engineer

Remik Trading Co. Pvt. Ltd.
Ahmedabad
01.2022 - 09.2023
  • Administered and maintained Remik ERP and associated database to ensure operational efficiency.
  • Utilized Oracle Forms Builder and Oracle Reports Builder for development and enhancements.
  • Modified Oracle forms and reports according to specific requirements.
  • Generated data and reports for departments including Sales, Purchase, Accounts, and HR through query writing.
  • Managed multiple servers including forms server, reports server, database backup server, and SMS server.
  • Ensured smooth functioning of ERP software for Financial Accounting System, Order Processing System, and other modules.
  • Managed transactions and master entries as directed by EDP manager or end users.
  • Provided training on new features to staff members and ERP training for new employees.

Senior Executive

Vodafone
10.2018 - 12.2021
  • Managed customer queries via chat for Mobile and Broadband sectors in New Zealand.
  • Provided comprehensive support for Prepay and On account inquiries, ensuring 100% client assistance.
  • Resolved billing, account, handset, and network issues with satisfactory outcomes.
  • Demonstrated diagnostic skills to address technical queries effectively per established processes.
  • Achieved monthly NPS, FCR, ASAT targets while maintaining high service standards.

Process Specialist

Ttech
12.2015 - 08.2018
  • Provided chat and email support to UK clients, addressing complex inquiries promptly.
  • Processed multiple emails and managed concurrent chats from eBay UK sellers.
  • Assisted with item listings, sales strategies, and billing queries for optimal client satisfaction.
  • Trained nesting teams as a mentor, focusing on query interpretation and resolution techniques.
  • Engaged in performance planning and goal setting through active participation in coaching sessions.

Samsung Experience Consultant (SEC)

SSK Retails Pvt. Ltd.
04.2012 - 11.2015
  • Sold Samsung mobile devices and laptops while addressing customer inquiries and resolving issues.
  • Managed billing and payment processes, ensuring accuracy and timeliness.
  • Performed routine office tasks, including reporting and drafting correspondence.
  • Generated weekly Management Information System (MIS) reports, including direct sales and billing summaries.
  • Coordinated with head office to resolve customer queries efficiently.
  • Participated in promotional activities, including advertising and merchandising campaigns.
  • Executed media strategies through newspaper ads, hoardings, and banners.

Education

DIPLOMA - Informaion Technology

Nirma University
Ahmedabad
01.2011

S.S.C -

Gujarat Secondary and Higher Secondary Board
01.2007

Skills

  • Oracle database management (10g, 11g, 12c)
  • SQL and PL/SQL proficiency
  • Data manipulation language (DML)
  • Data definition language (DDL)
  • Data control language (DCL)
  • Transaction control language (TCL)
  • SQL joins and subqueries
  • Database views and indexes
  • Sequences and cursors
  • Stored procedures and functions
  • Packages and predefined packages
  • Debugging PL/SQL subprograms
  • Exception handling techniques
  • Dynamic SQL execution
  • Database triggers and mutating objects
  • Nested tables and index-by tables
  • Data dictionary navigation

Personal Information

  • Date of Birth: 10/23/91
  • Gender: Male
  • Marital Status: Married

Languages

  • English
  • Hindi
  • Gujarati

Hobbies and Interests

  • Playing Cricket
  • Chess

Disclaimer

I hereby declare that the above-mentioned information is true to the best of my knowledge.

Sql Technical Skills

  • Oracle 10g, 11g, 12c, SQL
  • Plus, Oracle 12c SQL Developer, SQL, Oracle SQL, Oracle PL/SQL, Written SQL queries for DDL, DML, DCL, TCL operations, Managing and Gathering Statics on Table, Schema and Database, System and Object Privileges Management, Understanding of SQL Joins, Subquery, Grouping, View, Index, Sequence, Managing PL/SQL Blocks, Procedures, Functions, Packages, Debug PL/SQL Subprograms, Use of Packages, Cursors, Dynamic SQL statement, Database Trigger, Exception Handling, Predefined Packages, Mutating Objects, Knowledge of Index By Table, Nested Table, Knowledge of Gathering Data Dictionary information for Table, Schema and Database

Sql Training Details

  • Completed Oracle 12c SQL training from ITS Data Solutions Pvt. Ltd.
  • Completed Oracle 12c PL/SQL Training from ITS Data Solutions Pvt. Ltd.

Timeline

Software Developer

Bankai informatics PVT. LTD. (Formarly known as Acute Informatics PVT. LTD.)
04.2024 - Current

Software Engineer

Remik Trading Co. Pvt. Ltd.
01.2022 - 09.2023

Senior Executive

Vodafone
10.2018 - 12.2021

Process Specialist

Ttech
12.2015 - 08.2018

Samsung Experience Consultant (SEC)

SSK Retails Pvt. Ltd.
04.2012 - 11.2015

DIPLOMA - Informaion Technology

Nirma University

S.S.C -

Gujarat Secondary and Higher Secondary Board
Abhishek Shukla