satyasri

satyasri

Data Engineer
United States of America

نبذة عني

Data Engineer/Data Analyst/ Business Analyst with experience in data pipelines, ETL processes, SQL, Python, PySpark, AWS, Databricks, and data visualization tools such as Power BI and Tableau. Experience includes data en…

الخبرة

DATA ENGINEER

Copart – Plano, Texas, United State
Feb 2023 - حتى الآن · 3 سنوات 5 أشهر

Implemented schema changes to accommodate evolving business requirements, ensuring scalability for future data growth.
Designed and developed data pipelines to ingest and integrate data from diverse sources, both On-Premises and Cloud-based, using PySpark and AWS services like Neptune, RDS, Redshift, or Aurora.
Developed end-to-end ETL processes using Databricks Live Tables to extract, transform, and load data from diverse sources.
Crafted intricate SQL queries to extract granular insights from large datasets, optimizing data retrieval and analysis.
Developed Python (Spark) scripts for data preprocessing, enhancing data quality and reliability.
Revamped existing data models, introducing efficient fact and dimension tables, leading to a 20% improvement in query performance.
Increased overall data processing efficiency by 25% through optimization of ETL workflows and data models.

DATA ENGINEER

Tata Consultancy Services- Hyderabad, India
Oct 2020 - Sep 2021 · 11 أشهر

Contributed to a travel website project for streamlined data retrieval, optimization resulting in a 10% project efficiency gain.
Implemented PostgreSQL, AWS Redshift for streamlined data retrieval, applying indexing and query optimization techniques.
Utilized Airflow to orchestrate and automate complex workflows, ensuring seamless execution of ETL tasks.
Employed window functions and Common Table Expressions (CTEs) to simplify and optimize complex data retrieval scenarios.
Leveraged AWS Glue for efficient data cleansing, filtering, and aggregation, ensuring data quality and consistency.

DATA ANALYST

Smart Bridge in collaboration with IBM Intern, India
Jan 2018 - Jun 2020 · 2 سنوات 5 أشهر

Led the "Bike Buyer" project, utilizing clustering techniques to achieve a 12% improvement in prediction accuracy.
Applied data clustering methodologies to group customers, enhancing targeted marketing and prediction precision.
Played a key role in data acquisition, utilizing advanced SQL queries to extract, clean, and transform data from diverse sources.
Managing workflows with Jira and Rally, implementing continuous integration with Jenkins for data-driven projects.
Received the 'Team of Excellence' award for outstanding leadership and contribution to the project's success.

المهارات

بايثون (لغة برمجة) قاعدة بيانات SQL باور بي آي تحليلات البيانات SQL SQL Server MySQL PostgreSQL Azure SQL SparkSQL Oracle Data Mining Informatica Microsoft Azure Azure Data Factory Azure Synapse Analytics Big Data Hadoop HDFS Yarn Hive MapReduce MongoDB CMD shell PowerShell Pandas NumPy SciPy Matplotlib Git Bash AWS S3 Glue AWS Batch Dynamo DB Redshift AWS EMR CloudWatch RDS Lambda SNS SWS Beanstalk ECS EC2 CloudTrail Aurora MATLAB Unity xMatters AWS Application Integration WebSphere Microsoft SSIS Excel VLOOKUP
الإبلاغ عن هذا الملف الشخصي؟