B Kavitha

Data Professional with 8+ years of IT experience specializing in database development, ETL, and data analytics solutions using Microsoft SQL Server, SSIS, Alteryx, and Azure Data Factory (ADF). Experienced in designing, developing, and optimizing data pipelines and analytical workflows to support business intelligence and reporting. Certified in Alteryx Designer (Core & Foundational Micro-Credential) and Microsoft Azure Fundamentals (AZ-900). Skilled in requirements analysis, test planning, solution design, and providing technical guidance to development teams. Hands-on experience working in Agile (Scrum) and Waterfall methodologies, including sprint planning, application demos, unit testing, and defect resolution. Domain experience in Taxation, Retail, and Insurance, delivering data-driven solutions aligned with business requirements.

Database:

• Designed and optimized relational database schemas including fact and dimension tables for enterprise data warehouse solutions to support analytics and reporting.
• Developed complex SQL queries involving joins, window functions, CTEs, and aggregations to transform and analyze large-scale datasets efficiently.
• Implemented ETL/ELT data pipelines to extract data from multiple sources, load into staging layers, and perform transformations in the database using SQL and DBT.
• Optimized database performance by tuning queries, managing indexes/partitions, and leveraging Snowflake features like clustering, micro-partitions, and query profiling.
• Ensured data quality and integrity through constraints, validations, reconciliation checks, and automated testing in data pipelines.

Alteryx:

• Developed end-to-end data workflows in Alteryx to extract, cleanse, transform, and prepare data from multiple sources such as databases, Excel files, and APIs for analytics and reporting.
• Implemented data preparation and transformation logic using Alteryx tools like Join, Union, Formula, Filter, Summarize, and Data Cleansing to automate complex data processing tasks.
• Optimized workflow performance by using best practices such as efficient joins, batch macros, and workflow scheduling to handle large datasets efficiently.
• Integrated Alteryx workflows with enterprise databases and BI tools to deliver curated datasets for downstream reporting and analytics teams.

PowerBI:

• Developed interactive dashboards and reports in Power BI to visualize business metrics, KPIs, and trends for stakeholders using charts, tables, and slicers.
• Created data models and relationships by integrating data from multiple sources such as SQL databases, Excel files, and cloud platforms to support analytical reporting.
• Implemented DAX calculations and measures to perform advanced analytics, including time intelligence, aggregations, and business logic for dynamic reporting.
• Optimized report performance and usability by applying data modeling best practices, managing filters, and designing user-friendly dashboards for business users.

Project Experiences:

• Collaborated with business stakeholders to gather and analyze requirements, prepared functional and technical design documents, and obtained approvals before initiating development.
• Worked in Agile and Waterfall methodologies, creating and managing product backlogs, performing effort estimations with teams, and prioritizing user stories for sprint planning.
• Coordinated code deployments across multiple environments (Dev, QA, UAT, Prod), supporting developers during releases and ensuring smooth migration of code between environments.
• Scheduled, monitored, and maintained batch jobs using SQL Server Agent and Control-M, while providing production support and troubleshooting job failures or data issues in collaboration with technical and business teams.