Aakansha Gandhi
Bengaluru
Summary
Analytical and insightful Data Analyst with 5+ years of experience known for productivity and efficiency in task completion. Specialize in data visualization, statistical analysis, and predictive modeling. Excel in problem-solving, critical thinking, and communication, ensuring successful project outcomes and team collaboration.
Overview
5
5
years of professional experience
Work History
Data Analyst
London Stock Exchange Group
07.2023 - Current
- Currently working as a Senior Reporting and Governance Analyst in Infrastructure & Cloud Projects and Service Delivery, focusing on financial analytics, automation, and compliance reporting.
- Created and automated 100+ ad-hoc reports and interactive dashboards using Power BI (DAX, Power Query) and SQL, extracting data directly from Snowflake for real-time reporting with zero manual refresh.
- Designed and implemented budget forecasting and initiative tracking dashboards, enabling leadership to monitor financial allocations, cost variance, and project spend across global business units.
- Built automated data pipelines and ETL workflows integrating Snowflake, Power BI, and Power Automate, ensuring data consistency and reducing manual reporting efforts by 35-40%.
- Automated report scheduling and distribution through Power Automate, integrating Outlook, Teams, and Asana for seamless alerts, notifications, and workflow tracking.
- Developed learning dashboards for Ariban Oracle Inventory Management, and created financial sustainability reports to track hardware reuse, carbon emission, and environmental performance aligned with ESG and RBI reporting norms.
- Supported RBI-aligned financial reporting by preparing and validating liquidity coverage ratios, exposure reports, and capital adequacy data as per RBI and IFRS regulatory frameworks.
- Partnered with Finance, KIFA (Key Infrastructure Finance Accounting), and Cost Function teams to streamline data consolidation and enhance financial transparency across regions.
- Created KPI scorecards and performance dashboards for management, tracking project delivery, utilization, and operational efficiency against business goals.
- Contributed to the implementation of enterprise-wide reporting automation frameworks using Power Automate, SharePoint, and Asana, improving process reliability, accuracy, and reporting turnaround by 40%.
- Collaborated closely with Senior Project Managers, Finance Controllers, and Compliance teams to standardize governance and ensure continuous improvement of reporting systems.
- Develop and manage Snowflake tables for reporting, integrating them with Power BI for automated data refreshes.
- Automated ingestion of SharePoint files into Snowflake, enabling always-updated datasets for analytics.
Data Analyst
BYJU'S
11.2020 - 06.2023
- As a Data Analyst I am Responsible for Data Management and Distribution among the Team Members. Also to evaluate the overall performance of the individuals and Make Report Accordingly. I have good Knowledge of SQL and other BI tools.
- Made 20+ Tableau Dashboard for sales and finance data for CRM Management.
Education
B.Sc - Physics
G.D College
Bihar12th - English
CBSE
10th - English
CISCE
Skills
- Jira Tool ( Cloud & Server)
- Software Development Life Cycle
- CRM
- Agile Methodology
- SDLC
- Oracle SQL
- SQL
- Finance
- Data Analysis
- Tableau
- Power BI
- HTML
- Sales Analysis
- Google Analytics
- SQL Database
- Business Analysis
- Market Research
- Asana
- Power Automate
- Advanced Excel
- Dax
- Scorecard
- Reporting
- Financial analytics
- Snowflake
Projects
Restaurant Sales Analysis, 31 Days, Studied the raw data provided by the organization and prepared a report about the present sales and the recommendation to increase the sales. Indigenous budget stats, 30 Months, Analyzed indigenous budget statistics to identify cost-saving opportunities and improve financial efficiency, resulting in a 15% reduction in overall project expenses., Developed a comprehensive reporting system for indigenous budget statistics, facilitating better decision-making and resource allocation for future projects., Collaborated with cross-functional teams to gather indigenous budget data and conducted in-depth analysis to support strategic planning and forecasting initiatives.
Languages
- English
- Hindi
Languages
English
Advanced
C1
Hindi
Advanced
C1
Timeline
Data Analyst
London Stock Exchange Group
07.2023 - Current
Data Analyst
BYJU'S
11.2020 - 06.2023
B.Sc - Physics
G.D College
12th - English
CBSE
10th - English
CISCE