Arvind Gupta

Arvind Gupta

$3/hr
Accounting assistant with data analyzing
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
36 years old
Location:
Delhi, Delhi, India
Experience:
8 years
 -- Core Competencies Management Reporting Business Continuity Planning New System Implementation Training & Development Process Improvement/ Optimisation Human Resource Business Partner Internal Control & Audit Support IT Skills Oracle R12, SAP, Advanced MS-Excel, Power BI, Alteryx, GLDM Completed 100 hours Information Technology Training conducted by ICAI Can easily adapt to any software or any computerized environment. Education 2012:CIA course from ICA preetvihar 2011: B.Com. from Delhi University CA-CPT from ICAI Soft skills Collaborator Communicator Planner Thinker Innovator Profile Summary Offering over 8 years of experience in accounts, operations management, transition, business analysis, team management, variance analysis, R2R, Intercompany reconciliation, vendor Reconciliation, and monthly management reports Currently associated with Accenture as SME Extensive exposure in managing various types of invoices Working on Automation with the use of Alteryx software. Domain Purview: F &A solutions, process deliverables, R2R, General Accounting and Banking Training Attended Reconciliation Training for the GE Capital Customer First Operational Accounting Trainingfor the accounting procedure. Lean Training Management Training Batch Oracle R12 Application Passion at work. Interpersonal Effectiveness and Influencing Skills. Excel & Email Writing Notable Accomplishments Across Career Recognized as Business Analyst & Financial Analyst by the onshore business partner Multiple lean ideas for automation of journal entries, reconciliation and in various other processes by using MS Excel Half yearly Silver award of cross training backup level 1-2, 100% SOP Updating Star CSR Volunteer Award for 2017 Conducting business continuation plan testing every quarter at BCP location and share results with management Setting up targets, DTP& SLA, and maintained CTQ (Critical to Quality) / CTP (Critical to Process) for the process; administered execution of high quality on-going analytic and Adhoc requests accurately and delivered on time Organizational Experience Since August’2018 to till now: Accenture India Key Result Areas: Identify and investigate significant intercompany breakages Identification and resolution of issues when posting invoices and correction of postings Analyze backlogs, identify root causes and finding possible solutions Coordinate among Global Process Owners, Local or Regional Process Owners, and other Shared Service Centers for several Intercompany related topics Monitor of aging of suspense to avoid suspense provision Intercompany WMI AR: Preparing the file for World market Inc. which shows how much amount is receivable from different customer groups according to org unit or transit. After this preparing Invoices to allocate expenses for different regions. Transfer Pricing Settlement: - Preparing the file for Parent Bank which shows how much amount is pending from 32 customer groups. After checking making settlements between them with preparing of wires and processed Journals. Reconciliation of Unclaimed Balances to GL: - We pull out domestic reports from postedge and pull GL from Oracle (GLDM) and making reconciliation between them and process the required journal. NRD settlement between Parent Bank & ISI London Transfer pricing settlement Wires ISI Reverse Repo Process: - Prepare the file for Maturity amount and new Investment amount also find out accrual amount need to be booked. Bank Reconciliation on month end. Performing day to day journals & deliver daily performance as per agreed SLA matrix. Track Intercompany reconciliation status and taking necessary follow-up with other teams within the Bank to get variances resolved before month end. Performing necessary adjustments based on the reconciliation and passing Journal entries to balance and correct any errors, omissions, etc. Maintaining up-to-date working files for Sox purposes and prepare Artifacts for Internal Audit team. Prepared quarterly regulatory and reporting and performed comparison between current quarter and previous QTR revenue numbers and provided comments for the variance for each form being prepared for the regulatory and reporting Preparing 34 of reconciliation between different customer groups Processing almost 100’s of Pass through entries in the month end. Apart from my regular activities preparing almost 50-60 of wires each month as per client request. For Example Trailer fees, Project beach, IC wires and Adhoc wires. Clear daily cash from Parent bank and process that entry Conducting Quarterly Bashes, Friday fun activities, , Talent Hunt Shows, Diwali Bash, Independence day and Republic day Events. Since Feb’2012 to till May 2018: Genpact India Key Responsibilities in Schneider Electric. Managing month end closing & reporting: Balance sheet accounts reconciliations (cash & accrual), Bank Reconciliations, Preparing intercompany reconciliations & settlements, Income statements & Tax accounts reconciliations (Use Tax, Deferred Tax, Sales and Property Tax etc.) Intercompany confirmations: - We confirm the amount comes from different vendor for month end closing point of view. Intercompany Reconciliation: -Doing Vendor Reconciliation in the mid of the month. Accrual Posting: - Post accrual in SAP system, the difference of amount in vendor books and in our books. Reports AP & AR numbers in OPUS: - After Accrual posting post final numbers in OPUS system. Clear G/L process open Items:-through FBL3N and F-03. Invoices:- Provide GL and CC of Invoice to AP team for Invoice Processing. Basware: -Provide Invoice codling’s through basware system as well. PO and Non PO: - Check out weather Invoice is PO and Non PO. Adhoc request: - Query handling from client side. Fixed Assets: - Creating and editing of Assets in SAP system from shopping cart. B/s Recon: - Maintain the sheet of Balance sheet GL’s each month. Accrual: - Preparing IC Accrual and Accrual Sheets for Employee Recharges. Variance Analysis: - Doing various General ledger analyses quarterly for checking how much increase in cost. Key Responsibilities in GE Capital. VAT REPORTING Gather and monitor the incoming and outgoing transactions (Sale & Purchase) for filing the monthly and quarterly VAT/GST returns of branches located globally like (Australia, South Africa, Canada, Algeria, Nigeria, UK, Ireland, etc.). Auditing/analysis of data for compliance to local laws of particular country and sending data to local for filing of return with backups. Follow up with the local finance team for filing and remittance of taxes. Collect the copy of return and upload to GE’s tracker. Key Projects Implemented Receive Top Performer Award in just 6 months in Accenture and in 1 years receive Client Appreciation Award. Taken the full ownership of maximum task in the process and completed it with 100 % accuracy and appreciation. Publish the Dashboard through Power BI Performing many task with Altyrex team. Make my identity as a reliable and well matured source in customer and my manager eye's to complete my all task with confidence and well structure manner Played a key role as a good team member and assist my team members to come up with the process learning curve and skills. LEAN (quality) tested and certified. Also filed two LEAN ideas for process improvement. Give my 100% to provide the Valuable services to the customers to make Genpact image as reliable and Valuable source. In the results get 10/10 as a VOC New Business Intercompany Process Remote Transition -2016 Greater than $2B Aging Items Clearance Project – Finished Project at $2M in 2016-17. Personal Details Date of Birth:10th March 1990 Languages Known: English and Hindi Address: 1544, DDA Flats GTB Enclave Dilshad Garden Delhi 110093
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.