Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

GULSHAN RAWAT

New Delhi

Summary

Accomplished Senior Content Analyst with extensive experience at Magicpin, specializing in data analytics and process optimization. Demonstrated proficiency in Power BI and Python to elevate content relevance and streamline operational efficiency. Proven ability to drive cross-functional collaboration and tackle complex problems, resulting in enhanced content analysis and improved workflows.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Content Analyst

Magicpin
Gurgaon
05.2022 - Current
  • Analyze and evaluate various types of content, ensuring accuracy, relevance, and compliance with established guidelines.
  • Collaboration with cross-functional teams to identify content gaps and implement strategies for improvement.
  • Utilize my expertise in data analytics to extract, manipulate, and analyze large datasets, enabling comprehensive content analysis.
  • Responsible for creating visualizations using Microsoft Power BI and Google Looker Studio.

Quality Specialist

Amazon
Hyderabad
08.2019 - 06.2021
  • Responsible for assessing and evaluating operational processes and procedures to identify areas for improvement in case management and delivery efficiency.
  • Utilizing my keen analytical skills, I conducted comprehensive audits, identifying bottlenecks, inefficiencies, and potential risks.
  • With a focus on accuracy, compliance, and continuous improvement, I played a key role in ensuring timely and efficient case handling and delivery.

Education

B.TECH -

IMS Engineering College
Ghaziabad
01.2019

10+2 -

Mayur Public School
New Delhi
01.2015

Skills

  • Data Analysis & Visualization: MS Excel, Power BI, Looker Studio, Google BigQuery
  • Automation & Development: UiPath, Postman API, ChatGPT, Python
  • Database Management: MySQL, Google BigQuery

Accomplishments

  • Created a visually interactive sales data dashboard in Microsoft Power BI for Omnify to manage their SEO results
  • Developed an interactive sales report for a client, analyzing sales across different regions, and timeframes
  • Prepared a Covid data dashboard until March 2022 to analyze the confirmed, cured, and deaths in India until March 2022
  • Developed and implemented a robotic process automation (RPA) solution using UiPath to streamline the extraction of outlet details from Zomato links for merchant creation in an app
  • Automated the extraction and uploading of CSV files containing merchant information into the database using UiPath
  • I built a robot called 'Travel Buddy' to retrieve flight ticket details via MakeMyTrip

Certification

  • The Complete Python Program (Udemy)
  • Querying Microsoft SQL Server (Udemy)
  • Microsoft Power BI Desktop for Business Intelligence (Udemy)
  • UiPath Test Automation (Udemy)
  • Microsoft Excel program (Udemy)

Timeline

Senior Content Analyst

Magicpin
05.2022 - Current

Quality Specialist

Amazon
08.2019 - 06.2021

B.TECH -

IMS Engineering College

10+2 -

Mayur Public School
GULSHAN RAWAT