Pravina Prajapati

Data Analyst @Loblaw Companies Limited

Built and maintained a data pipeline to automate data extraction, transformation, and loading (ETL) processes using Python, SQL, SSIS, and Talend Open Studio, reducing data processing time by 30%- Managed and optimized databases including MySQL, Microsoft SQL Server, and Oracle, with expertise in data warehousing and data pipeline development- Applied Python and SQL for extracting, cleaning, and transforming large datasets from diverse sources, enabling 20% better data quality for downstream analytics- Conducted in-depth analysis of sales data to identify key trends and opportunities, utilizing statistical analysis techniques and developing Power BI reports and dashboards for actionable visualizations- Implemented Agile/Scrum methodology in collaboration with cross-functional teams, enhancing project efficiency- Led the yearly database cleaning, worked with the CRM Administrator to ensure high-quality data, supervised best practices for CRM data management.