SureshKumar Kothandan

• Provided L2/L3 support at production level for Randstad's internal RDirect web and Paybill applications to ensure uninterrupted operations.
• Optimized long-running SQL queries, enhancing overall database performance.
• Maintained and developed SQL stored procedures, joins, and triggers to streamline data processing workflows.
• Developed backend reports using SQL query techniques based on specific business requirements.
• Developed the SQL stored procedure and Designed user interfaces for repeated service requests.
• Participated in successful migration of databases from SQL Server to PostgreSQL while safeguarding data integrity and minimizing downtime.
• Achieved 30% reduction in downtime by addressing critical production incidents using advanced L2/L3 support methods and ServiceNow monitoring tools.
• Collaborated with various stakeholders to gather detailed requirements for delivering appropriate solutions.
• Supported the team by completing daily operational tasks to enhance efficiency.

• Worked as an L2/L3 Application Support at Production level for Randstad internal RDirect Web and Paybill Windows applications, ensuring seamless daily operations.
• Optimized long-running SQL queries and execution plans to enhance application performance.
• Monitored and optimized long-running SQL queries to improve performance.
• Prioritized and developed the SQL Stored procedure and designed the UI for the repeated service request raised from business user Built and enhanced database components including complex joins, stored procedures, and triggers.
• Developed SQL queries, including joins, stored procedures, and triggers to support application functionality.
• Created backend reports utilizing SQL queries based on business requirements.
• Developed and implemented Selenium-based automation using eclipse Java/Javascripts to extract reports from web applications and deploy them to designated server locations, ensuring seamless unattended execution through Windows Task Scheduler.
• Reduced manual workload and improved reliability and timeliness of report delivery.
• Managed employee lifecycle workflows, including onboarding, payroll processing, and exit management, to ensure smooth transitions.

• Leveraged L2/L3 support skills to resolve production incidents effectively.
• Delivered application support for Randstad's RDirect web and PayBill Windows applications.
• Provided technical support for software applications, improving user satisfaction and performance.
• Worked with development teams to troubleshoot and resolve application performance issues.
• Optimized response efficiency by managing user requests and assessing ticket priorities.
• Facilitated communication with stakeholders and business users to gather requirements.
• Generated reports via SQL querying to access backend data aligned with business needs.
• Created PowerShell dashboards for monitoring remote server services efficiently.

• Implemented microservices and containerization in collaboration with cross-functional teams to boost deployment scalability.
• Oversaw commissioning of project site and installation of Siemens software as per specifications.
• Led a team of four, ensuring successful project execution.
• Developed key documentation including functional design specifications and risk assessments.
• Engaged with clients and stakeholders to synchronize business development goals.
• Focused on enhancing customer satisfaction to drive loyalty and engagement.
• Adapted strategies after conducting detailed analysis of business metrics.

• Facilitated project site commissioning, ensuring operational readiness for project launch.
• Installed and configured Siemens software as per the requirements.
• Established the server-client architecture.
• Administered Symantec Antivirus. Designed and implemented the Active Directory Domain Controller (ADDC).
• Executed ADDC migration using ADMT, creating and implementing GPOs to enhance client system management.
• Performed remote push of antivirus client packages and GPOs from the respective servers.
• Installed and configured RAID in Fujitsu server-grade systems as per project requirements.
• Upgraded Windows 7 OS to Windows 10 OS and Windows Server 2008 R2 to Windows Server 2016.
• Installation and Configuration of PALO-ALTO Firewall switch as per the Business and project requirement.
• Ensured regular backups for production systems and databases to protect data integrity.
• Set up the WSUS Server and install the Microsoft patches as per the software and windows compatibility.
• Setup the NAS Server for maintaining the project backup.
• Set up and configured network switches to optimize connectivity and performance.
• Creating the Reports for the business requirement using the XL Reporter.
• Installation, Configuration and Migration of Reporting software.
• Prepared Project document (Functional Design Specification, Installation and Operational Qualification, Risk Assessment, SOP)

Assisted with various support activities

• Designed, developed, and maintained the central servers.
• Installed and configured Unix/Linux Server of central servers.
• Installed and configured the VM system (Oracle VirtualBox).
• Maintained the VM system backup.
• Designed and established network and client-server architecture, enabling secure internet access to central servers.

• Worked as a L1/L2 support engineer at client office Cognizant.
• Provided technical support and Managed Incident Management and Change Management and Prioritized using BMC IT Ticketing Tool
• Resolved technical issues for VIP users using remote management tools, minimizing project impact and ensuring timely support.
• Executed configuration and troubleshooting of email accounts, enhancing user accessibility and communication.
• Installed, configured, and troubleshot applications such as Oracle and SQL Server databases.
• Maintained SCCM and McAfee compliance at 98% as per SLA targets, ensuring system security and reliability.
• Implemented routine activities such as user data backup and restore.
• Guided engineers on critical incidents and provided support to resolve the issues.

Assisted with various support activities

• Supported the BCP projects setup.
• Performed the project setup based on the clients and business requirements.
• Retrieved and displayed R60 incident closure data and maintained the above-closure average.
• Provided training for engineers on SDLC.
• Knowledge on AppV software implementation.
• Audited incident requests and provided CAPA for necessary requests.