CURRICULUM VITAE
Sanchit Gupta
K-** *rd floor Jagat Ram Park Laxmi Nagar
New Delhi – 110092
***************@*****.***
Mobile No. 91+997*******
CAREER OBJECTIVE
To seek a challenging position in an organization that provides me with an opportunity to pursue career in the field of analytics and global exposure to excel in my work so as to make a contribution towards the growth of the organization.
ACEDAMIC QUALIFICATION:-
B.Com. Pass from Shobhit University
12th pass C.B.S.E. From Delhi
10th pass C.B.S.E. From Delhi
TRAININGS
Course on Data Science using R Programming from Analytics Lab (Gurugram) and having basic knowledge of SQL as well.
Selecting Rows & Columns
Selecting Rows by using filter
Changing Column names
Changing data types of variable
Adding & Deleting Columns
Deleting Duplicates Rows
Identify missing values
Deleting missing values
Imputing missing values by using mean score
Merging & Appending data frames
Group by and Summarise function
Transpose data by using reshape2 package
WORK EXPERIENCE:-
1-Jan 2017 – Jun 2020
Project Consultant (Business Operation)
Kantar IMRB India Pvt. Ltd (Kantar Group)
Job profile
Creating different type of template & Chart such as Colum Chart, Line Chart, Pie Chart, Bar Chart, Scatter Chart, Radar Chart in Excel and PowerPoint .
Key Responsibilities
Preparing independently monthly, quarterly & annually report of tracking Studies on Excel and Power Point.
Data validation: Data is validated /sig testing/logical checks on data before the final analysis with actual database given by the client
Create customized reports using vlookup, Hlookup, Sumif, Average, Sum & pivot table
Assisting and supporting Researchers for research projects and analysis in daily operations .
Help Researcher in making client deliverable such as Presentations, Reports & Dashboards
Prepare Analysis Plan & Field Material and share with concerned teams
Briefing to PM team and data processing teams with requirements.
2-Oct 2015 - Dec 2016
Senior Process Executive
GFK Mode Market Research Services India Pvt. Ltd
Key Responsibilities
Processing and providing operational support to research in the areas of charting & reporting, questionnaire formatting, data analysis .
Prepare Analysis Plan & Field Material and share with concerned teams
Briefing to PM team and data processing teams with requirements.
Coordinate & follow up field work status with PM team and inform to Reporting Manager.
Create customized reports using vlookup, filters & pivot table.
3-Mar 2013 - Oct 2015
Charting Executive
Millward Brown Market Research Services India Pvt. Ltd (Kantar Group)
Job profile
Creating different type of template & Chart such as Colum Chart, Line Chart, Pie Chart, Bar Chart, Area chart, Scatter Chart, Bubble Chart, Radar Chart in PowerPoint .
Key Responsibilities
Assisting and supporting Researchers for research projects and analysis in daily operations .
Help Researcher in making client deliverable such as Presentations, Reports & Dashboards
Preparing presentation with help of MS office, images and applying dynamic content like as animation etc.
Prepared charts and graphs for research.
Assist and solve charting problems for team.
Formatting of questionnaire, making show cards, brand cards, column coding, sig testing.
Exclusively worked for Marketing Science team in designing & creating Path Models and help in basic analysis, also provide training to Delhi charting team on creating Path Models
4-Dec 2011 - Jan 2013
Charting Executive (Freelancing)
IPSOS RESEARCH INDIA PVT LTD
Job profile
Prepare report in Excel
Prepared PowerPoint presentations for research team.
Prepare deliverables such as reports and client presentations.
Key Responsibilities
Preparing presentation with help of MS office, images and applying dynamic content like as animation etc.
According to client requirement we analysis data in excel and represent in requested format.
Preparing independently monthly, quarterly & annually report of tracking Studies including any extra analysis requirement.
Work in teams, with deadlines and contribute to team-building efforts.
5-Sep 2010 - Dec 2011
Freelance Interviewer
IPSOS RESEARCH INDIA PVT LTD
Job profile
Quality check, Calling, Inhalling and Data Punching as per Research Requirement.
STRENGTH:-
Quick learner
Ready to take responsibilities
Personal Details
Date of Birth : 15th September 1989
Marital Status : Unmarried
Language : English & Hindi
Interest/Hobbies : Travelling, Playing Cricket, Watching Wrestling
Sanchit Gupta