Overview
Work History
Education
Skills
Work Preference
Timeline
AccountManager

Ritika Ranjan

Software Engineer
Bengaluru,Karnataka

Overview

4
4
years of professional experience
4
4
years of post-secondary education

Work History

Software Engineer

Societe Generale
Bengaluru, Karnataka
06.2022 - Current
  • Conceptualized, developed and automated regulatory reports related to Russia Ukraine crisis using Excel, SQL, and
  • Airflow reducing sanctions reporting by 39%
  • Designed and developed report for daily trade booking to flag suspicious behavior reducing the manual check effort by 7 hours using Excel, C♯ and SQL
  • Analyzed and identified the discrepancy of the contingency settlement reports
  • Collaborated with the primary stakeholder to improve data quality from 23% to 100% using SQL, C♯ and Excel
  • Spearheaded the development of a new roster for production support, improving efficiency by 70%
  • Envisaged and led the weekly meeting to improve the code quality by resolving 2000+ code smells and blocker bugs in the code-base
  • Mentor to the two new joiners in the team
  • Facilitated and Organised the on-boarding and the KT sessions
  • Provided L3 support along with development activities and resolved critical incidents and production issues.

Software Engineer Intern

Societe Generale
Bengaluru, Karnataka
01.2022 - 05.2022
  • Conducted a study on the feasibility of cloud usage within the organization by analyzing the server usage data
  • Executed Airflow migrations, assessed impact, and created a comprehensive report highlighting the pros and cons of the migration
  • Developed process documents and initiated a git repository for migration template reducing manual effort by 3 hours.

Design Intern

G.S. Labs
Vadodara, Gujarat
05.2020 - 07.2020
  • Created the design of a user-friendly Food-Bank website increasing serviceability to tech novices by 43%
  • Conducted a human survey to select the most suitable idea
  • Presented the chosen idea to the design team, ranking amongst the top 2 designs
  • Personal Projects
  • Employee Satisfaction Analysis | PowerBI
  • Utilized eNPS Dataset for survey analysis
  • Created dashboards for data percentage, sentiment analysis, and survey influence
  • Pizza Sales Analysis | SQL, PowerBI
  • Extracted and filtered raw data using MS SQL server
  • Employed SQL queries for database creation and reporting
  • Utilized Power Query for Data Cleaning and DAX for custom columns
  • Developed dynamic dashboards for data visualization.

Education

Bachelor of Technology(B.Tech) - Computer Science

Vellore Institute of Technology
Chennai
07.2018 - 07.2022

Skills

  • Languages:
  • SQL(Postgres), C♯
  • Python, R, Java, HTML/CSS
  • Tools: PowerBI, Jira, MS Suite, MS Excel, Jupyter Notebook, Git, VS Code, Visual Studio
  • Soft-Skills: Leadership, Strong Communication Skills, Problem-Solving, Teamwork, Adaptibility
  • Professional Development and Certification
  • Product Management and Business Analysis: Become a Product Manager, Business Analyst ”A-Z” Masterclass
  • Microsoft Excel: Excel from Beginner to Advanced, Complete Data Analytic in Excel
  • Data Analysis and Visualization: Python Data Analysis and Visualization
  • Languages: Ultimate MySQL Boot camp

Work Preference

Work Type

Full Time

Location Preference

HybridOn-SiteRemote

Important To Me

Company CultureCareer advancementPersonal development programs

Timeline

Software Engineer

Societe Generale
06.2022 - Current

Software Engineer Intern

Societe Generale
01.2022 - 05.2022

Design Intern

G.S. Labs
05.2020 - 07.2020

Bachelor of Technology(B.Tech) - Computer Science

Vellore Institute of Technology
07.2018 - 07.2022
Ritika RanjanSoftware Engineer