Sanjana Chitoor Mahender
Business Analyst
Denver,CO
Summary
Proven Business Data Analyst with a robust background at The Cigna Group and Hexaware Technologies, specializing in data analysis and strategic planning. Expert in leveraging Tableau and Agile methodology to enhance decision-making and operational efficiency, achieving a notable 25% improvement in forecasting accuracy. Demonstrates exceptional collaboration and project management skills, driving successful healthcare and technology initiatives.
Overview
6
6
years of professional experience
Work History
Business Data Analyst
The Cigna Group
, USA
09.2023 - Current
- Conducted ad-hoc analysis and data querying using SQL and Excel to generate business insights
- Collaborated with stakeholders to gather business requirements and translate them into functional specifications for healthcare initiatives
- Collaborated with IT teams to implement a demand planning tool, resulting in a 25% improvement in forecasting accuracy and a 10% reduction in stockouts
- Leveraged Python for strategic planning, delivering briefings for healthcare market entry planning for the business development team
- Conducted extensive interviews and facilitated stakeholder workshops to compile and document in-depth project requirements across functional requirements documents (FRDs), business requirements documents (BRDs), and user stories
- Used Jira and Confluence to track project progress, manage requirements, and facilitate team communication within healthcare projects
- Created project plans, allocated resources, and monitored timelines using MS Project
- Managed projects using agile methodology to ensure timely software delivery
- Conducted user acceptance testing (UAT) and worked closely with development teams
- Led data migration efforts from legacy databases, including SQL Server, Excel, Flat, and Access, to modernize data storage and accessibility in a healthcare setting
Business Data Analyst
Hexaware Technologies
, India
01.2019 - 07.2022
- Enhanced enterprise system integration with a new payment system, utilizing Agile methodology and collaborating with technical and business teams
- Generated comprehensive financial and customer reports using Tableau, Excel, and Power BI, driving improved sales and customer relations
- Designed interactive dashboards for informed decision-making
- Employed NumPy arrays for advanced numerical operations and Pandas Data Frames to perform data cleaning, filtering, and transformation
- Designed and implemented data models on the PostgreSQL database, including tables, views, and functions
- Played a key role in PeopleSoft implementations, focusing on testing and process consulting for successful system deployment
- Created UML diagrams for effective project communication
- Conducted market research and analyzed consumer behavior for data-driven decision-making, using Tableau, Power BI, and Google Data Studio for interactive visualizations
- Improved supply chain efficiency by analyzing KPIs, resulting in a 12% increase
- Collaborated on cross-functional teams for targeted marketing campaigns aligned with market research and consumer preferences
- Conducted competitive analysis to enhance brand awareness and market share
- Prepared concise reports for senior management, enabling data-driven decision-making and strategic planning
- Conducted data cleansing and validation for accurate and reliable analysis
- Collaborated on data models and databases, optimizing storage and accessibility
- Utilized statistical analysis and visualization tools for operational efficiency improvements and enhanced customer experience
- Assisted in implementing data-driven solutions
Education
Master in Information Systems - Business Intelligence
University of Colorado Denver
Denver, CO05.2024
Master of Dental Surgery - Oral Pathology
Dr. MGR Medical And Research Institute
Chennai, India07.2021
Bachelor of Dental Surgery -
The Tamil Nadu MGR Medical University
Chennai, India11.2017
Skills
- Agile Methodology
- Waterfall
- SDLC
- SharePoint
- Jira
- Confluence
- Trello
- MS Project
- Apache Spark
- MS Azure
- Tableau
- Power BI
- Google Data Studio
- Data Analysis
- Regression Analysis
- Market Research
- Business Analysis
- Business Intelligence
- Product Analysis
- Business Forecasting
- Strategic Planning
- Data Mining
- Predictive Analytics
- Statistical Analysis
- Data Governance
- Data Warehousing
- MYSQL
- RDBMS
- Microsoft SQL Server
- MS Office
- Excel Add-Ins
- Google Analytics
- MS Visio
- MS Dynamics 365
- PeopleSoft
- Windows
- Linux
- Mac
- SAS programming
- Predictive modeling
- Advanced Excel
- Tableau software
Timeline
Business Data Analyst
The Cigna Group
09.2023 - Current
Business Data Analyst
Hexaware Technologies
01.2019 - 07.2022
Master in Information Systems - Business Intelligence
University of Colorado Denver
Master of Dental Surgery - Oral Pathology
Dr. MGR Medical And Research Institute
Bachelor of Dental Surgery -
The Tamil Nadu MGR Medical University
Similar Profiles
Jerece DennisJerece Dennis
Provider Service Representative at The Cigna GroupProvider Service Representative at The Cigna Group
Ellie PolackEllie Polack
Managing Director at The Cigna GroupManaging Director at The Cigna Group
Christopher M. StewartChristopher M. Stewart
Risk Management and Underwriting LDP at The Cigna GroupRisk Management and Underwriting LDP at The Cigna Group
Diandra Hippolyte McKnightDiandra Hippolyte McKnight
Supplemental Health Benefits Specialist at The Cigna GroupSupplemental Health Benefits Specialist at The Cigna Group
Lauren McHorseLauren McHorse
Personal Assistant at RBA Skin CarePersonal Assistant at RBA Skin Care