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.
• 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