beBee background
Professionals
>
Technology / Internet
>
Toronto
Rohith Krishna

Rohith Krishna

Data Engineer
Toronto, Ontario
$60 / hour
Approximate rate

Social


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

Professionals from different sectors near Toronto, Ontario

Other users who are called Rohith

Jobs near Toronto, Ontario

  • Shutterfly

    Production Specialist

    Found in: Talent CA C2 - 4 days ago


    Shutterfly Markham, Canada Full time

    Description · 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 ...

  • Granite Club

    server - food and beverage services

    Found in: Talent CA 2 C2 - 1 day ago


    Granite Club Toronto, Canada

    Education: 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 ...

  • Il Postino

    cook

    Found in: Talent CA 2 C2 - 2 days ago


    Il Postino Markham, Canada

    Education: · 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 ...