SWOT Analysis (Business Development Office - Dairy Development Corporation)

​

Issue: With the increasing number of competitors in the industry and the recent negative press received, the company wanted to get an update on the consumer perception, supply chain, competitors and their standing at the time. 

Solution: Conducted through analysis on Consumer, Competitor, their employees and presented with a report along with recommendations.

Process: I started out by creating a questionnaire for the consumers and vendors in supply chain. After gathering response directly from them regarding their impression on the company and the competition, I then moved into secondary research - looking into historical reports and market updates. This gave me a wider idea of what is the trend in the market, how is the industry progressing and what are the competitors up to. I then focused my attention within the company and interviewed some employees and high level officials to get an idea of their perception about the company, its operations and their vision for future. After through analysis for 4 months, I compiled a report and presented some solutions that i saw would improve the process.

 

Weekly Sales Report (Dot International Pvt. Ltd)

​

Issue: As the operations of Dot International grew, it was increasingly difficult to manage and keep track of the the transactions. The company was looking for a easy and quick way to view the report (ledger).

Solution: Use of Macros in Excel in reducing redundancy and streamlining process.

Process: I used Pivot Table to Sort the transactions by customers. Instead of doing the same action over and over again, I created a Macro in Excel to record the process. The report can now be generated in seconds, using the shortcut key for the macro – instead of spending hours sorting out rows and columns.

​

​

Budget Management (Nepalese Student Association - WTAMU)

​

Issue: With no proper budget system, the NSA was struggling to come up with and manage their budget for 2017. 

Solution: Setup a consistent inflow of cash and filter the programs and activities to manage budget

Process: As the vice president of the club, I was in charge of overseeing the operations. To manage the budget I followed the following process:

• Set up membership and collected annual membership fees

• Contacted NSA Lubbock at Texas Tech University and convinced them to sponsor a set amount annually for next 5 years (2017 to 2022) as a part of collaborative effort in promoting Nepalese Culture.

• Prepared a Journal to keep track of all the incoming and outgoing money, to control the leakage and increase visibility.

 

These actions has helped the NSA to sustain enough budget to plan out additional events for upcoming years.

​

​

General Ops Manual Update (Strategic Projects - United Supermarkets)

​

Issue: Yearly update of the General Operations Manual. Formatting and Editing the content of the Manual.

Solution: Get in touch with each department and discuss what all changes are required.
Process: A mass email was sent to all the departments regarding the notification of Yearly update of the manual. I then reached out to individual department over the phone or via email and discussed the changes and edits that were required for their individual sections. Each department again had multiple People in charge of multiple aspect within, and therefore communication was the key to keep everyone in loop. I conducted regular follow through, set up meetings with concerned individuals and updated everyone on the changes as they occurred. I kept a track of all the changes that were made, and also of all the individuals that were supposed to provide me with their materials. This made it easy for me to reach out to everyone on time and get everything done within the time frame.