Ishan Ghai Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

• Projects - Total Cost of Acquisition of a member, Life Time Value & Tenure, Member Enrollment and Experiences
• Working as a Tableau Expert in the team to manage all the Key Dashboards for Senior Leadership
• Utilizing SQL, SAS , R and Hive for Data structuring/computations & Tableau extensively for Data visualization
• Developed Automated Tableau reports that covers key metrics that enables in reduction of cost as per all the vital categories
• Playing Project manager role for Requirement gathering, Implementation and Client Engagement meetings

Gurgaon, India

Manage Key Performance Indicators – Financial, Productivity, and Activity related metrics for the internal teams (Sales, Marketing, Finance, HR)➢ Leading a team of SQL and Tableau Developer for building KPI Dashboards that improve accuracy, transparency and compliance of reporting and planning for multiple client businesses➢ Developing Business solutions that automate the Information systems effectively and efficiently➢ Handling around 100+ Dashboards for the organization that are monitored on daily basis with data fetched from multiple sources mainly SQL, Access and Excel file➢ Consult Clients and Internal Stakeholders on strategies of efficient information systems integration and management➢ Design and Convert business requirements into Technical Capabilities➢ Design, Deploy and Automate business Intelligence solutions through Reporting and Visualization Tools➢ Worked on complete “OTC (Order to Cash) cycle” project to monitor issues faced by Finance team related to order moment and invoices sent. Helped them automate the process to save manual effort of the team (Daily man hour saved – 6 to 7 hrs)➢ Working on Salesforce portal for report creation and extraction for multiple sales team and monitor their activity related metrics➢ Focus on Quality assurance and Quality control (QA/QC) for the dashboards built that can enhance operational efficiencies

Bangalore

Turning deep customer data into actionable insights through strategic methodologies and analytical techniquesConsulting Clients on New Business prospects in multiple markets as per Competitor Analysis Profiling based studies to understand economical and social aspects Maintaining Client interactions and working on projects from kick-off to report deliverable phaseHandling multiple interactions at one timeExperienced on : 1. Market research methods used for both qualitative and quantitative research projects.2.R language - Linear regression, Logistic regression, Time series forecasting, Clustering and Market basket analysis.3. Tableau - Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the dataProject Expertise: Market segmentation , Competition analysis , Forecasting, Dashboard tracking, Messaging studies , Pricing studies , Opportunity Assessment, Positioning studies , Demand Forecasting studies across multiple geographies (EU5, U.S, China, Mexico, Brazil, Japan)

Bengaluru Area, India

Working with a blend of Market research and consulting services to provide fact base solutions to the client for defining growth plansDesigning Questionnaires for Quantitative and Qualitative StudiesLeveraging latest market research technologies , data analytics frameworks and technologies on continues basisUnderstanding Customer Buying Behavior in Retail sectors through Surveys and InterviewsUsed Primary and Secondary research data to develop clear, concise reports that provide key conclusions and actionable recommendations for the clientsUnderstanding Social and Demographic metrics through Online surveys in multiple geographiesProject Expertise: Market segmentation , Competition analysis , Messaging studies , Pricing studies , Opportunity Assessment, Positioning studies , Demand Forecasting

Bengaluru Area, India

* Studied the increased usage of Smart phones, iPods, Tablets related to buying behaviour. * Analyzed Printing behavior of Small and Medium businesses in India and U.S. *Analyzed decision making and buying behavior of customers related to printers in a developing and developed country.

Pgdm, Marketing, Dean'S Merit List

Bachelor Of Technology (Btech), Computer Science, 76%