Dikshit
Mobile: +813*******
E-Mail: ***********@*****.***
AN OVERVIEW
A professional with the 3+ years of extensive experience in ledger Accounting and Financial Reporting. (journal enries, RTR, PTP, bank reconcillation,expense reconcillation, intercompany reconcillation etc).
Year
Examination/course
Institution
University/ board
Marks
2008
CA Inter
ICAI
ICAI
53.5
2005
PE 1
ICAI
ICAI
55.25
2005
B.COM (H)
DEEN DAYAL UPADHAYA
DELHI UNIVERSITY
51
2002
XII
SACHDEVA PUBLIC SCHOOL
CBSE
79
2000
X
SACHDEVA PUBLIC SCHOOL
CBSE
73
CAREER SCAN
Company Name: GOODTHINGS
Designation: ASSISTANT MANAGER ACCOUNTS
Duration: JAN TO PRESENT
TECHNOGY : TALLY ERP 9.0
Handling day to day accounting.
Handles Day to day accounting(JOURNAL ENTRIES)
Handles all statutory complainces like vat, service tax,tds etc
Ensuring payment as per payment cycle.
Bank reconcillation & coordination with banks,
Balance sheet and profit and loss finalisation as per relevant standards.
Tds reconcillation, expense reconcillation etc
Finalisation of accounts and balancesheet.
Company Name: A.I.G (AMERICAN INTERNATIONAL GROUP)
Designation: PROCESS DEVELOPER
Duration: MAY 2014 TO SEP 2015
Technology: ONEFDC, REPORTNET, SQL(Basics), VBA (Basics)
Designation: PROCESS DEVELOPER
Title: Financial (MIS)reporting
Duration: May 14 till 10th September ‘15
Technology: MS Access 2013, MS Excel 2013 with VBA, SQL(basics)
Tools Used: Visual Studio, sql server management studio.
Role: Consolidation
Responsibilities: HANDLED THE FOLLOWING TASKS:
Data mining using sql management studio.
MIS reporting by using MS Excel & VBA (Macro) at Operational and Client level.
Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department.
Implement and analysis data to create daily, weekly, monthly, and quarterly reports
Design/develop the agreed upon solution in MS Excel/ MS Access with VBA Programming.
Deliver end products maintaining quick turn around times and highest quality standards execute quick turn around work in MS Excel/MS Access which involves VBA
Implement practices and metrics to improve operational efficiencies
Roll out different reports i.e. Efficiency, Collated Trackers, OPS Report, Work Flow Report,
Generating & maintaining day to day MIS Data and updating the management.
Determined required data by analyzing MS-Access databases and created customized reports.
Handling SQL queries for data manipulation and retrieve on SQL server.
Extensive usage of MS Excel (Aggegate function, Vlookup, Pivot table, Macros)
.
Company Name: Sandeep kalra and company
Designation: Assistant accounts
PERIOD : AUG,10 TO SEP,13
Technology: Advanced Excel 2013
Tools Used: Computax, Tally ERP 9.0, ERP MODULES
Responsibilities: Handled the following task:
oWorking independently on the audits like statutory audit, tax audit, internal audit, special audit .
oAudit like tax audit 3CD, statutory audit 3CD,3CA, Special audit 3CD & 3CB etc.
ACADEMIC PROFILE
PERSONAL DETAILS
Date of Birth: 21h June, 1984
Address: LP-56 F,PITAMPURA, Delhi-110088
Linguistic Abilities: English and Hindi
Date : 30/ 6/ 2016
Signature : Dikshit Malhotra
(Immediate Joining)