Ajay Madaan Email & Phone Number

Dublin, County Dublin, Ireland

Dublin, County Dublin, Ireland

Dublin, County Dublin, Ireland

Bangalore

Headed several intensive projects leveraging data to help make effective marketing strategies for multiple Brands, Companies and Celebrities.• Strategizing & Creating Research Reports: Understanding the end Goals and aligning the reports end to end with their use case. Co-ordinating with Sales & Pre-Sales Team for Client requirements & deliverables.• Internal Projects: Developed a custom model to analyze online user behavior and find clusters based on their Social Interests. Analyzed & processed complex datasets (up to 8 million rows) using advanced querying from MongoDB & visualizations using Python. Social Media Research reports on multiple Industries e.g., topic extraction from text data relevant to Brands/Personalities captured from Facebook and Twitter mainly.• Automating Regular Tasks with Python: Various weekly/monthly reports & analysis, saving team’s time and increasing efficiency. Handling large data to perform various analysis for reports, faster than Excel.

Noida Area, India

•. Created custom Reports & Dashboards in Excel with data from MySQL database for Marketing (measuring campaign effectiveness), Sales (Regional head wise sales figures) & Content Teams (content completion and recency metrics).•. Understood database business fundamentals to write efficient SQL queries for frequently requested reports, minimised creation time to a few mins while also democratising data reporting across teams.•. Nominated Twice for Kickstarter & Kaizen Awards at Monthly Rewards & Recognition event.

Gurgaon, India

Wrote Car Spec comparisons for ASEAN region

Gurgaon, India

Worked on catalogs from Manufacturing SMEs to onboard them to the platform SMEShops

Bhatinda Area, India

Studied production processes of Oil, Naphtha & Sulphur in refinery and assisted in lab testing of crude oil distillation products from multiple units.