Sanket Mandare

About Sanket Mandare

Specialized and experienced in Analytics, Currently I\'m working as a Lead - Validation…

Experience

1. Application Support Analyst

   CGI

   Mar 2022 — Present

   Worked in sprints to conduct end-to-end testing of monthly releases for both technical and functional upgrades well as Ad-hoc requests. Owned multiple on-prem workstreams in lower environments and responsible for creating a test plan, execute testing by configuring the data and files specific to the workstream and running related Autosys jobs and monitor successful transfer of information either through vending or file transfers to mimic production like environment and functionality to keep system up and running. Construct and execute SQL queries in TOAD and DBeaver on Oracle/Netezza DB to manipulate/update data sets required to push the process and generate accurate data through processing for downstream consumers for monthly weekly and bi-weekly processes. Responsible for Unix Shell Scripting in putty by identifying the initiatives and application on respective servers based on testing to perform SCP, Trigger Vends and ESB Adapters, Create/Modify/Move files and run respective AutoSys jobs to ensure smooth functioning of applications. In-depth understanding of ticketing system and created JIRA and My Services tickets to the team specific to situations, requirements and applications to fix issues, DB backup and Modifications and reporting incidents and issues. Worked on multiple Software applications like TIBCO to monitor and restart vending services, Informatica to monitor the active workflows and failures, EMS to publish messages and subscribe to Queues and Topics specific to testing along with various applications. De-bug failed jobs by monitoring and analyzing the root-cause, checking for workflow logs and sessions logs to identify issues like incorrect data types in backend, memory space issues and throughputs as well as from performance stand point to provide real-time accurate data to downstream consumers in production and connect with development teams if needed.