Hitesh Rajpurohit

Card Digital Dashboard

• Dashboard to monitor digital activity of customers across Mobile, Browser etc.
• Automated process using Alteryx and Tableau.

Merchants Dashboard

• Dashboard to monitor sales of merchants across different products, age group, segments, geography, Merchant Category etc.
• View to compare Merchants in same category for intake or partnership process.

User Telemetry Dashboard

• Dashboard to monitor dashboards published on production server with metrics such as Unique Visitors, Monthly Visits, New Users (MoM) etc.
• View for access control guidelines to make sure all dashboard align to Company control policies.
• Automated emails for actions to end user if anomaly detected and process was developed using Alteryx and Tableau.

Offers Dashboard

• Developed comprehensive dashboard for marketing team to track campaigns and post analysis.
• Metrics such as Enrollments, Fulfillments, Opt-in Rates etc are tracked on daily basis.

Card Authorizations

• Dashboard to track authorization systems on daily basis and send alert if anomaly detected.
• Helps in identifying root cause of declines of transactions.

Balance Transfer Dashboard

• Using SAS developed ETL script to fetch data from SQL Server and Teradata.
• Built dashboard in Tableau showing Key KPIS and trend charts along with detailed analysis

Automation of Reports

• Automated process of creating slides across Enterprise level, LOB, and marketing channels
• Generating more than 70 slides across Quarterly and YTD Time period in day

Cash Vault Analysis

• Analyzing All Internal Cash Vault data for 2 years and coming up with actionable insights
• Created Ratings System for Cash vaults and identified under performing
• Built Decision-Board in tableau which can be further used for Quick

Market Mix Model

• Built market mix model for Mortgage LOB by analyzing Marketing and Non-Marketing variables.
• Calculated ROI and CPA across marketing channels.
• Built presentation and highlighted improvement areas for Marketing channels to stakeholders.

Debit Claims Analysis

• Analyzing Debit cards claims data for pattern and insights
• Created Tableau Dashboard highlighting insights and using Customer Age and Tenure with bank identified pattern
• Also, Built Prediction model for identifying if claim is reversible

Data Extraction and Report

• Loading data from multiple sources to manipulate and consolidate for generating Master Input sheet with all required numbers
• Using Master Input sheet to create PowerPoint slides
• Converting granular level excel report into automated report in Tableau
• Making report more Interactive by using filters, Actions features in Tableau

Ad hoc Projects

• Extracting data for Campaigns run in particular time period by building SQL queries in Teradata
• Extraction of data from various sources about Competitor and analyzing it as per requirement.

Distance Calculator

• Building Distance and ETA calculator using Python and Google maps
• Later replaced Google maps with Open Street Map by creating instance for Internal team of Open Street Map to avoid paying to Google for API hits (1000 hits per day would cost $100

Sales Analysis Dashboard

• Created Dashboard in MS Power BI using real-time Data from MySQL DB
• Purpose of Dashboard was to get real-time data about different Sales region, Sales professional and products.

Web Crawlers

• Automated script to download information from multiple pages and store in excel for Analyzing
• Downloading trip details excel for different time slots and aggregating all excels in one Excel file.

Server Lead

• Leading team of 5 members to support teams onshore and offshore regarding server and application access.
• Installing and managing different applications on all Servers (Windows and Linux).
• Setting up EC2 instances on AWS with desired applications as per client's requirement.
• Responsible for maintaining good health and Security of Servers using Nagios, Open VPN.

Data Governance Consultant

• Leading team of 5 members for evaluating and building POC around Data Governance tools.

Informatica to Collibra Integration

• Sutter Health – Informatica Data Quality (IDQ) To Collibra Integration
• Created rules and scorecards in Informatica Data Quality v9.6.1/10.0.0
• Created Workflow for creating Exceptions in Informatica Developer
• Helped Integration team with IDQ support by triggering backend database for fetching metadata

OEDQ2DGC

• Worked on building different Processors (Data Quality Rules) as per client's requirement
• Created various Jobs for making process automatic
• Also created workflow for generating issues in Oracle Enterprise Data Quality
• Helped with OEDQ part to Integration team like retrieving details from database

BNSF – Building Data Quality Rules

• Performed Column Analysis, Key and Cross Domain Analysis and Baseline Analysis.
• Created Data Quality Rule as per Client Requirement
• Connected Tableau with Information Analyzer using DB2 as backend database and generated Data quality reports

GM Customer Elements

• Worked on creating Data Quality Rules in IBM Information Analyzer and publishing results to Microsoft Power BI
• Using R script fetched data from IBM Information Analyzer and transformed it as required by Microsoft Power BI and generated reports

As part of the course studied about Statistics and Probability and how they're applied in Data Science and Machine learning. Following things were covered in the course. Python programming for Data Science. learned about most popular libraries used such as numpy, pandas, seaborn, sklearn, matplotlib. Machine learning algorithms from basic to Advanced – Regression Algorithms,Clustering Algorithms, Time Series, NLP.