RHEA ROBERT AVLAR
551-***-**** Jersey City, NJ ************@*****.*** https://www.linkedin.com/in/rhea-avlar EDUCATION
Master of Business Administration, Business Analytics, New York Institute of Technology, New York, NY GPA: 3.60/4.0 May 2024 Diploma in Information Technology, Garware Institute of Career Education and Development, India Sept 2021 WORK EXPERIENCE
Social Media Analyst Editha House Foundation New Jersey City, NJ Sept 2024 – Present
Creating engaging social media content that reflects the foundation’s mission and maintains a stable brand voice across platforms
Tracking key metrics on social media platforms (Facebook, Instagram, Twitter, LinkedIn) to assess engagement, reach and overall routine
Planning, executing and optimizing social media campaigns to promote the foundation’s initiatives, events, and fundraising efforts
Responding to comments, messages, and inquiries to foster a strong online community and increase audience engagement
Evaluating social media trends, preparing performance reports, and using data insights to refine strategies for better results
Identifying partnership opportunities and collaborating with influencers to enhance the foundation's visibility and online presence
Organizing and maintaining a content calendar to ensure regular posting and timely promotion of events or key initiatives Junior Analyst Brain Vision Technology India May 2022 - Aug 2022
Analyzed company growth using Power BI and Tableau, spotting key trends and performance indicators to support decision-making
Developed visualizations (Maps, Combo Charts, Waterfall Charts) to share revenue, market share and customer trends effectively
Formulated strategic recommendations by identifying growth drivers and leveraging data to guide business tactics and objectives
Collaborated with other teams to gather business requirements and ensure the effective integration of data sources into BI tools
Conducted ad-hoc data analysis for senior management, providing legal insights on market performance and business strategies
Automated data reporting processes using Excel macros and Power BI, improving efficiency and reducing reporting time by 25%
Enhanced data quality by cleaning and transforming data in Excel (Power Query) to create accurate and insightful visualizations focused on revenue, market share, and customer trends PROJECT EXPERINECE
Fraud Detection: A Comparative Analysis April 2024
Evaluated model performance using metrics like accuracy, precision, recall, and F1-score to identify the most effective technique
Provided auditors with insights, enabling them to select high-risk companies based on predictions, enhancing audit efficiency
Collaborated with cross-functional teams to gather, analyze, and interpret relevant financial data for fraud detection initiatives
Maintained, optimized, and updated fraud detection models, ensuring accuracy and relevance in detecting emerging fraud trends
Conducted regular reviews of model performance, making adjustments based on new data and feedback to ensure reliability
Analyzed historical audit data (financial statements, control assessments) to identify fraud patterns, utilizing Python libraries
(Matplotlib, Seaborn) for visualizations (scatter plots, bar plots, confusion matrices) to compare models Analysis of Car Part Production and Distribution Feb 2024
Used SQL queries to filter and group car part sales data, applying Excel tools (pivot tables) to identify popular configurations
Transformed car part demand and buying patterns into insights, improving planning, optimizing logistics & influencing decisions
Collaborated with sales, production and logistics teams to gather insights, ensure data accuracy & align strategies with operations
Integrated data sources (sales, inventory, shipping) into reports and provided updates to stakeholders on metrics and trends
Identified opportunities to automate data workflows and reporting, reducing effort and enhancing decision-making efficiency
Developed Tableau dashboards to display insights for car part production, forecasting demand and adjusting production schedule Stock Market Performance Analysis Nov 2023
Conducted data analysis and visualization, identifying price trends and forecasting changes using line charts to inform decisions
Performed volatility analysis, calculating key metrics such as standard deviation and beta, to assess and visualize financial risk
Analyzed correlations between different stocks and industries, identifying variation opportunities to adjust investment strategies
Assessed liquidity ratios (current, quick) to evaluate a company's ability to meet short-term debts and enhance financial stability
Analyzed solvency ratios (debt-to-equity ratio) to evaluate a company's long-term financial stability, performance, and resilience
Compared sector performance using key metrics like P/E ratio, P/B ratio, and extra yield to provide insights for asset and growth
Evaluated profitability ratios (ROA, ROE) to assess financial health, performance and providing insights for decision-making TECHNICAL SKILLS
Data Analysis & Programming: Python, SQL, MySQL, RDBMS, Pandas, NumPy, Matplotlib, Scikit Learn, Data Wrangling, ETL
Data Visualization & Reporting: Tableau, Power BI, Advanced Excel, PowerPoint, Interactive Dashboards, Business Reporting
Financial & Business Analysis: Financial Modeling, Profitability & Cost Analysis, Forecasting, Trend Analysis, Risk Assessment
Statistical & Predictive Analytics: Regression Analysis, Predictive Modeling, Hypothesis Testing, Time Series Analysis and Data
Version Control & Collaboration: GitHub, Version Control, Code Management, Collaborative Development, Source Code Sharing
Front-End Development: HTML, CSS, Responsive Web Design, User Interface (UI) Development, Web Development Principles
Business Intelligence & Strategy: Requirements Analysis, Data-driven Decision Making, Process Improvement & Competitive
Solving & Critical Thinking: Root Cause Analysis, Process Optimization, Scenario Planning, Business Insights, Solution Design CERTIFICATIONS
Data Science and Analytics,Boston Institute of Technology 2021-2022
Post Graduate Program in Full Stack Software Engineering, National Institute of Information Technology 2019- 2020
Data Analysis and Visualization in Excel and Power BI, National Institute of Information Technology 2019- 2020