Summary
Overview
Work History
Education
Skills
Timeline
Generic

Malay Gangopadhyay

Solutions Architect | Data Consultant
Hyderabad

Summary

Solution architect with more than 14 years of experience in different domains like healthcare, media and entertainment, Govt. agencies

Strong functional and technical skills: able to transition seamlessly between project roles to meet dynamic business needs. Experience in technical delivery of migration project including Azure Data Factory, Azure Databricks, Synapse analytics as well as consulting experience in different domains.

Overview

15
15
years of professional experience
4
4
years of post-secondary education

Work History

Solutions Architect

Tech Mahindra
09.2021 - Current

Pre-Sales (Azure- D&A):

Part of pre-sales Azure Data & Analytics global team.

  • Building solutions for data migration, modernization
  • GTM with partners for different deals and demo
  • Working on expanding relations with the existing clients by enhancing their D&A landscape and solution
  • Working with pre-sales team on response for RFPs, RFIs
  • Preparation of RLS, Estimates
  • Client presentations and management
  • Defense calls and presentations


Leading FMCG (APAC):

Delivery/Project Manager for a leading FMCG for an Azure Data Migration project.

Responsibilities includes:

  • Stakeholder management
  • Building architecture on Azure
  • Resource management
  • Ontime delivery of the entire project


Leading O&G (NORDIC):

Led consulting and pilot project to migrate from OBIEE to POWER BI (Azure).

Responsibilities includes:

  • Stakeholder management
  • Gathering client requirements from Business as well as technical teams
  • Collaborate with the developer to deliver the project

Project completed before time with appreciation which resulted in multi-million dollar win.


Media and Entertainment (US):

Part of the consulting team for a leading Media and Entertainment organization.

Responsibilities includes:

  • Current state assessment
  • Maturity assessment
  • Gaps analysis and recommendations
  • Data Strategy


Govt. Agency (Middle East):

Part of a consulting team.

Responsibilities includes:

  • Current state assessment
  • Maturity assessment
  • Data governance findings and recommendations
  • Data Strategy


Sr. Data Engineer

Optum Global Solutions
05.2016 - 09.2021

CCAT (Comprehensive Contract Audit Tool):

CCAT is implemented to replace the dependency on third party application for repricing of the claims.

It is used to identify overpayments and sending it to the auditors for further analysis.

Project was completely built on Azure with different Azure services.

CCDI (Commercial Client Data Integration):

CCDI is the Process of converting the Standard & Commercial clients data into Anti-Fraud & Recovery Solutions (AFRS) format and get them loaded to CCDI database. Data is pushed from CCDI to downstream to find out Fraud and Abuse cases.

Led the project for migration of data from on-prem to Azure.

Sources: CCDI takes input source data as claims, member, provider, and patient etc. Again the claims can be either Medicare claims or Medicaid claims or both or can be any other insurance kind claims.

Database: CCDI database is an Oracle database which stores claim, member, provider, diagnosis, drug and Pharmacy etc. data from various clients which is further used by data analytics team and other downstream. Thus CCDI has only filtered data and it is acting as bridge to provide data to various downstream.

FOCUS (Fraud Object Complex Unified Solution):

Fraud, Waste and Abuse (FWA) dept. runs complex operational processes using a variety of systems. Business wanted complete visibility into the fraud workflow, managed across multiple teams, processes and systems in order to make faster, better and informed decisions. The main goal of the project is to establish a universal fraud datamart that consolidates information from selected operational system. Create common reporting portal that provides access to the self-service queries and all fraud reporting suites including dashboards, scoreboards and drilldown reports.

Software Engineer

HSBC Software Development India
10.2010 - 05.2016

Detica (HBME):

HSBC Bank Middle East(HBME) believes that it has the opportunity to significantly reduce the exposure to fraudulent activities by implementing sophisticated analytics software. A project thus has been initiated by HBME to reduce to implement a fraud analytics solution by DETICA, This project will result in a solution based on the Detica NetReveal product which will identify high-risk fraud candidates operating in UAE.. NetReveal wil provide an interface allowing the HBME Fraud Team to efficiently investigate the highest risk candidates.

CM3 (Channel Management):

The CM3 system supports Group systems globally, promotes standardization and reduces the cost of ownership and IT expenditure. With the standard approach, each application no longer needs to develop or maintain its own module. It maximizes reuse, promotes faster time to market and lowers development and on-going maintenance costs.

Responsibilities:

  • Implemented system fixes in a critical data warehouse solution, integrating enterprise banking solutions in a single data platform. Additionally, streamlined system redundancies to effect $3K monthly savings over a year
  • Identified optimization opportunities in cross industry solutions and created technology driven automation solutions to effect optimum resource utilization. The said solutions were scaled as services to effect top line and generate revenue incremental of ~$30k
  • Took ownership of responsibilities beyond role and led a team of 2 to deliver on multiple initiatives in a key financial advisory enterprise solution, rated highest among 50 peers

Sr. Associate

Wipro
08.2009 - 10.2010

Worked for HP project (US) on desktop and laptop support. Provided end to support for all the desktop/laptop’s hardware and software issues.

Education

B.Tech - ECE

BUIE
Bankura
08.2004 - 05.2008

Skills

    Pre-Sales (Azure-D&A)

undefined

Timeline

Solutions Architect

Tech Mahindra
09.2021 - Current

Sr. Data Engineer

Optum Global Solutions
05.2016 - 09.2021

Software Engineer

HSBC Software Development India
10.2010 - 05.2016

Sr. Associate

Wipro
08.2009 - 10.2010

B.Tech - ECE

BUIE
08.2004 - 05.2008
Malay GangopadhyaySolutions Architect | Data Consultant