Soumitra Bhunia, Developer in Kolkata, West Bengal, India
Soumitra is available for hire
Hire Soumitra

Soumitra Bhunia

Hyperion Financial Management Developer

Kolkata, West Bengal, India

Toptal member since June 25, 2025

Bio

Soumitra Bhunia is a dynamic and results-driven enterprise performance management (EPM) consultant with over 12 years of experience in the Oracle EPM Suite integrated products with Microsoft products. His expertise spans Oracle Hyperion Planning, Essbase, Financial Consolidation and Close Cloud Service (FCCS), Account Reconciliation Cloud Service (ARCS), and Microsoft Access.

Portfolio

Duco
Oracle Hyperion Planning, Hyperion Financial Management, SAP ERP, Java, PBCS...
Marlabs
Azure, Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS), AWS IAM...
Apexon
Azure, Data, Governance, Oracle EPM Cloud, CI/CD Pipelines, Data Warehousing...

Experience

  • Hyperion Financial Management - 8 years
  • SAP ERP - 8 years
  • Enterprise Performance Management (EPM) - 8 years
  • PBCS - 6 years
  • Oracle EPM with ARC - 6 years
  • Data Migration - 5 years
  • Azure - 4 years
  • SAP - 3 years

Preferred Environment

Slack App, Financial Consolidation and Close Cloud Service (FCCS), Oracle Hyperion Planning, Essbase, Enterprise Performance Management (EPM), Account Reconciliation Cloud Service (ARCS), Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS), Business Intelligence (BI), Oracle Fusion Applications, Microsoft Copilot Studio, Microsoft Fabric, Microsoft Copilot

The most amazing...

...projects I've undertaken influenced key outcomes at the intersection of finance, data, and cloud innovation.

Work Experience

Consulting and Development

2022 - PRESENT
Duco
  • Led kickoff meetings with stakeholders to define project scope, timelines, and deliverables.
  • Oversaw the integration of source system data into ARCS, using data management and EPM Automate, and Microsoft Suites.
  • Collaborated with CFOs, finance teams, and IT stakeholders, translating their goals into tangible solutions using tools like Oracle Hyperion Planning, EPBCS, and FCCS, and developed customized products with Microsoft Access.
  • Delivered user training sessions for preparer, reviewer, and administrator roles.
  • Created SOPs and user guides for post-launch support and validated trial balance loads and reconciliation balances.
  • Automated the comparison of high-volume transactions from different data sources to identify and clear matched items, reducing manual effort and reconciliation risks.
  • Defined match rules to compare transactions based on business logic. Built forms for streamlined data entry. Generated queries to extract, filter, and analyze data. Designed reports for clear summarization and professional printing.
  • Designed multiple reconciliation formats and rules tailored to business needs.
Technologies: Oracle Hyperion Planning, Hyperion Financial Management, SAP ERP, Java, PBCS, Azure, Financial Consolidation and Close Cloud Service (FCCS), Account Reconciliation Cloud Service (ARCS), Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS), Oracle PL/SQL, Oracle, Azure Databricks, ETL, SAP, ServiceNow, SQL, Data Engineering, Microsoft Excel, Data Analysis, Reporting, Microsoft Power BI, Accounting, Data Architecture, Master Data Management (MDM), Data Governance, Business Analysis, Sisense, Data Scraping, Profit & Loss (P&L), Microsoft Access, Excel 365, Excel Add-ins, Excel VBA, Visual Basic for Applications (VBA), Looker Studio, Google Apps Script, Google Workspace, Google Cloud Platform (GCP), Computer Vision, Data Warehouse Testing, Databases, Amazon Redshift, ODBC, Financial Modeling, Excel Dashboards, Cloud Firestore, Database Design, Oracle Cloud, Oracle Primavera, Primavera, Acumatica, Oracle Fusion ERP, Financial Planning & Analysis (FP&A), Microsoft Copilot Studio, Artificial Intelligence (AI)

Lead Consultant

2020 - 2021
Marlabs
  • Collaborated with CFOs, finance teams, and IT stakeholders, translating their goals into tangible solutions using tools.
  • Collaborated with business analysts and functional owners to translate BRDs into scalable data solutions, completing over 15 cross-functional projects within deadline and budget.
  • Oversaw the product launch process, resulting in over 100,000 downloads within the first launch cycle and significantly exceeding initial adoption targets.
  • Experienced in functional documentation (BRD, FRD, SDD), stakeholder management, and agile delivery practices. Tools include Jira, ServiceNow, Confluence, Balsamiq, and Zoho.
Technologies: Azure, Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS), AWS IAM, Data Governance, MDM, Business Intelligence (BI), Google Sheets, Computer Vision, Data Warehouse Testing, Python, Data Modeling, Git, Amazon Web Services (AWS), Oracle ERP, Excel 2016, Microsoft Fabric, Microsoft Copilot

Lead Consultant

2019 - 2020
Apexon
  • Experienced (12 years) in enterprise performance management (EPM), ERP systems, master data management (MDM), and data governance across Oracle, SAP, and cloud-based platforms.
  • Experienced in functional documentation (BRD, FRD, SDD), stakeholder management, and agile delivery practices. Tools include Jira, ServiceNow, Confluence, Balsamiq, and Zoho.
  • Collaborated with business analysts and functional owners to translate BRDs into scalable data solutions, completing over 15 cross-functional projects within deadline and budget.
