Vishva Pandya
Oakville,ON
Summary
Accomplished Business Analyst with over five years of experience in converting business needs into robust technical solutions across various sectors. Proficient in advanced data analytics tools such as Power BI, Tableau, Domo, and SQL enhancing data-driven decision-making and organizational performance. Proven success in collaborating with cross-functional teams and utilizing Agile and Waterfall methodologies to manage complete project lifecycles, improving workflows by up to 15%. Adept in aligning business objectives with strategic execution through stakeholder engagement and precise requirement analysis. Currently pursuing a Domo Specialist certification to deepen expertise in business intelligence technologies.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
1
1
Certification
Work History
Reporting and Data Analyst
Concentrix
01.2022 - Current
- Dashboard Development: Led the creation of interactive dashboards using advanced techniques in Power BI, Tableau, and Domo, significantly enhancing data visualization. This enabled stakeholders to easily access and interpret complex data, leading to more informed and timely decision-making.
- Data Modeling and Optimization: Developed and implemented star and snowflake schema cubes, utilizing dimensions, measures, and DAX queries. Enhanced database structure by designing tables, relationships, and optimizing SQL queries and stored procedures
- Collaborative Reporting: Worked closely with stakeholders to interpret data insights, delivering actionable recommendations that led to a 20% improvement in key performance indicators year-over-year.
- SQL Automation: Utilized SQL to automate the data collection process, achieving a 100% reduction in data collection time and significantly boosting team productivity.
- Ad Hoc Analysis and Insights: Conducted detailed ad hoc analyses utilizing data modeling and trend analysis techniques to identify strategic business opportunities and challenges, thereby directly informing strategy optimization and enhancing business outcomes.
Technical Support Advisor
Concentrix
03.2021 - 12.2021
- Provided technical support for Apple OS and devices, resolving complex issues across iPhone, Mac, and iPad, reducing average resolution time by 30%.
- Efficient Problem Solving: Applied multitasking and rapid problem-solving skills, resulting in a 20% increase in customer satisfaction scores.
- CRM Tools: Managed over 100 customer interactions weekly using CRM software, ensuring 95% issue resolution on first contact.
- Collaboration and Knowledge Sharing: Created technical guides that reduced team onboarding time by 25% and collaborated cross-functionally to improve support quality.
Technical Business Analyst
Klippers
09.2019 - 06.2020
- Data Reporting: Leveraged Tableau and Power BI for advanced business reporting, enhancing data-driven decision-making processes.
- SQL Expertise: Executed complex data analyses with SQL, improving data retrieval efficiency by 20%.
- Data Preparation and Analysis: Utilized Python and R to refine data preparation processes, enhancing analysis speed and accuracy.
- Requirements and Testing: Developed detailed business requirements and executed rigorous test cases, reducing system defects by 15%.
- Agile Delivery: Implemented agile methodologies to adapt swiftly to project changes, boosting project delivery timelines by 10%.
Business Analyst
Scube Technologies
05.2016 - 12.2017
- Developed technical documentation including business requirements, functional specifications, support documentation, user guides; created use cases, use case diagrams, activity diagrams, state diagrams based on UML Methodology and business process workflow diagrams.
- Provided technical specifications, QA test plans, status reports , budget and timeline estimates.
- Performed functional analysis of the client’s current business process and reviewed supporting documentation.
- Monitored client deliverables and ensured deliverables deadlines meet scheduled completion dates.
- Collaborated with the QA team to develop robust use cases, test plans, and scripts, ensuring compliance with company quality standards and reducing defect rates by 25%.
Education
Information System Business Analysis
George Brown College
Toronto, ON 01.2019 - 12.2019
Master of Science - Project Management
Durham College
Oshawa, ON 01.2018 - 12.2018
Bachelor of Science - Information Technology Engineering
Gujarat Technological University
Ahmedabad, Gujarat, India 05.2012 - 05.2016
Skills
- Data Analysis & Visualization:Proficient in Power BI, Tableau, Domo for creating interactive dashboards
Advanced SQL skills for data querying, analysis, and automation of data processes
Experience with data modeling techniques such as star and snowflake schemas - Programming:Skilled in Python and R for data preparation and advanced analytics
- Project Management:Experienced with Agile and Waterfall methodologies for comprehensive project lifecycle management
- Technical Proficiency:Expertise in data-driven strategy development
Proficient with CRM tools and systems to enhance customer interactions and data integrity
Certification
Domo Professional Certified
Timeline
Domo Professional Certified
10-2023
Reporting and Data Analyst
Concentrix
01.2022 - Current
Technical Support Advisor
Concentrix
03.2021 - 12.2021
Technical Business Analyst
Klippers
09.2019 - 06.2020
Information System Business Analysis
George Brown College
01.2019 - 12.2019
Master of Science - Project Management
Durham College
01.2018 - 12.2018
Business Analyst
Scube Technologies
05.2016 - 12.2017
Bachelor of Science - Information Technology Engineering
Gujarat Technological University
05.2012 - 05.2016
Similar Profiles
Sandile Marvellous NtombelaSandile Marvellous Ntombela
Team Coach at ConcentrixTeam Coach at Concentrix
Priyanka DasPriyanka Das
Team Leader at ConcentrixTeam Leader at Concentrix
AKASH BISHTAKASH BISHT
Senior Advisor at ConcentrixSenior Advisor at Concentrix