Data Insurance

REKHA CHOWDARY

E-Mail:*****.***@*****.***

Q U A L I F I C A T I O N S U MMARY

A Result Oriented Associate Market Analyst with experience of 2.5 years in Insurance Industry and hands-on experience in quantitative / statistical analysis and forecasting.

• Employed quantitative and qualitative marketing research techniques to help clients understand their customers and competitors more fully and make well-informed business decisions.

• Strong analytical skills and support operations through analysis of key performance indicators and trends.

• Consensus-driven communicator; liaise across various business teams and promote organizational success.

• Rapidly adapt to new technologies and possess expertise with Excel, Tableau and broad range of statistical software.

• Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines calculation measures.

• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables.

• Extensive understanding of working in a matrix organization by virtue of versatility and hands- on approach.

CORE COMPETENCIES

~Primary Research ~Data Management and Analysis

~Secondary Research ~Data Visualization

S K I L L S

Office Automation :MS Office

Statistical Packages :R

Database :MySQL

Statistical Techniques :Simple Regression, MultipleRegression, ANOVA Multivariate techniques :Factor Analysis,Cluster Analysis Visualization Tool :Tableau

Charting tools :Rational Rose

P R O F E S S I O N A L E X P E R I E N C E

Organisation : Digital Insights and Research Private Limited, Hyderabad as Associate Analyst. Duration : 2.5 Years

Role : Associate Analyst

Domain : Insurance

Clients : Insurers, Reinsurers, Brokers, Consultants Platform :Market Research and Analysis

Key Responsibilities:

• Market research and analysis in financial services domain (Insurance).

• Responsible for collection and management of data (domestic and global) from various Insurance regulation and Associations by secondary research.

• Produce comprehensive quarterly and annual market analyses that details current market conditions, transactions, market.

• Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.

• Utilized spreadsheets and statistics to analyse significant patterns in the Market and preparing charts using spreadsheets

• Collaborate with reporting team to conduct the futures market data analysis to maintain the accuracy.

• Updated the database regularly and participated in different projects as requested by my supervisor.

• Designed various Key Performance Indicators for business monitoring of Client such as market shares, profitability indicators

• Analysis of the major Strengths, Weaknesses, Opportunities and Threats within the insurance sector.

• Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.

• Combine data sources by joining multiple tables and using data blending.

• Formatting the data by using legends, marks, colors, sizes, shapes and applying various types of filters like Data source filters, Quick filters and Context filters and performed conditional sorting.

• Implemented aggregated data into Tableau and created highly interactive and user friendly dashboards with visual effects.

• Handling a consulting project with Lloyds’ which involves in creating country level database for General Insurance market for 70 countries.

• Prioritized tasks and manage time effectively to meet deadlines. A C A D E M I C DETAILS

2013-2015 PGDM (Marketing & Business Analytics) from Vignana Jyothi Institute of Management with 4.09/5 C.G.P.A.

2009-2013 B.Tech. (CSE) from K.L University with 7.76 C.G.P.A. I N T E R N S H I P

Organisation : Nagarjuna Fertilizers and Chemicals Pvt.Ltd. Hyderabad. Duration : 2 Months

Project title : A Study on Awareness and adoption of Non-bulk fertilizers. Key Result Areas:

• A questionnaire was used to obtain the information from farmers, dealers and competitors.

• All the important questions in the questionnaire which enriches the inputs to the company and the given managerial implication are critically analysed using descriptive statistics, regression and some excel tools like pivot tables, pie charts, radar graphs and bar graphs.

• This survey helped to analyse the product information dissemination strategy that the company should follow for better market share and perception of farmers about NFCL and other brands. A C A D E M I C P R O J E C T S

Retail Analytics

• Used Tableau dashboards to gain the insights of consumer behavior and used market basket analysis to build a model for better business opportunities. ANOVA on Product Sales of FMCG Sector for 12 years’ data using R.

• This helps to find the relation between the quarters, product sales and product categories. So we can plan for the order of products in next quarter. MySQL project on VJIM student database.

• Used simple queries, sub queries and joins to retrieve the information, this helps to find whether the employability of students depends up on graduation specialization and entrance test score.

Lenovo’s Entry to Smartphone Market and Changing Industry Dynamics”.

• Conducted primary survey among different age groups by developing a questionnaire using Google questionnaire and Survey Monkey.

• Used descriptive statistics and chi-square to find whether there is a relation between gender and apps availability, types of apps and price.

• Concluded that the purchase pattern varies among gender based on cost. E X T R A C U R R I C U L A R A ND CO-C U R R I C U L A R A C T I V I T I E S

• Certified as Data Scientist with SAS by SimpliLearn in 2017

• Took active part as volunteer in Chrysalis event conducted by VJIM.

• Active part as volunteer in Each One Teach One Program conducted by VJIM in 2014

• Took active part as volunteer in Blood Donation Camp by Friends Charity Organization at VJIM in 2013

• Participated in The Great Mind Challenge Competition by IBM in 2012.

Contact this candidate