Khushbu Torawane

Senior Domain and ETL Architect
Pimple Saudagar, 411017, Pune, IN.

About

A highly accomplished Telecom Domain and ETL Architect with over 15 years of experience, adept at driving transformative data solutions within BI and Big Data analytics. Specializing in designing and optimizing scalable ETL processes, E2E architectures, and complex data workflows using advanced tools like Abinitio, Teradata, and GCP. Proven leader in facilitating cross-functional coordination and delivering strategic software solutions that enhance business profitability and operational efficiency.

Work

VOIS
|

Domain Architect

Pune, Maharashtra, India

Summary

Led technofunctional E2E architecture initiatives and strategic programs, ensuring comprehensive data integration and system alignment across Vodafone UK market operations.

Highlights

Spearheaded the design and implementation of E2E architectures for multiple strategic programs within the Vodafone UK market, ensuring seamless data flow and system interoperability.

Orchestrated complex inbound and outbound data integrations, application integrations, and cloud integration patterns, optimizing data exchange across diverse platforms.

Provided deep domain expertise in BSS systems including CRM, BRM, Order Management, and Marketing systems, guiding the successful deployment of outbound campaigns.

Managed end-to-end project lifecycles from feasibility analysis to implementation, ensuring successful delivery of critical software solutions.

VOIS
|

ETL Architect

Pune, Maharashtra, India

Summary

Designed and optimized scalable ETL processes and data pipelines, driving efficient data integration and robust data warehousing solutions.

Highlights

Designed and implemented scalable, secure ETL processes and logical data models, translating stakeholder needs into robust physical database structures.

Managed end-to-end data pipelines, transforming raw OLTP database data into optimized data solutions for enhanced analytics and reporting.

Leveraged cloud-based batch and real-time data integration tools, including GCP Cloud Data Fusion, GCP Cloud Data Flow, and Kafka, to ensure seamless data flow.

Applied best practices in Data Warehousing design, analysis, and application implementation to ensure high-performance data solutions.

Contributed to an efficient onshore-offshore delivery model, optimizing resource utilization and project timelines.

VOIS
|

Technical Lead

Pune, Maharashtra, India

Summary

Led a 13-member team in delivering a consumer profitability data mart, enhancing business intelligence and driving significant monetary savings for senior leadership.

Highlights

Directed a 13-member team in developing a consumer profitability data mart, identifying critical business process gaps and delivering actionable solutions across consumer segments.

Developed and deployed business intelligence dashboards that significantly improved decision-making efficiency for senior leadership, resulting in notable monetary savings.

Applied expertise in UNIX shell scripting, Python, SQL, Abinitio, Informatica, and Power BI reporting to optimize data pipelines and reporting solutions.

Collaborated as a Senior Business Analyst on Vodafone's RIVA initiative, contributing to the successful replacement of commission management systems across the group.

Tata Consultancy Services
|

Technical Team Lead

Pune, Maharashtra, India

Summary

Led Teradata and Informatica ETL projects, developing business-critical dashboards for multiple US retail clients and optimizing data solutions.

Highlights

Functioned as an ETL Developer utilizing Teradata and Informatica Power Center to build robust data integration solutions.

Developed business-critical dashboards using Tableau and Power BI, providing key insights and supporting strategic decision-making for clients.

Served as Technical Lead for Teradata projects, serving multiple high-profile US retail clients including Supervalu, Best Buy, and Toys R Us.

Contributed to data warehousing initiatives, ensuring efficient data processing and accessibility for client business needs.

Education

Savitribai Phule Pune University
Pune, Maharashtra, India

Bachelor of Engineering (BE)

Information Technology

Certificates

Dataiku Core Designer

Issued By

Dataiku

Dataiku Advanced Designer

Issued By

Dataiku

Google Cloud Certified Professional Cloud Architect

Issued By

Google Cloud

Skills

Tableau

Business Intelligence, Dashboards, Reporting.

Power BI

Business Intelligence, Dashboards, Reporting.

Python

Programming Language.

PL/SQL
Domain Architecture

E2E Architecture, Techno-functional.

Google Cloud Platform (GCP) BigQuery

GCP, Big Data Analytics.

Google Cloud Platform (GCP) Data Fusion

GCP, Data Integration.

Data Modeling

Logical Data Models, Physical Database Structures.

Telecom Domain Expertise

Retail Domain, Vodafone UK Market, BSS Systems, CRM, BRM, Order Management, Marketing Systems, Outbound Campaigns.

Teradata

ETL, Data Warehousing.

Abinitio

ETL, Data Integration.

Informatica Power Center

ETL, Data Integration.

UNIX Shell Scripting
SQL
Kafka

Real-time Data Integration, Cloud Data Flow.

ETL Processes

Scalable ETL, Secure ETL, Data Workflows.

Data Pipelines

OLTP Databases, Optimized Data Solutions.

Data Warehousing Best Practices

Design, Analysis, Implementation.

Project Management Lifecycle

Feasibility Analysis, Implementation Stage.

Team Leadership

Cross-functional Coordination, Onshore-Offshore Delivery Model.

Business Intelligence Development

Decision Making Efficiency, Monetary Savings.

Data Integration Patterns

Inbound Data, Outbound Data, Application Integrations, Cloud Integration.