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
