Hello, I'm Saurav
Architect by title, Coder by craft, Engineer by soul.
View Profile
← Back
Saurav Rout
Show Email
[email protected]
LinkedIn:
linkedin.com/in/sauravrout
Core Competencies
Data Modeling & Architecture
Data Integration & Transformation
Data Governance & Compliance Management
Big Data Analytics & Processing
Business Intelligence & Reporting
Scalable Infrastructure Design & Management
Real-time Data Processing & Streaming
Database Management & Administration
Data Warehousing & Data Lakes
Agile Development & DevOps Practices
Data Visualization & Dashboarding
Change Management & Stakeholder Engagement
Risk Assessment & Mitigation
Technical Skills
Cloud Platforms: Azure, OpenShift
Containerization: Azure Kubernetes Service, Docker, Azure container registry
Databases: Snowflake, Azure SQL, Azure Synapse, Cosmos DB, Netezza, Teradata
Scripting: Yaml, Bash, PowerShell
Version Control Systems: Git, GitHub Enterprise, Azure Repos
Automation/Build Tools: Azure DevOps, CI/CD Pipelines, Jenkins, XL Deploy
Infrastructure as Code: Terraform, ARM template
Cloud Services: Azure App services, Azure Kubernetes Service, Azure Compute, Azure networking, storage, Azure Data Factory, Azure Databricks
ETL Tools: Abinitio, ADF Pipelines
Programming: Python, Bash Shell Scripting, Scala, R, Spark
Realtime Processing: Kafka, Azure Events Hub
Orchestration: Azure Data Factory, Airflow
Visualization/Logging: Microsoft PowerBI, Grafana, Prometheus, Splunk
Metadata Management: Collibra, Datahub, ER Studio
Profile Summary
Results-oriented Data Engineer and Architect with 13 years experience, specializing in cloud computing and data-intensive applications.
Leading modernization of Amgen's Data & Analytics platform, enhancing user experiences.
Expertise in Azure cloud computing and architecture with certifications.
Proven experience in ETL/Data Warehouse design and migration using Abinitio.
Skilled in building scalable data platforms and infrastructure with strong governance and compliance focus.
Continuous learner, proficient in modern tech stacks including Big Data, streaming, Kubernetes, CI/CD.
Professional Experience
Technology Architect
Amgen
Oct 2023 - Present
Spearheading enterprise data engineering Center of Excellence team, crafting reusable solutions and frameworks.
Supervising data engineering initiatives, verifying data quality, fostering innovation and collaboration.
Aligning team efforts with business goals to streamline data workflows.
Staying current on emerging data engineering technologies.
Principal Engineer
UnitedHealth Group (Optum)
Apr 2017 - Sep 2023
Subject Matter Expert and Technical Owner for Optum Frontier Therapies cloud team, maintaining data quality and smooth operations.
Designed CD pipelines deploying terraform scripts across environments per enterprise guidelines.
Developed batch ETL framework using Azure Data Factory and Databricks for reporting databases.
Established layered data architecture (Bronze, Silver, Gold) in Azure Databricks.
Implemented near real-time reporting with Kafka and velocity reports.
Led cloud security implementations and managed cloud migration ensuring data quality.
Configured Azure pipelines, service connections, and variable templates linked to Key Vault.
Implemented row and column level security with Azure Synapse and Databricks roles.
Managed metadata with Collibra and Datahub.
Senior Consultant
Vodafone
May 2016 - Apr 2017
Collaborated on Ab Initio ETL architecture, metadata integration, and Hadoop-based data lake.
Provided services for Vodafone entities in Europe and Middle East on billing, account tracking, and vendor management.
Conducted feasibility and impact analyses and guided teams on design and implementation.
Handled production support and prepared reports on an ad-hoc basis.
Technology Specialist
Wells Fargo
Oct 2012 - May 2016
Participated as developer, implementer, and post-install support in various projects.
Tested and deployed data warehouse graphs across multiple environments.
Published reports for various business groups using incremental data warehouse.
Collaborated with global technology experts and gained Ab Initio, data warehousing expertise.
Associate
Morgan Stanley
Mar 2011 - Oct 2012
Supported multiple projects with development, testing, and support tasks.
Learned about Ab Initio environment, metadata, data lineage, and banking practices.
Certifications
AZ-305: Designing Microsoft Azure Infrastructure Solutions
AZ-500: Microsoft Certified: Azure Security Engineer Associate
AZ-400: Microsoft DevOps Engineer Expert
DP-203: Data Engineering on Microsoft Azure
Microsoft Certified: Azure Administrator Associate
Microsoft Certified: Azure Fundamentals
Education & Credentials
Bachelor of Technology (B.Tech.) - Computer Science Engineering (2005-09), Jagannath Institute of Technology & Management (BPUT, Odisha)
Project Details
Amgen
Leading enterprise data engineering Center of Excellence, crafting reusable solutions and frameworks.
Supervising key data initiatives, verifying data quality, fostering collaboration and innovation.
Aligning team goals with business objectives for streamlined data workflows.
Staying updated with emerging data engineering technologies.
UnitedHealth Group (Optum)
Subject Matter Expert and Technical Owner for Optum Frontier Therapies cloud team.
Designed terraform-based CD pipelines for infrastructure provisioning.
Developed batch ETL frameworks with Azure Data Factory and Databricks.
Managed layered data architecture and real-time reporting systems.
Led cloud security implementations and migration projects.
Configured pipelines, service connections, and security roles.
Managed metadata with Collibra and Datahub.
PreCheck MyScript (Optum)
Migrated on-premise Data Warehouse to cloud using Azure and Databricks.
Managed large-scale infrastructure and automation in Azure.
Designed Azure Resource Manager templates and CI/CD pipelines.
Worked on various cloud services and scripting languages.
Participated in technology architecture and migration strategy.
Vodafone
Collaborated on Ab Initio ETL architecture and Hadoop metadata integration.
Supported multiple Vodafone entities in Europe and Middle East.
Provided technical leadership, performance tuning, and production support.
Wells Fargo
Supported development and deployment of data warehouse solutions.
Collaborated with global experts and gained extensive technical knowledge.