Viswanathan R. Profile

EXPLORE

5.0

(44 reviews)

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

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$20 USD / hour

bangalore,

india

$20 USD / hour

It's currently 10:28 PM here

Joined March 29, 2008

0 Recommendations

Viswanathan R.

@edatawiz

5.0

(44 reviews)

5.4

100%

$20 USD / hour

bangalore,

india

$20 USD / hour

98%

Jobs Completed

100%

On Budget

100%

On Time

15%

Repeat Hire Rate

Data Enthusiast: Excel | Python | Data Automation

Welcome to my portfolio! I'm Vishy, also known as Viswa, a seasoned Excel and Data Automation Specialist. My expertise includes: • Automating Excel tasks and designing sophisticated Dashboards. • Tailoring Google Sheets and dashboards to meet your specific needs. • Harnessing the power of Python alongside BS4, Requests, and Selenium for Web Scraping. • Integrating Python for General Scripting to optimize your data workflows seamlessly. Through my engagement with communities and utilization of AI technology, I've honed my professional capabilities significantly. I remain committed to ongoing improvement, consistently exploring new avenues for advancement and innovation. I'm ready to enhance your data workflow and help you unlock the full potential of your data. Let's collaborate to turn your data challenges into opportunities for success. Have a wonderful day !

See all Excel Experts in India

Contact Viswanathan R. about your job

Portfolio

Quick Dashboard using Google Sheets new formulas, Charts and Pivots

Note: This is only a sample data to show how it would look. The number and count may vary with actual figures.

Sales Processing ! Google Sheets

Features:

One for daily claim uploads:

A macro will run and examine about 19 columns to see if they require any updating. If so, it will log the updates and update them to a different page with the claims number so that it can be verified at all times.
Will add to the consolidated sheet if the claim is not present.
Claims that do not match will be deleted from the combined sheet.

Extra options: Data validation and drop-down menus are included to prevent errors during human entry. Every item will be tagged according to specific criteria, and the comment section will be updated by formulae and macros with the appropriate steps to finish the process.

Dashboard:

There will be a summary of the claims that are pending and ongoing. Here is an example screenshot (the number will display dummy values because this is only an example).

Claim Management System

A performance dashboard for project management was the goal of the project. To create a real-time update to the summary, Excel macros, pivot tables, and pivot charts are all employed.

To visualize the development, key metrics like Actual Vs. Expected completion and Yet to Recover Vs. Revenue are displayed on a trend line chart.

Project Performance Dashboard

This VBA takes as input a folder containing all of the csv files that record the delivery of data for each day, then computes a ratio for the month Max to Min, and then plots the results on a graphs. You can compare two symbols also. The drop-down, charts are automatically populated.

Attached is a sample screenshot.

Portfolio Comparison and Analysis

10822896

The project was to automate the creation of serial number based on inputs. The Excel sheet had to be automated using Forms to avoid manual errors and to speed up the process.

Excel Form - Serial Number Automation

A sample sales dashboard covering key parameters to be measured.

Sample Quick Sales Dashboard

Sales Processing ! Google Sheets

Claim Management System

Project Performance Dashboard

Portfolio Comparison and Analysis

10822896

Excel Form - Serial Number Automation

Sample Quick Sales Dashboard

Reviews

Changes saved

Showing 1 - 5 out of 44 reviews

Filter reviews by:

5.0

₹1,500.00 INR

Excel Dashboard -- 2

It was a pleasure to work with Vishwanathan and a smooth experience. He was proactive in both execution and thought process and worked well basis high level scope shared. He also was open to incorporating feedback and change requests at a short notice.

Excel

Microsoft PowerBI

Praveen K.

@pkumar0080

•

1 year ago

5.0

$70.00 USD

Google sheet expert with formulas for basic project

The guy went beyond the scope Definitely hire him again

Edgar S.

@Lvtn2099

•

1 year ago

5.0

₹600.00 INR

CORRECTION_SHEET_GENERATOR

He delivered the my task before time and his coordination is outstanding. He is one of the best freelancer i have worked with till now.

PHP

Visual Basic

Excel

Software Architecture

Visual Basic for Apps

Shuvam D.

@Shuvam9

•

1 year ago

5.0

$10.00 NZD

Power BI Pro

Really good what he do.

Amit S.

@ammyshro1495

•

1 year ago

5.0

£12.40 GBP

Help with a formula.

Viswanathan solved my problem really quickly. His responses were fast and professional. Will definitely go back to him directly next time I need help with a formula. Recommended.