To ascend to a decision making role, in the MNC, Focusing Business Process Improvement, Analysis with enactment and technology enhancement, A Rewarding organization with opportunities for Personal and Professional Growth. Phone: 899-***-****

Address: Pune, Maharashtra, India 411004

LinkedIn: https://www.linkedin.com/in/rajendra-p.

Email: adp0n9@r.postjobfree.com

Rajendra N. Panshikar

An Ingenious, Organised, detail-oriented Professional, Conscientious self-starter, Out of the Box Thinker, able to strategize and prioritize effectively to accomplish multiple tasks and stay calm under pressure. Gained over 15+ years’ Professional experience in Gulf Countries (Dubai-UAE, Oman) and >8 years in India at multiple vertical MNC’s, worked under various profiles at Hospitality Preopening Operations, Accounting, System Processes Development, Assisting Audit, Malls/Retails Business, FMCG and Pharmaceutical Product Manufacturing, Travels and Tourism and Aviation Sector. SKILLS

Strong ability to motivate, direct, and develop personnel and identifying those with the best strengths for the job. Coordinates with different departments such as HR, Logistics Services, Marketing, Sales Audit, Legal & Branch Operations Proven ability to accurately collect, organize, analyze and disseminate substantial amount of Inbound and Outbound information for business growth Strategies, KPI’s, MIS

Effectively evaluating system performance, Reports, Flaws, finding indicators, and discovering how changes in operations will improve results and meet goals. Provide SRS Documentation

Transition support to Software Projects Team, Implemented LSOP at 5* Hospitality/Other Properties Designed automation framework and implemented the same, in eliminating Hospitality Night Audit Process, which has reduced the processing time by 80% and Payroll Cost, Introduction FO-Pre Check-Out Night Window Report* Provided On the job Software Training to Subordinates/Cashiers, Train the Trainer Program PROFILE SUMMARY

Multi Sector

Multi/Cross Currency AR/AP/GL/Branch Audits Pharma CRM/Sales Distribution Data Pipelining Purchase/MRP/Logistics MIS Assistance Shopping Mall Retailers/Billing, Group Accounts, SRS Inventory Valuation Variance analysis

Monthly Distributors P&L, MIS, Branch Accounts/LC, BG Identification, System Vendor Visits-ERP Bug Regularization Resolving Operational Queries, MRP/Logistics Advance Excel, Pivot, Slicer, X & Vlookup, Index Match/Macro Payroll Processing/HRMS Reports – Gulf Sector Budgeting and Forecasting Assistance to FC Transition Support-Automation/System Migration Government & Overseas Customer/Distributors Accounts Hospitality Flash Reports/Credit Cards/Daily MIS Pack Room Revenue, Type/Average Daily Sales, No Shows POS/PMS/Materials/Banquet/HK Audits PM Rooms/City Ledger Routing, Income Auditing EXPERIENCE

Self Employed

Consulting : Manager Accounts, Business Analysis, Change Requirements, System Study, Automation SRS

Aug-2019 to Present

Aug’2019 Onwards Undertaking Freelance Accounting Job, Actively working as Manager Accounts at Shreenath Plaza CPCS Ltd - Pune Studied Business Model, (Mall with 200 Offices), Streamlined the Tally Accounting setup, MIS, Billing Tracker, Bank/GL/TDS Reconciliation, Audit finalization, Automated Receipts, Facility AMC's renewals, Collections Resolved Past TDS pending matters with the assistance of Tax Consultant Other operational consulting

WIP on Personal Project, Initiated Homestay Facility and Tour Arrangements at Native Konkan MH Phoenix Market City / Vamona Developers Pvt. Limited - Pune Assistant Credit Manager - Mall Accounts and Finance Jan-2019 to Aug-2019

