Pawan Thota
Austin
Summary
Analytics and automation professional with experience designing scalable data solutions and workflow automation using Alteryx, Tableau, Power BI, Power Apps, and Power Automate. Proven ability to build datasets from scratch, develop interactive dashboards, and implement validation-driven automation to improve data quality and operational efficiency. Strong ownership mindset with a track record of delivering end-to-end analytics solutions from data ingestion through reporting.
Overview
2
2
years of professional experience
Work History
Specialist - Analytics Developer
Charles Schwab
05.2024 - Current
- Designed and developed scalable analytics solutions by building new datasets from scratch using Alteryx, integrating multiple heterogeneous data sources, applying data standardization and transformation logic, and creating reusable, scalable data models to support both operational reporting and future analytical use cases.
- Developed end-to-end automation solutions using Power Apps, Power Automate, and SharePoint, enabling structured data intake, automated routing, business-rule enforcement, and real-time status tracking through integrated workflows and application logic.
- Implemented robust data validation and governance controls within applications, leveraging conditional logic, field-level validation, and dependency checks to ensure accuracy, completeness, and consistency of submitted data, significantly improving overall data quality and reliability.
- Built, maintained, and enhanced production Tableau dashboards, ensuring reliable refresh cycles, proactively resolving data integrity, access, and performance issues, and delivering enhancements such as extended historical views, refined calculations, and updated business logic to support evolving analytical needs.
- Created interactive Power BI dashboards by applying data modeling best practices, developing advanced DAX measures, and enabling drill-down and exploratory analysis to provide stakeholders with deeper visibility into key metrics and trends.
- Took full ownership of the solution lifecycle, including requirements interpretation, technical design, development, testing, deployment, and documentation, ensuring solutions were scalable, maintainable, and aligned with business objectives.
Supply Chain Data Analyst Intern
AAPA American Association of Port Authorities
07.2023 - 01.2024
- Leveraged advanced Microsoft Excel functionalities for data analysis and visualization, applying data cleaning and manipulation techniques to create analytical reports that supported supply chain optimization and informed a comprehensive, data-driven approach.
- Spearheaded data analysis initiatives on supply chain datasets, utilizing Tableau to identify trends and patterns and support strategic decision-making.
- Conducted market and supplier research across multiple domains, supporting supplier network expansion through detailed port data analysis and evaluation.
- Developed comprehensive reports presenting data analysis and research findings in a clear and structured format.
- Effectively communicated insights to senior management, delivering executive-ready presentations that aligned strategic objectives with data-driven insights.
Education
Bachelor of Science - Supply Chain Management And Analytics
The University of Texas At Dallas
Richardson, TX05-2025
Minor - Information Technology And Systems
The University of Texas At Dallas
Richardson, TX05-2025
Skills
- Alteryx (Advanced)
- Tableau (Advanced)
- Power BI (Advanced, DAX)
- SQL, Excel, Power Apps (Advanced)
- Power Automate (Advanced)
- SharePoint, Data Modeling
- Workflow Automation
- Data Validation
- Dashboard Development
- Java
- Python
- Web Development
- Project Management
Timeline
Specialist - Analytics Developer
Charles Schwab
05.2024 - Current
Supply Chain Data Analyst Intern
AAPA American Association of Port Authorities
07.2023 - 01.2024
Bachelor of Science - Supply Chain Management And Analytics
The University of Texas At Dallas
Minor - Information Technology And Systems
The University of Texas At Dallas