Saloni Vichare

Dallas, Texas(Open to relocate) • ad46xx@r.postjobfree.com • 469-***-**** • https://www.linkedin.com/in/salonivichare/ Result driven Business Analyst with over 3 years of experience skilled at data analysis, process optimization, and identifying solutions to enhance efficiency. Proficient in SQL, PowerBI, Tableau, Scrum, JIRA, Excel to gather requirements, analyze data, and develop solutions. SKILLS

Programming: SQL, VBA, Python

Database Management: NoSQL, Cosmos DB, MS Azure, MySQL, Snowflake, Oracle, MongoDB, Teradata, Microsoft Access Data Visualization Tools: Microsoft PowerBI, Tableau, Alteryx, Looker, PowerPoint, Qlik, Google Sheets Analytics and Reporting Tools: Microsoft Excel (Power Query, XLOOKUP, Analytic Solver), Microsoft Power Automate, Salesforce Project Management Tools: Agile Methodology, Scrum, JIRA, Smartsheet, SharePoint PROFESSIONAL EXPERIENCE

Shreeya Hospitality LLC - Texas Jun 2022 - Dec 2023 Business Analyst

• Led the development of performance analysis for various projects 3through in-depth analysis of historical data and customer feedback using SQL and Python, resulting in an 8% increase in customer satisfaction rates. Designed dashboards on PowerBI for presentation.

• Analyzed large datasets by building optimization models on Excel (Solver, VLOOOKUPs, Pivot Tables) to develop data-driven insights.

• Designed dynamic PowerBI reports and dashboards to communicate data insights and provide business recommendations to Sales Teams and internal Stakeholders as well as tracked key performance indicators (KPIs) to measure the impact of the recommendations.

• Built SQL queries to compile, extract and analyze large datasets related to customers in order to identify trends, patterns, and insights.

• Conducted customer interviews and collaborated with cross-functional teams including UI/UX designers to synthesize user requirement, user feedback and customer insights into actionable business requirements and translate them into use cases and scenario.

• Automated reporting process by integrating Excel reports with PowerBI and generated weekly, monthly, and quarterly reports that provided insights into business trends, improving decision-making for stakeholders, hence reducing teams’ manual effort by 60%.

• Leveraged Salesforce data export and extraction tools to gather data for analysis, ensuring accurate information for decision making.

• Utilized Jira's Agile capabilities, including Scrum, to convert roadmap into smaller user stories and streamline project management methods for hotel development and event planning, significantly improving project outcomes and overall team performance.

• Successfully managed multiple projects, providing strategic recommendation to stakeholders to contribute to client’s business process. Insight Talent Solution - India Jan 2019 – May 2021 Business Analyst

• Optimized SQL queries to streamline data cleaning processes and database reporting. Generated user-friendly reports for non-technical stakeholders, increasing productivity by 20% and providing actionable recommendations for enhancing custom software solutions.

• Implemented statistical analysis on datasets having 1M+ records by building hypothesis, t-tests, and time series machine learning algorithms to forecast trends and validated findings against historical data for anomaly detection, leading to 15% risk mitigation.

• Conducted complex data analysis by writing SQL queries to verify the accuracy of reports, reducing the error rate by 20%.

• Worked closely with clients and stakeholders to gather and prioritize requirements to provide insights and analyze quantitative data.

• Published ad-hoc PowerBI dashboards using DAX functions to visualize complex business problems while providing insightful solutions.

• Conducted data visualization and data analysis by automating Excel reports using Macros and VBA programming.

• Executed market research to identify business requirements and developed Python scripts for performing data quality checks.

• Employed Excel functionalities such as Pivot tables, data validation, and conditional formatting to conduct in-depth data analysis, identifying industry trends, outliers, and patterns, thereby aiding in strategic decision-making processes.

• Efficiently managed core Agile Scrum ceremonies (Sprint Planning, Daily Stand-ups, and Sprint Reviews) with a 99% success rate and collaborated closely with Product Managers to refine backlog items, create user acceptance criteria, and gather requirements. PROJECTS

Walmart Sales Data Analysis (Technologies used: MySQL, PowerBI) Nov 2023 - Dec 2023

• Led in-depth analysis of Walmart sales data using MySQL, revealing insights into top-performing branches, product trends, and customer behavior, identifying informed business decisions and conducted meticulous data wrangling ensuring data integrity and completeness.

• Conducted comprehensive exploratory data analysis to address critical business questions related to customer segments while analyzing purchasing trends and generated detailed reports using PowerBI summarizing key findings while providing strategic recommendations. Financial Modelling for Investment Decision (Technologies used: VBA, Goal Seek, Solver, What-if analysis) Feb 2022 - Mar 2022

• Developed Financial models using MS Excel to evaluate investment opportunities for real estate investment trust (REIT), resulting in informed investment decisions and improved financial performance.

• Modeled various scenarios for potential investments and analyzed their financial feasibility using tools such as NPV, IRR. Integrated macros for the scalability of financial models, allowing for quick and accurate evaluation of multiple investment opportunities. EDUCATION

The University of Texas at Dallas - Richardson, Texas Aug 2021 - May 2023 Masters in Management Science; Major in Business Analytics Relevant coursework: Database for Business Analytics, Statistics & Data Analysis, Spreadsheet Modeling & Analytic, Project Management in Engineering & Operation, Business analytics with SAS, Marketing Web Analytics, Data Visualization, Product Management Chetanas Hazarimal Somani College - Mumbai, India Jun 2018 - May 2021 Bachelors in Business Administration

Contact this candidate