Mohit Rathod Email & Phone Number

Dublin, County Dublin, Ireland

Marketing Expertise: Analyzing marketing data with a deep understanding of media campaigns, social marketing, paid search, offline and programmatic strategies. Experience in building detailed reports for these channels to help inform strategic decisions.Client Service Excellence: Prioritizing client service, ensuring clients' challenges and needs are understood and addressed. Utilizing communication and presentation skills to engage with clients, understand their business requirements, and present tailored solutions.Dashboard Design & Data Visualization: Creating clear, intuitive dashboards and reports, presenting data concisely and impactfully. Utilizing tools such as Adverity, Excel, PowerBI, and R shiny to build customized visualizations.Data Scripting & Analysis: Proficient in Microsoft Excel, using advanced formulas. Developing programming skills in R, Python and SQL to manipulate data structures, write queries, and design data tables, enhancing analytical capabilities.Data Pipeline Implementation: Onboarding new clients to the standard reporting suite by consulting with client teams, structuring reports, enabling data feeds, applying transformations, and activating dashboards. Developing customized dashboards to meet specific client needs.Operational Management: Monitoring live data feeds and dashboards for production issues, responding to service desk queries, and managing change requests. Analyzing and troubleshooting issues to ensure seamless operations as experience grows.

Dublin, County Dublin, Ireland

Assist in generating revenue for Trinity through retail, accommodation, the Book of Kells, conferences and events

Dublin, County Dublin, Ireland

Pune, Maharashtra, India

Predictive Models: Built a statistical model to forecast campaign efficiency based on budget and clicks, accounting for Brand/Non-Brand differentiation, multiple channels, and various data types, achieving 82% accuracy.Data Analysis Processes: Maintained and updated procedures for generating marketing insights, enhancing strategy effectiveness.Ad Hoc Analysis: Provided on-demand analysis to support marketing expenditure decisions, proposition planning, and execution.Automated Data Processing: Developed R scripts to clean and standardize datasets, reducing manual processing time by 3 hours and optimizing scalability.Executive Reporting: Delivered high-level reports for quarterly budget planning and allocation.Team Collaboration: Assisted in designing a campaign health dashboard with data ingestion via GCP, ETL processes, and dashboard presentation, providing WoW, MoM, and YoY comparisons.Data Integration: Managed multiple data sources to generate reliable data and metrics for analysis.

Pune, Maharashtra, India

Volunteered at National Service Scheme in group activities such as educating underprivileged kids, farming, trekking, play-act and yoga-sessions.Volunteered for 3 years at Police Friend Service to control traffic and crowd during Indian festivals at high density areas.

Master'S Degree, Business Analytics

Activities and Societies: Class Representative of Business Analytics batch 2021-2022. Committee member of Trinity College International.

Master Of Science - Ms, Statistics

Activities and Societies: Participated in conferences, cultural events and sports.Intensiveprogramprovidededucationinsolidtheoreticalandapp.

Bachelor Of Science - Bs, Statistics

Activities and Societies: I was highly active in Statistical conferences and festival called Statistika where Statistics oriented games.