Phoenix Market City is a shopping mall developed by Phoenix Mills Limited located in Pune, Maharashtra. It was opened in January 2011 and is one of the largest malls in India, with the area of 3.4 million square feet. Vamona Developers Pvt. Ltd. develops commercial real estate properties in India. Additionally, the company promotes, leases, and manages malls. The company was incorporated in 2006 and is based in Mumbai, India. Vamona Developers Pvt. Ltd. operates as a subsidiary of The Phoenix Mills Limited.

Accepted the challenge with a Management cognition, to have my inputs at ongoing departmental scenarios At Joining Sessions with new TEAM, HOD’s, as well interaction with Internal, External Auditors, tried to understand the Local Business Model, shared my inputs to UFC, on ongoing audit queries, operational challenges, LSOP, Mall-Retailers Accounts, AR-Age O/S, DA/LLA’s, further analyzed the Commercial impact

Analyzing growth factors at Retailers Rental Income, Revenue sourcing area, Escalations, way’s in improvising Cash Flow Monitoring DCR-Daily Collection Report, Deal Approvals (DA), Letter of Intent(LOI), Leave License Agreement (LLA), Tenancy Schedules, Rent Roll, Projected Revenue, Provisions

Analyze LLA-Term Based, Fix Billing Monthly Cycle, Process Run, Prorate/Projected Billing, Debit/Credit Notes, Reconciliation, Collections, Created using Resumonk - Online Resume Builder

Follow-up, Terminations, Security Deposits Refunds Carried out the important & Pending Management HO Request, Task of Re-verifying >400 Nos. Tenant’s LLA’s further Co-relating their Contractual Terms with the Financial System Data

Presented formatted RPF-(Retailers Proposal Form) Table Data with Commercial Escalations plus PR-Pure Revenue and R+RS Revenue Share, Trading Density

Studied various Reporting Structure’s, LLA Inputs, Calculations, the Bottlenecks, Validations, Flaws, Methodology, Controls, Timelines, Gap between Inter-departmental data sharing/Formats used, Discussed & suggested various points with Central Director on improvisation Updated Higher-ups, with Solution to overcome MIS Dependency Delay’s, Risks, the impurities at existing coordination Designed Automated Template - Tenancy Schedule-1 for Monthly, Term, Escalations Area/Rate Check, CAM/Other system records and YTD revenue forecasting MIS, Security Deposits Analysis Jotting down routing Observation on system Customization requirements in terms of speeding of various internal report as well report requests from HO level, Engineering utility billing, Other Revenue Controls Automation-Excel WIP, Designed a Template and Carried out AR-TDS VS 26AS-TDS traces Reconciliations for last 4 years Compiled and Pipelined the Data & Presented KPI-Budget Foot-Fall Revenue/Counts, based to the Daily Security Check and CCTV departmental modified Visitors Reports, Parking other Revenue Records Providing Excel support to TEAM in reconciling AR-Accounts, follow-up on Group Brand long Outstanding, LDC, Automated the Email Invoice Delivery process, Successfully carried out test Run of (Email Binder program) Attended, Assisted External Auditors Representative, in resolving Causes on Retailers delay in submitting ADSR-Reports and obtaining speedy Certification from Auditors on Final Retailers Net Sales Revenue Other Analysis as per Management Discretion

Pride Projects and Consultants /PC-Soft ERP Solution/ Perennial Technologies Pvt. Ltd – Pune, India

Accounts and Admin Manager/Freelancer

May-2018 to Dec-2018

Associated with Engineering Project Consultant in converting Manual Project Transactions to Tally Setup On-job training to Branch Colleagues, suggest Points on improvising existing workflow, necessary automation, MIS Aligning existing accounting data under GST environment, Monitoring Sales Transaction under GST Formats Monthly, Quarterly GST Returns GSTR-1,2/GSTR3, Payroll, Vendor Payment, TDS and Customer Ageing, Recoveries Designing various Pivotal, Macro Templates, MIS, GST reporting based on the needs & With Auditors Recommendations After Relocation to India from Oman, Jul-2017 Onwards Worked at Software Company in Pune, PC-Soft ERP Solution & Perennial Technologies Pvt. Ltd Pune, as Sr. Team Member/Freelancer continued to provide Services with Learn and earn basis, Under Indian GST environment Al Bahja Group : ID Design Al Bahja Malls Retail Division (Oasis Life Style LLC), Oman Pharmaceutical Products Co LLC (OPP)

