Tarunoday Sharma
Kolkata
Summary
Seasoned analytics professional with 18+ years of experience in Business Intelligence and Data/Information Management. Expertise in Business Performance Measurement, Strategic Analytics Project Management, and Credit Card Campaign Execution. Domain familiarity in Banking and Credit Cards. Skilled in agile and SDLC environments with a strong background in stakeholder management and cross-cultural collaboration. Trained in data privacy regulations including GDPR and CCPA. Available for immediate joining.
Overview
18
18
years of professional experience
1
1
Certification
Work History
AVP (Wholesale Banking Analytics)
HSBC Global Analytics Centre
Bengaluru
2021.05 - 2023.07
- Created daily new-to-bank daily feed to Actionable Intelligence (RM front-end) and CRM platform for CMB
- Sourcing data from CMB data warehouse, external datasets, and files, integrating and transforming the data for all countries in scope
- Creating a snapshot of the customer base and creating delta files by comparing snapshots
- Applying QC check on volume threshold breach and creating email alert
- Sftp files to two different front-end systems, AI and CME.
Senior Manager
HSBC Global Analytics Centre
2017.01 - 2021.01
- Worked on a strategic commercial banking initiative called Client Network Banking, where the goal is to win new business through referrals
- Here external vendor/supplier data of a client (buyer) is fuzzy name matched against internal data to identify banked customers
- Additional data elements such as revenue and risk rating, facility limit is also added along with the matched records to give rich understanding of banks penetration into client’s supply chain
- Successfully executed client network banking POC where external data vendor, FactSet data was used along with internal data sources to compare buyer, supplier, subsidiary coverage of FactSet data vis-a-vis internal data sources
- The analysis was done on two phases in sprint mode, on two sets of companies selected based on their geographical presence
- The analysis helped businesses to decide whether to buy FactSet data (expensive) or use FactSet terminal (less expensive)
- Developed revenue funnel report that tracks customers which are eligible for revenue reporting but are stuck in the pipeline from deals won till showing up in the revenue system.
Manager
HSBC Global Analytics Centre
2015.01 - 2017.01
- As part of commercial banking CDO, my primary role was to engage with multiple country business heads and compliance teams to present on various aspects of commercial banking MDM solution called client central and obtain necessary approvals from the countries
- These approvals were necessary for the countries to share customer demographic information to the central MDM repository in the UK, where all countries' customer data will be stored
- Data sharing transfer schedule (DTCS) document was used for the country level discussions.
Lead Consultant
ITC INFOTECH India Ltd
Bangalore
2011.07 - 2015.02
- Performing banking data analysis in SAS/SQL and providing valuable insights to the client in Denmark
- Create KPI report on cross selling index, customer net development, profitability, RM meetings and credit card spend
- Data extraction, integration, cleaning, transforming, and reporting is an important part of the day-to-day job
- Working on multiple projects at the same time and collaborating with multiple teams to address any information gap
- Performing ad-hoc data analysis & reporting in SAS.
Systems Analyst
American Express
Gurgaon
2007.11 - 2011.03
- Understanding campaign requirements with the campaign managers and finalize data flow
- The campaigns covered diverse range of areas such as Loyalty, Internal acquisition, Market Research, Anti attrition/retention, Benefit Awareness, Customer Spend Usage, Early Engagement, Card Insurance, & Account Servicing
- Extract data for campaign target population from customer marketing historical database (SAS datasets in Unix)
- Cell segmentation of target base based on cell level criteria (product type, spend, age etc)
- Applying suppression based on predefined suppression logic, data Formatting
- Final file(list) creation as per predefined layout, which varies according to channel, campaign type.
Sr. Batch Analyst
AON Hewitt
Noida
2005.02 - 2007.11
- Developed, unit tested and deployed ETL pipelines in production SAS, according to the analysis specification
- Designed new JCL program from scratch and made modifications in the existing JCL, SDLC methodology used throughout the process.
Education
Diploma in International Data Privacy & Protection Laws -
Skill Arbitrage
09.2024
B. Tech (Computer Science) -
Guru Gobind Singh Indraprastha University
TBSE -
Bir Bikram Institution
TBSE -
Bir Bikram Institution
Skills
- SAS (BASE SAS, SAS Macros)
- R / Pyspark (working knowledge)
- JIRA
- SQL (expert)
- Power BI (Power Query, DAX)
- Credit Card Campaign Execution
- Commercial Banking Strategic Analytics of Global coverage
- Familiarity with SDLC Methodology & Project Management
- Excellent communication & Presentation skills
- Interpersonal skills
- GDPR
- CCPA
- Project Management
- Report Preparation
- Procedure Implementation
Certification
- Diploma in International Data Privacy & Protection Laws (Skill Arbitrage)
- Data camp track for Python /R/ Pyspark/Power BI
- Python for Everybody (Coursera)
- Agile Foundations(Linkedin Learning)
- CCPA Essential Training(Linkedin Learning)
- GDPR Essential Training(Linkedin Learning)
Accomplishments
- Promoted to Senior Manager in 2017 (HSBC)
- Delivering the Promise (DTP) award for successfully completing 2 crucial phases of Value of Network project in commercial banking analytics team in HSBC for Q4’2016
- Trained CMB team for analytics symposium in which CMB Analytics team won 1st prize in people's choice award and 2nd prize in Jury award in 2019.
- I led various strategic initiative to grow revenue for the bank by identifying and acquiring new customers through the supply chain of the existing commercial banking customers leading to additional revenue of ~25Cr INR for the bank
Personal Information
Date of Birth: 04/19/82
Languages
- English
- Hindi
- Bengali
Timeline
AVP (Wholesale Banking Analytics)
HSBC Global Analytics Centre
2021.05 - 2023.07
Senior Manager
HSBC Global Analytics Centre
2017.01 - 2021.01
Manager
HSBC Global Analytics Centre
2015.01 - 2017.01
Lead Consultant
ITC INFOTECH India Ltd
2011.07 - 2015.02
Systems Analyst
American Express
2007.11 - 2011.03
Sr. Batch Analyst
AON Hewitt
2005.02 - 2007.11
- Diploma in International Data Privacy & Protection Laws (Skill Arbitrage)
- Data camp track for Python /R/ Pyspark/Power BI
- Python for Everybody (Coursera)
- Agile Foundations(Linkedin Learning)
- CCPA Essential Training(Linkedin Learning)
- GDPR Essential Training(Linkedin Learning)
Diploma in International Data Privacy & Protection Laws -
Skill Arbitrage
B. Tech (Computer Science) -
Guru Gobind Singh Indraprastha University
TBSE -
Bir Bikram Institution
TBSE -
Bir Bikram Institution
Similar Profiles
Mugilarasu PMugilarasu P
Assistant Vice President at HSBC, Global AnalyticsAssistant Vice President at HSBC, Global Analytics
Madhur GuptaMadhur Gupta
Consultant Specialist at HSBC – Global Technology Centre, RPSConsultant Specialist at HSBC – Global Technology Centre, RPS
Jhumar KapoorJhumar Kapoor
Senior Business Analyst - Assistant Vice President at HSBC Global Banking and Markets - Securities Services - Global CustodySenior Business Analyst - Assistant Vice President at HSBC Global Banking and Markets - Securities Services - Global Custody