Summary
Overview
Work History
Education
Skills
SAP-FI
Languages
Software
Advanced Excel
Black Line Softwere
Timeline
Generic

Suraj Sagar

Delhi

Summary

To employ my knowledge and experience with the intention of securing a professional career with opportunity for challenges and career advancement, while gaining knowledge of new skills and expertise.

Overview

5
5
years of professional experience

Work History

TELLUS HOMES PRIVATE LIMITED
07.2022 - Current
  • Preparing and analysing daily and weekly report (E.g. Accrual Entry, Average Cost Record, Position File, Account Receivable, Cash Receipt, Final Entry, Hourly Bonus Accrual, Inventory Consumption, Shipment File Report, Inventory Control File, Re-class, Sales JE Working File, Cost Centre, Emission File, GPJ, HSE Report, Inventory Correction, LAC Feed Sales, Payroll Validation, Inventory Adjustment and comparing actual costs against its historical and forecasts.
  • Handling Finance and management reporting one Client independently.
  • Experience with New process transition and making SOPs of all the activities.
  • Manage the Daily, Month-end, Quarterly & Annual close process, ensuring all reconciliation are performed.
  • Conducting a detailed examination of the accounting records of the organization to ensure that the information presented is accurate and complete.
  • Reviewing the accounting policies and procedures of the organization to ensure that they comply with the relevant laws and regulations.
  • Preparation of Budget & review the actual Vs Budgeted figure.

GST PAN INDIA & CO. (CA Firm)
07.2020 - 07.2022
  • Finalization of Balance sheet and filing of ITRs.
  • Preparation of Budgeting and Forecasting for Direct expenses.
  • Assisting in the preparation of Audit Report.
  • Preparation of Balance Sheet, Profit and Loss & assisting to the Auditor.
  • Preparation of GST -1 & GST-3B and send data to Tax Consultant.

Education

Bachelor of Commerce -

Tilkamajhi University

Skills

  • Highly motivated and result oriented
  • Excellent oral and written communication skills
  • Proven ability to reach goals
  • Strong organizational and analytical skills
  • Leading team with excellent outcome

SAP-FI

Enterprise Structure (Company creation, Company code, Business Area, Segment), Assignment, Check Organizational Structure., Financial Accounting Global Setting (FAGS) – Fiscal year variant, posting period variant, filed status Variant, Document type, Posting Keys, Tolerance group.

Some important SAP T-code uses in daily basis i.e., FAGLB03, FB03, FAGLL03, S_ALR_87013611 etc., 

Languages

English
Intermediate (B1)
Hindi
Advanced (C1)

Software

SAP-FICO (R3)

Black Line

Advanced Excel

Power BI

Advanced Excel

Good knowledge in Advance Excel.

Introduction of Excel.

Data Entry and Basic formula in Excel 

Sorting Data in Excel 

Filter Data in Excel 

Data Validation in Excel 

Conditional Formatting in Excel 

Text to columns & Flash Fill 

Paste special in Excel 

IF Formula in Excel, IF with AND Formula in Excel, IF with OR Formula in Excel.

Sum if and Count if Formula, Sum ifs and Count ifs Formula.

Match and Index Formula

 V-lookup and H-lookup,X-lookup Formula 

Text Formula in Excel 

Date Formula in Excel 

 Pivot table in Excel 

Sort and Filter Formula in Excel 

Financial function in Excel etc.

Black Line Softwere

Preparing Key and Non Key activities performed in monthly & Quarterly Basis .

Timeline

TELLUS HOMES PRIVATE LIMITED
07.2022 - Current

GST PAN INDIA & CO. (CA Firm)
07.2020 - 07.2022

Bachelor of Commerce -

Tilkamajhi University
Suraj Sagar