Supporting a realtor CRM in building their database with valid client contact details based on their categories such as real estate agents, business people and future prospect contacts.Validating contact details shared by loan officers to check for proper formatting, correctness of the data provided using formulas and to ensure duplicity is avoided by looking up the contacts with existing data.Uploading the validated contacts into the CRM by following the instructions provided through the assigned tickets for every request.Analyzing the customer review from the surveys conducted by market research companies and calculating the percentage of respondents who prefer the brand in comparison with competitors and extracting the required data using excel functionalities to be used in PowerPoint for presentation.

Conduct research on consumer opinions and try to identify the buying habits of consumers.Review the Ad boards/ Videos to understand the basic concepts such as functionality, convenience, uses, manufacturing Brand and market price of a given product.We capture the highlights, lowlights and the factors that drive a consumer to specifically choose a particular product in the market.Perform Source of Volume Analysis to find out success rate of a particular brand over its competitors.We read, analyze and classify open-ended responses to numerical codes using structured code frames and convert the open-ended responses into numerical values using Ascribe Software.We analyze the processed numerical output from the data processing team and itemize, reorder, calculate, compare and prepare the data in such a way that it could be incorporated into slides.We project the outputs from the research conducted with bar charts, pie chart, line graphs, spider chart, tables in order to display how well the product compares in the market with other brands along with trend analysis comparing the progress with several period of months or years.Nominated as Subject Matter Expert and been assigned with a team to ensure that the output by my team is delivered with prefect quality.Clarifying the queries raised by team members through query management system.Conducting brainstorming and KT sessions to spread the knowledge on CPG to the team.Presenting team weekly review & monthly dashboard reports comprising of quality summary, error details to clients.Perform Root Cause Analysis over the errors made to ensure that the cause is identified and avoided.Providing 30 days training as per schedule to the new joiners and mentoring them over the period.Understanding and identifying the difficulties in manually extracting data from various excel sheets to project them in charts or for reporting purpose and providing solution using vba macros.

Ascribe CodingPowerpoing SlidesVBA MacroGeo Latitude Longitude Mapping