Samim Shaikh

.Provide 24*7 Production Support for Trade Finance Application System.
.Wrote and optimized complex SQL queries to validate business transactions and reconcile trade data.
.Use PL/SQL procedures and joins to extract and analyze trade and payment details during incident investigation.
.Developed Shell Scripts to automate routine production tasks,log analysis,batch monitoring
.Used Dynatrace to analyze performance metrics,Identify memory leaks and prevent outage.
.Managed Autosys Jobs Chains,Ensuring successful EOD/BOD batch runs.
.Handled Incident and problem management through servicenow,providing RCA and Implementing permanent fixes.
.Used CyberArk for secure privileged access and credential management across servers.
.Managed Server patching and post-deployment validation to maintain system security and production uptime.
.Monitored Linux servers,database sessions,and application logs to identify potential failures.

.Troubleshot incidents in production environments, restoring system stability and minimizing downtime.

.Collaborated with cross-functional teams to resolve application issues, enhancing overall operational efficiency.

.Monitored system performance, identifying and addressing potential areas for improvement to optimize application reliability.

Broadridge(Client) - Production Support Engineer

Bangalore, India

07/2020-12/2024

• Utilized SQL for data extraction, transformation, and loading(ETL) processes, ensuring data integrity and accuracy.

• Developed SQL queries with Joins, Subqueries, and viewsto extract data from the database and generate reports for client distribution.

• Experienced in writing PLSQL Procedures, Functions, Triggers, Cursors, Collections, Packages, and Dynamic SQL.

• Performed database performance tuning and optimization using SQL scripts and queries.

• Handled incidents and major incidents (MIM).

• Identified defects, worked with vendor andproject management team on code changes and a new fix in the upcoming Release.

• Thisresulted inincreased efficiency in batch processing withno errors or missed transmissions, thus reducing the number of incidents.

• Analyzed logs from multiple sources to identify patterns or trends in system behavior.

• Performed troubleshooting tasks on complex distributed systems.

• Established runbooks for each exercisetoensurethatthefailover procedures were accurate and repeatable, and that theassociatedrisks were minimized.

• Handled andassisted in the resolution of high-priority production issues by reviewing large server logs.

• Usedmonitoring technologies tomonitor batch processes(Control-M).

• Run UNIX commandsand Shell Scripts to automate repetitive tasks, such as backups and monitoring system resources.

• Developed scripts for automation of routine operational tasks such as backups, Deployments ,monitoring.

• Assistedinthedeployment of new releases intoproduction environment.

• Implementedchange management processes to ensure consistency across environments.

• Performedroot causeanalysis (RCA) toidentify underlying causesof incidents.

• Participatedinpost-incident reviewstodocument lessons learnedfrom outages and failures.

• Worked closely with other teams toresolve cross functional issues.

• Generated reports onsystem availability, performance metrics and SLAs compliance.

• Provided first-level support to end-users for hardware, software, and network issues.

• Resolving 80% of tickets at the first point of contact by effectively diagnosing and troubleshooting.

• Identified root cause of incidents and problems and implemented appropriate solutions accordingly.

• Logged and tracked incidents in ITSM tool (ServiceNow), ensuring resolutions met SLAs.

• Escalated complex technical issues to L2/L3 teams with proper documentation and follow-up.

• Collaborated with cross-functional teams to resolve customer inquiries effectively.

• Monitor system health and performance using standard monitoring tool like (IRTS).

• Created detailed reports on system performance metrics for management review, aiding in strategic decisions.

• Identify recurring issues and suggest process Improvements to reduce ticket volume.

• Generate periodic reports on incident trends and resolutions to aid in decision making.