Summary
Overview
Work History
Education
Skills
Languages
Location
Timeline
Generic

Rajalakshmi Radhakrishnan

Chennai

Summary

Data-driven professional with 5 years of experience in retail specializing in data management and marketing analytics. Transitioned from ETL Developer to CRM Audience Developer, proficient in SQL, PySpark, and data visualization tools. Seeking to advance career in Data and Insights.

Overview

5
5
years of professional experience

Work History

CRM Audience Manager

Marks and Spencer via Tata Consultancy Services
01.2023 - Current
  • This position is part of Marks and Spencer's(M&S) CRM Growth Team and involves developing the audiences for a range of marketing campaigns, including newsletters, Paid Media, emails, push notifications, personalization, offers, and more
  • Utilized SQL and Python to segment customer data based on demographics, purchasing behavior, and engagement history, resulting in more effective and personalized marketing strategies
  • Has strong expertise in handling huge datasets, data privacy and data security
  • Has worked in three of the M&S business units: food, clothing and home, and loyalty where i analyze and create the audiences, conduct tests, and give presentations to stakeholders that enables them to make well-informed decisions
  • SME in handling paid media audiences and audience creation for the M&S Ireland unit
  • Automate the campaigns using PySpark in order to reduce time, error, and human labor
  • Work closely with the marketing team to comprehend the requirements, assist them in determining the target audience, and provide guidance on the most effective attributes to utilize
  • Create reports to monitor the jobs using Power Bi
  • Organize knowledge-sharing sessions, provide new team members with training, and offer continuous support
  • I participate in the team's hiring procedure as well.

ETL Developer

Marks and Spencer via Tata consultancy services
11.2019 - 12.2022
  • Designed and developed the flows for Customer Repository application to handle ETL processes for integrating customer information from multiple sources
  • Utilized IBM InfoSphere DataStage for creating data pipelines and transforming data to support reporting and analytics
  • Integrated and cleansed data from various sources into a centralized data warehouse, improving data accuracy and completeness
  • Build physical data models and ETL pipelines using DataStage to integrate different upstream and downstream systems with CR
  • Conducted unit, functional, and performance testing; identify and fix the bugs
  • Discuss the changes in the CAB meeting and deploy the jobs in production
  • Developed and optimized SQL queries in Oracle DB to enhance data retrieval processes, which improved the accuracy and efficiency of handling customer-related inquiries
  • Coordinated with stakeholders to gather data requirements and ensure successful implementation of data integration projects
  • Developed and maintained documentation for ETL processes, data mapping, and system architecture
  • Provided 24/7 application support and Worked with customer service teams to understand and address data-related issues, providing timely and accurate information from Oracle DB to resolve customer queries effectively.

Education

B.Tech - Electronics and Communication

SASTRA University
Tamilnadu, India
06-2019

Skills

Customer Data Management Tools:

  • mParticle: Proficient in using mParticle for managing and integrating customer data

Data Integration & ETL Tools:

  • IBM DataStage: Built and maintained ETL pipelines for seamless data integration
  • Azure Databricks: Leveraged for large-scale data processing and integration

Programming & Scripting:

  • PySpark: Expertise in distributed data processing and advanced analytics
  • SQL: Skilled in developing and optimizing SQL queries for data management and reporting
  • Oracle DB: Experience in managing and querying Oracle databases to ensure data integrity

Project Management & Collaboration:

  • Experienced in using Jira, Confluence and agile methodologies

Languages

Tamil
First Language
English
Advanced (C1)
C1
German
Beginner
A1

Location

  • Currently based in India | Relocating to Germany on a dependent visa by [October/2024]

Timeline

CRM Audience Manager

Marks and Spencer via Tata Consultancy Services
01.2023 - Current

ETL Developer

Marks and Spencer via Tata consultancy services
11.2019 - 12.2022

B.Tech - Electronics and Communication

SASTRA University

Similar Profiles

CREATE PROFILE
Rajalakshmi Radhakrishnan