Kenil Patwa

Experience

• 

  1DigitalStack.ai

  Jan 2023 - Jun 2023

  Business Analyst

  1. Data Management and Automation: - Led data extraction using Keystone and Metabase, ensuring ETL processes for clean data transfer. - Automated data retrieval and reporting using Python and SQL, enhancing operational efficiency. - Applied advanced techniques, including ChatGPT, for accurate brand mapping and improved categorization.2. Quality Assurance and Database Management - Conducted rigorous quality checks on database tables, addressing crawler failures proactively. - Used ChatGPT integration for precise brand mapping, contributing to enhanced data reliability.3. Client Reporting and Analytical Insights - Compiled 100+ Daily Availability Reports, offering clients a comprehensive overview of product availability. - Developed Month-to-Date Availability Reports and summary sheets for strategic decision-making.4. Python and Power BI Integration: - Explored Python visual capabilities in Power BI, creating market share and sunburst visuals. - Demonstrated expertise in Python, contributing to advanced visualizations for data-driven insights.5. Automation and Python Proficiency: - Automated quality checks, implemented scoring mechanisms, and automated product feature mapping using Python. - Integrated ChatGPT for context-aware feature mapping, contributing to enhanced accuracy. - Generated 100+ client reports, actively supporting data-driven decision-making. Show less

• 

  Rutgers University

  Oct 2023 - now

  - As a Graduate Student Researcher Assistant, I contributed to a project focused on data-driven insights and happiness index analysis for Cali, Colombia, under Dr. Adam Okulicz-Kozaryn's supervision at Rutgers University, Camden.- Utilized statistical techniques to find regression models, correlations, and associations between socioeconomic factors and happiness outcomes.- Created and executed a linear regression machine learning model to examine and forecast happiness outcomes.

  • Graduate Teaching Assistant

    Sept 2024 - now

  • Student Mentor

    Oct 2023 - Aug 2024

  • Graduate Student Researcher

    Oct 2023 - May 2024
• 

  Trackmind

  Sept 2024 - now

  Data Science Intern (Direct-Client: Johnson & Johnson)

  1. Accelerated Power BI dashboard data refresh processes using SQL and Python, improving operational efficiency by 90% and reducing decision-making time by 50%.2. Investigated alerts using Nexthink NQL and PowerBI to enhance the end-user experience, identifying 30% of devices responsible for 85% of issues through data analysis and correlation.3. Created and configured Nexthink alerts with predefined thresholds to identify outages, reducing incident resolution time by 40% by enabling IT teams to pinpoint root causes efficiently.4. Developed a Nexthink dashboard, delivering real-time system insights, accelerating decisions, cutting data retrieval time by 70%, and enabling proactive IT issue resolution. Show less