Guruprasad Mandrawadkar
HEAD - DATA PRIVACY AND DATA GOVERNANCE
Mumbai,MH
Summary
- Currently working as Head of Data Privacy and Data Governanc with one of the Top 10 Global Bank in India
- Experienced Business Consulting & Technology Consulting individual. Adept in integrating & embedding Data Management, Data Analytics, Data Modelling, Data Engineering, Feature Engineering, AI ML Modelling, Data Visualization, Data Quality, and GenAI based solutions across business functions like digital banking, digital marketing, business operations, credit risk, sales, agent activation, customer experience, customer analytics, collections, NPA and delinquency management, productivity management.
- An engineer with 24 years of experience in stitching business solutions using technology across end-to-end value chain of Digital Banking, Mortgage & General Insurance. Have rich experience in modern cloud data platforms like AWS, Azure, Databricks, Hadoop Kafka, Spark, AI ML (AutoML, MLOPs), GenAI solutions (Code Llama, Mistral)
- Global experience of working in India, the UK, Switzerland & Malaysia, playing multiple roles – Head of Data Science, Head of DW and BI, Solution Architect, Program Manager, PMO Lead, Team Leader, System Auditor.
- Global Bank - Ran the ADF reporting for Standard Chartered Bank, performed payment system audit for Deutsche bank for 9 business functions to identify about 12 major regulatory and compliance risks, built customer facing applications for Shinsei Bank, ran the DW initiative and Campaign Management function for Barclays Bank.
- Domestic banks - Created a strategy & roadmap for setting up a Data Science department for SBI across all asset and liability products, built data science department for HDFC from scratch.
- Insurance – Built a fraud model to identify potential fraudulent health claims for HDFC Ergo General Insurance, led the DW & BI for HDFC Ergo General Insurance from scratch, performed data model validation & migration for BSLI, ran a multiple database benchmark test on 300 TB systems.
- Capital markets – Developed the data layer for audit trail of stock market orders for Fidelity Investments.
Overview
26
26
years of professional experience
3
3
Certificates
Work History
HEAD - DATA PRIVACY & DATA GOVERNANCE
HDFC BANK
11.2024 - Current
- Engage Data Privacy Impact Assessment to map data privacy posture for over 100 plus applications.
- Develop Data Privacy Framework to establish data privacy program across Retail Liability, Retail Assets, Corporate Banking applications
- Architect Data Discovery, Data Classification and Data Catalogue to identify PII touch points across structured, semi structured and unstructured data across the universe of the banks system spread over on premise, AWS, Azure and Google Cloud.
- Create PII Asset Inventory for mapping degrees of data usage risk and define potential safe guard criteria's including access control, encryption, tokenisation and protection.
- Define Privacy policies and procedures.
- Establish Data Principal Consent Management, Rights Management, Breach Notification and Localization for more than 100 plus net banking and mobile banking applications.
- Define Privacy Enabling Technologies as per DPDP Rules.
VERTICAL HEAD - CREDIT RISK AND ANALYTICS
HDFC BANK
07.2023 - 11.2024
- Innovated by enhancing the architecture by introducing new technology capability like Unity Catalog, AML OPS, AI Copilot, Databricks Assistant, GenAi using Code Llama and Mistral.
- Designed and developed custom data warehouses and data marts to support data analysis and reporting, resulting in a 25 to 30% improvement in data accessibility and a 35 to 40% reduction in execution times of credit campaign jobs across all retails products.
- Supported the development and maintenance of pipelines to efficiently move data between systems, resulting in a 20 to 25% reduction in data processing time and improvement in overall data accuracy.
- Developed and maintained data governance policies and procedures, by ensuring data integrity and compliance resulting in a 20 to 25% improvement in the data quality and a 45 to 50% decrease in data redundancy issues.
- Responsible for extending RPA capability to various business functions by building close to 20 plus BOTs and improved operational efficiency by almost 35 to 40%.
- Configured Intelligent Workload Management (IWM) to enhance the ability of serverless SQL warehouses so as to process large numbers of queries quickly and cost-effectively.
- Integrated high-performance vectorized query engine Photon to run SQL workloads and DataFrame API calls faster and reduce cost per workload.
- Optimized an automated Information Management by building business driven dashboards using Power BI which helped in driving actionable insights.
- Collaborated with various business functions to build an end-to-end Model Deployment across various product journeys encompassing almost 13 retails products.
- Identification and arresting of suspicious credit loan applications by using an algorithm based on fraudulent bank statements through advanced OCR technologies.
HEAD - DATA SCIENCE & DECISION INTELLIGENCE
HDFC BANK
11.2019 - 07.2023
- Understood the vision and strategy of leadership (MD, COO, CRO and CIO) teams so as to plan the journey of the Data Science Team at HDFC Limited.
- Performed an AS-IS analysis of various business functions across the value chain of the organization. Understood the key challenges and obstacles of decision-making in areas where data can be leveraged.
- Performed research and analysis of industry-wide practices in the lending business to be able to define a modern and holistic roadmap.
- Brought in operational efficiency of 12 to 13% across the Mortgage Lifecycle of Sanction, Disbursement, Post Disbursement, Collection and NPA management.
- Based on the business strategy and challenges, structured and defined the AI and ML roadmap for the organization, which will be futuristic and implementable. Defined the department hierarchy and staffing requirements while also running the technology architect solutions and implementation.
- Enhanced existing Lead Scoring, and Balance Transfer ML models and built new AI engines for identifying NPA, and NLP techniques for auto-categorization of customer service requests and performing Credit Underwriting Scoring, and NLG for building dynamic business scorecards.
HEAD - DATAWAREHOUSE & BUSINESS INTELLIGENCE
WALT DISNEY COMPANY
05.2016 - 06.2019
- Responsible for the overall design of the enterprise wide data/information architecture, which maps to the enterprise architecture. Facilitate consistent business analysis, data acquisition and access analysis and design, database management systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the enterprise level.
- Bring industry & technology point of view across BI, DW, Data Science, big data & analytics work streams. To provide input and/or create architectural artifacts including, but not limited to standards and principles, plans, road maps, blueprints.
- To enable the cloud first strategy, defined data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.
- Built a predictive channel health score which can be used as a single metric across digital platforms that enabled the CMO to generate 20 to 22% higher ROI on marketing campaigns as compared to last year.
- Built a unified digital marketing data platform (MDP) for measuring and predicting marketing spend effectiveness of paid & organic channel health by integrating data from multiple digital channels.
- Migrated a large work-loads to open source Hadoop sandbox resulting in successful processing of data in 60% of original time at 70% of original cost.
- Created AI Chatbot for interactive voice enabled interface for channel ratings analysis, thereby reducing complexity in design and getting information on the GO.
- Created a data lake to process machine learning models on more than 200 odd features required to build a predictive pricing strategy for different content.
- Enabled quick decision making by evaluation of each transaction/deal on metrics like Transaction Profitability, Pricing Benchmarks, Client Precedence, Client Wallet share and Prime-Time Content demand.
DIRECTOR TECHNOLOGY CONSULTING
PWC CONSULTING
04.2013 - 05.2016
- Led the PMO for the definition of the 5 year Analytics roadmap and implementation plan for SBI.
- Identified the key strategy scope & helped the bank in defining the organization and governance structure.
- Defined the parameters of the RFP that was required to be rolled out to select an implementation partner.
- Defined Analytics framework & implementation plan by selecting prioritized use cases relevant to bank.
- Provided thought leadership to the bank to build the Analytics capability of the bank.
- Led the solution delivery of propensity to fraud ML algorithms using SAS, right from solution conception to hypothesis building to data model design to data acquisition to model development to Go Live of the machine learning model.
- Narrowed down 100+ features to a list of business centric 40 odd features using pre model analysis.
- Provided SME support in building of logistic regression model, including selection of test data, validation data, model output and field level validation..
- Conducted about 120 interviews across different levels of front-to-back payment process value chain within 9 business functions to identify about 12 major regulatory and compliance risks.
- Reviewed the payment process across 4 control areas [Governance, Payment Pre Initiation, Payment Initiation, and Reporting] and identified gaps. Highlighted and raised the issues to the MD to enable traction.
- The banks product classes included business functions covering Equities, Asset Services, Fixed Income, Collateral, Global Liquidity, Commodity, Derivatives, Loans, Cash Operations and Trade Operations.
- Create a remediation plan across 9 business process for all the gaps identified..
SOLUTION ARCHITECT
TERADATA INDIA PVT LIMITED
MUMBAI
02.2011 - 04.2013
- Managed 3 major large scale DB benchmarks > 150 TB for existing and prospective clients across wide industry segment like insurance & capital markets with value of more than 4 Million USD.
- Designed architectures for integration of the data warehouse into the customer’s enterprise environment.
- Worked as a trusted advisor in building overall DW technologies and Teradata’s Suite of Products.
ASSOCIATE MANAGER
Accenture Services Private
03.2006 - 02.2011
- Responsible for understanding RFP received from 4 large prospects / existing customers and responding to RFP with proposed solutions.
- Provide detailed technology and implementation solution for proposed landscape and technical architecture.
- Responsible for providing efforts estimation using standard estimators and create a breakup of scope into manageable project phases and milestones
- Involved in core DW/BI capability initiatives like proficiency development, asset management, recruitment drives etc.
- Created a general Insurance specific data model as part of a fixed price DW/BI project delivered within timeline, scope and budget.
- Phase 1 delivered 18 tactical reports and Phase 2 delivered 20 strategic reports by using a data model. The policy and claims data marts were successfully integrated with the source system and KPI’s like Claims Ratio, Severity Ratio, Claims Incurred, Settlement Ratio, Open claims, Closed claims etc. were successfully implemented.
- Effectively handled the business requirements using pre-defined traceability matrix and requirements tracker and proposed reporting solutions for policy and claims system.
- Managed the standard project management activities like risk management, issue management, metrics submission, schedule and efforts management etc. using PMI guidelines
BUSINESS INTELLIGENCE DEVELOPER
Novartis Healthcare Private
10.2004 - 03.2006
- Worked as an Application Development Manager [ADM] for Pre-Clinical Safety project.
- Responsible for end to end project design and development including vendor’s management.
- Enabled BI CoE by defining Competency Measurement, Re-Usable Artefacts and trainings.
SENIOR SOFTWARE ENGINEER
MPHASIS SOFTWARE SERVICES PVT LIMITED
03.2003 - 09.2004
- Responsible for design, development, testing and documentation for 5 large projects.
- Worked as Oracle DBA involving life insurance, banking and capital markets projects
SENIOR SOFTWARE DEVELOPER
BIRLA TECHNOLOGIES LIMITED
08.2000 - 03.2003
- Responsible for design, development, testing & documentation of 7 large projects.
- Worked at onshore at the United Kingdom for about a year
PROGRAMMER
ONWARD TECHNOLOGIES LIMITED
03.1999 - 08.2000
- Responsible for coding and documentation of 3 projects.
- Worked at onshore at Zug, Switzerland for two months
Education
Bachelor of Engineering - INDUSTRIAL ELECTRONIC
KITS COLLEGE OF ENGINEERING
KOLHAPUR 04.2001 -
PROJECT MANAGEMENT
S.P. Jain Institute of Management And Research
Mumbai, India12-2005
Analytics For Management Program
IIT MUMBAI
06-2015
Professional Certificate in Business Management
IIM KOZHIKODE
01-2023
Skills
AI ML
DATA PRIVACY
DATA GOVERNANCE
DATA LAKEHOUSE
DATA WAREHOUSE
BUSINESS INTELLIGENCE
APPLICATION DEVELOPMENR
RISK MANAGEMENT
PROJECT MANAGEMENT
AZURE CLOUD
GOOGLE CLOUD
AWS
Certification
Statistics for Business II Program - Indian Institute of Management, Bangalore
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Marathi
Bilingual or Proficient (C2)
Kannada
Upper intermediate (B2)
Accomplishments
- Winner of Analytics Top 50 Award (2018) & Analytics Top 100 Award (2019) Presented by AIM.
- Highly appreciated by Fox Star India CMO for significant contributions in enabling predictive customer attribution model using a digital marketing platform by leveraging marketing spend & response information.
- Received Winning Ways award for one of the best teams at PwC, responsible for driving compliance and audit requirements of the Country Head of a large investment bank in India.
- Received Star Performer of the Month [March 2007] at Accenture.
- Hand-picked from a group of 1000 employees for a special 6-month Leadership Development Program at Accenture, while working on a large DW project for Barclays Bank.
- Received a Best Asset Award and Best Idea award for contributing an asset to the DW / BI capability at Accenture. Nominated for an idea award at the Accenture Information Management workshop.
- Received the ABOVE & BEYOND-2005 award for exceptional work on Safety Profiling and Assessment project (Novartis Healthcare Pvt. Ltd.), a Business Intelligence and Data warehouse project.
Software
Oracle
Python
H20
Informatica
Data stage
Ab initio
AS400
Interests
SPEAKER AT VARIOUS FORUMS
CRICKET
TRAVELLING
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeTimeline
HEAD - DATA PRIVACY & DATA GOVERNANCE
HDFC BANK
11.2024 - Current
VERTICAL HEAD - CREDIT RISK AND ANALYTICS
HDFC BANK
07.2023 - 11.2024
HEAD - DATA SCIENCE & DECISION INTELLIGENCE
HDFC BANK
11.2019 - 07.2023
HEAD - DATAWAREHOUSE & BUSINESS INTELLIGENCE
WALT DISNEY COMPANY
05.2016 - 06.2019
The Analytics Edge - Massachusetts Institute of Technology
08-2015
Statistics for Business II Program - Indian Institute of Management, Bangalore
07-2015
Certified Big Data Analyst on Azure HDInsight
03-2015
DIRECTOR TECHNOLOGY CONSULTING
PWC CONSULTING
04.2013 - 05.2016
SOLUTION ARCHITECT
TERADATA INDIA PVT LIMITED
02.2011 - 04.2013
ASSOCIATE MANAGER
Accenture Services Private
03.2006 - 02.2011
BUSINESS INTELLIGENCE DEVELOPER
Novartis Healthcare Private
10.2004 - 03.2006
SENIOR SOFTWARE ENGINEER
MPHASIS SOFTWARE SERVICES PVT LIMITED
03.2003 - 09.2004
Bachelor of Engineering - INDUSTRIAL ELECTRONIC
KITS COLLEGE OF ENGINEERING
04.2001 -
SENIOR SOFTWARE DEVELOPER
BIRLA TECHNOLOGIES LIMITED
08.2000 - 03.2003
PROGRAMMER
ONWARD TECHNOLOGIES LIMITED
03.1999 - 08.2000
PROJECT MANAGEMENT
S.P. Jain Institute of Management And Research
Analytics For Management Program
IIT MUMBAI
Professional Certificate in Business Management
IIM KOZHIKODE