Tejaswi Dalavi

Data Analyst

Cartesian Consulting Pvt .Ltd•  August 2023 - October 2024•  Mumbai, India

Implemented Segment of One (SOO) campaign strategy. Proactively involved in customer segmentation, profiling, creating campaign analysis reports, dashboards, building and tracking important metrics/KPIs, improvement in campaign execution and customer life-cycle management. Actively involved in advanced scripting (DDL, DML, sub-queries, JOINS), creating Stored Procedures, Functions, managing multiple Schemas, Tables, Views in MySQL Workbench. Efficiently working with 60 tables across 5 Schemas and handling large data of dimensions like 60 million records across 30 attributes, 2 million records across 250 attributes.

Analyst

Cartesian Consulting Pvt Ltd•  August 2021 - August 2023•  Mumbai, India

Devised proactive ETL process using Pentaho Data Integration BI software. Created multiple jobs and transformations for fetching 60 tables daily from one server to other along with automated email notification at several checkpoints. Effective experience of data import/export, wrangling, pre-processing, cleaning, tabulation, manipulation, visualization. Created shell scripts for automation using cron jobs in Linux. Reporting various business metrics and KPIʼs. Provided valuable insights from past data & responses behaviors of customers. Created segmentation for retail brand for upselling which gave incremental order value of 10%.

Associate Software Engineer

Figmd India Pvt .Ltd•  August 2020 - July 2021•  Pune, India

Proficiency in a database platform: MySql, Excel, BigQuery. Map all clinical data into decided structure and reflecting that data to dashboard. Data analysis is done for different hospitals.

University of Pune, Pune

Mathematics, MS•  July 2016 - June 2019

I have Completed M.sc statistics From Pune University. Currently working in 'Figmd India Pvt. Ltd' as ' Associate software engineer' from Sept.2020. I have good knowledge of SQL, Advance excel and Machine learning with Python