Summary
Overview
Work History
Education
Skills
Certification
Awards
Languages
Timeline
Generic

WASIM SHAIKH

Mumbai

Summary

Results-driven Senior Associate at IPG Mediabrands India, skilled in Python and VBA programming. Achieved a 60% reduction in reporting time through automation and developed impactful Tableau dashboards that enhanced decision-making. Adept at data analysis and fostering collaboration across teams, ensuring consistent and accurate analytics.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Senior Associate

IPG Mediabrands India Private Ltd
Mumbai
12.2022 - Current
  • Collaborated with business units to gather requirements, translate them into analytical solutions, and deliver self-service BI tools.
  • Developed interactive dashboards in Tableau to visualize charts, KPIs, trends, and business performance, improving stakeholder decision-making.
  • Automated recurring reports using Python, VBA, and SQL, reducing manual reporting time by over 60%.
  • Standardized data models and reporting logic, resulting in consistent analytics across teams, and reduced reporting errors.
  • Automated repetitive tasks in Excel using VBA macros significantly reduce manual effort and improve accuracy across reporting processes.
  • Developed complex VBA-based tools for data transformation, validation, and formatting, enhancing productivity for finance and operations teams.

Analytical Tool Executive

NielsenIQ
Mumbai
02.2016 - 11.2022
  • Developed advanced Excel reporting solutions, integrating Pivot Tables, Charts, and formulas, to deliver interactive, client-ready reports.
  • Automated reporting workflows using VBA macros reduce manual processing time by 30–50% and improve data accuracy.
  • Created reusable VBA modules for repetitive tasks, such as data import/export, Pivot Table creation, and chart automation.
  • Developed custom VBA automation tools in Excel and Access to streamline reporting, reduce manual effort, and improve data accuracy.

Analyst

Tech Mahindra
Mumbai
06.2015 - 02.2016
  • Engineered robust error-handling routines and modularized VBA code for maintainability and scalability in legacy systems.
  • Migrated legacy manual spreadsheets to automated VBA-driven systems, reducing processing time by up to 70%.
  • Leveraged advanced Excel functions (INDEX-MATCH, SUMPRODUCT, array formulas) combined with VBA to build high-performance calculators and models.
  • Recognized with performance awards for creating high-impact Excel tools that improved business operations and client satisfaction.
  • Created custom Excel dashboards integrated with SQL Server for real-time KPI monitoring and ad hoc business analysis.
  • Developed and maintained ETL pipelines using SQL Server Integration Services (SSIS) and Data Transformation Services (DTS) to extract, transform, and load large datasets from multiple sources.
  • Utilized SQL Server Reporting Services (SSRS) for building parameterized reports, enabling dynamic user-driven analytics.

Senior Team Member

BA Continuum India Pvt Ltd
Mumbai
05.2008 - 06.2015
  • Automated task to extract data on Excel from Oracle (Toad) and SQL Server 2008.
  • Liaised with various groups to automate daily tasks on Excel and Access using VBA (Macro).
  • Received Bronze Award for reducing the overall time taken by 15 minutes in preparing the report.
  • Automated end-to-end reporting workflows in Excel with VBA, including dynamic pivot tables, charts, and scheduled data refreshes.
  • Facilitated the automation of daily tasks utilizing Excel and Access with VBA macros.
  • Streamlined data extraction processes from Oracle and SQL Server 2008 into Excel.
  • Achieved a Bronze Award for decreasing report preparation time by 15 minutes.

Customer Service Executive

Reliance Infostream Pvt Ltd
Navi Mumbai
08.2006 - 12.2007
  • Activated new handset and landline services for customers.
  • Communicated new recharge options and handset promotions to Reliance Prepaid users.
  • Addressed and resolved customer inquiries regarding mobile usage and internet services over the phone.

Education

MBA - Finance

The ICFAI University
Tripura
11-2012

Bachelor of Commerce - Commerce

K J SOMAIYA COLLEGE OF SCIENCE AND COMMERCE
University Of Mumbai
03-2006

Skills

  • Microsoft Excel
  • SQL
  • Python
  • VBA programming
  • Data analysis
  • Database management
  • Tableau
  • Power BI

Certification

• Executive Programme in Algorithmic Trading (Quantinsti).
• Full Stack Data Analytics (iNeuron).
• The Professional Option Trading Workshop (QuantsApp).
• Certified Data Scientist (Edvancer).
• Oracle SQL Expert Certified.

Awards

  • Silver Award
  • Bronze Award

Languages

  • English
  • Hindi
  • Marathi

Timeline

Senior Associate

IPG Mediabrands India Private Ltd
12.2022 - Current

Analytical Tool Executive

NielsenIQ
02.2016 - 11.2022

Analyst

Tech Mahindra
06.2015 - 02.2016

Senior Team Member

BA Continuum India Pvt Ltd
05.2008 - 06.2015

Customer Service Executive

Reliance Infostream Pvt Ltd
08.2006 - 12.2007

MBA - Finance

The ICFAI University

Bachelor of Commerce - Commerce

K J SOMAIYA COLLEGE OF SCIENCE AND COMMERCE

Similar Profiles

  • Dinesh SonalkarDinesh Sonalkar

    Deputy Financial Controller at Mediabrands India Pvt Ltd. (IPG)Deputy Financial Controller at Mediabrands India Pvt Ltd. (IPG)

  • Ruchi JainRuchi Jain

    Associate at IPG Mediabrands IndiaAssociate at IPG Mediabrands India

  • Nikhil PatilNikhil Patil

    Senior Paid Search & Social Associate at IPG Mediabrands India Pvt LtdSenior Paid Search & Social Associate at IPG Mediabrands India Pvt Ltd

  • Anushka BagchiAnushka Bagchi

    Pharmacovigilance Associate at Accenture India Pvt. Ltd.Pharmacovigilance Associate at Accenture India Pvt. Ltd.

  • ANJALI SINGHANJALI SINGH

    Relationship Manager at Deleverage TechnologiesRelationship Manager at Deleverage Technologies

CREATE PROFILE
WASIM SHAIKH