Ankit Jain

Experience

• 

  Cognizant Technology Solutions

  Oct 2011 - Aug 2015

  Programmer Analyst

  • Strong experience in Data Warehousing and ETL tools Informatica Power Center and SAS Data Integration Studio 4.9• In-House training on SAS EG 6.1 and SAS OLAP Cube Studio 4.4.,SAS VA,SAs AML/ECM• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, SAS dataset and Flat files• PL/SQL - Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators• Well versed with Base SAS Programming and SAS macros• Strong understanding of business processes with good experience in development• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes• Oracle Certified Associate (OCA- PL/SQL Developer Track) Show less

• 

  SAS

  Sept 2015 - Sept 2020

  Senior Technical Consultant
• 

  Barclays

  Sept 2020 - Jul 2024

  Data Analyst - AML
• 

  Emirates NBD

  Jul 2024 - now

  Product Data Manager

  • Analysis and create mapping for standard payment data products for SWIFT based payments, IPP, IPI, FTS,WPS and Cheque based payments• Perform analysis and converted the high-level data requirements from data consumers into detailed functional specifications covering data mapping with golden source, business rules/data transformation rules, business glossary/data definitions, data quality rules, observability metrics, data access specifications• Supported and worked with collaborative model with Data Strategy & Governance function and IT teams for the implementation of Data Products for payments• Provide and review data model design to build data products for supporting potential business use cases• Build SAS and SQL scripts to validate data on oracle and Hadoop platforms Show less