Available for opportunities

Punit Gauttam

System EngineeratTCS

Transforming complex data into actionable insights through interactive dashboards, automated workflows, and enterprise-grade analytics solutions.

Jaipur, Rajasthan, India
Get In TouchLinkedInEmail
0+

Years Experience

0+

Power BI Reports

0+

Automated Flows

0%

Client Satisfaction

About Me

Power Platform & Data Expert

With 5+ years of hands-on experience, I specialize in Power BI development, Power Automate workflows, and SQL optimization. I leverage AI tools for parallel development and building personal productivity dashboards while continuously expanding my expertise in advanced DAX queries.

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 BIDAXSQL ServerPower AutomateSharePointPower Apps

Expertise Distribution

Data Visualization
40%
Data Visualization
Process Automation
Database & SQL
Cloud & Integration

Interactive Dashboards

Creating visual reports that help executives and teams make faster, data-driven decisions with real-time insights.

Data Management

Organizing and optimizing large datasets to ensure reports load quickly and information is always accurate and up-to-date.

Process Automation

Building automated workflows that eliminate repetitive manual tasks, saving teams hours of work every week.

Team Collaboration Tools

Setting up centralized platforms where teams can easily access, share, and collaborate on important business data.

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

Delivering enterprise Power BI solutions and automated workflows for a global entertainment studio, transforming complex data into actionable business intelligence.

Developed 25+ interactive Power BI dashboards using advanced DAX and SQL queries
Implemented Power Automate flows reducing manual reporting effort by 60%
Migrated legacy reports to Power BI Service with Row-Level Security (RLS)
Power BIDAXSQL ServerPower AutomateSharePointPower Query
Oct 2021 - Jul 2023

Associate Engineer

Circulants Solutions Inc.

Delivered end-to-end Power Platform solutions for healthcare and enterprise clients, specializing in Power BI development and process automation.

Designed Power BI reports with drill-through, bookmarks, and custom DAX measures
Built Power Automate workflows integrating SharePoint, SQL, and Power Apps
Implemented Row-Level Security for multi-tenant Power BI solutions
Power BIPower AutomatePower AppsSharePointAzure DatabricksSQL
Jun 2020 - Oct 2021

Graduate Engineer

Circuitloop Technologies

Managed e-commerce operations and developed data solutions using Excel and SQL for business analytics.

Built advanced Excel reports with pivot tables and macros for business analytics
Managed SQL databases for e-commerce inventory tracking
Led team operations ensuring timely delivery of client solutions
MS ExcelSQLData AnalysisTeam Leadership
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 analysts

API Analytics & Deployment Platform

Leading the development of comprehensive Power BI analytics solution for a major US-based insurance company, focusing on API call collection, monitoring, and deployment metrics. Built end-to-end dashboards tracking API performance, usage patterns, and deployment pipelines for enterprise stakeholders.

2 Direct Reports
Team Size
50+
API Metrics Tracked
15+
Automated Workflows
Power BIPower AutomateDAXSQL ServerAPI Analytics
Power BI

Enterprise Power BI Dashboard Suite

Comprehensive Power BI solution for a global entertainment studio featuring real-time KPIs, interactive drill-throughs, and DAX-powered calculations for executive decision making across multiple business units.

25+
Dashboards
150+
DAX Measures
12
Data Sources
Power BIDAXSQL ServerPower Query
Power Automate

Power Automate Workflow Suite

End-to-end automation solution integrating SharePoint, Power BI, and SQL Server for automated report generation, email triggers for scheduled reports, and distribution with approval workflows.

25+
Flows Created
40+
Hours Saved/Week
8
Integrations
Power AutomateSharePointPower BIOutlook
SQL Server

SQL Performance Optimization

Database optimization project involving query tuning, indexing strategies, and stored procedure development for high-performance Power BI DirectQuery connections.

+70%
Query Speed
50+
Procedures
100+
Tables Optimized
SQL ServerT-SQLQuery OptimizationIndexing
Power Apps

Power Apps Data Entry Portal

Custom Power Apps solution connected to Dataverse and SharePoint for streamlined data collection with real-time validation and Power Automate integration.

15+
Forms Built
200+
Users
99.9%
Accuracy
Power AppsDataverseSharePointPower Automate

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