Open To Work
Gomathi Sankar Shanmuganathan
Insight Solutions
Work Preference
Job Search Status:
Open to work
Desired Job Title
Power BI DeveloperFabric DeveloperData AnalystAzure Data Engineer
Work Type
Full TimeContract Work
Location Preference
On-SiteRemoteHybrid
Location:
Chicago, IL
Open to relocation:
No
Minimum Desired Compensation
$120000/yr
Important To Me
Career advancementPersonal development programsCompany CultureWork-life balanceHealthcare benefitsPaid time offWork from home optionPaid sick leave
1
Certification
16
Years of experience
Enterprise BI and Microsoft Fabric Architect with 15+ years of experience designing and modernizing enterprise reporting and analytics solutions. Extensive hands-on experience with Power BI, Microsoft Fabric, Azure Synapse, Azure Data Factory, SQL, semantic modeling, DAX, Lakehouse and Data Warehouse architecture. Led BI modernization initiatives involving migration of Tableau, Spotfire, SSRS, Access and Excel-based reporting solutions to Power BI and cloud-based analytics platforms. Strong background in data modeling, security, governance, performance tuning, deployment automation and building scalable reporting solutions for complex business environments.
Work History
BI & Fabric Architect
5 Years 4 Months- Streamlined Pipelines migrate to Fabric, replacing lengthy processes with new activities like Semantic Model refresh and integrated notifications (Outlook, Teams).
- Migrated enterprise-scale metadata from Azure SQL Database into Fabric Data Warehouse.
- Created shortcuts for 10,000+ Delta files in ADLS via REST API in Fabric Lakehouse.
- Identified platform-level constraints and contributed architectural insights to the Microsoft Fabric team to improve future releases.
- Designed complex semantic models in Fabric by handling many-to-many relationships with bridge tables, managing active/inactive relationships and implementing dynamic Row-Level Security (RLS) to provide managers secure access to their own and direct reports' data.
- Assessed and validated Copilot capabilities within Microsoft Fabric for generating DAX measures and building Power BI dashboards through prompt-based interactions. Documented prompt behavior, outlined variance patterns, built best practices for effective prompt engineering, and submitted structured findings to Microsoft product teams.
- Client: Microsoft
BI Lead
5 Months- Developed and maintained Power BI dashboards for U.S. recruitment, sales, client performance, and financial analysis using data from SQL Server, SharePoint, and Excel.
- Created SQL queries, views, joins, and stored procedures to extract, cleanse, validate, and prepare recruitment and sales data for Power BI reporting.
- Used Power Query to integrate and transform data from multiple sources while improving data quality and consistency across reports.
- Configured scheduled refresh, row-level security, and workspace permissions to provide secure and reliable access to business users.
- Worked with recruitment, sales, finance, and management teams to gather requirements, validate KPIs, conduct UAT, and support production reports.
BI Lead
4 Years 4 Months- Built star-schema data models connecting clients, job requirements, candidates, recruiters, account managers, placements, billing, revenue, and cost information.
- Developed advanced DAX measures for submission-to-interview ratio, interview-to-offer ratio, offer-to-join ratio, fill rate, time-to-submit, time-to-fill, aging, and recruiter productivity.
- Developed client-analysis dashboards showing open requirements, placements, billing, revenue contribution, profitability, fill rate, turnaround time, SLA performance, and account growth.
- Integrated Power BI with Power Automate to automate workflow notifications and email alerts for aging requirements, SLA exceptions, pending actions and performance thresholds, enabling recruiters and account managers to take timely corrective action.
- Created recruiter and account-manager scorecards covering submissions, interviews, placements, closures, revenue, margin, target achievement, pipeline conversion, and performance ranking.
Data Team Lead
3 Years 11 Months- Managed MIS reporting and data analysis for technical support operations covering network complaints, VAS, PAC, ICRM, and customer service issues.
- Automated weekly and monthly reports using MS Access, Advanced Excel, Macros, and VBA, significantly reducing manual reporting effort.
- Built and maintained MS Access databases and analyzed large complaint datasets to identify recurring issues, service trends, performance gaps, and high-volume categories.
- Gathered reporting requirements and supported Service Request testing by validating complaint workflows, data accuracy, system changes, and reporting outputs.
Data Team Lead
2 Years- Prepared daily, weekly, and monthly MIS reports for Airtel technical support operations, focusing on network-related customer complaints and service issues.
- Tracked Airtel network complaints by complaint type, circle/location, priority, open and closed status, aging, turnaround time, resolution status, and SLA compliance.
- Analyzed recurring Airtel network issues, high-volume complaint categories, geographic trends, repeat complaints, escalations, and SLA breaches to identify areas requiring attention.
- Worked closely with Airtel technical support, network operations, and management teams to provide ad-hoc Excel reports and actionable insights for complaint resolution and service improvement.
Education
Bachelor of Business Administration
Skills
Power BI Desktop & Service
Enterprise Semantic Modeling
DAX
Power Query/M
Performance Optimization
Paginated Reports
RLS/OLS
Microsoft Fabric
OneLake
Data Warehouse
Direct Lake
Medallion Architecture
Dataflows Gen2
Fabric Data Pipelines
Azure Synapse Analytics
Azure Data Factory
ADLS Gen2
Enterprise BI Architecture
BI Center of Excellence (CoE)
Power BI/Fabric Platform Strategy
Data & Semantic Model Governance
Security & Access Management
Workspace & Capacity Strategy
Data Lineage
Enterprise Performance Optimization
Power BI/Fabric Administration
Capacity Management & Monitoring
Git
Azure DevOps
CI/CD
Deployment & Release Management
Enterprise BI Modernization
Legacy-to-Cloud Migration
Reporting Platform Transformation
Tableau
TIBCO Spotfire
SSRS
Excel/Access
Enterprise Data Engineering (SQL
ETL/ELT)
Data Integration & Orchestration
Metadata-Driven Architecture
API Integration (REST APIs)
Distributed Data Processing (Spark)
Certification
- Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Microsoft Certified: Azure Data Fundamentals (DP-900)
Personal Information
Title: Enterprise BI & Fabric Architect
Skills
Power BI Desktop & Service, Enterprise Semantic Modeling, DAX, Power Query/M, Performance Optimization, Paginated Reports, RLS/OLS, Microsoft Fabric, OneLake, Lakehouse, Data Warehouse, Direct Lake, Delta Lake, Medallion Architecture, Dataflows Gen2, Fabric Data Pipelines, Azure Synapse Analytics, Azure Data Factory, ADLS Gen2, Enterprise BI Architecture, BI Center of Excellence (CoE), Power BI/Fabric Platform Strategy, Data & Semantic Model Governance, Security & Access Management, Workspace & Capacity Strategy, Data Lineage, Enterprise Performance Optimization, Power BI/Fabric Administration, Capacity Management & Monitoring, Git, Azure DevOps, CI/CD, Deployment & Release Management, Enterprise BI Modernization, Legacy-to-Cloud Migration, Reporting Platform Transformation, Tableau, TIBCO Spotfire, SSRS, Excel/Access, Enterprise Data Engineering (SQL, ETL/ELT), Data Integration & Orchestration, Metadata-Driven Architecture, API Integration (REST APIs), Distributed Data Processing (Spark)
Timeline
BI & Fabric Architect
Insight Solutions
03.2021 - 07.2026Read More
BI Lead
ITT digital
10.2020 - 03.2021Read More
BI Lead
Cortex Consultants LLC
06.2016 - 10.2020Read More
Data Team Lead
Vayam Info Solutions
03.2012 - 02.2016Read More
Data Team Lead
Primaccess Technologies Pvt. Ltd
03.2010 - 03.2012Read More
Tamil Nadu University
Bachelor of Business Administration
Read More