Business Analytics Senior Team Leader
- Dedicated and results-driven Business Analytics Team Leader with a proven track record of leading high-performance teams to deliver impactful insights that drive business growth and strategic decision-making.
- Adept at leveraging advanced analytics, data visualization, and statistical modeling to extract actionable intelligence from complex datasets.
- Skilled in collaborating with cross-functional teams to identify opportunities for process optimization and efficiency improvements.
- Known for fostering a data-driven culture within the organization and delivering innovative solutions to enhance overall business performance.
- Gathered data from various external sources into a data warehousing system with the help of ETL process.
- Collaborated with business users, collected requests, and updated the set of existing BI reports to accommodate business needs.
- Implemented data models and DAX calculations to improve data accuracy and streamline reporting processes.
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
- Implemented row-level security in Power BI workspaces depending on the type of access required.
- Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.
- Written complex SQL queries by using Joins,Storied Procedures,Sub queries etc.
- Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources and integrates data based on business logic and to load it in data warehouse.
- Experienced in developing SSRS reports using data from ETL Loads and various heterogeneous data sources.
- Expertise in data transformations and data modeling such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
- Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.
- Used Power automate and power apps for the end to end Power BI dashboard automations.
- Automate Excel based report using VBA and RPA technologies.