Power Bi Business Intelligence

: +919********* *******.***********@*****.*** Page 1

Sarvesh Tripathi

Business Intelligence Associate

Total Experience

2.5 Years in Business

Intelligence

Qualification

Ramdeobaba University

B.E. - Electronics &

Communication (GPA: 8)

May 2022

Nagpur, Maharashtra

Work history

ZS Associates

March 2022 – Present

Pune, Maharashtra

Work Summary

Cloud Application

Administration

Power BI Development

Tableau Administration

Tableau Reporting

AWS Administration

Personal Dossier

Portfolio

Sarvesh Tripathi

Certifications

Tableau server

Administrator

Microsoft Azure 900

Power BI Analyst

AWS Cloud Practitioner

Gen AI Fundamentals -

Udemy

Summary and Accomplishments

BI Expertise: Result-driven professional in designing, configuring, maintaining, optimizing and monitoring business intelligence platforms.

BI Process Automation: Streamlined daily BI processes and reduced manual workload by 50% using PowerShell and Python scripting.

Cloud Compute Services: Experienced in Cloud infrastructure services (EC2, Redshift, CloudWatch, S3, RDS, Lambda, Code Build, IAM, CloudFront) with extensive experience in building and managing Windows and Linux servers for data-driven dashboards using containers and Docker.

Development and Reporting: Skilled in critical development activities within the client's hierarchy. Leveraged reporting skills to meet business needs, enhance business continuity, and streamline processes.

Implementation of Advanced BI Features: Implemented cutting-edge features in the BI domain, including self-service reporting models, advanced data visualization techniques, Co-pilot, Gen AI, & Microsoft Fabric for comprehensive data interactivity, and multi-source data integration.

Project Management and Client Engagement: Responsible for resource planning, project management, and client interactions. Addressed all Tableau and Power BI-related issues, ensuring team collaboration during problem resolution.

AWS Cost Optimization and Performance Improvement: Optimized AWS infrastructure with Savings Plans and Reserved Instances, increasing revenue by 15% and enhancing data accessibility and server uptime by 20% through optimizing database design using Gen AI.

Technical Skills

Business Intelligence Tools Power BI, Tableau

Cloud Technology Microsoft Azure, Amazon AWS & GCP ETL Tools Python, SSIS

Internet Technologies HTML, CSS

Scripting Tools PowerShell, Python

Programming Languages C, C ++, Python, DAX

: +919********* *******.***********@*****.*** Page 2 Project Profiles

Project Details

ZS Associates

March 2022 – Present

Role

Business Intelligence

Associate

Key Skills

Server administration

API integrations

Troubleshooting and

Debugging

Gateway configuration

Dashboard Design and

Optimization

Automation and Scripting

Performance tuning

Security management

Infrastructure setup

Data warehousing

Tableau Server Management Automations:

Gathered requirements from client coordinators and analyzed them to create a deployment pipeline to deploy code from lower to higher environments.

Automated access management for multiple Tableau servers across different clients.

Utilized TSC libraries and Tableau Rest APIs to meet client requirements.

Developed code using REST APIs and Python to fulfill ad-hoc business needs and streamline processes, significantly reducing turnaround time by 75%.

Leveraged AWS Code Build to host and deploy the solution according to business needs.

Cost Optimization via Azure Entra ID Management:

Analysed requirements from client coordinators to create an automated process for access management and ad-hoc refreshes in Power BI production environments.

Designed and implemented access management workflows on Azure AD using Graph APIs.

Developed custom code using Graph APIs and Python to meet ad-hoc business needs, streamlining processes, and significantly reducing turnaround time for providing user access to in-house managed applications.

Created a bespoke solution for ad-hoc dataset refreshing on Power BI Service via custom URLs triggered by Power Automate, integrated with Power BI REST APIs for enhanced functionalities.

Utilized AWS Lambda to host the solution with AWS API Gateway, ensuring efficient traffic management, authorization, and access control. BI Platform Optimization:

Managed to elevate uptime of all BI application-hosted servers by 99.8%, enabling timely actions across all servers when required.

Developed a query in Splunk to monitor server utilization across multiple BI technologies, ensuring they remain within thresholds.

Designed a Splunk dashboard to facilitate environment scaling decisions based on server utilization data.

Enhanced the solution to provide node-wise health check monitoring for Tableau servers, delivering real-time alerts for all services on all nodes in the production environment to better manage servers and prevent downtime

Contact this candidate