Rohan Singh

About Rohan Singh

Hello — I’m Rohan Kumar Singh, a Data Executive at OPK E Services focused on building reliable, scalable data workflows that power targeted email marketing. I transform incoming customer data into production-ready datasets by designing incremental ETL processes, modeling Data Extensions with stable schemas and keys in Salesforce Marketing Cloud, and writing performant SQL using CTEs, window functions, and set-based logic to perform segmentation, deduplication, and suppression at scale.I earned 5-star HackerRank certifications in Python and Advanced SQL and completed the Professional Specialization in Advanced Data Analytics from Google. I apply those foundations to automate validation and reconciliation tasks using Python, implement idempotent load patterns, and orchestrate recurring jobs with scheduled SQL activities and platform scripting, ensuring data pipelines remain robust and predictable.Where appropriate, I adopt modern data-engineering practices such as modular ETL design, orchestration, version-controlled SQL and scripts, automated data testing and monitoring, and documented lineage so datasets are reliable, auditable, and easy to maintain. This engineering-minded approach helps reduce operational risk and improve the reproducibility of data products consumed by campaign and analytics teams.I enjoy collaborating with marketing, analytics, and engineering peers to translate business requirements into production-grade data solutions, and I am continually learning new tools and patterns to scale data operations and improve reliability.

Experience

1. Data Executive

   Opk E Services

   Jun 2024 — Present · Gurugram, IN

   Build and maintain scalable ETL pipelines and data workflows within Salesforce Marketing Cloud to ingest, transform and deliver incoming customer data for targeted email campaigns.• Build and optimize complex SQL queries and data models to enable precise audience segmentation, suppression logic, and campaign targeting.• Design and manage data tables, unique customer keys, and schema standards; automate recurring data tasks using SQL activities.• Implement data-quality checks, validation rules, and reconciliation processes to ensure dataset accuracy and consistency across campaign pipelines.• Monitor pipeline performance, troubleshoot data issues, and tune queries and processes to improve throughput and reliability.

Education

• Coursera

  Specialization

• Ranchi University, Ranchi

  Bachelor's degree