Siddhesh Chaudhari
Pune
Summary
Dynamic and motivated to software developer with almost 3 years of proficiency in SQL, Informatica, Linux, Shell Scripting and coupled with a foundational understanding of ETL processes. Eager to leverage technical expertise to contribute to innovative projects and solutions in a collaborative team environment.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Production L2 Support Analyst
TATA Consultancy services Ltd
Pune
05.2022 - 01.2025
- Company Overview: BFSI US EAST Banking Client – Asset Management, and Staff Selection Technology.
- Application Support (24/7): Conducting health status checks for 240+ banking applications, which involved maintaining the servers (Linux, Windows, Apache) and services.
- Providing user support to application users by providing a resolution for the problems raised by users.
- Validating the applications, implementing change requests, and patching.
- Utilized technologies to check the application health status: SOUP UI, Dynatrace, Mobaxterm, Windows Server, Grafana, and PowerShell scripts.
- ETL Production Support: Utilized Informatica tools (Developer, Manager, Monitor) to troubleshoot Informatica ETL issues, identify performance bottlenecks, manage blocking sessions, and perform SQL tuning.
- Collaborated with the Database Team for performance tuning at both the Informatica and database levels.
- Actively monitored Hadoop ETL batch jobs in Hue and IBM z/OS, identifying error logs, troubleshooting, performing root cause analysis, and resolving incidents within SLA timelines.
- – Handled P1 and P2
- Supported mainframe applications by regulating and monitoring the mainframe production batches, doing the log analysis, and resolving the job abends.
- Collaborated with an agile team of six, and helped prioritize and scope feature requests to ensure that the biggest-impact features were worked on first.
- Developed and updated JSON script code to validate the application health status using the Rest API, ensuring robust monitoring and proactive identification of potential issues.
- Used the ServiceNow ticketing tool for handling incidents and change tasks.
- Worked as an SRE on call for supporting the application 24/7.
- Utilized Jira for vendor new connections and issue resolution, effectively managing communication and collaboration with external vendors to ensure timely resolution of issues, and smooth integration processes.
- Mainframe Support: Supported mainframe applications by monitoring production and lower environment batches, analyzing, and resolving abends.
- Worked with the L3 team for further troubleshooting of jobs, using performance tuning and issue resolution methods.
- Continuous tracking of applications' performance to ensure it works efficiently.
- Assisting users with issues and questions related to the mainframe.
- Generating reports and maintaining up to date documentations and configurations for further understanding of issues in future
- BFSI US EAST Banking Client – Asset Management and Staff Selection Technology
- Developed a PowerShell script Cron Job to delete the server logs older than 60 days to clear up the space in the server
- Created knowledge base articles for recurring issue resolutions to support the team
- Automation of restarting the failed services whenever it goes down through a PowerShell script
- Created Dynatrace Dashboard to view active problems of 240 applications under single dashboard easing the process of monitoring
- Created ETL workflows as per business requirements using Informatica power center and Toad oracle
- Created dashboards in ServiceNow to report on monthly team workaround issues and presented KPIs to clients
- Created KPIs of weekly and Monthly basis using Advance excel and PowerPoint and presented it to the clients to analyze the recurring problems and key highlight
Education
Bachelor of Engineering - Mechanical Engineer
Savitribai phule pune university
01.2021
Diploma - Mechanical Engineer
J.T. mahajan polytechnic
Faizpur01.2018
SSC -
Smt. P.K.Kotecha highschool
Bhusawal01.2015
Skills
- Informatica
- Autosys
- Python
- Shell scripting
- PLSQL
- SQL
- Oracle
- Git
- Bitbucket
- Linux
- Windows Servers
- Unix
- ServiceNow
- Jira
- Big panda
- Dynatrace
- New relic
- Grafana
- Splunk
- Kafka
- Toad
- Confluence
- SharePoint
- Mabaxterm
- Power BI
- Office 365
- ITIL processes
Certification
- Python – Udemy
- Informatica - Udemy
- ITIL 4 Foundation – Udemy
- Business Communication – Udemy
- Gen AI – E1 Competency in TCS Evolve Learning platform
Languages
- English
- Hindi
- Marathi
Reporting and Analysis
- Created dashboards in ServiceNow to report on monthly team workaround issues and presented KPIs to clients.
- Created KPIs of weekly and Monthly basis using Advance excel and PowerPoint and presented it to the clients to analyze the recurring problems and key highlight.
Value Adds
- Developed a PowerShell script Cron Job to delete the server logs older than 60 days to clear up the space in the server.
- Created knowledge base articles for recurring issue resolutions to support the team.
- Automation of restarting the failed services whenever it goes down through a PowerShell script.
- Created Dynatrace Dashboard to view active problems of 240 applications under single dashboard easing the process of monitoring.
- Created ETL workflows as per business requirements using Informatica power center and Toad oracle.
Timeline
Production L2 Support Analyst
TATA Consultancy services Ltd
05.2022 - 01.2025
Bachelor of Engineering - Mechanical Engineer
Savitribai phule pune university
Diploma - Mechanical Engineer
J.T. mahajan polytechnic
SSC -
Smt. P.K.Kotecha highschool
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Aditya SurgadeAditya Surgade
Game Tester 2 at Electronic ArtsGame Tester 2 at Electronic Arts