SHYAM PRASAD KATTA
Riverview,FL
Summary
Results-driven Data Engineer with over 2 years of experience in building automated ETL pipelines, cloud-based data solutions, and enterprise-scale reporting systems. Proficient in Python, SQL, Spark, and Azure / AWS cloud services. Skilled in data modeling, big data tools, and implementing secure and optimized data lake / warehouse solutions. Adept at working with business stakeholders to deliver scalable and reliable analytics infrastructure for decision-making.
Overview
2
2
years of professional experience
Work History
Data Engineer
Tata Consultancy Services TCS
Hyderabad, INDIA
07.2021 - 07.2023
- Designed and supported ETL workflows for document generation using Python, SQL, and Oracle tools, improving SLA adherence and reducing incident rate by 30%.
- Analyzed system logs to perform root cause analysis and proactively address issues, reducing recurring incidents by 15%.
- Automated data pipelines to process and monitor logs, performance stats, and alerts, enabling real-time system health insights.
- Collaborated cross-functionally to gather requirements and implement secure access controls using monitoring tools and audit trails.
- Practiced CI/CD using Git, Docker, and Jenkins to support data pipeline deployments and system automation.
- Streamlined data flow from diverse sources using ETL tools such as Talend, Informatica, and Airflow.
- Implemented data visualization tools like Tableau and Power BI to create dashboards and reports for business stakeholders.
Education
Master of Science - Computer Science
University of Central Missouri
05.2025
Bachelor of Technology - Electronics and Communication Engineering
VNR VJIET
05.2021
Skills
- Programming / Scripting : Python (Pandas, NumPy, SciPy), PySpark, SQL (T-SQL, PostgreSQL, MySQL), MongoDB
- Cloud Platforms : Azure (Data Factory, Databricks, Synapse, Data Lake), AWS (S3, Glue, Lambda, KMS, SNS, SQS - familiar)
- ETL Tools & Data Engineering : Azure Data Factory, Databricks, Spark, Bronze-Silver-Gold architecture, Automation with Key Vault & triggers
- Data Warehousing & Modeling : Azure Synapse, Snowflake (basic), DDL, data partitioning, indexing, RBAC, metadata management
- Analytics & Visualization : Power BI, Tableau, Excel (VLOOKUP, Pivot Tables, Conditional Formatting)
- DevOps & Tools : Git, Azure Key Vault, Entra ID, ServiceNow, JIRA
Projects
Azure End-to-End Data Engineering Project
- Built a scalable data pipeline using Azure Data Factory, Azure Databricks, and Azure Data Lake to move on-premise SQL Server data into Synapse Analytics.
- Transformed raw data using Spark and Python, implementing a Bronze-Silver-Gold layered architecture.
- Automated refreshes, secured pipelines with Key Vault, and enforced data access through RBAC with Entra ID.
- Created Power BI dashboards to track KPIs and deliver insights to business teams.
Sales Performance Dashboard (Power BI)
- Designed data model and ETL process in Power BI using Power Query and DAX.
- Automated data updates and built dynamic dashboards to track sales by product and region.
- Enabled real-time business reporting and supported leadership in strategic planning.
Timeline
Data Engineer
Tata Consultancy Services TCS
07.2021 - 07.2023
Master of Science - Computer Science
University of Central Missouri
Bachelor of Technology - Electronics and Communication Engineering
VNR VJIET
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Divya KandimallaDivya Kandimalla
SQL Support Engineer at Tata Consultancy Services (TCS)SQL Support Engineer at Tata Consultancy Services (TCS)
ZAMAGCAGA MAMPOFUZAMAGCAGA MAMPOFU
Accounts Receivable Specialist at Tata Consultancy Services (TCS)Accounts Receivable Specialist at Tata Consultancy Services (TCS)
Veronica GarciaVeronica Garcia
Clinical Nurse at BayCareClinical Nurse at BayCare