Anand Dalvi
Data Analyst | Economic Researcher | Python & Power BI Enthusiast
Aundh Camp, Pune – 411027
About Me
Aspiring data analyst with strong economic modelling and statistical skills, currently pursuing M.Sc. Economics with specialization in Data Analytics from Symbiosis School of Economics. Experienced in analysing large datasets across various sectors including GST, banking, and audit.
Proficient in R, Python, SQL, Excel, and Power BI, with a proven ability to translate data into actionable insights for business stakeholders. My analytical approach combines rigorous economic theory with modern data science techniques to solve complex business problems.
Core Expertise
Technical Skills
Programming & Analytics
Data Visualization
Statistical Techniques
Business Tools
Professional Experience
Data Analyst Intern
- Supported cross-functional departments including GST, Internal Audit, and Banking operations
- Analyzed financial and operational datasets using Python and Power-BI for business insights
- Automated reporting workflows and standardized data pipelines, improving efficiency by 40%
- Collaborated with teams to enhance internal review processes and audit procedures
Research Assistant
- Completed comprehensive research projects, compiled data, and assisted in timely reporting
- Attended meetings and presentations to understand project requirements and scope
- Visualized research findings through data tables, graphs, and presentations
- Updated spreadsheets and produced detailed analytical reports for stakeholder review
Academic & Research Projects
🌍 Urban Air Pollution and Economic Implications Research
White Paper Research (2021-2023)
Comprehensive analysis of air quality in Pune, Hyderabad, and Bangalore using advanced data mining techniques. Employed K-means clustering, seasonal decomposition of time series, and correlation analysis to uncover pollution patterns and their economic impact.
Key Findings: Identified critical seasonal peaks in winter affecting public health and economic losses. Clustering analysis placed Pune in the most critical category for intervention.
- Applied K-means clustering to identify pollution hotspots across three major cities
- Conducted seasonal decomposition analysis revealing winter pollution spikes
- Developed phased policy roadmap for urban air quality management
- Quantified economic implications of air pollution on urban productivity
📊 RBI Banking Data Analysis Dashboard
Developed comprehensive Power BI dashboard analyzing banking sector transactions, ATM operations, and credit/debit card usage patterns across different bank segments.
- Processed and visualized transaction data worth ₹305+ billion across multiple banks
- Created interactive dashboards showing monthly trends and bank performance metrics
- Implemented advanced filtering and drill-through capabilities for detailed analysis
- Identified key insights in ATM cash withdrawal patterns and digital transaction growth
🔗 Supply Chain Optimization Model
Built advanced logistics optimization model using GAMS (General Algebraic Modeling System) to improve cost efficiency in supply chain operations.
- Developed mathematical optimization models for logistics cost reduction
- Implemented linear programming techniques for resource allocation
- Achieved significant cost savings through optimized routing and inventory management
- Created detailed documentation and sensitivity analysis reports
👩⚕️ Women's Health Issues Across India - Bachelor's Thesis
Comprehensive research study analyzing gender-specific health challenges across India using secondary survey data from National Housing Survey.
- Designed research methodology based on National Housing Survey parameters
- Collected and analyzed data from national government websites
- Assessed impact of health-related precautions and treatments in gender context
- Utilized advanced Excel for statistical analysis and data visualization
Education
Master of Science in Economics (Data Analytics Specialization)
Expected: 2026 | Current CGPA: 6.5/10
Coursework: Data Mining, Data Analysis & Visualization, Big Data, Financial Analytics, Advanced Econometrics
Bachelor of Science in Economics
Graduated: 2024 | CGPA: 6.6/10
Coursework: Microeconomics, Macroeconomics, Econometrics, Statistical Methods, Mathematical Economics
Professional Certifications
🐍 Introduction to Python Programming
University of Pennsylvania, Coursera
Comprehensive foundation in Python syntax, control structures, and object-oriented programming principles
📊 Data Collection and Processing with Python
University of Michigan, Coursera
Advanced techniques for data collection, cleaning, and processing using Python libraries
🔬 Introduction to Data Science in Python
University of Michigan, Coursera
Data manipulation, statistical analysis, and visualization using pandas, NumPy, and matplotlib
📱 Social Media Data Analytics
University of Washington, Coursera
Advanced techniques for analyzing social media data patterns and trends
📝 Applied Text Mining in Python
University of Michigan, Coursera
Natural language processing and text analysis using Python libraries and NLTK
📊 Power BI for Data Science and Analytics
Edureka
Part of Mastering Power BI for Data Analytics & Storytelling Specialization - Advanced dashboard creation and data visualization
💰 Financial Markets
Yale University, Coursera
Comprehensive understanding of financial markets, instruments, and analysis
Extra-Curricular Activities
Sports & Fitness
Passionate cyclist with regular participation in local cycling events and fitness activities
Event Management
Registration team member for Niverve fest, handling logistics and participant coordination
Strategic Gaming
Strategy-based online gaming enthusiast, developing analytical and quick decision-making skills
Languages
Get In Touch
anand.dalvi.2024@sse.ac.in
Phone
+91 70209 69649
Location
Aundh Camp, Pune – 411027
GitHub
github.com/anandd31