Omkar Nagwekar

About Omkar Nagwekar

I’m a Data & Business Analyst with 3+ years of experience helping organizations turn raw data into actionable insights. With a strong background in Python, SQL, Tableau, and Power BI, I specialize in building dashboards, automating workflows, and delivering recommendations that improve efficiency and decision-making.At Walgreens, I designed and deployed analytics dashboards that improved decision-making speed by 25%, automated compliance reporting to save 12+ hours weekly, and drove a 9% boost in customer engagement through A/B testing. Earlier at Adons Softech, I partnered with global clients to optimize workflows, cut project scope changes by 30%, and delivered SQL-driven cost savings worth $200K annually.I thrive at the intersection of data analysis and business strategy—translating requirements into technical solutions, ensuring data quality, and enabling leadership with KPIs that drive results. With expertise in Agile, risk analysis, and process optimization, I enjoy collaborating across teams to deliver measurable impact.Always eager to tackle new challenges where data meets business.

Experience

1. Information Technology Business Analyst

   Walgreens

   Jan 2024 — Present · US

   Designed and deployed Tableau and Power BI dashboards to monitor prescription trends, sales patterns, and operational KPIs, improving decision-making speed by 25% for store managers. Created complex SQL queries and stored procedures to extract, clean, and integrate data from SQL Server, reducing report generation time by 40%. Automated inventory and compliance reporting using Python (Pandas, NumPy) and Excel Power Query, eliminating 12+ hours of manual reporting effort weekly. Partnered with stakeholders to translate business requirements into BRDs, FRDs, and user stories, ensuring alignment between IT deliverables and retail business goals. Conducted A/B testing for targeted pharmacy promotions, achieving a 9% increase in customer engagement and conversion rates. Led data quality improvement initiatives, identifying and rectifying anomalies across 1M+ transactional records, enhancing reporting accuracy by 18%. Integrated Python-based data validation scripts into ETL workflows, reducing data discrepancies by 22% before analytics processing. Designed and maintained KPI scorecards for pharmacy compliance and patient service metrics, enabling leadership to track performance in near real-time. Partnered with data engineering teams to optimize SQL Server indexing strategies, cutting query execution times by 35% on high-volume datasets. Collaborated in Agile sprints, supporting backlog grooming, sprint planning, and user acceptance testing (UAT) for multiple digital transformation projects.

Education

• Cleveland State University

  Master's degree

  2022 — 2024

• Don Bosco Institute of Technology (D.B.I.T)

  Bachelor of Engineering - BE

  2017 — 2021