Mastering PL/SQL: Turbocharge Your Data Processing with Bulk Queries!

Hello, I'm Akhil, an Associate Consultant at Atos India with a focus on the Advisory Consulting practice, specializing in Data and Analytics. My professional journey has led me through various facets of data analysis and modeling, particularly in the BFSI sector, where I've had the privilege of overseeing the full lifecycle of development and execution.

My skill set encompasses a wide range of data-related tasks, including data wrangling, feature engineering, algorithm development, model training, and implementation. I thrive on leveraging data mining techniques such as statistical analysis, hypothesis testing, regression analysis, as well as both unsupervised and supervised machine learning processes to extract meaningful insights and drive data-informed decisions. I'm particularly passionate about risk identification through decision models, and I've honed my expertise in Machine Learning Algorithms, Data/Text Mining techniques, and Data Visualization to effectively address these challenges.

Currently, I'm immersed in an exciting Amazon cloud project that involves end-to-end development of ETL processing. In this role, I craft ETL processing code using PySpark/Spark SQL to extract data from S3 buckets, perform necessary transformations, execute scripts using EMR services, and load consolidated data into Postgres SQL (RDS/Redshift) on a full, incremental, and live basis. To streamline this process, I've automated it by creating jobs in Step functions, which trigger EMR instances to run scripts in a specific order and send notifications upon execution status changes. The scheduling of these Step functions is achieved through event bridge rules.

Additionally, I've worked extensively with AWS Glue, using it to replicate source data from on-premises systems to raw-layer S3 buckets via AWS DMS services. One of my key strengths lies in my ability to understand the nuances of data and apply the right transformations to convert data from multiple tables into key-value pairs. Furthermore, I've optimized the performance of stored procedures in Postgres SQL to execute second-level transformations by efficiently joining multiple tables and loading the data into final tables.

I'm passionate about harnessing the power of data to drive actionable insights and improve business outcomes. If you share this passion or are interested in collaborating on data-driven projects, feel free to connect with me. Let's explore the endless possibilities that data analytics has to offer!