Summary
Overview
Work History
Education
Skills
Websites
Personal Information
References
Timeline
Generic

SHOBHANA SEKARAN

Northbrook,USA

Summary

  • 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

Education

Master in Business Administration -

Sinhgad Institute of Management
India
01.2013

Master of Science -

Pune University
India
01.2011

Bachelor of Science -

Pune University
India
01.2009

Skills

  • SQL
  • Excel
  • DAX
  • Data Mining
  • Data Modeling
  • Business Analysis
  • Market Analysis
  • Competitive Analysis
  • Gap analysis
  • Data Mapping
  • Market Research
  • Tableau
  • Power BI
  • Matplotlib
  • MySQL
  • PostgreSQL
  • Regression analysis
  • Hypothesis testing
  • A/B testing
  • Data cleaning
  • ETL processes
  • MS Office
  • BI tools expertise
  • Advanced Excel
  • Python Programming

Personal Information

Authorized To Work: US

References

References available upon request.

Timeline

Business Intelligence Consultant

ALLSTATE INSURANCE COMPANY
01.2018 - 01.2021

Market Research Intelligence Analyst

BSRIA INC.
01.2018 - 12.2018

Market Research Analyst

MARKETS and MARKETS
01.2014 - 01.2018

Business Data Associate

TMR Pvt. Ltd.
01.2013 - 01.2014

Master in Business Administration -

Sinhgad Institute of Management

Master of Science -

Pune University

Bachelor of Science -

Pune University
SHOBHANA SEKARAN