Meeting with clients to understanding their needs, and determining gaps between those and technical functionality, and collaborating with all stakeholders to generate mutually agreeable and advantageous Business Intelligence and Data Engineering solutions. · Creating and maintaining project related documentation (Statement of Work Document, Proof of concept document, technical design document etc.) · Supporting sales/pre-sales, manage resources and developers, assist in defining team objectives, provide subject matter expertise and conduct performance reviews.· Designing Business Intelligence reports using Power BI (utilizing DAX Expressions, Power Query, Power Pivot, Power BI Desktop) & Tableau, based on client preference.· Developing Complex Power Bi calculated Measures, Calculated Columns and Row Level Security (RLS) using DAX in Power BI Desktop, complex visuals & dashboards, scheduling dataset refreshes in Power BI Service, implementing Power Query, Power Pivot.· Enhancing and Performance Tuning of SQL Scripts, SQL modules delivered to production by rewriting and developing new SQL code to improve the efficiency and effectiveness of systems.· Creating advanced SQL Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.· Providing the Power BI Training for internal Employing and team. Helping customer to provide the training on new azure services and features. Helping Customers for application monitoring and providing the internal training. · Building Azure Data Engineering solutions for Cloud Migration, Data Migration, Azure data factory, Databricks, Azure Synapse Analytics, Stream analytics, Cloud Services, Azure SQL Database, Azure Blob storage.

Working with the infrastructure team to maintain databases, design ETLs and build Analytics Reports, following complete SDLC life cycle during requirement collection, analysis, design, and development of BI solutions. · Gathering business requirements, conducting interviews, developing customized applications, designing, testing, and deploying enterprise-wide ERP solutions, and project management.· Creating and modifying various SQL Stored Procedures used in the application using T-SQL. Worked on performance tuning of SQL Views, CTE's, stored procedures. Automated back-end SQL Server processing, creating maintenance plans and SQL Agent.· Building SQL deployment scripts for OLTP backend databases and Data Warehouse implementation using T-SQL for DDL, DML and DCL programming objects like Database tables, SQL Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQL SERVER 2005/2008 R2/2012/2014/2016. · Designing ETL dataflows using SSIS. Developing SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, DB2, MS accessing SQL Server SSIS 2008 R2/2012. · Creating reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. · Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements. Creating DAX formulas, installing Power BI gateways, adding Power BI users, user groups and implementing RLS in Power BI service.· Experience in creating SSRS reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.