Venkateshwar R

9+ years of IT Experience in Database Design, BI-Development of Microsoft SQL Server 2018/2016, Snowflake. Azure SQL DB, Azure Data Lake Store, Azure Data Factory, DBT on various development, test, and production environments in various business domains. Experience in writing T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments. Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes, Dynamic SQL, Joins, Cursors, CTE and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2016/2012. Highly proficient in Tuning SQL queries and improving the query performance. Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan. Worked on Data Factory to load data from Data Lake to Azure SQL Data warehouse and Azure SQL. Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL Data Warehouse environment. Worked on Data Lake Analytics (Azure Data Bricks) to transform the data as needed to build the tabular model in Azure Analysis Services and automated the refresh of tabular models using Azure Run books, Azure Automation Account and Azure Functions. Design and implement end-to-end data solutions (storage, integration, processing, and visualization) in Azure. Experienced in InfoPath, Power App, Nintex form in designing, developing and defining data structures of electronic form and integrating within the Sharepoint Platform. Hands-on experience in designing and developing cloud solutions based on Microsoft Power Platform using Power Apps, Power Automate, Power BI, Power Apps Portal and Common Data Services. Experienced in Power Automate working with Services, triggers, actions, conditions, parallelism, and loops. Working with Services, triggers, actions, conditions, parallelism, and Loops- Run a flow on Schedule, calling custom business services using approval options, observing flows, Team Flows-Extending Power Apps with Flow- Extending Flow with Power Apps. Created SSIS packages to Extract, Transform and Load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS Transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all. Experience in Virtual Warehouse, Performance Tuning Snow SQL Queries. Good knowledge on HVR Replication, replicated more than 400+ tables from on prim to Snowflake. Used For-Each Loop Container, Sequence Container, Script task, Expressions, execute SQL task, Variables, send Mail Task, Package Execution task to achieve business needs. Expert in Creating and managing roles for security in SSRS Reports. Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security. Ability to define and develop Report Structure with data definition, report layout and report definition language. Strong ability in defining query for generating drill through, drill down reports canned and cache reports with drop down menu option, sorting the data, defining subtotals and creating report layouts using SSRS 2012/2008. Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, Conditional, List items, Charts, Sub reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS). Expert in Publishing and Sharing Workbooks, Data Sources with User Filter to Tableau Server, Setting Schedules for the extracted reports, Authorization and Permissions, incremental refresh extracts and updating server data that are using extracts. Worked on numerous dashboards in Tableau Desktop based on the data collected from different locations by importing and blending data from MS Excel and CSV files along with SQL Server Database. Strong knowledge in Power BI on how to import, shape, and transform data for Business Intelligence (BI), Visualize Data, author reports, schedule automated refresh of reports. Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways). Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling, and reporting tools. Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters. Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates like Named Set, MDX Query and Custom Table. Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and Snowflake schema’s design and implementation. Experience using different Version Control Tools like Microsoft Source Safe and TFS. Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem-solving skills. Diligent BI Developer with 9+ years of experience performing detailed compilation and maintenance of extensive database systems to track complete BI information. Integral leader when overseeing analytics to generate critical custom business intelligence reports. Applies detail-oriented process for overseeing analytics application availability and performance, from planning through end-of-lifecycle. Crucial contributions to BI database backup, recovery and maintenance.