Himanshu Gupta

This project was for a Dutch professional services firm which mainly occupied the company formation space.

I worked in the capacity of a product manager, helping them decide whether the digital applications should be developed after studying the internal and external processes of the firm. I concluded that the features should be developed in collaboration with the senior management of the firm.

I also acted as the project manager during the design and development phase, managing a total of five remote international teams of designers and/or developers.

I completed the MVPs of three different applications, geared towards different kinds of customers and partners of the firm. Then, I also completed detailed prototypes of the next iterations of the two apps, keeping an especially strong focus on design and user interface.

This was a long project spanning more than 18 months but with breaks in between.

The client was one of the world’s largest visitor attraction operators.

I analyzed several user feedback sets for this company and provided insights about the user experience—focusing on how it could be improved. The analysis included sentiment analysis, historical analysis, word clouds, and so on.

This project was for a European company looking to launch its app in the German market, followed by selected other markets. The app was a health and fitness app, focused more on fitness and the social component. In this project, I helped the company in metrics, product roadmap, and related areas.

I advised them on the metrics to track in the initial phase and in the later stages. Based on the company’s objectives, I also developed a product roadmap for them. I also recommended marketing activities, prepared a high-level feature prioritization, scanned user feedback of other similar apps, and identified insights around monetization based on market research.

I developed an end-to-end solution that provides business insights to the clinic. As part of the project and with the clinic's founder, I identified the metrics needed, the appropriate way to visualize them, and the calculations that need to be done. I then put in place a system to record the raw data via paper forms and electronic forms. Finally, in the front end, a Google Data Studio based visualization system was put in place.

The visualization system was developed for the founder and individual employees of the clinic.

This project was for a New Zealand-based digital video agency. The project involved building a Tableau-based online system that provided a set of graphs that helped visualize the impact of a TV advertisement.

The system connected to Big Query, Google Sheets, and Google Analytics in the back end. Information related to new advertisements automatically showed up in the Tableau-based online system. The charts had enough filters and other interactive elements to visualize the information effectively in different ways. Datasets were joined as well as blended to achieve different objectives.

This project was for a Hawaii-based professional staffing firm. The client wanted to build their own applicant tracking system (ATS).

I researched the ATS market, compared the features of selected ATS, and provided product recommendations to them.

This project was for a German startup that wanted to provide legal services online.

I researched the legal services space by looking at similar service providers and estimating online traffic, conversion rates, and product economics for this startup.

This project was for a Brazilian entrepreneur looking to enter the European market. I developed a prototype for an eCommerce platform where horse owners could sell horses and others could buy them.

Here, I developed a dashboard that focused on the sales funnel of an European professional services firm. In addition, there were also some financial and operational metrics.

The dashboard was first made in Google Sheets and was fully automated from data retrieval to visualizations update to sending emails to the CEO, using different cloud-based software. The same dashboard was much later developed in Tableau.

The client was a digital healthcare startup based in the US and I researched different apps in the nutrition space.

The research covered areas such as the features of the apps, the popularity of the apps and the company behind the app.

We assessed a wide range of apps for the project—some focused on food logging, some on photo journaling, some on fitness, some made by healthcare providers, others by app developers, some by wearable manufacturers, and others by digital startups.

This project involved user experience and competitive research on more than ten products within the password manager space. Later, we completed a similar type of research for more than 20 products in the online privacy space.

The research included looking at the product features, product business model, product design and usability, product performance, and company details. The deliverables were in the form of Airtable and a professional slide deck.

For this project, I developed a model that simulated the effect of different pricing combinations on the revenue for a San Francisco-based edtech company.

On this project, I analyzed the job requirements for 40+ technology firms using programming tools (R), web scrapping apps, and visualization software.

A number of hiring insights, both at the firm level and at the industry level were identified based on this analysis. Most of the insights were also visualized using visualization software such as Tableau and Power BI. This project was for a Canadian marketing firm whose CEO is also a public speaker.

Here, I estimated the market size—on the supply side as well as on the demand side—for a London-based food tech company. This food tech company was a food platform that connected customers and food suppliers. The company was looking to expand to other cities in Europe. The research helped them receive £1.1 million in seed funding from two investment funds.

I researched different third-party logistics providers that served the eCommerce industry in the US and abroad. For each 3PL provider, I gathered competitive intelligence such as services, warehouse capacity, key industries served, digital presence, contact details, and so on—covered over 75 logistics providers.

