07/21/2023 updated


100 % available
OneStream Consultant
Pune, India
India
Microsoft ExcelControles de AccesoDistributed File SystemsEnterprise Resource PlanningMicrosoft OfficeSAP ERPOracle ApplicationsSAP ApplicationsSAP BPCSAP FITally ERPOracle HyperionConsolidation (Financial)Vba Programming Language
Onestream implementations, Consolidation solutions, Oracle, Hyperion, BPC, access rights, SAP, Excel, VBA, DFS, SAP FI, ERP, SAP ERP - FI Certified, Tally ERP Customisation, MS Excel, MS Office tools, Macro recordings
Experience
Professional experience5 - 10 years
Languages
EnglishGood
Project history
- Technical design, build and test of system functionality and components as requested by Ascend in relation to the implementation of the Oracle Hyperion or OneStream (or related) software and systems.
- Assist with the support of project deployments and parallel run operations, in collaboration with other project teams.
- Assist with the support of users, including monthend operations, monitoring of services, and addressing technical issues that may arise.
- Participation in training preparation and execution.
- Assist with the production of relevant documentation as requested.
Projects:
Implemented of OneStream Consolidation solution for Multiple clients
As Financial Analyst / Controller
- Publish Weekly P&L dashboards and creating ad-hoc reports as requested i.e. Short term Forecast
- Publish Weekly Volume & rate forecasting Dashboard i.e. Short term Revenue Forecast
- Financial Analysis, Budgeting, Forecasting, A Vs. F analysis
- Involved in preparation of rolling forecast (ROFO), Continuous Monitoring of Assumptions and
summarizing presenting the Current Estimates
- Controlling closing of IFRS consolidated financials in BPC and HFM/OneStream at Group level and
coordinating with teams at various entity level for their deliverables. Inter-company transaction
controlling at group level,
- Preparation of consolidated Line items commentary on present performance, Balance sheet line items
and their movements.
- Supporting in HFM & smartview access rights to HFM admin team;
- Maintaining & creating controlling templates via smartview reports for use of whole group.
- Maintenance of Entity structure in Consolidation tool.
- As a SAP user day to day and Period end Closing tasks
- Working on improvement & simplification projects by applying Excel Automation e.g. Macro or VBA.
As Business Process Support (Analyst)
- Working on improvement & simplification projects by Excel Automation e.g. Macro or VBA
- Working on projects for business outcome, mainly analyzing the process issues of global SAP banking
setup (IHC) and looking for benefits (Hard as well as soft);
- Major projects for Business outcome-
Analysing Global cash pooling and deriving possible benefits, Reduction in Bank accounts by analyzing
business utility,
- Working closely with group treasury and enabling them in efficiently utilization of idle funds,
- Project on internal group interest rates on loans, Supporting In House Cash Setup related issues in SAP,
- Identifying pain areas in Third Party agents accounting process and defining & implementing a correct
policy;
- Publish Weekly P&L dashboards and creating ad-hoc reports as requested i.e. Short term Forecast
- Publish Weekly Volume & rate forecasting Dashboard i.e. Short term Revenue Forecast
- Financial Analysis, Budgeting, Forecasting, A Vs. F analysis
- Involved in preparation of rolling forecast (ROFO), Continuous Monitoring of Assumptions and
summarizing presenting the Current Estimates
- Controlling closing of IFRS consolidated financials in BPC and HFM/OneStream at Group level and
coordinating with teams at various entity level for their deliverables. Inter-company transaction
controlling at group level,
- Preparation of consolidated Line items commentary on present performance, Balance sheet line items
and their movements.
- Supporting in HFM & smartview access rights to HFM admin team;
- Maintaining & creating controlling templates via smartview reports for use of whole group.
- Maintenance of Entity structure in Consolidation tool.
- As a SAP user day to day and Period end Closing tasks
- Working on improvement & simplification projects by applying Excel Automation e.g. Macro or VBA.
As Business Process Support (Analyst)
- Working on improvement & simplification projects by Excel Automation e.g. Macro or VBA
- Working on projects for business outcome, mainly analyzing the process issues of global SAP banking
setup (IHC) and looking for benefits (Hard as well as soft);
- Major projects for Business outcome-
Analysing Global cash pooling and deriving possible benefits, Reduction in Bank accounts by analyzing
business utility,
- Working closely with group treasury and enabling them in efficiently utilization of idle funds,
- Project on internal group interest rates on loans, Supporting In House Cash Setup related issues in SAP,
- Identifying pain areas in Third Party agents accounting process and defining & implementing a correct
policy;
- Finalisation of Accounts.
- Preparation of MIS and improving it from time to time.
- Working on Process development assignments for logistics using advanced excel tools e.g. VBA.
- Working on automation assignments for Master Data Maintenance & MIS preparations.
- Working on Project Analysis & Business Valuations.
- Preparation of MIS and improving it from time to time.
- Working on Process development assignments for logistics using advanced excel tools e.g. VBA.
- Working on automation assignments for Master Data Maintenance & MIS preparations.
- Working on Project Analysis & Business Valuations.