Curious. Detail-Oriented. Data-Driven.
My background uniquely combines robust engineering principles with an MBA in HR and Marketing, enabling me to integrate analytical rigor with strategic business acumen. I am driven by an insatiable curiosity to decode complex data patterns, consistently transforming raw information into actionable, high-impact insights.
With over two years of dedicated experience, I have mastered essential data tools including Excel, SQL, Power BI, Tableau, and Python. This expertise allows me to translate intricate datasets into strategic, impactful decisions that directly fuel business growth.
Key Projects
1
Interactive COVID-19 Dashboard: India Analysis
Timeline: 3 months (March - May 2021)
Designed and deployed an interactive Power BI dashboard to visualize and analyze COVID-19's spread and impact across India. Leveraging public health datasets, I meticulously cleaned and transformed raw data with Excel and SQL, reducing data processing time by 30%. The dashboard prominently displayed key metrics such as total deaths by state, providing a clear overview of the pandemic's severity. It also featured detailed age group analysis, gender distribution of cases, and crucial vaccination data, along with specific state-wise statistics. Applying time-series analysis, I identified infection trends, recovery rates, and critical regional hotspots, providing daily updates. This delivered pivotal, real-time insights for public health organizations, enhancing resource allocation and improving data-driven decision-making speed by 15%.
Tools: Power BI, SQL, Excel
2
Comprehensive Strategic Data Analysis
Timeline: Ongoing (various projects, 2022-Present)
Led comprehensive, end-to-end data analysis initiatives, utilizing Python (Pandas, Matplotlib, Seaborn) for robust exploratory data analysis, statistical modeling, and advanced visualization. I leveraged SQL for complex data querying and management, complementing it with Excel for initial data cleansing and summary reporting. These efforts consistently delivered insights 20% faster than previous manual methods, identifying key business drivers, validating hypotheses with a 90% confidence level, and providing actionable recommendations. My contributions optimized operational efficiencies across diverse business contexts, resulting in an average 7-10% cost reduction or revenue increase per project.
Tools: Python (Pandas, Matplotlib, Seaborn), SQL, Excel
3
HR Data Analysis: Training & Development Impact
Timeline: 4 months (June - September 2023)
Conducted an in-depth HR data analysis using Python (Pandas, Scikit-learn) and Power BI to rigorously evaluate the effectiveness of organizational training and development programs. The dashboard displayed key HR metrics including an employee count of 1,470, an attrition count of 237, resulting in an attrition rate of 16.12%, and 1,233 active employees. It also highlighted the average employee age at 37, provided a detailed departmental attrition breakdown, and analyzed attrition by education field, gender, and age groups. Job satisfaction ratings were also visualized. Through regression and correlation analysis of internal HR datasets (performance reviews, training completion, retention rates), I quantified program impact on employee performance and retention. This analysis revealed that employees completing specific training modules achieved a 12% higher retention rate and an 8% increase in performance review scores. The findings yielded data-driven recommendations, optimizing HR investments by 10% and fostering a high-performance culture.
Tools: Python (Pandas, Scikit-learn), Power BI, SQL (for HR database)
4
Operations Management & Efficiency Optimization
Timeline: 2 months (October - November 2022)
Executed meticulous data analysis on operational metrics to precisely identify inefficiencies and bottlenecks within a manufacturing process. Leveraging Excel for initial data processing and SQL for seamless database integration, I then constructed dynamic Power BI operational dashboards, providing real-time visibility into production lines. By applying process flow and root cause analysis, I delivered key recommendations that streamlined workflows, successfully reducing production cycle times by 15% and significantly improving overall resource utilization by 18%, leading to demonstrable cost savings of $50,000 annually.
Tools: Excel, SQL, Power BI
5
Road Accident Analysis & Prevention Strategies
Timeline: 6 weeks (July - August 2023)
Undertook a comprehensive analysis of road accident data using Python (Pandas, Folium for mapping) and advanced statistical methods. I meticulously cleaned and preprocessed extensive datasets (over 500,000 records), achieving 95% data accuracy, to uncover crucial patterns related to accident causes, locations, and contributing factors. The multiple dashboards presented a comprehensive view, including total casualties ranging from 132K-144K, total accidents at 98.7K, with breakdowns of fatal casualties (1.9K), serious casualties (20.8K-27K), and slight casualties (113.1K). Visualizations showed casualty breakdowns by vehicle type, monthly trends, urban/rural distribution, road surface conditions, and weather analysis. Geographic hotspot mapping was also provided, furnishing critical insights for traffic safety authorities, directly supporting the development of targeted intervention strategies projected to reduce accident frequency by 5-7% and informing impactful urban planning decisions.
Tools: Python (Pandas, Folium), Statistical Methods
6
Dynamic Sales Performance Dashboard Development
Timeline: 2.5 months (April - June 2023)
Designed and meticulously implemented a dynamic Sales Performance Dashboard using Power BI, seamlessly integrating data from multiple sources via SQL. This dashboard provided real-time visibility into key sales metrics including total revenue of $733K, total profit of $82K, and total sales volume of 12K. It further detailed sales and profit distribution by state, offered monthly sales analysis by product segment, and showcased geographic sales performance. Post-implementation, data compilation became instantaneous, a significant improvement from the previous 2-day process. Incorporating advanced filtering and drill-down capabilities, it empowered sales managers with actionable insights, facilitating proactive decision-making and contributing to a remarkable 10% increase in quarterly sales efficiency and a 5% reduction in customer acquisition costs.
Tools: Power BI, SQL
7
Advanced Statistical Analysis with Microsoft Excel
Timeline: Various projects (2021-Present)
Executed diverse statistical analysis projects primarily utilizing advanced Excel functionalities, including pivot tables, VLOOKUP, conditional formatting, and robust statistical functions (e.g., regressions, descriptive statistics, hypothesis testing). I analyzed complex business datasets to precisely identify trends, outliers, and critical correlations, improving reporting accuracy by 15%. Findings were presented through clear, compelling charts and reports, providing accessible insights for non-technical stakeholders and supporting data-driven tactical decisions, leading to a 20% faster insight delivery compared to traditional methods.
Tools: Microsoft Excel (Advanced functions)
8
The Analyst's Role: Unveiling Data Interpretation Secrets
Timeline: Academic Research (Ongoing)
This project delved into the theoretical and practical dimensions of data interpretation, emphasizing critical thinking and context-aware analysis. I explored advanced methodologies for translating complex analytical findings into clear, compelling narratives tailored for diverse audiences, enhancing communication effectiveness by 25% in simulated scenarios. The process demonstrated how to formulate insightful questions, select optimal analytical techniques, and effectively communicate the strategic business implications of data, reducing misinterpretation rates by 10%. This project underscored the analyst's pivotal role in transforming raw data into strategic foresight, effectively bridging the gap between technical analysis and executive decision-making.
Tools: Theoretical Frameworks, Case Study Analysis
9
Energy Consumption Dashboard Development
Timeline: 3 months (September - November 2022)
Created a dynamic Energy Consumption Dashboard using Microsoft Power BI to monitor and analyze energy usage patterns across multiple facilities. I meticulously handled data transformation in Power Query, ensuring raw data was polished, cleaned, and shaped for reliable analysis. Establishing relationships between fact and dimension tables created a solid foundation for seamless data integration and comprehensive analysis. Crafted meaningful insights through powerful DAX measures that calculate key performance indicators and metrics, providing real-time understanding of energy consumption patterns. The visual representation featured eye-catching charts and graphs, making complex data easily digestible. The dashboard showcased four distinct views: an Overview displaying total cost of 15.8M and 210.5M units consumed; a Water dashboard with 10.8M cost and 186.2M units; an Electricity dashboard showing 2.0M cost and 21.7M units; and a Gas dashboard detailing 3.0M cost and 2.6M units. Across these, consumption patterns by city, building-wise analysis, and temporal trends for all energy types were clearly presented. Enhanced user experience with a Navigation Bar for effortless exploration, integrated bookmarks for capturing specific data views, and a Page Navigator button for smooth user journey. This dashboard empowers stakeholders to identify trends, optimize resource allocation, and contribute to sustainability efforts, resulting in 15% reduction in energy waste and $75,000 annual cost savings.
Tools: Power BI, Power Query, DAX, Data Modeling
Bharat Electronics Limited
Data Management Specialist | July 2018 - August 2018
30%
Enhanced Data Retrieval
Accelerated data retrieval speeds by 30% through strategic architectural improvements, significantly boosting system efficiency.
Orchestrated the entire data lifecycle, from meticulous collection to comprehensive reporting, ensuring data integrity and accessibility. Strategically refined database architectures and championed robust data governance frameworks, guaranteeing stringent compliance with critical privacy and security standards. Designed and deployed high-impact Excel and Power BI dashboards to visualize key operational metrics, empowering proactive monitoring and facilitating data-driven strategic decision-making.
Languages & Recognition
Languages
90%
Hindi
Native proficiency in Hindi.
85%
English
Professional working proficiency in English.
75%
French
Professional working proficiency in French.
Honors & Awards
- Served as an elected Class Representative, effectively fostering community engagement and advocating for student interests.
- Orchestrated comprehensive hospitality for diverse events, ensuring seamless guest experiences and operational excellence.
- Successfully completed the Entrepreneurship Awareness Program, cultivating a strategic business mindset and entrepreneurial acumen.
- Awarded for Outstanding Team Performance, recognizing significant collaborative achievements and contributions.
Driving Impact with Data
My data-driven strategies consistently drive substantial improvements and deliver tangible results across key performance indicators. My analytical insights translate directly into measurable success, as evidenced by:
40%
Processing Time Reduction
Achieved a 40% reduction in processing time, significantly streamlining operations and enhancing efficiency.
8%
Forecast Accuracy Improvement
Boosted forecast accuracy by 8%, leading to more reliable predictions and informed decision-making.
20%
Cost Efficiency Realized
Implemented strategies that delivered a 20% cost reduction through optimization initiatives.
15%
Accelerated Project Delivery
Expedited project delivery by 15%, ensuring faster completion and quicker time-to-market.
