Vivek Sairam Email & Phone Number

Chennai, Tamil Nadu, India

• Developed PySpark scripts for efficient onboarding of CSV files, transforming them into Parquet format for optimized storage and processing.• Implemented data quality checks and validation procedures to ensure accuracy and reliability of the processed data.• Orchestrated end-to-end data pipelines using Apache Airflow, ensuring seamless execution and timely processing of tasks.• Utilized Amazon EMR (Elastic MapReduce) for distributed computing, executing PySpark scripts at scale to handle large datasets.• Collaborated with the operations team to address and resolve errors and issues, leveraging extensive log analysis and debugging techniques.• Worked closely with the ops team to enhance system performance, identify bottlenecks, and optimize data processing workflows.• Created tables in Amazon Athena for efficient and interactive query access to the processed data.• Collaborated with AWS S3 for storing and managing the processed data, optimizing storage costs and accessibility.

Chennai, Tamil Nadu, India

• Designed and implemented an end-to-end ETL process for sensor data received from devices, ensuring efficient and reliable data processing.• Utilized AWS S3 for scalable and cost-effective storage of sensor data, optimizing data accessibility and retrieval.• Created ETL pipelines in AWS Glue, streamlining the data transformation and loading processes for enhanced efficiency.• Implemented event-based triggering of Glue jobs using AWS CloudWatch, ensuring timely execution of data processing tasks in response to specific events.• Leveraged AWS Simple Email Service (SES) for automated email notifications, enhancing communication and alerting mechanisms within the data processing workflow.

Banglore

• Collaborated with diverse stakeholders to comprehend project requirements, intricacies of the data, and gained substantial domain knowledge in the Pharma industry.• Analysed diverse data sources, including Claims and Sales, employing MySQL Workbench and Tableau to develop descriptive analytics for informed business decision-making.• Developed descriptive analysis metrics, particularly in "Drug Performance" (identifying top-performing drugs in the market) and "Market Access Analysis" (identifying top Payers based on lives covered), which were well-received and widely referred to by C-Suite executives.• Presented results of the "Market Access Analysis" to devise the optimal strategy for launching the new drug delivery device.

Master Of Technology - Mtech, Material Science And Engineering, 8.9

The M.Tech. (Materials Science) programme has been designed to meet the requirements of experts in the fields of Manufacturing, Material.

Bachelor Of Technology - Btech, Mechanical Engineering, 8.0

Activities and Societies: Event Organizer ,Equilibrio2K17.

12Th, Mathematics ,Physics And Chemistry, 97.6%

10Th, 9.8