Vishal Gabel
Sakti
Summary
Accomplished Software Engineer with extensive experience at Tech Mahindra, specializing in Informatica PowerCenter and PL/SQL development. Proven track record in designing complex data transformations and enhancing reporting structures. Adept at performance tuning and effective communication, delivering innovative solutions that drive operational efficiency and user satisfaction.
Overview
3
3
years of professional experience
Work History
SOFTWARE ENGINEER
TECH MAHINDRA
Navi Mumbai
10.2024 - Current
- Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
PLSQL Developer
Nityo Infotech(Client HDFC BANK Ltd.)
Mumbai
10.2021 - 10.2024
- Company Overview: The loan accounting system is a complex system, and the application is divided into three major modules, which can also be said to consist of three major applications integrated as a single entity.
- I have worked on all the modules of the application (three main sub-applications).
- Primary working as an independent PL/SQL developer.
- Created and modified existing tables used in the application.
- Created complex procedures for multiple modules in the application, as the application is extensively database-driven.
- Created indexes for the table, performed entire DDL, and DML operations.
- Created New Oracle BI Reports using the Oracle BI Reporting tool, remodeling the entire reporting structure of the application replacing the legacy reports with this new architecture
- Wrote complex Jobs with scheduling to perform automate branch code update to keep the data in sync after the merger of HDFC Ltd with HDFC Bank (as both have this common entity of branchcode and to uniquely identity HDFC Ltd as well as HDFC Bank branches
- Write a complex script for dynamically adding the menus to the application based on customer details
- Created complex report for the automation using Oracle Apex tool
- Created a complex script for the batch update and insertion of records, along with Triggers in the table which is consumed by frontend windows scheduler program
- Coordinated with end users regarding project development and resource estimates
- Microsoft Team Call/Verbal Communication to handle the client queries on day-to-day basis
- Providing extensive support to the users in production and UAT Environment
- Daily customer support as it is an ongoing project and involves frequent interaction and changes within the UI
- Wrote PL/SQL programs required to retrieve data from the data repository using Cursor and exception handling
- The loan accounting system is a complex system, and the application is divided into three major modules, which can also be said to consist of three major applications integrated as a single entity.
Education
BTECH - Mechanical Engineering
Shri Shankaracharya Instituteof Engineering and Technology
04.2017
Skills
- PLSQL
- ORACLE REPORT
- ORACLE FORM
- ORACLE APEX
- INFORMATICA POWERCENTRE
- SQL
- ORACLE BI
- DATABASE OBJECTS
- TABLES
- VIEWS
- SYNONYMS
- MATERIALIZED VIEWS
- STORED PROCEDURES
- FUNCTIONS
- PACKAGES
- COLLECTIONS
- PERFORMANCE TUNNING
- DEBUGGING
- ORACLE TOOLS
- ORACLE BI Reports
- JIRA
- ZOHO
Hobbies and Interests
- Reading Books
- Playing Cricket
- Watching Movies
Languages
- English, Proficient
- Hindi, Proficient
Timeline
SOFTWARE ENGINEER
TECH MAHINDRA
10.2024 - Current
PLSQL Developer
Nityo Infotech(Client HDFC BANK Ltd.)
10.2021 - 10.2024
BTECH - Mechanical Engineering
Shri Shankaracharya Instituteof Engineering and Technology
Similar Profiles
Hemanth Kumar BangaruHemanth Kumar Bangaru
Team Lead at Tech Mahindra, Tech Mahindra Pvt LtdTeam Lead at Tech Mahindra, Tech Mahindra Pvt Ltd
SHASHI SHARMASHASHI SHARMA
Senior Software Test Engineer at Comviva Mahindra (A Tech Mahindra Company)Senior Software Test Engineer at Comviva Mahindra (A Tech Mahindra Company)
Ravi Ranjan OjhaRavi Ranjan Ojha
Lead Software Developer at Tech MahindraLead Software Developer at Tech Mahindra