Jayalakshmi Durga

Background

About Jayalakshmi Durga

SUMMARY: Professional with 7+ years of experience in total 3+ years of hands-on experience in SQL, T- SQL, Power BI development Hands on experience in SQL, T-SQL, Power BI, DW Concepts, Data Modelling SQL (SSMS): Advanced queries, complex joins, subqueries, data modelling, and data extraction Power BI: Advanced dashboard creation, DAX queries, dataflows, and Power BI Services Data Modelling: Design and maintain complex data models for reporting and analysis Data Analysis: Trend analysis, statistical methods, business insights Experience in SQL, T-SQL: Experience in Writing SQL Queries Experience on RDBMS concepts & with all database objects in SQL Experience at using the Integrity Constraints at column and table levels Experience on single row and multi row functions. Good experience at using joins Good at using sub queries, correlated sub queries and Set Operators Query Optimization and Performance Tuning Experience in using of Common Table Expressions (CTE) & creating indexes Experience at different database objects in T-SQL Good at understanding the business rules and application of logic in the sub programs Good at handling user defined functions Experience in Power BI: Develop Power BI reports, Custom Visuals, Groups Creation & effective dashboards after gathering & translating end user requirements Experience in data preparation in Edit Query like add column, change data types, split columns, combining two columns etc Imported data from multiple data sources, created relationships between data, created calculated columns & measures using DAX Query By using a different type of functions like Logical, Number, String, Window function, Date functions Creating Calculations & Advanced, Parameters, slicer & interactions Creating interactions of Highlight Action, Filter Action add interactivity to the visualizations Creating Storyboard with all the Dashboards Publishing reports to Power BI services & setting up the necessary connection details & scheduling Creating workspaces, Users & Groups assigning the permissions to end users & scheduling the reports in Power BI services Knowledge in ADF (Azure Data Factory) & Databricks: Basic understanding in Azure Data Factory in creating and configuring data pipelines for ETL tasks Exposure to connecting data from various sources like cloud storage and on-premises systems Understanding of connecting Databricks to Azure services like Blob Storage and SQL Databases Understanding of working with Databricks notebooks for basic data processing tasks Knowledge of scheduling and automating Databricks jobs through ADF