Summary
Overview
Work History
Education
Skills
Timeline
Generic
Anand Mohanty

Anand Mohanty

Sr. Analyst - Integrated Operations
Noida

Summary

At Birlasoft, as a Sr. Analyst in Integrated Operations, I spearheaded financial reporting and operations, enhancing the gross margin by optimizing processes and leveraging advanced MS Office and SQL skills. My strategic analysis and Python proficiency drove profitability and productivity, showcasing my problem-solving abilities and data-driven decision-making expertise.

Overview

3
3
years of professional experience

Work History

Sr. Analyst - Integrated Operations

Birlasoft
Noida
06.2022 - Current
  • Responsible for the operations and financial reporting of the Infrastructure & Testing HBU unit in Birlasoft.
  • Bench management and training planning for my unit.
  • Identified, analyzed and monitored data related to profitability, growth and productivity.
  • Developed financial models to analyze business performance, identify trends and forecast future results.
  • Maintaining and improving the gross margin percentage for different projects under my unit.
  • Forecast quarterly and annual revenue for the entire HBU based on ongoing and upcoming project details.
  • Created spreadsheets using MS Excel to track financial performance metrics.
  • Created spreadsheets using MS Excel to track expenses and other financial data.
  • Performed data analysis using spreadsheet software such as MS Excel or Google Sheets.
  • Analyzed monthly operating results against the prior year and budget; tracked progress toward achieving strategic objectives.
  • Oversaw financial management, budget management, accounting and payroll activities.
  • Utilizing data analysis tools, like Power BI, to generate and share business insights.
  • Created detailed documentation regarding processes related to tracking operations.
  • Generated reports and provided analysis of project metrics, including cost, timelines and resources used.
  • Performed data analysis tasks such as extracting, manipulating, transforming, validating, or modeling data with various tools, such as MS Excel or SQL query language.
  • Created MS Excel spreadsheets to track expenses, revenues, profits and losses, and other metrics.
  • Calculating important metrics like CPP, RPP, and project-wise gross margin to reach the organization's objectives.
  • Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.

Education

MBA - Information Technology

Xaviers Institute of Social Service
Ranchi
05-2022

Masters in Commerce - Financial Analysis

Gossner College
Ranchi
04-2020

Bachelor in Commerce - Business Mathematics & Statistics

Marwari College
Ranchi
06-2018

Skills

  • Advanced MS Office Suite knowledge
  • SQL query optimization
  • SQL Querying Abilities
  • Understanding of SQL
  • Excel automation
  • Data validation
  • Pivot tables
  • Report generation
  • Python Programming Familiarity
  • Python data analysis
  • Python Coding Abilities

Timeline

Sr. Analyst - Integrated Operations

Birlasoft
06.2022 - Current

MBA - Information Technology

Xaviers Institute of Social Service

Masters in Commerce - Financial Analysis

Gossner College

Bachelor in Commerce - Business Mathematics & Statistics

Marwari College
Anand MohantySr. Analyst - Integrated Operations