Rahul Yadav Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

• Worked with one of the largest Bank of Canada• Created 12+Dashboards for clients to continuously monitor PnL and Balance Sheet’s essential KPIs and Metrics.• Designed 4 Templates in Excel utilizing Ledger Data, resulting in an 80% reduction in data processing time.• Engineered and implemented over 15 complex codes leveraging advanced SQL and SAS including use of macros, and forecasting of Actual and Plan numbers, resulting in the comprehensive automation of Finance Data Preparation• Mentored a team of 2 SI Analysts to successfully develop 6 finance dashboard for Eyeguide tool, which provides Monthly, Quarterly, and Yearly reports for vital KPIs across LOBs for Wealth Management while delivering results 50% more efficiently than peer teams.• Acted as a point of contact for delivery of the final product within a challenging 1 month timeline. Incorporated valuable feedback from CEO, Stakeholders and users of Wealth Management through iterative processes, ensuring utmost client satisfaction.• Led cross-functional teams in achieving product delivery excellence through effective collaboration and on-time project completion.• Developed 8+ design outlines and crafted over 100 KPI reports spanning Revenue, expenses, loans, deposits, AUM/AUA, etc., while fostering impactful collaboration with stakeholders across all organizational tiers to ensure seamless project execution.• Prepared over 10 exhaustive Business and Technical Documents, encompassing error handling, business rules, and other critical components, ensuring seamless client handover.

Gurugram, Haryana, India

• Enhanced visibility of USPs and values by designing 8+ landing pages using Leadpages which led to average conversion rate of 70%• Wrote 100+ SQL queries to generate report from Database for operation team which helped fasten the Doctor remuneration process• Using Macro in excel sent mails to Platinum doctors every month containing analysis report of their performance and weekly slots