Jan 2023 - Present

Data Analyst at CVS Health

● Extracted data from CVS Health's pharmacy management system, order databases, and supplier systems using SQL and Python for comprehensive data collection. ● Implemented database normalization techniques and optimized indexing strategies in SQL for efficient data retrieval and storage. ● Implemented dynamic parameterization in Tableau dashboards to enable end-users to customize views based on specific criteria, enhancing interactivity. ● Conducted cohort analysis using advanced SQL queries to evaluate customer behavior patterns over time, aiding in targeted marketing strategies. ● Collaborated with pharmacists, and logistics teams to gather requirements and align data analytics efforts with business objectives, leading to a 15% improvement in overall team efficiency.

Aug 2023 - Dec 2023

Data Analyst at Enfocus

● Leveraged Python scripts to meticulously transform and cleanse data, catalyzing an impressive 25% enhancement in data accuracy and reliability, ensuring the integrity of ESG-related metrics for THOR Industries, a leading RV manufacturing company. ● Spearheaded the development of an interactive Power BI dashboard, providing real-time visibility into recycling rates, waste diversion, and year-over-year (YoY) comparisons, resulting in substantial savings of $500K while facilitating informed decision-making and strategic planning initiatives. ● Pioneered the implementation of a centralized database system, revolutionizing data accessibility and efficiency by reducing retrieval time by a remarkable 30%, streamlining data management processes.

May 2022 - Jun 2022

Data Analyst Intern at KPMG

● Aggregated unstructured data from different sources and performed data quality assessment on the existing customer dataset and improved its quality by 98%. ● Created powerful dashboards using tableau and provided significant findings of data to clients which potentially increased marketing growth by 45%.

May 2020 - July 2021

Data Analyst at Topper IAS

● Automated an ETL pipeline by using Amazon S3, Glue, Lambda & Tableau, enhancing operational efficiency of team by 4hrs. ● Engineered end-to-end data flow diagrams encapsulating various entities in the organization's inventory management system, thereby enabling teams to enhance business process efficiency. ● Performed cluster analysis & identified insights for customer retention using SQL, enhancing Q3 profits by $80K. ● Analyzed customer feedback for new product features, strategically enhancing product appeal & customer acquisition. ● Investigated data discrepancies, implemented resolutions, and communicated the findings clearly, bolstering the team's capacity for effective data analysis and subsequently improving operational efficiency.

Mar 2019 - Jan 2020

Data Analyst at Techlene Software Solutions

● Led the deployment of Power BI dashboard for products and propositions, improving data visualization and accessibility for stakeholders. ● Orchestrated the processing and integration of over 1TB of billing and profile data using SQL and Azure Databricks, significantly enhancing data accuracy and accessibility for strategic business analytics and decision-making. ● Achieved an 85% recall rate for predicting overdue payment using weighted average ensemble techniques (Decision Trees, and Random Forest) in Python, reduced the overdue rates by 10%. ● Developed an interactive Power BI dashboard for monitoring monthly payment rate, debt rate, and consumer analysis to inform strategic decision-making. ● Collaborated with finance team to optimize credit limit protocols within the credit adjustmen