About
Highly analytical Data Analyst with expertise in Microsoft Excel and Power BI, showcasing a robust portfolio of 15 projects across 10+ diverse industries including healthcare, finance, and retail. Adept at end-to-end data lifecycle management, from complex data cleaning and transformation to generating actionable insights and compelling visual storytelling. Seeking to leverage advanced analytical skills and industry versatility in Data Analytics, Business Intelligence, or Data Visualization roles to drive data-informed decision-making.
Work
Remote, Global, US
→
Summary
Developed a comprehensive sales performance dashboard for an e-commerce platform, analyzing revenue trends, product categories, and regional sales metrics to enhance strategic decision-making.
Highlights
Designed and implemented an interactive sales dashboard using Microsoft Excel, improving visibility into key performance indicators and sales patterns.
Analyzed revenue trends and product category performance, identifying top-performing segments and areas for strategic growth.
Evaluated regional sales metrics to uncover geographical opportunities and inform targeted marketing strategies, optimizing resource allocation.
Utilized advanced Excel formulas, PivotTables, and conditional formatting to transform raw sales data into actionable, executive-ready insights.
Remote, Global, US
→
Summary
Conducted a comprehensive procurement analysis for healthcare facilities, covering supplier performance, cost efficiency, and equipment acquisition trends to optimize operational spending.
Highlights
Developed a detailed procurement dashboard in Microsoft Excel, providing comprehensive insights into supplier performance and cost efficiency.
Analyzed equipment acquisition trends across multiple healthcare facilities, identifying opportunities for bulk purchasing and cost savings.
Tracked key procurement metrics to ensure optimal inventory levels and reduce waste by an estimated 10-15%.
Transformed complex procurement data into clear visualizations, enabling stakeholders to make informed decisions on purchasing strategies.
Remote, Global, US
→
Summary
Performed an in-depth insurance cost analysis, exploring correlations between patient demographics, medical conditions, and insurance charges to surface actionable insights for risk assessment.
Highlights
Executed a detailed insurance cost analysis using Microsoft Excel, identifying key correlations between patient data and medical expenses.
Analyzed patient demographics and medical conditions to pinpoint high-cost drivers, informing targeted intervention strategies.
Surfaced actionable insights from complex insurance charge data, contributing to improved risk profiling and policy development.
Utilized statistical methods within Excel to quantify relationships, enhancing the accuracy of predictive models for medical expenses.
Remote, Global, US
→
Summary
Conducted a retail performance deep-dive for a superstore, covering product profitability, regional breakdowns, shipping modes, and customer segment contributions to optimize sales strategies.
Highlights
Performed a comprehensive retail sales analysis in Microsoft Excel, uncovering critical insights into product profitability and sales trends.
Analyzed regional sales breakdowns to identify high-performing areas and underperforming markets, guiding localized strategies.
Evaluated the impact of various shipping modes on delivery efficiency and customer satisfaction, recommending improvements.
Assessed customer segment contributions to revenue, enabling tailored marketing campaigns and loyalty programs to increase engagement.
Remote, Global, US
→
Summary
Evaluated travel insurance claim patterns, policy uptake trends, risk profiling, and destination-based performance metrics to inform product development and risk management.
Highlights
Executed a detailed travel insurance performance analysis using Microsoft Excel, identifying key claim patterns and policy uptake trends.
Analyzed risk profiles associated with different travel destinations, providing data-driven recommendations for premium adjustments.
Evaluated destination-based performance metrics to understand regional market dynamics and inform product development strategies.
Presented complex insurance data through interactive dashboards, enhancing stakeholders' understanding of market behavior and risk exposure.
Remote, Global, US
→
Summary
Conducted a historical analysis of global aviation accidents using Power BI, identifying patterns by operator, aircraft type, geography, and time period to inform safety improvements.
Highlights
Developed an interactive Power BI dashboard for historical global aviation accident analysis, visualizing key trends and patterns.
Analyzed accident data by operator, aircraft type, and geography, identifying high-risk areas and operational factors.
Identified temporal patterns in crashes and fatalities, providing insights for preventative measures and safety enhancements.
Utilized data modeling and DAX measures in Power BI to transform raw accident data into comprehensive, decision-driving reports.
Remote, Global, US
→
Summary
Created a restaurant operations dashboard examining order volumes, menu performance, peak hours, and revenue trends across service categories to optimize operational efficiency.
Highlights
Designed and implemented a Power BI dashboard for Bliss Restaurant, providing real-time insights into order volumes and operational performance.
Analyzed menu performance to identify popular dishes and optimize offerings, potentially increasing sales by 15-20%.
Identified peak hours and revenue trends across service categories, enabling efficient staff scheduling and resource allocation.
Utilized interactive slicers and drill-through pages in Power BI to empower managers with granular data for strategic decision-making.
Remote, Global, US
→
Summary
Developed an automotive market intelligence report covering sales volume, brand performance, model preferences, and dealer-level metrics to inform sales strategies and inventory management.
Highlights
Constructed a comprehensive Power BI automotive market intelligence report, visualizing sales volume and brand performance.
Analyzed model preferences and dealer-level metrics, providing granular insights to optimize inventory and marketing efforts.
Identified key market trends and consumer behaviors, enabling data-driven adjustments to sales strategies.
Leveraged Power BI's data modeling capabilities to integrate diverse datasets, presenting a holistic view of the automotive market.
Remote, Global, US
→
Summary
Conducted a compensation landscape analysis for data science roles, benchmarking salaries by experience level, location, job title, and company size to provide valuable market insights.
Highlights
Developed a Power BI report for data science job salary analysis, benchmarking compensation across various factors.
Analyzed salaries by experience level, location, job title, and company size, providing critical insights for talent acquisition and compensation planning.
Identified salary trends and disparities within the data science market, enabling informed career and hiring decisions.
Utilized Power BI visuals and dynamic filters to present complex salary data in an accessible and interactive format.
Remote, Global, US
→
Summary
Created a macro-economic report visualizing global debt-to-GDP ratios, country-level debt trends, and year-over-year fiscal comparisons to understand economic stability.
Highlights
Constructed a Power BI macro-economic report visualizing global debt-to-GDP ratios and country-level debt trends.
Analyzed year-over-year fiscal comparisons to identify economic shifts and potential areas of concern.
Leveraged advanced data modeling and DAX measures to process complex economic datasets, ensuring data accuracy.
Presented critical global economic indicators through interactive dashboards, facilitating a deeper understanding of financial stability.
Remote, Global, US
→
Summary
Designed a financial market dashboard tracking NYSE-listed equities, sector performance, price movements, and trading volume patterns to provide real-time market insights.
Highlights
Developed a dynamic Power BI financial market dashboard tracking NYSE-listed equities and sector performance.
Analyzed price movements and trading volume patterns, identifying key market trends and investment opportunities.
Integrated multiple financial data sources to provide a comprehensive view of market activity and investor sentiment.
Enabled stakeholders to monitor market changes and make informed trading decisions through interactive visualizations.
Remote, Global, US
→
Summary
Created a customer behavior and retail performance report covering sales funnels, product mix, repeat purchase rates, and regional segmentation to optimize retail strategies.
Highlights
Developed a Power BI retail performance report, analyzing customer behavior and sales funnels to identify conversion bottlenecks.
Evaluated product mix effectiveness and repeat purchase rates, informing inventory management and loyalty program enhancements.
Conducted regional segmentation analysis to tailor marketing campaigns and product offerings, boosting regional sales by an estimated 10%.
Transformed raw sales data into actionable insights through dynamic visuals, supporting strategic planning for increased profitability.
Remote, Global, US
→
Summary
Executed an academic well-being study examining mental health indicators, prevalence by demographics, academic performance correlations, and support needs to inform intervention strategies.
Highlights
Conducted a comprehensive Power BI study on student mental health, analyzing indicators and prevalence across demographics.
Identified correlations between mental health metrics and academic performance, highlighting areas for targeted support.
Assessed student support needs, providing data-driven recommendations for improving well-being programs and resources.
Visualized complex health data to communicate critical insights to educators and administrators, fostering a supportive learning environment.
Remote, Global, US
→
Summary
Built an end-to-end supply chain analytics dashboard covering supplier KPIs, delivery performance, inventory turnover, and logistics cost optimization to enhance operational efficiency.
Highlights
Developed an end-to-end Power BI supply chain performance dashboard, tracking key supplier KPIs and delivery performance.
Analyzed inventory turnover rates and logistics costs, identifying opportunities for significant operational cost reductions.
Implemented data models to integrate various supply chain datasets, providing a holistic view of the entire process.
Enabled proactive decision-making through interactive visuals, leading to improved supply chain resilience and efficiency.
Remote, Global, US
→
Summary
Generated an e-commerce performance report for TATA's online platform, analyzing revenue trends, customer segments, and product category performance to drive strategic growth.
Highlights
Created a comprehensive Power BI e-commerce performance report for TATA's online platform, analyzing revenue trends and growth drivers.
Segmented customers to identify high-value groups and tailor marketing strategies, enhancing customer retention and acquisition.
Evaluated product category performance to optimize inventory and merchandising decisions, contributing to increased sales.
Utilized Power BI's capabilities to transform complex sales data into clear, actionable insights for business stakeholders.
Languages
English
Skills
Data Analysis & Tools
Microsoft Excel, Power Query, DAX, Power BI, Dashboards, Data Cleaning, Data Transformation, Data Modeling, Statistical Analysis, PivotTables, Advanced Formulas.
Analytical & Business Skills
Analytical Thinking, Insight Generation, Visual Storytelling, Business Intelligence, Problem-Solving, Market Analysis, Financial Analysis, Retail Analytics, Healthcare Analytics, Supply Chain Analytics, Macro-economic Analysis, Performance Metrics, Risk Profiling, Strategic Planning.