LOKENDRA TANWAR

Project: Data Subject Requests (DSR) Automation

• Developed and managed over 500 end-to-end Data Subject Requests (DSR) for access and deletion using OneTrust, achieving 100% compliance with GDPR data privacy regulations.
• Designed and implemented an automated data processing pipeline using Azure Data Factory and Azure Databricks, reducing data handling time by 30%.
• Automated DSR deletion batch creation and request closure processes using Python and APIs, reducing manual workload by 50% and ensuring timely data deletion.
• Built Unix scripts to delete profiles and suspend users from the Guest Integration Hub (GIH) using Shell and Python scripts in Putty, streamlining user data management and improving system efficiency by 20%.
• Leveraged advanced SQL techniques to delete user data from Snowflake tables by merging multiple data sources.
• Ensured that all user-related data identified by email was nullified across relevant columns, significantly improving data privacy compliance.

Project: Data Integration and Optimizations

• Fine-tuned SQL queries and optimized database structures, resulting in a 20% reduction in data retrieval times.
• Collaborated with cross-functional teams to validate data from various sources, ensuring data quality and reducing discrepancies by 10%.
• Developed data processing and analysis algorithms optimized for complex data sets and large-scale volumes, enhancing analytical capabilities for business insights