ABHIJEET TIWARY

• Created and optimised Power BI reports and dashboards to process and integrate data from various sources, ensuring data availability and reliability.
• Developed data workflows in Azure Data-bricks for transforming raw data into structured datasets stored in Delta Lake, enabling high-performance analytics.
• Implemented fully interactive dashboards for capturing manager, supervisor, and agent commission; improved their manual efforts by calculating reliable commission numbers.
• Implemented row-level security so that agents who log in can only view the commission numbers.
• Developed and oversaw the report for the Customer Relations Department, which is a one-stop shop for all the incidents (complaints, inquiries, praises).
• Collaborated with business leaders to understand their analytical needs, and provide customized data solutions.
• Communicated data findings and recommendations effectively to non-technical stakeholders, facilitating data-driven decision-making.
• Transitioned SQL Queries from On-Premise SQL Server/Azure Synapse Analytics to Azure Data-bricks (Apache Spark SQL)

• Developed and optimised interactive dashboards and reports to visualise healthcare data, enabling data-driven decision-making.
• Utilized Power BI, DAX, and M Language to create robust data models and perform advanced analytics.
• Developed and optimised SQL Queries to assist Business Intelligence practices.
• Managed end-to-end Project delivery, ensuring timely completion following Sprint practice under Agile Methodologies.
• Implemented security measures for Power BI Reports using RLS mechanisms.
• Implemented Data Warehousing solutions using SSIS for improved Analytics and Reporting capabilities.
Provided ongoing support for existing Power BI dashboards and reports for a hospitality client, ensuring data accuracy, troubleshooting issues, and optimizing performance to meet business needs.