Travel Services Business Analyst

Rajendra Narayan Panshikar

City: Pune, State: Maharashtra, Country: India Mobile +91-899*-****-**

About me

I am a dedicated, organized and methodical individual. I have good interpersonal skills, am an excellent team worker, a self-motivated Ingenious individual, quick learner and very willing to add quality of commitment to a task.

I have an active and dynamic approach to work and getting things done. I am determined and decisive. I observe, identify, Analyse and develop opportunities.

I am Creative, logical thinker, an intersection of technology and business leaders and play a critical role in ensuring that new features are a success for both their organization and their customers. which I believe sets me apart from the common candidate.

Personal Information

Email Phone DOB-Place Driving License Citizenship

********@*****.*** +91-899*******-**-Jan-1970 Karnataka India/UAE/Oman India

Passport Details LinkedIn Marital Status

N2964893/Oman Issue Date: 15-12-2015 Expiry: 14-12-2025 www.linkedin.com/in/rajendra-panshikar

Married

Skills

Creativity & Critical Thinking Project Operations Support CRM-Ideation Visualisation

Emotional Intelligence Business Process Improvement KT-Coaching Adaptability

Advance Excel-Micros, MIS Analysing System flaws, Trends Self-Management Open-mindedness

Employment Work History

Tenure/Project Organisation/Association Location Position/Project Task

From To Details

Mar-2023 Active Kanbiosys Pvt Ltd - Pune

Alliance - De Sangosse India

France SAP Project Manager/Facilitator ECC6 [Business Analyst] Consultant

Providing fulltime Contractual Service as Consultant, an Inhouse Data/Business Analyst to Kanbiosys Pvt Ltd

In collaboration with PRIMUS Techsystems Pune, an India SAP partner, I am heading the SAP Harmony Project of [De-Sangosse France], an alliance of [Kanbiosys Pvt Ltd], in the role of SAP Project Manager/Facilitator. Engaged in the active setup of FICO, SD, MM, PP, QA, QC, and WM modules.

The Kanbiosys company which manufactures products for Plant nutrition, Pest management and Bio-fertilizers which brings full plant potential to life by microbial inputs and precision agriculture.

• Before SAP Project began, Studied Ongoing Scenarios and Contributed the inputs, ideas, Thought Process, Operational Process Change, Automation requirements at multiple areas at HO/Factory/Field Sales /Marketing

• Drafted SOPs for Sales & Distribution, Travel Claim Management

• On-job Support & training for Continuous Process Monitoring, Existing System Flaw escalation, Finding low-Cost alternate Solutions with Inhouse Sales CRM S/W Developers, Other Vendor Developments, Banking partners

• Created and executed MIS Advance Excel Trackers in accordance with the requirements and logical inputs/outputs provided by the departments

• Took part in the SAP Project Kick-off meeting in order to learn about the roadmap, scope, scalability, Site Visits, Project automation H/W and ILL line network requirements, Project Blueprint validation

• Be alert, proactive at all levels, attend daily and weekly steering committee meetings, and contribute subject matter expertise.

• Researched, comprehended the important roles that colleagues already play, and carried out the selection of key individuals for the SAP project.

• Thoroughly monitoring the need for SAP transition data, gathering and standardizing source data for SAP Pivot upload templates

• Collaborate with the customer, partners, stakeholders, and SAP management to efficiently manage and oversee projects in order to guarantee their successful completion and a major influence on the business KPI of the customer.

• Oversee overall services relationships, steering committees, and project offices with partners, customers, and the SAP-France team during installations to guarantee that projects are completed on schedule.

• Facilitate, assist in resolving queries of end users in confirming AS-IS, TO-BE, WISHLIST, GAP ANALYSIS – KDS [Key data structure], UAT documents, Training Schedule arrangements, Factory Visits

• Conducting Pre-screening Interviews of the shortlisted candidates by HR, All Transition support through billable consulting

• Previous Project Profile Includes, Project base Full/Part time, online/WFH, Job Support to Start-ups entity, Assistance on Health Clinic Data Startup Events, SME’s. Shopping Complex, Society Facility, Individuals Job base Freelance support

• Providing Techno functional Services, Tally S/W Business Change Requirement Assistance, Annexures, Customisation needs

