I am Ruby Gunna, a certified Google Data Analyst and a Supply Chain Specialist with 3 years of experience in multi-million-dollar procurement projects across the Energy and Petrochemical sectors I hold an MBA in consulting and strategic management from the University of British Columbia, Canada, and I have a strong background in technology as a Software Engineer at IBM and WIPRO, India early in my career. I am a Canadian citizen living in NJ,USA. I am looking for Data Analyst/ Data Engineering roles. I enjoy using data to foster growth and enhance supply chain performance. But that’s not the only thing I can do, my skills are versatile and adaptable to various industries. I use SQL, Tableau, Excel, and Alteryx to prep, clean, analyze and visualize data.

• A data mining project that analyzes the Google Apps Store dataset to find the relationship between app downloads and rating and other attributes using PowerBI.
• A Business Inteliigence project that leverages PowerBI Desktop and various inbuilt ML algorithms to forecast the customer lifetime value for an Auto Insurance Company.
• A project that uses Power BI to create a dashboard for sales management and analysis using Amazon E-commerce Sales dataset.

• ETL/ELT data pipelines using Microsoft Azure Data Factory, Azure Data Bricks
• Performance optimization of Data pipelines in Databricks and Azure DataFactory
• Advanced DAX in Power BI

• Tools Used: Alteryx

• Implemented three-phase data analysis workflow in Alteryx

• Improved project efficiency by 30% and reduced development time by 25%

• Tools Used: Tableau

• Designed strategy for 10% increase in test completion rate

• Visualized critical factors in Tableau for improved user engagement

• Tools Used: SQL (MySQL Workbench 8.0)

• Extracted key sales insights for a 45-store retail chain

• Identified strategies for a 12% holiday revenue boost

• Tools Used: Tableau Public,R, Canva

• Analyzed bike-sharing data for usage patterns

• Increased conversion rate by 25% through targeted marketing strategies

• Anything related to SQL, Tableau, Alteryx, Excel, especially SQL Challenges and how to showcase them
• My hobbies and interests, such as content creation , Toastmasters club for Public speaking

• Email: [email protected]
• LinkedIn: Roopmathi

• Alteryx
• Azure Data Factory
• Databricks
• SQL
• SnowFlake
• Tableau
• PowerBI
• Excel
• GitHub