Talk to sales Try for Free
Ajay Swarnkar

Ajay Swarnkar

location of Ajay SwarnkarDelhi, India

Connect with Ajay Swarnkar to Send Message

Connect

Connect with Ajay Swarnkar to Send Message

Connect

  • Timeline

  • About me

    Associate Director Business Analyst at OSTTRA

  • Education

    • Govt Sr. Sec. School, Hindaun City,Rajasthan

      2003 - 2004
      +2 Mathematics and Computer Science

      Completed my higher secondary.

    • University of Rajasthan

      2005 - 2008
      Bachelor of Engineering (B.E.) Electrical, Electronics and Communications Engineering

  • Experience

    • Tata Consultancy Services

      Nov 2008 - Jan 2013

      Software development and support for ING Bank netherlands Initial Training and professional building program.

      • Software Developer

        Jan 2009 - Jan 2013

      • Initial Learning Program

        Nov 2008 - Jan 2009

    • ING Nederland

      Jan 2013 - Sept 2015
      Business Analyst

      Business analyst in Treasury Market.- Requirement Gathering.- Solution Design- Release and Change Management- End to End software deployment- Analysis, Development and unit testing

    • Tata Consultancy Services

      Oct 2015 - Aug 2017
      Business Analyst

      Working as Business Analyst in Corporate Action (Financial Market) Domain.

    • Royal bank of scotland

      Aug 2017 - Dec 2018
      Senior Business Analyst

      Project 1: Migration of Treasury business from NRFB to RFB Part of UK regulatory requirement Royal Bank Of Scotland is bringing its retail and investment bank as standalone entities. Collaboration of treasury assets on single technology is key deliverable of this project bringing all Treasury Business from different trading platforms to Murex. My Role in project included - Create migration approach and strategy, co-ordinate with all stakeholders and perform impact analysis Create and Execute program Runbook involving 20+ IT systems and 100+ Business and IT stakeholdersDeveloped migration script using MxML in MurexProject 2: Libor TransitionThis is one of the Major UK banking project to move from LIBOR rates to more risk free rates like SONIA, SOFR Perform impact assessment of treasury IT system for moving from Libor interest rates to more risk free rates like SONIA or SOFR300+ IT systems and 200+ Business reports successfully assessedCreate project plan and development approach Show less

    • RBS

      Jan 2019 - May 2021
      Big Data Engineer

      Created Physical and Logical data models for the source system according to RBS LDM governance Create Single true golden copy for the data using Big Data Hadoop frameworkHive/Impala Query OOzi Workflows

    • NatWest Group

      May 2021 - Feb 2023
      Lead Data Analyst

    • OSTTRA

      Feb 2023 - now
      Associate Director Business Analyst

  • Licenses & Certifications

    • Cash Management

      Tata Consultancy Services
      Dec 2013

    • Certification in Business Skills

      Tata Consultancy Services
      Dec 2013

    • Certification in Money Market

      Tata Consultancy Services
      Jun 2013

    • Certification in Risk Management

      Tata Consultancy Services
      Dec 2012

    • Certification in Operational Risk

      Tata Consultancy Services
      Jun 2012

    • Treasury Management Concept

      Tata Consultancy Services
      Jan 2012

    • Certification in Clearing and Settlement

      Tata Consultancy Services
      Jul 2011

    • Big Data Hadoop Expert

      Edureka
      Sept 2019

    • Six Sigma Green Belt.

      Tata Consultancy Services

    • Capital Market certification

      NSE India

    • ITIL

      EXIN
      Apr 2012

    • Certification in Forex Management

      Tata Consultancy Services
      Jun 2013

    • Basics of Banking and Finance

      NSE India

    • Professional Scrum Master

      Scrum.org
      Apr 2015

    • Microsoft Certified Azure Fundamental

      Microsoft
      Feb 2020

    • Certification in Corporate Action

      Tata Consultancy Services
      Oct 2015