Ramesh Pallothu

Experience

• 

  LiquidHub

  Nov 2006 - Feb 2010

  Module Lead
• 

  Capgemini

  Mar 2010 - Jul 2011

  Senior Consultant

  Technical Lead, Solution design and execution

• 

  WinWire Technologies Inc.

  Jul 2011 - May 2012

  Senior Technical Lead
• 

  CGI

  May 2012 - Jun 2014

  Lead Analyst

  Enterprise Content Management solutioning, Project execution, Pre-sales

• 

  Cognizant

  May 2014 - Dec 2016

  Technical Architect
• 

  Tavant

  Dec 2016 - Dec 2019

  Associate Data Architect

  Led data & data pipeline migration strategy to increase the data load efficiency and reduce the infra cost.● Rebuilt 15 legacy ETL data pipelines using cloud native solutions, reducing pipeline execution time by 50% and saved $1 million on infrastructure costs.● Managed requirements and led the implementation.● Automated E2E pipelines and reduced operational cost 70%.● Defined the data quality metrics and KPIs.● Implemented Agile/Scrum Methodology and development.

• 

  Clarivate

  Jun 2020 - Mar 2022

  Data Architect

  Built a super complex data pipeline to transform data from multiple data sources, built a framework to handle structured and semi structured data.● Design scalable distributed data solutions using Spark Framework.● Automated E2E data pipelines using AWS Data services like S3, Lambda, Step Functions, Athena, EMR and SQS.● Redefined S3, Glacier data retention policies to save storage cost.● EMR cluster management with spot vs reserve vs on-demand instances to save compute cost.● Data pipelines integration with ML models.● Designed framework to unify data formats from multiple sources systems. ● Built data quality control framework.● Design data ingestion framework to consume data from various sources. Show less

• 

  T-Mobile

  Mar 2022 - now

  Data Architect

  Built an in-house ETL platform which processes 6 TB of incremental data daily and reduce development and maintenance costs by 50%.● Designed data flows to migration data from Salesforce to Snowflake (full and incremental)● Built data reconciliation pipelines to synchronize data between partner systems and T-Mobile.● Developed business critical ETL pipelines with complex transformations. ● Initiated low code/No code features to reduce development cost by 50%.● Lead product squad engineers, designers, security, SRE and coordinated with stakeholders across the regional ecosystem.● Ops advisory to provide automated solutions. Show less