SUBODH KUMAR OJHA, Sr. Cloud Solution Architect - Data & AI

SUBODH KUMAR OJHA

Sr. Cloud Solution Architect - Data & AI

Microsoft

Location
Hong Kong - Hong Kong
Education
Master's degree, Mathematics & Computer science
Experience
4 years, 6 Months

Share My Profile

Block User


Work Experience

Total years of experience :4 years, 6 Months

Sr. Cloud Solution Architect - Data & AI at Microsoft
  • Hong Kong - Hong Kong
  • My current job since November 2022

Leading Data & AI solution architecture for top Life Insurance providers in Asia & ANZ region which includes providing Insurance solutions using Azure cloud Technlogies like ADLS, Azure SQL MI, Synapse Serverless /Dedicated SQL Pool, Cosmos DB(NoSQL), ADF, Azure ML, Databricks (DELTA LAKE, Data science/ML, AutoML, mlflow, Unity Catalog), Cognitive Services API (OCR, Speech to text), Azure Purview & Power BI solutions.
Working with top 5 MSFT Enterprise Customers and Partners for long term Data & AI strategic Solution includes guiding on industry best practices with E2E Data Solution Architecture, Data Governance, Data Model Design, review and implementations.
This is customer facing role, owns the overall technical relationship between the customer & Microsoft Azure platform with technical engagements including envisioning, solutioning, architecture design and POC/MVP and closely working with CXO level specialist /technologist / stakeholders for Digital Enterprise modernization/transformation or strategic initiatives.

Director - Data specialist at Sun Life
  • Hong Kong - Hong Kong
  • July 2021 to October 2022

Was responsible for E2E Data Solution Architecture, Information Model, Data Model Design (actively Hands-on & established best practices), Data Governance, Data Quality, Data Profiling, with Informatica MDM, ODH/BI semantic layer model & Standardization across countries in Asia,
ERDM, Client360/MDM & Analytics on Insurance business solution for Data Lakehouse /BI/DS
and Advance Analytics on AWS platform.
• Actively involved and owned ODH/Data Lakehouse Design with hybrid of Data Fabric & Data
Mesh Architecture and Business Solution
• Closely working with CXO Level stakeholders includes CDAO, Business Architect, Business
Solution head, Chief Architect, Digital Enterprise Architect, Integration Architect, Product Owner,
BAs, SCRUM master, Agile Coach and business partners of different countries in Asia

Sr. Manager - Consulting at Deloitte Touche Tohmatsu
  • Hong Kong - Hong Kong
  • November 2019 to July 2021

Led & responsible for IFRS17 Data Solutions which includes Data Warehouse Architecture/Data Model & Design and ETL and BI Reporting Development in Azure ( ADLS, ADF, SSIS, AAS & Power BI)
Define Standard & Guideline and best practices, Data Architecture document for Data Engineering, Data Pipeline design on cloud using Azure Data Factory ( ADF), Azure Data Lake, Azure SQL Data Warehouse, SSIS, AAS, Power BI, DevOps( CI/CD) & Control-M
Logical data Modeling and Physical Data Modeling for IFRS17 DWH and SAS SLAM Data Mart including Partition, distribution and Index design
Data Analysis, Data Standardization, Data Extraction/ Load and transformation into Actuaries format ( Prophet Cloud), CSM calculation, SAS Sub Ledger, Accounting ( SUN GL) and reporting using SAS VA
Working with Multiple ETL Lead & Architect for IFRS17 data extraction, Loading, data fulfillment for Prophet Model, CSM calculation, Sub GL and SUN GL posting

Education

Master's degree, Mathematics & Computer science
  • at University Of Calcutta
  • October 1996

Specialties & Skills

Windows Azure
Artificial Intelligence
Business Intelligence
Data Models
Analytics
Architectural Drafting
Data Modeling
Data Warehouse Architecture
APPLICATION PROGRAMMING INTERFACE (API)
COST ESTIMATION
DATA CLEANSING
DATA PROFILING
PROFILING (COMPUTER PROGRAMMING)
ALGORITHMS
ANALYTICS
CONTROL-M (BATCH SCHEDULING SOFTWARE)
FEATURE SELECTION
INFORMATICA

Languages

English
Expert

Training and Certifications

Azure Data Engineer (Certificate)
Date Attended:
February 2021