Summary
Overview
Work History
Education
Skills
Timeline
Generic

Revathi Mallineni

Kansas City,MO

Summary

Data Engineer and Data Analyst with 4 years of experience in data engineering, analytics, and business intelligence solutions. Expertise in SQL, Python, Informatica, and ETL development, with a strong foundation in cloud platforms (AWS, Azure, GCP) and database management (Snowflake, Databricks, SQL Server, PostgreSQL, MongoDB). Adept at designing end-to-end data pipelines, automating ETL workflows, and leveraging data modeling and governance best practices to drive business impact. Strong collaboration with cross-functional teams, data scientists, and business analysts to deliver data-driven solutions.

Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.

Overview

5
5
years of professional experience

Work History

Data Analyst

Aetna
06.2023 - Current
  • Manipulate large datasets in a business environment using SQL and Python to drive strategic insights.
  • Developed data models to establish relationships between entities, enabling more effective pattern recognition and anomaly detection.
  • Designed and implemented scalable data pipelines for real-time data integration and machine learning workflows.
  • Developed and optimized ETL processes using Informatica, SQL, and Python, ensuring seamless data transformation.
  • Integrated real-time financial data streams from SAP and OneStream, enabling dynamic reporting and faster month-end close processes.
  • Partnered with data science teams to integrate ML models into production environments.
  • Automated monthly reporting by building interactive Power BI and Tableau dashboards, reducing manual effort by 40%.
  • Managed cloud data infrastructure (Snowflake, Azure Data Factory, AWS S3) ensuring security and governance.
  • Built and maintained data lakes and ingestion pipelines using AWS Glue and Lambda, improving processing efficiency by 30%.
  • Integrated SAP and OneStream data, streamlining financial reporting and closing timelines.
  • Led Unix shell scripting automation for ETL job scheduling and data processing tasks and Data Lakes.
  • Managed SQL Server, Snowflake, and Azure Data Factory for data governance, security, and reporting.
  • Manage data governance, security, and reporting across SQL Server and Snowflake environments.
  • Built KPI dashboards in Tableau and Power BI, providing actionable insights for executive leadership.
  • Worked with AWS and Azure cloud platforms, integrating data lake and analytics solutions.
  • Designed and maintained AWS infrastructure components such as S3, Redshift, Lambda, and Glue for data storage, transformation, and orchestration.
  • Implemented data ingestion pipelines using AWS Glue and Lambda, reducing processing time by 30%.
  • Partnered with data scientists to productionize machine learning models, enabling predictive analytics.

Business Data Analyst

Franklin Templeton
01.2020 - 12.2021
  • Led ETL process development to integrate data from multiple sources, ensuring data quality and consistency for business intelligence initiatives.
  • Conducted long-term and short-term data analysis, optimizing productivity and reducing operational costs.
  • Developed data models and dimensional schemas to improve reporting capabilities.
  • Led business intelligence initiatives, implementing Power BI Dataflows and streamlining ETL processes.
  • Created detailed process flow diagrams and documentation to support business requirements and system enhancements.
  • Led data integration from multiple financial sources, maintaining data accuracy and reducing latency by 25%.
  • Conducted statistical analysis and built predictive models for business forecasting.
  • Created custom Power BI dashboards for business stakeholders to track KPIs and operational metrics.
  • Developed and tuned complex SQL queries for performance improvements and reduced data retrieval time.
  • Designed ETL pipelines with Informatica, improving reporting turnaround times by 40%.
  • Wrote Unix Shell scripts to automate batch ETL jobs and monitor data loads.
  • Implemented data governance models and documented data flow for auditing and compliance.
  • Led data integration projects using Informatica, ensuring data consistency and performance optimization.
  • Developed ETL workflows, improving data pipeline efficiency by 40%.
  • Conducted SQL-based performance tuning for database queries and data extraction.
  • Created Unix-based automation scripts for batch processing and ETL monitoring.
  • Built interactive Power BI dashboards for real-time decision-making.
  • Familiarity with data science approaches, including predictive modeling, classification, and clustering techniques to uncover actionable insights.
  • Developed data governance models, ensuring compliance with industry best practices.
  • Implemented cloud-based data storage solutions (AWS S3, Azure Blob) for optimized data retrieval.
  • Leveraged SQL and Tableau to analyze historical data, uncovering trends and patterns that informed process improvements and data-driven decision-making.

Education

Master of Science - Information Technology

Trine University
Angola,IN
12.2023

Bachelor of Technology - Electronics and Engineering

KL University
India
05.2021

Skills

  • Informatica
  • DBT
  • Data Pipelines
  • Data Warehousing
  • Airflow
  • Python
  • SQL
  • Unix Shell Scripting
  • JavaScript
  • C#
  • Snowflake
  • Databricks
  • SQL Server
  • PostgreSQL
  • MongoDB
  • Azure SQL Database
  • AWS
  • S3
  • Redshift
  • Lambda
  • Azure
  • Data Factory
  • GCP
  • Big Query
  • Cloud Functions
  • Hadoop
  • Spark
  • MLOps
  • Machine Learning Pipelines
  • ETL Development
  • Data Migration
  • Batch Processing
  • OneStream
  • SAP API Integration
  • Power BI
  • Tableau
  • Advanced Excel
  • Data Storytelling
  • JIRA
  • Agile
  • MS SharePoint
  • Cross-functional Team Communication
  • Data visualization and presentations
  • ETL processes
  • Data mining
  • Database management
  • SQL databases
  • Python programming
  • Data analysis
  • Data validation
  • Data warehousing
  • Database programming and SQL
  • Data mapping
  • Data programming

Timeline

Data Analyst

Aetna
06.2023 - Current

Business Data Analyst

Franklin Templeton
01.2020 - 12.2021

Master of Science - Information Technology

Trine University

Bachelor of Technology - Electronics and Engineering

KL University

Similar Profiles

CREATE PROFILE
Revathi Mallineni