Kapil Shrotriya

Kapil shrotriya

bookmark on deepenrich
Followers of Kapil Shrotriya788 followers
  • Timeline

  • About me

    VP at OCBC Bank

  • Education

    • Alok school, udaipur

      -
  • Experience

    • Wipro infotech

      Jul 2005 - Jan 2011

      Technical Delivery and implementation of Teradata based warehouses for Insurance companies.

      • Tech Lead

        Jan 2009 - Jan 2011
      • DWH developer / Module Lead

        Jul 2005 - Sept 2009
    • Hcl technologies

      Feb 2011 - Apr 2014
      Data architect - datamodeler - mapping lead

      Architecture and Designing Early Data Inventory, Data Profiling, Extraction Analysis, Sizing, De-duplication/Single view of Customer design, Access layer Design, ETL Design, Technical Metadata (Control Table) design, Data Architecture documentation, etc.Requirement Gathering Business Analysis and system understanding for heterogeneous Source Systems from modeling perspective.Upstream Data Modeling Customization and extension of OCBC EDW based on Teradata FSLDM (Financial Services Logical Data Model) Downstream Data Modeling Participated in Design, Data modeling for Data Mart for analytics on top of OCBC EDW.Single View of Customer(SVC) Implementation of SVC (Match and Merge) in Enterprise Data Warehouse from heterogeneous operational systems which does not support customer matching mechanism.Data Mapping Team Buildings Build and led team of 12 mappers for Upstream and Downstream Mapping. Show less

    • Medtronic plc (earlier covidien)

      May 2014 - May 2018
      Data architect
    • Ocbc bank

      Jun 2018 - now
      • Vice President

        Apr 2023 - now
      • AVP

        Jun 2018 - Apr 2023
  • Licenses & Certifications

    • Teradata certified design architect v2r5

      Teradata
  • Honors & Awards

    • Awarded to Kapil Shrotriya
      OCBC Spot On Award OCBC Sep 2012 Received Spot-On award 2012 from client OCBC Bank, Singapore.