Dorai Sulam

PROFESSIONAL SUMMARY CORE COMPETENCIES
PROFESSIONAL EXPERIENCE
Senior AWS Data Engineer Lead Data Engineer – Life Sciences Division
EDUCATION
CERTIFICATIONS
PROJECT HIGHLIGHTS

Experienced Senior AWS Data Engineer with 10+ years of expertise in designing, building, and optimizing data engineering solutions within the Life Sciences and Pharma domain. Proven ability to lead large-scale data integration projects, implement robust ETL pipelines, and manage end-to-end data solutions using AWS data services (Glue, Redshift, S3, Lambda, MWAA). Strong domain knowledge in Commercial Pharma Operations, including sales analytics, clinical data processing, and regulatory reporting. Adept at aligning data engineering solutions with business objectives for actionable insights.

• AWS Services: Glue, Redshift, S3, Lambda, MWAA, RDS
• Languages: Python, SQL, PySpark
• ETL Development: AWS Glue, Informatica, custom Python scripts
• Data Modeling: Star/Snowflake schema, Dimensional Modeling
• Big Data: Apache Airflow, Spark, EMR
• DevOps & CI/CD: Git, Jenkins, CloudFormation, Terraform (basic)
• Life Sciences Expertise: HCP/HCO data, CRM (Veeva), Clinical Trial Data, IQVIA, Commercial Ops
• Project Leadership: Agile/Scrum methodologies, technical mentorship, cross-functional collaboration

[Current or Most Recent Company Name] – [City, State]
[Month, Year] – Present

• Lead design and implementation of end-to-end AWS-based data pipelines for major pharmaceutical client.
• Integrated commercial data from Veeva CRM, SAP, and IQVIA sources to support business intelligence and analytics.
• Developed scalable ETL workflows using Glue and Lambda to automate ingestion and transformation of clinical trial datasets.
• Worked with data scientists and commercial teams to model and deliver data for forecasting, territory alignment, and sales incentive planning.
• Deployed Airflow DAGs on MWAA to orchestrate data processing tasks, reducing pipeline latency by 40%.
• Mentored junior engineers on AWS best practices, coding standards, and domain-specific data requirements.

[Previous Company Work]

• Migrated legacy ETL jobs to AWS Glue, optimizing runtime and cutting cloud compute costs by 25%.
• Built data lake architecture using S3 and Redshift Spectrum to store patient-level data from various study centers.
• Worked closely with pharmacovigilance and regulatory teams to ensure compliance with HIPAA and GDPR guidelines.
• Created dashboards and reporting pipelines that supported drug launch KPIs and market access strategies.

Bachelor of Business Admistration (BBA)

[Roots International Business School], [Hyderabad, India]
Graduated: [2017]

• AWS Certified Data Analytics – Specialty
• AWS Certified Solutions Architect – Associate
• Certified Scrum Master (CSM) – [if applicable]
• Commercial Pharma Dashboard: Built Redshift-backed reporting system used by 500+ sales reps to track HCP engagement.
• Clinical Trial Data Lake: Architected a centralized data lake for Phase III trials, enabling real-time insights across global study sites.
• ETL Automation: Automated over 200 daily ETL jobs using Airflow on MWAA, improving SLA adherence and reducing manual errors.