Sameer Husain

Jack of Lots,
Master of None.

‘Live to the point of tears.'

Trying to document life as I know it. I'm a coffee snob, film enthusiast, amateur runner, solo backpacker; pretty much adopting every thing that sounds even slightly appealing to me.

SCORO AnalysisI extract revenue, cost and client data from our project management software - clean it - and create an easily understandable dashboard for stakeholder's to review our company's performance. This is performed on a monthly basis.

  • Data Analysis

  • PowerBI Visualisation

  • Dashboard Preparation

  • Data Validation

  • Financial analysis

CASH TESTINGCash Testing includes testing the accuracy of the borrower's financial statements, verification of transactions, and performing necessary checks on assets and liabilities to make sure they are reflected correctly.

  • Financial Analysis

  • Cash Auditing

  • Report Preparation

BORROWING BASE TESTINGBorrowing Base Testing involves testing the accuracy of investor reports prepared by the borrower. There is no Standard of Procedure for this as reports by different borrowers can differ vastly; it broadly can be broken down into verifying that the covenants set by the lender are being followed. For this, tests against the various financial ratios are performed depending on the covenants themselves.

  • Financial Analysis

  • Data Validation

SAMPLINGSampling refers to cutting a smaller subset from a big data tape that can be used to perform tests. A sample cut is only valid if the subset reflect the whole data tape truthfully. I modelled a Sample Calculator that outputs the sample size required from a dataset for it to be considered a true sample. It takes into account the Confidence Level, Error Rate, Precision Rate.

  • data sampling

  • data modelling

Project GOWER | Mar 18, 2024For a potential venture, I modelled a revenue and profit forecast. For this I leveraged 19 months of historical data from a similar company in the industry. I accompanied the output with an interactive dashboard to allow the user to understand the findings better.

  • Financial Modeling

  • Statistical Analysis

  • Data Visualisation

  • Financial Forecast & Projection

EXPENSES WRAPPED 2023
I examined my personal expenditures that I recorded from August 2022 to August 2023 and created a DASHBOARD using both Microsoft Excel and Power BI.

Doon in 10
March 16 - March 26

This was my very first time getting into solo travel, i was very scared to say the least. But to my surprise i ended up extending the trip from a week to 10 whole days to celebrate holi with literal strangers.

fourteen days of himachal
May 11 - May 25

This whole trip will remain ingrained in my mind forever. I met the most beautiful of people here - some who I stay connected to till this day. It was supposed to be a seven day endeavour but to my surprise, I booked a ticket to Manali (from Shimla) with a literal stranger from Germany to give me company.

a weekend in Jaypore
July 12 - July 14

The whole trip was planned 8 hours before the execution. A slow thursday + two bored friends + one long weekend = memories of a lifetime.

Vietnam Getaway
Aug 1 - Aug 11

The best thing about travelling is to meet likeminded individuals who would encourage you to step out of your comfort zone and take that leap you've been holding off on - and leap I did. The whole trip was a big time learning moment for me, at every corner I made a lot of mistakes - but all for a reason; I like to believe I'm a little more seasoned than before.

Feel free to reach out anywhere!

2023