Nupur Joshi
Denton,TX
Summary
Results-driven Senior Data Analyst at Cigna with expertise in SQL and Python, delivering actionable insights that reduced reporting effort by 40%. Proven ability to design impactful Power BI dashboards and collaborate effectively with cross-functional teams, enhancing decision-making and operational efficiency in healthcare analytics.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Cigna
07.2023 - Current
- Designed interactive Power BI dashboards tracking patient readmissions, claims lifecycle metrics, and cost per episode of care, enabling healthcare executives to monitor performance KPIs and identify improvement opportunities.
- Analyzed healthcare claims and patient data using SQL and Python (Pandas, NumPy) to identify denial trends, processing patterns, and readmission risks, providing actionable insights to clinical and operations teams.
- Built predictive models using scikit-learn and XGBoost to forecast patient hospitalization risk and readmission likelihood, supporting care management teams in identifying high-risk patients for early intervention programs.
- Developed automated reporting pipelines that extracted data from multiple sources using SQL and Python, ensuring consistency across monthly and quarterly reports and significantly reducing manual reporting effort.
- Performed statistical analysis including hypothesis testing, correlation analysis, and regression modeling in Python and R to assess effectiveness of chronic disease management programs on patient outcomes.
- Created data quality validation frameworks using SQL and Python, implementing automated checks that enhanced accuracy and completeness of clinical data.
- Collaborated with data engineering teams to optimize Snowflake data warehouse queries and table structures, improving dashboard refresh times by 30% through proper indexing and partitioning strategies.
- Developed HIPAA-compliant data anonymization and masking solutions in Python to enable safe analytics on protected health information (PHI) while maintaining data utility for analysis.
- Conducted ad-hoc analysis using SQL to support business initiatives including provider network optimization, claims processing efficiency, and member satisfaction improvement programs.
- Partnered with business stakeholders in Agile ceremonies to gather requirements and prioritize analytics requests, delivering insights aligned with organizational goals and compliance standards.
- Environment: SQL, Python (Pandas, NumPy, scikit-learn), Power BI, Tableau, Snowflake, AWS (S3, Glue), Azure (Data Factory, SQL Database), Excel, Git, JIRA, HIPAA Compliance, Agile/Scrum.
Data Analyst
Bank Of America
Richardson, TX
06.2022 - 06.2023
- Analyzed credit card usage patterns, payment behavior, and default risk using advanced SQL queries with CTEs, window functions, and joins, enhancing customer segmentation and risk scoring models.
- Developed Power BI and Tableau dashboards to monitor revenue trends, customer churn rates, customer acquisition cost (CAC), and product profitability across card portfolios, facilitating data-driven strategic decisions.
- Automated fraud trend analysis using Python (Pandas, NumPy, Matplotlib) to identify anomalous transaction patterns, providing insights to fraud prevention teams resulting in 25% reduction in false positives.
- Built ETL workflows using SSIS and Alteryx to integrate data from multiple sources including transactional systems, CRM, and external data feeds, standardizing data for unified reporting and analysis.
- Developed interactive dashboards in Power BI tracking KYC completion rates, debt-to-income ratios, and credit utilization metrics, improving underwriting efficiency and compliance monitoring.
- Conducted A/B testing for rewards campaigns using Python and SQL to analyze customer response rates and ROI, providing recommendations that improved campaign effectiveness by 20%.
- Performed credit risk analysis using XGBoost and logistic regression to identify early delinquency indicators, supporting collections strategies and reducing default rates.
- Ensured PCI-DSS compliance by implementing SQL-based data encryption and masking techniques for sensitive customer information including SSNs and card numbers, working with compliance teams on audit requirements.
- Streamlined SQL queries through indexing, partitioning, and query execution plan analysis, enhancing performance on large-scale financial datasets with millions of transactions.
- Partnered with business analysts and product managers to define KPIs and design analytical frameworks, delivering insights that support lending decisions and portfolio management strategies.
- Environment: SQL (SQL Server, Oracle), Python (Pandas, NumPy, scikit-learn, XGBoost), Power BI, Tableau, SSIS, Alteryx, Excel, Git, JIRA, PCI-DSS Compliance, Agile/Scrum.
Business Analyst / Data Analyst
BNY Mellon
Pune, India
07.2016 - 07.2021
- Analyzed financial transactions, account activities, and customer behavior using SQL to identify trends in retail banking operations, supporting product development and customer retention strategies.
- Built Power BI dashboards tracking operational KPIs including transaction volumes, account openings, customer demographics, and service quality metrics providing visibility to management teams.
- Developed automated reporting pipelines using SQL stored procedures and Python scripts to extract, transform, and analyze banking data, reducing manual reporting time by 50%.
- Performed customer segmentation analysis using K-means clustering and RFM analysis in Python to identify high-value customer segments, enabling targeted marketing campaigns.
- Conducted time series forecasting using Python statistical libraries to predict transaction volumes and account growth, informing capacity planning and resource allocation.
- Created data quality monitoring frameworks using SQL validation queries to ensure accuracy and consistency of financial data across source systems and reporting databases, enhancing data integrity for reporting.
- Collaborated with business stakeholders to gather requirements, define metrics, and design analytical solutions addressing key business questions in retail banking and wealth management domains.
- Developed ETL workflows using Alteryx and SQL to integrate data from multiple banking systems, enabling consolidated reporting and analysis across product lines.
- Performed ad-hoc analysis using SQL and Excel to support regulatory reporting, audit requests, and business initiatives requiring data-driven insights.
- Documented data definitions, business rules, and analytical methodologies in centralized data dictionary, improving data literacy and streamlining analysis requests across teams.
- Environment: SQL (Oracle, SQL Server), Python (Pandas, NumPy, Matplotlib), Power BI, Tableau, Excel, Alteryx, Git, JIRA, Agile/Scrum.
Business Analyst
Ananth Technologies
Nashik, India
12.2014 - 06.2016
- Collaborated with engineering and manufacturing departments to analyze project costs, resource utilization, and production efficiency across aerospace manufacturing units.
- Analyzed cost drivers, production bottlenecks, and schedule variances across multiple aerospace programs to support leadership decision-making.
- Developed KPI tracking systems aligned with aerospace project requirements, improving delivery monitoring and ensuring compliance with internal audit and regulatory frameworks.
- Developed Excel-based dashboards and reporting models to track project milestones, budget variance, and resource allocation, improving visibility for project managers and stakeholders.
- Facilitated communication between teams to gather and clarify business requirements for data analysis.
- Built system requirements and functional documentation for PLM-aligned processes, ensuring traceability and alignment with organizational standards.
- Designed and maintained standardized reporting frameworks for program health, incorporating cost, schedule, scope, and resource utilization metrics.
- Performed variance analysis (planned vs. actual) on project budgets and timelines, identifying root causes and recommending corrective actions.
- Automated recurring Excel and SQL-based reports using Power Query, reducing manual effort and improving reporting turnaround time.
- Supported capacity planning and workforce utilization analysis to optimize resource allocation across manufacturing units.
- Collaborated with quality and compliance teams to define and report KPIs that met internal audit and regulatory standards.
- Worked with ERP and legacy systems to consolidate data for centralized reporting, reducing manual workflows and improving data accuracy.
- Improved project reporting efficiency by 25–30% by automating Excel and SQL-based dashboards.
- Reduced manual data consolidation errors by implementing centralized ERP-driven reporting solutions.
- Enhanced project visibility for stakeholders by standardizing KPI definitions across multiple aerospace programs.
- Conducted training sessions for stakeholders on reporting systems and analytical tools, improving adoption rates and reducing support requests.
- Environment: Excel, SQL, Power Query, ERP Systems, Project Management Tools.
Education
Master of Science - Finance
University of North Texas
Denton, TX01.2023
Bachelor of Technology -
University
India01.2014
Skills
- Database management (SQL: Oracle, MySQL, PostgreSQL, SQL Server, MongoDB, Snowflake)
- Excel proficiency and Power Query
- Statistical methods and hypothesis testing
- Data visualization tools (Power BI, Tableau, QlikView)
- Reporting and dashboard design
- Python libraries (Pandas, NumPy, Matplotlib, Seaborn)
- R language expertise
- Basic SAS and data integration tools (SSIS, Informatica, Alteryx)
- Cloud services (AWS: S3, Glue, Redshift; Azure: Blob Storage, Data Factory)
- Predictive analytics (Scikit-learn, XGBoost)
- Version control platforms (Git, GitHub, Bitbucket)
- Scrum framework
- Compliance with data governance standards (HIPAA/GDPR)
Certification
- Financial Accounting I & II — Coursera
- Excel to Tableau Data Visualization — Coursera
- Learning AWS QuickSight — LinkedIn Learning
- SAP Financials Essential Training — LinkedIn Learning
- Asset Management Virtual Experience — J.P. Morgan Chase (Forage)
Timeline
Senior Data Analyst
Cigna
07.2023 - Current
Data Analyst
Bank Of America
06.2022 - 06.2023
Business Analyst / Data Analyst
BNY Mellon
07.2016 - 07.2021
Business Analyst
Ananth Technologies
12.2014 - 06.2016
Master of Science - Finance
University of North Texas
Bachelor of Technology -
University