Shailender Kumar Email & Phone Number

Gurugram, Haryana, India

• Leading the Data Quality and Business Insights functions within the Sales, Assets and Revenue Centre of Excellence (CoE) to generate actionable insights around the firm’s revenue, sales and assets performanceSelected.
• Gross Sales Forecasting: Developed a Machine Learning based model to forecast Gross Sales for the firm’s institutional business using internal, competitor and macroeconomic data - Ridge, Lasso, RF, XGB
• Developed a probabilistic Monte-carlo simulation for predicting the distribution of Assets under Management (AuM), Gross Sales, Gross Redemptions, Net Sales: Mean, Upside and Downside Scenarios
• Pricing analytics: Analyzed the historical compression seen in pricing trends across clients and business segments. Tableau dashboard to facilitate variance analysis of Basis points at a country, fund, client level
• Financial Planning and Analysis: Developed granular Scenario based forecasts for annual Gross Sales, Gross Redemptions, AuM, BPS and Net Revenue targets using industry data from McKinsey Growth Cube
• Data Exceptions Analysis: Created a Power-BI dashboard to highlight anomalies and exceptions in Revenue and AuM data through trend analysis, variance analysis, data quality rules for rectification

Gurgaon, India

• Top US bank: Worked for Portfolio Analytics division of a large US based bank. Leveraged Analytics and Automation to deliver process improvements and efficiencies for Retail Lending portfolio of the bank
• Created visualization in Tableau to monitor month over month performance of Business lending portfolio
• Project lead: Led a team of 2 consultants to achieve analytics delivery for multiple project streams across different assets classes – Credit Cards, Home Equity, Business Banking, Unsecured Installment Loans, Auto
• Project Management: Worked on preparation of project plans with time and resource estimates for client approval, project progress updates and reviews for weekly client calls to achieve efficient service delivery

Gurgaon, India

• I worked in a managerial capacity for clients across a variety of industries.UTILITIES (Power)
• UK based Top 4 Energy provider: Managed a client facing Revenue Assurance project end to end from requirement gathering to project execution. Led a team of 2 SAS analysts for offshore delivery/ MI reporting
• Worked on-site in Leicester, UK to implement a process improvement solution for improving billing accuracy
• Prepared end to end process maps and used SAS to identify potential points of revenue leakage for the client in its billing process. Identified and recommended process controls and flows to plug revenue leakage.
• Indian Railways: Contributed to a Proof of Concept (POC) design for Indian Railways for optimizing freight train scheduling on its Ajmer- Palanpur route. Translated client requirements into workable business problems.
• Conceptualized and presented a Linear Programming based- Train schedule optimization approach which was subsequently implemented in Python and submitted to Indian Railways as a part of EXLs technical bid.BFSI

Delhi Area, India

• Worked as a Business Analyst to provide data and analytics assistance to Director (Engineering) on revenue, operational and project performance of the company on a monthly, half-yearly and annual basis
• Business Analysis: Monitored and analyzed monthly sales performance of BHEL’s 17 manufacturing units through an excel dashboard. Presented reasons for revenue shortfall and bottlenecks to CMD & Directors.
• Interacted with product managers of Bhopal manufacturing unit to understand manufacturing constraints and their impact on sales targets. Identified revenue risks and prepared risk adjusted revenue forecasts
• Reporting & MI: Generated reports to monitor project progress, order-book and other administrative activities

Pgdm, Finance And Economics, Top 15%

Bachelor'S Degree, Mechanical Engineering, Top 10%