lavanya kandukuri

Sr. Reporting Analyst

Andhrapradesh, India 6+ yrs exp 90 · Outstanding

About

Analytical and detail-oriented professional with 5+ years of experience in data analysis, reporting, and dashboard development. Skilled in Applications such as Excel, Advanced Excel, SQL and Power BI. Hands on Experience on Google Studio and Excel functions like VLOOKUP, HLOOKUP, Date Functions, Text functions, IF, Nested IF, etc. Hands on expertise in end-to-end design and development for business processes using MS Office based applications (Excel, PPT, PDF, Outlook), and experience working with Google Sheets. Outstanding expertise in all Microsoft Office applications. Exceptional problem solving and analytical skills. Comprehensive knowledge of MS Excel in a business environment.

Skills & Expertise (25)

Power BI Service Advanced

8.5/10

Years Exp

Power BI Desktop Advanced

8.5/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Excel Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Power Query Advanced

8.0/10

Years Exp

MS SQL Server Advanced

8.0/10

Years Exp

Advanced Excel Advanced

8.0/10

Years Exp

DAX Advanced

8.0/10

Years Exp

Power Pivot Advanced

7.5/10

Years Exp

VBA Intermediate

7.0/10

Years Exp

MS Office Suite Advanced

7.0/10

Years Exp

Data Modelling Intermediate

7.0/10

Years Exp

VLOOKUP Advanced

7.0/10

Years Exp

Tableau Intermediate

7.0/10

Years Exp

HLOOKUP Intermediate

6.5/10

Years Exp

Text functions Intermediate

6.5/10

Years Exp

Date functions Intermediate

6.5/10

Years Exp

Google Sheets Intermediate

6.5/10

Years Exp

Google Studio Intermediate

6.0/10

Years Exp

Basic Statistics Intermediate

6.0/10

Years Exp

If Nested IF

Work Experience

Sr. Reporting Analyst (Contract)

Deloitte

Feb 2025 - Jul 2026

Analyzed HR datasets related to headcount, attrition, recruitment, performance, and compensation at Deloitte to support strategic workforce planning. Managed employee service line conversions, ensuring employee information was accurately aligned with new organizational transformations. Designed and maintained HR dashboards in Power BI to track KPIs such as attrition rate, hiring funnel metrics, time-to-hire, and employee demographics. Extracted and transformed HR data from HRMS systems using SQL, applying 3 years of hands-on SQL experience to write complex queries and deliver actionable insights to HR leadership. Supported recruitment analytics, including pipeline tracking, offer-to-join ratios, source effectiveness, and recruiter performance. Performed data cleansing and validation to ensure data accuracy, consistency, and compliance with HR data governance standards. Automated recurring HR reports, reducing manual effort and improving reporting turnaround time. Collaborated with HR business partners and leadership to gather requirements and deliver ad-hoc and scheduled analytical reports. Created and maintained documentation for data models, dashboards, and reporting logic to support transparency and reusability. Ensured confidentiality and security of sensitive employee data in accordance with company policies and regulations.

MIS Reporting Analyst

Quess Corp. Ltd

Nov 2022 - Feb 2025

Responsible for generating and distributing accurate reports from multiple data sources on a daily to quarterly basis and automated the reports using Power BI for daily, weekly & monthly reporting. Proficient in Power BI Desktop for interactive dashboards and real-time visualizations, with expertise in Power Query for data cleaning, complex DAX formulas, and building all processes from data extraction and transformation to visualization and delivery. Hands-on experience creating dashboards and charts in Excel and Advanced Excel, and maintaining a daily leads tracker — entering all leads exchanged with proper supporting fields for further tracking. Monthly collation of inputs from businesses — collating progress on leads exchanged to track closures, revenue generation, incentives, etc. Checking business remarks to ensure correctness of inputs and remarks. Improvising reports and formats for better data collation, visualization and insights — improving the way data is entered, maintained and presented. Making management reports and presentations for reviews, insights and activity overview — providing data overview in different formats for management to track progress and identify improvement areas.

MIS Analyst

Elric Soft Private Limited

Sep 2018 - Nov 2021

Prepared reports for various lines of business on a periodical basis to drive decision-making, with expertise in handling large volumes of quantitative data using Excel. Received and downloaded data from different sources, cleaning and formatting data using Excel. Visualized data using pivot tables and PowerPivot, and developed report specifications based on user requirements. Created, stored, retrieved and manipulated databases; performed data processing, visualization, and presented interactive dashboards. Collected and analyzed data and performed text mining using VBA to create structured data, visualizing the data and developing modules in VBA. Integral part of the team throughout the data gathering and analysis framework, involving data cleaning, processing, analysis, and visualization. Understood banking processes to automate workflows and created web scrapers to download tables and income sheets from PeopleSoft. Managed all MIS activities of the process and conducted Excel training for associates on a monthly basis. Circulated the project list weekly status summary report to management and the business unit head. Validated the project list weekly status report against the idea value mapping file. Prepared new formulas for Excel templates and MIS Excel reports for internal and onshore teams.