About Me
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.
Experience
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
Interacted with stakeholders to learn about their decision-making criteria.
Used Power BI and ETL to analyse data.
Created dashboards that tell a story.
Resolved data issues by improving data quality and integrity.
Successfully extracted, transformed, and loaded data from Azure SQL, Blob storage, and on-premises servers.
Constructed pipelines in ADF utilizing Linked Services, Datasets, and Pipelines.
Translated business requirements into meaningful report decks utilizing Power BI.
Accessed SQL database for analysis.
Collaborated with stakeholders to gather feedback and iterate on deliverables.
Incorporated and used Power BI's capabilities to manipulate, transform, and aggregate data for KPI calculation, metrics, and visualizations.
Maintained documentation.
Implemented process improvements that reduced manual intervention and increased automation efficiency.
Followed best practices in data management.
Maintained a high standard of data security.
BI Analyst
Built reporting infrastructure using Power BI and SQL.
Developed data-driven strategies to support business decisions.
Created SQL queries to extract and transform data from multiple databases for reporting and analysis purposes.
Conducted data cleansing to improve data accuracy and consistency.
SQL/ BI
Developed and maintained SQL scripts, stored procedures, functions and ETL processes for data extraction, transformation, and reporting.
Wrote SQL queries.
Optimized query performance.
Conducted data analysis and profiling.
Identified and resolved data quality issues.
Performed ETL activities to load data from Source Systems to Azure Storage and Azure SQL DB using Azure Data Factory and T-SQL.
Assisted in troubleshooting and resolving database-related issues.
Implemented and maintained database security measures.
Created and maintained documentation for ETL workflows, BI and standard operating procedures.
Did enhancements of end-to-end coding for development.
Worked on the queries and tables in the database to analyse the data.