Rohan Kumar Gupta Email & Phone Number

Bengaluru, Karnataka, India

Data Governance & Analytics in Corporate and Investment Banking

Kolkata, West Bengal, India

Part of the Business Strategy Team/Technology Leadership GroupHighlights- Facilitated transition from Ex-works to FOR billing. Spearheaded analytical due-diligence of baselining P&L scenarios, aiding management decisions. Projected savings of ₹5 Crores within the next 12 months.- Created Excel macro based 1-click tool to provide communication to 70+ existing customers about 4000 SKU-price combinations.- Standardized MIS reports of the whole organization for monthly review by the CEO. Coordinated with functional heads to capture important data points in paper manufacturing processes. - Developed dashboards, carried out trend analysis to detect inconsistencies in operations.

Kolkata, West Bengal, India

Department of Sports

Mumbai, Maharashtra, India

Highlights- Enriched data for 8000 prospects within 3 weeks, 10 days before the stipulated time.- Automated the manual process of gathering data points for B2B leads using external tools with no additional costs.

Kolkata, West Bengal, India

Following a 6-month internship as a BI Analyst, Rohan was promoted to a full time role as a Management Trainee in Business Intelligence. In this new role, he assumed leadership responsibilities and successfully completed major projects.Highlights- Provided extensive mentorship and training to interns and new joiners.- Championed the migration of the BI team from Excel to Power BI, implemented data governance, real-time reporting, and self-service analytics for the stakeholders, reducing our team's workload by 70%. - Led and successfully delivered a major data integration project, combining 4 databases of different formats (SQL and NoSQL) into 1 data warehouse.- Collaborated and co-developed 60+ reports and dashboards in Power BI.- Conducted multiple training sessions for the BI team covering techniques on data modeling, advanced data transformation and automation.

Kolkata, West Bengal, India

Highlights- Developed reports, increased visibility and quantified effectiveness of various offline marketing activities like health camps, hoardings, door to door campaigns as well as digital marketing efforts like Google Search Ads, Keyword Analysis and Facebook B2C campaigns.- Developed and automated processes to audit customer calls across 5 sub-departments thereby increasing the efficiency of Quality Analysts by 200%.- Contributed to ‘Marketing Ambassador Project’, a mass door to door marketing campaign in its early stage, successfully creating more than 17000 customers in a span of 12 months.- Created and managed an interactive SOP dashboard for the Customer Service team currently being used by 50+ executives.- Conducted company wide Advanced Excel and Google Sheet training sessions attended by more than 80 employees across departments in both online and offline mode.- Prepared various MIS and ad-hoc reports covering business processes across multiple domains including Customer Service, Franchise Management, SCM and Marketing.

Kolkata, West Bengal, India

Activities:- Conducted Workshop classes offline three days a week.- Helped and encouraged students of different age groups in public speaking.- Evaluated performance of students and provided feedback.

Bachelor Of Commerce - Bcom, Accounting And Finance, First Class - 75%

Activities and Societies: Department of Sports

Higher Secondary (+2), Commerce With Mathematics, A+ (Among Top 10)

WBCHSE

Secondary (10), High School/Secondary Diplomas And Certificates, A+ (Among Top 3)

WBBSE