Rohith Krishna
Services provided: Microsoft Power BI , SQL Developers , Data Lake , Oracle SQL , Transact-SQL , Data Engineering , Azure Developers , Data Warehouse , Databricks , T-SQL , SQL Server , PL/SQL , SQL , Data Engineer , Tableau software , Tableau , Microsoft Azure , Data analysis , SSRS , Data Visualization Developers , MS SQL Developers , SSIS , Data Analysts , Azure
About Rohith Krishna:
5+ 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.
Experience
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
Education
PG Diploma at st. clair college (Data Analytics for Business )
Professionals who compete with Rohith
Professionals offering similar services to those of Rohith Krishna
Professionals in the same Technology / Internet sector as Rohith Krishna
Professionales offering Microsoft Power BI services
Professionales offering SQL Developers services
Professionales offering Data Lake services
Professionales offering Oracle SQL services
Professionales offering Transact-SQL services
Professionales offering Data Engineering services
Professionales offering Azure Developers services
Professionales offering Data Warehouse services
Professionales offering Databricks services
Professionales offering T-SQL services
Professionales offering SQL Server services
Professionales offering PL/SQL services
Professionales offering SQL services
Professionales offering Data Engineer services
Professionales offering Tableau software services
Professionales offering Tableau services
Professionales offering Microsoft Azure services
Professionales offering Data analysis services
Professionales offering Data Visualization Developers services
Professionales offering MS SQL Developers services
Professionales offering SSIS services
Professionales offering Data Analysts services
Professionales offering Azure services
Other users who are called Rohith
Jobs near Toronto, Ontario
-
Production Specialist
Found in: Talent CA C2 - 4 days ago
Shutterfly Markham, Canada Full timeDescription · At Lifetouch (part of the Shutterfly family of brands), we believe there is extraordinary power in the self-expression. Built on the tradition of "Picture Day", Lifetouch has captured the unique personalities of children and families for more than 85 years. · Job T ...
-
server - food and beverage services
Found in: Talent CA 2 C2 - 1 day ago
Granite Club Toronto, CanadaEducation: No degree, certificate or diploma · Experience: Experience an asset · Tasks · Address customers' complaints or concerns · Prepare and serve specialty food at customers' tables · Describe menu items including daily specials for customers · Advise on menu selections · Cl ...
-
cook
Found in: Talent CA 2 C2 - 2 days ago
Il Postino Markham, CanadaEducation: · Expérience: · Education · Secondary (high) school graduation certificate · Tasks · Prepare and cook complete meals or individual dishes and foods · Plan menus, determine size of food portions, estimate food requirements and costs, and monitor and order supplies · I ...