HARSHITHA PRASAD
Dallas,TX
Summary
Professional data integration specialist with 5+ years of experience prepared to excel in ETL development roles. Proven history of optimizing data workflows and enhancing data accuracy across various platforms. Known for strong team collaboration and consistent delivery of high-quality results, with expertise in SQL, data warehousing, and problem-solving.
Overview
8
8
years of professional experience
Work History
Data Engineer
Pinnacle Group
Dallas, TX
02.2023 - 05.2026
- Independently managed and owned the complete client account by leading end-to-end ETL development, enterprise data warehouse design, deployments, production support, stakeholder communication, and delivery management for large-scale financial reporting and analytics initiatives.
- Led initiatives to automate repetitive tasks, enhancing operational efficiency within the team.
- Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
- Built, automated, and maintained scalable ETL pipelines using SSIS and Azure Data Factory, ensuring timely and reliable data delivery within SLA timelines.
- Developed complex SQL queries, stored procedures, fact tables, and dimension tables to support high-performance reporting and analytics solutions.
- Collaborated with finance teams, business analysts, and cross-functional stakeholders to translate business requirements into scalable technical solutions.
- Designed and implemented enterprise data integration processes into Amazon QuickSight for dashboarding, reporting, and business intelligence visualization.
- Implemented data validation, monitoring, logging, governance, and Change Data Capture (CDC) processes to improve data quality, pipeline reliability, and operational efficiency.
- Optimized ETL workflows and SQL queries using Change Data Capture (CDC), improving pipeline performance by 50%, reducing failures by 30%, and lowering operational and infrastructure costs for the company.
- Managed CI/CD deployments, release management, issue resolution, and production support using Git and Azure DevOps.
- Optimized database performance by tuning queries and indexing strategies for improved response times.
- Increased efficiency of data-driven decision making by creating user-friendly dashboards using Tableau that enable quick access to key metrics.
Data Analyst
Tata Consultancy Services
Cleveland, OH
11.2021 - 02.2023
- Implemented Agile methodologies within cross-functional teams and acted as a liaison between business stakeholders at Pentagon Federal Credit Union and the data engineering team to ensure successful project delivery.
- Developed and maintained ETL workflows using batch processing, SQL, Python, Shell scripting, and SSIS to support production systems, data integration, and reporting processes.
- Designed and implemented SQL-based data transformation rules, optimized MySQL database queries, and supported data extraction, validation, and reporting activities.
- Collaborated with senior data engineers during data warehousing, deployment, and migration activities to support scalable enterprise data solutions.
- Developed Tableau dashboards and data visualizations to transform complex datasets into actionable business insights and support post-ETL reporting requirements.
Project Engineer
Wipro Technologies
Bangalore, India
08.2018 - 07.2019
- Utilized Agile methodology to support iterative development, stakeholder communication, requirement analysis, reporting, and delivery of analytical solutions.
- Performed application performance testing and analysis using NeoLoad, generated performance reports, and identified optimization opportunities to improve system efficiency.
- Leveraged Python libraries including Pandas, NumPy, SciPy, and Matplotlib to analyze structured and unstructured data from databases, flat files, and reporting systems.
- Developed analytical reporting solutions, SQL queries, stored procedures, database views, and Tableau visualizations to support data-driven business decisions and stakeholder reporting.
- Utilized MS Office Suite (Excel, Word, PowerPoint) to prepare dashboards, reports, presentations, and business insights for stakeholders and clients.
Education
Master of Computer Science - Computer Science
Kent State University
Kent, OH05-2021
Bachelor of Information Science and Technology - Information Technology
Visvesvaraya Technological University
08-2018
Skills
- Azure Data Factory
- SSIS
- SQL Server
- Snowflake
- Python
- Tableau
- Power BI
- Amazon Quick Sight
- SQL Optimization
- Azure DevOps
- Git
- AWS
- Agile Methodology
Timeline
Data Engineer
Pinnacle Group
02.2023 - 05.2026
Data Analyst
Tata Consultancy Services
11.2021 - 02.2023
Project Engineer
Wipro Technologies
08.2018 - 07.2019
Master of Computer Science - Computer Science
Kent State University
Bachelor of Information Science and Technology - Information Technology
Visvesvaraya Technological University