Amiya Ranjan R.

About Amiya Ranjan R.

Experienced Data and BI Engineer with years of success in designing and delivering enterprise-scale data platforms, with deep domain expertise in insurance, reinsurance data. Specializing in Azure-based data architecture, I build secure, high-performance data solutions that support ingestion, transformation, governance, and analytics at scale.Currently leading the end-to-end architecture of a unified data ecosystem in Azure Cloud using Databricks, ADF, ADLS, DBT and Power BI, integrating data from multiple source systems to support reliable and timely insights across the organization. I work hands-on in pipeline design, data standardization, and ensuring robust PII data handling and compliance with governance and security frameworks. Leveraging Databricks Genie and Databricks Dashboard for conversational BI to mine data for various data discovery. With a strong delivery background, I drive Agile projects using Azure DevOps, bridging the gap between technical teams and business stakeholders. Experienced in leading high-impact teams, I consistently deliver scalable, compliant, and actionable data solutions that improve decision-making and support critical regulatory requirements.

Experience

1. Senior Analytics Engineer

   Marsh

   Feb 2020 — Present · New York, NY, US

   Partnered with stakeholders and cross-functional teams to gather requirements and brainstorm data and visualization needs.• Designed and developed data models with Azure Databricks, boosting data processing efficiency by over 25% and accelerating data availability by 30 minutes to several hours.• Led the migration of multiple tables through the Databricks medallion architecture from Bronze to Silver to Gold layers.• Created interactive dashboards for 250+ users, cutting decision-making time by 40%.• Designed and developed data pipelines processing over 400 million rows daily basis and reducing turnaround time by more than 20%.• Spearheaded the reengineering of a legacy data model and migrated 200+ reports from Cognos to Qlik Sense.• Built several Power BI dashboards to uncover ad-hoc data patterns and insights to help narrow down the decision-making time.• Delivered 30+ complex Cognos reports, generating monthly views for users.• Optimized SQL queries and reports, reducing turnaround time by over 50% for the top 40 frequently used reports.• Lead an effort to collect raw and semi-structured data from Mongodb into the Data Lake, perform necessary transformations and present the data using various interactive visualizations.

Education

• IBMR

  Master of Business Administration (MBA), Information Technology

  2003 — 2005

• Gediaplli High School, Odisha

  High School

  1995 — 1998

• Bangalore University

  BCA, Computer Software Engineering

  2000 — 2003

Skills

• Tableau
• Pl/Sql
• Performance Tuning
• Agile Methodologies
• Sdlc
• Sql
• Solution Architecture
• Sql Server Integration Services (Ssis)
• Software Development Life Cycle (Sdlc)
• Database Design
• Tm1
• Exploratory Data Analysis
• Dashboarding
• Data Warehousing
• Business Requirements
• Software Project Management
• Dmr
• Etl
• Extract, Transform, Load (Etl)
• Cognos
• Ibm Db2
• Unix
• Data Modeling
• Business Intelligence
• Microsoft Sql Server
• Data Integration
• Oracle
• Requirements Analysis
• Requirements Gathering
• Direct Client Interaction
• Unix Shell Scripting
• .net
• Business Analysis
• Ssis
• Data Warehouse Architecture