Ramesh Kori Email & Phone Number

● IT professional with 6+ years of experience in total● Hands on experience working on SQL, T-SQL, Power BI & Data Warehousing.● Well-versed in using SQL Server Built in functions (Character or String Functions, Numeric Functions, Date Functions and Windows Functions).● Hands on experience in using Joins, Sub queries, Set Operators, Temporary tables, Table variables & CTE’s. ● Experience in creating Stored procedures, Views, UDF (User Defined Functions). ● Designed & created SQL Databases with proper relationships (PK, FK relationships), tables, indexes, and views based on requirement.● Good knowledge in Data Warehouse Concepts.● Having Good Experience on Power BI Desktop and Power BI Service Development and worked on the Power BI Reports & Dashboards with SQL Server.● Imported data from multiple data sources into BI Tool, created relationships between data, created calculated columns and measures using DAX Query.● Experience in Data modelling, Creating Relationship, Hierarchies and Groups. ● Creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. ● Used Bookmarks concept and used custom visuals like Dough nut chart, waterfall chart, and gauge chart, bar chart etc.● Having experience in creating different charts like Line chart, bar chart, table, matrix table, area chart, scattered chart, tree map.● Experience in creating different custom visualizations like Dough nut chart, waterfall chart, and gauge chart, bar chart etc.● Creating Formatting, Advanced Formatting in tooltip labels like descriptive tooltips, and conditional formatting.● Developed Power BI Reports and Dashboard on Live Connection and Import mode.● Understanding the Business Requirements, Identifying the system and getting it Developed and Implemented in Power BI.

• 

  Software Engineer

  Abs (Assertive Business Solutions)

  Sep 2020 - Present - Bengaluru, Karnataka, India

  ● Extracting data from source and transforming, validating and loading into final Destination.● Writing complex SQL queries using Joins, Sub queries, correlated sub queries and Set Operators to retrieve data from the database.● Experience with SQL Server and T-SQL in creating Tables, Functions, Views, Indexes, CTE, Window Functions and Stored Procedures. ● Creating functions and analyzing existing stored procedures and functions.● Analyzing and developing Power BI reports according to client requirement.● Creating the Measures according to the business logic in Power BI Desktop using DAX ● Extensively created Calculated Measures, Custom columns using Power BI Desktop to generate reports for Business analysis.● Created Reports using Various Visualizations like Bar and column charts, Multi row cards, Doughnut charts, Line charts, Matrix charts, Tables.● Worked on creating Dashboards by pinning visuals of the reports. ● Creating multiple kinds of Power BI Reports and Dashboards for the given requirement. ● Define access control on the dashboards created using the reports.● Shared the Dashboards through Power BI service to clients.