Abhishek Suresh Vaskar
Mumbai
Summary
PROFILE Highly skilled senior implementation engineer with 8+ years' expertise in the IT, banking & payment sector. Track record of successfully leading end-to-end software development projects. Proficient in Oracle 12C, SQL/PLSQL, business analysis, and application support. Demonstrated ability to deliver exceptional results while managing complex technical endeavors.
Overview
8
8
years of professional experience
5
5
years of post-secondary education
Work History
Senior AMS Engineer
Magnaquest Technologies Pvt Ltd
05.2022
- Responsible for developing and customizing application modules
- Resolve production issues by modifying back-end code as needed
- Perform DML and DDL operations based on business requirements
- Analyze and implement data to generate daily, weekly, monthly, and quarterly reports
- Createvariousdatabaseobjects,suchastables,views,indexes,sequences,storedprocedures,andfunctions
- Gather client requirements, plan their implementation, and deliver the solutions
- Take ownership of the entire application life cycle
- Prepare Business Requirement Documents through discussions and processes
- Coordinate with the development team to meet project requirements from clients
- Conduct comprehensive testing of new requirements from start to end
- Implement changes in the live environment
- Create business reports in the system for various purposes
- Configure the system through the GUI to accommodate new requirements.
Deputy Manager
HDFC BANK LTD
02.2021 - 05.2022
- Responsible for overseeing all system changes
- Retrieving data from SQL based on team requirements
- Acting as the primary point of contact for system changes and SQL queries
- Compiling and preparing the system control report on a monthly basis
- Monitoring the functionality of system deviations to ensure proper operation
- Leading the analytics function in RIC and continuously evaluating RIC processes, strategies, and policies for the pan India regional team, and implementing necessary changes
- Enhancing and reviewing internal risk system controls
- Resolving any issues related to database usage
- Managing responsibilities for automated processes such as allocation MIS, YTD, etc
- Creating a monthly fraud scorecard after the Analysis of System Controls
- Utilizing the Jira bug tracking tool to report issues and submit requirements for new features or modifications to existing ones
- Collaborating with the Development team to create reports for the business teams.
Executive
Ingenico ePayments India Private Limited
06.2018 - 02.2021
- Resolving queries related to ECS, EBPP, and DDT applications and providing backend support to various teams, including Transaction Processing, Development, and Customer Support teams
- Using the CR Tracker application to raise and track ticket requests to the technical team for issues related to ECS, EBPP, and DDT applications
- Communicating with the tech team to facilitate the resolution of these requests
- Automating MIS reports using batch files and SQL stored procedures and delivering them to respective teams upon request
- Implementing business logic, designing SQL queries, utilizing Import and Export Wizard, employing BCP utility, creating and altering stored procedures on SQL server
- Acquiring knowledge of defect tracking software JIRA
- Performing Autopay Amount updation by utilizing Bat files with sqlcmd utility and SQL queries
- Creating Bat files for backend status upload of Direct Debit status using sqlcmd and stored procedures
- Handling stop transaction requests received from the transaction team through bat files using sqlcmd utility and SQL queries
- Uploading advance status received from locations directly into the system through bat files using sqlcmd and stored procedures
- Generating payment reports, including advance payment reports, by fetching data from the system with bat files and providing it to clients using sqlcmd utility and SQL queries
- Scheduling the deletion of invalid MICR records in the system through bat files using sqlcmd utility and
- SQL queries.
Executive
Yes Bank LTD
02.2017 - 06.2018
- Workingextensively withthe Finnone applicationandproficient inwritingSQLqueries in MSSQLServer& Oracle SQL Developer
- Familiar with the disbursement flow of various Retail Assets Loans, including Auto, Personal, Business
- Commercial Vehicle, and Construction Equipment loans
- Prepared UAT testing scenarios and conducted testing to ensure smooth system functionality
- Providing sign-off for moving successfully tested issues or enhancements to the production (Live) system after UAT
- Collaborating with senior database developers and management on various tasks
- Demonstrating competence in Unix/Linux systems
- Acting as the primary point of contact for all SQL support queries
- Well-versed in major LMS functionalities like repayments and insurance
- Familiar with other modules in the Finnone application, including CAS (Credit Assessment System), etc
- Proactively following up with the TSG team (Technology and Solution Group) to ensure quick resolution of any project-related issues
- PROJECT
Education
Master of Science - Information technology
Idol College of Mumbai University
07.2022 - Current
Bachelor of Science - Information Technology
College Of Arts, Science
07.2013 - 07.2016
Skills
- Microsoft Office
- Jira
- Oracle/Sql
- Business Analysis
- Leadership
- Software Testing
- COURSES SQL, Seed Infotech
- Oracle DBA 11G, Seed Infotech
- Data and Analytics
- Technical Design Documentation
- Business Processes and Procedures
- UAT Support
Work Preference
Work Type
Full TimeLocation Preference
On-SiteImportant To Me
Work-life balanceCompany CultureCareer advancementPersonal development programsTeam Building / Company RetreatsCertification
- ORACLE SQL
- ORACLE DBA
Awards & Recognition
• Received a certificate for participating in the Story Writing competition at HDFC Bank.
• Received the Best Team Player award at Ingenico E-payments Services Ltd.
• Received the Flawless Execution award at Ingenico E-payments Services Ltd.
• Received the Successful Transition award at Ingenico E-payments Services Ltd.
• Received the On the Spot award at Ingenico E-payments Services Ltd.
Timeline
Master of Science - Information technology
Idol College of Mumbai University
07.2022 - Current
Senior AMS Engineer
Magnaquest Technologies Pvt Ltd
05.2022
Deputy Manager
HDFC BANK LTD
02.2021 - 05.2022
Executive
Ingenico ePayments India Private Limited
06.2018 - 02.2021
Executive
Yes Bank LTD
02.2017 - 06.2018
Bachelor of Science - Information Technology
College Of Arts, Science
07.2013 - 07.2016
Similar Profiles
VISHAL ANAND POTTIVISHAL ANAND POTTI
Software Engineer at Magnaquest Technologies LtdSoftware Engineer at Magnaquest Technologies Ltd
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
S ChetanS Chetan
Assistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt LtdAssistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt Ltd
Shikha NishadShikha Nishad
Director of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt LtdDirector of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt Ltd
Priti SharmaPriti Sharma
Senior AVP (Senior Business Executive - Consultant), Audit and Governance at Wells Fargo International Solutions Private LimitedSenior AVP (Senior Business Executive - Consultant), Audit and Governance at Wells Fargo International Solutions Private Limited