Technologies: Azure, Data, Governance, Oracle EPM Cloud, CI/CD Pipelines, Data Warehousing, Tableau, Inventory Management, Optical Character Recognition (OCR), Qlik Sense, Amazon Athena, Apache Airflow, PostgreSQL, Oracle EBS General Ledger, Large Language Models (LLMs)

Lead Consultant

2016 - 2020
Gamut Infosystem
  • Skilled in enterprise data models, data lineage, and architecture blueprints, especially in performance management, finance, and marketing systems.
  • Led initiatives ensuring data quality, compliance, security, and policy enforcement, enabling trusted, usable data across business functions. Used Jira ticketing tool.
  • Collaborated with Collibra and prepared for its foundation certification to reinforce my governance capabilities.
Technologies: SAP ERP, Oracle, Property Management System Integrations, Data Lakes, Qlik

Experience

Warehouse Project

I developed an inventory planning and optimization model to predict warehouse inventory requirements, considering demand, seasonal variations, and lead times. To enhance cost allocation efficiency, I allocated direct and indirect costs like labor, utilities, and equipment depreciation to specific stock-keeping units (SKUs), warehouses, or business units.

Warehouse Group

DELIVERABLES
• Worked with stakeholders to gather and analyze business requirements for reconciliations.
• Configured reconciliation types, profiles, rules, and formats.
• Set up data loads (via data management or direct loads).
• Defined reconciliation compliance workflows.
• Trained end users and created documentation (user manuals, SOPs).
• Collaborated with the technical team for integrations or automation.

National Survey Office

To enable the National Survey Office to efficiently fetch, manage, and scale applications by leveraging Cloud Solutions for improved data collection, processing, and analytics, I conducted an IT audit to understand current data collection, storage, and dissemination tools.

Financial Modelling Work

I'm a results-driven Senior Excel Modeling Consultant with expertise in FactSet data solutions and advanced financial analysis. I'm passionate about building reliable, scalable models that empower decision-makers and improve operational efficiency. I'm also known for bridging technical proficiency with business insight to deliver impactful analytics.

Financial Modelling Analyst

Worked as a financial modelling analyst responsible for building dynamic financial models to support budgeting, forecasting, business valuation, and strategic decision-making. Collaborated with finance, operations, and senior leadership teams to deliver data-driven insights and improve financial planning accuracy.

Education

2007 - 2009

Master of Business Administration (MBA) in Finance

Eastern Institute for Integrated Learning in Management (EIILM) - Kolkata, India

2003 - 2006

BCom in Accounting

Prafulla Chandra College - India

Certifications

JUNE 2025 - PRESENT

Post-graduate Program in Cloud Computing

Great Learning

JULY 2023 - PRESENT

Certified Scrum Master

Scrum Alliance

MAY 2021 - PRESENT

Oracle Certified Professional

Oracle

Skills

Libraries/APIs

ODBC

Tools

Oracle EPM with ARC, Microsoft Excel, Tableau, Microsoft Access, Google Sheets, Qlik Sense, Git, Apache Airflow, Oracle EBS General Ledger, Oracle ERP, Excel 2016, PBCS, Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS), Microsoft Power BI, AWS IAM, Sisense, Google Workspace, Amazon Athena, Primavera, Acumatica, Microsoft Copilot

Languages

Excel VBA, Google Apps Script, SQL, Visual Basic for Applications (VBA), Python, Java

Paradigms

ETL, Business Intelligence (BI), Scrum, Database Design

Platforms

Google Cloud Platform (GCP), Azure, Oracle, Qlik, Amazon Web Services (AWS), Microsoft Copilot Studio, Microsoft Fabric

Storage

Master Data Management (MDM), Data Pipelines, Databases, Cloud Firestore, Oracle PL/SQL, Data Lakes, PostgreSQL, Oracle Cloud, Essbase

Industry Expertise

Accounting

Other

Hyperion Financial Management, Azure Databricks, Data Engineering, Data Analysis, Reporting, MDM, Data, Oracle EPM Cloud, Business Analysis, Data Analytics, Data Warehousing, Profit & Loss (P&L), Excel 365, Excel Add-ins, Property Management System Integrations, Looker Studio, Computer Vision, Optical Character Recognition (OCR), Financial Modeling, Excel Dashboards, Database Schema Design, Oracle Fusion ERP, Financial Planning & Analysis (FP&A), Slack App, Oracle Hyperion Planning, Enterprise Performance Management (EPM), SAP ERP, Financial Consolidation and Close Cloud Service (FCCS), Account Reconciliation Cloud Service (ARCS), Finance, Data Migration, SAP, ServiceNow, Data Architecture, Data Governance, Scrum Master, Accounts, Balance Sheets, Governance, Master Data, CI/CD Pipelines, Data Scraping, Inventory Management, Point of Sale, Data Warehouse Testing, Data Modeling, Amazon Redshift, Oracle Primavera, Oracle Fusion Applications, Artificial Intelligence (AI), Large Language Models (LLMs), Cloud, Data Management, Macros

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring