Drives performance of analytics solutions to impact overall business results while keeping costs in check and ensuring the department remains within the planned budget. Determining and sourcing the right team for Analytics & heading the data analytics departments in strategy development about the collection, manipulation, and analysis of data for various business functions/departments such as Marketing, Sales, Operations, among others. Specialties :Setting the departmental vision for the use of data in making key business decisions. Handling day-to-day analytical approaches and exploring solutions to particular problems. Consult with several departments across the Customers to understand, document and analyze business requirements that drives the development and design of the BI solution.Have done end-to-end development of Power BI business insights for the MS Dynamics and SAP Customers for many industries like food and beverage industry, manufacturing industry, electronics industry, retail industry, wholesale distribution, Entertainment, Agriculture, Infrastructure and many more.Heading the team for the Projects of SQL and Power BI Solutions and providing them the optimized solutions as per the client’s requirement.Design, develop, and implement various customized reports and dashboards for Client on BI Tool (Power BI, QlikSense and Tableau) with the help of relevant “Data Modeling” Technique and scripts.Handling various Extract, Transfer and Load (ETL) reporting mechanism and offer the finest solution as per the of data volume of the transactions.Maintain data and create SQL and Python queries as per the requirement, also done Data-Warehousing with the technique of “Linked Server”, “Hadoop HDFS Architecture” and “SSIS packages”.Performance Tuning with dive-in into query SQL performance, QlikView and Power BI desktop, understanding the dashboards and query caches.Follow the best practices for the Schedulers and also set up performance monitoring on the machine and mail subscriptions to the stakeholders.Also have the architectural knowledge of Microsoft D365, AXAPTA, SAP B1, HANA and NAVISION data structure and created OLAP cubes for the data analysis.Created Sales, Manufacturing, Purchase, Inventory, Maintenance, Export, Profitability, Retail, Stocks, Expense Management, Workforce Management, SCM and other Finance - related dashboards as per the client’s requirements.Also have worked on Customized ERP to design the solution for the customer and incorporated the solution with the detailed knowledge of transformation of data.