Gayathri Pujari
Austin
Summary
Results-driven Business Analyst & Business Intelligence professional with 5+ years delivering data-driven solutions that enable strategic decision-making. Expert in SQL, ETL development, data modeling, and BI tools (Amazon QuickSight) to build scalable ETL pipelines and interactive dashboards that streamline reporting and surface actionable performance insights. Proven collaborator with cross-functional teams, translating business requirements into analytics-driven recommendations and process improvements that enhance operational efficiency.
Overview
13
13
years of professional experience
Work History
Senior Business Analyst
Amazon
Austin, TX
11.2021 - Current
- Lead end-to-end analytics solutions by gathering and translating business requirements into scalable data models and ETL/ELT pipelines using SQL and AWS technologies.
- Design, develop, and maintain data warehouses and dimensional models to improve query performance, reporting reliability, and decision support.
- Build interactive Amazon QuickSight dashboards and reports that surface actionable KPIs for product, finance, and operations stakeholders.
- Implement data quality checks, monitoring, and documentation to increase data accuracy and reduce time spent on investigations.
- Collaborate with cross-functional teams to prioritize analytics projects, deliver insights, and drive process improvements that support strategic decisions.
Business Intelligence Engineer
Collabera
San Diego, CA
03.2021 - 10.2021
- Designed and delivered interactive dashboards and KPI scorecards to monitor transportation operations, risk metrics, and compliance, reducing manual reporting and improving visibility for stakeholders.
- Built and maintained ETL pipelines to consolidate transportation, logistics, and compliance data into centralized data warehouses for reporting and analytics.
- Developed scalable data models and reporting solutions that provided actionable insights into shipment performance, operational risks, and regulatory compliance.
- Partnered with cross-functional stakeholders to gather requirements, automate reporting processes, and implement data-driven solutions that enhanced decision-making and operational efficiency.
Information Technology Analyst
Tata Consultancy Service
Bangalore,India
03.2013 - 11.2018
- Developed ETL pipelines to ingest large datasets (MySQL, flat files, XML, JSON) from diverse customer sources into HDFS using Pentaho and Informatica.
- Designed large-scale data warehouses using star and snowflake schemas; gathered business requirements and implemented Type 1 and Type 2 slowly-changing dimensions.
- Implemented partitioning (including dynamic partitions) and bucketing in Hive and optimized Pig scripts, improving processing performance by ~20%.
- Authored complex T-SQL (stored procedures, dynamic queries, functions, triggers, and views) to support reporting and solution development, increasing ETL efficiency by ~40%.
Education
Master of Science - Management Information Systems - Business Analytic
California State University - Fullerton
Fullerton, CA12-2020
Bachelor of Science - Information Science
VTU
Bangalore-India05-2012
Skills
- Data Visualization
- SQL, Database Management, and Query Optimization
- Data Analysis
- Amazon Quicksight,Tableau
- Business Intelligence & Analytics
- Data-Based Recommendations
- Market & Trend Analysis
- Real-Time Analytics & Reporting
- Performance Insights
- ETL Development & Data Integration
- Data Modelling & Data Mining
- Stakeholder Management & Requirements Gathering
- Process Improvement & Decision Support
Timeline
Senior Business Analyst
Amazon
11.2021 - Current
Business Intelligence Engineer
Collabera
03.2021 - 10.2021
Information Technology Analyst
Tata Consultancy Service
03.2013 - 11.2018
Master of Science - Management Information Systems - Business Analytic
California State University - Fullerton
Bachelor of Science - Information Science
VTU