Job Search Status
Open to workDesired start date: Open to discussion
Desired Job Title
IT Application Support and Management SpecialistWork Type
Full TimeLocation Preference
On-SiteRemoteHybridLocation: Mumbai, MH
Open to relocation: Yes
Open To Work
Verified
This profile is verified using an email address.
Prasad Patil
Nandurbar
Work Preference
Summary
Detail-oriented IT and Database Analyst with nearly 5 years of experience in SQL (Oracle), production support, incident management, and database operations. Proven skills in analyzing complex issues, reducing incident resolution time, and delivering system enhancements while ensuring data integrity and stability. Committed to leveraging AI tools for improved SQL productivity and automation.
Overview
5
5
years of professional experience
Work History
IT Application Support and Management Specialist
Saksoft Limited
Mumbai
01.2022 - Current
- Providing mission-critical application and production support for core banking applications and databases, ensuring high availability, reliability, and performance.
- Managed end-to-end application enhancement lifecycle from requirement analysis to deployment, resulting in a 10% increase in user productivity.
- Leveraged advanced SQL (Oracle) for real-time data analysis, performance tuning, and critical production fixes (DML operations) on multi-terabyte databases.
- Reduced incident resolution time by approximately 1.5 hours, consistently maintaining >95% customer satisfaction (SLA adherence).
- Conducted root cause analysis (RCA) on recurring production issues, implementing preventive measures that reduced high-priority incidents by 25%.
- Acted as a project coordinator for support initiatives including patches, upgrades, and migrations, ensuring on-time and within-budget delivery.
- Designed and executed functional and regression testing, identifying and tracking 50+ critical defects, ensuring high-quality releases.
- Collaborated cross-functionally with business stakeholders, development, and infrastructure teams to translate production insights into actionable enhancements.
- Developed and optimized complex SQL queries and data workflows, improving operational efficiency and minimizing data inconsistencies.
- Ensured data integrity and accuracy through validation, monitoring, and continuous improvement of data processing pipelines.
- Conducted data analysis using SQL techniques and report generation for business requirements.
- Executed data extraction, transformation, and loading processes for banking modules, ensuring accurate and timely data delivery.
- Automated manual tasks using SQL scripts and Excel Macros to improve efficiency.
- Supported in preparing test scenarios, executing test cases and documenting defects.
- Client HDFC Bank Ltd
Education
B.E. - Electrical Engineering
North Maharashtra University
JalgaonJalgaon
Diploma - Electrical Engineering
MSBTE
MumbaiSkills
- SQL and Oracle expertise
- Database querying and maintenance
- Performance optimization
- Data integrity and validation
- Incident management
- Root cause analysis (RCA)
- Quality assurance processes
- Automated testing strategies
- Application lifecycle management
- Agile project management
- Requirements gathering
- Configuration management
- Project coordination
- Business analysis
- Customer relations
- Teamwork
- Application support
- Application monitoring
- Issue resolution
- Workflow improvement
Ai Tools And Sql Productivity
- AI-Assisted SQL Querying: Using ChatGPT and GitHub Copilot to generate, optimize and explain complex SQL queries.
- Code Explanation & Debugging: Leveraging AI tools for quick understanding of SQL errors, performance bottlenecks and suggested fixes.
- Automation Ideas: Using AI to create SQL scripts, test cases and documentation templates.
- Other Tools: ChatGPT, GitHub Copilot, Google Gemini
Timeline
IT Application Support and Management Specialist
Saksoft Limited
01.2022 - Current
B.E. - Electrical Engineering
North Maharashtra University
Diploma - Electrical Engineering
MSBTE