Rohith V Email & Phone Number

Cardiff, Wales, United Kingdom

London Area, United Kingdom

• Worked closely with the project management team, stakeholders to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.• Constructed ETL processes to easily combine data spread across different source systems into a single harmonized layer, so that metrics are aligned and insights are valid.• Developed ADF pipelines to invoke set of API’s for fetching artifacts in order to perform user onboarding, migration process and in… Show more • Worked closely with the project management team, stakeholders to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.• Constructed ETL processes to easily combine data spread across different source systems into a single harmonized layer, so that metrics are aligned and insights are valid.• Developed ADF pipelines to invoke set of API’s for fetching artifacts in order to perform user onboarding, migration process and in turn integrate with downstream applications.• Designed Azure Data Factory pipelines for processing push notifications, extracting required data (JSON response) and posting to REST endpoints.• Develop and implement data collection systems using various activities in Azure Data Factory and other strategies that optimize statistical efficiency and data quality.• Created new tables, written stored procedures, triggers for ADF Pipelines and user defined functions. Created SQL scripts for incremental extract and load into DWH.• Communicated with stakeholders to understand and build visualization dashboards in Power BI.• Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.• Responsible for the design and implementation of the reports interface and used DAX functions for writing the calculations on each Power BI report. Show less

India

• Actively collaborate with business sponsors, gather requirements, perform User Acceptance Testing, provide user training, and maintain team documentation.• Design and create visually impactful dashboards and reports in Power BI to support business strategies for various levels of leadership, such as executives and sales representatives.• Manage production issues, data corruption, and data discrepancy and Responsible for analysing data, modelling, developing, testing, and maintaining… Show more • Actively collaborate with business sponsors, gather requirements, perform User Acceptance Testing, provide user training, and maintain team documentation.• Design and create visually impactful dashboards and reports in Power BI to support business strategies for various levels of leadership, such as executives and sales representatives.• Manage production issues, data corruption, and data discrepancy and Responsible for analysing data, modelling, developing, testing, and maintaining Power BI reports.• Identify business process gaps, corrupted data, inefficient processes to enhance report performance and data quality on Power BI reports.• Created Custom Invoke Functions using Power Query to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible.• Worked and utilized DAX functions, which includes Aggregation, Counting, Logical, information, Text and date functions in source data. And created variables and parameters.• Identify, analyse, and interpret trends or patterns in complex data sets and Filter and clean data using Power Query, and review existing reports to locate and automate data problems.• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize and develop self service reports • Worked on Power BI Services to create workspace, publish reports and used Gateways to automate reports and created incremental refresh.• Create Row Level Security to restrict user access to the dataset, and used Azure Active Directory to create and manage user groups.• Wrote complex T-SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic. Show less

Master'S Degree, Data Science

Bachelor Of Technology - Btech, Computer Science