Gaurav Lalwani
Financial Analyst @In-Sattva
Signup · Get unlimited contacts
WORK HISTORY
Financial Analyst @In-Sattva
Chicago, IL, US
Built a fully integrated 2-year FP & A forecast model (revenue, COGS, OPEX, cash flow) by consolidating multi-channel sales data, improving forecast accuracy by 34% and enabling leadership to make data-driven budgeting and investment decisions- Led budgeting and variance analysis, identifying $45K in cost discrepancies from promotions and freight accruals, and improving month-end close efficiency by 20% through standardized reporting and QuickBooks corrections- Created automated Power BI KPI dashboards (GM%, contribution margin, inventory turns, OTIF, return rates) using SQL/Power Query, cutting manual reporting labor by 35% and enabling Bi-weekly pricing and inventory decisions instead of monthly- Optimized supply-chain and working-capital efficiency by modeling reorder points and safety stock, reducing stockouts by 19%, improving inventory turns by 1.4x, and freeing almost $75K in working capital from slow-moving SKUs- Strengthened financial controls by creating an accurate SKU/barcode master and aligning revenue
EDUCATION
H.R. College Of Commerce & Economics
Master's degree, Banking and Financial Support Services
DePaul University
Master of Business Administration - MBA, Business Analytics & Finance
H.R. College Of Commerce & Economics
Bachelor of Commerce - BCom, Business/Commerce, General
ABOUT GAURAV LALWANI
Gaurav Lalwani, a finance and a business analyst professional with a distinguished track record in client management, financial analysis, business performance analysis and regulatory compliance, holds a Master’s degree in Banking and Finance from the HR College of Commerce and Economics, where he graduated with distinction (GPA 3.92/4).At ACG Associated Capsules Pvt. Ltd, Gaurav worked as a Financial Analyst Intern where he applied business analyst skills to streamline reporting and enhance decision-making. He consolidated multi-center North American operations into unified reports, automated P&L and COGS dashboards using Excel and Power BI, and conducted competitor benchmarking across American and European operations. His analysis of freight and warehouse expenses uncovered inefficiencies and improved transparency, supporting more accurate budgeting and strategic planning.As an Assistant Manager at Yes Bank, Gaurav oversaw high-net-worth portfolios worth over $20 million and drove growth rates of 12–20% through tailored investment strategies. His client-first approach earned him Yes Bank’s Applause and Trail Blazer awards. In his earlier role as Senior Officer, he implemented KYC and AML protocols that reduced financial crime cases by 40%, while also leading a team of 10 to improve compliance accuracy and productivity.Gaurav’s academic foundation is reinforced by his ongoing MBA in Business Analytics at DePaul University (GPA 3.98/4), where he is gaining expertise in predictive modeling, forecasting, and data-driven decision making. He also served as Case Competition Chair for the MBA Association, leading partnerships with companies and designing cases on real-world challenges. He is also an active member of the DePaul Accounting and Finance Club, expanding his exposure to both finance and analytics.Outside his professional journey, Gaurav enjoys traveling, exploring new cuisines, cooking, and playing pickleball.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.