Tanuja Chati

SUMMARY:Analyst with experience of extracting meaningful information usingMS-Office, Business Objects, Oracle, SQL to facilitate better decision making.

EXPERIENCE:

Cisco Systems, San Jose, CA (IT Flexible services) Market Research Analyst (5/08-9/08)

  • Competitive Analysis: Compiled data from multiple excel sheets, business objects, Vendor Marketing Portal (internal portal), and competitors’ web sites

Analyzed the competitor’s products and services, market position, market share, product

  • Marketing Campaign Effectiveness Analysis: Consolidated and analyzed the campaign data to measure the effectiveness of events in terms of:

Total sales/total requests as the result of campaigns

Time it takes to generate the first order/request

Number of requests in each service area

Used clickstream data to analyze site hits

  • Client Analysis: Developed customer profiles based on purchase behavior that can be used for future targeted marketing programs and promotions

Microsoft Corporation (IPTV Division), Mountain View, CA Marketing Analyst, (10/07- 4/08)

Built a Value Proposition Model in MS-Excel 2007

  • Studied the IPTV architecture
  • Analyzed complex excel workbook “Sizing Tool” to calculate the number of servers needed for the IPTV system
  • Incorporated competitors’ pricing in the model for comparison with Microsoft’s IPTV solution
  • Researched market reports to find information about ARPU/ Churn Rate/ Take Up rate

Spansion LLC.(Previously AMD), Sunnyvale, CAMarket Analyst, (9/05-9/06)

  • Identifying the key market players in the industry for NOR Flash Memory chips, analyzing their market position e.g. Competition, Suppliers
  • Gathering information about latest and future technologies in chip development e.g. OUM
  • Studying the total Flash market from time to time using research reports from iSupply, Web-feet, WSTS, Forester reports etc.
  • Allocating information to launch new product NAND Flash Chip- TAM for ORNAND
  • Search for new customers in each of the product segment

EDUCATION

  • MBA (Finance/Economics) Babasaheb Gawde Institute of Management, Mumbai University
  • BA (Accounting) R.A. Podar College of Commerce and Economics, Mumbai University
  • Overall GPA 3.5/4.0

OTHER ANALYTICAL TOOLS USED

Salesforce.com

DETAIL EXCEL EXPERIENCES

  • Charts/ Graphs –To present the cost differentials(Line graphs), top 3 costs, total cost of Mediaroom (Pie Cart), HW cost architecture (Bar chart)
  • If statement-Conditional statements for the price metric
  • DataTables/Scenario Manager (What-if -analysis)-Used data tables to analyze the change in total cost by changing the VOD cost, What-if –analysis to view the results by changing the service group scalability
  • Data Validations and Excel/Visual Basic User Forms-Prepared a Sales tool for the sales team, to enter costs and see the result on the output sheet. For this tool used data validations and created some basic User Forms
  • Macro recording and writing(VBA)-Crated Macros for the repetitive tasks such as changing the costs
  • Debugging VBA programs if required
  • Cell referencing-To build the model dynamic used a lot of cell referencing.
  • Pivot Tables-Used excel’s pivot tables function to create ad-hoc reports with specific criterion such as market segment/opportunity owner/region. Also created pivot reports and charts
  • Vlookup function-To lookup the values and text in different markets from another sheet in a same workbook
  • Charts/graphs-Created different graphs e.g. bar graphs, line graphs, trend lines, pie charts, template to show Spansion’s market share, revenue, profit margin