• GMP, Operational Process change requirements, SOP Assistance, Scrutinising transactional S/W Flow/Flaws, Bugs

• Experiencing on Job requirements, Exploring, Learning & providing New Ideas (Data Analysis, Automation, MIS tabulation)

• Designing Excel Advance validation trackers, Training as per business requirements, YTD Variance analysis

Tenure/Project Organisation/Association Location Position/Project Task

From To Details

Jul-2022 Oct-2022 Health System Technologies -Project Assignment Pune Start-up Company

(Operations S&M)

• Team Leader to Co-worker to direct, co-ordinate and provide leadership to all staff. Support to Project consultants

• Identified and provided solution to resolved unsafe, ineffective practices in reduce the company operational cost

• Design Ideation to Promote S&M activities, translation

• Answering doubts of colleagues/BA-interns, discussing user stories, value addition to the Projects/application development

• Data Sourcing, alignment, competitive Analysis, Assistance to IT Developers for Test Case check solution.

• Strategic Assistance in planning, Model Projection, Tabulation & desired MIS formulation

• Advanced productivity KPI for achieving key business goals and objectives, Visits to On Site Potential Leads

• Achievement: Opening of Concept Healthcare Center [Working Model Called “Maha-E-Clinic”]

Jun-2022 Jul-2022 Elevate-Bio - Waltham MA 02451 USA WFH- Lock-down

Month Assignment (SAP)

• USA Based Organisation (Operating a portfolio of cell and gene therapy)

• WFH- Month Assignment: AP Module GRIR/ on SAP_S4Hanna_ON_Premise Module, Data fetching Created Data Source linkage

• Reconciling Transaction allocation, Automated desired MIS for Daily status review

Feb-2022 Mar-2022 Ozone Info Engineering

Pvt Ltd Pune Project Support Manager

• Configured 200 Nos. Bio Matric Machines for Multi-Region Govt. Warehousing at Head Office

• On Site Support at Govt office MSWC

• Smart office Biometrics HRMS Solutions (Brand: Biomax)

• Fetching, aligning and Uploading the Payroll Employee Live Records at new system templates under SAP environment

• Created delivery Logistic plans estimate and communicated deadlines to complete projects on time.

• Completed paperwork, recognizing discrepancies and promptly addressing for resolution.

• Exceeded goals through effective task prioritization and great work ethic.

• Achievement: Delivered services to customer locations within specific timeframes.

Jun-2020 Feb-2022 Shreenath Plaza CPCS Pvt Ltd Pune Manager Accounts

• Restructuring of Tally ERP Setup

• Audit Finalisation for 2 years, submission to Government Authorities.

• Developed pipeline to monitor Rental progress and boost Members collection.

• Addressed problems with accounting, billing and service delivery to maintain and enhance client satisfaction.

• Automated the third-party Rental Billing A/R process, Bank Reconciliation.

• Tabulated and cleared GST/TDS/Tax back-log with assistance from Tax Consultant

• Other Operations and Legal administrative correspondence with Auditors/consultants

• Achievement: Streamlined 200 units/90K Sq. Ft. Shopping Complex Accounting.

Jan-2019 Aug-2019 Phoenix Market City

(Vamona Developers Pvt Ltd) Pune Assistant Credit Manager

(Accounts and Finance)

• Departmental Correspondence for A/R Billing Information, Prorate/Projected Billing, Presenting the summary insights to CD

• Monitoring AR Billing Process AP vs AR Setoffs, Deal Approvals (DA), Letter of Intent (LOI), Leave License Agreement (LLA), Tenancy Schedules, Rent Roll, Projected Revenue, Provisions

• Analysed LLA-Term Based, Fix Billing Monthly Cycle, Process Run, Prorate/Projected Billing, Debit/Credit Notes, Reconciliation, Collections, Follow-up, Terminations, Security Deposits Refunds

• Studied various Reporting Structure’s, LLA Inputs, Calculations, the Bottlenecks, Validations, Flaws, Methodology, Controls, Timelines, Inter-departmental data sharing gaps/formats used, suggested various change requirements to Central Director.

• Compilation of the Contractual Terms with the (Yardi) Financial System Tenancy Scheduler

