Forecasting and reporting on Direct Non-Interest Expenses (DNIE) and headcount for Commercial Banking and its sub-lines of business, including variance analysis (year-over-year, forecast vs. budget, actual vs. forecast vs. budget).Annual budgeting for DNIE at the lowest organizational level, collaborating with leaders to align budgeting with their yearly tasks.Tracking efficiency initiatives for Commercial Banking down to the lowest levels and assisting business leaders in… Show more Forecasting and reporting on Direct Non-Interest Expenses (DNIE) and headcount for Commercial Banking and its sub-lines of business, including variance analysis (year-over-year, forecast vs. budget, actual vs. forecast vs. budget).Annual budgeting for DNIE at the lowest organizational level, collaborating with leaders to align budgeting with their yearly tasks.Tracking efficiency initiatives for Commercial Banking down to the lowest levels and assisting business leaders in identifying opportunities for efficiency improvements and strategic planning to meet efficiency targets.Allocating indirect non-interest expenses down to the lowest organizational level and addressing leaders' queries regarding the rationale behind expense allocations.Reporting on headcount, including number of displacements, attritions, hires, and new positions filled.Led automation projects within Commercial Banking using expertise in Power BI and Alteryx. Show less

• Monthly Actuals reporting including Estimating Accruals through Alteryx tool, Variance analysis and reporting for Asia Pacific Markets• Monitor and Control of Freight Operations budget against actual spent by keeping track of Operational Changes and Key performance Indicators• Performed Monthly Forecasting and Annual Budget and Business Plan activity (5-year period) of Freight cost by incorporating Volumes, Exchange Rates, Fuel rates, Economics & Efficiencies and CPU (Cost per… Show more • Monthly Actuals reporting including Estimating Accruals through Alteryx tool, Variance analysis and reporting for Asia Pacific Markets• Monitor and Control of Freight Operations budget against actual spent by keeping track of Operational Changes and Key performance Indicators• Performed Monthly Forecasting and Annual Budget and Business Plan activity (5-year period) of Freight cost by incorporating Volumes, Exchange Rates, Fuel rates, Economics & Efficiencies and CPU (Cost per unit) into forecast model and report Year-over-Year and Issue to Issue Variances• Worked closely with Operations in Costing New Vehicles models and Perform cost benefit analysis on ad-hoc request and prepare financial reports for Leadership• Contract Management - Analyze Price variance, validate cost Savings by understanding business changes; Approve Purchase Request & Purchase orders in the systemKey Contribution• Process improvement - Developed automated workflow using Alteryx Designer to upload CPUs into systems for different markets, reducing half a day's work to only 5 minutes• Reported Cost Variance analysis at element level which helped in identifying critical elements resulting in Variance Show less

• Interned as Financial Analyst in Ford Customer Service Division (FCSD)• Developed Profit Analysis tool which reports Gross Margin at each marketing hierarchy used at Ford all Asia Pacific markets and Explains Variance by volume, price and cost impact• The tool was developed using Alteryx for ETL (Extract Transform Load) operations and QlikView for Data Visualization and Variance calculation• Implemented time-based variance analysis and identified key performance indicator and… Show more • Interned as Financial Analyst in Ford Customer Service Division (FCSD)• Developed Profit Analysis tool which reports Gross Margin at each marketing hierarchy used at Ford all Asia Pacific markets and Explains Variance by volume, price and cost impact• The tool was developed using Alteryx for ETL (Extract Transform Load) operations and QlikView for Data Visualization and Variance calculation• Implemented time-based variance analysis and identified key performance indicator and implemented KPI Drill down till the bottom level Show less

• Worked in Dev-op projects responsible for testing (Both manual and automation) web application of a leading US insurance company• Handled functional and regression testing of the application (Manual testing) by developing exhaustive test cases• Experience on direct client interaction for requirements gathering, clarifications and bugs resolvent.• Headed a 3-member team which was responsible for handling validation in downstream systems