Ashish Solanki

Business Analyst | Optimizing Financial Reporting Through BI & Automation | SQL • Power BI • Agile • Enabled CFOs with Real-Time Dashboards by Streamlining Reporting Workflow

Role: Business Analyst at Bain & Company
Location: New Delhi, IN
LinkedIn followers: 500 followers

General Business & ManagementView LinkedIn profile

About Ashish Solanki

Results-driven Power BI Developer with 1 year of experience delivering end-to-end…

Experience

Business Analyst
Bain & Company
May 2024 — Present · Gurugram, IN
Automated Financial Reporting: Designed and implemented automated financial reporting solutions using Power BI and SQL, covering Cash Flow Statements, P&L Reports, and Expenditure Analysis in customized formats tailored to leadership needs.Efficiency Improvement: Reduced monthly reporting cycle by 50% by automating data pipelines and report generation, enabling real-time access to financial metrics for the CEO and CFO—eliminating dependency on static, end-of-month reporting.Dashboard Development: Built interactive dashboards with Row-Level Security (RLS) in Power BI to ensure role-based access control across departments and secure distribution of sensitive financial data.SQL Expertise: Leveraged SQL (T-SQL) to develop efficient queries and views for data extraction, transformation, and modeling from complex, multi-source financial systems.Project Management: Implemented end-to-end project management techniques for dashboard initiatives—defining business requirements, building data models, coordinating with stakeholders, and ensuring timely delivery using Agile methodology.KPI Development: Defined and maintained KPIs and financial performance metrics, improving visibility into revenue, cost drivers, and cash positions across business units.Cross-Functional Collaboration: Collaborated with finance, IT, and executive teams to ensure alignment between BI solutions and strategic objectives, enhancing decision-making efficiency.Continuous Optimization: Continuously optimized reports for performance, UX, and scalability, including the use of DAX measures, bookmarks, drill-through filters, and custom visuals.

Contact information

Verified work emails, personal emails, and direct dials — unlocked in one click.

Work email
•••••@bain.com
Personal email
•••••@•••••.com
Direct dial
+•• ••• ••• ••••

Unlock verified contacts

Free to start · No credit card required

Current company

Bain & Company

Business Consulting and Services · 26K employees · Boston, Massachusetts, United States

We work alongside leaders around the world to solve their hardest problems and achieve results that last. Since 1973, we’ve partnered with clients, including private equity firms and their portfolio companies, to build the capabilities that keep them ahead of change and help them redefine their industries. We’ve led large-scale transformations through every technology wave, and today technology and AI are in everything we do. We help clients see where AI changes how they compete, then create the advantage: the strategy, the engineering to build it, and the change leadership to make it hold in a real organization with real constraints. We measure our success by our clients’ success, and our client advocacy is the highest in our field. We’re consistently recognized as one of the best places to work in the world. Across 67 cities in 40 countries, we operate as one global team, uniting strategists, industry and functional experts, engineers, AI experts, data scientists, designers, and advisors with a vibrant ecosystem of technology partners.

bain.com

Find verified contacts for anyone on LinkedIn

Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.

Start for free See how it works

Free plan included · No credit card required

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.