Data & BI Analyst for Data-Driven Solutions

GAUTAMI JAGANNATH KATTI

Plano, TX 201-***-**** **************@*****.*** LinkedIn

SUMMARY

Data and Business Analyst with experience in enabling data-driven decision-making and business process optimization. Skilled in SQL, Python, ETL (Informatica, Alteryx), cloud platforms (Azure, AWS), BI tools (Tableau, Power BI), and Agile methodologies with proven track record of automating workflows and enhancing business outcomes for Fortune 500 clients. PROFESSIONAL EXPERIENCE

Third Estate Ventures Senior Business Analyst February 2025-July 2025

• Created data pipelines with DBT (Data Build Tool), leveraging Snowflake Cloud Data Warehouse for data ingestion and storage of 5+ million records, significant for manufacturing analytical reports.

• Utilized Pandas in Python to parse, structure, and transform raw data, reducing data pre-processing time by 15% and enhance ETL processes automation efficiency.

• Developed executive Power BI reports with KPIs (Click-through, Engagement, Conversion Rate, P&L, Net Revenue Retention, New/Returning Users), improving client portfolio analysis by 25%. University at Buffalo Research Analyst August 2024–February 2025

• Conducted root cause analysis on customer needs, market dynamics, and risks on Tableau dashboards to visualize key financial metrics and patterns, driving 25% improved retention.

• Gathered and analyzed ad-hoc business requirements capturing functional and technical needs, ensuring 100% alignment between stakeholders and development teams, leading to 15% increase in operational efficiency.

• Ensured data accuracy for critical business operations by developing and executing complex SQL queries to validate data. PricewaterhouseCoopers BI & Data Analyst August 2021–June 2023

• Executed automated data validation within Power BI by optimizing workflows and reducing data inconsistency to less than 3%.

• Mitigated data privacy and security risks across 10+ Power BI dashboards by implementing granular, user-based access controls for over 400 users, ensuring adherence to critical compliance standards.

• Parsed and normalized diverse unstructured ERP data formats including JSON, XML, parquet, and CSV extracts across 10K+ financial and supply chain transactions, transforming complex nested structures into analytics-ready schemas.

• Migrated workflows via Azure DevOps and conducted user acceptance tests within SLA standards, mitigating risks and improving response times by 25% and system stability by 15%.

• Automated 80% of manual controls and validation checks using Python and UNIX, reducing operational risk, improving data quality, and streamlining compliance processes.

• Optimized data ingestion, transformation, and loading for processes by leveraging RESTful and SOAP APIs to integrate SAP S4/HANA with CRM systems, reducing data retrieval time by 30%.

• Engineered Postman/Swagger-driven API testing framework that boosted test coverage by 40% and enhanced validation accuracy.

• Partnered with cross-functional teams including Finance and Operations during PI planning and Agile sprints, using JIRA and Miro to improve project delivery by 65% and provide custom BI solutions. ACADEMIC PROJECT

Ian Szabo Investment Group January 2024–June 2024

• Performed data validation and outlier detection on product and sales data prior to time-series forecasting, ensuring high-quality inputs with 10% rise in sales and 12% increase in customer satisfaction.

• Streamlined financial data analysis by integrating SQL queries and Alteryx workflows, reducing data preparation time by 70%.

• Utilized data mining techniques on customer behavior, resulting in 20% increase in targeted marketing campaign effectiveness. SKILLS & CERTIFICATIONS

Languages & Tools: SQL, Python, Scala, Tableau, Power BI, Alteryx, Google BigQuery, Snowflake, HTML, AWS, Google Cloud, Advanced Excel, LookUp, VBA, Pivot Table, ETL, Scripting Languages, Machine Learning, CI/CD, SAS, R Analytics: Hypothesis Testing, Statistical Modeling, Data Science, Database Management, Data Governance, Data Quality, Data Security, Data Integration, Data Warehousing, Data Collection, Predictive Analytics, Data Transformation, Data Pipelines, KPI Tracking Management: JIRA, Agile, Process Optimization, Project Management, Cross-functional Collaboration, Strategy Planning, Quality Management, Risk Management, Client Collaboration, Stakeholder Engagement, Project Support, Change Management Certifications: Microsoft Azure Fundamentals, Alteryx Core Designer, Informatica Cloud, Lean Six Sigma, Google Data Analytics EDUCATION

University at Buffalo, The State University of New York Buffalo, New York Master of Science, Management Information Systems (STEM) June 2024

Contact this candidate