Freelancer logo
How It Works
Browse Jobs
Log In
Sign Up
Post a Project
EXPLORE
Data Entry
Data Processing
Project Management
Training
Visual Basic
0.0
(0 reviews)
You're now following .
Error following user.
Your membership plan only allows 0 follows. Upgrade
here.
Successfully unfollowed user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Email successfully verified.
User Avatar
$20 USD / hour
Flag of INFlag of IN
pune,
india
$20 USD / hour
It's currently 6:06 am here
Joined April 16, 2019
0 Recommendations

Rahul L.

@rslamba1

0.0
(0 reviews)
0.0
(0 reviews)
0.0
0.0
$20 USD / hour
Flag of INFlag of IN
pune,
india
$20 USD / hour
N/A
Jobs Completed
N/A
On Budget
N/A
On Time
N/A
Repeat Hire Rate

Financial Modeling/Analysis | Process Automation

I'm a Pune, India based Consultant with over 10 years of experience across; Excel based Process Automation, Operating & Financial Modeling, Budgeting, Business Valuation (DCF, Comps, SOP, LV etc.), Strategic Business Analysis and Excel based problem solving. I can also provide solutions to everyday financial or business challenges, say building a logistics model, orderbook organizer, sales strategizer and the like. Among other things, I can help with Market Sizing, Bottom-up Revenue forecasts or validating an existing one, M&A analysis, Performance Improvement Analysis and help with Corporate Finance decisions (Project analysis, Capital budgeting, Return analysis, Build vs Buy, Lease vs. rent etc.) As a trainer/instructor I have conducted workshops in many of the aforementioned areas which saw participation by students, professionals and senior management from organizations of repute. I am passionate about wildlife & nature photography and follow UFC, tech & healthy living among other things.
Freelancer
Visual Basic Developers
India

Contact Rahul L. about your job

Log in to discuss any details over chat.

Portfolio Items

There are 2 broad methods to analyze financials; discrete ratio analysis or an integrated framework (Ex. DuPont or ROIC tree).
The former can throw you off especially if you don't know what to look for, more so when one ratio says business is doing great while another contradicts it.
This here is an example of a framework analysis, this is the McKinsey framework called the ROIC tree.
I have a different take on it, this is a mini-model in itself and can leave the manager to focus on impact analysis in testing different scenarios say, "how much do I gain by shaving off 10% of my operating expenses" or "what if lay off 20% of the workforce from this division".
It is a Very powerful tool which few realize until they see it in action.
Integrated Performance Analysis
Sometimes Pivot Tables don't work for a client, they need something more direct where they can work with a limited number of inputs as opposed to sifting through several filters/dropdowns.
Here, the client wanted a heat map on 4-dimensional data. The data itself is quite complex and most of the work actually went into organizing it rather than building the actual reports.
Formulaic Report
Pivot Table reports are usually (not always!) the best way to get answers from voluminous data.
They are much lighter than going the formulaic route, can handle a lot of parameters pitted against each other and have a ton of operational flexibility.
Adding custom fields, grouping dates or price brackets only makes them more powerful.
However, sometimes the questions clients have simply cannot be answered with them and a customized formulaic report is the only way out.
Pivot Table Report
There is no such thing as a 'standard' Dashboard. 
It varies by project, by how many variables are at play, how many such variables you would want to see in a single report etc.
This is an example of a more advanced dashboard where I had built an operating model for a highly regulated sector and there were a lot of variables that needed to be simultaneously compared.
Dashboard #1
This is what most clients mean when they say 'I want to analyze the performance of my business'.
A tool like this simply gives you a laundry list of categories and within that a ton of performance measures that the user can look through.
This is a laborious task but smart use of Excel can really make a huge difference to the end-user experience here.
Discrete Performance Analysis
The Client described it as 'I want to organize my Orderbook and want a few questions answered'. Though it ended up spanning 3 months and needed a ton of back-end data clean up!
Tools such as these are tricky because usually clients already have something in place, that serves as a reference for them and it becomes a challenge to explain to them why they need to rebuild one from scratch as opposed to trying to fix what's clearly... just off!
Then come issues with legacy data, random text and numbers in the same column, missing data points, incorrect date formats, file management issues and the like.
Such an exercise is not just about building something sophisticated, unbreakable yet modular but also about spending time educating the end user on how to use it efficiently.
Orderbook Management tool

Reviews

Changes saved
No user reviews
No reviews to see here!

Experience

Founder

Plutonia Solutions
Aug 2017 - Present
Plutonia offers solutions across; Corporate Finance, Performance Improvement, Strategic Business Analysis, Excel based Problem solving and Training in the said areas. Some of the projects include; - Built an Operating model for a Dubai based global consulting firm on the Saudi Waterways sector. - Built a hyper-detailed Operating Model for a Pune, India based building materials manufacturer. - Built a performance analysis and benchmarking tool for a Singapore based global contract manufacturer.

Consultant

Cashel House | Melbourne, Australia
Aug 2017 - Jan 2018 (5 months, 1 day)
The project involved building perhaps, a first-of-its kind comprehensive & modular Family Office tool. The tool was designed to evaluate an exhaustive list of financial services that a wealthy family may require help with. And planning of each such service across the horizon in the context of; pre-defined laws, state acts and individual requirements of a given family. The stint also saw me filling up on a few buyside & sellside mandates.

Co-founder, Lead Content Creator and Instructor

Finatics | Pune, India
Oct 2008 - Jun 2016 (7 years, 8 months)
I co-founded Finatics - a financial training and consulting initiative. We specialized in Financial Modeling and Excel workshops for B-schools, corporates as well as individuals. I assumed the role of lead trainer and content creator. Our techniques were proprietary and continued to evolve over a period of 5 years. We folded-up in 2016 due to the economic downturn and a shift of demand within the financial services space.

Education

Master of Business Administration

University of Pune, India 2006 - 2008
(2 years)

Bachelor of commerce (B.Com)

Symbiosis International University, India 2002 - 2005
(3 years)

Contact Rahul L. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Top Skills

Excel VBA
Visual Basic
Project Management
Data Entry
Training

Browse Similar Freelancers

Visual Basic Developers in India
Visual Basic Developers
Data Processing Executives
Project Managers

Browse Similar Showcases

Visual Basic
Data Processing
Project Management
Data Entry
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 141 959 042)
Copyright © 2020 Freelancer Technology Pty Limited (ACN 141 959 042)
There is no internet connection