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
Trichy04-2021
B.E - Automobile
Bannari Amman Institute of Technology
Sathy04-2019
Class XII -
Vidya Vikas Matriculation Hr. Sec. School
Tiruchengode04-2015
Class X -
Vidya Vikas Matriculation Hr. Sec. School
Tiruchengode03-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