Tableau
Aparna Raghavendra Rao
Analyst
Silver Spring,USA
Summary
Detail-oriented analyst adept at collecting, analyzing, and interpreting large datasets to support data-driven decision-making. Strong communicator, proficient in analytical tools and data visualization, with a proven track record of driving strategic decisions and improving operational efficiency.
Overview
5
5
years of professional experience
2
2
years of post-secondary education
Work History
Business Analyst
Capstone Project in Business Analytics
College Park, Maryland
08.2023 - 12.2023
- Performed a comprehensive analysis of leisure travel trends in the airline industry and executed SQL queries on Snowflake to extract a dataset exceeding 20 million records and navigated dual dimensionality complexity successfully
- Engineered a Python script to efficiently clean and preprocess data, reducing cleaning time by 70% and ensuring data consistency
- Created interactive dashboards on Tableau, presenting key insights on market & seasonal trends and competitor performance
- Uncovered critical insights regarding airfare fluctuations during specific periods of the year, providing valuable strategic recommendations
Data Analyst Intern
Center for Global Business - Maryland Global Consulting Program
College Park, Maryland
06.2023 - 08.2023
- Performed exploratory data analysis, identified complex trends and patterns for a small business manufacturing consumer products
- Created data-driven, interactive visualizations, and Tableau dashboards recognizing 8 key areas requiring attention to foster strategic expansion and optimize operational effectiveness
- Engineered tailored Excel spreadsheets for sales data analysis and inventory management, highlighting 10 key metrics to aid strategic decision-making
- Translated client needs into qualitative technical solutions and recommended 3 best practices to improve operational efficiency
Management Trainee - Finance & Accounts
Allanasons Private Limited
Bengaluru
01.2021 - 11.2021
- Conducted comprehensive market and competitor analysis using Excel & R to inform strategic insights, while supporting senior management in drafting business plans, brand mapping, coordinating with stakeholders, and facilitating equipment purchase decisions of approximately $100, 000
- Enhanced flow of inter-departmental communication between 6 functional departments by developing a Microsoft Excel tracker & ensured quality control of operational planning presentations
- Expedited decision-making processes by creating a cost of raw materials format and a stock position report format for the coffee business within a 20-day time frame, delivering an 83% reduction in processing time
Financial Analyst Intern
TATA Coffee Limited
Bengaluru
04.2019 - 05.2019
- Developed a Microsoft Excel & VBA Macros-based model for automating the Accounts Receivable and Accounts Payable process, resulting in a 30% reduction in time and effort for data management, facilitating management in financial planning and analysis decisions
Education
Post Master's Advanced Certificate - Data Science
Monroe College
New Rochelle, NY 01.2024 - Current
Master of Science - Business Analytics
University of Maryland
College Park, MD 08.2022 - 12.2023
Software
SQL
R
Python
Microsoft Excel
Microsoft PowerPoint
Snowflake
Google Colaboratory
Excel Solver
ARENA
PowerBI
SAS
Skills
- Data Mining
- Data Analysis
- Requirements Gathering
- Business process improvement
- Consulting
- Microsoft Office Suite
- Pivot tables
- Competitive Analysis
- Data Modeling
- Report Writing
- Analytical Problem Solving
- Strong Work Ethic
- ETL processes
- Tableau
- Statistical Analysis
- Python Programming
- Statistics and SAS
- Database Programming and SQL
- Attention to Detail
- Data Science
- Clear and Concise Communication
- Data Visualization and Presentations
Publications
Coupling of Currencies: An INR and USD Perspective, Ushus-Journal of Business Management: Co-authored a paper in 2019 focused on currency coupling employing Granger Causality analysis.
Languages
English
Full Professional
German
Professional
Projects
Maternal Health Risk Prediction [02/2024 - 04/2024]
- Developed a predictive maternal health risk assessment application in R, using Multinomial Regression, Decision Trees, and K-Nearest Neighbors. Visualized data and derived insights using ggplot2.
- Implemented proactive healthcare & health management features, issuing warnings for abnormal patient vitals within the application.
HR Analytics on Tableau [04/2023 - 05/2023]
- Created Tableau dashboards and a compelling data story on HR analytics, utilizing advanced concepts to display key metrics with the objective of identifying and addressing factors contributing to attrition. These efforts facilitated the development of actionable measures aimed at minimizing this critical issue.
Inventory Management System [11/2022 - 12/2022]
- Conceptualized, designed & developed an inventory management system to track, manage & analyze the inventory stock and product movement using Lucidchart, & SQL Server
Timeline
Post Master's Advanced Certificate - Data Science
Monroe College
01.2024 - Current
Business Analyst
Capstone Project in Business Analytics
08.2023 - 12.2023
Data Analyst Intern
Center for Global Business - Maryland Global Consulting Program
06.2023 - 08.2023
Master of Science - Business Analytics
University of Maryland
08.2022 - 12.2023
Management Trainee - Finance & Accounts
Allanasons Private Limited
01.2021 - 11.2021
Financial Analyst Intern
TATA Coffee Limited
04.2019 - 05.2019
Similar Profiles
Aman ModyAman Mody
Data Analyst at MIS, BUSINESS DATA MANAGEMENT & DATA ANALYTICS PROJECTData Analyst at MIS, BUSINESS DATA MANAGEMENT & DATA ANALYTICS PROJECT
Ankiambom Nkesa NkesaAnkiambom Nkesa Nkesa
Project Manager at Project Management Capstone: Acme Health Innovations Marketing Application Development Project. Courtesy Coursera IBM IT Project Manager Professional Certificate CourseProject Manager at Project Management Capstone: Acme Health Innovations Marketing Application Development Project. Courtesy Coursera IBM IT Project Manager Professional Certificate Course
Matthew HallMatthew Hall
Student Consultant at University of South Carolina OSC Capstone ProjectStudent Consultant at University of South Carolina OSC Capstone Project