Rohith Krishna

4+ years of total IT experience in Database Design, Modeling, Programming, Development, and Implementation of Client-Server Applications & Database systems using SQL Server 2005/2008/2008R2/2012/2014/2016/2018.  Experience in data warehousing and Business Intelligence Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, and Power BI for building, deploying, and managing applications and services through a global network of Microsoft - managed data centers.  Created multiple customized SQL Procedures & Packages for various business needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.  Excellent understanding of Business Requirements Gathering, Translating Requirements into Specifications, and Application Design. experience with data modeling, data warehouses, and/or ETL/ELT pipelines and experience with programming languages like Scala, Python  Proficient in Technical and Business writing, Business Process Flow, Business Process Modeling, and Testing.  Involved in Test Planning, Test Preparation, Test Execution, and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
 Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support, and maintenance of business applications using SQL Server 2014/2012/2008/2005, SSIS and SSRS 2005/2008/2012/2014/2016.
 Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, and Triggers, and using the latest features to optimize performance like Bulk Binds, Inline views, and Global Temporary Tables.
 Expertise in working with various operational sources like DB2, Oracle, Teradata, SQL Server, and Flat Files
 Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs), and Complex Queries on Microsoft SQL Server 2014/2008R 2/2008/2005.
 Experience in database development and release management concepts, practices, and procedures along with performance-tuning database code in OLTP and OLAP environments.
 Experienced in SSAS Tabular data modeling.  Implemented Copy activity, and Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
 Hands-on Experience working with Azure Data Lake Analytics to analyze structured, and non-structured data from various sources.  Experience in creating Ad-hoc reports, and data-driven subscription reports by using Report Builder in SSRS  Good experience in importing and exporting data from various sources using SQL/SSIS  Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
 Hands-on experience in creating and deploying SSAS cubes using Star Schemas and Snowflake Schema.  Experience in Microsoft Power BI Tools such as Power Pivot, Power Map, and Dashboards. Comfortable using Tableau. And have good Experience creating and maintaining reports.
 experience coding SQL stored procedures and queries
 Integrated Custom Visuals based on business requirements using Power BI desktop.
 Worked in Implementation life cycles of both Agile and Waterfall Methodologies.
 Excellent problem-solving, analytical, technical, interpersonal, and communication skills and an extremely diligent strong team player with an ability to take on new roles.  have good experience using visualization tools such as Power BI, Tableau, Qlik, Excel

PG Diploma at st. clair college (Data Analytics for Business )