Bhavin Tanna

About Bhavin Tanna

Senior Techno Functional enthusiast currently working as a Vice President in JP Morgan having16+ years of experience in the IT Industry with expertise in Oracle DB and Data Analysis.Technical Skills - Oracle Databases (9i, 10g, 11g, 12c, 19c), Microsoft SQL Server (2008, 2014, 2019), Sybase SQL. Tableau, Alteryx, UNIX, Crystal Reports, Oracle D2K Forms. SQL, Oracle PL/SQL, UNIX Shell Scripting, Transact-SQL Server, VB Scripting languages. PL/SQL developer, Toad, Rapid SQL, SQL Server Studio. Microsoft Excel, Visio. Control M Enterprise Manager, SAP Business Objects CMC. Messaging systems - EMS, OMB and Kafka. Tortoise Sub Version (SVN), Git Bitbucket, MS Visual Source Safe, IBM Rational ClearCase, FishEye Crucible. TeamCity, Jenkins, SonarQube, AppDynamics, Splunk. JIRA, HP Service centre, HP Quality centre, IBM Clear Quest. Well versed in the Scrum Model Agile methodology - Scrum Member and Scrum Master in the Team, focusing on ‘Test Driven’ and ‘Behavioral Driven’ Development (TDD & BDD) following SOX compliance. Relevant exposure to industrial processes like SLA (Service Level Agreement) based approach, RFC (Request for Change), RCA (Root Cause Analysis), CAB (Change Advisory Board).Functional Expertise - Experienced in IT Business Analysis, Data Analysis, GAP Analysis and creating BRD, FRD, Technical Designs, Test Strategy / Planning, Traceability matrix, training material and uploading them on SharePoint / WIKI pages for the benefit of End Users / IT Teams. Well versed with OTC Derivatives Trade Lifecycle Management –o Products - Rates - IRS, OIS, CCY/CCBS Swap, Swaption, IRG, FRA, etc. Credits - CDS and CD Swaptions Exotics, Equities, Commodities and Bondso Trade Execution at SEF (Swaps Execution facility) venues -Tradeweb, Bloomberg or MarketAxess.o Trade Affirmation / Confirmation platforms - MarkitWire, DTCC.o Clearing Houses - ICEClear, ICETrust, LCH, EUREX, JSCC or CME.o Front Office and Back Office RMS - Risk Management Systems.o Cash Settlement process via payments to Clients and Brokers.o Dealer to Client, Dealer to Dealer, Inter-Book, Inter-Company and Back-to-Back 3-way Switch Ticketing Trades.o Life cycle events - Execution, Affirmation, Clearing, Allocations, Novation, Netting, Compressions, Maturity or Termination.o Trade flow through Exchange connectivity via SWML, XML, JSON, CSML and FIX protocol.o Market Driven Derivatives Regulatory reforms (DRR), Dodd Frank (DF), European Market Infrastructure Regulations (EMIR), Markets in Financial Instruments Directive (MiFID2) and BREXIT.

Experience

1. Vice President

   JPMorganChase

   Jun 2023 — Present · Mumbai, IN

Education

• Terna Engineering College

  Bachelor of Engineering (B.E.), Electronics and Telecommunication

  2007

• National Education Society's Arts, Commerce & Science College

  HSC, Science

  2003

• Don Bosco High School - India

  SSC, Primary School

  2001

Skills

• Baan Erp
• Software Development
• Microsoft Excel
• Testing
• Tia
• Project Management
• Agile Methodologies
• Unix
• Oracle Forms
• Business Analysis
• Oracle Sql
• Sdlc
• Oracle Pl/Sql Development
• Oracle
• Requirements Analysis
• Performance Tuning
• Oracle Sql Developer
• Pl/Sql
• Maximo
• Sql