Paruchuri Anil kumar

Data Analyst with 2 years of experience in SQL, Power BI, and Excel, specializing in data analysis, dashboard development, KPI reporting, data modeling, query optimization, and business intelligence reporting.

Data Analyst at Tata Elxsi (2023-03 – 2025-02)

Developed interactive Power BI dashboards and SQL-based solutions for sales analytics and inventory management. Led data transformation, validation, and optimization initiatives.

• Developed an interactive Power BI dashboard to track sales, revenue, profit, and customer KPIs
• Used SQL queries to extract and transform data from multiple sources
• Created DAX measures and calculated KPIs for business reporting
• Identified top-performing products and regions, supporting data-driven decision-making
• Built inventory monitoring dashboards to track stock levels and inventory movement
• Used SQL and Power Query for data cleaning and transformation
• Analyzed slow-moving inventory and stock shortages to improve operational efficiency
• Automated reporting processes, reducing manual effort and improving reporting accuracy
• Developed 10+ interactive Power BI dashboards for sales and KPI tracking, reducing manual reporting effort by 40%
• Developed complex SQL queries using Joins, Subqueries, CTEs, Window Functions, and Aggregate Functions to analyze 1M+ records and generate business insights
• Optimized SQL queries to improve report performance and reduce dashboard refresh time
• Performed data validation and data quality checks using SQL to ensure reporting accuracy
• Created SQL-based reports and datasets for KPI tracking and business analysis
• Automated recurring reports, reducing manual reporting effort by 40%
• Collaborated with cross-functional teams to provide data-driven insights for strategic planning
• Analyzed sales and inventory trends to identify low-performing regions and support management decision-making
• Improved reporting accuracy by 30% through data validation and cleaning processes
• Reduced dashboard refresh time by optimizing SQL queries and improving data model performance
• Delivered actionable insights that contributed to process improvement initiatives

B.Tech in Computer Science – Vel Tech Multi Tech Engineering College (2022)

Intermediate – Narayana Junior College (2018)

SSC – ZPP High School