Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project Profile cover photoundefined
You're now following .
Error following user.
This user does not allow users to follow them.
You are already following this 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
$25 USD / hour
Flag of INDIA
gwalior, india
$25 USD / hour
It's currently 6:55 PM here
Joined July 25, 2013
1 Recommendation

Bhupendra Y.

@bhupendrayadav

preferred-freelancer-v2.svg
4.9 (57 reviews)
6.1
6.1
$25 USD / hour
Flag of INDIA
gwalior, india
$25 USD / hour
98%
Jobs Completed
100%
On Budget
97%
On Time
21%
Repeat Hire Rate

Process Automation professional

A professional having more than 8 years of experience in VBA based automation tools, Excel automation, PowerPoint automation, Word automation, financial automation, macros, Web application development (Python), with postgraduate degree from a well reputed tier-1 B-School. Worked in many reputed organizations on senior level. Why Hire ME? I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which We are sure are doable within time frame and budget.. I always deliver 100% Satisfaction to the client. Area of Expertise: Business processes automation VBA macros Advanced Excel Excel Modeling MS Office Automation ERP development Employee management system Excel and VBA automation Project Management system Database management Web app development
Freelancer Excel Experts India

Contact Bhupendra Y. about your job

Log in to discuss any details over chat.

Portfolio Items

Client is one of the Indian stock traders, working with technical analysis.

Requirement: To create an Excel based automated system to fetch stock market alerts from third party website and analysis those alerts in excel and present the output in form of radar charts for Bull and Bear categories.
Stock Market Analysis tool with Radar Charts
About Client: One of the top real estate agents in London, United Kingdom. They help big brands in finding out the best property with high profitability for their shop.

About project: An excel based analysis tool was developed with following outcomes:
1. Can analyse and compare up to 5 properties based on break even analysis, profitability analysis and property cost.
2. Financial forecasting for next 10 years to get an idea about cash flows and comparison between available properties.
3. Dynamic dashboard to visualize the outcome of the analysis in charts to provide the complete picture on one page
4. Scenario analysis with three scenarios (worst, base and best) to check the feasibility of the property in case of adverse conditions.
5. An analysis report (PDF) is generated on a single click of a button, which has complete analysis and comparison of all available properties
Commercial Property Analysis Tool
About Client: One of the top real estate agents in London, United Kingdom. They help big brands in finding out the best property with high profitability for their shop.

About project: An excel based analysis tool was developed with following outcomes:
1. Can analyse and compare up to 5 properties based on break even analysis, profitability analysis and property cost.
2. Financial forecasting for next 10 years to get an idea about cash flows and comparison between available properties.
3. Dynamic dashboard to visualize the outcome of the analysis in charts to provide the complete picture on one page
4. Scenario analysis with three scenarios (worst, base and best) to check the feasibility of the property in case of adverse conditions.
5. An analysis report (PDF) is generated on a single click of a button, which has complete analysis and comparison of all available properties
Commercial Property Analysis Tool
About Client: One of the top real estate agents in London, United Kingdom. They help big brands in finding out the best property with high profitability for their shop.

About project: An excel based analysis tool was developed with following outcomes:
1. Can analyse and compare up to 5 properties based on break even analysis, profitability analysis and property cost.
2. Financial forecasting for next 10 years to get an idea about cash flows and comparison between available properties.
3. Dynamic dashboard to visualize the outcome of the analysis in charts to provide the complete picture on one page
4. Scenario analysis with three scenarios (worst, base and best) to check the feasibility of the property in case of adverse conditions.
5. An analysis report (PDF) is generated on a single click of a button, which has complete analysis and comparison of all available properties
Commercial Property Analysis Tool
About Client: One of the top real estate agents in London, United Kingdom. They help big brands in finding out the best property with high profitability for their shop.

About project: An excel based analysis tool was developed with following outcomes:
1. Can analyse and compare up to 5 properties based on break even analysis, profitability analysis and property cost.
2. Financial forecasting for next 10 years to get an idea about cash flows and comparison between available properties.
3. Dynamic dashboard to visualize the outcome of the analysis in charts to provide the complete picture on one page
4. Scenario analysis with three scenarios (worst, base and best) to check the feasibility of the property in case of adverse conditions.
5. An analysis report (PDF) is generated on a single click of a button, which has complete analysis and comparison of all available properties
Commercial Property Analysis Tool
About Client: One of the top real estate agents in London, United Kingdom. They help big brands in finding out the best property with high profitability for their shop.

About project: An excel based analysis tool was developed with following outcomes:
1. Can analyse and compare up to 5 properties based on break even analysis, profitability analysis and property cost.
2. Financial forecasting for next 10 years to get an idea about cash flows and comparison between available properties.
3. Dynamic dashboard to visualize the outcome of the analysis in charts to provide the complete picture on one page
4. Scenario analysis with three scenarios (worst, base and best) to check the feasibility of the property in case of adverse conditions.
5. An analysis report (PDF) is generated on a single click of a button, which has complete analysis and comparison of all available properties
Commercial Property Analysis Tool
About Client: One of the top real estate agents in London, United Kingdom. They help big brands in finding out the best property with high profitability for their shop.

