Available for opportunities

Punit Gauttam

Senior Data & Power BI EngineeratTCS

Delivering enterprise-grade analytics and automation solutions using Power BI and Power Platform. Experienced in building 25+ dashboards and enabling business users through workflow automation across Healthcare, Media & Entertainment, E-commerce and Insurance domains.

Jaipur, Rajasthan, India
Get In TouchLinkedInEmail
0+

Professional Experience

0+

Power BI Dashboards

0

Process Optimization

0

Domains

About Me

Power Platform & Data Expert

Delivering enterprise-grade analytics and automation solutions using Power BI and Power Platform. Experienced in building 25+ dashboards and enabling business users through workflow automation across Healthcare, Media & Entertainment, E-commerce and Insurance domains.

As a data visualization specialist at Tata Consultancy Services, I help businesses unlock the power of their data through interactive reports and intelligent dashboards that drive decision-making.

I create visual dashboards with advanced DAX queries, design automated workflows that eliminate manual tasks, and leverage AI tools for parallel development and building personal productivity dashboards.

Education

B.Tech

Bachelor of Technology (B.Tech)

Swami Keshwanand Institute of Technology

Aug 2015 - Jun 2019

Core Technologies

Power BIDAXPower AutomatePower AppsSharePointSQLPython

Expertise Distribution

Power BI & Visualization
40%
Power BI & Visualization
Power Platform & Automation
SQL & Data Modeling
Cloud & Integration

Interactive Dashboards

Designing and delivering Power BI dashboards with DAX-driven insights, optimized models, and role-based access to support informed business decisions.

Data Management

Modeling, transforming, and validating data using SQL and Power Query to ensure accuracy, performance, and reliable reporting at scale.

Process Automation

Automating business workflows using Power Automate and Python, including email schedulers and API-enabled processes that reduce manual effort.

Team Collaboration Tools

Enabling business users through Power Apps and SharePoint solutions that simplify data access, sharing, and operational workflows.

Technical Expertise

Skills & Proficiency

A comprehensive overview of my technical skills and expertise levels. I specialize in turning complex data into clear, actionable insights using industry-leading tools.

Core Competencies

Hover to see proficiency levels

Technology Experience

Years of hands-on experience with each technology

Key Focus: Leveraging AI tools for parallel development while continuously expanding expertise in advanced DAX queries and building personal productivity dashboards.
SQL Server Management Studio
Query executed successfully
SELECT id, skill_name, category, proficiency, years_exp
FROM dbo.Skills
WHERE proficiency >= 75
ORDER BY proficiency DESC;
Results
Messages
8 rows returned
id
skill_name
category
proficiency
years_exp
certifications
1Power BIVisualization
95
4.52
2DAXVisualization
92
41
3SQL ServerDatabase
90
51
5Power QueryETL
90
40
4Power AutomateAutomation
88
3.51
6SharePointCollaboration
85
30
7Power AppsDevelopment
82
2.50
8Azure DatabricksCloud
80
20
Connected to: PunitGauttam_Portfolio_DBRows: 8 | Execution time: 0.023s
Power Automate

Workflow Automation

Building intelligent automation flows connecting SharePoint, Power BI, SQL Server, and Power Apps to streamline business processes.

Report Automation Flow
Active
triggerWhen a new request is submitted

Triggers when a new item is created in SharePoint list

conditionCheck Request Type

Route based on request category

Yes: Data ReportNo: Dashboard Update
actionRefresh Power BI Dataset

Trigger dataset refresh for latest data

actionExecute SQL Query

Run stored procedure for data extraction

actionUpdate Power Apps

Notify users via Power Apps notification

actionSend Email Notification

Email stakeholders with report link

Run History

Last 28 days
2 min ago
Succeeded1.2s
15 min ago
Succeeded0.9s
1 hour ago
Succeeded1.5s
3 hours ago
Succeeded1.1s

Power Platform Connectors

SharePoint
Power BI
SQL Server
Power Apps
Outlook
Dataverse
Excel
Teams
25+
Flows
40+
Hrs Saved/Wk
8
Integrations
Career Journey

Professional Experience

A timeline of my professional journey, highlighting key roles, responsibilities, and achievements across leading organizations.

Sep 2023 - Present

System Engineer

Tata Consultancy Services

Worked on multiple enterprise analytics initiatives across Insurance and Media & Entertainment domains, delivering Power BI dashboards, API analytics platforms, and governance reporting solutions. Responsibilities included modernizing legacy data platforms, building role-secured analytics, developing regulatory and all-encompassing reports, and leading a small team while collaborating directly with client stakeholders.

Delivered end-to-end Power BI analytics solutions across multiple business domains
Built API analytics, governance, and regulatory dashboards for enterprise clients
Migrated legacy SQL workloads to modern cloud data platforms
Power BIDAXSQL ServerPower AutomateSharePointPower Query
Oct 2021 - Jul 2023

Associate Engineer

Circulants Solutions Inc.

Delivered healthcare analytics and data automation solutions, working on both data processing pipelines and Power BI reporting platforms. Contributed to projects involving automated data ingestion, validation, secure access, and visualization of healthcare and medicine usage data.

