Prashanth Reddy Email & Phone Number

Dallas, Texas, United States

Led data migration from Oracle and SAP ASE to BigQuery using Dataflow, staging in Google Cloud Storage (GCS).Containerized Python-based data processing jobs using Google Kubernetes Engine (GKE).Automated batch processing and task scheduling with Airflow for orchestration.Built real-time data pipelines from SAP HANA to Google Cloud for faster analytics using SAP BODS.Cleaned and normalized datasets using Spark and Python to get rid of inconsistencies.Scaled data pipelines to process huge amount of data daily to optimize performance and better latency.Implemented Change Data Capture (CDC) and incremental loading strategies for real-time data updates.Managed data ingestion pipelines with Terraform and set up CI/CD pipelines using Cloud Build.Monitored data workflows with Cloud Monitoring to ensure stability across BigQuery, Dataproc, and Airflow environments.Collaborated with cross-functional teams in an Agile environment, ensuring timely delivery of data solutions.

Designed and built ETL pipelines to migrate CRM data into Snowflake with FiveTran, for analysis.Cleaned and normalized transactional data to maintain accuracy and reduce duplication for efficient storage.Streamed real-time IoT data into BigQuery with Google Pub/Sub, using timestamps to capture only updated records.Created data models using star schemas, improving performance for reporting and analytics.Used Python and PySpark to transform data before loading it into BigQuery, optimizing for better query performance.Integrated machine learning models on live datasets for predictive insights, including recommendations and classifications.Automated ETL processes with Airflow, orchestrating both real-time and scheduled tasks.Participated in Agile sprints, working with cross-functional teams to ensure on-time delivery of data projects.

Hyderabad, Telangana, India

Migrated healthcare data from on-premise systems to AWS Redshift using Talend and AWS Glue, ensuring compliance with HL7 and FHIR standards.Developed Python and Spark scripts on AWS EMR and Lambda to transform data for analytics in Redshift.Designed and implemented secure data processing for Protected Health Information (PHI) in S3 using data mirroring and staging techniques.Automated batch processing with AWS Step Functions, EMR, Lambda, and Glue to handle large healthcare datasets efficiently.Managed real-time healthcare data via APIs, processing it with Python and storing it in optimized formats for analysis.Monitored healthcare data pipelines using AWS CloudWatch and CloudTrail for real-time logging and tracking.Used Git for version control of data scripts and Jira for task management within Agile teams.

Built frameworks for both full and incremental data loads, improving ETL efficiency.Developed and implemented data solutions using Spark and Python to load data from AWS S3 into Redshift.Created dimension and fact tables in Redshift, applying database indexing to enhance query performance.Automated manual processes with Python scripts, saving time and effort in data processing.Conducted end-to-end unit testing and documented results to ensure quality before moving to production.Collaborated with business users, ETL developers, and QA teams in an Agile environment to meet project deadlines.Designed and documented visualization reports, including KPI creation, to provide clear insights to stakeholders.

Hyderabad, Telangana, India

Developed and maintained ETL processes using Informatica PowerCenter, applying SCD Type 1 and Type 2 logic for accurate customer data management.Designed and optimized Informatica mappings for efficient bulk data loads, leveraging FastLoad and MultiLoad in Teradata.Created star schema data marts in Teradata, supporting advanced reporting and KPI analysis with fact and dimension tables.Engineered ETL workflows to populate data marts, enhancing reporting capabilities and providing valuable business insights.Documented ETL processes and transformations, providing user guides and data dictionaries for seamless maintenance and reference.

Hyderabad, Telangana, India

Designed and implemented customized database systems to meet diverse client needs.Developed advanced ETL pipelines using Pentaho, streamlining data integration from multiple sources.Engineered scalable big data solutions with Hadoop, Hive, MapReduce, and Spark.Optimized MapReduce code, improving performance and resolving job failures efficiently.Authored detailed technical documentation and user guides for Hadoop and its ecosystem.