Vaibhav Sutar

• Developed interactive dashboards and reports using Power BI to visualize key performance metrics and trends.
• Implemented data models in Power BI Desktop to transform raw data into meaningful insights.
• Collaborated with cross-functional teams to gather requirements and deliver actionable insights through data visualization.
• Utilized DAX expressions to create calculated columns, measures, and calculated tables to support complex business logic.
• Conducted data analysis to identify trends, patterns, and outliers, providing insights to stakeholders for informed decision-making.
• Conducted user training sessions to improve Power BI adoption and empower users to create their own reports.
• Worked closely with IT teams to optimize data connections and improve data refresh performance.

Preparing excel VBA automations apps as per business requirements. Providing technical support to app users Based in UK

Roles and Responsibilities:

• Understanding the requirement and analyzing data from BA

• Creating excel apps based on VBA automation

• Providing support to users in UK

• Creating internal macros as per requirements.

Preparing excel dashboards as per requirements to help leads take decisions. The raw data consists of technicians who work in US, their rates, hours, location etc. Also applying excel-vba automation in excel dashboards and optimizing the report and reducing manual effort.

Roles and Responsibilities:

• Understanding the requirement and analyzing data.

• Submitting bills to client’s system.

• Validating data.

• Preparing dashboard on weekly basis.

• Creating macros as per requirements.

Preparing tariffs for US Import/Export rates of “Ocean Freight Rates”, “Inland Rates” for shipments coming from across the world to US (Import). Handling around 800+ customers’ tariffs for 7 trade lanes (e.g. EMEA, LATAM, AUSNZ, Middle-East etc.) across the world.

Roles and Responsibilities:

• Understanding the requirement and analyzing Ocean Freight Rates, Inland Rates to prepare tariffs using Advanced Excel formulae’s, VLOOKUP, SUMFIF, COUNTIF, MATCH, INDEX, PIVOT TABLE, VBA Macros, CONDITIONAL FORMATTING, DASHBOARDS, CHARTS etc.

• Communicating with the Stakeholders all over the world for submitting rates through Email.

• Validating rates submitted by offices resolving issues related to rates using mail.

• Preparing tariffs on monthly, quarterly basis using MS Excel.

• Uploading rates into online portal.

Created macros at Shipco IT Pvt Ltd as per process requirement.

Project Description:

Quovant is the next generation in legal management services and technology designed to optimize corporate legal, claims and risk management departments.

Roles and Responsibilities:

• Understanding the requirement and analyzing the expenses to prepare reports using MS Excel.

Validating raw data and correcting errors to submit to Database using MS Excel Contacting offices through Email for resolving issues related to rates, data etc.

• Using Business Intelligence Suite (BI Suite.

• Using advanced excel formulae’s, VLOOKUP, SUMFIF, COUNTIF, MATCH, INDEX, PIVOT TABLE, VBA Macros, CONDITIONAL FORMATTING, DASHBOARDS, CHARTS etc. Editing raw reports and preparing final report using word, excel and pdf. Review of reports and submitting suggestions to US team.

Project Description:

The Light App is an answering engine mobile application. It answers all types of questions through app. It serves as an answering engine for all questions you have.

Roles and Responsibilities:

• Prepared reports for performance of app, users by using advanced excel formulae’s, VLOOKUP, SUMFIF, COUNTIF, MATCH, INDEX, PIVOT TABLE, VBA Macros, CONDITIONAL FORMATTING, DASHBOARDS, CHARTS etc.

• Providing suitable answers to queries for customers by primary and secondary search

• Executing Test Cases and create Defect Logs Involved in Manual Testing of applications

Reviewing answers provided by others. Handled team of 10 people

Project Description:

• Gathering data from internet by primary research and secondary research. Maintaining and sorting data using excel. Submitting the data for further process after review. Supporting SEO work like Social media marketing, email marketing, tagging, creating blogs and Word Press websites etc.

Roles and Responsibilities:

• Gathered data and maintained it using by using advanced excel formulae’s, VLOOKUP, SUMFIF, COUNTIF, MATCH, INDEX, CONDITIONAL FORMATTING etc. for support required for SEO.

• Searching internet by using primary and secondary searches.

• Created blogs and handled queries related to broadband internet.

Project Description:

• Supporting broadband related queries of customers

Roles and Responsibilities:

• Resolving queries related to broadband.

• Helping customers to setup new connection.

• Maintaining customer database in excel.