Summary
Work History
Education
Skills
Pan Number
Personal Information
Languages
Timeline
Generic
Abhishek Mishra

Abhishek Mishra

NOIDA

Summary

Overall 8+ years of experience in IT industry. 8 years of professional experience in Application Programming like SQL/PLSQL And Python. Hands On experience in technologies like Oracle, SQL, PL/SQL. Proficient in SQL and PLSQL, Ability to customizing existing logic to add new functionalities, use procedures and functions to validate and to process the business data proficient in writing SQL queries, Cursors, Sub programs like Procedures, Functions, Packages and well known with triggers in PL/SQL blocks. Experience in writing SQL scripts, Stored Procedure, Functions, and Exception Handling for Oracle. Excellent at making time sensitive decisions based on the available information. People Management and mentoring the team.

Work History

Technology Analyst

Infosys Limited
07.2021
  • Creation and modification of database structure as database objects like tables, Alteration
  • Create complex functions, scripts, stored procedures and triggers to support development
  • Designing databases and ensuring their stability, reliability, and performance
  • Used analytical functions, decode, case statement while writing complex SQL queries
  • Handling Database triggers, Forms triggers
  • Creation of new procedures, functions, triggers, packages, also customizing all PLSQL Subprograms and PLSQL blocks
  • Used collection objects, ref cursor and bulk collect, aggregate functions while writing SQL queries.

Senior Software Engineer

IRIS SOFTWARE
  • Understanding of Oracle Architecture
  • Creation and modification of database structure as database objects like tables, Alteration
  • Experience in writing Packages, Procedures, Function and Indexes
  • Create complex functions, scripts, stored procedures and triggers
  • Designing databases and ensuring their stability, reliability, and performance
  • Good understanding on usage of collections, Analytic Functions
  • Used analytical functions, decode, case statement while writing complex SQL queries
  • Handling Database triggers, Forms of triggers
  • Creation of new procedures, functions, triggers, packages, also customizing all PLSQL Subprograms and PLSQL blocks
  • Used collection objects, ref cursor and bulk collect, aggregate functions while writing SQL queries
  • Experience with Partitions, External Table, SQLLDR
  • Developed PL/SQL procedures for processing business logic in the database
  • Implemented performance tuning by using hints, indexes, temporary tables and using tables with fewer rows as the master table in joiner transformations, dropped indexes and re-created them after loading data to targets and increased the commit interval
  • Good knowledge of Performance related issues and worked on SQL tuning
  • Write Unix Script to load data using loader.

Senior Software Engineer

HCL Technologies
  • Fix any issues related to database performance and provide corrective measures
  • Test database query and perform bug fixes
  • Develop best practices for database design and development activities
  • Design, create, and implement database systems based on the end user's application requirements
  • Ensure the data quality and integrity in databases
  • Working Client site as well as Online Remotely Handling, Monitoring Client and Controlling
  • Work With in this Give Training for End User and also Support for Re-Solving Client/ Customer Issues
  • Designed mappings that loaded data from flat-files, Oracle to the staging tables in the Oracle DB Respond all Incidents, service requests within SLA.

Education

B-Tech (Information Technology) -

Diploma -

10th (S.S.C.) -

Skills

  • SQL
  • PL/SQL
  • Python
  • Pandas
  • Pyspark
  • Oracle Architecture
  • Database Design
  • Packages
  • Procedures
  • Functions
  • Indexes
  • Analytic Functions
  • Triggers
  • Collection Objects
  • Ref Cursor
  • Bulk Collect
  • Aggregate Functions
  • Partitions
  • External Table
  • Configuration Management
  • Performance Improvements
  • Performance Tuning
  • Unix Scripting
  • Database Performance
  • Database Systems Design
  • Data Quality and Integrity
  • Incident Management
  • Service Request Management
  • PLSQL Developer
  • Toad
  • Autosys
  • WinSCP
  • Tectia

Pan Number

CAUPM5342K

Personal Information

  • Father's Name: Rajesh Mishra
  • Date of Birth: 03/13/92
  • Marital Status: Married

Languages

  • English
  • Hindi

Timeline

Technology Analyst

Infosys Limited
07.2021

Senior Software Engineer

IRIS SOFTWARE

Senior Software Engineer

HCL Technologies

B-Tech (Information Technology) -

Diploma -

10th (S.S.C.) -

Similar Profiles

CREATE PROFILE
Abhishek Mishra