Rajasekhar G Email & Phone Number

United Kingdom

• Developed and maintained Power BI dashboards and reports for insurance underwriting department, enabling real-time monitoring of policy submissions, risk assessment, and decision-making processes.• Implemented data modeling techniques to integrate disparate insurance datasets, such as policy data, claims data, and customer information, into a centralized data warehouse.• Collaborated with business users and subject matter experts to gather requirements and translate complex insurance metrics into meaningful visualizations and interactive reports.• Created calculated measures, custom visuals, and drill-through actions to provide detailed insights into policy performance, loss ratios, claims trends, and policyholder behavior.• Implemented row-level security and data-level security measures to ensure data privacy and compliance with industry regulations.• Optimized Power BI reports for performance and usability, including data refresh schedules, data compression techniques, and query optimizations.• Conducted training sessions and workshops for end-users to promote self-service BI and enhance data literacy within the insurance organization.• Collaborated with the data engineering team to streamline ETL processes, improve data quality, and automate data integration workflows.• Ensuring the fulfilment of all architectural goals on development projects, including estimation, unit testing, deployment, and maintenance.

United Kingdom

• Developed Power BI dashboards and reports to monitor real-time production data, drilling performance, and equipment maintenance for oil and gas exploration and production operations.• Designed and implemented data models to integrate diverse data sources, including SCADA systems, well logs, production databases, and reservoir simulations.• Collaborated with domain experts to define key performance indicators (KPIs) and develop visualizations that provided insights into production volumes, well performance, downtime analysis, and cost optimization.• Built interactive reports and drill-through capabilities to enable users to analyze production trends, identify anomalies, and troubleshoot operational issues.• Worked with different applications data like Oracle ERP, MuleSoft, SFDC. • Developed complex calculated measures using Data Analysis Expression language (DAX).• Worked extensively with calculated fields, Parameters, Maps, Trend Lines.• Creating various complex visualizations, KPI’s, Paginated Reports, Bookmarks implementing row-level security on data along with an understanding of application security layer models in Power BI and Tableau based on business requirements.• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on SQL Servers.• Mentored and trained junior Power BI developers, providing guidance on best practices, design principles, and advanced functionalities.

• Worked closely with business stakeholders to gather requirements, analyze data needs, and translate business goals into actionable insights.• Developed robust data models, ensuring optimal performance and scalability for complex datasets.• Designed and created interactive dashboards and reports using Power BI Desktop, providing users with real-time visibility into KPIs, performance metrics, and trends.• Implemented advanced analytics and custom visualizations to enhance data exploration and storytelling.• Design and deploy rich Graphic visualizations with Drill Down option with the Hierarchies in Power BI.• Worked on Period to Date Calculations like YTD, QTD, MTD, WTD and YOY, QOQ, MOM, WOW.• Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.• Worked on reports migration from Tableau to Power BI.• Worked on complex visualizations, KPI’s, Paginated Reports, Bookmarks and implementing row-level security on data along with an understanding of application security layer models in Power BI and Tableau based on business requirements.• Demonstrated expertise in designing schema objects such as attributes, facts, etc., and public objects such as metrics, filters, prompts, etc.

• Installed, configured, and upgraded Oracle databases (11g/12c/19c) in both single-instance and RAC environments.• Administered Oracle E-Business Suite (R12), including installation, patching, cloning, and monitoring.• Conducted performance tuning activities, including SQL optimization, index creation, and database parameter tuning.• Implemented and managed backup and recovery strategies using RMAN, Data Pump, and Flashback technologies.• Configured and maintained Oracle Data Guard for disaster recovery and Oracle RAC for high availability.• Diagnosed and resolved database issues, performed root cause analysis, and implemented corrective actions.• Implemented and enforced database security measures, including user management, role-based access control, and data encryption.• Developed and maintained scripts for automation of routine database administration tasks.• Created and maintained technical documentation, standard operating procedures, and change management processes.• Participated in troubleshooting and resolving database-related issues.