Kavitha

Kavitha

BI Developer
United Kingdom

نبذة عني

A dynamic and skilled BI Developer, ETL & Data Engineer, and Analyst with 3 years of extensive IT experience. Highly proficient in data cleansing, data transformation, data analytic and visualization, as well as extracti…

الخبرة

Data Engineer

Cipla
Jan 2023 - حتى الآن · 3 سنوات 6 أشهر

 Worked with management and stakeholders to gather and review business requirements,
and then translate them into clear and concise specifications and deliverables.
 Designing and implementing data integration solutions using Synapse and Data Factory to
move data between various data sources, including on-premises and cloud-based systems.
 Worked on ARM templets to deploy in ADF pipelines to production using Azure DevOps.
 Used Data Factory Dataflows to build ADF data flow pipelines. Improved performance by
using optimization options by effectively using partitions during various transformations.
 Built Data pipelines using ADF to extract, transform and load data from different sources like
storage account, ADLS, files like. JSON, .XML, Parquet, .CSV to Azure SQL DB.
 Automated pipelines deployments from Dev to Test and Test to Prod using CI CD.
 Automated ADF pipelines and Synapse notebooks using various data factory triggers.
 Used Azure Key vault as central repository for storing, maintaining secrets and referenced
the secrets in Azure Data Factory and in Synapses notebooks.
 Keeping up to date with emerging technologies and best practices in data engineering, and
applying them to improve data processing efficiency, scalability, and reliability.
 Developed Power BI solutions by configuring the data security and assigning the licenses and
sharing the reports and dashboards to different user groups in the organization.
 Interpret data and analyze results using various techniques to provide ongoing reports and
actionable data and business insights using Tableau and Power BI.
 Track performance weekly in key doors and programs and communicate to teams to quickly.
 Worked on Power BI services to manage users, and schedule reports, provide maintenance.

BI Developer, ETL & Data Engineer, and Analyst

Cipla, UK
Jan 2023 - Dec 2023 · 11 أشهر

Worked with management and stakeholders to gather and review business requirements, and then translate them into clear and concise specifications and deliverables.
Designing and implementing data integration solutions using Synapse and Data Factory to move data between various data sources, including on-premises and cloud-based systems.
Worked on ARM templets to deploy in ADF pipelines to production using Azure DevOps.
Used Data Factory Dataflows to build ADF data flow pipelines.
Improved performance by using optimization options by effectively using partitions during various transformations.
Built Data pipelines using ADF to extract, transform and load data from different sources like storage account, ADLS, files like JSON, XML, Parquet, CSV to Azure SQL DB.
Automated pipelines deployments from Dev to Test and Test to Prod using CI CD.
Automated ADF pipelines and Synapse notebooks using various data factory triggers.
Used Azure Key vault as central repository for storing, maintaining secrets and referenced the secrets in Azure Data Factory and in Synapses notebooks.
Keeping up to date with emerging technologies and best practices in data engineering, and applying them to improve data processing efficiency, scalability, and reliability.
Developed Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to different user groups in the organization.
Interpret data and analyze results using various techniques to provide ongoing reports and actionable data and business insights using Tableau and Power BI.
Track performance weekly in key doors and programs and communicate to teams to quickly.
Worked on Power BI services to manage users, and schedule reports, provide maintenance.

BI Developer, ETL & Data Engineer, and Analyst

ITC infotech, Worked for RBC Insurance, Carma Developers
Mar 2021 - Nov 2022 · 1 سنة 8 أشهر

Work cross functionally with analysts, business insights, report developers, and stakeholders to ensure a tight Development/QA/UAT process and quality deployments.
Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different data sources like Excel, SQL Server, Csv, CRM Systems using ADF.
Designed and implemented end-to-end data solutions on the Azure platform, utilizing Azure Data Factory, Azure SQL Database, Azure Synapses, and Azure Data Lake Storage.
Used Power BI, Power Pivot, Power Query, Custom Invoke Functions, Blank Query to develop data analysis prototype, and used Power View and Power Map to visualize reports.
Designed and developed quality Power BI reports to clients by conducting quality assurance checks and recorded a 70% increase in controlling the orders transactions.
Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
Developed Power BI reports for large enterprise scale clients with story-telling visualizations.
Worked on DAX to create calculated measure, column, and variable to extract the required metrics, KPI’s that shows business trend, pattern, and provide insights.
Use data Power BI, and Tableau visualization tools to provide a user friendly, easy-to-understand interface for end users to quickly identify key themes within their data.
Used Power BI service, and Azure Active Directory to create and manage user and control user access using Row Level Security, implemented auto schedule refresh on reports.

BI Developer, ETL & Data Engineer, and Analyst

DFX Finance
Jan 2020 - Feb 2021 · 1 سنة 1 شهر

Involved in Requirements gathering, data analysis, BI solutions Design, Development, Testing and Production roll of Reporting and Analysis projects using Tableau and Power BI.
Communicate with internal clients to develop and translate a business requirement into an effective and insightful interactive analytical dashboard in Tableau and Power BI.
Maintained existing BI solutions and identified patterns for opportunities to improve the system process flow, performance and technical efficiencies using Power BI, Tableau.
Published Power BI Reports into PBI services, Tableau reports into Server and made reports available in Web clients and mobile apps for users access to analyse the performance.
Designed and developed ETL workflows and datasets in Alteryx and used it for Data Preparation and then Tableau for Visualization and Reporting.
Identified Key Performance Indicators (KPIs) and analyzed past trends to better answer business questions and provided data and business insights in the for reports, dashboards.
Quickly and effectively diagnose and respond to users requests regarding data integrity and functional or interactive issues in existing and future dashboards in Tableau and Power BI.
Worked on Power BI services to create workspace and publish the reports into services.
Automated reports refresh using gateways, created incremental refresh using parameters.

المهارات

البيانات الضخمة أزور هادوب (Hadoop) مايكروسوفت أزور (خدمة حوسبة سحابية) سكالا سبارك أباتشي هايف أباتشي بيغ كافكا ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) ADF Synapse ADLS Storage Logic Apps SQL Server MySQL Oracle Azure Data Factory Alteryx Power BI Tableau Azure SQL Database Azure DevOps Azure Key Vault CI/CD Data Warehousing Data Modeling Dimensional Modeling Star Schema Snowflake Modeling Kimball Methodology Data Cleansing Data Transformation Data Visualization Data Analysis RDBMS Data Integration Data Pipelines Dataflows ETL DWH Azure SQL Azure Data Lake Storage Power Pivot Power Query DAX Power View Power Map Azure Active Directory Row Level Security Incremental Refresh Gateways
الإبلاغ عن هذا الملف الشخصي؟