Data/Business Analyst

Samradni Pathari

Business Data Analyst

*****************@*****.*** +1-857-***-**** LinkedIn USA SUMMARY

Business Data Analyst with around 4 years of experience turning complex data into actionable insights across the healthcare, e-commerce, and finance industries. Proficient in SQL, Python, R, and Excel for data analysis, predictive modeling, and process automation. Skilled in conducting exploratory data analysis (EDA), running A/B tests, and building intuitive, interactive dashboards that empower non-technical stakeholders to explore key metrics and make strategic decisions. Experienced in the full Software Development Life Cycle (SDLC) and Agile methodologies, with a proven ability to collaborate with cross-functional teams and drive data-informed decision-making in fast-paced environments. TECHNICAL SKILLS

Languages: Python (NumPy, Pandas, Matplotlib, Scikit-learn), R, SQL (MySQL, SQL Server) Methodologies: Agile(Scrum), Waterfall, SDLC

Business Intelligence: Tableau, Power BI (DAX, Power Query), Looker, Google Analytics Databases: MySQL, SQL Server, Snowflake, AWS Redshift, Oracle DB, Azure Cosmos DB Documentation: FRD, BRD, SRS

Automated Reporting: Microsoft Excel (VBA, PivotTables), Crystal Reports, SQL Server Reporting Services (SSRS), Git Data Analysis: Cost/benefit, Impact, GAP, Risk, SWOT analysis Cloud Platforms: AWS (Lambda, S3, Glue), Azure Data Factory, Google Cloud Platform (GCP) ETL Tools: SSIS, Alteryx, Talend

Other Skills: Microsoft Visio, Advanced Excel, MS Office (Excel, PowerPoint, Word, Outlook) Project Management: JIRA, Confluence, JAD, UAT

Operating System: Windows, Linux

WORK EXPERIENCE

Business Data Analyst Aetna (CVS Health) USA Sep 2023 - Current

• Collaborated with stakeholders to define key performance indicators (KPIs), gather business requirements, and design tailored reporting solutions that supported $12M in strategic healthcare programs.

• Conducted Exploratory Data Analysis (EDA) on claims and patient data using Python, uncovering trends and anomalies that improved forecasting accuracy and prevented $250K in billing errors.

• Applied statistical techniques such as regression and clustering to segment patients by risk category, supporting targeted care management and reducing readmission rates by 14%.

• Integrated Google Analytics with internal data to enhance user experience and identify drop-off points in the digital member journey, driving a

$1.1M boost in engagement efficiency.

• Built end-to-end reporting dashboards in Tableau, allowing leadership to monitor KPIs like churn risk, digital engagement, and cost utilization.

• Led A/B testing to optimize outreach strategies, increasing member engagement rates by 18% through data-backed experimentation.

• Partnered with cross-functional teams (product and operations) to align data models with business needs, boosting turnaround time by 25%.

• Extracted and transformed datasets via SQL Server and Azure Data Factory, cutting report generation time from 6 hours to under 30 minutes.

• Ensured data accuracy and governance by developing FRD/BRD documentation and SOPs, reducing rework and escalations by 40%.

• Presented insights to senior leadership, translating complex analyses into actionable strategies that supported operational decision-making. Business Data Analyst Miraicoders Technology India Feb 2020 - Aug 2022

• Developed interactive Power BI dashboards for product and marketing teams to track churn, engagement, and KPIs, enabling targeted retention strategies and boosting Customer Lifetime Value (LTV).

• Performed customer segmentation across 80K+ users using SQL and CRM behavior data, improving campaign personalization and contributing to a $200K revenue increase and higher ROI.

• Automated reporting workflows with SQL and Excel (VBA), cutting manual work by 40% and streamlining monthly reporting cycles.

• Designed ETL pipelines with SSIS and Talend to consolidate data from legacy systems and cloud platforms, enhancing reporting efficiency by 35%.

• Conducted cost-benefit and GAP analyses to evaluate new feature proposals, helping optimize $300K in internal resource allocation.

• Collaborated in Agile/Scrum environments to refine requirements in sprint cycles and supported backlog grooming for 10+ cross-functional projects.

• Participated in JAD sessions and UAT processes using JIRA and Confluence to align stakeholder expectations and validate business requirements.

• Analyzed web traffic in Google Analytics and identified funnel drop-offs, leading to a 20% increase in conversion rates post UX adjustments. EDUCATION

Northeastern University Boston, MA

Master of Science in Information Systems

May 2024

University of Mumbai Mumbai, India

Bachelor of Engineering in Electronics Engineering Jun 2021

ACADEMIC PROJECTS

Customer Churn Analysis and Prediction Alteryx, Talend, AWS Lambda, CloudWatch Apr 2024

• Predicted churn for 10K+ customers using scikit-learn, improving model precision to 87% and identifying top 5 behavioral churn indicators.

• Built ETL pipelines with Alteryx and Talend to clean and transform interaction data from 3 sources, reducing preprocessing time by 40%.

• Deployed a real-time monitoring dashboard using AWS Lambda and CloudWatch to track churn predictions and support timely decision-making. Instacart Product Recommendation System and Analysis Azure Data Factory, Python, Cosmos DB, Power BI May 2023

• Designed a product recommendation engine using Python and Azure Data Factory on 50K+ orders, generating personalized suggestions for users.

• Modeled product pairings in Cosmos DB with Gremlin across 20K+ unique item combinations, identifying high-frequency cross-sells.

• Visualized purchase trends across 600+ partners using Power BI, uncovering key reorder triggers and seasonal buying patterns. Electoral Database Management System Oracle DB, PL/SQL, ER/Studio Dec 2022

• Designed and optimized ER models in ER/Studio, reducing data redundancy by 20% and enhancing query efficiency.

• Automated election data workflows using PL/SQL, improving system responsiveness by 30% and enabling near real-time access.

• Implemented audit trail logging across 8 key tables in Oracle DB to ensure traceability and compliance with data access protocols.

Contact this candidate