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 launches• 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 scopes valued up to $500K• 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