About project: An excel based analysis tool was developed with following outcomes:
1. Can analyse and compare up to 5 properties based on break even analysis, profitability analysis and property cost.
2. Financial forecasting for next 10 years to get an idea about cash flows and comparison between available properties.
3. Dynamic dashboard to visualize the outcome of the analysis in charts to provide the complete picture on one page
4. Scenario analysis with three scenarios (worst, base and best) to check the feasibility of the property in case of adverse conditions.
5. An analysis report (PDF) is generated on a single click of a button, which has complete analysis and comparison of all available properties
Commercial Property Analysis Tool
About Client: One of the top real estate agents in London, United Kingdom. They help big brands in finding out the best property with high profitability for their shop.

About project: An excel based analysis tool was developed with following outcomes:
1. Can analyse and compare up to 5 properties based on break even analysis, profitability analysis and property cost.
2. Financial forecasting for next 10 years to get an idea about cash flows and comparison between available properties.
3. Dynamic dashboard to visualize the outcome of the analysis in charts to provide the complete picture on one page
4. Scenario analysis with three scenarios (worst, base and best) to check the feasibility of the property in case of adverse conditions.
5. An analysis report (PDF) is generated on a single click of a button, which has complete analysis and comparison of all available properties
Commercial Property Analysis Tool
About Client: World's leading manufacturer of escalators, moving walkways, and elevators worldwide, founded in Switzerland in 1874.

Objective: Facilitating fleet management team with smart fleet management application which can help the team in selection of best suitable vehicle as per the requirement, cost of ownership and objective of reducing the carbon footprints across the globe.

Solution: Developed a web based smart fleet management application with following features:
1. Application Can recommend the best suitable fuel type along with cars available and their details according to the requirements of business unit
2. Cost of ownership can be calculated for lease period up to 10 years, for any vehicle based on  usage of vehicle in different business units.
3. Auto recommendation for existing fleet of vehicles with new vehicles which are meeting the criteria for achieving the objective of cost and carbon footprint reduction.
4. Comparative analysis of 2 or more vehicles.
Web Based Smart Fleet application
About Client: World's leading manufacturer of escalators, moving walkways, and elevators worldwide, founded in Switzerland in 1874.

Objective: Facilitating fleet management team with smart fleet management application which can help the team in selection of best suitable vehicle as per the requirement, cost of ownership and objective of reducing the carbon footprints across the globe.

Solution: Developed a web based smart fleet management application with following features:
1. Application Can recommend the best suitable fuel type along with cars available and their details according to the requirements of business unit
2. Cost of ownership can be calculated for lease period up to 10 years, for any vehicle based on  usage of vehicle in different business units.
3. Auto recommendation for existing fleet of vehicles with new vehicles which are meeting the criteria for achieving the objective of cost and carbon footprint reduction.
4. Comparative analysis of 2 or more vehicles.
Web Based Smart Fleet application
About Client: World's leading manufacturer of escalators, moving walkways, and elevators worldwide, founded in Switzerland in 1874.

Objective: Facilitating fleet management team with smart fleet management application which can help the team in selection of best suitable vehicle as per the requirement, cost of ownership and objective of reducing the carbon footprints across the globe.

Solution: Developed a web based smart fleet management application with following features:
1. Application Can recommend the best suitable fuel type along with cars available and their details according to the requirements of business unit
2. Cost of ownership can be calculated for lease period up to 10 years, for any vehicle based on  usage of vehicle in different business units.
3. Auto recommendation for existing fleet of vehicles with new vehicles which are meeting the criteria for achieving the objective of cost and carbon footprint reduction.
4. Comparative analysis of 2 or more vehicles.
Web Based Smart Fleet application
About Client: World's leading manufacturer of escalators, moving walkways, and elevators worldwide, founded in Switzerland in 1874.

Objective: Facilitating fleet management team with smart fleet management application which can help the team in selection of best suitable vehicle as per the requirement, cost of ownership and objective of reducing the carbon footprints across the globe.

Solution: Developed a web based smart fleet management application with following features:
1. Application Can recommend the best suitable fuel type along with cars available and their details according to the requirements of business unit
2. Cost of ownership can be calculated for lease period up to 10 years, for any vehicle based on  usage of vehicle in different business units.
3. Auto recommendation for existing fleet of vehicles with new vehicles which are meeting the criteria for achieving the objective of cost and carbon footprint reduction.
4. Comparative analysis of 2 or more vehicles.
Web Based Smart Fleet application
Client ( a restaurant chain owner) wanted to have his financials forecasted for next 10 years along with the dashboard analysis
Financial forecasting and Dashboard analysis
Client ( a restaurant chain owner) wanted to have his financials forecasted for next 10 years along with the dashboard analysis
Financial forecasting and Dashboard analysis
Client ( a restaurant chain owner) wanted to have his financials forecasted for next 10 years along with the dashboard analysis
Financial forecasting and Dashboard analysis
Client wanted to have a financial model with responsive dashboard along with scenario analysis and a control panel for easy use of the model.
Financial model with dashboard and scenario analysis
Client wanted to have a financial model with responsive dashboard along with scenario analysis and a control panel for easy use of the model.
Financial model with dashboard and scenario analysis
Client wanted to have a financial model with responsive dashboard along with scenario analysis and a control panel for easy use of the model.
Financial model with dashboard and scenario analysis
Client wanted to have a financial model with responsive dashboard along with scenario analysis and a control panel for easy use of the model.
Financial model with dashboard and scenario analysis
Problem Statement: 
Client is a designing company handling many projects, and facing difficulty in managing project information including number of hours worked by different designers, their costing, weekly timelines and profit calculation of the company. He was looking for a robust excel based project management tool to have a clear visibility on projects going on.

