Summary
Overview
Work History
Education
Skills
Certification
Projects
Languages
Timeline
Generic
Mohan Raj D R

Mohan Raj D R

Bengaluru

Summary

Results-driven Data Analyst with a proven track record at Cognizant Technology Solutions, enhancing reporting efficiency and achieving a 15-20% ROI increase. Proficient in SQL and data visualization, I excel in cross-functional teamwork, delivering actionable insights that optimize operations and drive growth.

Overview

5
5
years of professional experience
1
1
Certification

Work History

MIS / WFM / Data Analyst

Cognizant Technology Solutions
06.2022 - Current
  • Delivered analytics and reporting solutions across Amazon Ads, Microsoft Nuance, and Google Cloud VMO, driving improvements in reporting efficiency, forecast accuracy, and operational productivity.
  • Delivered actionable insights through performance reviews and ad-hoc analysis, managing campaign pacing and budget utilization with Amazon Ads Console and DSP to achieve a 15-20% increase in ROI and a 12% improvement in ROAS.
  • Automated dashboards and reports using Excel, SQL, and Power BI, streamlining decision-making across campaign and workforce operations for multiple projects.
  • Forecasted chat volumes and workloads using historical data and advanced methodologies, optimizing staffing levels and reducing overtime costs by 20-25%.
  • Partnered with Finance, Operations, Strat-Ops, Vendor Consultants, and quality teams to support P&L reviews, Max Cap planning, Billing discussions, & Risk and Compliance reviews across multiple projects.
  • Supported the end-to-end Salesforce migration of Amazon Seller and Vendor accounts, ensuring seamless data transition, system integrity, and improved account management efficiency across sales and operations teams.
  • Identified onboarding anomalies and performed root cause analysis for Google VMO.

Preferred Relationship Manager

HDFC Bank Ltd.
09.2021 - 03.2022
  • Managing a portfolio of 224 HNW customers with a book size of 750 million INR and bringing 12 NTB (new to base) HNW clients to the portfolio with a value of 26.8 million INR.
  • Generated 181 million INR in revenue and 16.5 million INR in income by increasing retail asset business about 310% through maintaining effective business relationships with all key stakeholders.
  • Identified and networked with prospective clients while generating business from existing accounts, achieving profitability and increased sales.
  • Developed business strategies to align with bank objectives and drive growth.
  • Analyzed business potential, conceptualized and executed strategies to drive sales and meet targets for sales and banking services.

Education

MBA - Marketing

Bharathidasan Institute of Management
Trichy
04-2021

B.E - Automobile

Bannari Amman Institute of Technology
Sathy
04-2019

Class XII -

Vidya Vikas Matriculation Hr. Sec. School
Tiruchengode
04-2015

Class X -

Vidya Vikas Matriculation Hr. Sec. School
Tiruchengode
03-2013

Skills

  • Data analysis
  • Data visualization
  • SQL
  • Google Sheets
  • Excel
  • Excel VBA
  • Power BI
  • Tableau
  • Data governance
  • Analytical skills
  • Cross-functional teamwork

Certification

  • Certified by the Insurance Regulatory and Development Authority (IRDA), 05/21.
  • Lean Six Sigma Green Belt certified by the Karl Pearson Institute, 05/20.
  • Udemy certified in 'Python Programming' and 'SQL.'
  • Certified B1 in Business English Entry Level Certificate in ESOL International awarded by Cambridge English, 05/17.

Projects

  • Research project to identify Brand activation of FMCG sector, The study focused on identifying brand activation strategies and its role in driving consumer engagement and awareness for 5 FMCG products.
  • Brand Analysis of HDFC Bank, Analyzing appropriateness of the brand name, positioning statements, pricing and distribution strategies, challenges faced, IMC and came up with suggestions.
  • DMAIC six sigma improvement framework for Avidco Asia Pacific, The objective of the study was to draft a project charter which aligns the project with the organization's goals and maximize the timeliness of responses to the client's RFP.
  • Sustainable and bankable business plan in Erode district, To improve life of Banana growers by coordinating with CFTRI & other district government organizations.

Languages

English
Proficient (C2)
C2
Tamil
Native
Native
Telugu
Advanced (C1)
C1
German
Beginner (A1)
A1

Timeline

MIS / WFM / Data Analyst

Cognizant Technology Solutions
06.2022 - Current

Preferred Relationship Manager

HDFC Bank Ltd.
09.2021 - 03.2022

MBA - Marketing

Bharathidasan Institute of Management

B.E - Automobile

Bannari Amman Institute of Technology

Class XII -

Vidya Vikas Matriculation Hr. Sec. School

Class X -

Vidya Vikas Matriculation Hr. Sec. School
Mohan Raj D R