Chirag Varshnay

CHIRAG VARSHNAY DOB: 7/11/1995 | E-mail:-| Phone:- Address: H. No. 22, Street No. 2, Radheypuri Ext.-2, NEW DELHI – 110051 WORK EXPERIENCE Wealth Clinic Private Limited Designation  Assistant Manager – Process Development Duration Feb, 2018- Till Date WORK DONE –  G SUITE & ZOHO ADMINISTRATOR  Responsible for end to end implementation of ZOHO - CRM, Motivator, People & Recruit for Leads, Operation & HR Department  Created operational processes using Google Forms, Google Sheets and Google Drive  Developed google scripts for automating the regular operation work in Google Sheets  Data management and reporting using Google Sheets and Google Data Studio  Develop consistency across reports and develop meaningful dashboards and publish them  Performs testing, reconciliation and ad-hoc issue resolution for report creation, design and deployment  Ascertained process bottlenecks and built new solutions accordingly  Preparation of MIS Reports relating to sales, operation and finances.  Generate and distribute management reports in accurate and timely manner, Provide recommendations to update current MIS to improve reporting efficiency and consistency.  Perform data analysis for generating reports on periodic basis.  Provide strong reporting and analytical information support to management team.  Analyze business information to identify process improvements for increasing business efficiency and effectiveness Quality Council of India (Ministry of Commerce and Industries) Member of the Chairman's Office at QCI. QCI is an autonomous organization set up by the Ministry of Commerce, FICCI and CII and is led by Adil Zainulbhai, the former Chairman of McKinsey India. Designation Duration  Analyst - MIS Oct, 2016- Oct, 2017 WORK DONE –  Wrote a Macro-enabled workbook in MS Excel that reduced user error and time spent completing the operations work by over 50 percent and Created macros used to simplify routine tasks for end users  Performed analysis and presented results using SQL, MS Access and MS Excel  Analytical Excel Modeling - Analysis of Swacchh Bharat Mission Gujrat Grameen Gram Panchayat ODF data segmented at geography demographics and ULB level.  Created Excel database designs for easy understanding of complex data and formulating of final inspection reports  Multi-Purpose Data Analysis to find the scope of improvement in different processes  Created training manuals and conducted training sessions for assessors pan India  Automation of important business metrics at Daily, Weekly and Monthly level to be presented to client  Automation of Compliance with mandatory and scoring parameters for advising affiliation recommendations of ITIs to NCVT  Designed automated reports using various functions and tools in MS Office for improving work efficiency in Operations  MIS Reporting SKILL SET Google Suite & Zoho Administrator Microsoft Office - Advanced Level Excel, Access, Power Point and Word SAS (Basics) – Accessing and Managing data, Basic Analysis MySQL (Basics) – Accessing and Managing data, Inner Join, Left Join, Right Join, Full Outer Join Python Programming (Basics) – NumPy, Matplotlib EDUCATION QUALIFICATIONS Course (Stream)/Examination Institution/University Year of Passing Performance B.COM (HONS.) DYAL SINGH COLLEGE(UNIVERSITY OF DELHI) 2016 77.33% 12TH NIRMAL DEEP SCHOOL, RISHIKESH NIRMAL DEEP SCHOOL, RISHIKESH 2013 77% 2011 72% - COMMERCE 10TH REFRENCES References are available on request