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: roopmathi@gmail.com
- LinkedIn: Roopmathi
- Alteryx
- Azure Data Factory
- Databricks
- SQL
- SnowFlake
- Tableau
- PowerBI
- Excel
- GitHub