• Tabulated and Presented RPF- (Retailers Proposal Form) with Commercial Escalations plus PR-Pure Revenue and R+RS Revenue Share, Trading Density. Footfall Report

• Designed and Implemented Email Binder Excel VBA Macro base automation for Customer Email Billing Process

• Co-ordinate with YARDI Software vendor for fixing system bugs

• Exceeded goals through effective task prioritization and great work ethic.

• Achievement: Management HO Request, Task of Re-verifying >400 Nos. Tenant’s LLA’s.

Tenure/Project

Organisation/Association Location Position/Project Task

From To Details

May-2018 Dec-2018 Pride Projects & Consultants Pune Accounts and Admin Manager

• Conversion and updating of Projects manual recorded transactions to Tally Accounting Systems, Project Payments

• Observed daily routine, discussed with owner and made necessary workflow changes

• Liasoning with Auditors for GST/TDS rules, threshold limits, Designed Tabulation Template as per Auditors Guidelines

• Visited project site (SKODA Factory) for better understanding of site Operation

• Achievement: Timely Completed the task and Provided training to new staff

Feb-2018 Apr-2018 Perennial Technologies Pvt Ltd Pune Senior Team Member (Commercial)

• Participated in continuous improvement by generating suggestions, engaging in problem-solving activities

• Designed Templates and provided training to junior staff on scheduled reporting, Software Data Inputs.

• Monitoring of Project Staffing, Onsite Material demand, Warehouse inventories levels.

• Reconciled and posted all receipts and cleared of past disputed A/R accounts for DSO improvisation.

• Presented Commercials MIS to Management for implementing it at Branch operations

Jul-2017 Nov-2017 PC-Soft ERP Solutions Pvt Ltd. Pune Voluntary Service

• Held a volunteer position to learn about latest technology trends, development under GST Environment

• Experienced Impact of GST Change requirements at Existing Software

• Attended Company Inhouse/Onsite Consulting Demo sessions, noting of FAQ’s, change requests

Feb-2009 Jan-2017 Al Bhaja Group of Companies Muscat, Oman Assistant Manager

(Internal Audit Division)

• Group Company Transfers, Worked at multiple profiles

• Oman Pharmaceutical Products Co LLC - Manufacturing Unit HO Office

- Factory Payroll, Distributors, Cross Currency AR/SO Management, MIS, S/W Bug corrections vendor visits, Audit Annexures

• Oasis Life Style LLC - Furniture Business Unit

- Brand: ID Design. Fixed all Backlogs, Custom Clearance, Aligned Warehouse Inventory, System Upgrades, Monthly Unit MIS

• Al Bahja - Mall Operations Carry out surprise visits for transaction verification, Contractual Billings Implementing, New Guidelines, Asset Accounts, Mall renovations, Shop Closer formalities, HVAC Inventory check

Dec-2007 Jan-2009 Al Ghurair Group

(Bustan Macaroni Noodles LLC) JAFZA

Dubai-UAE Management Accountant

FMCG/Poultry -Division

• A Dubai based family-owned business Conglomerate founded in 1960

• Unit: Manufacturers and Exporters of Pasta, Macaroni, Noodles & Poultry products Division (Al Jebel Poultry Farms)

• Inter-Company Accounts, GL Reconciliations, Multi-Country Sales Order Consolidation, Prioritising assistance

• Attended Audit Queries /Foreign Currency Payment LC, BG Documentation, under ERP 11-I environment

Dec-2001 Dec-2007 5* Fairmont, Raffles Hospitality Dubai-UAE Income Auditor

• Units of flagship Hospitality (The Fairmont, Raffles, Swiss & Delta) Group /Canada, Colleagues from 49 Nationalities

• Proud to be a pre-Opening Member of 5* Properties, The Fairmont and Raffles Dubai Hospitality

• Key Revenue/Income Audit Personnel in verifying all Hospitality Transactions, Monitoring Night Audit operations

• Verifying entries of guest and non-guest, Paid Outs, POS, City Ledger, Banquets, HK, Spa, Tips, Complementary A/C’s

• Cross verifying, Interface errors & corrections of all FO/POS Cashier Break-shift, Folio Billing from Multiple Departments