Assistant Manager Finance & Accounts (Internal Audit Division) Feb-2009 to Jan-2017

A well-diversified group of FMCG, Packaging, Agro, Trading, Hygiene, Solar, Cable, Pharmaceutical Manufacturing, Industrial and Hospitality & Mall business in Sultanate of Oman -Established in 1947 Initially posted at Furniture Business at ID Design Brand a Unit of Al Bahja Malls Retail Division (Registered as Oasis Life Style LLC) Streamlined the Backoffice Accounting, Custom Clearances MIS, POS, Warehouse operations, Inventory Reporting, System improvisation, Working under Guidelines and Reporting to Regional Audit Head at Head Office Muscat Moved to Oman Pharmaceutical Products Co LLC (OPP) Head Office Accounts Department, Profile includes Contract Manufacturing Foreign Currency Service Debit Notes, Billing Check UCP-600, Overseas Distributors Expenditures, County staff Salaries Debits, Branch claims, Factory Payroll Banking, Closely working with Financial Controller, Department assistance for MIS development, MRP Planning, CRM-Sales cross reconciliations

Achievement: Received Service Excellence Letter from OPP Finance Controller for uninterrupted and Excellent Service for more than 5 years, Recommended for Automation of various MIS, Generated Leave Module Template & Reduced Payroll Processing Time from 5 days to 1 day, Provided Payroll Project SRS (Software requirement Specification Document) to Senior Management Al Ghurair Group :Bustan Macaroni and Noodles LLC & Al Jebel Poultry Farms-Dubai

Management Accountant

Dec-2007 to Jan-2009

Al Ghurair Group : A Dubai based family owned business Conglomerate founded in 1960 Unit: Manufacturers and Exporters of Pasta, Macaroni, Noodles & Poultry products Division ERP-11-I system, Generation of Overseas Payment, On Account, Advances, LC, Bank Guarantee, Bill Discounting, Importers Payments, documents checks, Audit assistance

Assisted in restructuring the MIS Excel Template, Vendor Preferential Consolidation of Sales Orders vs Production order based to available Inventory

The Fairmont-Dubai / Raffles Hospitality (Preopening Team)- Dubai UAE Income Auditor

Dec-2001 to Dec-2007

Flagship Hotel of – (The Fairmont, Raffles, Swiss & Delta Group) Dubai UAE Achievement: Participated in Preopening project’s discussions, Provided Transition Support, A key Finance personnel at Fidelio to Opera System migration, Manual Swipe Credit Card system to 3C Online banking system Flash Report, Daily MIS Pack, Monitoring Tip Distribution, HRD support, Payroll Restaurant shift attendance consolidation, Provided assistance to F&B Department, System Mapping-Liquor Costing Menu Breakups, Macros Report Initiated and designed New POS/Front Office reports for offline balances Attended Micros (POS) 9700 Champions Training

Successfully eliminated Night Audit Process to Day Audit with LSOP write-up presentation to Management, Nominated as Start of the Month Taj Group of Hotels, Mumbai, Indore, Nashik /Cox & Kings (India) Ltd. HO Mumbai, India

Mar-1993 to Nov-2001

Created using Resumonk - Online Resume Builder

Executive Accounts /Accountant