Solution: 
Developed a google spreadsheet based project management tool, which can be worked on by many users simultaneously. It was developed by using complex spreadsheet functions and google app scripts. The tool has two section 1. Booking management - where bookings are made for each designer and summary of total hours worked on project, cost of designer, and weekly timeline is generated. 2. Project Management - Where complete summary of each project is displayed, which includes total 2d hours booked, total 3d hours booked, total costing till now of each project and weekly timeline of hours booked for each project.
Google Spreadsheet based Project Management System
Problem Statement: 
Client is a designing company handling many projects, and facing difficulty in managing project information including number of hours worked by different designers, their costing, weekly timelines and profit calculation of the company. He was looking for a robust excel based project management tool to have a clear visibility on projects going on.

Solution: 
Developed a google spreadsheet based project management tool, which can be worked on by many users simultaneously. It was developed by using complex spreadsheet functions and google app scripts. The tool has two section 1. Booking management - where bookings are made for each designer and summary of total hours worked on project, cost of designer, and weekly timeline is generated. 2. Project Management - Where complete summary of each project is displayed, which includes total 2d hours booked, total 3d hours booked, total costing till now of each project and weekly timeline of hours booked for each project.
Google Spreadsheet based Project Management System
Problem Statement: 
Client is a designing company handling many projects, and facing difficulty in managing project information including number of hours worked by different designers, their costing, weekly timelines and profit calculation of the company. He was looking for a robust excel based project management tool to have a clear visibility on projects going on.

Solution: 
Developed a google spreadsheet based project management tool, which can be worked on by many users simultaneously. It was developed by using complex spreadsheet functions and google app scripts. The tool has two section 1. Booking management - where bookings are made for each designer and summary of total hours worked on project, cost of designer, and weekly timeline is generated. 2. Project Management - Where complete summary of each project is displayed, which includes total 2d hours booked, total 3d hours booked, total costing till now of each project and weekly timeline of hours booked for each project.
Google Spreadsheet based Project Management System

Reviews

Changes saved
Showing 1 - 5 out of 50+ reviews
Filter reviews by: 5.0
€320.00 EUR
As always great job done in time! Thank you!
Visual Basic Data Processing Data Entry Excel Finance
+1 more
User Avatar
Flag of Studio V. @StudioVaroli
1 year ago
5.0
€480.00 EUR
i keep working with Bhupendra for so many projects so far! Excellent work! If happens any post issue he is always available to provide fixes and advice! Extremely professional person! Awesome!
Visual Basic Data Processing Data Entry Excel Finance
+1 more
User Avatar
Flag of Zaur B. @zaurtasty
1 year ago
5.0
€35.00 EUR
Excellent work as usually! Very satisfied and will keep hiring!
Visual Basic Data Processing Data Entry Excel Finance
+1 more
User Avatar
Flag of Studio V. @StudioVaroli
1 year ago
4.8
€1,450.00 EUR
awesome work! will continue working on other parts of the project
Accounting Business Analysis Analytics Automation
+1 more
User Avatar
Flag of Studio V. @StudioVaroli
1 year ago
5.0
€200.00 EUR
For me he is number 1 in my projects! Very professional and am happy to work with Bhupendra! It is not the fiirst project with him and I keep hiring him.
Visual Basic Data Processing Data Entry Excel Finance
+1 more
User Avatar
Flag of Studio V. @StudioVaroli
1 year ago

Experience

Business Automation consultant

EZ Services
Apr 2015 - Present
Working as a freelancer providing consultancy in business process automation, financial modeling, database management, web application development, ERP development, excel based automation tools development.

Credit Rating & Financial Modeling

Ernst & Young
Apr 2011 - Apr 2015 (4 years)
I have worked in Financial modeling, financial forecasting and analysis, credit rating, model validation and review for different MNC companies

Education

Post Graduate Program in Management

Indian Institute of Management, Indore, India 2011 - 2013
(2 years)

Contact Bhupendra Y. about your job

Log in to discuss any details over chat.

Verifications

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

Certifications

preferredfreelancer-1.png Preferred Freelancer Program SLA 1 97% us_eng_1.png US English 1 85%

Top Skills

Excel 55 Finance 18 Word 4 Financial Analysis 4 Software Architecture 3

Browse Similar Freelancers

Excel Experts in India
Excel Experts
Financial Experts
Word Experts

Browse Similar Showcases

Excel
Finance
Word
Financial Analysis
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection
Loading preview