Dynamic Data Engineering Team Lead with extensive experience at Accenture, specializing in Power BI and SQL. Proven track record in mentoring teams and driving collaborative projects, resulting in enhanced data insights and client satisfaction. Adept at transforming complex data into actionable strategies while fostering a culture of knowledge sharing and continuous improvement.
· Understand business requirements in BI context and design data models to transform raw data into meaningful insights.
· Utilized advance analysis actions, complex Dax, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards.
· Implementing RLS in Power BI, Data Preparation and Data Preparation using all the types of transformations that are available in Power BI query editor.
· Developing Power BI widgets and collaborating with the Web Development team for the integration of the report on Accenture Central Server.
· Catered multiple clients Like BMW, Starbucks, ROSHN, Bank of Indonesia etc.
· Aligned with Agile Methodologies, scrum stories, and sprints in a Python-based environment in association with data analytics and Excel data extracts.
· Created multiple prototypes in Power BI for multiple clients based on their requirements.
· Perform DAX queries and functions in Power BI for dynamic slicers and charts.
· Create relationships between data and develop tabular and other multidimensional data models.
· Worked on various client reports like Coles, Petronas, Sasol etc.
· Perform DAX queries and functions in Power BI
· Worked on all types of transformations that are available in Power BI query editor.
· Communicated effectively across multiple platforms and departments by performing various QA tasks and evaluating workflow.
· Create customize charts and custom calculations as per requirements.
· Developed Risk Analysis Power BI reports for various scenarios across the client firm.
· Created Power BI reports which fetches the csv files incrementally on daily basis.
· Worked on conversion of all operational excel into Power BI reports.
· Published PBI reports on server and scheduling of refresh based on requirements.
· To test loading of data using multiple data sources in a single report using direct query.
· Worked on Power BI to test cross report functionality.
· Integrated custom visuals based on business requirements using Power BI desktop.
· Developed QlikView Reports for data quality and implemented dashboards. Used visualizations like Combo Chart, bar chart, Gauge, Pivot, Tables, Line Chart, in QlikView.
Experienced in creating reports like drill down, cyclic reports, etc. In QlikView and deployed dashboards to server using QlikView Workbench.
· Building QlikView reports for various Application data and Working on Adhoc QlikView Reports.
· Worked on implementation of business logic using objects like tables and constraints using DDL and DML concepts in Rapid SQL.
· Working on UNIX scripts and Database.
· Worked on QlikView version upgrade across the client firm.
Power BI
SQL
Power Apps
Microsoft Fabric
Qlikview
Tableau
Microsoft Azure
Dax studio/Tabular Editor
Microsoft Data Analyst (DA-100)