Application Support Analyst - Java & SQL Troubleshooter

Name : Sujit K Jadhav

E-mail: **************@*****.***

Phone: +91-814*******

Application Support Analyst

Application Support Engineer with 2+ years of IT experience in L1/L2 production support, incident management, and troubleshooting enterprise applications. Strong hands-on exposure to Java-based applications, SQL-driven data analysis, and UNIX/Linux environments. Actively building backend expertise using Java, Spring Boot, Hibernate/JPA, and RESTful APIs. Known for quick issue resolution, clear communication, and working effectively in high-pressure production environments.

Technical Skills

SQL, Python(Basics), Java, Spring Boot, Hibernate, REST APIs, AWS, Docker

L1, L2 Support, Linux, Azure, DNS

Windows 10, UNIX, IOS, Shell Scripting

Ticketing, Trouble shooting, VLAN

Debugging, Problem solving, API

Manual testing, BMC Remedy

Tools used

Ticketing tools – SalesForce, Atlassian JIRA, BMC Remedy, Azure

Documentation – Confluence, SharePoint, Notepad++ (for reviewing logs/XML)

DB connection: Q-Tools, Jump Box (Like VMWare), Starburst

Collaboration & Productivity – Google Workspace, Slack, Zoho Creator

Monitoring : Conrol-M

Competencies

Technical issues analysis

Application support

Excellent Communication

Decision-Making

Written Communication

Critical Thinking

Analytical and Critical Thinking

Applications / Product Support

Comfortable to work in 24X7 environments on Production Support.

Product / System Support Engineer with proven track of solving product related issues, debugging and monitoring and reactive tracking, log and respond to support tickets

Incident management Leads the Incident investigation and quickly finds out an approach to resolve the problem.

Proficiency in all types of SQL commands, DDL, DML and TCL.

Hands on experience in writing SQL window / Analytical functions.

Data Analysis and Investigation using SQL Select, Aggregate, group by features.

Data Fix such missing values, outliers, using UPDATE, MERGE commands.

Able to write SQL commands including DDL, DML and Select statements

Good with Joins, Aggregate functions and Subqueries

Exposure to Database objects Procedure, functions and packages

Able to work in UNIX environment and identifying and resolving technical issues.

Multipleproducts and sub-products, services and platforms to support

Being at a start-up where everyone knows almost everyone, interacting with each professionally and personally played a major role in the getting the work done.

Primary point of contact for ticket resolutions, data transfer jobs, and morning system availability testing.

Ability to work in teams and independently with minimal supervision to meet deadlines.

Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

Strong management, administrative and leadership skills to work in team.

Manage Incidents and Problems – Triaging, logging, prioritizing, tracking, communicating and resolving, from beginning to end, the resolution of all incoming support requests. Managing ticketed query system and ensuring comprehensive database of queries and resolutions are kept up to date.

Dynamic individual with a positive attitude, good communication, troubleshooting skills, and the ability to think on your feet are key skills for this position.

Professional Working Experience

Working as Application Support Engineer at Scanfii Software Technologies PVT LTD from June 2023

To till date

Roles & Responsibilities (IT-Operations)

Managed and monitored the ticket queue for different projects and distributing tickets to team members based on priority and workload.

Experience in leading or mentoring junior IT staff and team collaboration.

Reviewed business justifications and granting access to required applications.

Reviewing & grading SQL assessments to granting access for Redshift databases. Coordinating with cross-functional teams.

Skilled in creating and maintaining comprehensive technical documentation/ Confluences/KB’s docs.

Performing end-to-end testing of systems from entry to exit to ensure that applications are delivering functionality as expected per documented requirements

Expertise in providing level 1 and 2 technical support for internal or external customers.

Ability to manage IT operations projects, ensuring they are completed on time and within SLA. Experience in ensuring business systems remain operational during outages or disruptions. Experience in analyzing IT operations data to identify areas for improvement.

Project #1: NextGen Service Desktop

Client : EE -UK (Everything in Everywhere) Role : Application Support Engineer

Skills : SQL, UNIX, Java Platform : BMC Ticking Tool

Customer Ticket analysis giving resolution with in defined SLA.

Collaborating with different teams to deliver tasks with quality.

Reviewing and classifying tickets.

Collecting required details in one go to avoid multiple follow-ups.

Verifying details in Omni Assist and mapping clients.

Verifying provided data from users in ‘Business manager’ like DV360, CM360, Meta, Snapchat, Google Ads..etc.

Raising tickets to the performance node team for client onboarding and data ingestion

Applications and database access managed with Okta (SSO).

Performing QA in Starburst to ensure data is flowing properly.

Good understanding of SDLC & STLC and Involved in Manual testing tasks such as Smoke testing, functional testing, integration testing and regression testing, System testing. Having knowledge on performance testing as well.

Resolving issues with clear solutions and documenting issues during QA.

Good understanding of Agile process.

Ticket Analysis and data Fix.

Track, log and respond to support tickets.

Product/ System Support Engineer with proven track of solving product related issues,

Debugging and monitoring and reactive tracking, log (HQ/Adapter/wedge) and respond to support tickets.

Multiple products and sub-products services and platforms to support

Troubleshoot runtime errors and workflow related issues.

Debug and Troubleshoot java-based programs for run time exceptions

Creating RCA document for bugs and working with develops through Jira Items.

Meetset up services they provide Service Level Agreements (SLAs)

Advancedconfiguration changes -Central, IDX, SQL queries and updates -Sometimes saved in JSON/XML.

(Configuration of product based on clients requirements)

Responsiblefor the dealing with the problems, bug fixing and troubleshooting.

Troubleshooting Customer n/w and running diagnostic tools to find RCA.

Playing Key resourceat L2 support b/w customerand Development team

Installing and upgrading product related issues.

Academics:

BE : KLS Gogte institute of Technology Belagavi -2023

PUC : Oxford PU Science College Vijapur -2019

SSLC : Maruti High School Basavakalyan -2017

Personal Information:

Father’s Name : Kalidas Jadhav

Date of Birth : 14/07/2001

Language Known : Kannada, English and Hindi

Contact this candidate