Business Data Analyst with 5+ Years Experience

Lakshmi Saranya

Business Data Analyst

+1-469-***-**** • *****************@*****.***

Profile Summary

Business Data Analyst with 5+ years of experience in data analysis, business intelligence, and reporting, supporting financial and operational decision-making in fast-paced environments. Proficient in SQL (joins, subqueries, CTEs), Power BI, Tableau, and Excel (Pivot Tables, VLOOKUP/XLOOKUP) for analysing large datasets, building dashboards, and generating actionable insights. Experienced in data cleaning, validation, data modelling, and ETL concepts, translating business requirements into analytical solutions and technical specifications. Skilled at performing trend analysis, ad-hoc analysis, and statistical interpretation to deliver stakeholder-ready reports that support business strategy, improve operational efficiency, and enable data-driven decision making.

Technical Skills

Data Analysis & Querying: SQL (Joins, Subqueries, CTEs, Window Functions), Data Extraction, Data Cleaning, Data Validation, Data Transformation

Business Intelligence & Visualisation: Power BI (DAX, Power Query, Data Modelling), Tableau, Looker, Dashboard Development, KPI Reporting, Data Visualisation

Excel & Reporting: Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, Macros), Data Analysis, Automated Reporting

Programming & Analytics: Python (Pandas, NumPy – basic)

Data Management Concepts: Data Modelling, ETL Concepts, Data Warehousing, Relational Databases

Business Analysis: Requirements Gathering, Business Process Analysis, User Stories, Functional Specifications, Stakeholder Collaboration

Tools: Jira, Confluence, Microsoft Office (Excel, Word, PowerPoint)

Education

University of North Texas Denton, Texas

Master's in Business Analytics Jan 2023 – May 2024

Work Experience

Automated Health Systems (AHS) Remote, USA

Business analyst Aug 2025 – Present

Conduct business and data analysis using Excel, SQL, and Power BI to evaluate operational workflows and identify process improvement opportunities.

Analyze operational datasets using SQL (joins, subqueries, CTEs, window functions), Excel, and Power BI to identify trends and support data-driven decision making.

Develop and maintain Power BI dashboards and BI reports to track business KPIs and operational metrics.

Perform data validation, cleaning, and transformation to ensure data accuracy across reporting and analytics pipelines.

Collaborate with stakeholders to translate business reporting needs into technical data specifications and dashboard requirements.

Conduct ad-hoc data analysis and statistical interpretation to provide actionable insights to leadership.

Opera Technologies INC. Exton, PA, USA

Data Analyst Jan 2024 – Jul 2025

Extract, transform, and analyze large datasets using advanced SQL queries (joins, subqueries, CTEs, window functions) from relational databases.

Build interactive dashboards and visualizations using Tableau and Power BI to support operational and performance reporting.

Perform data cleaning, validation, and transformation using Excel (Pivot Tables, VLOOKUP/XLOOKUP) and SQL.

Automated recurring reporting workflows using SQL and Python, improving reporting efficiency and reducing manual data preparation time.

Conducted trend analysis and statistical interpretation on large datasets to identify patterns, anomalies, and performance improvement opportunities.

Use Python (Pandas, NumPy) to perform exploratory data analysis and automate data preparation tasks.

Support data modeling, ETL workflows, and data warehousing environments to ensure structured data availability for reporting.

Razorpay Bangalore, India

Business Intelligence Analyst Aug 2019 – Nov 2022

Analyzed financial transaction datasets using SQL and Excel to evaluate payment processing workflows and performance trends.

Delivered data-driven insights and analytical reports that supported cross-functional teams in making informed business decisions.

Developed analytical reports and dashboards using BI tools (Power BI, Tableau) to communicate key financial metrics to stakeholders.

Performed statistical analysis and trend interpretation to identify anomalies and improve operational performance.

Worked with engineering teams to support data modeling, ETL processes, and data warehouse reporting systems.

Translated business requirements into data queries, reporting logic, and technical documentation for analytics and reporting solutions.

Contact this candidate