Ruhi Tamanna

CEO

Bengaluru, Karnataka, India18 yrs 7 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • 16 years of diverse industry experience
  • Expert in cloud, AI, and security best practices
  • Led impactful projects with significant ROI
Stackforce AI infers this person is a Data Architect specializing in Oil & Gas with expertise in cloud and data solutions.

Contact

Skills

Core Skills

Solution ArchitectureData ArchitectureCustomer ExperienceData ModelingEtl DevelopmentData AnalysisData Governance

Other Skills

Data MonetisationAI ChatbotSearch AIKnowledge AIGen AILLMMLPythonData WarehouseData LakehouseBig DataETL/ELTSQLPLSQLAPIs

About

With 16 years of diverse industry experience, I am a visionary, risk-taking strategist ready to revolutionize your business landscape. My knack for designing integrated solutions and leveraging assets has propelled me to be a detail-oriented Solution & Data Architect. I thrive in complex multi-tower transformations, armed with expertise in cloud , AI and security best practices delivering impactful projects like Japan Rising for Shell . Solution Data Architect | Shell Oil &Gas | Bangalore , India • Shell Intelligent B2B,B2C Customer Operation – Designed Solution and Customer Operations Channel strategy for Omnichannel program to enhance CX using Kore.ai Conversational AI platform. Technical due diligence on vendor solutions, performed on-premise deployments ,built Intelligent Virtual Assistant using Knowledge AI ,Search AI and advance NLP. Achieved CSI of 86% and saved 587 FTE hours. • B2B Shell Market Hub - Designed Data Architecture to provide a Secure, Self-Serve portal for B2B (Aviation, Lubricants, Mobility) to manage orders, Accounting, Reporting, Valuable training tools for distributors. • Japan Rising - Designed Solution and Data Architecture for Japanese Oil refinery Idemitsu acquisition to Shell in record time during COVID , successfully mapped 15 applications between Idemitsu and Shell to enable Order Journey via Shell Specific applications (Sap, Salesforce,SMH,COV,Medallia,BT Pulse). Offered opportunity for $31.3m by 2025 and enhanced Shell Market presence in Asia • Shell Marketing and Content Management - Designed Solution to provide standard Self-Serve Marketing console using standard Shell Digital assets, Adobe Experience Manager. Delivered tangible financial benefits and direct OpenX value and C3 FY2023 • Shell Road Transport Data Platform - Designed Solution and strategy for Shell Fleet by using data insights to make informed decisions and reduce time - cost. Fifty-nine percent reduction in Fuel consumption leading to 84% ROI. Implemented Data Monetisation using Maps data to optimize Depo to site operations. • Shell Athena – Designed Data pattern and implementation of Medallion Architecture for Athena (Shell ADLS), setting up bronze, silver and gold layers, Azure Storage and ADF, Azure Devops, CICD Pipelines

Experience

18 yrs 7 mos
Total Experience
3 yrs 7 mos
Average Tenure
4 yrs 2 mos
Current Experience

Chevron

Senior Architect

Jan 2026Present · 4 mos · Bengaluru, Karnataka, India

Shell

Data Architect

Mar 2022Present · 4 yrs 2 mos · India

  • Solution and Data Architecture , Data Monetisation • AI Chatbot,Search AI, Knowledge AI, Gen AI, LLM , ML, Agentic AI, Python • Data Warehouse, Data Lakehouse & Big data ,ETL/ELT,SQL /PLSQL • Data Modeling - dimensional modeling, OLTP ,OLAP ,UML• APIs (RESTful, GraphQL) • microservices, event-driven, cloud-native and well-architected framework, on-premise deployments, Data Governance, Well Architected Framework, • Data Modeling tools – SAP Power Designer , IBM System Architect , CA ERwin • Azure Storage, Azure Open AI , ADLS, Azure Devops ,AWS Lakeformation, AWS Athena, AWS Glue, Event Bridge, Cloud Watch,AWS Lamda, CICD , Azure Synapse, AWS Redshift, cutting-edge Azure services ,Multicloud AWS,GCP IaaS,PaaS,SaaS
  • Certificate - Azure Solution Architect AZ-305• Azure AI Fundamentals AI-900 •Azure Data Fundamentals DP-900•Azure Fundamentals AZ-900 • IBM Architect Design • TOGAF 9 /ArchiMate
Solution ArchitectureData MonetisationAI ChatbotSearch AIKnowledge AIGen AI+25

Ibm

Data Architect

