نبذة عني
Highly skilled and dedicated BI analyst and SQL developer with 3+ years of experience collaborating with stakeholders, integrating the data, designing and developing data systems and a proven track record of creating hig…
Highly skilled and dedicated BI analyst and SQL developer with 3+ years of experience collaborating with stakeholders, integrating the data, designing and developing data systems and a proven track record of creating high-quality deliverables through data visualization and analysis using Power BI, SQL and identifying the process improvement.
الخبرة
Bi Developer
● Interacted with stakeholders to learn about their decision-making criteria, then use Power BI and ETL to analyse the data to create dashboards that tell a story and also resolved data issues by improving the data quality and integrity achieved by 20%.
● Successfully extracted, transformed, and loaded data from a variety of sources, including Azure SQL, Blob storage, and on-premises servers, pipelines were constructed in ADF utilizing Linked Services, Datasets, and Pipelines achieved by 10% accuracy rate.
● Translated business requirements into meaningful report decks utilizing Power BI and accessed SQL database for analysis and collaborated with stakeholders to gather feedback and iterate on deliverables achieved by 30%.
● Incorporated and used Power BI's capabilities to manipulate, transform, and aggregate data for relevant KPI calculation 20%, metrics, and visualizations to present comprehensive management information. Familiar with using the DAX, Filters and Power Query.
● Maintained documentation, implementing process improvements and increased automation efficiency.
Followed best practices in data management, resulting in zero data breaches and maintaining a high standard of data security
BI Analyst
<p>Interacted with stakeholders to learn about their decision-making criteria.<br>
Used Power BI and ETL to analyse data.<br>
Created dashboards that tell a story.<br>
Resolved data issues by improving data quality and integrity.<br>
Successfully extracted, transformed, and loaded data from Azure SQL, Blob storage, and on-premises servers.<br>
Constructed pipelines in ADF utilizing Linked Services, Datasets, and Pipelines.<br>
Translated business requirements into meaningful report decks utilizing Power BI.<br>
Accessed SQL database for analysis.<br>
Collaborated with stakeholders to gather feedback and iterate on deliverables.<br>
Incorporated and used Power BI's capabilities to manipulate, transform, and aggregate data for KPI calculation, metrics, and visualizations.<br>
Maintained documentation.<br>
Implemented process improvements that reduced manual intervention and increased automation efficiency.<br>
Followed best practices in data management.<br>
Maintained a high standard of data security.</p>
BI Analyst
<p>Built reporting infrastructure using Power BI and SQL.<br>
Developed data-driven strategies to support business decisions.<br>
Created SQL queries to extract and transform data from multiple databases for reporting and analysis purposes.<br>
Conducted data cleansing to improve data accuracy and consistency.</p>
SQL/ BI
<p>Developed and maintained SQL scripts, stored procedures, functions and ETL processes for data extraction, transformation, and reporting.<br>
Wrote SQL queries.<br>
Optimized query performance.<br>
Conducted data analysis and profiling.<br>
Identified and resolved data quality issues.<br>
Performed ETL activities to load data from Source Systems to Azure Storage and Azure SQL DB using Azure Data Factory and T-SQL.<br>
Assisted in troubleshooting and resolving database-related issues.<br>
Implemented and maintained database security measures.<br>
Created and maintained documentation for ETL workflows, BI and standard operating procedures.<br>
Did enhancements of end-to-end coding for development.<br>
Worked on the queries and tables in the database to analyse the data.</p>