Project - Market Risk explorer • Analyzing the issue and providing solution in a timely and efficient manner.• Creating dashboards in splunk and making use of Splunk Processing Language (SPL) to understand the capacity and performance of the system.• Effectively using SPL to debug Production issues.• Tuning of SQL queries to reduce response time of the application components.• Effectively made use of SQL Functions, Indexes, Analytical functions, Views, Cursors, Procedures, and Functions.• Analyze issues and propose solutions with issues related to SQL and Python deployments.• Automate the workaround/daily tasks using Linux shell scripting and Python.• Making use of Geneos tool to create pro-active and re-active monitoring based on the production issues.• Making use of Git and BitBucket to deploy configuration related changes in Production.• Contribute in all phases of incident and problem reporting including identification, categorization, and impact assessment.

Project - GCAD (Global Capital Adequacy)• Involved in analysis, design, coding and testing migration of the file based system to database based. • Responsible for creating and modifying database, procedures, functions, triggers as per the requirement given by the user.• Responsible for development of Unix Scripts to automate process such as loading feed files in database, providing feeds to downstream and sending notification to users.• Involved in setting up entity - Nomura Singapore Limited (“NSL”) for Asia region used for MASReporting.• Worked in L3 support for analyzing issues and providing solutions in a timely and efficient mManner.• Creation of Autosys jil and calendar to automate scheduling process.• Code walkthrough and review of documents of peers to ensure adherence to the standards and requirements.• Worked under tight schedules for successful development and implementation

Software Developer/Production Support