VATSAL PATEL
Vadodara
Summary
Dynamic Vendor Coordinator and VBA Developer at Tata Consultancy Services, adept at enhancing vendor relationships and optimizing performance through strategic analysis and effective communication. Proven expertise in data visualization and project management, driving impactful solutions that elevate operational efficiency and foster collaboration across teams.
Overview
12
12
years of professional experience
Work History
Vendor Coordinator & VBA Developer
Tata Consultancy Services
10.2021 - Current
- Company Overview: Deutsche bank
- As a Vendor Coordinator I am responsible for managing and optimizing relationships between a company and its vendors.
- Act as a strategic advisor for both parties to improve performance, processes, and customer experience.
- Develop and execute strategic account plans to meet key business opportunities and vendor performance.
- Establish and maintain clear communication channels, manage expectations, and provide regular performance updates to vendors.
- Analyze vendor performance data, conduct root cause analysis on issues, and provide data-driven recommendations.
- Establish and maintain clear communication channels, manage expectations, and provide regular performance updates to vendors.
- Also, by using my knowledge of VBA, I have created several tools to track vendors' activity and get a summary of each contract.
- Coordinated vendor relationships to ensure timely delivery of products and services.
- Communicated regularly with vendors regarding order changes or cancellations as needed.
- Coordinated business requirements with vendors and located new vendors for specialty requirements.
- Developed strong relationships with vendors to understand their needs and negotiate terms of service.
- Managed vendor contracts and negotiated terms for optimal performance.
- Facilitated communication between vendors and internal teams to resolve issues.
- Organized vendor meetings to discuss updates and changes in policies.
- Maintained accurate records of vendor agreements and compliance documents.
- Coached team on company policies, procedures and best practices to enhance operational efficiency and employee productivity.
- Developed and maintained vendor performance evaluation systems for quality assurance.
Data Analyst
Tata Consultancy Services
05.2013 - 09.2021
- Company Overview: NIQ.
- While working as an SME and data analyst, we need to work on real-time, historical data.
- Collecting data from different sources, there might be a mixture of data formats available, which we standardized for the next step.
- Utilization of tools and skills during this process: Excel, Excel VBA, and SAS-based tools.
- Price and promotion sensitivity analysis and measure the impact of change in strategy on the brand, cross-comparison with competitors, as well as measuring the cannibalization impact on a particular brand.
- We used to showcase a full analysis in a client convenience format.
- Utilization of tools and skills during this process: PowerPoint, Tableau, Power BI, and a custom pre-built visual interface (Nielsen Interface).
- Collaborated with cross-functional teams to define data requirements and specifications.
- Automated reporting processes to streamline workflows and improve efficiency.
- Analyzed complex datasets to identify trends and patterns for client projects.
- Assisted in training junior analysts on best practices for data analysis techniques.
- Engaged with clients to gather feedback and refine analytical solutions based on needs.
- Collected, tracked and reviewed data to evaluate business and market trends.
- Worked closely with management to prioritize business and information needs.
- Collaborated with cross-functional teams to prioritize business and information needs.
- Performed data entry, data cleaning, and data coding for analysis.
- Assessed the effectiveness and accuracy of new data sources and data gathering techniques.
Education
Master of Business - Administation
PARUL UNIVERSITY
Vadodara ,Gujarat05-2012
Bachelor of Business - Administration
S P UNIVERSITY
V V Nagar , Gujarat04-2010
Skills
- Project management
- Teamwork
- Leadership
- Effective communication
- Critical thinking
- Quick learner
- VBA programming
- Data visualization
- Team coaching
Timeline
Vendor Coordinator & VBA Developer
Tata Consultancy Services
10.2021 - Current
Data Analyst
Tata Consultancy Services
05.2013 - 09.2021
Master of Business - Administation
PARUL UNIVERSITY
Bachelor of Business - Administration
S P UNIVERSITY