Hemant D. Mahant

Product Management Specialist, with over 12 Years of experience in Data Profiling/Analysis, Data Quality (DQ) & Controls implementation using SQL, basic Python scripting (expertise in OFSAA DQ framework).

• Ability to gather business requirements, translate structured/unstructured problems into analytical frameworks and independently plan & deliver within estimated time with industry standard quality.
• Experienced in performing impact analysis and designing/developing data solutions based on MS Excel, Power Query, SQL & basic Python.
• Strong analytical/problem solving mindset with the ability and willingness to get into the details to find solutions, while collaborating with multiple teams across geographies.
• Proficient with in-depth understanding of Data Warehousing (EDW)/ Data Lake, Data Governance, ETL concepts and Dimensional Modelling.

BNY Mellon India Operations Ltd, Pune Aug 2022 – Present

Project: Billing Oversight Role: Specialist, Product Mgmt

• Leading efforts to remediate data issues to smoothly migrate old billing platform to a new Oracle Product for

Corporate Trust (CT) line of business (LoB)

• Overseeing population of CT Critical Data Elements to move towards Digital Invoicing
• Ensured data sync across all sources and resolved data breaks from 46% to <1% while collaborating with multiple source and platform teams within few months of moving into this project
• Designing and publishing the rollout plan depending on factors like data preparation, development /system readiness, invoice validation, business signoff etc.
• Worked with multiple Client Onboarding teams to smoothen out existing BAU processes and reduced TAT by

~27% (from 52hours to under 40hours)

• Analyzed existing Wire Payment billing process to plug revenue leakage as part of 5-member team of Catalyst

(IDEAs) project, suggested corrective actions and potentially saved ~$2mn/annum Wire Processing fees

Wells Fargo India & Philippines, Bangalore Feb 2020 – Aug 2022

Project: eONE Data Quality & Controls Role: Senior Data Mgmt Analyst

• Responsible for achieving 100% DQ coverage (data-at-rest) for MDRMs related to next live filing event of US FED

Regulatory Reporting schedules.

• As part of SCRUM team, gather requirements from Data Governance/Mapping PODs, perform necessary analysis and design/implement Data Controls (data-in-motion) for Data Elements (DE) ingesting from multiple sources.
• Devised and published Data Quality & Controls Coverage reports to identify/track gaps till they are accordingly addressed in upcoming releases.
• Automated multiple manual tasks, required for identifying DQ Coverage gaps for Critical Data Elements (CDE),

using Python and MS Excel/Power Query.

• Leading efforts to design and automate DQ rules execution as per assigned priorities/DQ dimensions at Data

Element level using Python & SQL.

KPMG India Services LLP, Mumbai Aug 2019 – Jan 2020

Project: IFRS9 (Ind AS-109) Implementation Role: Consultant

• Responsible for identifying minimum DQ coverage from relevant stakeholders and implement them as part of initial Data Onboarding process.
• Developed utilities to calculate custom thresholds required for IFRS9 solution after considering all manual interventions from bank source.

BNP Paribas India Solutions, Mumbai Oct 2017 – Jul 2019

Project: Intermediate Holding Company Role: Software Engineer

• Automated Production Deployment using Unix shell scripting, via back-end Data Model upload utility and archival/restoration of OFSAAI components (T2T, PLT, ICC Batch etc.).
• Built diverse Tableau reports to show DQ rules execution status and to compare the results with previous executions in order to understand/track data issues within the system.
• Designated at Onshore (Montreal, CA) for a month to work with BA team and design & implement new data flow for BNP Canada Branch within existing data warehouse.

Tata Consultancy Services, Mumbai Jul 2014 – Sep 2017

Project: Operations Dashboard Role: System Engineer

• Analyzed the existing operational activities carried out by the Operations team and designed and implemented the tracker using Microsoft Excel.
• Collaborated with BAs and End Users to prepare Trend Reports for CDEs after appropriate Data Profiling exercise

Bachelor of Engineering in Electronics and Instrumentation, Medicaps Institute of Technology and Management, Indore (M.P.) 2014