• Recheck reservations routing remarks from room status change, No Shows, Upgrade, Rate change, Discounts, Cash, Credit Card change, Deposits, Authorisation Blockings, tips, Complementary, VIP Guests transactions and discrepancies

• Producing operational and managerial reports (Flash Reports)

• Training Programs: Micros (POS)9700 Champions, Key Personnel Transition Support in migrating Fidelio to Opera, Trainer

• Achievement: Presented Ideation and implemented SOP in eliminating Night Audit Process, which saved the Manpower Cost

• Achievement: Nominated as Star of the month, Promotional transfer at (Raffles Dubai) 5* Chain Group Hotel from Singapore

• Assisted IT-Team from Canada & Local Vendor – to carry out successful implementation of all software/interfaces

Mar-1993 Nov-2001 Other Multiple Organisations (Accounting Divisions) Mumbai, Indore, Nasik. Ahmedabad Executive Account

Hybrid Roles

• Taj Hospitality, got opportunity to worked at multiple locations and to be a part of pre-opening Operations at 5* Properties

• Cox and Kings (India) Pvt Ltd. Mumbai/Ahmedabad role played as Accounting Executive, Branch Operations, Intram Setup

• Kusum Trading Company - Mumbai Handloom Machine Manufactures and Traders - Worked as EDP Operator

• Air India Post graduation, worked at NIPTC-Mumbai Stores Department

Industrywide Software usage

Industry Application Worked On Industry Application Worked On

1. AGRO /Product Mfg. SAP ECC-6

Transition Support 2. Tally PRIME Tally Prime Customizations Support

3. AGRO /Product Mfg. NITSO-HRMS Findings on S/W Customisation needs. 4. AGRO Product MFG. TEEM FORCE - KBPL-Tailormade Sale CRM – Data Flow/Flaw Identification

5. Retails-Malls / Real Estate PMS Yardi Voyager Property Management 6. 5*Hospitality–India DSRC (Data Software Research Centre), POS-Showman, BOSS(Financial) India

7. Tally Guru ERP 9 GST Certification Tally ERP 6.9.1 8. 5*Hospitality–UAE FIDELIO/OPERA/MICROS-9700 POS, Materials Management., FCS, ACCPAC

9. Pharmaceutical Manufacturing PC soft ERP Accounts/ Logistics, In-house Payroll 10. Tours and Travel INTRAM Travel Management, Alcatel, Galileo

11. FMCG Manufacturing ORACLE 11i ERP 12. Travel, Hotel Interface Spa Soft, Dell5, CRIS, Horizon/TMS, Neo’s, 3C Credit Card Interface, Netu

13. Retail Business SMARTSOFT Accounting, FO and POS-SQL Based 14. MS OFFICE products Advance Excel: Pivot, VBA Web Support Macro

15. CRM/Sales/HRMS BITRIX24, Teams,

Teem Force/NITSO HRMS 16. Application study WIP (Self-exploration) SAP, Power BI, Tableau10, ODBC, Google Forms/Sheets, Adv. Power Point

Academic /Courses

Month-Year Details

Jun-2022 Successfully completed Power BI Module from OPINE Group, Pune – Under Exploration

Aug-2021 Successfully completed SQL Basic Module from OPINE Group – Under Practice

Jul-2018 Tally Guru ERP 9 Certification Version 6.1 from Deccan Institute of Commerce, Pune with A+ Grade

Sep-2008 International Shipping Export & Import Management Training Program from Career Institute, Dubai

Sep-2008 Certified Commercial & Freight forwarding professional Halifax college of London Course done in Dubai

Feb-2007 Completed ERP-Management Course from Zabeel Institute-Dubai

Sep-1993 Post Graduate Diploma in Computer Science and Management from St Xavier’s Institute Mumbai

Apr-1991 Bachelor of Commerce Mumbai University (Bombay) Dahanukar College of Commerce-Vile Parle

Language Proficiency

English Hindi Marathi

Konkani

Arabic

Hobbies

Pencil Sketch, Painting, Artifact Gardening /Recycling Online Self Learning BI-Trends, Qlik View Creativity Hospitality, Travel & Tourism Study, Interior Design Ideas, Space Saving Concept design

Reference can be provided on request

Notes:

Contact this candidate