Ramesh

Professional Summary:

 Having around 5+ years of Experience in Power BI, SQL and T-SQL, Data Warehouse, SQL Server Integration Services (SSIS).  Hands on experience in Power BI Service.

 Exposure in creating different types of reports such as Cross-Tab, Drill- down and Sub reports, Parameterized and cascading reports.

 Written Stored Procedures in SQL Server in order to generate reports.

 Expert in Data Warehouse designing with different schemas- Star and Snow Flake schemas.

 Designed and documented the Architecture of Power BI projects.

 Implemented dynamic calculations using the DAX functions like calculate, filter, min, max, sum, count, MTD, QTD, YTD and Cumulative Total Etc.

 Expertise in writing complex DAX functions in Power BI and Power Pivot.

 Developed different types of reports like line chart, bar chart, pie chart, Table, Drill through, calendar type reports, donut reports, drill down reports, matrix reports etc.

 Created Workspace and content packs for business users to view the developed reports.

 Having experience on scheduling the reports for dynamic refresh.

 Created New Calculated columns and Measures using DAX Expressions.

 Worked on many Transformations such as Lookup, Conditional Split, Merge, Multicast, Derived Column, OLEDB Command and Row Count Etc.

 Excellent knowledge of using variables and expressions in SSIS packages.

 Hands on experience in writing and implementation of the Stored Procedures, Functions, Views, Joins, Sub – Queries, CTE’s, Indexes, Triggers using SQL & T-SQL.

 Good Understanding of Data Modelling, Dimensions and Fact Tables and its relationships.

 Good Experience of working in Software Development Life Cycle ( SDLC) processes including Analysis, Design, Programming, Testing and Documentation.

 Hands on experience in Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

 Excellent knowledge on Full Loading and Incremental Loading with SSIS.

 Ability to learn and adapt to new tools.