Ramya Chandran
Data Engineer
Coimbatore,TN
Summary
Dynamic Database Engineer devoted to maintaining reliable computer systems for uninterrupted workflows. Delivers up-to-date methods to increase database stability and lower likelihood of security breaches and data corruption. Offers detailed training and reference materials to teach best practices for system navigation and minor troubleshooting.
Overview
5
5
years of professional experience
4
4
Certifications
Work History
Data Engineer
AstraZeneca, OCE
Chennai, TN
07.2017 - Current
- OCE/Veeva integration solution - Oracle, Postgres, Snaplogic, Salesforce
- Developed Integration solutions between source systems like Reltio MDM, Data lake and other could services into Salesforce using Oracle, Postgres, Snaplogic.
- Worked on migration of 50+ ETL jobs from informatica to snaplogic.
- Created reusable components using SnapLogic
- Monitored all critical job schedules 0f 100+ jobs in Veeva and OCE using autosys, active batch, splunk, step functions in AWS, snaplogic and mulesoft.
- Development of utility scripts for duplicate checks and data validation for daily monitoring
- Hyper care support and resolution of data mismatches between the systems post deployment
Reltio customer maintenance programme – AWS EMR, AWS Lambda, Pyspark, AWS Postgres(RDS), AWS SQS/SNS
- Design and implementation of real-time data availability into Reltio MDM system using AWS lambda.
- Real Time data flow from Reltio using AWS SQS/SNS into Postgres database and Salesforce systems
- Worked on pyspark and EMR implementation for data publish from Reltio to postgres RDS using AWS data pipeline, step function.
Intern
Honeywell
Bangalore, Karnataka
01.2017 - 06.2017
- Worked in Azure Virtual Network, Express Route connections.
- Worked in Azure Security using Active Directory, multi-factor authentication,
- Security Centre, and Key Vault.
- Analyzed Azure Storage and Backup.
- Analyzed Architectural design for overall security.
Education
MS - Data Science (Online)
Liverpool John Moores University
Liverpool, UK 01.2020 - 09.2021
B-Tech - Computer Science
Amrita University
Coimbatore, TN 01.2013 - 01.2008
Skills
SQL
Python
Snaplogic
Postgress
Unix
Data analysis
AWS Basics
Azure Basics
Informatica
Machine Learning
Deep Learning
Websites
Projects
Credit Card Fraud Detection
- Kaggle Project on PCA transformed variables were used to predict frauds with highest accuracy and recall balance using various models.
Telecom Churn Prediction
- Build predictive models to identify customers at high risk of churn and identify the main indicators of churn with various ML model comparison.
House Price Prediction
- Devised a Model using Advanced Regression to predict house price at Australia and parameters that contributes more to price.
Car Price Prediction
- Explored multiple Linear Regression model to predict car price and evaluated with various metric and choose the right metric.
NGO Money allocation to Countries
- Categorized countries based on socio-economic and health factors using clustering which helps NGO in distribution of money strategically and effectively.
Lead Score Prediction for Conversion
- Devised Lead Score using logistic regression predict probability and found top parameters which increases lead conversion rate from 30% to 80% for education company selling online courses.
Certification
SQL Python Snaplogic Postgress
Additional Information
- Energise Award - We Are Entrepreneurial (09/2020) Appreciation for OCE Contribution "Ramya, thanks for your contribution to the OCE Project, The efforts shared beyond your current role are highly appreciated. The inputs/ideas sharing your project expertise that helps project team to simply the process in new project." - Jabibulla Shaik (Manager)
- Ignite Award - We Play To Win (06/2020)
- Quarterly Award (12/2019) Best at Upskilling Pluralsight Challenge (07/2019)
- Best Project Team (05/2019)
- Monthly Award (12/2018)
Timeline
MS - Data Science (Online)
Liverpool John Moores University
01.2020 - 09.2021
Data Engineer
AstraZeneca, OCE
07.2017 - Current
Intern
Honeywell
01.2017 - 06.2017
B-Tech - Computer Science
Amrita University
01.2013 - 01.2008