Ritika(Ritzy) Patel

Business Data Analyst at MCIC Vermont, LLC
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Edison, New Jersey, United States, JE

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Analyzing and Visualizing Data with Microsoft Excel
    Udemy
    Sep, 2019
    - Nov, 2024
  • Introduction to Database and SQL Querying
    Udemy
    Sep, 2019
    - Nov, 2024
  • Introduction to Data Science using Python
    Udemy
    Aug, 2019
    - Nov, 2024
  • Introduction to Programming Using Python
    Udemymy/
    Mar, 2019
    - Nov, 2024

Experience

    • United States
    • Insurance
    • 1 - 100 Employee
    • Business Data Analyst
      • Apr 2021 - Present

      • Wrangling data from multiple sources and customer databases to create reports that can be used to drive decision making using Excel (Pivot tables and VBA) and which help in retention of customers • Creating new dashboards and helping teams visualize data using Tableau and drawing conclusions along with providing recommendations • Created meaningful business cases to support new products and developed forecast models to support growth initiatives using SQL • Built relationships with internal and external business partners and project sponsors and collaborated with cross – functional teams to meet individual commitments • Analyzing healthcare data using SQL to study patterns in claims data and visualizing in Tableau or SQL • Performing scheduled check-ins and uploads of the monthly claims report onto the claims portal for all the AMCs • Facilitating the creation of GAP analysis document and workflow to understand and infer the efficiency of modifying the existing system • Resolving the assigned JIRA tickets as well as created tickets to plan and prioritize project schedule or tasks Show less

    • United States
    • Information Technology & Services
    • 1 - 100 Employee
    • Business Analyst
      • Feb 2020 - Mar 2021

      • Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts • Documented changes in project plans whenever necessary as part of agile methodology and made sure those changes were implemented • Acted as a liaison between system users, client managers and software development team to gather requirements and document workflows and results of Financial Analysis into the Business Requirement Document (BRD) • Developed SQL queries for report generation and created visually impactful dashboards in Tableau and Excel (Pivot tables, VBA, VLOOKUP) for data reporting • Developed use cases and use case scenarios and visualized those using UML diagrams in MS Visio Show less

  • Suraj Gems
    • New York, New York, United States
    • Data Reporting Analyst
      • Mar 2019 - Nov 2019

      • Exporting data to MS Access and Excel for periodic and exception reporting: creating various types of graphs and summaries • Collaborated high level business goals and defined metrics, presentations, and reports/dashboards that track progress, influenced organizational behavior, drive forward-looking strategy, and identify areas of improvement • Prioritized the different stocks available for buyers to make a big impact on customer needs/goals • Worked closely with clients to design the ideal jewelry piece according to their needs and specifications, thereby increasing the productivity by 30% Show less

    • United States
    • Higher Education
    • 700 & Above Employee
    • Data Analyst Intern
      • Jan 2019 - May 2019

      • Analyzed complex reporting requirements for the credit card approval system and created visualization dashboards thus improving operational efficiencies by 20%• Tackled various pre-processing steps - label encoding, scaling, and missing value imputation - using python• Applied logistic model and random forest model, achieving the same accuracy of 86%• Attended and lead meetings; provide project status reporting to management

    • Secretary - MITSA
      • Sep 2018 - Mar 2019

    • Social Media Coordinator - MITSA
      • Feb 2018 - Feb 2019

      • MITSA is a student organization that promotes the Master of Information Technology and Analytics program.• Facilitate events that enhance the skills of the students.• Provide professional networking opportunities to make their life at Rutgers fun and to establish alumni and corporate outreach of the students in the professional world.

Education

  • Rutgers Business School
    Master's degree, Information Technology
    2018 - 2019
  • Mumbai University Mumbai
    Bachelor's degree, Information Technology
    2012 - 2016
  • Kishinchand Chellaram College - India
    Science
    2010 - 2012

Community

You need to have a working account to view this content. Click here to join now