Soumava Roy

· More Than 11 Years’ Experience in Data Engineering, Data warehousing and Data Migration Projects. Currently working with Amazon as a Senior Data Engineer. · Designed and developed large-scale, high-volume, high-performance data structures for business owners. · Managed AWS resources including EC2, Redshift, S3, Glue, EMR. Explored and learnt the latest AWS technologies to provide new capabilities and increase efficiency. · Reduced Data generation Timeliness increase Platform Availability and improve Latency of data access. · Created and maintained strong access controls framework for each individual component of infrastructure using the platform across organization. · Owned high-impact alignment and standardization projects across the organization by collaborating with Business Intelligence Engineers and global BI leaders. · Designed, developed and maintained ongoing metrics, reports, analysis, and dashboards to drive key business decisions. · Worked with business owners to develop and define key business questions and build data sets that answer their business questions. · Collaborated with Data Scientists and applied scientist to implement advanced analytics algorithms that exploit Amazon’s rich data sets for statistical analysis, predictions, clustering and machine learning purposes. · Assisted Data Scientists and Machine Learning Scientists with data identification and data preparation phases. · A full stack data engineer who knows Scripting, Data Modelling, Reporting, Data Warehousing and ETL. · Experienced in Dimensional and relational Data Modeling and worked in both OLAP (Analytical) and OLTP (Transactional) projects. · Extensively worked In SQL and ETL Development. · Extensively worked on understanding/modifying/creating logical and physical data model using Erwin Data Modeler. · Extensively Experienced in Dimensional data Modelling (Star, Snow-Flake Design, SCD (Slowly changing dimension) Concepts) · Experienced in Data Analysis, Data Profiling, Data Mapping, Data validation Analysis, Data retention Analysis and Ad-hoc Query analysis. · Extensively worked on AWS Redshift and Drayed, Athena,S3,Glue. · Worked on all phases of SDLC specializing in Requirement Gathering, Requirement Analysis, Data Analysis and Data Modeling for both OLTP and OLAP Environments.