I have worked on the below tasks during my employment with Canada Life, NielsenIQ and KPMG, and can work on similar or related tasks:
• Reported cloud cost for different applications and VMs (Prod and Non-Prod) and the weekly comparison of the cost, for the leadership to deploy cost-saving measures
• Leveraged logs from Microsoft Azure Blob Storage to identify client order execution time and automated the process using Python
• Developed data connections with SAP-ASE cloud databases using ODBCs to analyse orders punched in by different clients in the US, Australia, New Zealand, and European environments, on Power BI with Power Query and advanced DAX functions
• Extracted issue reports from Sonar Qube via API using Python, to develop a Power BI dashboard for reporting KPIs of continuous inspection of code quality for metrics including Code Coverage and Duplication and reporting of issues like Bugs, Vulnerabilities, and Code Smells across different projects
• Set up On-prem gateway for Power BI and configured data sources to enable auto-refresh of datasets across the reports
• Created Python data frames from JSON responses of Snyk API call, to report severity of vulnerabilities in code scans
• Created custom tables in Azure Databricks using SQL from Master Data Management to scrutinize the status of customers' consent for Terms and Conditions and marketing offers, and how the customer consent changes over time
• Maintained Azure DevOps repository and published the SQL codes to the repository to enable auto-refresh of the data from MDM
• Devised data connections with SharePoint List and folders to create dashboards in Power BI using DAX and Power Query for analysing and reporting status and other metrics of the JIRA tickets received by the Canada Data team
• Built Power BI dashboard to report metrics on Privacy and Compliance of data which includes Privacy Rights, Privacy Breaches, Privacy Maturity, Privacy Risk Assessment, etc.
• Assisted change management team in updating Power BI FAQs and articles on Data Hub
• Successfully automated key reconciliations using PostgreSQL and VBA programming to save manhours and achieve accuracy of results
• Curated data connection from PostgreSQL database to Power BI to monitor the daily trend of traffic generated by subscribers, receipt of material, performance of catalysts, etc.