Sonali Majumdar

Implemented solutions for targeted strategies to maximize customer engagement and drive sales performance by marketing and sales teams using PL/SQL ETL pipelines. Optimized and fine-tuned existing pipelines for faster and more efficient data delivery, enhancing overall performance and productivity by 83.3% for marketing communications, using PL/SQL procedure, AWS DMS. Implemented scaled out solutions which increased the business efficiency by more than 50% in submission of regulatory reports using big data tools such as AWS S3 , EMR with spark cluster, hive, sqoop, bash and SQL. Enabled campaign reachability and efficiency by creating data pipeline to process the data in batches on daily basis empowering visualization of the customer engagement for management using Python and MongoDB. Performed debugging and root cause analysis on production issues. Designed and deployed real-time solution leveraging logs empowering business to view actionable insights in realtime using Python, AWS Lambda and Kafka. Involved in designing and architecturing solutions alongwith cross functional collaborations.

Conducted Source system analysis on agile specific sources like CI/CD pipelines, SDLC and source code management, performed Data Modelling for warehouse. Designed and Implemented highly complex data pipelines from scratch after analyzing in depth source data behavior ensuring various data scenarios are handled by the pipeline using PL/SQL. Optimized and fine-tuning of data pipelines for reducing data flow time for huge volume of data by 30%. Involved in Dashboard design and creation which involved blending of various unrelated data cubes along with QA support in testing data quality.

Developed a central UI for a radar system using swift UI and socket communication in Java enabling communication with its components along with other interns in a team.