Tejinder Mangat Email & Phone Number

San Jose, California, United States

• IDG offers market analyst research and strategic consulting to 100+ firms in the video game industry, including platforms, publishers, developers, media conglomerates, and private equity firms.
• Served clients in custom research consulting engagements, including strategic investment due diligence for game development studios, market landscape analyses for genre categories, and forecasts for upcoming title.
• Improved the sustainability of the company's consulting department during a period of high growth by coordinating team reorganization, establishing onboarding procedures for new analysts, and managing new project.
• Responsible for creating and administering the company's PostgreSQL databases and validating new datasets for the analyst team, including retail sales data, playerbase estimates, title rankings, and transaction receipts
• Reviewed new technologies to be implemented to improve business processes, including Tableau, Microsoft SharePoint, DBeaver, Asana, MailChimp, and DocSend

San Jose, California, United States

• Defined scope/structure of new research publications and guided a five-person analyst team on key research topics to cover on industry trends
• Implemented Asana to manage project timelines and allocate resources, ensuring timely production of quarterly reports and custom research
• Improved business processes by streamlining financial models, visualizing forecasts in Tableau, migrating Microsoft Access databases to MySQL and later PostgreSQL, and creating process documents

San Francisco, California, United States

• Published report presentations to summarize forecast updates and provide analytical insights on emerging industry trends using sales and active user data (readership includes 500+ clients across 90+ gaming companies)
• Forecasted console, PC, and mobile gaming market sizes for 20 regions/countries over five year periods
• Visualized forecast data by territory, platform, and business model using interactive Tableau dashboards/stories

Cupertino, California

• Adecco offers contract technical staffing solutions for major technology companies. I worked onsite at Apple Maps from May 2014 to Aug 2015 and then at Google Maps from Sep 2015 to Dec 2015.
• Resolved at least 60 service issues with Apple/Google Maps' data per day
• Investigated and assessed validity of customer reports and service issues
• Analyzed data and imagery using QGIS, VLookup in Excel, and web research
• Provided support in understanding of policies to team members as needed

Washington D.C. Metro Area

• Identified potential sources of renewable energy in Forest Service supply chains by gathering and synthesizing data using Pivot Tables in Excel
• Gained working knowledge of GIS mapping tools through external coursework and internal shadowing
• Enhanced staff webinar training by interviewing and collaborating with internal teams to find common priority areas in need of improvement
• Reviewed federal grant proposals to recommend suitable program partners based on project plans, budget summaries, and expected project outcomes

Bachelor Of Arts (B.A.), Environmental Studies & Political Science

Education Abroad Program, International Relations