
Results-driven SQL and Power BI Developer with a proven track record at Apollo Pharmacies Limited. Expert in optimizing SQL queries and creating impactful dashboards. Skilled in data modeling and DAX, complemented by strong problem-solving abilities. Successfully enhanced order processing efficiency and improved data accuracy through innovative solutions.
2024-2025
o Optimized existing SQL queries to improve performance and
reduce execution time.
o Developed new SQL scripts for table profiling and data
analysis.
o Created SQL Server scripts for dashboard visualizations based
on Power BI team requirements.
o Implemented a process to identify SQL-based location using IP
addresses to verify branch activity status for Quick Commerce
(QC) operations.
o Monitored the Order Management System (OMS) to ensure
system health and timely order processing.
o Performed daily inventory checks to verify online shop status
(active/inactive) and ensured past sales data was correctly
posted; coordinated with regional teams for any sales
amendments.
o Resolved order status posting issues by manually updating
fulfillment order statuses based on order IDs when required.
o Investigated high order allocation counts using SQL queries;
escalated critical issues to developers for resolution.
SQL
Power BI
Tools: