My Projects
IPL Dasboard
Analytics of IPL to find cricketing stats of favourite players/Teams and predict outcomes based on past performance subjected to different playing conditions.
Power BI
Excel
ETL Validation with Python Scripting
Design and Develop ETL pipeline from Oracle to Postgresql(Cross DB) using informatica Powercenter and Perform ETL validation using Python scripting.
Powercenter
Python
Postgresql
oracle
Election Dasboard
2014 & 2019 General Election anlaysis to Analyse the Demographic details of the contestants and top performers of respective constituentcies.
Power BI
Excel
ETL Transformations
ETL Transformations are essential for unlocking Data Insights and crucial for Enhanced Analytics. Design, Develope & Data validation of several Transformations are performed, which are crucial for ETL Pipeline.
Powercenter
oracle
Supermart Analysis
Sales & Transaction details modelled in postgres DB(star Schema). Querying & Analysing this data to answer problem statements raised by several stakeholders to improve Business.
Power BI
Postgresql
ETL Pipeline
Develop ETL Pipeline for Complicated Scenarios such as Incremental Load, SCD with the help of Informatica Powercenter & Data validation with the help of Linux.
Informatica Powercenter
oracle
Linux