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.

<p>Involved discussion with business users and provided technical guidance for Power BI Desktop and Power BI Service.<br>
Spearheaded the design and development of end-to-end Business Intelligence solutions using Microsoft BI Stack (SQL Server, SSIS, SSAS, SSRS).<br>
Implemented Power BI dashboards to visualize and analyze complex data, providing actionable insights to stakeholders.<br>
Led troubleshooting efforts for data discrepancies and performance issues, ensuring the accuracy and reliability of BI solutions.<br>
Collaborated with cross-functional teams to gather and analyze business requirements, translating them into effective BI solutions.<br>
Conducted regular training sessions for end-users, enhancing their proficiency in utilizing BI tools and dashboards.<br>
Contributed to the optimization of ETL processes, resulting in a 10% reduction in data processing time.<br>
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.<br>
Troubleshot data-related issues in real-time and implemented effective solutions to ensure smooth data operations.<br>
Designed and developed RESTful APIs using Azure API Management to expose data services and enable seamless integration with external applications and services.<br>
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.<br>
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.<br>
Implemented version control systems like Git and GitHub for efficient code management.<br>
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.<br>
Migration of on-premises data (SQL Server / MongoDB) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V1/V2).</p>

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

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