Involved in requirement gathering, analysis, design, development & deployment. Collaborated on ETL tasks, maintaining Data integrity, and verifying ADF pipeline stability. Designed and developed ADF pipelines using Activities to facilitate the incremental load process. Worked on Databricks, created Notebooks for doing data cleansing and data transformations, and copy it to the Azure Data Lake storage or Azure Synapse (DW) or Azure SQL DB. Data integration between various systems using Rest API. Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schemas such as Microsoft SQL Server and Azure Services. Working knowledge in deploying CI/CD pipelines using Azure DevOps. Used Azure DevOps services such as Azure Repos and Azure Boards to plan work and collaborate on code development, built and deployed applications. Automate deployment Pipelines for Power BI Items using Power BI Rest APIs. Developed and deployed dashboards, visualizations, and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the BI reporting platform Power BI Service. Optimize report distribution, execution, and the scalability of all reporting solutions so they are autonomous and dynamic. Work with various Team Members, internal departments, and third-party agencies on reporting business requirements, documentation, timelines, testing, and technical delivery.

Involved in gathering, analyzing, and displaying financial data from SAP ERP, Sales Force CRM and FPNA systems. Experienced on Azure cloud platform in components of ADF, ADLS, and Azure SQL DB & Data Warehouse (Synapse / Fabric). Copy the Data from Data Source to Landing Stage, Transform the Data in Staging and create the Facts & Dimension Table in the Data Warehouse. (Synapse / Fabric / Databricks) Experienced working on Star and Snowflake Schema and used the facts and dimension tables to build the cubes, perform processing, and deployed them to the Data Warehouse. Designed and developed ETL packages to facilitate the incremental load process for transactional Data. Developed complex SQL queries using stored procedures to support power BI and SSRS reports. Create the Calculated columns, Calculation Groups and Dax Measures in the Power BI Desktop / Tabular Editor. Implemented Dynamic Row level security to restrict data access to the users based on their roles. Design reports for Finance like Balance Sheet, Income Statement and Budget vs Actual Report. Design reports for Sales & Expenses like Sales / Purchase Analysis, Aging Report, Travel Expenses and Recurring Expenses reports. Developed and deployed dashboards and dynamic reporting interfaces distributed to stakeholders via the Power BI Service, Power BI Embed, mobile, tablet devices, widgets, and email. Work with various Team Members, internal departments, and third-party agencies on report business requirements, documentation, timelines, testing, and technical delivery.

Involved in Technical and Business decisions for Business requirements, Interaction with Business Analysts, Client Coordinator, and Development team through the Agile Kanban process. Create Copy Data Activity using ADF for loading the data from On Premises SQL Server/ Excel files into Azure SQL database or ADLS. Involved in processing ETL transformations, data validations, and stored procedures. Experienced working on Star and Snowflake Schema and used the facts and dimension tables to build the cubes, perform processing, and deployed them to the Data Warehouse. Experienced in Developing Power BI Reports and Dashboards from multiple data sources including Excel files, ADLS, REST APIs, Azure Synapse and Databricks. Responsible for creating and changing the visualizations in Power BI reports and Dashboards on change requests from the Scrum Master. Created Calculated Columns and Measures in Power BI depending on the requirement using DAX queries. Created Dashboards and Interactive Visual reports in Power BI, used proper visual for the right kind of report in the Dashboard. Worked with Import, Direct Query and Composite model connectivity modes in Power BI. Managing Power BI Premium capacities and access to standard monitoring and usage reporting.

Preparation of Blueprint, Project Plan, and Documentation for discussions. Mapping of clients complex business process into SAP B1. Handling Requirements, design, build, and testing of the product. Writing SQL queries, views, and stored procedures. Managing SQL Backups, SBO Backups, and restore Backups. Migrating Master Data and Transactional Data using Data Transfer Workbench. (DTW) Creating UDF, UDT, and UDO as per business requirements in SAP B1. SQL queries for any type of business reports, formatted search (FMS), and Transaction Notification (Stored Procedure). Preparation of Functional Specs for the Technical Team to customize screens. Implementation experience and knowledge of SAP Business One reporting for different functional areas.