Conducted backend logic and code development for the Targeting Dashboard, focusing on the Infusion Business
Identified actual market size and leakage within the Optum Business
Led Root Cause Analysis (RCA) to identify territories for extensive targeting by Sales Representatives
Formulated winback strategy based on CPR+ data and third-party data (Lexis Nexus and Symphony), optimizing customer retention
Utilized Tableau to create visualization dashboards, both from scratch and on an ad hoc basis.
Analyst
iQuanti
06.2021 - 06.2022
Utilized data-driven solutions to track, analyze, and monitor campaign-generated traffic for Banking and Financial Sector clients
Prepared MOM and YOY analysis reports using Business Intelligence Tools, delivering valuable insights to clients
Developed integrated data channels and ETL tools to consolidate information into Snowflake for streamlined data management.
Business Analyst-Intern
HomeLane
11.2020 - 06.2021
Conducted in-depth data analysis and KPI monitoring to support daily operations
Collaborated with cross-functional project teams to implement data-driven strategies and track progress
Designed and developed tailored dashboards on Metabase and Tableau to support Consulting Team's requirements.
Education
Bachelor of Technology (B.Tech.) -
NIT- Hamirpur
06-2021
12th Class
01-2016
Skills
SQL
TABLEAU
PYTHON
ETL
AZURE
DATABRICKS
STATISTICAL ANALYSIS
FINANCIAL MARKET ANALYSIS
Custom
PRESIDENT-TECHNICAL ACTIVITIES, NIMBUS, Led the strategic planning and execution of various Technical Programs and events within the institute, ensuring seamless coordination and successful outcomes., Spearheaded the organization of Nimbus 2021, the flagship Technical Fest, overseeing all aspects from conceptualization to implementation, fostering a vibrant and engaging environment for participants.
TRAINING AND PLACEMENT COORDINATOR, 2020, 2021, NITH, Played a pivotal role in bridging the gap between students and prospective employers by actively facilitating recruitment processes for both Full-Time positions and Internship opportunities., Established and nurtured relationships with corporate entities, organizing recruitment drives and placement events to enhance career prospects for students.
MANAGING EDITOR, 2017, 2021, SRIJAN, Held a multifaceted role in overseeing the publication process of the college magazine and newsletters, ensuring high-quality content and timely distribution., Additionally, orchestrated various events such as OPEN-MIC sessions and debates, fostering a culture of intellectual exchange and creative expression within the college community.