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 TimeLocation Preference
HybridOn-SiteRemoteImportant To Me
Company CultureCareer advancementPersonal development programsTimeline
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