Nagajyothi Boggarapu

Data Analyst with 1.5+ years of experience in pharmaceutical supply-chain analytics, specializing in SQL, Power BI, and Python. Skilled in building executive dashboards and automating recurring reporting workflows to support inventory planning and supplier performance decisions. Built a manufacturer-wise Fill Rate dashboard covering the Top 50 manufacturers, representing nearly 50% of total sales, used by stakeholders to identify supply-availability gaps.

Data Analyst - Apollo Pharmacies Corporate Limited - Hyderabad, India

(2025-01)

• Extract, clean, validate, and analyze data from multiple sources across pharmacy operations to support business decision making.
• Fetch and process data from SSMS to provide site- and item-level Reorder Level (ROL), Reorder Quantity (ROQ), and Quantity On Hand (QOH), along with sales, fill-rate, and OTIF (On-Time In-Full) metrics, and contract checks for items.
• Develop and maintain interactive Power BI dashboards and daily reports tracking KPIs, sales performance, inventory metrics, and operational trends for stakeholders across the business.
• Write optimized SQL queries (joins, CTEs, window functions) for data extraction, transformation, and analysis across multiple systems.
• Automate recurring daily and periodic reporting using Python, reducing manual preparation time and eliminating recurring data-entry errors.
• Ensure data accuracy, consistency, and integrity across multiple systems and reporting platforms through regular validation checks.

B.Tech - Computer Science Engineering - St. Mary's Women's Engineering College (2019 - 2023)