Vinodkumar C Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

• Collaborate with business stakeholders and data analysts to gather requirements for BI solutions.• Analyze business requirements and translate them into technical specifications for BI development.• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).• Extract data from diverse sources such as policy systems, claims databases, and CRM systems.• Transform data to ensure consistency, accuracy, and compatibility with the data warehouse.• Load data into the data warehouse and data marts efficiently.• Design and develop data models using SQL Server Analysis Services (SSAS) for multidimensional and tabular models.• Create and maintain OLAP cubes to facilitate complex data analysis and reporting.• Manage and optimize SQL Server databases to ensure performance and scalability.• Develop and maintain interactive reports and dashboards using SQL Server Reporting Services (SSRS).• Design and implement Power BI dashboards to visualize key insurance metrics and KPIs.• Ensure reports and dashboards meet business requirements and provide actionable insights.• Optimize SQL queries, ETL processes, SSAS cubes, and Power BI reports for improved performance.• Monitor and troubleshoot BI solutions to identify and resolve performance issues promptly.• Implement data governance policies and procedures to maintain data quality and integrity.• Ensure compliance with industry regulations and data security standards.• Protect sensitive insurance data through robust security measures.• Work closely with cross-functional teams including business users, data scientists, and IT professionals.• Communicate effectively with stakeholders to understand their needs and deliver BI solutions accordingly.• Document technical designs, processes, and configurations for BI solutions.• Provide training and support to end-users on utilizing BI tools and interpreting data insights.

Bengaluru, Karnataka, India

• Gathering and assimilating requirements, performing source system analysis, and developing ETL jobs to populate data from the transactional data source to the target Data warehouse• Importing the source or target tables from the respective database by executing package tasks using control tasks in SQL Server 2018 Integration services; designing the modeling in Power BI • Creating visual interactions using Edit Interactions to make few visuals to effect data based on requirement• Accessing various data sources and writing SQL queries to retrieve data for reporting and analysis from the database.• Performing optimization, performance tuning, monitoring, debugging, and scheduling for SSIS; deploying different packages to different environments and scheduling SSIS packages.• Designing packages that utilized tasks and transformations such as Execute SQL Task, Data Flow Task, For Each Loop Container, Lookup, Expression, OLE DB Command, and Derived Column• Utilizing OLEDB Source, Excel Source, Flat File Source, and ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow• Transforming the data before loading into the destination using different transformations provided by SSIS such as Script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, union all & slowly changing dimension• Operating Event Handlers to do Event management on error at the package and task level on error, on warning and configured it using Send Email Task and Script Task• Preparing Power BI reports in Direct Query Mode; Delivering Power BI reports to the management and managing workspaces in Power BI service• Developing the Calculated columns and measures with the use of DAX Expressions• Creating data visualizations like Bar Charts, Tree Maps, Line Charts, Scatter Plot, & Mapping Visualization with Power BI