Arti Arora

Arti Arora e-mail:-Mobile no.: +91 - Profile: Executive Assistant cum Business Analyst with twelve years of relevant experience. Thorough and meticulous Data Analyst, passionate about helping businesses succeed. Former small business owner and recipient of an PGDBA. Possessing strong technical skills rooted in training. Core values: MIS reporting and Business Analysis for helping in taking informed strategic decisions. Detail oriented and system driven. Passionate about creating automated system and programs / applications to reduce manpower cost by increasing productivity and accuracy. Good in interacting with people. Educational Qualifications 1. PGDBA, Diploma in Business Administration, from Symbiosis, Pune (2004 – 2006) 2. Graduation, B. com. from Delhi University -th – CBSE -th – CBSE (1997) Professional Qualification and trainings attended 1. Data Analysis online course (8 months, 2019) consists of Python, Pandas, NumPy, Matplotlib, Correlation and Regression, Data Cleaning, Data scrapping, etc. 2. Diploma in Administration (1 year) from Y.W.C.A. of Delhi 2. Diploma in MS Office from NIIT 3. Done short-term course in Corporate Business Communication from British Council, C.P. 4. Attended 15-days training program in Bangalore to operate JDE package & receive thorough training in Excel, Word & Power Point. Also, attended training sponsored by S.C. Johnson Products Pvt. Ltd. on Advance MS office (VBA / Macros, Pivot Table / H-lookup / V-lookup etc./index-match function) 5. Attended certified training on 5 S in Capsugel Healthcare Ltd. 6. Attended training on SAP in admin function. Projects 1. Prepared MIS dashboard presentation for easy understanding. 2. Automated the project report / HR data report with the help of VBA / Macros / Python 3. Prepared Cost vs. Revenue financial report presentation. 4. Currently working on preparing small program / application to automate the routine office jobs. Computer Qualification: Programming language : Operating System : Software Packages : DBMS Known : Designing Packages : Mail Packages : Python (Pandas, NumPy), VBA / Macros MS Dos, Windows 98 / XP / 2000 MS office (advance version) Excel, Word, Power Point, MS Binder, SAP MS Access, FoxPro 2.6, Navision Photoshop 7.0, Page Maker, Corel Draw 10 Eudora, Outlook Express, Lotus Notes Job Experience: Total 12 years (10 years of experience as Executive Assistant / Secretary and last 2 years of experience as Data Analyst cum Assistant Manager office administration) 1. Astrum Value Homes Pvt. Ltd., as Assistant Manager – Administration reporting to Chairman w.e.f. Nov 2017 to Aug 2018 • Arranging meeting – booking conference room, circulating agenda of the meeting with written material, preparation of MoM and following up on tracking sheet to meet deadlines of the action points. • Routine Correspondence - drafting letters and documents; collecting and analysing information; producing agendas, minutes and all key paperwork for meetings. • • • Calendar Management – Maintaining busy appointment schedule by planning and scheduling meetings, conferences, teleconferences, and travel. Travel arrangement – arranging business/personal visits by arranging logistics, flight and hotel booking, issuing letters, applying for visas, preparing schedule sheet of day to day activities of the visit with important contacts, etc. HR activities – arranging induction programmes, maintaining employees’ files and data, posting the job openings in the job portals and shortlisting the candidates for the interviews, etc. 2. Capsugel Healthcare Pvt. Ltd., as Sr. Executive Assistant reporting to MD w.e.f. 27th August 2011 to 22nd Aug 2015. Responsible for the following tasks. • Analyzing MIS / various project / operational / Financial reports – collecting data from different resources and departments through online data scrapping and SAP reports, respectively and cleaning / structuring / analysing the raw data with the help of VBA / Macros / Excel / Python, etc. Prepared MIS dashboard for easy understanding and automated the routine work. • Arranging meeting – booking conference room, circulating agenda of the meeting with written material, preparation of MoM and following up on tracking sheet to meet deadlines of the action points. • Routine Correspondence - reading, researching, and routing correspondence; drafting letters and documents; collecting and analysing information; producing agendas, minutes and all key paperwork for meetings; initiating telecommunications. • Calendar Management – Maintaining busy appointment schedule by planning and scheduling meetings, conferences, teleconferences, and travel. • Assisting MD in budget preparation, financial planning and budget reviews of different departments/Group as a whole. • Travel arrangement – arranging business/personal visits by arranging logistics, flight and hotel booking, issuing letters, applying for visas, preparing schedule sheet of day to day activities of the visit with important contacts, etc. • Making follow up with all the HODs relating to any deviations to processes/ standard and report to the Manager. Liasioning and follow up with all the respective offices, plant and business locations for required information. • Vendor management: managing and formulating agreements, monitoring renewal of agreements, vendor satisfaction through timely payment, regular meetings, billing process, etc. • Handling Budget and Petty cash account: Managing budget and petty cash account for both the sites Rewari and Mumbai office. • Event management: coordinate details of events, managing staff for preparation, detailing on decoration, food menu, music, venues, gift items selection, preparation of invitation / circulars, negotiations with the vendors, arrange transport, etc. • Transport Management: Analysis of cost models, vendor evaluation and defining service level agreements for vendor, ensuring on timely pick up and drop, cost optimization, monthly cab leaders meeting to handle grievances and issues, if any. Handling taxi service for non-regular use i.e. cabs for foreign customers, sales team on both locations, etc. • AMC Management: Negotiate & maintain annual maintenance contracts with various vendors and their cost-effective renewal. • Handling audits independently: for instance, Canteen Audit, Transport audit, Pest Control Audit, Housekeeping facility audit, etc. • Liaisoning between Union and management: attended union meetings, using diplomacy and confidentiality at highest degree, listening to the issues and grievances, etc. 3. M3M India Ltd., as an Executive Assistant – Admin, reporting to Chairman & Directors (owners). From 2010 – 2011 Responsible for the following tasks. • Solely handling different events i.e. project launch of the company, etc. • Handling correspondence on behalf of Director. • Keeping track of work progress by interacting with different departmental heads. • Managing Director’s calendar regarding appointments, reminders, etc. • Drafting and sending approvals, schemes and other policies and keep a track of the same. • Preparing presentation using latest version of PowerPoint, Excel, Word, etc. and helping my direct official in presentation and analysis. Independently generated special format on excel for analysis. 4. Shriram Bioseed Genetics India Ltd. (Shriram Group), as an Executive Assistant – Admin, reporting to President (Head of Bioseed business of Shriram Group), SBGI. From 2008 – 2010 Responsible for the following tasks. • Corresponding and coordinating with all departmental heads i.e. Finance, Marketing (Veg. & Field Crops) and officials in H.O., for Collecting and Consolidating the reports, Monthly Business planning, etc. • Arranging meetings, drafting agenda, arranging for meeting essentials, taking minutes of the meeting, circulating MOM among attendees, keeping track on actions taken, etc. • Analyze reports and correspondence and preparing synopsis of the same, making it easier to understand. • Analyze & sending reports on behalf of President to the departmental heads on Budgets and targets achieved, every month. • Drafting and sending approvals, schemes and other policies and keep a track of the same with accounts officials. • Generating and circulating MIS reports to the top management on monthly basis. Independently generated format on excel for analysis. • Travel arrangements. Arranging visits for CMD, VCMD, DMD and other top officials • Keeping update of latest news on agriculture and circulating to the concerned Regional Head and Departmental head. 5. SC Johnson Products Pvt. Ltd., Delhi as an Executive cum Administrative Assistant, reporting to Director Marketing & Sales, from 2007 - 2008 responsible for the following tasks. • • • • • • Working closely with sales team of twelve and responsible for business presentations, data management and MIS reporting relating to sales & marketing department. Sales data analysis, formulate reports and make recommendations. Managing POs Business Analysis pertaining to sales, product lines, market Maintaining art works library, research reports library, cupboard of SCJ products as well as for competitors’ products for ready reference, in-charge of store, stationary, office equipments i.e. fax machine, photocopier machine, etc and for their AMCs. Thoroughly handling customer care process by maintaining liaison between SCJ & outsourced company, distributing weekly and monthly customer care line reports to senior executives, chasing up concerned departments to close customer complaints. Independently handling different vendors and negotiating for the different requirements & equipments of the workplace i.e. Air conditioners, office maintenance, gifts, stationary, etc. 5. JETRO (Japanese External Trade Organization), as a Project Coordinator cum Administrative Asst. reporting to Komuro San, Sr. Consultant - Japan, 2006 – 2007 (Contract job) Responsible for the following tasks. • Maintaining liaison between different departmental heads. • Setting up appointments with GOI and Ministries Officials with the direct officials of JETRO. • Accompany our team in the meetings with GOI officials. • Arranging travels for the expats and also other arrangements for their stay in India i.e. Rented house, electricity, water, local cabs, etc. • Applying Visas to the embassy and work closely with the officials to get the visas done. 6. the Programming and Economic Analysis unit of Asian Development Bank (UN Mission, Delhi) as an Admin & Project Assistant on contractual basis. 2005 – 2006 (Contract job) Responsible for the following tasks. • Performing various secretarial duties i.e. drafting documents and letters as required, making arrangements for tour and travel, hotel booking, coordinating with the different embassies for the issuance of visas, arranging appointments with GOI officers, Maintaining A/c’s records of the reimbursable bills received from the consultants etc. • Handled all research and finance related work i.e. estimation of cost, maintaining budget, maintain petty cash, helping in preparation of project report, collecting economic data from different ministries’ sites. • Segregating, filing and maintaining documents track system. • Maintain clippings of newspapers / magazines articles to track policy reforms & key events relevant from the perspective of ADB operations in India Technical Skills 1. Shorthand : 80 wpm 2. Typing : 85 wpm Signature : Date :