Summary
Overview
Work History
Education
Skills
Accomplishments
Positions Of Responsibility
Work Availability
Languages
Timeline
Generic
Rakshit Ranjan

Rakshit Ranjan

Business Technology Solutions Associate Consultant
Pune

Summary

Business Technology Associate Consultant with 3+ years of experience in the Pharma domain, specializing in ETL for data warehousing, Tableau for reporting, and Master Data Management. Skilled in leveraging Big Data tools to develop management consulting solutions, with a strong emphasis on leading requirement gathering sessions. Adept at translating complex data into actionable insights that drive strategic decision-making and operational efficiency.

Overview

6
6
years of professional experience
7
7
years of post-secondary education

Work History

Business Technology Solutions Associate Consultant

ZS Associates
07.2023 - Current
  • Led the implementation and integration of a Master Data Management (MDM) system for a healthcare provider network to centralize and maintain high- quality, consistent, and accurate master data across multiple systems and platforms. The project aimed to ensure a single, unified view of master records related to healthcare professionals, facilities, and customers
  • Involved in requirement gathering and analysis designed to onboard 3 new clients. Developed foundational and aggregate layer for data warehouse using ETL process and making insightful Tableau dashboard.
  • Data Profiling for various pharma companies’ vendor data to create a pipeline for various operational processes cutting data analysis time by 30%.
  • Data Profiling for various pharma companies’ vendor data to create a pipeline for various operational processes cutting data analysis time by 30%.
  • Facilitating client calls to ensure clear requirement gathering and foster strong client relationships. Managed a team of 8 members to ensure prompt delivery of ad- hoc/enhancement requests and daily operations.

Business Technology Solutions Associate

ZS Associate
08.2021 - 07.2023
  • Worked as a Tableau Lead for the Reporting team. Onboarded 4 new Associates and interns to have a better understanding of the tech stack and Pharma domain.
  • Working as a Tableau Lead for the Reporting team
  • Created 35+ data models for the dashboards and reporting team which helped the client to track the performance of a newly launched Peds drug.
  • Created a Group Security Model in the Tableau Dashboard for Partial and Full Access.

Digital Research Consultant

ICICI Securities
05.2019 - 07.2019
  • Company Overview: India's Leading Stock Broker
  • Part of Digital Team which performed End-to-End analysis of the Customer Onboarding process and digitized the entire onboarding process increasing customer satisfaction by over 42%.

Education

Graduation -

Indian Institute of Information Technology
08.2017 - Current

Skills

SQL

Accomplishments

  • Integrated Analytics Outstanding Contribution 2024 Q4
  • Integrated Analytics Outstanding Contribution 2023 Q3
  • Secured 1st Position at Sympulse, Symbiosis Quiz.
  • Secured 1st Position at the MELA Quiz in iConclave 2020.

Positions Of Responsibility

  • Cultural Secretary of IIIT Pune, Responsible for the smooth conduct of many Social and Annual Gatherings like Cest La Vie, the fest of IIIT Pune.
  • Founder and Head of Quizzing Society of IIIT Pune (QRioCity), Organized and hosted various inter-college Quiz Competitions with a footfall of over 500.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Languages

English
Advanced (C1)
Hindi
Advanced (C1)

Timeline

Business Technology Solutions Associate Consultant

ZS Associates
07.2023 - Current

Business Technology Solutions Associate

ZS Associate
08.2021 - 07.2023

Digital Research Consultant

ICICI Securities
05.2019 - 07.2019

Graduation -

Indian Institute of Information Technology
08.2017 - Current

Similar Profiles

CREATE PROFILE
Rakshit RanjanBusiness Technology Solutions Associate Consultant