sripal

• Involved discussion with business users and provided technical guidance for Power BI Desktop and Power BI Service.
• Spearheaded the design and development of end-to-end Business Intelligence solutions using Microsoft BI Stack (SQL Server, SSIS, SSAS, SSRS).
• Implemented Power BI dashboards to visualize and analyze complex data, providing actionable insights to stakeholders.
• Led troubleshooting efforts for data discrepancies and performance issues, ensuring the accuracy and reliability of BI solutions.
• Collaborated with cross-functional teams to gather and analyze business requirements, translating them into effective BI solutions.
• Conducted regular training sessions for end-users, enhancing their proficiency in utilizing BI tools and dashboards.
• Contributed to the optimization of ETL processes, resulting in a 10% reduction in data processing time.

Involved discussion with business users and provided technical guidance for Power BI Desktop and Power BI Service.
Spearheaded the design and development of end-to-end Business Intelligence solutions using Microsoft BI Stack (SQL Server, SSIS, SSAS, SSRS).
Implemented Power BI dashboards to visualize and analyze complex data, providing actionable insights to stakeholders.
Led troubleshooting efforts for data discrepancies and performance issues, ensuring the accuracy and reliability of BI solutions.
Collaborated with cross-functional teams to gather and analyze business requirements, translating them into effective BI solutions.
Conducted regular training sessions for end-users, enhancing their proficiency in utilizing BI tools and dashboards.
Contributed to the optimization of ETL processes, resulting in a 10% reduction in data processing time.
Developed complex SQL queries and stored procedures to extract, transform, and load (ETL) data from various source systems into RDMS, ensuring data accuracy and integrity.
Troubleshot data-related issues in real-time and implemented effective solutions to ensure smooth data operations.
Designed and developed RESTful APIs using Azure API Management to expose data services and enable seamless integration with external applications and services.
Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics.
Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
Implemented version control systems like Git and GitHub for efficient code management.
Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
Migration of on-premises data (SQL Server / MongoDB) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V1/V2).

Worked closely with business users to congregate and comprehend requirements.
Prepared documentation for all the requirements and enhancements to reports.
Designed and developed SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle, and SQL server using SSIS.
Built automated reports for business users using SSRS and SharePoint subscriptions.
Migrated the needed data from Oracle, MySQL into HDFS using Sqoop and imported various formats of flat files into HDFS.
Migrated ETL jobs to Pig scripts and did Transformations, even joins and some pre-aggregations before storing the data onto HDFS.
Preparing Daily reports of Agent wise performance, Adherence, Productivity, and other reports related to monitor the FTD performance.
Data Mining and Data analysis to identify the Useful information for the Business development.
Root Cause Analysis on Escalations
Preparing Presentations to global and local business leaders with information of complete DECK which consists of overall business performance for MBR / WBR.
Maintaining all the data records of contact center performance and maintaining confidentiality.
Having good Experience in Power Bi Desktop and Power Bi Service and Power Bi Report Server
Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB).
Utilized Python and SQL for data manipulation and analysis, including writing DDL/DML/DQL queries.
Worked with databases such as SQL Server, Teradata, and Snowflake for diverse data storage and retrieval needs.
Implemented data partitioning and archival strategies in RDBMS to manage large volumes of historical data while minimizing storage costs and maintaining data accessibility.
Led a migration project to transition on-premises relational databases to Azure SQL Database, including database schema conversion, data migration, and post-migration validation.
Ability to deploy, manage, and monitor Snowflake and Azure data solutions using Infrastructure as Code (IaC) principles, ensuring repeatability, consistency, and scalability.
Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
Design Setup maintain Administrator the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse.

Developed workflow in SSIS to automate the tasks of loading the data into HDFS and processing using hive.
Spearheaded the optimization of data solutions for performance, scalability, and cost-efficiency using Azure technologies.
Spearheaded the development of custom BI solutions utilizing Power BI, Azure Synapse, and SQL Server.
Successfully implemented solutions for data orchestration, big data processing, and security management.
Acted as a subject matter expert in Azure data technologies, including Azure Functions and Azure Event Hub.
Demonstrated excellent written and oral communication skills, effectively articulating technical concepts to both technical and non-technical stakeholders.
Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
Worked with Various HDFS file formats like Avro, Sequence File, and various compression formats like snappy, Gzip.
Worked in determining various strategies related to data security.
Conducted thorough testing and validation of APIs using tools like Postman and Swagger, verifying functionality, performance, and adherence to API specifications and standards.
Performance monitoring and Optimizing Indexes tasks by using Performance Monitor, SQL Profiler, Database Tuning Advisor, and Index tuning wizard.
Worked on Hue interface for Loading the data into HDFS and querying the data.
Wrote scripts and indexing strategy for a migration to Confidential Redshift from SQL Server and MySQL databases.
Collaborated with cross-functional teams to define data governance policies and standards for RDBMS, ensuring compliance with regulatory requirements and industry best practices.
Involved in converting Hive/SQL queries into Spark transformation using Spark RDDs.
Used Avro, Parquet, and ORC data formats to store into HDFS.