Harsha Penmetcha
Frisco,TX
Summary
Enthusiastic and driven Business Analytics graduate. Looking to secure a position where I can utilize my analytical skills and business knowledge.
Overview
1
1
Certification
8
8
years of professional experience
Work History
Senior Data Analyst
Syser Inc.
01.2026 - Current
- Improved dashboard performance and load times by 30–50% through optimized data modeling, relationship restructuring, and DAX measure refinement.
- Automated recurring reporting processes in Power BI, reducing manual reporting effort by 5–12 hours per week and improving consistency across reports.
- Integrated data from multiple sources (SQL databases, Excel, and APIs) into Power BI data models, consolidating reporting into a single source of truth.
Implemented data validation and transformation rules, reducing data inconsistencies and reporting errors by ~20–35%.
ETL Analyst
Ernst & Young
01.2022 - 08.2025
- Document design specifications to address data mapping, data quality, data lineage, data transformation logic, logical data model, physical database design
- Build code based upon technical specifications for ETL (Extract, Transformation, and Loading), data quality rules, data transformation logic, database and table creation scripts
- Conduct data related testing to confirm that developed code meets technical requirements
- Design, run and report on automation or performance test scenarios, scripts and execution results
- Apply the automation tools to support a wide variety of tax compliance processes
- Collaboration with Internal and External facing clients to develop dashboards for various tax return services
- Developed dataflows as well as databricks solutions to improve performance of reports with large datasets.
Data Analyst
Syser Inc.
11.2018 - 01.2022
- The ability to communicate effectively to multiple levels in technology organization.
- Provided analytics and forecasts for cloud capacity, troubleshooting analysis and uptime.
- Wrote python scripts to parse xml documents and load data in the database Extensively used python modules such as pandas, requests, and urllib.
- Set up databases in AWS using RDS including MYSQL and Dynamo DB. Storage using S3 buckets and configuring instance backups to S3 buckets.
- Built basic ETL that recorded transactional data from multiple websites with large daily users.
- Manage various levels of AWS services(Lambda, Aurora, and Route 53).
- Recruiting Company that focuses on helping Immigrants land IT positions
Education
Bachelor of Science - Business Analytics
University of North Texas
05-2021
Skills
- SQL
- Python
- Tableau
- Linear Programming
- Data Visualization
- Warehousing
- Modeling
- Access
- Excel
- Optimization
- Jira
- Redshift
- Glue
- IAM
Certification
AWS Cloud Practitioner
Timeline
Senior Data Analyst
Syser Inc.
01.2026 - Current
ETL Analyst
Ernst & Young
01.2022 - 08.2025
Data Analyst
Syser Inc.
11.2018 - 01.2022
Bachelor of Science - Business Analytics
University of North Texas