Here, I worked with business stakeholders and cross-functional teams to define business requirements, KPIs, insights, business objects, and business intelligence solutions, for seamless data warehousing workflow processes, pipelines, and data flows towards a 65% reduction in the time taken after migration from on premises to cloud.Moreover, I tracked and enhanced auditing capabilities using Azure and formulated pipelines for data extraction, developed SQL queries, complex stored procedures, and user-defined functions, and designed/implemented databases triggers (DDL, DML). Also, I reviewed DAX queries to generate computed columns in Power BI, and created variables to reduce modelling activities, while applying DAX calculated measures and columns.Furthermore, I incorporated data from multiple data sources including APIs and servers, and executed transformations in Power Query. I also ideated key metrics, insights, static reports, and performance reports, using several features like table, charts, and graphs, while creating insightful dashboards using Tableau. Also, I applied Power BI to generate reports and used Power View and Power Map to visualize reports.Apart from above, I performed troubleshooting of data related and reporting solutions, row level security issues, and data protection matters, and worked with cross-functional teams to explain technical concepts of project and present reports using meaningful dashboards. I also introduced Power BI gateway using different sources of data storage to match analysis criteria and present findings in association with cross-functional teams within a fast paced environment.Also, I conducted ad-hoc data analysis to support decision-making for cost savings of 10% through process optimization. I also designed/sustained interactive dashboards using Tableau for a 20% increase in revenue. I executed data analysis to determined customer segmentation patterns for 7% improved customer conversion rates.

Here, I created and presented financial, operations, and flash reports KPIs targeting, while conducting trending analysis for the board of directors and stakeholders to support data-driven decision-making for sales and executive leadership teams for business processes.I created and implemented performance management models in Power BI to compute KPIs and track sales performance for a 15% increase in sales revenue. I also participated in data analysis, data cleaning, data modeling, data collection, and data visualization of unstructured data applying data sources like SQL, Python, Power BI, and Excel Identified Trends.Moreover, I executed data modeling and data transformation using Power Query Editor in Power BI Desktop to clean and capture data, manipulate data as per requirements, and streamline data quality. Also, I reviewed customer data to identify cross-selling/upselling opportunities for 12% increase in average transaction value.Furthermore, I used SQL to retrieve data and DAX functions like Logical, Aggregate, Case Statements, Relative and Time Intelligence, and Date Functions to create business computations as per needs of statistical techniques and data analysis. I applied complex data sets for Power BI to create dynamic reports/dashboards with Drill Down, Charts, and Tabular Reports as per customer needs with provision of IT support.Apart from that, I assessed/cleaned unstructured data using Excel and Python, and conducted in-depth statistical analysis, while delivering insights and KPIs via user-friendly dashboards using BI reporting tools for data-driven decisions with peer support for customer service delivery.Along with that, I researched and analyzed integrity decisions and engaged in reviewing accuracy, effectiveness, and modeling techniques of existing reporting frameworks in data analytics, while sustaining confidentiality and data protection for enhancing best practices via quality assurance with detail orientation.