Taj is a chain of luxury hotels and a subsidiary of the Indian Hotels Company Limited - headquartered at Express Towers Nariman Point in Mumbai. Incorporated by the founder of the Tata Group, Jamsetji Tata, in 1903, the Company is a part of the Tata Group, one of India's largest business conglomerates Gained Professional Experience at 5*Hotel President (Vivanta) Colaba Mumbai, Subsidiary of the Indian Hotels Company Ltd, At the start of the career, got an opportunity closely work with Property Financial Controllers, Cost Controls Department to learn Converted existing Cost Budget Reports from LOTUS123 to EXCEL Formats Cox & Kings Ltd., set up in 1758, is one of the longest established travel companies. Headquartered in India and the UK, the Holiday and education travel group has subsidiaries in the United States, Canada, the United Kingdom, Netherlands, and the United Arab Emirates, Japan, Singapore, Australia and New Zealand Achievements: At Cox & Kings Ahmadabad Branch, Headed Mumbai HO-IT personnel, to complete Timely implementation of INTRAM Travel Management system and its smooth operation thereafter, signed-out handover Kusum Trading Company /Air India-Stores Department EDP Operator / Store Department

Temporary Job 1991

Worked at Kusum Trading Company HO Mumbai/ EDP Operator – Handloom designers and manufacturers - Coimbatore Served Air India-Stores Department, Other SME’s Mumbai after Passing of Graduation in 1991 EDUCATION

Successfully Completed SQL-Part of MSBI Module from OPINE GROUP, Pune Aug-2021 Tally Guru ERP 9 Certification Version 6.1 with A+ Grade from Deccan Institute of Commerce, Pune, Jul-2018 International Shipping Export & Import Management Training Program from Career Institute, Dubai 2008 Certified Commercial & Freight forwarding professional Halifax college of London Course done in Dubai 2008 Completed ERP-Management Course from Zabeel Institute-Dubai in 2007 Post Graduate Diploma in Computer Science and Management from St Xavier’s Institute Mumbai in 1993 Bachelor of Commerce from University of Mumbai (Bombay) Dahanukar College of Commerce-Vile Parle in 1991 SOFTWARE APPLICATION WORKED ON

Industry Application/Software Skills

Retails-Malls / Real Estate PMS– Pune Yardi Voyager Property Management Software – AR/ Finance and Accounts Tally Guru ERP 9 GST Certification, Version

6.1 >

Passed Tally ERP with A+ Grade from Deccan Institute of Commerce, Pune Pharmaceutical Manufacturing-Oman PC soft ERP, Access based In-house Payroll, ODBC Dash Board Reporting FMCG Manufacturing - Dubai ORACLE 11i ERP

Retail Business – Oman SMARTSOFT Accounting, FO and POS-SQL Based 5*Hospitality–India – Mumbai

DSRC (Data Software Research Centre), POS-Showman, BOSS(Financial) India

5*Hospitality–UAE FIDELIO/OPERA/MICROS-9700 POS, Materials Management., FCS, ACCPAC Tours and Travel-Ahmedabad INTRAM Travel Management, Alcatel, Galileo Other Travel, Hotel Interface Netu, Spa Soft, Dell5, CRIS, Horizon/TMS, Neo’s, 3C Credit Card Interface MS OFFICE products

Advance Excel; With web support VBA Macro Programming, Word, Outlook, Power point, (Self-study Power BI, Tableau10, ODBC, Google, Forms/Sheets) HOBBIES AND PROJECTS

Drawing, Painting, Interior Design (Space Saving Concept)/Creative Ideas, Travels & Tour Arrangements, Online Self Learning Initiated & Started Catering ODC Business at Nasik/India in the Year 2000 prior moving to Overseas/Later Closed PERSONAL DETAILS

Date of Birth 31-01-1970, Place: Karnataka, India

Passport Number N2964893 Issue Date: 15-12-2015 Expiry Date: 14-12-2025/Oman Languages Known English, Hindi, Marathi, and Konkani, Working Arabic Marital Status Married

Driving License India/UAE/Oman

Created using Resumonk - Online Resume Builder

Contact this candidate