Akshay Balasaheb Nikam

Project :- Risk Canvas

Client :- Amp bank, Australia

• Risk Canvas is a comprehensive financial crime risk management platform.
• This product is designed to help financial institutions manage various aspects of financial crime prevention, such as Anti-money laundering(AML), fraud detection, transaction monitoring, risk scoring, customer due diligence.
• For this project, we used technologies like Python, PySpark, AWS Glue, AWS Athena, DynamoDB, AWS Lambda, Elasticsearch, Step Functions, EC2, EMR, S3, HBase, and RestAPI.
• For this, pipelines are created to process the data from the S3 location to the Risk Canvas UI.

Project :- Legal Data Retention

Client :- Vodafone Ireland

• Designed and implemented a data pipeline to provide legal customer data to Ireland Government based on complaint registers for specific mobile numbers. For this client, where we are dealing with large amount of data which is in hourly basis, daily basis, weekly basis and monthly basis.
• As well as we are pulling data using API’s, then we are encrypting the data with gpg encryption and moving it to GCS(GCP) using Apache NiFi.
• Again read the file from GCS and decrypt it then transforms it into parquet file and if any Pii data is present then pseudonymize the pii data and again store it on GCS.
• Created Pyspark jobs to transform data as per business requirement with gpg encryption. Developed a Python application to move files from SFTP location to HDFS.
• Utilized API integration and encryption techniques for secure data transfer to GCP using Apache NiFi.
• Transformed and pseudonymized sensitive data, created PySpark jobs, and shared reports with the business team. Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability

Project :- Network Monitor System (Vodafone Ireland)

Client :- Amdocs

• Built an end-to-end data pipeline for real-time customer data using HDFS, Apache-Spark, Hbase, Python, and Kafka.
• Created Spark jobs to process and store data in Kafka and Hbase.
• Developed Python API (Flask) to display data on a web application.
• Dockerized the application for efficient deployment.

Project :- Retail Store Data Pipeline

Client :- Mahyco Pvt. Ltd. (Pune)

• Ingested supermarket data from the mainframe system to the data warehouse in real-time.
• Developed an end-to-end data pipeline using HDFS, Apache Spark, MySQL, and PowerBI for data cleaning, processing, and analysis.
• Collaborated with the business team to understand requirements and implemented data transformations accordingly.
• Managed JIRA tickets, conducted data validation, quality checks, and profiling.