Ajay Singh Sikarwar

Projects MARKET DATA SUPPORT (10/2020 – PRESENT)

• Project focuses on managing golden source application responsible for integrating static referential and market data (prices) of listed products into banks system after capturing them from market data providers like Reuters and Bloomberg to be utilized by FO booking applications as underlying data for derivative trades, acting as upstream to FIC and EQD scope booking apps plus market, credit risk computation engines
• Continues integration, consolidation distribution( replication notification/publication) of static data and prices 24X7 to downstream
• Static data and prices notification also happening in request/reply mode on demand
• Clients can even requests data via rest API call, gateway bridge to hit load balanced cloud servers
• Apart from integrating prices from market provider application integrate prices of some derivative product contributed from internal risk computation engines too
• App also facilitates integration of newly created bond, warrant, structured product and other products from different app system/portal to its system, there are in-house tools and applications which creates product using market provider info and same sent for integration into this application
• For bond, convertible bond, structured product this application acting as cash flow computation engine based on static data from market provider, prices and dll library functions and parameters from referential and booking in-house apps

Roles and responsibilities

· As a senior resource & spoke responsible for monitoring health of services in production.

· Performing sanity checks database and unix servers to monitor health of replicator notifier services

· working in sync with operations team to resolve data quality issues with appropriate actions from IT end for serving FO, Risk, Traders, Sales ,risk indictor certification teams.

· Updating KEDB with encountered issues and their workarounds.

· Creating ,updating SOP,POC for procedural tasks ,Manual procedures and production known workarounds.

· conducting weekly governance call with operations team explaining global prod status, discussing ongoing incident & requests

· Having weekly call with dev discussing open problem tickets weekend activity (infra weekend ,DR exercise, other migration activities etc.) open incident (functional ,technical) on IT (prod + dev) side.

· working upon & chasing with different stake holder teams for resolving incidents ,creating JIRA's assigning to Dev for issues to be addressed by them.

· Working as spoke/lead during live production incidents in collaboration with operations team acting as owner, accountable from IT side by engaging various stake holders teams to resolve prod issue ASAP with minimum or zero business, operational ,opportunity loss in terms of end user business.

· Acting as release gate keeper for new enhancement ,bug fixes delivered in production by thoroughly going through release document doing impact analysis identifying changes elements and modules which can directly impact production and challenging dev to put additional checks and corrective measures to minimize major incident due to release or its regression as root cause improvising/optimizing overall KSI of application or project.

• Collaboration with the development, business analyst, application users in assisting the release management process
• Adhering to the ITIL workflow in product deliverables, backlogs clearing, client focused service.

Projects

Counterparty Credit Risk

• Project deals with applications responsible for calculating, monitoring, governing credit risk indicators also responsible for limit allocation, overshoot monitoring during market activities ensuring availability of same during trade booking
• CCR project consist of four business processes/chains CVAR, CVA, B2T, EEPE each chain have defined SLA with business in terms of availability of final risk indicator computed figures to FO, Risk
• CVAR complete chain can be majorly classified into 2 parts 1st computing CCR 6 risk indicator exposure, available limit figures, certified by operations team to be used by Risk, FO for accounting and PNL purpose, same to be used by real-time trading desk to clear go/no go available limit check on a particular business line, booking zone, risk monitoring structured level for a particular counterparty
• CVAR computation provides exposures up to precision of deal level to trader & sales helping them in estimating live available limits on entity/counterparty/master/CSA/deal level, on booking tool side before booking trade there is a compulsory check done to know available limit for that counterparty on deal level if available limit overshoots FO not allowed to book trade need to go for 1 off approval with risk
• CVA-It's a fee to hedge the position of trade collected from client with that money CVA desk traders buy CDS to hedge position
• B2T regulatory Weekly and monthly running process mainly computing two risk indicators IRC (incremental risk charge) and CRM (Comprehensive risk method)
• EEPE regulatory monthly batch which computes risk weighted assets in banks basket plus Expose at default

Roles and Responsibilities

• Provide end to end support on the Counterparty credit risk applications. Responsible to monitor the daily production batches and fix all the issues encountered by doing detailed technical analysis and code debugging to deliver the CVAR and CVA figures within the SLA.

• Utilized knowledge of SQL and Unix/shell scripting to troubleshoot and fix the batch technical issues, resolving queries from traders, users, stakeholders relating to applications, ability to perform root cause analysis.

• Working on SR tickets and functional incident tickets raised by business and stakeholders and provide the resolution on time.

• Conducting routine system health and infra checks using the tools like (MARPE, MARLYN and SVCMON)

• Analyzing and debugging the daily PnL risk profiles functional issues reported by business, provide the satisfactory explanation and solution on time to save the batch data quality and reduce the business impact.

• Positive involvement and coordination with Development during change releases in production environment, helping them in performing code release deployment on the applications, clearing production environment, performing health check activities post release.

• Identifying the issues in application functionalities and raising it to development team for permanent fix with problem ticket to track the status.

• Suggesting process improvement plan, deeper analysis on batch performance issue and provide continuous feedback to development team to improve the process, logging mechanism and application monitoring and ensure it is implemented and enhanced the efficiency, reduced work done by support team.

• Prepare KEDB for resolving the production issues quickly to avoid unauthorized or dangerous workarounds in support activities. Prepared documents and knowledge articles for support engineers, stakeholders for reference.

• Anticipating productions issues and taking effective prompt action. Communicate workarounds to be followed to team till the production issues gets resolved. Raising issues to development team and follow up with them closely for permanent fixes.

• Conducting weekly incident/problem management calls with development team/stakeholder. Engage with them to track the status of the problem tickets and release to fix outstanding production issues.

• Working on critical incidents, providing end user communication for service delays/disruption with ETAs. Send daily production status communication report to global support team and business and CRM team.

• Doing pre-approved releases, creating templates for outage communications and releases to notify all the users and stakeholders during releases and incidents.

• Handling production governance meeting with business and stakeholders to present weekly production status. Present and discuss on all production issues reported, issue resolution, permanent fixes, Root-cause analysis, operational/business impact.

• Actively participated in DR and weekend infra-activities
• Creating impact analysis sheet, disaster recovery plans, infra health check documents and share it with the team
• Identifying the repeated manual actions done by PRD team and exploring the way to automating the task.

Projects

Transversal services management

• Under RRF department we have applications which were managing computing, certifying governing market, credit risk for investment bank plus we have applications which are computing accounting, PNL figures, computing liquidity figures for bank SGCIB
• Bacardi application computes PNL & VAR figures for Equity derivative scope of trades for SGCIB-basically it is one of market risk indicators computing engine SG have for equity derivative scope
• As a part of it contributed to UAT environment
• Project name-'Easy Desk migration', category- 'development project' project for migrating desks from 1 to another building in Paris (including all desk assets)

Roles and Responsibilities

Joined S.G. in October 2012

• as a part of TSM tem member use to manage technical & infrastructural services of applications under RRF department

• started working in RRF/TSM/PPS for bacardi application preproduction support

• As a part of preproduction support for bacardi application we use to perform sanity checks ,heath check of GUI interface (To check for status of jobs ,commands launched by Dev team previous night)

• Database Health check ,refreshes from production environment.

• Perform same checks for R&D ,Homologation ,QA environment including Dev Env.

• From April to June 2013 worked with project team responsible for developing tools for facilitating ,catering production services

• Contributed to the development of the basic module of insert, update, delete and navigation through pages on UAT (as a part of it worked on technology PHP, MYSQL, JSON, tools-SQL YOG, Eclipse
• WAMP(hosting local host apache and tomcat server)).