Ratnesh Kumar Roy

Data-Driven Marketing Insights & Optimization:

• Collected and managed diverse datasets from web analytics, social media, CRM, marketing automation, and surveys.
• Ensured data quality and consistency through rigorous cleaning and preparation. Reduced data cleaning time by 40% through automated processes.
• Increased data accuracy by 30% through rigorous data validation and cleaning.
• Leveraged statistical analysis to uncover trends, patterns, and correlations within marketing data.
• Created compelling visualizations to communicate actionable insights to stakeholders.
• Identified and analyzed distinct customer segments to tailor marketing efforts effectively.
• Measured marketing channel effectiveness using attribution modeling and ROI analysis.
• Developed data-driven recommendations to optimize campaigns and drive business growth. Optimized 15 marketing campaigns in a short period based on data-driven insight.
• Provided strategic guidance to marketing teams through regular reporting and presentations.

Requirement Gathering & Dashboard Development:

• Led stakeholder collaboration to define and deliver impactful data visualizations.
• Built interactive dashboards in Tableau and Power BI to provide actionable insights.
• Integrated data sources from Google BigQuery for comprehensive web analytics.
• Managed full development lifecycle from analysis to implementation and support.

Data Visualization & Business Intelligence:

• Created compelling visualizations to showcase department spend and earnings trends.
• Developed comprehensive Tableau dashboard suite for responsible gambling tracking, earning recognition as Performer of the Quarter.

Data Blending & Security:

• Mastered data blending and cross-database joins to create robust Tableau workbooks.
• Optimized data performance through SQL script design, indexing, and query optimization.
• Provided expert troubleshooting for end-user reporting issues.

• Mentored junior analysts, fostering professional development while enhancing overall team performance.

Dashboard Development & Deployment:

• Created interactive dashboards in Tableau Desktop to provide actionable insights.
• Integrated Tableau Server with SharePoint to enable seamless data sharing and automated updates.
• Managed full development lifecycle from analysis to implementation and support.
• Implemented robust data security using row-level security and user filters to restrict access.
• Leveraged data blending to combine data from multiple sources for comprehensive analysis.

Data Analysis & Visualization:

• Developed custom KPIs using calculated key figures and parameters to provide tailored insights.
• Mastered advanced Tableau features including analysis actions, calculations, parameters, background images, maps, trend lines, and table calculations.
• Leveraged custom SQL queries to integrate data from various sources and meet specific business needs.

ETL & Data Engineering:

• Solely responsible for designing, developing, testing, and deploying reporting and ETL jobs.
• Built complex ETL pipelines using Talend to integrate data from diverse sources, including databases, Excel, and web sources.
• Created optimized stored procedures in SQL Server and PostgreSQL to handle complex queries and data transformations.