Ritika Johri

Experience

• 

  Reliance Communications

  Apr 2016 - Jun 2017

  Corporate Relationship Manager

  • Managed multiple vendors and 30 large corporate accounts with respect to services, payments system and complete life cycle management. • Ensured that retention and churn from all mapped accounts to be less than 1% and developed, implemented & executed action plan for winning back churned accounts & reconciling previous unpaid dues from existing & churned accounts.

• 

  ICICI Bank

  Jul 2017 - Mar 2021

  Product Data Analyst - Savings Account

  • Performed data querying, cleansing, preprocessing and analysis of existing savings account customers data to identify non-profitable customers, root cause analysis and developed promotion campaigns & strategies to enhance balance & increase product attachments for these customers.• Identified data quality issues to ensure regulatory compliance like KYC, documented data quality & data validation rules.• Collaborated with a cross-functional team of business, operational partners & other stakeholders to document business requirements & translate it into technical requirements to help drive product performance and improve overall product health.• Performed ETL activities including extracting relevant savings account customer data using Oracle SQL as per business requirements, transforming it to the desired format and loading it to create BI dashboards using Tableau measuring product performance. Show less

• 

  University of South Florida Muma College of Business

  Dec 2022 - May 2023

  Graduate Teaching Assistant

  • Provided instructional support for undergraduate students, leading weekly class sections, conducting hands-on simulation labs, and holding office hours.• Assisted in developing course materials, including presentations and online resources. • Graded assignments and quizzes, providing constructive feedback to enhance student learning. • Possess strong proficiency in Microsoft Office Suite, data visualization and database management software.

• 

  Mutual of Omaha

  May 2023 - Aug 2023

  Data Analyst Intern

  • Worked within an Agile development team, produced conceptual/logical data models including Entity Relationship diagrams, attribute names & definitions using Erwin. • Developed Python code as part of Event Ingestion pattern to flatten JSON files to Parquet format in AWS Lambda.• Assisted with testing of Analytical Workspace in AWS S3/Glue/Athena to ensure documentation is understandable & functionality is useful. • Tracked testing progress & worked on feedback received from the testers. • Researched on version incrementing for typescript projects.• Fixed Master to Main branch for Analytical Workspace Template using Microsoft Visual Studio Code and Bitbucket to ensure Jenkins build is successful. • Tested the code for decentralized data lake in VS Code, AWS Lake/Cloud Formation, IAM, S3. Show less

• 

  University of South Florida Muma College of Business

  Aug 2023 - May 2024

  Graduate Teaching Assistant

  • Provided instructional support for undergraduate students, leading weekly class sections, conducting hands-on simulation labs, and holding office hours.• Assisted in developing course materials, including presentations and online resources. • Graded assignments and quizzes, providing constructive feedback to enhance student learning. • Possess strong proficiency in Microsoft Office Suite, data visualization and database management software.

• 

  Seven Seas Water Group

  Oct 2024 - now

  Business Reporting Analyst