Arpit Jhanwer

Arpit jhanwer Faridabad▪ -▪- INTRODUCTION Arpit started his career with Finance and dedicated crucial 4.5 years. Arpit has an experience of 1 year in a leadership role in finance and accounts. Currently he is looking for an opportunity in finance, accounts and data analytics domain. WORK EXPERIENCE 1. Wisecor Services Private Limited (Outsourcing service & solution providers) - Senior Analyst (July, 2016 – Present) Manage Pricing Strategy Maximize the company’s revenue by establishing prices for the company’s +30,000 rentable storage spaces based on ongoing sales closing ratios, the competitor’s prices, occupancy rates and the amount of time that has lapsed since the last price increase. Analyst to the Chief Operating Officer and Vice president financial planning and analysis Direct reporting line and daily interaction with the company’s Chief Operating Officer and Vice president financial planning and analysis with the following responsibilities. Develop Web Application (Backend) using Node (Express) using javascript, type- script, Docker, Swagger and worked with databases like MySQL & MongoDB. Created automated invoice from VBA to excel for the analysis and presentation. Coordinates in the creation of the company’s comprehensive monthly reporting package using current and previous parameters. Intercompany reconciliation, journal entry (depreciation, prepaid expenses, accrued expenses) Actively manage the advertising spend on online lead generation accounts based on the company’s specifications Calculate the staff’s monthly bonus pools Maintaining accounts on Quickbook accounting software & analysing data for the purpose of budgeting and forecasting. Calculate and process customer rent increases Coordinates and manages the creating & forecasting of annual company budgets using current and previous parameters. Managing billing and due days for account payable for the vendor’s service used by the company. Perform ad-hoc analysis as per the company’s requirement including SEO analysis. Automating reports and analysis based on the requirement for the view of company’s high level executive people. Insurance reconciliation for the employees in the company. Posting, managing jobs on ziprecruiter portal of the company for the employee recruitment and manpower planning, budgeting and forecasting. Documenting SOW (statement of work) for employees and engaging them in their sphere of work. Strategy development for the price fixation, expense analysis and other key areas of the company. Attendance marking on Octane ERP. Employee master data updating on octane ERP. Data Analysis on the pricing for the company together with other competitor’s using various tools. Running oracle fusion for the reporting and analysis part. Cash flow maintenance for funds Documents saving related to Private equity investors funds Distribution and call analysis based on payment received Reviewing work of fund accountants Capital schedule maintenance Mark to Market maintenance and analysis Unrealized cost and gains analysis A/R and A/P Sheet maintenance Maintenance of accounts on E-Front ERP Data Analysis for the fund’s profit/losses and as per the fund invested by the company. Doing analysis of companies using fundamental & technical analysis:- 1. Ratio Analysis 2. Dow-theory 3. Peer analysis 4. Balance sheet inspection 5. Discounted Cash Flow 6. Financial Modeling Documentation and compliance for Import and export of the goods. Created and maintained precise and accurate models, charts and reports. Monitored organization's performance against competitors. Built and maintained database for forecasting future financial performance. Identify risks associated with projects, contract approvals and other client accounting issues. 2. Maheshwari Deepak & Associates (August, 2013 to February, 2014) : a) Cash and accounts maintenance b) Filling & preparing returns for individual clients c) Maintaining vouchers for expenses on daily basis d) Preparing journal for all the transactions EDUCATION MBA & PGPM (Finance and International Business) from Amity University (2016) B.com from Delhi University, Delhi (2013) XII class from C.B.S.E Board, Delhi – Delhi Public School (2009) X class from C.B.S.E Board, Delhi – Delhi Public School (2007) SKILLS, INTERESTS AND ACHIEVEMENTS Ms-Word - Ms-PowerPoint Ms-Paint - Ms-Excel VBA - Macros’ SQL - Ms-Acess Sitelink - E-Front Yardi Voyager - Automation for reports and analysis R-Statistical software - Python Monday.com - Octane Quickbooks - Xero Tableau - SEO SAS - MIS ZOHO Analytics - Netsuite Oracle fusion Won gold medal in corporate tournament in Uventus (2015) held in JLN Stadium. First position in Sudoku held in college (2015) at Amity University. Obtained 10th rank at National Science Olympiad. (2007) in Delhi Public School Obtained first position inter-house football competition in Delhi Public School(2006) Active Participant at Delhi Public School in Annual Cultural festival –Chanakya (2003) Soft Spoken, Team Player, Motivated, Adaptable and Quick learner. Forecasted budget successfully for the company (2018). Designed price matrix independently for the new site developed by the company based on the competitor and company reports researched by me. (2018)