Contact: 085********
Email: adl52n@r.postjobfree.com
YELLAPU RAJASHEKHAR
Objectives: Obtained a challenging leadership position by applying problem-solving techniques and learned management skills in growing companies to achieve optimum utilization of resources to maximize profits. I have experience in hardcore accounting, analyses in the computerized environment for the last 19 years.
Academic Profile
Last completed : Post Graduation in Commerce
Specialization in Accountancy (1999-2001)
University : Andhra University
Specialized courses
oDiploma in Tax management (welingkars)
oM.S. Office Specialized in Excel + VBA
oPost graduation in computer applications
oTally ERP 9, Quick Books Online Certified.
oMicrosoft Dynamics-Great Plains and Acclaim ERP software’s.
oDigital Marketing from Digital Ready Hyderabad
Skills gained on the work environment
Better usage of the Excel with all the functions, Macros & VBA for financial reports and automation routine activities as far as possible.
TDS, VAT, Payroll, Service tax, Bank Reconciliation on the Tally software, and ERP software’s like Great Plains, and Acclaim, Quick Books Online.
Experience Summary
Designation
Duration
Organization
Place of work
Articled Clerk (mm085898)
3 years
(10-08-1998 to10-08-2001)
Under T. Mohan
Chartered Accountant
Visakhapatnam
Accountant
2 years 3months
(05-04-2002 to 30-06-2004)
J.S. Enterprises (HLL Regd. Dealer)
Visakhapatnam
Accounts Assistant.
8 months
(02-07-2004 to 25-02-2005)
U.A.N. Raju – IVRCL construction (JV)
Jammu
Senior Accountant
1 year
(04-04-2005 to 31-08-2006)
Agarwal Group of Companies
Mumbai
Officer Accounts
2 years
(01-09-2006 to 24-08-2008)
RSM Mcgladrey FPO India PVT Ltd (USA experience).
Mumbai
Executive Accounts
10 months
(25-08-2008 to 31-05-2009)
Miel E- Security Pvt Ltd
Mumbai
Sr. Subject Matter Expert-Accounting
71/2 years
(09-06-2009 to 28-04-2017)
Acclais Inc. (USA experience)
Unit of Tower Watson LLC.
Visakhapatnam
Accounts Manager
4 Years
From 01-05-2017 to 31-08-2020
Sowjanya Enterprises, SS Logistics, Sowmya Transport.
Visakhapatnam
Senior Process Associate
21-09-2020 till date
Precistat IT solution Pvt Ltd (Walters & Skylar LLP) (USA experience)
Visakhapatnam
Work experience in detailed Current to past:-
Senior Process Associate in Precistate IT solutions (USA experience)
1.Working US Payroll and Financial Accounting in QuickBooks
2.Automation of QA Reports (VBA)
3.Standardized Process to Clients for long term service
4.US Tax preparation.
5.Bookkeeping for Small Clients.
Accountancy and Tax Expert at (Sowjanya Enterprise / Sowjanya Transport / SS Logistics)
1.Supporting Accounting Team in Works like – Payroll, Billing, Reconciliation.
2.Working on TDS process GST Process.
3.Working upto Finalization in Tax Audit & ITR Filing.
4.Assisting for Clearing and handling agency Works – Like HS Code, Custom Duty Payments, and E-Way Bills Etc.
Senior Subject Matter Expert in Acclaris Business solutions Pvt Ltd (09/06/2009 to 28-04-2017) (USA experience)
1.Bank Reconciliation: Working on payment batches to release checks, ACH, and payrolls also request of funds (peg balance funding) from the clients for the daily payments, Bill the clients based on the activities performed by us.
2.Investment reconciliation (buy/ Sale recon): working with Denver investment partner for the settlements done at both ends.
3.Pay roll wire match: Receiving the contributions from the clients through wire and adjusting among the members of the groups of the clients
4.Help tickets: Working on requests of participants for Closing accounts/ Payment adjustments/ movement of accounts/ return of excess contributions etc.
5.Payment audit: Monitoring the checks so issued by us has been correctly delivered to the payee timely.
6.Mis reports: I have designed automation templates for all the production reports and manpower utilities during the process for effective use of time and resources.
Executive Accounts in Miel E-Security Pvt Ltd (25/08/06 – 31/05/2009)
1.Payroll Process: CTC Preparation, Salary Preparation based on HR leave Records for over 250 Employees & Generation of Salary Slips though Mail merge., Preparation of challans to Prof Tax, P.F & ESIC., Income tax working of Employees though software for 150 employees for TDS Deductions based on declarations., Full and final Settlement workings till cheque preparation.
2.E-TDS Process: Extraction of Details of Deductions from Tally in Excel, Payment of the Deductions on due dates, Designed Macro-Enabled 281 Challan in Excel for submission in bank. Filling FVU return at TIN facilitation center along with 27Q.
3.VAT, CST Process: Extraction of Purchase Register & Sales Register from tally in excel, categorizing details CST, LST, Stock Transfers, and P.O, Payments made after taking Credit for the Set-off on inputs along with return Cum Challan, Dealing on overall Administrative functions Like, Vat Registrations.
4.Service Tax Process: - Payments of the Service tax so deducted in TR6 challan before 5th of Next month, Submission of half yearly ST3 Returns.
5.Reconciliations: - Bank Reconciliation’s, Supplier’s reconciliation’s, Customers Reconciliation’s, Inter Departmental Reconciliation Like Logistic V/s Accounts, Collection V/s Accounts., Stock reconciliations with inventory V/s Accounts.
6.MIS Reports: - Ageing of Debtors’ & Creditors, Monthly Working capital Statement Giving to Banker with whom CC A/c taken on hypothecation of Sundry Debts
7.Ledger Scrutiny: - Receiving & Sending confirmation of Accounts to either to costumers or suppliers
8.Finalization Of Accounts: Preparation of Scheduled balance sheet along with notes to accounts as per Accounting standards & schedule IV Part I & Part II of Company’s act, Computation of Income as per the normal provisions of the income tax act as well, as per MAT calculation, Adhering to Scrutiny notices
Officer Accounts in Rsm McGladrey FPO Pvt Ltd (01/09/06 – 24/08/2008) (USA experience)
1.Accounts Payable processing of invoices prepping & review
2.Check building, manual checks
3.Daily deposit verification
4.Bank reconciliation: Master, operating, payroll bank accounts with the GL bank statement.
5.Financial activities: Accounts payable reconciliation, audit schedule, etc...
Senior Accountant in Agarwal Group of Companies (04/04/2005- 31/08/2006)
1.Book keeping: Preparation of vouchers, journals, credits, notes (debit/ credit).
2.Entering the financial transactions on Tally 7.2 release 8.1.
3.Purchasing / work orders for material & sub contractors,
4.Finalization of accounts also worked on Scrutiny notices.
5.Payrolls, Employees provident fund & ESIC Calculations & filling to the dept
6.Sales tax on works contract as per vat regulations
Accounts Assistant in UAN Raju – IVRCL Construction (J.V) (02/07/2004 – 25/2/2005)
1.Book keeping: Preparation of vouchers, journals, credits, notes (debit/ credit).
2.Petty cash maintenance for site expenses.
3.Recording of financial transactions on seva package.
4.Stock reconciliations on excel spreadsheet.
5.NMR sheets through checking Daily Labour reports.
Accountant in J.S. Enterprises (05/04/2002 – 30/06/2004)
1.Financial Accounting on tally 4.5 & recommended software of HLL
2.Maintenance of sales tax records on respective forms
3.Maintenance of labour records on respective forms
4.MIS inventory Billing, CRS ordering, JC claims, etc...
Articled Clerk (10/08/1998 – 10/08/2001) (Audit and accounting)
S. No
Organization
Type of operation
Activity
Mode of functioning
1
Nalanda talent school
Educational institution
Financial accounting
On tally 4.5
2
Dena bank, vijiya bank, Bank of Baroda
Banking
Internal audit, statutory audit
By Applying AAS
3
Tass engg pvt.ltd.
Construction company
Financial accounting & finalization
On tally 4.5 and excel spreadsheets
4
O-optex
Textile trading
Tax audit
By applying AAS & income tax provisions
5
Polytechnic college
Educational institution
Financial accounting & finalization
On tally 4.5 and excel spread sheets
6
Office
Taxation
Computation statements and
On VPP or excel spread sheets
Personnel Information
Linguistic Proficiency
(Speak, Read & Write) : English, Hindi & Telugu
Date of Birth : 19-06-1978
Father’s name : Y. S .Apparao
Marital Status : Married
Permanent Address : 61-2-39/4, R.K.Puram, Malkapuram, Visakhapatnam
PAN : ACHPY1717D
Aadhaar : 938*-****-****
Passport : H6892102
I hereby assure that the above details are correct and true.
Yellapu Rajashekhar