PRATIK SAWANT

• Handling critical application in bank Like Access Request management [ARM] / LUAM /RSAM/SPLUNK/3SO Working on Jenkins, Splunk, Autosys for day-to activity
• Enhanced software functionality by identifying and resolving complex technical issues.
• Managed multiple projects simultaneously while maintaining strict deadlines and high-quality standards.
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Trained and mentored junior developers and engineers, teaching skills in deployment purpose and working to improve overall team performance.
• Working closing with dev team for patching activity Hosting sites in windows server in IIS Performing critical activity like DR drill in banks Middleware patching on Windows and Linux OS Writing optimized SQL queries for integration with other applications Designing database tables and structures Working on Critical deployments in windows server, applications servers as well as database server on all the major environment like PROD/DEV/UAT
• MS-SQL 2008 Database Log Shipping for DR Drill Activity
• Conducted thorough testing to identify and resolve bugs, ensuring optimal software performance.
• Introduced automation tools for efficient deployment processes, minimizing downtime during updates.
• Collaborated with cross-functional teams to design innovative software solutions.
• Optimized code performance for improved user experience and system efficiency
• Proactively identified areas for process improvement, implementing changes that led to significant time savings for the team
• Regularly reviewed peers'' code contributions, offering constructive feedback to enhance overall product quality
• Stayed current on industry trends, incorporating emerging technologies into new projects when appropriate

• CTS Image based clearing process which help to manage the clearing on the basis of images not physically or manually, this also support to reduce the time and cost of clearing processing
• This project is started in India since 2006-07 in country capital
• The core bank to start this project was SBI, PNB, Canara and many more that time, now a day’s all the member banks of RBI are using the CTS process to handle their clearing, NCR (National Cash Register) is the only company who introduced and started this project in to our country with the mentioned bank.

Client :Kotak Securities Ltd

· Working on MsSQL server.

· Developing SQL queries for Ad-hoc data which is to be provided of all the applications used in organization.

· Also developing the queries for audit purpose monthly/quarterly.

· Coordinating for Application Support issues with different Application team.

· Ensuring the completion of all business related critical backend task.

· Fixing bugs for critical tasks executed on daily basis.

· Deploying patches on MFund Live and UAT, Taking follow up with vendor and business

· Users for change management.

· Communication between business users and application vendors regarding various application related issue and following with up vendors to gets issue resolved.

· User ID creation and data modification for various internal application of KMAMC.

· Creation of SOP for various new issues face in different application.

· User creation, Hierarchy mapping, RM mapping, Contact upload, Data import in Microsoft Dynamic CRM 2016.

· Device setup and troubleshooting as well as Following up with citrix app support for issue in production environment.

· Providing application support to various critical applications such as HRMIS, Petty cash, ESIC, Intranet, Brokerage, CRM, Treasury Workflow etc.

· Coordinating with vendors, users and internal team for monthly DR activity for critical applications.

• Interfaced extensively with Server team to provide immediate support on technical issues.
• Password Management, Disk Space Management, Media Management,
• Performing SOD & EOD activities.
• Starting the Services on Servers for Establishing Connection between NSE & BSE with HDFC Securities before market opens.
• Monitoring & Sending the Offline Orders, Trade Orders, Market Volume mails for HDFC Securities to the Users.
• Taking Application Backups, Cold Backups, Export Backups, Log backups.
• Site Monitoring of the online trading site for HDFC Securities.
• Monitor Veritas Net Backup version 7.5. Follow up with application owner regarding backup.
• Monitor Autosys Job. If any job fails coordinate with application owner.
• Execute export (Cold backup of respective database) on live server.
• End of day process and Start of day process (EOD/SOD). Maintain all error.
• Following the procedures checklist for daily activities
• Performed root cause analysis on recurring issues, implementing long-term resolutions to prevent recurrence.