Skip to main content
Santosh Krishna Sahoo

Santosh Krishna Sahoo

Data analyst & Automation of MIS Reporting using Advance Excel forumla, VBA & Macro, Power Bi, Power Automate, SQL & Microsoft Fabric

Talent
3/14, Sampat Chawl, Bandrekar Wadi, Jogeshwari - East, Mumbai – 400 060Member since July 2, 2026
Business IntelligenceExcelSQLPower BISAPMicrosoft CopilotUiPath RPAPythonVinmar BI toolsMYSQLMS SQLCelonisMicrosoft FabricPower QueryPower AutomateDAXChatGPTGeminiClaude.aiVBA
·

Hire this person

Send a job offer directly to this candidate

Business IntelligenceExcelSQLPower BISAP

About

I would like to work in an organization, which believes in adding value to its employee its clients, and ultimately to the business. Looking forward for a challenging and growth-oriented career in service sector.

Experience

Assistant Manager - Business Analyst at Vinmar Business Services Pvt. Ltd. (2016-07 – Present)

Experienced Data and Reporting Professional with expertise in MS Access, Business Intelligence tools, Celonis, Microsoft Fabric, advanced MS Excel (VBA and Power Query for ETL), and Power BI (DAX). Proficient in leveraging AI tools such as ChatGPT, Gemini, Claude.ai, and Microsoft Copilot to enhance productivity, reporting, and analytics. Possess intermediate proficiency in SAP, Python, SQL, Power BI, and Power Automate, with a strong focus on report automation, dashboard development, and process optimization.

Experienced in supporting Logistics, Procurement, HR, and Accounts & Finance (AP/AR) functions, including KPI reporting, forecasting, inventory management, SOP preparation and process improvement initiatives through automated and semi-automated solutions.

  • Designed and maintained Excel- and Access-based dashboards and standardized reporting templates for India and US teams. Trained global users on newly developed reporting solutions, improving efficiency, productivity, and data accuracy.
  • Automated end-to-end reporting processes using Python (Jupyter Notebook), Power BI (DAX, ETL, and Measures), Power Automate, Microsoft Copilot, and Claude.ai.
  • Extracted, analyzed, and reconciled accrual and inventory data (HDPE, LDPE, LLDPE, PVC, and PP) from SAP. Successfully migrated legacy reports to Power BI and leveraged Microsoft Copilot to enhance reporting capabilities.
  • Developed and maintained Microsoft Fabric solutions using Warehouses, Lakehouses, Data Pipelines, Notebooks, and Semantic Models to support enterprise reporting and analytics.
  • Managed inventory movements from storage yards to owned and 3PL warehouses using FIFO methodology, implementing control logic by integrating data from multiple sources.
  • Developed Power Automate workflows to automate repetitive tasks, reducing manual effort, API Extract with the help of Claude.ai and improving operational efficiency.
  • Analyzed and prepared monthly sales invoice forecast reports categorized by logistics teams and countries, supporting business planning and decision-making.
  • Streamlined reporting and business processes by implementing automation solutions across Logistics, Procurement, HR, and Finance functions.

Senior Executive (DSAT / BIT - Reconciliation and MIS Reporting) at Bharti AXA Life Insurance Co. Ltd (2015-07 – 2016-07)

  • Designed and automated Excel/Access-based reporting solutions, performed SQL-driven reconciliations, managed commission calculations, and delivered timely business reports with actionable insights across multiple distribution channels.

Lead Associate (Revenue Accounting, Reconciliations & MIS) at Accelya Kale Solutions Limited (2012-06 – 2015-02)

  • Performed GL and AP/AR reconciliations between systems, leveraged SQL/PLSQL for data extraction and updates, managed JV entries, and delivered audit-ready reports and trial balance analysis for accurate financial control.
  • Galaxy of Stars Award – Quarter I, 2013 & Accelyance Best Performer Award – February 2014.

Senior Associate (Acting Team Leader) at State Street Syntel Services Pvt. Ltd (2005-10 – 2012-06)

Experienced in mutual fund cash management and transfer agency operations, handling end-to-end transactions, treasury activities, and system-based processing while supporting UK process migration and delivering accurate MIS reporting and stakeholder coordination.

  • Syntel Values – Star Team Award (Q3 2006), Syntel Values – Simple Award (Q3 2008) & Syntel Values – Synergy Team Award (Q1 2011).

Education

Post Graduate Diploma in Financial Management – University of Mumbai (2013-05)

Master's Degree in Commerce (M.Com) – Mumbai University (2004-10)

Bachelor's degree in Commerce (B.com) – K. G.

Mittal

College (Mumbai University) (2001-04)

H.S.C – K. G.

Mittal

College (1998-03)

S.S.C – St Mary High School (1996-03)

Skills

VBA & MacroPower BiPower AutomateSQL & Microsoft Fabric

Reviews

Related