Lakshmi Devi Email & Phone Number

Bengaluru, Ka, In

Tamil Nadu, India

Bengaluru, Karnataka, India

• Analyze, design, and build Modern data solutions using Azure service to support visualization of data. Understand current Production state of application and determine the impact of new implementation on existing business processes.• 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.• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, Spark SQL, Azure Data Lake Analytics.• Enhanced and optimized Spark/python jobs to aggregate, group and run data mining tasks using the Spark framework. • Worked on migration of data from On-prem SQL server to Cloud databases (Azure Synapse Analytics (DW) & Azure SQL DB).• For real-time/batch analysis, reporting, optimization, data collecting, and associated tasks, design, manage, and maintain Azure data pipelines.• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into Data Warehouse• Experience in developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing& transforming the data to uncover insights into the customer usage patterns.• Wrote UDF’S in Scala and store procedures to meet specific business requirements • Primarily involved in Data Migration using SQL, SQL Azure, Azure Storage, and Azure Data Factory, SSIS, PowerShell• Performance analysis of batch jobs by using Spark Tuning parameters. • Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the Sql Activity.• Responsible for estimating the cluster size, monitoring, and troubleshooting of the Spark Data Bricks cluster

Bangalore

• 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)• 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.• Implemented data ingestion pipelines from multiple data sources using Azure Data Factory, Azure Databricks and other ETL tools. • Have good experience working with Azure BLOB and Data lake storage and loading data into Azure SQL Synapse analytics (DW)• Developed Big Data cloud-based enterprise solutions in PySpark and SparkSQL and related frameworks/libraries• Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns. • REST APIs to retrieve analytics data from different data feeds • Responsible for estimating the cluster size, monitoring, and troubleshooting of the Spark Databricks cluster.• Experienced in performance tuning of Spark Applications for setting right Batch Interval time, correct level of Parallelism and memory tuning. • Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the Sql Activity. • Analyzed, designed, and built data solutions for enterprise level businesses to support the visualization of their data from various sources, to understand and determine the impact and risk of changing their business processes.• Hands-on experience on developing SQL Scripts for automation purpose. Exported analyzed data to relational databases using Sqoop for visualization to generate reports for the BI team.

Bengaluru, Karnataka, India

• Automated the Alliance partners report card, Kanban for team assignments and Billing report using Tableau by using the SharePoint list connection.• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports• Worked on POC’s on Power BI/Tableau.• Reports were prepared with blending input sources, filters, parameters, and navigation with actions, displaying Financial analysis, line, stacked, bar chars on variance and correlation plot using financial forecast vs actuals spend. Data modelling was done by Power Query(M) and DAX in Power BI. • Created Tabular, Matrix, Chart Reports using SSRS from SQL Server Database (OLTP), and included various reporting features such as group by, drilldowns, drill through, sub-reports.• Designed and created data extracts, supporting Power BI, Tableau, Data Studio, or other visualization tools reporting applications.• Developed cost spend/saving analysis reports and dashboards by Manager and Venders.• Developed Power BI data visualizations using cross tabs, Heat Maps, Box and stacked bar, line chart, Scatter Plots, Geographic Map, Pie Chats.• Design and developed the Paginated Reports in Power BI Report Builder and Publishing into the Power BI Online Services.• Using Roles, we are providing security to the Users for Specific Data and for Specific Locations.• Written DAX calculation as per the requirement to maintain business measures.• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly filters the data.• Involved to designed/deployed Document Management Collaboration in SharePoint Online Portal to save the cost of $500M of external charges annually. • Designed, developed and deployed task management ticketing system with PowerApps workflow notification to user in SharePoint to save the cost $150K.Standardized and Implemented Email templates with standard dropdown selection for finance Settlement wire request for Managers and Director as part of automatio

Bengaluru Area, India

• Analyzing requirements from business and provided scalable development in SQL.• Analyzed existing SQL queries to identify opportunities for improvements.• Created optimal technical solutions to user needs with in-depth system analysis.• Developed, implemented and optimized stored procedures and functions using T-SQL.• Developed custom database objects, stored procedures and delivered application support.• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.• Designed and implemented TSQL queries for reporting and complex solution development.• Performed regular database backups to prevent information loss.• Followed standard practices for migrating changes to test and production environments.• Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.• Built data integration solutions to introduce new sets into asset repositories