Hemanth Pendam
Springfield,IL
Summary
Logical data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with several years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
8
8
years of professional experience
2
2
years of post-secondary education
Work History
Data Analyst /Senior ETL Developer
Lead IT Corporation
Springfield, IL
01.2023 - Current
- Designed and maintained ETL pipelines to extract, transform, and load large datasets from multiple source systems into enterprise data warehouses.
- Developed complex SQL queries, joins, stored procedures, and data transformations to support analytics and reporting.
- Worked with Talend-based data integration workflows to process structured files and batch data loads.
- Processed and validated EDI files and other file-based data exchanges for downstream analytics and reporting systems.
- Implemented data cleansing, transformation, and validation rules to improve overall data quality and reliability.
- Collaborated with cross-functional teams to gather requirements and translate business needs into scalable data solutions.
- Built automated reporting pipelines using SQL, Python, and Excel to reduce manual data preparation.
- Monitored ETL jobs, investigated data pipeline failures, and optimized workflows to improve processing performance.
- Supported data warehouse architecture and data modeling activities to ensure efficient data retrieval.
- Created dashboards and analytical reports to help stakeholders track key performance metrics and operational insights.
Data Analyst /Senior ETL Developer
Tech Mahindra
Springfield, IL
01.2020 - 06.2022
- Developed ETL workflows to extract and integrate data from relational databases and flat files into centralized data warehouses.
- Wrote optimized SQL queries, joins, and data transformation scripts to support business reporting and analytics.
- Performed data cleansing, validation, and quality checks to ensure accuracy and consistency across reporting datasets.
- Built automated data pipelines and reporting processes using Python and SQL, reducing manual reporting efforts.
- Created dashboards and analytical reports using Excel and BI tools to support operational decision-making.
- Collaborated with cross-functional teams to understand business requirements and deliver data-driven insights.
- Assisted with data modeling and schema design to improve data accessibility and reporting performance.
- Monitored and optimized ETL job performance to improve pipeline efficiency and reliability.
Data Analyst /ETL Informatica Developer
JPMorgan Chase
Springfield, IL
03.2018 - 01.2022
- Developed ETL workflows to extract and integrate data from relational databases and flat files into centralized data warehouses.
- Wrote optimized SQL queries, joins, and data transformation scripts to support business reporting and analytics.
- Performed data cleansing, validation, and quality checks to ensure accuracy and consistency across reporting datasets.
- Built automated data pipelines and reporting processes using Python and SQL, reducing manual reporting efforts.
- Created dashboards and analytical reports using Excel and BI tools to support operational decision-making.
- Collaborated with cross-functional teams to understand business requirements and deliver data-driven insights.
- Assisted with data modeling and schema design to improve data accessibility and reporting performance.
- Monitored and optimized ETL job performance to improve pipeline efficiency and reliability.
Education
Master of Science - Data Analytics
University of Illinois At Springfield
Springfield, IL 08.2022 - 05.2024
Skills
- Talend (TDM, TDA)
- ETL Pipeline Development
- Data Integration Workflows
- Batch Data Processing
- SQL (Advanced Joins, Window Functions, Stored Procedures)
- Python (Pandas, Data Processing)
- Shell Scripting
- EDI File Processing
- Healthcare Data Integration
- HIPAA Data Handling Concepts
- Healthcare Claims Data Processing
- Snowflake
- SQL Server
- MySQL
- PostgreSQL
- Data Warehousing Concepts
- Data Modeling
- Data Transformation
- Data Migration
- Data Cleansing
- Data Validation
- Data Governance
- Error Handling in ETL Pipelines
- Power BI
- Tableau
- Advanced Excel (Pivot Tables, Power Query)
- AWS (S3, Glue, Lambda basics)
- Apache Spark / PySpark
- Databricks
Timeline
Data Analyst /Senior ETL Developer
Lead IT Corporation
01.2023 - Current
Master of Science - Data Analytics
University of Illinois At Springfield
08.2022 - 05.2024
Data Analyst /Senior ETL Developer
Tech Mahindra
01.2020 - 06.2022
Data Analyst /ETL Informatica Developer
JPMorgan Chase
03.2018 - 01.2022