Senior Data Analyst
Consoleflare
Total years of experience :5 years, 2 Months
• Developed Power BI dashboards, Power Pivots, and OLAP models, enabling self-serve analytics and driving a 102% increase in annual revenue.
• Used Power Automate, Power Apps and Python Scripts, boosting employee productivity by increasing average task completion rate by 300%.
• Developed multiple Power BI, D3.js dashboards for directors and board members to communicate import KPIs and helping them reduce churn rate by 30%, and boost CRR.
• Automated data integration by implementing optimized ETL pipelines using Azure Data Factory and advance SQL stored procedures, resulting reduced reporting latency.
• Led team of 9 members cross-functional team (across engineering, sales and marketing), ensuring collaborative and successful outcomes.
• Actively coordinated with client stakeholders, achieving a 95% satisfaction rate in understanding project requirements and converting them into effective solutions involving SQL, Synapse, Snowflake and Power BI.
• Spearheaded data modeling and mapping for a large Australian client, contributing to a seamless migration of their data warehouse with a 98% accuracy rate.
• Developed and implemented scripts and logic using Python within Azure Data Factory for data migration, resulting in a 30% reduction in migration time compared to initial projections.
• Debugged data pipelines and provided resolution logic to the Data Engineering team, utilizing Azure Data Factory and SQL, leading to a 20% decrease in the occurrence of data processing errors.
• Led the creation and migration of SSRS reports to Power BI, resulting in a 50% increase in report interactivity and visualization capabilities, enhancing client understanding of data insights.
• Took ownership of training newly joined freshers in Power BI, SQL, Python, Azure, and Power Platform, resulting in a 90% proficiency rate among trainees within the first three months of onboarding.
• Implemented robust data quality checks utilizing Excel data validation techniques, resulting in a 99% accuracy rate and a 20% reduction in data processing errors.
• Developed and maintained end-to-end data warehousing solutions, optimizing ETL processes to achieve a 30% decrease in data processing time and a 25% increase in data accessibility.
• Led the development, maintenance, and enhancement of ETL processes and OLAP cubes, automating the complete BI lifecycle and reducing manual intervention by 40%.