Senior BI Consultant
Confiz Limited
Total years of experience :5 years, 4 Months
• Developed and implemented end-to-end Business Intelligence solutions to meet clients' reporting needs, ensuring accurate and timely delivery of critical insights.
• Collaborated with cross-functional teams to gather requirements, understand business objectives, analyze data sources, and design data models.
• Designed and created interactive reports and dashboards using Power BI, Tableau and Excel, enabling users to gain actionable insights from complex datasets.
• Created robust and scalable data pipelines using SSIS, Azure Data Factory and Python, ensuring seamless data extraction, transformation and loading.
• Developed and maintained data warehouse solutions using SQL Server and Azure Synapse.
• Utilized Azure big data technologies such as HDInsight, Data Lake and Databricks to analyze large volumes of data, extracting valuable insights through distributed processing.
• Provided technical guidance and support to users, empowering them to leverage self-service analytics.
• Managed and collaborated with Business Intelligence team to plan and implement industry standard analytics solutions for reporting.
• Interacted with client executives to identify & transform critical business KPIs and opportunities into technical requirements.
• Developed dashboards using advanced BI tools and cloud technologies for retail, supply chain, finance, e-commerce and marketing sector.
• Developed Power BI reports, created data models, DAX measures & calculated columns to track key metrics and receive insights from data.
• Developed ETL packages and data models for the development and implementation of tabular & multidimensional data warehouses to obtain clear value out of data.
• Ensured efficiency by supporting on-going projects and recommending new tools & methodologies for data analysis.
• Collaborated with data engineering and machine learning teams to increase the efficiency and productivity of operations, automate workflows, reduce errors and accelerate performance.
• Gathered relevant data from various sources and analyzed it to identify trends, patterns, and insights.
• Prepared and organized data by cleaning, validating, and transforming it into a usable format for analysis.
• Developed reports and dashboards to effectively communicate data findings to stakeholders.
• Collaborated with teams to identify opportunities, solve business problems and improve processes.
• Responded to data requests by running queries and extracting information from databases and data repositories.
• Verified the accuracy and quality of data through rigorous testing, data validation, and data quality assurance techniques.
• Tracked and monitored key performance indicators (KPIs) and data trends over time to identify deviations, anomalies, and areas of improvement.
• Used gathered data to develop an understanding of customer behavior, demographics and lifecycle.