Sujit Kumar Jena Email & Phone Number

Bengaluru, Ka, In

Bengaluru Area, India

Current Role: Core Data Science (data lake, GCP & Azure dev ops)Transform existing way of management reporting into digital platform to draw automated insights using MS Power Bi. Majorly deep dive into source system for financial information and gather business logic that can be used to develop reports and dashboards using Power Query/Power Pivots and MS Power Bi etc. Also provide analytics dashboard through trend graphs, projection graphs etc for top line such as Revenue, PBT, CAPEX, Sales volume etc.

Bengaluru Area, India

Leading consolidated financial data from data lake in GCP for creating tables. These tables are then consumed part of MS Power Bi through Google big query. Create smaller tables using Google big query to convert from existing inhouse SQL server to GCP. Plot projection trend through forecasting based on current actuals for future months of the year. Time series analysis using ARIMA, Exponential Smoothing, Moving average, converting to non stationary to stationary through Detrending & Differencing. Consolidate multiple reports and summarize to build insights that help in business decisions. Financial analysis for emerging line of business across the globe  Analyze top and bottom level clients based on Revenue & CCI. This provides an indicator on which client need a revisit for better evaluation in terms of Revenue and CCI.

Bengaluru Area, India

 The Main role is to prepare Flash reports on forecast and actual expenses including Orders and Revenue P&L. Preparing Dashboards and Sales Flash report for Corporate Management team using Tableau on daily, weekly and monthly basis. Developed and automated management reports like Daily Revenue reports, Expense report, Variance analysis report using VBA macro in MS Excel. Financial analysis for Honeywell Building Solutions line of business across the globe that includes Forecast Models and P&L summary, connecting Hyperion/HFM /BI tools in MS Excel. Mainly, Financial reporting for all business units across the globe. Assisting and working with the Finance Managers/Directors based in Belgium and Europe for report generation and deep dive analysis into expenses and revenue using various tools such as Tableau BI/BW analyzer, SAP – R/3. Automated Financial models using VBA in MS Excel, thereby increasing scope for analysis of expenses, actuals, revenue etc. Adept in using BI tools and queries, together with Hyperion database in MS Excel for digging and retrieval of financial data (Mainly HFM and Essbase) Understanding Business needs and reporting system to improve visibility from management perspective.ADHOC reports that varies according to the request from the higher management across the globe.Monthly Actual report explaining the variance between Forecast and actual numbers.

Bengaluru Area, India

Business Analytics,Financial Budgeting, Forecasting and Variance analysis, Financial Modeling, Hyperion,SAP, BI/BW, BPC (Business Planning and Consolidation)

Key Role: Financial Budgeting, Forecasting and Variance analysis, Financial Modeling, Trend Analysis.

Name of the Organization: Electronica Machine Tools Ltd. Title- "Study of Inventory management systems in a SAP enabled environment"Responsibilities- Assisting Supply chain manager to analyze the inventory systems followed by the company and find a trend and the shortcomings through correlating data from Materials Management (MM) module in SAP.Find a difference of allowed average inventory and actual inventory maintained.Also find a trend for raw materials, domestic, semi finished and finished products using MS Excel.Duration: 5 months

Technical Engineer

M.B.A, Finance

MBA Finance

B. Tech, I.T

Graduated as I.T Engineer from CV Raman College of Engineering in 2005

S.S.C, 10Th