The front end consisted of an inventory tracker sheet that showed the balance inventory for each SKU at the end of the day. The sales for the corresponding SKU could also be seen. A consolidated dashboard provided key metrics such as sales, revenue, top-selling products, percentage of returns, and a few other metrics.

The back end consisted of sales data from Shopify and an inventory update tab.

I assessed the impact of robotic automation on a number of industries and sub-industries such as eCommerce, electronics, agriculture, apparel, manufacturing, and so on for a Palo Alto-based future technologies think tank.

Here, I researched and estimated the revenue, sales, customer satisfaction, and so on for different eCommerce product categories for a US-based entrepreneur. As part of this, I also analyzed large data sets of Amazon data. All these resulted in a set of recommendations related to different product categories to start a business in.

This project was for a German startup in the online legal services space. It involved building process maps for each of the three online services the startup intended to offer. The process maps were developed in a swimlane format, clearly identify the department/person responsible for the activity.

The client for this project was a technology consulting firm headquartered in San Francisco with few offices outside the US as well.

In this project, I researched the US fintech space in-depth—covering areas such as market size, different segments, geographical differences, investment scenario, thought leaders, leading players, engineer demand, and more. This not only involved research but also making estimations based on researching and analyzing the data.

A Canadian Factory Operations Executive wanted to restart a sugar factory based in Haiti so that it helps the local economy. For this, a business proposal had to be submitted and presented to the authorities.

First, a financial model for restarting the factory was built and the economics understood. The final part involved preparing a presentation incorporating key data from the financial model. The presentation also summarized the technical, market, operational and social feasibility of the factory restart plan.

This was a very good learning experience for me as this was an industry I was totally unfamiliar with. I had to understand it in-depth to be able to do this project.

This project was a Middle-Eastern based family office. The venture arm of the family office was looking to launch a mobile accessories brand in the Middle-East, followed by other countries.

I prepared an in-depth financial model for this company, after understanding their products, business model and the requirements. Along with this, I also researched and prepared a slide deck, containing the market potential, business case, product roadmap and marketing tactics

This project was for a startup that provided support and rewards to students actively engaged in college clubs.

In this, I estimated the market size of student clubs both at the undergraduate level and the graduate level. Along with market size, we also estimated historical growth rates.

I used multiple bottom-up approaches to size the market and used a "football field" approach to determine the final market size. All of the entire research and estimation work was converted to an investor-ready slide deck format. The slide deck also provided statistical backing for the sampling method used for the market size estimation.

I developed a Google Sheets-based dashboard that had sales, marketing, human resource, finance, and operational metrics for a Chicago-based law firm.

The dashboard was fully automated and connected to multiple software in the back end: Google Sheets, Xero, Lawmatics, Clio, Zapier, and Google Analytics. The dashboard updated daily and sent weekly PDF snapshot emails to the CEO and top executives. We also prepared concise documentation of the dashboard.

On this, I researched the trends in the connected car space for the innovation team of a leading American automobile manufacturer.

The end client was a London based mutual fund. One of their portfolio companies was a leading Thai telecom company.

The mutual fund wanted to know whether the high dividend payout of the telecom company was sustainable or not. I assessed and prepared a report about the same. At a high level, the assessment involved looking at the telecom market dynamics, assessing the strengths of the company and analyzing the financials of the company.

This project was for a Spanish Autism Therapy Provider. This NGO was developing its fundraising strategy. As part of the fundraising strategy, our team built financial models quantifying the benefits of investing or donating money to the NGO. Within the team, I had taken the responsibility of building 1 of the 3 models we came up with. This model was based on macroeconomic impact.

This project involved researching the solar energy market in Europe, addressing the client's specific questions. The research was summarized by creating a professional report. The report looked at market outlook, solar panel pricing, the renewables subsidy regime, company profiles among other things.

This project was for a private investor. I evaluated the proposed merger between the two oil & gas companies, arriving at a fair value based on multiple approaches. The valuation was performed using 3 approaches - DCF Valuation, Comparables Valuation & Transaction Analysis.

The client was the Paris-based division of a leading Fortune 50 industrial conglomerate.

The research involved several aspects related to the global renewable energy scenario, such as:
1. The grid system preparedness to handle fluctuating inputs to the grid
2. Global renewable energy storage capacities
3. Activities of large corporations in the renewable energy space
4. Volatility in electricity pricing
5. Regulatory policies and structures