Shiv Prakash Saini

Experience

• 

  Indian Institute of Technology, Delhi

  Aug 2011 - Jun 2012

  Field Engineer

  worked under project started by MHRD, India named virtual labs.Which included development and deployment of various online labs which will provide remote-access to Labs in various disciplines of Science and Engineering.

• 

  ICreate Software

  Jul 2012 - May 2014

  Product Consultant

  • End to end process from testing, development and deployment ETLs using Informatica.• Worked on Designer, workflow manager and monitor.• Worked with flat files, oracle database and XML files• Extensively used update strategy, stored procedures, sql, Normalizer, Joiner, Filter, Aggregator, Router transformations and mapplets.• Used session, reusable sessions, command, scheduler, Assignment, event wait tasks and worklets.• Understanding and analyzing the requirement by having a walkthrough with Business Analysts on regulatory reports specifications.• Development & Testing of RBI regulatory reports for banks to disclose their capital adequacy ratio and balance sheets to disclose their assets and liabilities.• Writing PLSQL procedures, Packages and functions to handle various exceptions and automated process. Show less

• 

  Moody's Analytics

  Jun 2014 - Sept 2022

  Credit Risk Calculations for the BHC around the geographiesAssisting Banks to maintain the LCR and the NSFR requirements Designing the Regulatory Framework Models for Basel III Liquidity and Credit Risk.LCR and NSFR Regulations for product enhancement for APAC regionLeverage Ratio Calculations for SAMAGSiB Regulatory Implementation and product design for the Globally Systematic Important Banks Risk Foundation Suite for Enterprise Risk Assessment Solutions by Moody's Analytics.Handling team of 8 members Show less • Work on Moody’s Analytics Regulatory reporting tool to build regulatory reports for banks which they required to submit to Banking Supervisors as per supervisory instructions. • Responsible for end to end configuration of report building that includes analysis of Specifications, Transform business/ Functional requirements into technical functionality in tool.• Hands on experience on complete process of data flow that includes Data transformation from calculation tables to Transaction tables(T_CDR, T_MR, T_OPR, T_FIN_BAL_SHEET etc). Implementation of this data in reports by developing Dimension, Facts and Aggregations. Show less

  • Asst Dir- Sr Product Analyst

    Apr 2020 - Sept 2022

  • Product Analyst

    Oct 2018 - Apr 2020

  • Delivery Lead

    Jun 2016 - Sept 2018

  • Deputy Senior Associate

    Jun 2014 - May 2016
• 

  Macquarie Group

  Oct 2022 - now

  Assistant Vice President