Database Analyst
Dublin 2, Ie
Data Analysis:Identified two-third of the integrity exceptions using Athena, Redshift by utilizing data analysis to monitor process efficiencies.Reduced up-to 50% of support calls by designing and implementing data pipelines using python pandas for storage and maintenance of customer campaigns.Lead a team of 3 in updating the dashboards using Tableau for the User Interface, resulting in a 50% improvement in data visualization and a two-third increase in user engagement.Developed and integrated machine learning models using TensorFlow and PyTorch libraries, resulting in the improvement in user retention.Customer Data Warehousing:Conducted business analysis for a data warehouse solution, resulting in the improvement of data accuracy and reduction in data processing time. Lead data modeling and testing of program modules to ensure compliance with design specifications, resulting in a decline of decrease in defects and a major increase in program efficiency.Executed SQL queries using SQL Workbench to fulfill business needs and deployments, leading to an enhancement in data quality.Created detailed reports and closed incidents promptly, resulting the downtime and increase in efficiency.Delivered technology solutions to support user needs by performing DDL updates for the required deployments which was done in the production server.Tools Used: Python, Pandas, AWS Services - Athena, Redshift, S3, Lambda, RDS, SQL Workbench, Tableau, Tensor Flow, PyTorch