Business Intelligence Analyst /Data engineer - **SQL Development and Database Management**: - Designed and executed complex SQL queries for data extraction and analysis. - Developed and maintained stored procedures, views, and functions to support BI requirements. - Optimized database performance and ensured efficient data retrieval.- **Pandas and Python (Basics)**: - Applied Pandas for basic data manipulation tasks such as cleaning, merging, and filtering datasets. - Utilized Python scripts for simple automation and data processing tasks to complement BI processes.- **Power BI Development**: - Created interactive dashboards and reports in Power BI to visualize data and support business decisions. - Connected Power BI to various data sources, including SQL databases and Excel, for integrated reporting. - Used DAX (Data Analysis Expressions) for essential calculations and data analysis.- **SSIS (SQL Server Integration Services)**: - Developed ETL processes using SSIS to extract, transform, and load data from multiple sources into data warehouses. - Optimized SSIS packages for performance and reliability, handling complex data transformations and large datasets. - Automated ETL workflows and ensured data consistency and quality.- **ETL Processes**: - Managed end-to-end ETL processes, including data extraction, cleansing, transformation, and loading. - Implemented data quality checks and validations to ensure accurate and reliable data for reporting and analysis. - Streamlined data integration and processing using various ETL tools and methodologies.**Key Achievements:**- Improved reporting efficiency by 30% by developing a series of interactive Power BI dashboards.- Automated data processing tasks with Python, reducing manual preparation time by 20%.- Enhanced ETL performance with SSIS, decreasing data load times by 25% and improving data integration accuracy.**Skills:**- **SQL**: Advanced querying, database management, performance optimisation- **Pandas (Basics)**: Data cleaning, merging, and basic manipulation- **Power BI**: Dashboard creation, data visualization, DAX- **SSIS**: ETL design and implementation, performance tuning.- **ETL**: Data extraction, transformation, loading, quality assurance---