Default profile banner
KV

Kumar Varunav

@kumarvarunav

Subject Matter Expert at ZS Associates

New Delhi

ZS AssociatesChandigarh University

Kumar Varunav is a result-oriented professional with experience in data operations and business technology solutions at ZS Associates. He is proficient in SQL, Python, and AWS technologies (S3, EC2, Redshift), having managed data ingestion, cleaning, and complex data extraction. He also possesses skills in Java and Big Data technologies, demonstrated through projects like sentiment analysis and centralized event scheduling.

Experience

Subject Matter Expert

ZS Associates

•Jul 2020 - Present•New Delhi

Responsible for accomplishing and timely deliverables of the data ingestion using AWS technologies (S3, EC2, Redshift) into the AWS Redshift data warehouse. The process includes data cleaning, data pre-processing, and the data migration on AWS S3 bucket project using Python scripts. Responsible for preparing the TIBCO Spotfire dashboard for all the data ingested in the data warehouse according to the requirements of the users by performing SQL queries. Responsible for preparing the data extracts and data cut using AWS Redshift and SQL queries by writing complex SQL queries and performed QC on extracted data to ensure the quality of data. Responsible for scheduled and timely delivery of the external partnership support to the clients ensuring the quality and proper communication.

Business Technology Solution Associate

ZS Associates

•Jan 2020 - Jun 2020•New Delhi

Education

Chandigarh University

B. Tech (IT)

IT

Jan 2012 - Jan 2020•Grade: 80.9%

CPRF Public School

12th Standard

CBSE

Jan 2016•Grade: 88.2%

CPRF Public School

10th Standard

CBSE

Jan 2014•Grade: 85.5%

Licenses & Certifications

IT Automation using Python professional certification

Google (Coursera)

• No expiration

Skills

SQL
C++
Python
Java
UNIX
Big Data Technologies
Microsoft Excel
AWS (S3, EC2, Redshift)
TIBCO Spotfire
Hadoop
MapReduce
Pig
Sqoop