Umesh Chandra Ram

Meet business users to understand business objectives and discuss requirements. Imported different data from SQL Server database, Share Point and Excel file to generate reports. Data massaging, cleansing, transformed data by utilizing Power Query and M Queries such as unpivot columns, replace values, duplicate, reference. Optimized data modelling, used cross filtering, joins, merge & append.

Worked with business to take requirements and translate them into technical designs. Participated in designing architecture of SSIS (ETL) process to pull out policy, billing data from VMS system to daily, monthly OLAP (Star Schema, Snow Flake Schema) data mart and feed downstream reporting. Extensible used T-SQL scripts, dynamic SQL, complex stored procedures, functions, cursors and indexes.

Discuss requirements with users and write technical document. Used SSIS tasks and transformations, T-SQL, logging, event handlers to extract, transform and load data warehouse Developed optimal stored procedures and queries to create data sets for reports. Created various sales KPIs and visualizations using Power BI desktop. Configured Power BI Gateway and scheduled refresh for dashboards.

CRM, Operations

Computer Applications, Mathematics, Digital Electronics

Computer Applications, Mathematics, Digital Electronics