CAREER SUMMARY
CEDAR was a project built to enable the business to view the reports in PowerBI from Azure DWH.It Contains Overall Sales details of the GSK products in different stores under Consumer Health.
Responsibilities:
BigDecision is an inhouse tool developed by Cognizant to perform ETL.
This project aimed at Migrating all the BigDecision components used in CEDAR to Azure Components.
Responsibilities:
All the business information of the Commonwealth Bank of Australia (CBA) is stored in FMS that is a mainframe system.Accessing those information from mainframe is very expensive so BIS is used to store the information from FMS.Data get fed from FMS to BIS server on an hourly basis where the data is filtered and flows to different applications through SSIS packages scheduled in SQL server agent.
BIS is a SQL server representation of FMS and Non-FMS data that manipulates the raw data and distributes it to different application through SSIS packages.
Responsibilities:
ODS was a project to build a near live datawarehouse that will reduce the load at mainframe systems.The semantic layer built on top of the ODS will be used by the data analytics and spotfire reporting team for customer reports.
Responsibilities:
Adviser Early Warning System is used to flag and report the advisers on risk as per the set of metrics.
Responsibilities:
Azure Data Factory
undefinedMicrosoft Certification-DP-200 Implementing an Azure Data Solution
Microsoft Certification-AI-900 Microsoft Azure AI Fundamentals
Microsoft Certification-DP-200 Implementing an Azure Data Solution