Archana Pegada Email & Phone Number

• Utilized Pandas and NumPy to clean and analyze over 500K rows of social media data, selecting key metrics for performance evaluation across multiple platforms.• Implemented sci-kit-learn models (Linear Regression, Time Series Forecasting), achieving 85% accuracy in predicting future engagement and content success rates. Analyzed social media KPIs using Meta Business Suite API for insights on engagement and growth.• Created data visualizations using Matplotlib and Seaborn, analyzing trends in 100+ posts, reels, and stories, identifying top-performing content types.• Built and maintained Tableau dashboards to track and present 10+ key performance indicators (KPIs), enhancing visibility into account growth and engagement trends.

Dayton, Ohio, United States

• Conducted in-depth analysis of inventory, transaction, and purchasing data to optimize the retail operation's supply chain data using SQL and Python, resulting in a 25% improvement in inventory accuracy.• Assisted in developing project scope and task plans, contributing to efficient project management through ETL tools and processes, reducing project completion time by 20%.• Provided critical input for developing information system requirements, enhancing system functionality with Power BI for data visualization, and increasing data reporting efficiency by 40%.• Developed detailed process flow charts and regularly reported project status to stakeholders, utilizing Microsoft Excel for comprehensive reporting, resulting in a 35% increase in report accuracy.

Dayton, Ohio, United States

Hyderabad, Telangana, India

• Spearheaded a comprehensive financial analysis project to optimize investment strategies, utilizing SQL and Python to analyze data from over 5 million transactions across various financial instruments.• Created detailed financial models in Excel to project investment returns and risk profiles, achieving a 90% accuracy rate in forecasting outcomes through Discounted Cash Flow and Comparable Company Analysis techniques.• Developed interactive dashboards in Tableau, which provided real-time insights into investment performance and risk metrics for a team of 40+ financial analysts and stakeholders.• Automated data transformation and reporting processes using Talend and Informatica, cutting down data processing time by 50% and enhancing the accuracy of investment reports.

Master'S Degree, Business Analytics

Bachelor'S Degree, International Business/Trade/Commerce