Sourav Rana

Designed innovative business solutions to optimize system architecture and streamline client workflows. Supported GenAI/RAG initiatives and led design reviews ensuring alignment with governance frameworks and industry best practices.

Led end-to-end data modelling strategy for Finance & Actuarial Data Store, owning logical and physical data models. Established metadata framework and collaborated with business and development teams to deliver strategic data transformation services.

Owned end-to-end Business Process Platform, driving process standardization and alignment with technology services. Led application discovery and knowledge transition activities, and developed business process maps and KPI frameworks.

Contributed to architecture and delivery of enterprise-scale Data Hub on AWS, enabling ingestion and analysis of large-volume business data. Designed scalable data ingestion and ETL frameworks, including real-time streaming solutions.

Designed and governed end-to-end ETL architecture for Inventory Reconciliation platform. Owned Talend ETL design and implementation strategy, establishing development standards and best practices.

Led architecture and optimization of Amazon Redshift and AWS EC2 environments for Global Consumer Analytics Platform. Defined best practices across Redshift, Talend, Alteryx, and Tableau ecosystems, and developed strategic cloud data architecture roadmap.

Led Agile/SCRUM delivery for global Commercial Operations Analytics program. Defined and implemented end-to-end enterprise data integration architecture on AWS, and designed Talend ETL architecture with reusable frameworks.

Owned and governed enterprise Data Warehouse logical and physical data models. Designed end-to-end data mappings and transformation rules across staging, audit, and presentation layers.

Delivered business-critical analytics and reporting solutions using QlikView dashboards and executive scorecards. Led migration of legacy reports to modern QlikView and Data Warehouse platform.

Designed and owned Data Warehouse (OLAP) data models and multi-layered architecture. Developed end-to-end data mapping and ETL solutions integrating multiple enterprise data sources.

Led BI discovery and requirements analysis for a global pharmaceutical organization. Designed enterprise data models including relational, dimensional, logical, and physical models.

Led design, development, and maintenance of OLAP data warehouse models and star schemas for Child Maintenance & Enforcement Commission. Collaborated with stakeholders to translate reporting needs into scalable data models.

Designed and governed Conceptual, Logical, and Physical Data Models (OLTP) for Child Maintenance & Enforcement Commission. Owned and managed Siebel Data Model, ensuring alignment between business and system models.

Led requirements analysis, data mapping, and ETL solution design for Openreach customer data migration. Designed end-to-end data migration and integration solutions, performing source data analysis and impact analysis.

Analysed business requirements and designed data migration, synchronization, and ETL solutions. Performed data mapping, source system analysis, and data quality assessments to support complex hierarchical data models.

Bachelor of Technology degree from West Bengal University of Technology, completed in 2005.