Summary
Overview
Work History
Education
Skills
Certification
Extracurricular Activities
Timeline
Generic

Rosan Kumar Swain

Summary

A dynamic, organized and results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive individual willing to fully render efforts in making significant contributions to fuel the growth and success of the organization.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Associate Analyst

Global Data Research Center Pvt. Ltd.
03.2024 - Current
  • Working with the Healthcare & Pharmaceutical division to understand project essentials and provide solutions promptly.
  • Streamlined advanced Excel functions to automate data entry, analysis, and reporting processes, boosting efficiency by 29%.
  • Engineered and maintained dynamic dashboards to visualize key performance indicators (KPIs) and project metrics, enhancing project tracking accuracy by 25%, impacting over 11 ongoing projects.
  • Executed data validation and cleaning using Excel to ensure 99% accuracy and reliability of reports, managing datasets of up to 100,000 entries.

Market Research Intern

Global Data Research Center Pvt. Ltd.
05.2022 - 09.2022
  • Worked with the Construction Division and conducted extensive secondary research, gathered data, and produced detailed reports daily, totaling over 200 reports during the internship.
  • Generated detailed reports and summaries that supported decision-making processes, reducing project turnaround time by 20%.

Campus Ambassador

National Engineering Olympiad Foundation
03.2022 - 04.2022
  • Generated approximately 500 positive clicks and impressions across various social media platforms throughout the campaign of one month.
  • Managed and created content for the social media channels, leading to an increase in followers and engagement by 25%.

Education

Master's Degree in Business Administration - Marketing & Information Technology

Indian Institute For Production Management
Kansbahal
08.2023

Bachelor of Commerce -

Ravenshaw University
Cuttack
11.2020

Skills

  • Advanced Microsoft Excel: Proficient in data analysis, pivot tables, VLOOKUP, and advanced formulas for reporting purposes
  • Report Preparation: Experienced in creating comprehensive reports using Excel to present data insights and trends
  • Business Communication
  • Proficient in Advanced Document Formatting: Skilled in creating and formatting complex documents, including the use of styles, headers, footers, and tables of contents, ensuring professional and consistent document presentation

Certification

  • IAB Digital Marketing from Google Digital Unlocked
  • MS Excel, Power BI from Talentele Learning
  • Certified as a First Aider by the National Safety Council, Government of India

Extracurricular Activities

Represented my school in various interschool tournaments of Cricket. Core team member of various student-run events. I enjoy reading and learning about various sub-cultures.

Timeline

Associate Analyst

Global Data Research Center Pvt. Ltd.
03.2024 - Current

Market Research Intern

Global Data Research Center Pvt. Ltd.
05.2022 - 09.2022

Campus Ambassador

National Engineering Olympiad Foundation
03.2022 - 04.2022

Master's Degree in Business Administration - Marketing & Information Technology

Indian Institute For Production Management

Bachelor of Commerce -

Ravenshaw University
  • IAB Digital Marketing from Google Digital Unlocked
  • MS Excel, Power BI from Talentele Learning
  • Certified as a First Aider by the National Safety Council, Government of India
Rosan Kumar Swain