Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Ranita Ray

Ranita Ray

Summary

Creative Business Analyst with broad-based background in highly competitive and dynamic organizations. Recognized as decisive leader and excellent team player. Committed to forming strong, productive teams.

Overview

3
3
years of professional experience

Work History

Associate Business Analyst

ICICI Bank Ltd.
06.2023 - Current
  • Gained valuable insights by effectively communicating with clients to understand their business requirements related to data.
  • Analyzed raw data, drew conclusions and developed recommendations. Wrote SQL scripts to manipulate data for data loads and extracts.
  • MS Excel: Gathering all data into sheets for each category from internal sources as well as external sources for cleaning the data and keep it ready for further analysis
  • MS SQL: Data import for each category into the MS SQL database server to merge and convert individual data into a comprehensive master dataset utilizing SQL queries.
  • Developed appropriate visualizations using Tableau to make data-driven decisions for optimizing business operations of the company
  • Created daily, weekly, and monthly analytics reports to present using Power Point.
  • Provided colleagues and clients with qualitative and quantitative data for daily system checks.

Project Coordinator

ANS Constructions Private Limited
05.2021 - 05.2023
  • Responsible for inventory management, trends, and end to end supply chain stocks of Products & Process improvement.
  • Automated report generation using SQL. Led creation of vendor scorecard and assisted supply chain team in high-level discussions with brands.
  • Managed the tracking of SKU availability at Pan India level to ensure optimal stock levels
  • Ensured optimal performance in cost, timeline, quality control and customer satisfaction levels.

Education

MBA in Analytics & Marketing -

KIIT SCHOOL OF MANAGEMENT
01.2021

B.Tech in Civil Engineering -

KIEM West Bengal University of Technology
01.2019

DATA ANALYTICS certified course -

TechTip24

Skills

  • MySQL
  • Microsoft Power BI
  • Tableau
  • Excel
  • R programming
  • KPI Tracking
  • Data Analysis
  • Policy Development
  • Pivot tables
  • Customer Needs Assessment
  • Data Validation & extraction
  • Bidding & Budgeting & Rate Analysis
  • Risk & competition analysis
  • Value Propositions
  • Procurement
  • Financial Modelling

Accomplishments

  • Awarded with the first prize in National Construction Talent Test by GICMAR
  • Participated in International level Online Business Simulation Contest organized by KSOM (10th NATIONAL Marketing Conclave)
  • Received appreciation from the Client of M/s. Tecnimont for prompt work actions in the project of Barauni IOCL.

Timeline

Associate Business Analyst

ICICI Bank Ltd.
06.2023 - Current

Project Coordinator

ANS Constructions Private Limited
05.2021 - 05.2023

MBA in Analytics & Marketing -

KIIT SCHOOL OF MANAGEMENT

B.Tech in Civil Engineering -

KIEM West Bengal University of Technology

DATA ANALYTICS certified course -

TechTip24

Similar Profiles

CREATE PROFILE
Ranita Ray