Mar 2016Mar 2022 · 6 yrs · Bangalore

  • Project 1- Royal Dutch Shell Plc- Working for Shell as a Data Architect May 2019 - till date
  • Key Deliverable -
  • 1.High Level Design Document
  • 2.Conceptual Data Model
  • 3.Logical Data Model
  • 4.Data Mastership Design
  • 5.CRUD , MSOP matrix
  • 6.Interface Data flow
  • Azure Data Modeling , Azure SQL database design, Azure Data Factory ,Power BI , SQL Server Management Studio
  • Dimensional Data Model , Enterprise Data Model, Dara Model Gap Analysis , Effort Estimations, Data Analysis
  • Job Description -
  • Project 2- Mercedes - Data Modeler, Data Analyst
  • Project 3- National Health Services UK- Data Integrator, Data Analyst
High Level Design DocumentConceptual Data ModelLogical Data ModelData Mastership DesignCRUDMSOP matrix+13

Tata consultancy services

2 roles

Data Architect and Data Analyst at UK Thames Water

Feb 2015Dec 2015 · 10 mos

  • DATA MODELER , DATA ANALYST , INFORMATICA DESIGNER AND DEVELOPER
  • Project # 1: Thames Water , United Kingdom
  • Module 1 - Thames Water Property Searches
  • Module 2 - Customer Satisfaction Data Analyst
  • Responsibilities -
  •  Involved in requirement gathering workshops and requirement document specification
  •  Development of Logical and Physical data model (LDM, PDM) using Erwin.
  •  Preparation of overall data migration plan
  •  Preparation of Data Governance document – Data Dictionary, LDM, PDM.
  •  Preparation of data profiling document
  •  Extensively used database for analysis and reporting
  •  Development of Salesforce Data Migration Strategy
  •  Source Data Analysis and Cleansing Strategy
  •  Development and analysis of CSAT data.
  •  Implementation of SCD type 1,2
  •  Preparation of data mapping plan using data governance document and analysis
Data ModelingData GovernanceSalesforce Data Migration StrategyData Analysis

Information Technology Analyst

Nov 2011Mar 2016 · 4 yrs 4 mos

  • Project # 2: XL Global Insurance & Reinsurance , Finance Improvement Module
  • Module Name - Solvency II
  • Module Name - Subscribe data load (Finance Improvement)
  • Project # 3: Aviva Life Insurance , Quote me Happy Module
  • Module Name - Quote Me Happy
  • Development of mappings and required sql as per business requirement .
  • Creation of Batch Scripts , Autosys Jil Scripts
  • Implementation of features like Replication and Change Data Capture in Sql server
  • Development of Etls using manual templates
  • Use of Informatica web service for Etl execution .
  • Development of stored procedure .
  • Enhancement of unix scripts for end to end testing of ETLs and Bteqs.
  • Usage of Teradata Utilities for data load - Mload , Fastload.
SQLInformaticaBatch ScriptsAutosys Jil ScriptsChange Data CaptureTeradata Utilities+2

Genpact headstrong capital markets

Consultant

Oct 2010Aug 2011 · 10 mos · Noida

  • Project # 4: Morgan Stanley , Global wealth Management-Sales Product Technical Coverage
  • Module Name - Sales Product Technical Coverage
  • Development of mappings and required sql as per business requirement .
  • Enhancement of unix scripts for parameterization ip address to download mainframe source file.
  • Test cases preparation for gap analysis and validation .
  • Performance tuning of the ETLs and Teradata queries .
  • Creation of unix scripts release Mload locks and dropping of Error Tables before the Etl execution .
  • Creation of unix script for collection of run statistis for the ETL and preparing report for the same .
SQLETLUnix ScriptsETL Development

Tech mahindra (formerly mahindra satyam)

Senior Software

Jun 2007Sep 2010 · 3 yrs 3 mos · Bhubaneshwar , hyderabad

  • Project # 5 : CISCO EDW2B Accelerated Migration
  • Update existing jobs for better performance by updating in the SQL part of the jobs.
  • Creation of mappings for the migration of data from oracle database to Teradata
  • Deployment of the code to the quality team for further validation using Kintana
  • Scheduling of the run of the mappings ,Bteq, sql files and uprocs using $universe.
  • Testing of mapping using Scripts in Unix and also unit testing
  • Project # 6 : State farm Insurance ( Conversion Project)
  • Creation of mappings and their validation using informatica
  • Testing of the Mappings using Unix Scripts and Various Automated Tools.
  • Loading and checking of Data using DB2 and unix
  • Software: Informatica 8.1.1,Unix,DB2,Allabase
  • Source : Flat Files and Allabase
SQLUnix ScriptsTeradataData Analysis

Education

Orissa Engineering College

Bachelor of Technology (BTech) — Electronics and telecommunication

Jan 2003Jan 2007

University of Oxford

Oxford Women's Leadership Development Programme — Organizational Leadership

Jan 2023Mar 2023

Indian School of Business

Essentials of Leadership

Dec 2021Feb 2022

Stackforce found 100+ more professionals with Solution Architecture & Data Architecture

Explore similar profiles based on matching skills and experience