VENKAT P

Around 5years of experience in Software Design, Database Design, Development, Integration Implementation and maintenance of Business Intelligence and the related Database Platforms.

• Strong Experience in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.
• Hands on experience in installing, configuring, managing, upgrading, and migrating, monitoring, and troubleshooting SQL Server 2019/2016/2014/2012.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experienced in writing the MDX queries to develop the Key Performance Indicator (KPI) Objects, Calculated Members, and Actions and to get the data from the OLAP cube for the reporting purpose.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Created calculated columns and measures in Power BI and Excel depending on the requirement using DAX queries.
• Experience stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
• Created custom calculated measures using Power BI DAX language to meet the business needs.
• Experience of a range of data processing languages and systems, including Oracle PL/SQL, SQL Server T-SQL, MySQL, and PostgreSQL.
• Experience in Microsoft Integration Services like SSIS(Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
• Hands on in Designing, maintaining and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS.
• Experience of designing and refining T-SQL stored procedures, functions, triggers, and views for effective data loading, transformation, and extraction methods.
• Experience in analyzing business user requirements, analyzed data and designed software solutions in Tableau Desktop based on the requirements.
• Developed and maintained tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax.
• Automated various Power BI related jobs using Power Shell activities.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling.
• Hands on Experience in Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory.
• Gained knowledge of how to automate the build, test, and deployment processes for software projects needing continuous integration and delivery (CI/CD) using Jenkins and Azure DevOps.
• Experience in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design.
• Experience one-time data migration of multistate level data from SQL Server to Snowflakewas implemented using Python and Snow SQL.
• Have knowledge Apache Spark's capacity to manage vast volumes of data and deliver insights, it is capable of processing and analyzing enormous amounts of data using Scala and PySpark.
• Knowledge on utilizing essential MapReduce, YARN, Hive, HBase, Flume, Sqoop, PySpark, Spark, SQL, and Kafka components of the Hadoop ecosystem to create and implement enterprise-based applications.
• Developed Python script to for processing large data sets and also to extract data from different files.
• Developed on how to manage projects, processes, custom fields, dashboards, and reports using JIRA.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.