Yash Jain
Neemuch
Summary
Results-driven Business Analyst with a track record of success at Mercer Mettl and Freedom Property Investors, leveraging data analytics to drive insights and enhance strategic decision-making. Proficient in tools such as Python, SQL, Power BI, Tableau, and advanced Excel, with expertise in identifying trends, building analytical models, and executing data-driven strategies to boost business performance. Experienced in developing interactive dashboards, streamlining reporting processes, and supporting cross-functional teams. Adept at using CRM, CSM, and Zoho platforms to optimize client relationship management, and facilitate effective stakeholder engagement.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Business Analyst
Freedom Property Investors
Remote
10.2024 - Current
- Led data analysis to support strategic decisions, using SQL to manage and analyze complex datasets for improved efficiency and cost control.
- Built and maintained Power BI dashboards to track KPIs, and deliver real-time insights to leadership.
- Used advanced Excel (Power Query, PivotTables, VBA) for financial modeling, automation, and deep-dive analysis.
- Contributed to a major SMSF project, focusing on financial analysis, compliance, and fund performance tracking.
- Created collaborative reporting tools in Google Sheets, enhancing data accessibility, and team coordination.
- Worked cross-functionally to define KPIs and deliver actionable insights, improving decision-making.
- Automated reporting processes and standardized data pipelines reduce manual effort by over 30%.
Business Analyst
Mercer Mettl
01.2024 - 07.2024
- Managed business analysis efforts to identify growth opportunities and improve operational processes.
- Conducted market research and competitive analysis to inform product development and positioning strategies.
- Analyzed business data using Power BI and Tableau to provide insights for strategic decision-making.
- Collaborated with cross-functional teams to implement process improvements and enhance efficiency.
- Engaged in stakeholder management, facilitating communication and understanding of business requirements.
- Assisted in the preparation of data-driven reports for senior management to support business decisions.
Business Analyst Intern
Celebal Technologies
05.2023 - 09.2023
- Supported data analysis efforts to identify growth opportunities and market trends.
- Developed analytical models for stock market trend prediction and housing price detection.
- Collaborated with cross-functional teams to implement process improvements and optimize operations.
- Engaged in requirements gathering to inform product development and stakeholder needs.
Education
Bachelor of Technology - Data Science
Manipal University
Jaipur07-2024
Skills
- Python
- SQL
- Advanced Excel
- Google Sheet
- Power BI
- Tableau
- Salesforce
- HubSpot
- Zoho
- Market Research
- Requirements Gathering
- Process Improvement
Certification
- Business Analysis - Certified Business Analysis Professional (CBAP)
- Google - Data Analytics Certificate
- Microsoft - Data Analyst Associate
- HubSpot - Inbound Sales Certification
Accomplishments
- Selected as one of 30 students out of 120 for the exchange university program.
- Increased sales efficiency by 30%
- Successfully brought in high-potential clients, contributing to business growth.
Projects
🔹 Sales Performance Dashboard – Power BI
Tools: Power BI, SQL, Excel
Overview: Designed a dynamic Power BI dashboard to track and visualize monthly sales performance across multiple regions and teams.
Impact: Enabled leadership to monitor KPIs in real time, resulting in a 15% improvement in sales team productivity through data-backed insights.
Tools: Python (Pandas, Scikit-learn), SQL
Overview: Built a machine learning model to predict customer churn using CRM data. Conducted feature engineering and model tuning to improve accuracy.
Impact: Provided actionable recommendations that helped reduce churn by identifying high-risk customer segments.
Tools: Tableau, SQL, Google Analytics
Overview: Developed an interactive Tableau dashboard to evaluate the ROI of digital marketing campaigns across multiple channels.
Impact: Enabled marketing team to allocate budgets more efficiently, increasing ROI by 20%.
Timeline
Business Analyst
Freedom Property Investors
10.2024 - Current
Business Analyst
Mercer Mettl
01.2024 - 07.2024
Business Analyst Intern
Celebal Technologies
05.2023 - 09.2023
Bachelor of Technology - Data Science
Manipal University
Similar Profiles
Mark PhelanMark Phelan
Member Care Manager at Freedom Property InvestorsMember Care Manager at Freedom Property Investors
Paishen MartinezPaishen Martinez
Investment Specialist at Freedom Property InvestorsInvestment Specialist at Freedom Property Investors
Shyanne KuruShyanne Kuru
Executive Assistant to CEO at Freedom Property InvestorsExecutive Assistant to CEO at Freedom Property Investors
Yashvant MeghwalYashvant Meghwal
Product Sales Manager and Assistance Manager (ISB) at Yes Bank LimitedProduct Sales Manager and Assistance Manager (ISB) at Yes Bank Limited
HOZEFA RAMPURAWALAHOZEFA RAMPURAWALA
Area Sales Executive at MUFADDAL JHUMAR HOUSEArea Sales Executive at MUFADDAL JHUMAR HOUSE