DEEPAK ARORA

Worked on various data analytics tools as part of the Voxel Metadata program. Specifically, installing data quality tools such as Ataccama, and data catalog tools such as Collibra.

Installed Ataccama last year, getting it connected to various internal sources, such as Databricks, Snowflake, and Azure SQL Server.

Project Name: Controls Automation
Project Description Responsibilities:-
The project was based upon developing Controls based upon requirement provided by Business.Controls are all customers that have not been gone with proper process once the data load has been done in Information Warehouse
Control IT Platform was introduced to have consolidated visibility of all exceptions occurring across UKRBB
This enables business, mitigate them and I have detailed understanding of various exceptions in some cases track it to closure
Identified and documented detailed business rules and use cases based on requirements analysis
Proficient in SQL with a healthy experience in Teradata Utilities and in Unix commands
Created a generic framework to move the code to use Hadoop technologies using PySpark. The reasoning for that was the data was to be used from Datalake and card data was masked in newly built Datalake.

The project is based the all the transaction goes via banking gateway there are certain charges involved that needs to be processed

• All these were done via generating invoices and charging the respective customer based upon the usage
• All these transactions go via security processes Technology C.

Production Environment dealing with P&G's customer data and order management the project requires ETL, MDM and CRM Expertise.I was working as an ETL expert.

As a team member I was responsible for.

Transforming and Loading data coming from P&G websites and counters into a data warehouse.The data comes through various interfaces (as per the nature of the file). Supporting the P&G Environment with day to day activities.

Proficient in Mainframe & Teradata with a healthy experience in Teradata Utilities and in Mainframe JCL commands and Utilities.

Analysis, Programming/coding based on the program specifications received. Preparing Test Plan and testing the built code.

Enhancement to the application which include impact analysis, coding, unit testing, integration testing and post production support.

Handled real time issues and also have good idea about client interaction. Acting as the Primary resource for the Customer relationship Module of UK Retail Banking

Gather requirements, create functional specifications, develop and implement changes in project within established timeframes.

Develop and deploy various business rules and other conditional data validation checks.

Developing or modifying JCL'S and Teradata Scripts based upon project requirements.