Senior Data Architect & Microsoft Fabric Lead
Resume:
SUBHENDU GHOSH
Microsoft Fabric Azure Data Factory Power BI & Data Engineering Lead
Irvine, California, USA
********.*****@******.***
LinkedIn: ****************@*****.***
PROFESSIONAL SUMMARY
● Senior Data Architect and Microsoft Fabric Consultant with 25+ years of experience in Enterprise Data Warehousing, Cloud Data Engineering, BI Architecture, and Database Modernization.
● Strong expertise in Microsoft Fabric, Azure Data Factory (ADF), Power BI, Snowflake, Oracle, SQL Server, ETL Architecture, and Enterprise Analytics solutions.
● Experienced in building enterprise-scale Data Warehouses, Data Lakes, Medallion Architectures, and metadata-driven ETL ecosystems.
● Extensive hands-on experience with PL/SQL, T-SQL, PySpark, DAX, SSIS, Informatica, DataStage, and cloud-native data integration solutions.
● Expertise in query optimization, performance tuning, indexing, partitioning, and large-scale enterprise database optimization.
● Proven track record of designing scalable data architectures supporting enterprise reporting, governance, and business intelligence initiatives.
● Experienced in enterprise reporting modernization using Power BI, Cognos, OBIEE, QlikView, and SSRS platforms.
● Strong experience leading offshore teams, Agile delivery, stakeholder management, budgeting, architecture governance, and enterprise project execution.
● Hands-on expertise in Azure ecosystem technologies, Snowflake implementation, Data Migration, Big Data, Hadoop, and API integrations.
● Domain expertise in Insurance, Healthcare, Telecom, and Travel industries. TECHNICAL SKILLS
Microsoft & Cloud Technologies
● Microsoft Fabric
● Azure Data Factory (ADF)
● Azure Synapse Analytics
● Microsoft Purview
● Azure Cloud Services
● Snowflake
● AWS Cloud
● Hadoop Ecosystem
BI & Reporting Tools
● Power BI
● SSRS
● Cognos
● OBIEE
● QlikView
Databases
● Oracle
● SQL Server
● PostgreSQL
● ClickHouse
● DB2
● Sybase
● Teradata
● Informix
Data Engineering & ETL
● Data Warehousing
● Data Lakes
● ETL / ELT Pipelines
● Medallion Architecture
● SSIS
● Informatica
● IBM DataStage
● Data Modeling
● Metadata Management
● Data Migration
Programming Languages
● PL/SQL
● T-SQL
● PySpark
● Python
● Shell Scripting
● Java
● NodeJS
● ReactJS
● JavaScript
● Spring Boot
● C#
Governance & Security
● RBAC
● Row-Level Security (RLS)
● Object-Level Security (OLS)
● Data Governance
● Capacity Planning
● Query Optimization
● Performance Tuning
● CI/CD & DevOps
Methodologies
● Agile Scrum
● Waterfall
● Offshore Coordination
● Stakeholder Management
● Technical Leadership
● Solution Architecture
PROFESSIONAL EXPERIENCE
Senior DataAnalyst cum Report Developer
TRISTAR Insurance Group Full-time
Mar 2025 – April 2026 Irvine, California
Responsibilities
● Managing enterprise databases including Oracle, PostgreSQL, and ClickHouse platforms.
● Designing scalable database architectures and enterprise reporting solutions.
● Developing PL/SQL stored procedures, functions, and optimized SQL queries for enterprise applications.
● Performing query optimization using indexing, materialized views, partitioning, and bulk processing techniques.
● Developing Python and Shell scripts for enterprise data migration and automation.
● Supporting enterprise analytics and reporting initiatives for insurance domain applications.
● Reports and dashboard development using Power BI, Power BI DAX functions and python integration.
● Collaborating with offshore and onsite teams for application support and database optimization.
● Monitoring database performance and implementing optimization strategies for large-scale workloads. Environment
Oracle, PostgreSQL, ClickHouse, PL/SQL, Python, Shell Scripting, Query Optimization, Performance Tuning Functional Manager cum Application Lead
ContinuumCloud Full-time
Jun 2024 – Mar 2025 Irvine, California, United States Responsibilities
● Led enterprise cloud application support and database optimization initiatives.
● Developed optimized PL/SQL procedures and enterprise reporting solutions.
● Performed SQL query tuning using indexing and partitioning strategies.
● Managed enterprise application lifecycle and offshore coordination activities.
● Supported cloud-based reporting and analytics environments.
● Worked closely with stakeholders to support operational and reporting requirements. Environment
Oracle, PL/SQL, SQL Optimization, Cloud Applications, Reporting Solutions Consulting BI Architect
Zensar Technologies Full-time
Apr 2012 – Jul 2024 12 Years 4 Months
Key Responsibilities
● Architected enterprise Data Warehouse, BI, and cloud analytics solutions for multiple clients.
● Designed enterprise-scale ETL architectures, reporting ecosystems, and dimensional data models.
● Worked extensively with Azure Data Factory, Power BI, Snowflake, Oracle, SSIS, DataStage, and Informatica.
● Led enterprise analytics modernization and reporting transformation initiatives.
● Developed metadata-driven ETL pipelines and automated data ingestion frameworks.
● Designed enterprise reporting solutions using Power BI, Cognos, OBIEE, SSRS, and QlikView.
● Performed query optimization and enterprise database performance tuning.
● Supported cloud modernization, DevOps, CI/CD implementation, and enterprise data governance initiatives.
● Managed offshore teams, sprint planning, budgeting, and stakeholder communication. Vialto Partners – Data Platform Implementation
Aug 2022 – Apr 2024
● Created Azure Data Factory pipelines for metadata-driven data ingestion into Snowflake.
● Supported enterprise Power BI reporting and analytics modernization initiatives.
● Developed technical documentation for Snowflake implementation and Azure integrations.
● Assisted business teams with Power BI reporting and data access using Python.
● Worked on QlikView to Power BI report conversion initiatives. Environment
Azure Data Factory, Snowflake, Power BI, Python, Azure Cloud Project: Beckman Coulter – SiteCore Implementation Duration: Feb 2022 – Jul 2022
● Performed Scrum Master responsibilities and technical leadership activities.
● Designed APIs using Swagger and integrated APIs with SiteCore.
● Developed automation scripts for Jira reporting and dashboard generation.
● Managed API access control and enterprise integrations. Environment
SiteCore, AWS, Oracle, JavaScript, Swagger, APIs
Project: Beckman Coulter – Phoenix Next Gen
Duration: Jan 2020 – Feb 2022
● Developed Oracle PL/SQL packages and stored procedures for enterprise applications.
● Designed pipelined table functions for optimized data processing.
● Built APIs using Spring Boot and NodeJS technologies.
● Developed NodeJS scripts for data migration between SQL Server and Oracle.
● Worked with AWS S3 integrations and enterprise batch processing solutions. Environment
Oracle, PL/SQL, Spring Boot, NodeJS, ReactJS, AWS, SQL Server Project: Assurant Specialty Property (SSP)
Duration: Sep 2016 – Dec 2019
● Created ETL validation frameworks using PL/SQL packages and stored procedures.
● Developed enterprise data warehouse models and SSIS jobs for reporting systems.
● Fine-tuned SQL queries for SSRS reports and enterprise reporting solutions.
● Developed custom components in C# for TFS integration and automation. Environment
Oracle, PL/SQL, SSIS, SSRS, C#, TFS
Project: Assurant Health – Enterprise Warehouse & Data Mart Implementation Duration: Apr 2012 – Aug 2016
● Designed enterprise data warehouse architecture and reporting data marts.
● Implemented ETL workflows using DataStage and Informatica.
● Provided query optimization solutions using PL/SQL pipelined functions.
● Developed metadata management and impact analysis solutions.
● Supported Big Data implementation using IBM InfoSphere and Hadoop ecosystem tools. Environment
Oracle, DataStage, Informatica, Cognos, Hadoop, IBM InfoSphere Solution Architect
Connectiva Systems
Client: ASSURANT HEALTH ACCESS
Jun 2008 – Jan 2012 3 Years 8 Months
Responsibilities
● Designed enterprise Data Warehouse and ETL architectures for healthcare and insurance clients.
● Developed dimensional data marts and reporting solutions for business analytics.
● Implemented ETL workflows using DataStage and enterprise reporting solutions using OBIEE.
● Performed data cleansing, transformation, and metadata management activities.
● Led development teams and performed enterprise solution architecture activities. Environment
Oracle, DataStage, OBIEE, ETL, Data Warehousing
Senior System Analyst
IBM Global Business Services
Sep 2006 – Jun 2008 1 Year 10 Months
Responsibilities
● Worked on enterprise database development and reporting modernization projects.
● Supported ETL integration, enterprise reporting, and analytics initiatives.
● Collaborated with onsite and offshore teams for solution delivery and support.
● Participated in enterprise data warehouse and metadata management projects. Environment
Oracle, ETL, Reporting Solutions, Database Development EDUCATION
● Post Graduate Diploma in Computer Science & Applications (1991 – 1993)
● Bachelor’s Degree in Mathematics (1988 – 1992)
CERTIFICATIONS
● Azure AZ-900 Certified
● Azure DP-900 Certified
● IBM Quality Stage Certified
● Teradata 12 Certified
● Certified Scrum Master – 2023
● SAFe 6 Agilist Certified – 2023
AWARDS
● IBM Star of the Quarter Award – Twice
Contact this candidate