Viswanath M
Bangalore
Summary
To secure a dynamic position in a professionally challenging environment where my technical and analytical skills will be utilized to the utmost level and provides enough scope to explore my knowledge to serve the organization to the best of my ability and skills.
Having around 9.4 yrs. of extensive experience in MIS reporting and Pricing & Data Analysis by using Advance Excel and Spread Sheets(Google sheets), PowerBI and SQL.
Overview
10
10
years of professional experience
Work History
Senior Manager pricing and Analytics
Gourmet Garden Pvt Ltd
Bangalore
08.2023 - 08.2025
- Company Overview: Gourmet Garden is home to the purest, freshest, and finest tasting veggies, grown with great care in protected zero contamination environments. Contamination free food is very difficult to come by. While organic farming has contained pesticide contamination, there are other sorts including soil borne diseases, water contamination, and poor handling through supply chain, all of which make our food less safe and unsuitable for consumption. Further, the food today has limited nutrition and flavour owing to genetic treatment of seeds and inefficient farming practices. At Gourmet Garden, our promise is to provide the freshest, zero contamination leafies and veggies, that are full of flavour and nutrition so you enjoy your healthy meal!
- Preparing and analyzing the data Daily / Monthly / Yearly - Sales reports by using Excel and spread sheets.
- Preparing live inventory report and sharing to inventory team.
- Preparing and analyzing the Return analysis reports by using Excel and power point tools.
- Preparing Inventory error logs report and checking the options are listed or not.
- Preparing farms wise P&L reports received & dispatched data.
- Daily checking selling prices and cost prices and updating the trackers.
- Daily pricing update as per competition prices & checking the sales analysis.
- Farm seeding plan & harvest plan & targets creating and sharing to farm managers, tracking daily.
- Discounts data checking and planning discounts on every day & updating the prices.
- Daily sharing Farm Forecast to all sales team & GRN data checking for tracking Cost price.
- Gourmet Garden is home to the purest, freshest, and finest tasting veggies, grown with great care in protected zero contamination environments. Contamination free food is very difficult to come by. While organic farming has contained pesticide contamination, there are other sorts including soil borne diseases, water contamination, and poor handling through supply chain, all of which make our food less safe and unsuitable for consumption. Further, the food today has limited nutrition and flavour owing to genetic treatment of seeds and inefficient farming practices. At Gourmet Garden, our promise is to provide the freshest, zero contamination leafies and veggies, that are full of flavour and nutrition so you enjoy your healthy meal!
Assistant Manager(MIS)
Dealshare Pvt Ltd
Bangalore
11.2021 - 08.2023
- Company Overview: Dealshare is a social e-commerce and an online buying platform for multi-category consumer products, focused on the new 'WhatsApp first' India. Its mission is to target the new 500Mn users in nonmetro and rural markets who haven't shopped enough online and who are still not comfortable on other platforms. These users are primarily on mobile and social media. Deal Share's Product catalog includes fruits & vegetables, grocery items, beauty & wellness, baby care, fashion accessories, electronics, home décor, etc.
- Dealshare is a social e-commerce and an online buying platform for multi-category consumer products, focused on the new 'WhatsApp first' India. Its mission is to target the new 500Mn users in nonmetro and rural markets who haven't shopped enough online and who are still not comfortable on other platforms. These users are primarily on mobile and social media. Deal Share's Product catalog includes fruits & vegetables, grocery items, beauty & wellness, baby care, fashion accessories, electronics, home décor, etc.
Assistant Manager(MIS)
Westbury Holdings Private Limited
Bangalore
07.2021 - 11.2021
- Company Overview: Westbury Kommerce (Westbury Holdings Pvt Ltd) was set up as an Online Retail Business and Solution provider for Brands, with an end-to-end integrated business solution for B2C eCommerce & Omnichannel. We provide seamless integration of technology, sales, merchandise, operations, and supply chain management to enable brands to manage their eCommerce business - including the brand's own websites, Omni Channel solutions, retail store integration, and marketplace integration.
- Preparing and analyzing the Inventory reco reports by using Excel and power point tools.
- Preparing options live report and analyzing the data.
- Preparing and analyzing the Return analysis reports by using Excel and power point tools.
- Preparing Inventory error logs report and checking the options are listed or not.
- Preparing World wise and brand wise the reports by using the Excel functions.
- Westbury Kommerce (Westbury Holdings Pvt Ltd) was set up as an Online Retail Business and Solution provider for Brands, with an end-to-end integrated business solution for B2C eCommerce & Omnichannel. We provide seamless integration of technology, sales, merchandise, operations, and supply chain management to enable brands to manage their eCommerce business - including the brand's own websites, Omni Channel solutions, retail store integration, and marketplace integration.
Data Analyst
10i Commerce Services Pvt Ltd (ShopX)
Bangalore
01.2019 - 04.2020
- Company Overview: SHOPX is a Retail Operating system, where Brands, Retailers, and Consumers are connected. Our state of the art technology can manage over 5, 00,000 transactions per day and powers a deeply integrated supply chain. SHOPX offers a wide range of products in categories such as FMCG, mobile phones, and accessories.
- Retailers are having two categories one is Mobile category and another one is FMCG (general stores).
- If retailer is performing well and good with the business then will give credit option.
- Reporting Weekly/Monthly/Quarterly reports to Management.
- Default reports and Weekly and Daily Wise report.
- Retailer performance report based on Business and transactions and Due payment paid.
- Credit Enhancement report for Good Retailers.
- Visits assigned to TSI in yardstick application for Payment collections.
- Retailers documents uploading in smart app.
- Generating the KPI Reports based on retailers wise.
- Maintaining Team Attendance and sending monthly Attendance to HR.
- Preparing Daily EOD Report for Team.
- Creating the Reports by using Excel functions like.( Lookups and Pivots and sumif , sumifs ,Counif , countifs )
- Creating Reports and Data Analysis by using Raw data.
- Incentive report for TSI(Collection Executives).
- SHOPX is a Retail Operating system, where Brands, Retailers, and Consumers are connected. Our state of the art technology can manage over 5, 00,000 transactions per day and powers a deeply integrated supply chain. SHOPX offers a wide range of products in categories such as FMCG, mobile phones, and accessories.
MIS Executive
Medybiz Pharma Pvt Ltd
Bangalore
01.2017 - 01.2019
- Company Overview: Medybiz Pharma is providing pharma companies with specialized distribution, prescription refill, therapy compliance support for super specialty medicines that require highly specialized handling & adherence protocols.
- Getting the customers requested data through the central CRM tool and this tool can receive the different customers information through the web/SMS and physical couriers.
- I Downloading the data from Central CRM tools. Post that we are cleaning the data like excluding the duplicate records. Etc. using the excel techniques.
- Next step would be Data processing and formatting as per the type of customer request.
- Assign or send the formatted data to different agents based on the customer request.
- Post agent's discussion with customers, Agents will send back the feedback data with our team.
- According to customer positive response will generate the reports on Weekly/ Monthly/Quarterly sales Reports.
- Creating the Reports by using Excel functions like..( Vlookup and Pivots and sumif , sumifs ,Counif , countifs )
- Creating Reports and Data Analysis by using Raw data.
- Preparing the KPI and TAT /Agent login Summary and Utilization Reports and Downtime Reports and Sales Team Reports.
- Creating PowerPoint presentation by using Data Analysis.
- Maintaining Team Attendance and sending monthly Attendance to HR.
- Preparing Daily EOD Report for Team.
- Medybiz Pharma is providing pharma companies with specialized distribution, prescription refill, therapy compliance support for super specialty medicines that require highly specialized handling & adherence protocols.
MIS Executive
ANI Technologies Pvt Ltd(OLA cabs)
Bangalore
04.2015 - 10.2016
- Company Overview: We are developing the business of Ola cabs. Ola cabs are having different cabs are Ola micro, Olamine, Ola share and Ola prime, Ola rentals and Ola out station.
- Preparing Revenue Report, Idle Time Report with Competitor data.
- Daily progress with quantity reporting system & thereby resulting in a weekly & Monthly &Quarterly.
- Preparing Ad-hoc reports send to management.
- Generating Monthly Reports and comparison of various Schemes of Competitors.
- Maintaining Team Attendance and sending monthly Attendance to HR.
- Daily Preparing Other Reports (Acceptance Rate, Trips Bucket, Incentives) based on Management requirement.
- Preparing Daily EOD Report for Team.
- Utilization Reports and Cab Distance Reports.
- Incentive Reports and Trips Reports and Cabs Type Wise Reports.
- We are developing the business of Ola cabs. Ola cabs are having different cabs are Ola micro, Olamine, Ola share and Ola prime, Ola rentals and Ola out station.
Education
B. Tech - Mechanical Engineering
Sri Krishnadevaraya Engineering College
GootySkills
- Advanced Excel
- PowerPoint
- Google Sheets
- SQL
- PowerBI
- MIS
- MS-Office
- Creating KPI Reports
- Pivot tables
- Charts
- Functions
- Advanced filters
- Creating KPI and trend by using advanced Excel
- Creating complex reports/dashboards
- CRM tool
- Meta base
- Multiple automation
- Knowledge of Power BI
- WINDOWS 9x/NT/2000
- UNIX
- MS-DOS
Projects
Gourmet Garden Pvt Ltd (Ekam Ultra Farms), Pricing and Analytics, Advanced Excel, Spreadsheets, PowerPoint, PowerBI, SQL, Senior Manager (MIS), Gourmet Garden is home to the purest, freshest, and finest tasting veggies, grown with great care in protected zero contamination environments., Preparing and analyzing daily/monthly/yearly sales reports using Excel, Preparing live inventory report and sharing with inventory team, Preparing and analyzing return analysis reports using Excel and PowerPoint, Preparing inventory error logs report, Preparing farms wise P&L reports, Daily checking selling prices and cost prices, Daily pricing update as per competition prices, Farm seeding plan & harvest plan creation, Discounts data checking and planning, Daily sharing farm forecast with sales team Dealshare Private Limited, Pricing Team, Advanced Excel, Spreadsheets, PowerPoint, Redash, PowerBI, SQL, Assistant Manager (MIS), Dealshare is a social e-commerce platform focused on non-metro and rural markets. Westbury Holdings Private Limited, Sales, Advanced Excel, Spreadsheets, PowerPoint, Assistant Manager (MIS), Westbury Kommerce provides end-to-end integrated business solutions for B2C eCommerce. 10i Commerce Services Pvt Ltd (ShopX), Customer Credit, Advanced Excel, Spreadsheets, PowerPoint, MIS, Data Analyst, SHOPX is a Retail Operating system connecting brands, retailers, and consumers. Medybiz Pharma Pvt Ltd, Diabetics Management Program (Merck Sharp & Dohme) data process, Advanced Excel, Spreadsheets, PowerPoint, MIS Executive, Medybiz Pharma provides specialized distribution and therapy compliance support. ANI Technologies Pvt Ltd (OLA Cabs), Daily/Weekly/Monthly Cabs performance Dashboard, Advanced Excel, Spreadsheets, MIS Executive, Developing the business of Ola cabs.
Languages
- English
- Telugu
Personal Information
- Date of Birth: 06/07/90
- Marital Status: Married
Timeline
Senior Manager pricing and Analytics
Gourmet Garden Pvt Ltd
08.2023 - 08.2025
Assistant Manager(MIS)
Dealshare Pvt Ltd
11.2021 - 08.2023
Assistant Manager(MIS)
Westbury Holdings Private Limited
07.2021 - 11.2021
Data Analyst
10i Commerce Services Pvt Ltd (ShopX)
01.2019 - 04.2020
MIS Executive
Medybiz Pharma Pvt Ltd
01.2017 - 01.2019
MIS Executive
ANI Technologies Pvt Ltd(OLA cabs)
04.2015 - 10.2016
B. Tech - Mechanical Engineering
Sri Krishnadevaraya Engineering College