Suvikram Sen

Strategic and detail-oriented Senior Data Modeler BA with extensive experience in architecting scalable data solutions within the aviation industry. Expert in Medallion Architecture, Dimensional Modeling, and cloud-based warehousing using Snowflake. Proven track record of translating complex business requirements into high-performance data schemas that drive enterprise-level analytics and revenue optimization.

• Modeling: Dimensional Modeling (Star/Snowflake Schema), Medallion Architecture (Bronze, Silver, Gold), ER Diagrams, Data Normalization.
• Cloud & Databases: Snowflake, AWS S3, SQL Server.
• Data Integration: Fivetran, Snowpipe, ETL/ELT CI/CDPipeline Design with Azure Devops.
• Analytics & BI: Power BI, DAX, Advanced SQL, Data Visualization.
• Tools & Governance: Data Quality Frameworks, Schema Validation, GIT,Version Control.

Jetstar / Qantas Airways

Senior Business Data Modeler | [Dates, e.g., 2021 – Present]

• Strategic Data Modeling: Lead enterprise-level data modeling initiatives, scoping complex business requirements and translating them into high-performance data structures for fleet management and passenger services.
• Medallion Architecture Oversight: Designed and governed the implementation of Medallion Architecture within Snowflake, establishing the gold standard for data transformation and analytics readiness.
• Advanced Schema Design: Engineered optimized Star Schemas and Snowflake-specific database structures to streamline the Power BI reporting layer, significantly improving query performance.
• Automated Integration Architecture: Architected end-to-end ingestion workflows using Fivetran for automated source integration and Snowpipe for real-time, file-based data streams from Azure platforms.
• Data Standards & Governance: Established rigorous data quality frameworks and validation protocols across all medallion layers to ensure a "single source of truth" across the enterprise.
• Technical Leadership: Serve as the subject matter expert (SME) on data modeling best practices, providing mentorship and architectural guidance to cross-functional teams.

• Collaborated with business stakeholders to analyze and streamline insurance workflows for applications including IDIT, Y75, and GDPR systems, resulting in improved operational efficiency and faster processing times.
• Designed and implemented GDPR data anonymization frameworks using Azure Databricks and DataStage, ensuring regulatory compliance across all data pipelines.
• Developed logical and physical data models to support analytics and reporting in Netezza and Azure SQL environments, supporting executive decision-making.
• Led agile ceremonies including PI Planning, Sprint Planning, Backlog Grooming, and Retrospectives for a distributed team across Europe and India.
• Created and maintained KPIs for Refund Premium and Policy Transactions, improving monitoring and root cause analysis for transaction anomalies.
• Client: Folksam Omessidig Sakforsakring
• Location: Munich/Budapest/Stockholm
• Role: Consultant / IT Business Analyst
• Designed and automated data pipelines using ETL transformations in Azure, significantly reducing manual reporting overhead.
• Conducted performance tuning and data quality checks to eliminate discrepancies in policy data and enhance seamless reporting dashboards.
• Coordinated UAT activities with QA teams and business users, ensuring high-quality, defect-free delivery of enhancements.
• Managed code deployments and pull requests using GitHub and Jenkins, facilitating CI/CD practices and faster go-lives.
• Delivered documentation, impact assessments, and solution presentations to cross-functional teams, strengthening knowledge sharing and transparency.
• Highlights:
• Played a pivotal role in Folksam’s BI modernization initiative using Azure and GitHub platforms.
• Received client recognition for driving business impact through effective root cause analysis and solution implementation.

• Participated in PI Planning, Feature Sizing, and Backlog Grooming as part of a 10-member Agile team supporting financial credit systems.
• Created RDV and BDV mappings in Informatica PowerCenter; deployed changes using SAP Power Designer and IntelliJ in SAP HANA DB.
• Executed Crossvista patch management across PAT, PRE, SIT, DEV, and TEST environments.
• Built Power BI dashboards for business credit scoring and credit validation reporting, enhancing decision-making.
• Acted as ad-hoc Scrum Master, ensuring sprint continuity and velocity improvement.
• Implemented Master Data Framework (MDF) structures, contributing to robust data governance.
• Monitored HANA and DVO validations and managed deployments through CI/CD practices.
• Conducted peer code reviews and guided junior developers in technical implementations.
• Highlights:
• Received “On the Spot Award” from TCS for defect-free, timely delivery.
• Praised by Rabobank leadership for independently driving dashboard design and BI analytics.
• Client: Rabobank
• Location: Netherlands/Chennai
• Role: Consultant / IT Business Analyst

• Built and managed MarkLogic NoSQL databases and implemented data bulk loading using MLCP.
• Developed Power BI dashboards with semi-additive measures for analytics on box office performance and movie distribution.
• Collaborated with the data team to model complex business logic using Power Query and DAX functions.
• Analyzed and validated requirements to ensure development readiness and data completeness.
• Client: Sony Motion Pictures | California (Offshore Project)

• Designed test plans and traceability matrices for defense aircraft applications; reviewed with quality managers.
• Conducted system architecture analysis and digital transformation PoCs for Boeing’s digital initiatives.
• Client: Boeing Aircrafts | Seattle, USA (Offshore Project)

• Managed SAP POS data loads and reconciliations for retail store openings and closures.
• Handled post-downtime ETL processes and UNIX-based data validations.
• Coordinated with business teams for backdated transaction updates and bill cancellations.
• Client: Reliance Industries Ltd. (Jio Retail) | Mumbai