Sql Server Power Bi

KAVYASRI VADDE

Apex, NC

+1-603-***-**** ad9sgc@r.postjobfree.com https://www.linkedin.com/in/kavyasri-vadde Summary

Microsoft Certified Azure Data professional with over 8 years of experience in database design, development, and analysis. Proficient in T-SQL/ETL development and skilled in creating SSIS packages for data migration. Experienced in Azure SQL Server DB and Azure VM migrations, with a solid foundation in SSRS and Power BI for reporting. Aiming to leverage extensive experience to drive data engineering initiatives and optimize data workflows. Skills

Skills: MS SQL Server (2012/2014/2019), T-SQL, MySQL, Oracle, SSRS, SSIS, SQL Profiler, Visual Studio 2019, SQL Server Report Builder, SSMS, Azure Data Factory, Azure Synapse Analytics, Salesforce, GitHub, Python, Power BI, C#, .NET, REST API, PowerShell, Jira, Relational Databases, ETL

Work Experience

Pentegra Oct 2021 - Feb 2024

Senior Database Developer

Developed extensive ETL pipelines utilizing Azure Data Factory, leading to a 30% increase in workflow efficiency.

Architected robust data models that supported business intelligence insights, driving a 25% lift in data driven decision making.

Led the design and development of a scalable Azure-based analytics platform, enhancing data processing speed and reliability

Designed and created data mappings from various sources, including Flat files, DB2, Excel files, OLEDB, and ODBC data sources, ensuring seamless data integration

Orchestrated the development and deployment of SSIS packages, integrating data from diverse sources like Flat Files, Salesforce, and Excel into the Enterprise Data Warehouse, resulting in a 20% increase in data accuracy and consistency.

Generated Daily, Weekly, Monthly, Subscriptions, and Dashboard reports using SSRS and optimized report performance.

Converted Python scripts to SSIS packages and scheduled jobs using SQL Agent for daily execution.

Developed a data warehouse that enabled users to easily query complex datasets.

Created operational reports and analytical dashboards on Azure Data Warehouse using Power BI and Azure Analysis Services.

Facilitated project planning by effectively estimating technical tasks, resulting in on-time sprint execution and delivery.

Developed PowerShell scripts to automate full, differential, and transaction log backups for SQL Server, reducing backup window time by 25% while maintaining data integrity and compliance. PoliteMail Software Sep 2015 - Oct 2021

Software Developer II Portsmouth, NH

Developed SQL Server stored procedures, T-SQL queries, Functions, Views, and Triggers, improving database performance and reliability

Completed a SQL migration from MySQL to SQL Server, fixing critical defects addressed during conversion.

Worked on Syncronym, a service-driven ETL tool from PoliteMail, and developed Web API Controllers, enhancing data processing efficiency

Created PoliteMail Custom Connector for automated workflows and generated custom reports using Microsoft Power BI, streamlining reporting processes

Designed SSIS Packages for data extraction, transformation, and loading (ETL) operations, ensuring accurate and timely data integration

Developed stored procedures, triggers and functions that automated manual processes and improved performance by 30%.

Developed a dashboard to visualize key performance metrics, allowing management to make informed decisions quickly. Techminds LLC Jul 2015 - Sep 2015

SQL Developer Hampton, NH

Involved in Database Design using Normalization Techniques and developed complex T-SQL code for applications.

Involved in writing scripts for querying databases. Developed queries, sub-queries, stored procedures, triggers, and functions.

Created and Modified Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as per business requirements.

Tested to optimize the Stored Procedures and Triggers to be used in production.

Implemented fine tuning of database objects and server to ensure efficient data retrieval. Education

Southern New Hampshire University

Master of Science in Information Technology Manchester, NH JNTU

Bachelor of Technology in Electronics and Communication Engineering, India Certifications

Microsoft Azure Data Fundamentals

Contact this candidate