Supriya Kolate

• Analyzed complex data and identified anomalies to improve online purchase experience of customers.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Employed data cleansing methods, significantly Enhanced data quality.
• Contributed to internal activities for overall process improvements, efficiencies and innovation.
• Designed and implemented effective database solutions and models to store and retrieve data from Google Analytics using Azure and Python.
• Built databases and table structures for GA data.
• Compiled, cleaned and manipulated data for proper handling.
• Creating and tested ADF pipelines to integrate the data from various sources i.e. SAP HANA, Snowflake, CSV and Excel files, SQL Server
• Logic App development in order to send late arriving dimensions data over an email
• Peer code review, framework development and POCs for junior team mates
• Finding RCA for existing logic and providing solution to fix issues
• Code migration to QA/PROD using Azure DevOps
• Tested, validated ADF/DB solutions, prepared document of testing

• Developed and monitored ADF pipeline execution and fixed bugs for PUDW
• Monitored and fixed SQL Server jobs for Raflatac
• Performed RCA for existing logic and solution to fix issues
• Deployment of ADF pipelines and SSIS projects
• Performance and feature enhancements for DWH

• Developed accurate and efficient DWH for Microsoft-LexBI (Dec'18-Dec'20)

• Requirement gathering and analyzing the data

• Building ad hoc SQL queries to built ad-hoc Excel reports.

• Implemented DWH using Stored Procedures to populate Dims and Facts, UDFs to perform calculations and data transformation, Views to be used as a source of SSAS cubes or Power BI reports

• Developed workflows using SSIS/ETL Controller to populate staging tables, Dims and Facts.

• Unit tested the data and prepared documents

• SQL Server Job creation to schedule and execute workflows

• Implemented Error handling and logging

• Created and published Power BI Reports(RLS for PII data)

• Feature’s enhancement of existing reports

• Successfully developed complex data mappers for Sakon(Feb'17-Dec'18) with 10x better performance than other mappers developed by company

• Discovering BRD improvement points according to business logic

• Data transformations and mappings against vendor and client repositories

• Build and deployment of projects to QA and UAT environment using DACPAC and ISPAC files

• Provided KT to QA and junior developers

• Code review of other teammates