Rithik Gujar

Rithik Gujar

Marketing and sales manager at vishwapreneur '20

Followers of Rithik Gujar2000 followers
location of Rithik GujarGreater Chicago Area

Connect with Rithik Gujar to Send Message

Connect

Connect with Rithik Gujar to Send Message

Connect
  • Timeline

  • About me

    Data Analyst @ KU | Ex-BSA Intern @ Odoo | MIS‘24 @UniversityAtBuffalo | SQL | Python | PowerBi | Tableau | ETL

  • Education

    • Vishwakarma Institute of Information Technology

      2017 - 2021
      Bachelor of Technology - BTech Computer Engineering CGPA 9.2/10.0
    • University at Buffalo

      2023 - 2024
      Master of Science - MS Management Information Systems, General GPA 3.89/4.00

      Courses: Data Warehousing, Data Visualisation, Healthcare Analytics, Predictive Analytics.

  • Experience

    • Entrepreneurship Development Cell, VIIT

      Oct 2019 - Mar 2020
      Marketing and sales manager at vishwapreneur '20
    • Entrepreneurship Development Cell, VIIT

      Aug 2020 - Jun 2021
      Member Of The Board Of Advisors
    • TATA MEMORIAL HOSPITAL

      Jan 2021 - May 2021
      Business Analyst Intern

      1. Boosted profitability by 10% by developing data models, process flows, and Power BI dashboards(DAX) ), streamlining database management processes, and improving product strategy and strategic direction2. Engineered and executed big data statistical analyses on extensive unstructured datasets, generating valuable clinical insights that informed and optimized product roadmaps and vendor relationship management3. Performed intermediate data analysis by leveraging SQL queries, MS Excel and Python to eliminate report issues and discrepancies, resulting in reduction of data duplication and inefficiencies Show less

    • LTIMindtree

      Jun 2021 - May 2023

      1. Collaborated with data engineers, project managers and cross-functional teams to provide recommendations, leading to enhanced speed of feature development life cycle by 25% year over year by creating interactive Power BI dashboards and reports2. Developed and implemented 50+ complex SQL queries to generate financial bi-weekly and quarterly reports for clients across APAC, EMEA and NAM, reducing report generation time by 15%3. Responded to regular ad hoc requests from 10+ applications and designed and implemented reporting solutions using SQL server reporting service (SSRS), enabling stakeholders to drive data-driven decisions4. Directed structured tracking of key performance indicators(KPIs), mentored 23+ team members on automation and data analysis and effectively implemented data quality and integrity plans across multiple Agile sprints across 3 client divisions5. Determined and developed user requirements for systems in production, to ensure maximum usability6. Prepared routine reports quality, production, customer service, operational efficiency and trend analysis for upper leadership Show less

      • Data/Business Analyst

        Oct 2021 - May 2023
      • Analytics Engineer

        Jun 2021 - Sept 2021
    • GrowthSchool

      May 2023 - Jun 2023
      Student

      Obtained Power BI Certification-The Power BI certification validates my expertise in utilizing Microsoft Power BI, a powerful business intelligence tool. Through this certification, I have demonstrated proficiency in transforming raw data into insightful visualizations and interactive reports. I have gained a comprehensive understanding of Power BI's functionalities, such as data modelling, data visualization, and data analysis. This certification showcases my ability to leverage Power BI's features to analyse and present complex data in a visually compelling and meaningful manner, enabling data-driven decision-making for organizations. Show less

    • Odoo

      Oct 2023 - May 2024
      Data/Business Analyst Intern

      1. Implemented CRM Odoo Success Pack to improve business acumen among clients and to facilitate timely delivery of business requirements, reducing client support queries related to system navigation and functionality2. Leveraged MySQL and Pandas Python library to clean and import unstructured client dataset into Odoo Compatible framework, ensuring data integrity and compatibility with ERP system3. Curated 10+ custom dashboards in Tableau according to clients business processes, allowing monitoring of operational efficiency, business objectives and 5+ sales KPIs, enabling informed decision-making and driving business growth4. Efficiently allocated 70-80% of time to client billable tasks, identifying and establishing scope and parameters of requirements analysis on project-by-project basis to define project impact, outcome criteria, and metrics Show less

    • The University of Kansas

      Jul 2024 - now
      Data & Market Analyst
  • Licenses & Certifications