Deepak Sahu

• Analyses financial and operational information as well as reports to provide accurate,timely, and actionable financial and/or performance improvement recommendations to support management decision making
• Involved in forecasting, budgeting based on trend analysis, and drive expense forecast calls
• Conducts research on performance indicators and benchmarks relevant to the firm worldwide
• Conducts analysis of and makes recommendations on the definition of strategic and operational KPIs
• Tracks, monitors and updates KPIs as necessary based on industry trends and the internal needs of the firm
• Develops planning and modelling tools to assist with enterprise project budgeting,return on investment analysis, strategic planning, etc
• Supports management with in-depth analysis and assessment of enterprise processes
• Prepares presentations to and recommendations for Senior Management
• Performs ad-hoc reporting and analysis including analytical and research support for various corporate and business unit projects
• Prepare ad hoc reports in Hyperion web studio

Hands on Experience on Tools

SmartView, Hyperion Financial Management (HFM), EPM, Hyperion Web Studio, Oracle Narratives

• Run quarterly close allocation process, which includes data gathering, loading journals into the Fiscal Recharge GL, updating formulas and running allocations
• Complete detailed reconciliation of allocated charges
• Load intercompany system and reconcile
• Updating the various CONSOL reports in R12 relating to Transfer Pricing either based on Corporate Tax inputs or on account of any Segment change
• Usage of Fusion Ledger Application for running revaluations for certain corporate entities, updating and maintaining the CVRs, uploading of Journal entries etc
• Local tax audit support (data gathering from Fiscal Recharge GL, GIFTS and SmartView)
• Assist with yearly review of lines of business (Tax Survey)
• Prepare detailed spreadsheets for the quarterly Flux Analysis
• Update hierarchies used for quarterly Tax Forecast
• Assist team with ad hoc projects

Hands on Experience on Tools

Oracle Smart view- Essbase, Oracle Fusion, Hyperion Financial Management (HFM), EPM, Oracle Data Visualization.

Special Achievements

• Simplified Fiscal Recharge process that resulted in saving time during quarter close.
• Recognized by stakeholders for implementing data visualization in Flux Analysis.
• Received Certificate of Appreciation for stabilizing the Tax Forecast process.

• Role and Responsibilities Financial Planning & Analysis Activities:
• Preparing Standard Sales reports efficiently on Daily, weekly, monthly, quarterly, and annual basis
• Preparation of daily/weekly/periodical reports for Turkey & UK online stores with complete analysis of Sales
• Retail sales budgeting – Budgeting for Turkey retails stores using the Top-down method of Budgeting
• Preparation of budget for major cost lines like stock loss and Payroll
• Variance analysis between current sales with LFL sales
• LFL (Like for like) Sales reporting and analysis which is one of the key metrics indicating the company's growth and performance
• Preparing rolling forecast to have forecast view of P&L line for upcoming periods
• Prepare Summary Management account on periodic basic to have P&L view on periodic, QTD and YTD view on company's performance
• Create management reports and performing analysis to interpret data and derive business models
• Also automated few reports and built-in checks to generate efficiency
• Addressing all the ad-hoc queries proactively and providing solutions for the same on a timely basis
• Automate the reports by using multiple advanced excel tools, Macros, advance formulas and tweaking the SQL queries to simplify the reports
• Intermediate level of proficiency SQL experience with the ability to create tables,query using multiple joins, etc
• Run SQL code to assess, clean, validate and analyze large datasets
• Preparation of Ad-hoc reports using business objects for the management and leadership as and when required

Hands on Experience on Tools

Oracle 11i, Oracle Smart view- Essbase, HFM, EPM, Teradata SQL

Special Achievements

• Awarded with a “star award” for control, speed, accuracy and commitment towards various tasks
• Awarded with a value award from stakeholders & the finance directors for speeding up the preparation of commercial pack Report, Grocery reports and making a process that was assumed to be complex an authentic one.