Vivek Reddy Email and Phone Number

• 6+ years of experience in the IT industry performing Database Administration, Design, and Development using SQL Server and a BI developer with Azure.• Extensive experience in SQL database development and hands-on in SDLC, including design,development, testing, and post-production support.• Skilled in writing T-SQL statements for triggers, tables, constraints, variables, stored procedures,functions, views, and table-valued User-defined Functions (UDF) to ensure data integrity.• Expert in data extraction, transformation, and loading (ETL) processes SQL Server Integration Services (SSIS) and Data Transformation Service (DTS).• Developed ETL packages for integrating data from multiple sources and implemented ETL designs for incremental loads and data cleaning using SSIS.• Competent in using SQL Server Reporting Service (SSRS) to construct various reports (Tabular, Matrix, Drill Down, and Drill Through) and producing reports with features like sub-reports, grouping, and drilldowns.• Designed and implemented dynamic dashboards in Alteryx, providing real-time insights and improved reporting efficiency.• Created and constructed dimensions and cubes with star and snowflake schemas using SQL ServerAnalysis Services (SSAS) handled cubes with KPIs, and calculated members.• Good knowledge of Azure platforms, including Azure SQL, Azure Data Warehouse, Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake Storage Gen2 Storage for data extraction, cleaning, and publishing.• Developed and maintained end-to-end operations of ETL data pipelines and worked with large sets in Azure Data Factory and Azure Synapse Analytics• Experienced in developing Power BI reports and dashboards from multiple data sources using datablending.• Executed SQL Server backups, engaged in SQL upgrades and data migration, and oversaw packagesusing PowerShell.• Outstanding Communication and analytical abilities, able to comprehend business needs, self-educate, and proficiently manage projects.