Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Rama Krishna Pallerla

Dallas,TX

Summary

Experienced data analytics and engineering professional with 5+ years of expertise in leveraging data insights to drive strategic decision-making across multiple business functions. Proficient in Python and SQL for data analysis, as well as Power BI and Tableau for creating interactive dashboards and reports. Skilled in utilizing machine learning techniques for predictive analytics. Recognized for automating reporting processes and improving system performance through innovative solutions.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Heford Business Solutions
05.2023 - Current
  • Designed and implemented end-to-end ETL pipelines using Apache Spark and Azure Data Factory, improving data processing efficiency by 50%.
  • Developed real-time data ingestion pipelines leveraging Kafka and Snowflake, reducing data latency and improving system response times by 40%.
  • Built and deployed serverless data processing solutions using AWS Lambda, significantly cutting infrastructure costs.
  • Automated data validation and anomaly detection using Python and machine learning models, increasing data accuracy and reducing inconsistencies by 30%.
  • Spearheaded migration from on-premise databases to cloud-based architectures, leading to 25% cost savings and improved scalability.
  • Designed and implemented multi-layer data models to enhance reporting and dashboard capabilities in Power BI and Tableau.
  • Led a team of junior data engineers, providing mentorship and guidance in ETL best practices and cloud-based data processing.
  • Integrated CI/CD pipelines for data workflows, enabling automated testing and deployment, reducing manual intervention by 60%.
  • Partnered with business stakeholders to develop self-service BI solutions, improving data accessibility and decision-making.
  • Conducted performance tuning and query optimization for large datasets, reducing report generation time by 35%.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Applied loss functions and variance explanation techniques to compare performance metrics.
  • Ran statistical analyses within software to process large datasets.
  • Devised and deployed predictive models using machine learning algorithms to drive business decisions.
  • Modeled predictions with feature selection algorithms.
  • Analyzed large datasets to identify trends and patterns in customer behaviors.
  • Learned and adapted quickly to new technology and software applications.
  • Developed strong communication and organizational skills through working on group projects.

Senior Data Engineer

Gayatri Projects Limited
06.2020 - 12.2022
  • Designed and managed data pipelines for ingesting, processing, and storing large-scale fleet performance data, reducing ETL processing time by 40%.
  • Implemented a robust ETL workflow using Python to extract, transform, and load vehicle log data, optimizing fleet tracking efficiency by 20%.
  • Developed and maintained Tableau dashboards that provided real-time insights into fleet movement, maintenance schedules, and cost analysis, increasing operational efficiency by 30%.
  • Engineered automated anomaly detection algorithms using Python and SQL, identifying inconsistencies in fleet data and reducing errors by 25%.
  • Deployed Docker-based containerized applications to streamline data processing workflows, integrating with CI/CD pipelines to enhance development agility.
  • Collaborated with cross-functional teams to define data governance standards, ensuring high-quality, consistent, and reliable data assets.
  • Improved forecasting accuracy by 15% through advanced predictive analytics and machine learning models for inventory and sales optimization.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Applied loss functions and variance explanation techniques to compare performance metrics.
  • Ran statistical analyses within software to process large datasets.
  • Devised and deployed predictive models using machine learning algorithms to drive business decisions.
  • Modeled predictions with feature selection algorithms.
  • Developed polished visualizations to share results of data analyses.
  • Compiled, cleaned and manipulated data for proper handling.
  • Leveraged mathematical techniques to develop engineering and scientific solutions.
  • Implemented randomized sampling techniques for optimized surveys.
  • Participated in team projects, demonstrating an ability to work collaboratively and effectively.
  • Demonstrated creativity and resourcefulness through the development of innovative solutions.

Data Analyst

Scrimpify
07.2019 - 05.2020
  • Conducted exploratory data analysis (EDA) using Python and SQL, identifying key trends and anomalies that improved financial decision-making by 20%.
  • Designed and executed ETL operations to extract, clean, and transform data from multiple sources (CSV, XML, JSON) into SQL databases, reducing data processing time by 85%.
  • Developed interactive Power BI reports that enhanced business intelligence visibility and operational transparency across teams.
  • Implemented data standardization protocols, improving data consistency and reducing manual data cleansing efforts by 70%.
  • Designed and deployed data validation and reconciliation scripts to ensure data integrity across analytics platforms.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Developed data mining algorithms to identify and classify patterns in data.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Created dashboards to monitor and track key performance indicators.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Optimized data access and storage to improve performance of analytics systems.
  • Designed and developed data pipelines to acquire, clean and process data.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Created data models to support decision-making processes.

Education

Master of Science - Business Analytics and Artificial Intelligence

The University of Texas at Dallas
Dallas, Texas
12.2024

Bachelor of Engineering - Civil Engineering

Osmania University
Hyderabad
06.2019

Skills

  • SQL
  • Python
  • Java
  • R
  • Looker
  • Tableau
  • Power BI
  • MS Excel
  • Azure Data Factory
  • ETL Pipelines
  • Apache Spark
  • PostgreSQL
  • Redshift
  • Snowflake
  • SQL Server
  • MS Visio
  • Lucid Chart
  • JIRA
  • Confluence
  • Google Suite
  • Data Quality Management
  • Data Governance
  • Statistical Analysis
  • Troubleshooting Data Anomalies
  • Business Process Analysis
  • Root Cause Analysis
  • Data Modeling
  • Agile
  • Scrum
  • Data warehousing
  • NoSQL databases
  • Continuous integration
  • API development
  • Java development
  • Machine learning
  • Data security
  • Performance tuning
  • ETL development
  • Linux administration
  • Python programming
  • RDBMS

Certification

  • Google Data Analytics
  • Azure Data Engineer
  • AWS Cloud Practitioner
  • AWS Data Engineering

Timeline

Senior Data Engineer

Heford Business Solutions
05.2023 - Current

Senior Data Engineer

Gayatri Projects Limited
06.2020 - 12.2022

Data Analyst

Scrimpify
07.2019 - 05.2020

Master of Science - Business Analytics and Artificial Intelligence

The University of Texas at Dallas

Bachelor of Engineering - Civil Engineering

Osmania University

Similar Profiles

CREATE PROFILE
Rama Krishna Pallerla