Built Power BI dashboards for healthcare analytics and reporting
Developed automated data processing pipelines using Python and Azure services
Worked with structured and unstructured healthcare data from multiple sources
Power BIPower AutomatePower AppsSharePointAzure DatabricksSQL
Jul 2020 - Oct 2021

Graduate Engineer

Circuitloop Technologies LLP

Worked in a startup e-commerce environment, supporting day-to-day business operations, data analysis, and customer engagement. Gained hands-on experience in analyzing sales and operational data using Excel, interacting with customers and organizational leadership, and contributing to data-driven decision-making in a small, fast-paced team.

Analyzed e-commerce sales, inventory, and operational data using Microsoft Excel
Created and maintained Excel-based reports to track orders, returns, and customer trends
Supported customer follow-ups, including order status, returns, and policy-related queries
Microsoft ExcelData AnalysisE-commerce OperationsCustomer EngagementBusiness Communication
Jun 2018 - 2 Months

Summer Intern

Larsen & Toubro (L&T)

Contributed to quality assurance and smart panel development for Rajasthan Government IoT projects.

Supported QA testing for government smart panel solutions
Assisted in data synchronization and connectivity testing
Quality AssuranceIoTTesting
Portfolio

Featured Projects

A showcase of data visualization and analytics projects that demonstrate my expertise in Power BI, data engineering, and delivering impactful business solutions.

Current
Featured Project
Power BI
Leading a team of 2

Insurance API Analytics, Governance & Automation Platform

Built an end-to-end analytics and governance solution from scratch for an insurance client by working directly with stakeholders and leading a small team. The platform delivers multi-level visibility into APIs across platforms, supports regulatory (NYDFS) reporting, and enables business users through Power Apps, Power Automate, and SharePoint. Key highlights include platform-level and API-level analytics using Power BI, governance and all-encompassing reporting for enterprise visibility, NYDFS regulatory reporting dashboards, data modeling from PostgreSQL sources, Row-Level Security (RLS) for role-based access, business enablement using Power Apps and SharePoint, automated email notifications using Power Automate, and leading a team of 2 with end-to-end delivery ownership.

Feb 2025 - Present
Duration
2 Direct Reports
Team Size
API + Governance + Regulatory
Reporting Types
Power BIDAXPostgreSQLPower AppsPower AutomateSharePointAPI AnalyticsInsurance AnalyticsBI Governance
Power BI

Media & Entertainment Consumer Analytics Platform

Modernized legacy reporting by migrating SQL workloads from Teradata to Snowflake and building Power BI dashboards for consumer and broadcaster analytics. Enabled secure access and long-term trend analysis through role-based reporting and historical data comparisons. Key highlights include migrating SQL queries from Teradata to Snowflake, building Power BI dashboards for consumer and broadcaster analytics, implementing Row-Level Security (RLS) for secure reporting, conducting historical and year-over-year analysis using Excel and Power BI, and collaborating with stakeholders for data validation.

Oct 2023 - Jan 2025
Duration
Teradata to Snowflake
SQL Migration
Consumer + Broadcaster
Analytics Focus
Power BISnowflakeSQL MigrationDAXMedia AnalyticsEnterprise BIRLS
Power BI

Healthcare Data Visualization & Insights Platform

Developed Power BI dashboards to analyze healthcare data from multiple hospitals and organizations. The solution provided insights into medicine usage, effectiveness, and geographic distribution using interactive and map-based visualizations. Key highlights include building Power BI dashboards for healthcare analytics, sourcing data from Azure Synapse and flat files, analyzing medicine usage and effectiveness, displaying geographic distribution using map visuals, and implementing role-based access using RLS.

Jan 2023 - Jul 2023
Duration
Azure Synapse + Files
Data Sources
Medicine Usage + Effectiveness
Analytics
Power BIHealthcare AnalyticsAzure SynapseData VisualizationDAXBI Reporting
Data Engineering

Automated Healthcare Data Processing Pipeline

Built an automated data processing solution to ingest healthcare data from SFTP sources in multiple formats, clean and validate it using Python, and store it securely in Azure Blob Storage for controlled access. Key highlights include SFTP-based data ingestion (CSV, Excel, ZIP), data cleaning and validation using Python, utilizing Azure Notebooks and Blob Storage, and implementing secure, role-based data access.

Oct 2021 - Jan 2023
Duration
SFTP Multi-format
Ingestion
Azure Blob Storage
Storage
PythonAzure Blob StorageAzure NotebooksData EngineeringHealthcare DataETL Automation

Interested in seeing more of my work?

Let's Connect
Power Automate

Let's Work Together

Send me a message using this automated workflow. Fill in your details and your message will be delivered directly to my inbox.

Contact Form Flow
Ready
triggerWhen contact form is submitted

Trigger: Form submission detected

actionGet user information

Collect name and email address

actionCompose message

Capture message content

actionSend email notification

Deliver message via Outlook

Flow StatusComplete all fields
Send Message
0/5000

Email

gautty97@gmail.com

Phone

+91 8503087806

Location

Jaipur, Rajasthan, India

Or connect with me directly