Sampath D
Automation Analyst
Aubrey,TX
Summary
Results-driven Business Intelligence and Automation Analyst with over four years of experience in developing innovative, data-driven solutions using Power BI, Python, SQL, and Snowflake. Expertise includes creating automated data pipelines, designing interactive dashboards, and integrating analytics with enterprise systems to enhance decision-making processes. Proven ability to translate complex datasets into actionable insights while optimizing workflows and empowering business teams through self-service reporting tools. Recently led a proof-of-concept in Palantir Foundry to assess data integration and ontology modeling for improved enterprise analytics capabilities.
Overview
4
4
years of professional experience
Work History
Associate BI & Automation Analyst – UiPath / Power BI
Internal Revenue Service (IRS)
11.2023 - 04.2025
- Designed and deployed interactive Power BI dashboards integrating ServiceNow and internal operational data, providing real-time insights into service desk performance and ticket resolution trends.
- Developed Python-based ETL scripts to clean and transform API and CSV datasets before loading into Snowflake.
- Supported a proof-of-concept project on Palantir Foundry, building small-scale pipelines and testing data ontology mapping to evaluate platform capabilities for analytics integration.
- Automated user access and data refresh tasks for BI reports, improving report availability and reducing manual maintenance.
- Partnered with business and IT teams to define KPIs and develop reports supporting service efficiency and compliance monitoring.
- Documented data flows and transformation logic to align with enterprise governance and audit requirements.
RPA Developer / Data Reporting Analyst – UiPath, Power BI
Western Alliance Bank
05.2021 - 05.2023
- Automated key reporting processes by connecting UiPath workflows with Power BI and Snowflake datasets for daily operational analytics.
- Designed Power BI reports consolidating KYC, fraud, and risk metrics, providing clear visibility into daily exceptions and processing volumes.
- Created Python-based ETL jobs to extract, validate, and enrich transactional data for use in BI models.
- Developed SQL queries and stored procedures for trend analysis and KPI dashboards consumed by management.
- Built a fraud alert routing system that combined Power Automate and Teams for real-time notification of high-risk transactions.
- Collaborated with data engineers on optimizing Snowflake schemas and scheduled data refreshes for reporting accuracy.
- Contributed to ongoing data governance efforts, including documentation of data lineage and access controls.
Junior Business Analyst (RPA & Reporting)
Verizon
09.2019 - 04.2021
- Partnered with internal teams to identify reporting gaps and automation opportunities, leading to faster data delivery and improved accuracy.
- Built and maintained Excel- and Power BI-based reports for process monitoring and volume tracking across departments.
- Participated in the development of UiPath automation for repetitive data entry tasks, integrating outputs into internal dashboards.
- Supported UAT, prepared end-user documentation, and created reusable components for reporting automation.
Education
Masters - Technology Management
Texas A&M University-Commerce
TXBachelors - Electronics and Communication Engineering
JNTU
IndiaSkills
BI & Data Tools: Power BI, Snowflake, Palantir Foundry (POC), Excel, SharePoint
Timeline
Associate BI & Automation Analyst – UiPath / Power BI
Internal Revenue Service (IRS)
11.2023 - 04.2025
RPA Developer / Data Reporting Analyst – UiPath, Power BI
Western Alliance Bank
05.2021 - 05.2023
Junior Business Analyst (RPA & Reporting)
Verizon
09.2019 - 04.2021
Bachelors - Electronics and Communication Engineering
JNTU
Masters - Technology Management
Texas A&M University-Commerce