Vardhan Gudla
Woburn
Summary
Strategic Data Analyst with expertise in designing and optimizing data pipelines on Azure, delivering scalable, and cost-effective solutions. Skilled in financial data analysis, Power BI dashboarding, SQL, and automation, enabling real-time insights for trading and cost management. Proficient in Azure Data Factory, Power Query, and ML techniques for forecasting and anomaly detection. Strong in ETL, RLS implementation, and BI tools like Tableau, enhancing financial decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Data Analyst
Broadridge Financial Solutions
NY
03.2024 - 03.2025
- Developed interactive financial dashboards in Power BI, providing real-time insights into budget performance, cost trends, and revenue forecasts to support decision-making
- Assisted in developing interactive financial dashboards in Power BI, supporting real-time insights into budget performance, cost trends, and revenue forecasts.
- Used Power Query for data cleansing and transformation, ensuring data consistency across financial datasets
- Supported the creation and execution of SQL queries to extract and analyze transactional data
- Helped automate routine financial reporting tasks by setting up scheduled refreshes in Power BI.
- Assisted in implementing row-level security (RLS) under supervision to ensure secure data access.
- Worked with stakeholders to gather reporting requirements, and helped deliver customized Power BI reports.
- Gained exposure to Azure services, including Azure SQL Database and Azure Data Factory, for financial data management.
- Assisted in financial forecasting and variance analysis by preparing data visualizations
- Contributed to impact assessment models by gathering and analyzing data.
- Supported the analysis and presentation of data-driven insights for strategic planning and budget discussions.
Data Analyst
FEDD- Fine Energy and Additives
India
12.2021 - 11.2022
- Leveraged Azure to integrate data from multiple sources, including distributors, logistics, and inventory management systems
- Ensured smooth and efficient data consolidation across both internal and external platforms for comprehensive reporting and analysis
- Utilized SQL services, SAS, and Excel to clean, transform, and process raw trading and agricultural data
- Designed and implemented automated ETL pipelines to ensure timely and accurate data availability for reporting and decision-making
- Developed and deployed interactive dashboards using Power BI and Tableau to monitor key trading metrics, including trading volumes, pricing trends, supply chain efficiencies, and inventory performance
- Focused on delivering impactful visualizations to simplify complex data for non-technical stakeholders and senior management
- Applied statistical modeling and machine learning techniques using Python and R to forecast price trends, supply-demand dynamics, and market fluctuations
- Helped optimize trading strategies by reducing risks and maximizing profitability
- Conducted an in-depth analysis of agricultural market trends and their impact on trade and revenue.
- Utilized transactional and financial data to assess trading activities' influence on cost reduction, revenue generation, and competitive market positioning.
- Used Power Apps and other automation tools to streamline data collection processes, and improve operational efficiency.
- Ensured that data workflows aligned with business goals and regulatory compliance
- Worked closely with both technical teams, such as data analysts, data engineers, and non-technical stakeholders, including trading managers, logistics coordinators, and finance teams, to develop data-driven policy recommendations and optimize operational processes.
- Collaborated with leadership teams to provide actionable insights through regular reporting on data trends, performance metrics, and trading efficiencies
- Ensured that data-driven decision-making supported the firm’s broader strategic goals in agricultural trading and import-export operations
Jr.Data Analyst
FEDD- Fine Energy and Additives
India
12.2020 - 11.2021
- Assist in building and maintaining ETL pipelines using Azure Data Factory to extract, transform, and load data across different systems, ensuring data flows seamlessly from source to destination.
- Support data extraction tasks from Dynamics 365 for Finance and Operations into Azure Data Lake, ensuring proper organization of financial and operational data for analysis.
- Help maintain basic data structures in Azure SQL, including tables and views, to ensure data readiness for reporting.
- Assist in querying and transforming data using SQL, under supervision, to support analysis and reporting.
- Support statistical analysis and forecasting efforts using tools like SAS to derive insights from business data.
- Assist with basic data processing tasks and automation using Python, under the guidance of more experienced team members.
- Analyze data from different sources, helping to prepare insights that support business decisions.
- Perform basic database optimization tasks, such as running simple queries, and helping with indexing to improve data retrieval.
- Help build and maintain custom reports and visualizations using Power BI, ensuring the data is accurately represented.
- Support data governance and quality assurance efforts by assisting in the implementation of basic data validation checks.
- Collaborate with team members to identify and automate simple, manual data tasks using tools like Power Apps and Power Automate.
- Assist in version control and deployment processes using Azure DevOps (GIT), ensuring smooth collaboration across different team environments.
- Support the testing and deployment of ETL processes, reports, and dashboards in development and test environments.
Education
Master of Science - Data science & Analytics
New England College
Henniker, NH, USA10-2024
Bachelors - Bachelor’s in Commerce (Hons) + ACCA
GITAM University
Visakhapatnam, AP, INDIA07-2021
Skills
- Tableau
- Power BI
- Excel (Advanced)
- MS Visual Studio
- SSIS
- SSAS
- MY SQL
- Azure SQL
- MS SQL Server
- SQL
- PL/SQL
- Big data analytics
- Python (Pandas, NumPy)
- R
- Azure Data Factory
- Azure Data Lake
- Databricks
Certification
Microsoft Certified: Azure Data Engineer Associate-DP 203 [https://shorturl.at/uaxdR]
University Projects
Healthcare Resource Utilization Dashboard :
Developed an interactive Tableau dashboard to analyze hospital resource utilization, optimizing bed occupancies capacity, and emergency wait times. Processed 3+ years of patient data using SQL and Python to identify trends and forecast demand. Designed predictive visualizations to help administrators make data-driven decisions, improving hospital efficiency. Integrated AWS for scalable data storage and reporting, ensuring better resource allocation and patient care during peak demand periods.
Student Performance Analysis System [Associated with GITAM University] :
A database-driven project to track and analyze student performance. It stores grades, attendance, and faculty feedback while enabling batch inserts, automated GPA calculation, and trend analysis. Using stored procedures, triggers, and queries, it identifies top-performing students and those at risk. Data visualization through dashboards (Power BI/Excel) provides insights. An ER diagram represents relationships between students, courses, and faculty. This project showcases logical data management, analytics, and decision-making skills.
Timeline
Business Data Analyst
Broadridge Financial Solutions
03.2024 - 03.2025
Data Analyst
FEDD- Fine Energy and Additives
12.2021 - 11.2022
Jr.Data Analyst
FEDD- Fine Energy and Additives
12.2020 - 11.2021
Master of Science - Data science & Analytics
New England College
Bachelors - Bachelor’s in Commerce (Hons) + ACCA
GITAM University
Similar Profiles
Tyler WilsonTyler Wilson
Financial Analyst at Broadridge Financial Solutions, Matrix Financial SolutionsFinancial Analyst at Broadridge Financial Solutions, Matrix Financial Solutions
Matthew P Gutierrez Matthew P Gutierrez null
Relationship Manager at Broadridge Financial Solutions, Matrix Financial SolutionsRelationship Manager at Broadridge Financial Solutions, Matrix Financial Solutions
Rosaura AlvarezRosaura Alvarez
Operator at Broadridge Financial Solutions, Matrix Financial SolutionsOperator at Broadridge Financial Solutions, Matrix Financial Solutions
MOSES TAJAM BABILAMOSES TAJAM BABILA
Machine Operator Apprentice at Broadridge Financial Solutions, Matrix Financial SolutionsMachine Operator Apprentice at Broadridge Financial Solutions, Matrix Financial Solutions
Hope FonHope Fon
Warehouse Associate at Home DepotWarehouse Associate at Home Depot