Detail-oriented data analyst with 8 years of experience in extracting insights from complex data sets to drive strategic business decisions. Proficient in statistical analysis, data visualization, and using tools such as SQL, Python, and Power BI. Adept at communicating findings to non-technical stakeholders. Holds extensive market research experience in a variety of Insurance, Agriculture, Chemicals, Materials, Healthcare, food, and beverage industries.
Managed the delivery of insightful and original market, product, and company analysis in both quantitative and qualitative (profiles, presentations, reports) forms and took responsibility for their production to publishable standards.
Experienced in Data Extraction, Data Analysis, Market Forecasting, Customer Segmentation, Marketing Analytics, Power BI, Business Intelligence, Statistics, Data Mining, Python, SQL, Data Visualization, Statistical Analysis, and A/B testing.
Conducted primary research, which involves the entire gamut of activities – preparing the questionnaire, identifying interview participants, developing contacts and interviewing, to generate quantitative and qualitative insight.
Conducted secondary research to build the analytical sections within each report and to identify data points, market trends, etc. Which would authenticate the market data within the internal databases.
Collected, processed, and cleansed raw data using MS Excel, Power Query, and SQL. Developed compelling, data-driven recommendations and created managerial dashboards using Tableau.
Led deliverables that include valuable insights from specific research projects, synthesis of consumer insights with internal sales data, syndicated studies, and competitive intelligence.
Oversaw qualitative and quantitative research processes, including needs assessments, new product ideation, concept testing, pricing, ad testing and tracking, customer segmentation, satisfaction and loyalty, brand tracking, competitive assessment, retention and defection, and market sizing.
Experienced in new product and service development and launch: Identified consumer needs, determined optimal product or service offering and appropriate pricing, identified target markets, provided course correction during product pilot time frames, and monitored success once fully launched.
Led Customer Segmentation effort that includes identifying strengths, weaknesses, opportunities, and challenges for growing the customer base.
Exceptional use of SQL, Power BI, DAX, Power Query, Python, and MS Office (Word, PowerPoint, and Excel) throughout the work experience.
Skilled at using a range of channels to accumulate, review, and record information that can then be presented for establishing trends and managing business plans. Proven track record in completing projects and delivering results on time and on target.
Overview
8
8
years of professional experience
Work History
Business Intelligence Consultant
ALLSTATE INSURANCE COMPANY
Northbrook, US
01.2018 - 01.2021
Analyzed large data sets to identify trends and actionable insights on possible implications to Allstate and overall insurance industry for senior executive leadership
Developed and maintained dashboards in Power BI to track key performance indicators to develop strategies for market share growth and profitability on a countrywide basis
Collaborated with cross-functional teams to define business requirements and deliver data-driven solutions
Used SQL to perform moderate to high complexity ad-hoc data requests/extractions for product, pricing, and underwriting teams
Worked on S&P Global and LexisNexis InsurQuote database using SQL and Tableau to evaluate competitive position
Focused on pricing, coverage and underwriting of incumbent and emerging competitors
Focused on new product design, emerging business models, evolving consumer needs, Insurtech and venture capital analysis, new technology platforms, and competitor innovation initiatives
Collaborated with 3rd party vendors to gain consumer insights on existing auto insurance for product revamping
Developed strategies for market share growth and profitability on a countrywide basis
Used SNL and other in-built tools to perform moderate to high complexity ad-hoc data requests/extractions for product, pricing and underwriting to deconstruct competitor actions and developed recommendations
Developed Insurtech repository using Salesforce technology for senior leadership
Market Research Intelligence Analyst
BSRIA INC.
Chicago, US
01.2018 - 12.2018
Assisted in data collection and preprocessing to ensure data quality and integrity for analysis
Conducted research on market conditions at local and international level for the built environment (HVAC, Building Automation, Cabling, etc.) to determine market sizes, trends and drivers, competitive environment, distribution, and other strategic marketing information sought after by decision makers
Collected data on competitors and analyzed prices, sales, and methods of marketing and distribution
Created visualizations and reports in Excel and Power BI to support management decisions
Conducted exploratory data analysis to uncover patterns and support business development initiatives
Managed and led a team that delivered full cycle of qualitative and quantitative market intelligence projects including primary and secondary research
Delivered reports and presentations of findings, illustrating data graphically and translating complex findings into written text
Conducted desk research, expert telephone and in-person interviews with C level respondents, essentially with manufacturers
Collected data on competitors and analyzed prices, sales, and methods of marketing and distribution
Turned findings into actionable recommendations and delivered forecasts by building dashboards on Tableau
Market Research Analyst
MARKETS and MARKETS
Northbrook, US
01.2014 - 01.2018
Conducted study to many customized/syndicated projects and developed expertise in data mining, market forecasting, industry analysis, competitive intelligence, financial modeling, and feasibility studies
Built Sales Forecasting and Marketing Mix Models for clients pertaining to consumer goods for measuring the effectiveness of different marketing activities
Used insights from these methods to recommend marketing mix that will result in a higher marketing effectiveness
Derived insights from financial and retail data sources to provide a comprehensive presentation of business performance and needs
Improved profit margin potential by analyzing sales data and forecasting product demand by continent, country, and state level using SQL and Tableau
Worked on various projects for financial, consumer goods, materials, and energy clients using descriptive statistics, predictive statistics, price forecasting, data visualization on client data
Identified critical drivers, key relationships, outliers, trends created critical insights, interactive reports using retail industry data for multiple clients
Business Data Associate
TMR Pvt. Ltd.
Pune, India
01.2013 - 01.2014
Managed deliverables of insightful and original market / product / company analysis in both quantitative (databases, models) and qualitative (profiles, presentations, reports) forms and took responsibility for their production to publishable standards
Conducting study for the development of a market-leading database in the area specific to the scope of the assigned project
Played a key role in developing new team products, processes, and content
Conducted primary research with the key opinion leaders in the industry and contribute in building a panel of experts in the industry
Conducted secondary research to build the analytical sections within each report to identify datapoints / market trends etc
Assisted in the development of market-leading databases by validating and strengthening the key datapoints as part of the report writing process