Venkatrayudu Paladugu
Hyderabad,,Telangana
Summary
- Designed, built, and maintained Power BI dashboards and reports to support Finance, Operations, and leadership decision-making.
- Developed SQL Server data models using star schema design to enable efficient and scalable business reporting.
- Created DAX measures, calculated columns, and KPIs to track operational performance and business trends.
- Analyzed enterprise and ERP-style transactional data to identify performance trends and improvement opportunities.
- Supported month-end and year-end reporting by ensuring data completeness, reconciliation, and timely report delivery.
- Implemented data validation and quality checks to ensure accuracy, consistency, and integrity across BI datasets.
- Gathered and documented business requirements, translating them into clear and actionable reporting deliverables.
- Automated data refresh, transformation, and reporting processes to reduce manual effort and improve reliability.
- Provided user training, documentation, and troubleshooting for Power BI dashboards and analytical tools.
- Collaborated with IT, Finance, and Operations teams to improve data accessibility and enable data-Database Tools driven decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
ICICI Bank
Hyderabad, India
06.2020 - 07.2022
- Designed, built, and maintained Power BI dashboards and reports to support Finance, Operations, and executive leadership.
- Developed SQL Server data models using star schema design to enable scalable and high-performance reporting.
- Created DAX measures, calculated columns, and KPIs to track operational efficiency and business performance.
- Analyzed enterprise and ERP-style transactional data to identify trends, anomalies, and improvement opportunities.
- Supported month-end and year-end reporting through automated refreshes, reconciliations, and validation checks.
- Implemented data quality and validation processes to ensure accuracy, consistency, and reliability across BI datasets.
- Gathered and documented business requirements, translating them into clear, actionable reporting deliverables.
- Automated data refresh and reporting workflows, reducing manual effort and improving report reliability.
- Provided user training, documentation, and troubleshooting for Power BI dashboards and analytical tools.
- Collaborated with IT, Finance, and Operations teams to enhance data accessibility and enable data-driven decision-making.
- Reduced dashboards refresh time through query optimization and incremental load strategies.
- Delivered automated reporting solutions saving hours per week for Finance and Operations teams.
- ENVIRONMENT: Power BI (Power Query, DAX), SQL Server, Python, T-SQL, ETL Pipelines, Star Schema, KPI Development, AWS (S3, Lambda, Redshift), Git, CI/CD, Windows, Linux/UNIX, JIRA, Agile/Scrum.
Data Engineer
Tech Mahindra
Hyderabad, India
04.2019 - 05.2020
- Developed and maintained Power BI reports and dashboards for operational and management reporting.
- Built SQL-based fact and dimension tables optimized for analytics and KPI reporting.
- Created DAX calculations and reusable metrics to support performance analysis.
- Automated data ingestion and transformation using SQL and Python.
- Implemented data validation and reconciliation processes to ensure reporting accuracy.
- Supported month-end reporting activities and resolved data discrepancies.
- Worked closely with business stakeholders to improve dashboard usability and adoption.
- Integrated ERP transactional data into BI dashboards for real-time operational insights.
- Optimized SQL queries, reducing report generation time.
- ENVIRONMENT: Power BI, SQL Server, PostgreSQL, Python, T-SQL, ETL Pipelines, Star/Snowflake Schema, DAX, KPI Development, AWS (S3, Lambda), Git, Windows, Linux/UNIX, JIRA, Agile/Scrum.
Junior Data Analyst
Wissen Technology
Hyderabad, India
02.2018 - 03.2019
- Developed and maintained Power BI reports and dashboards for operational and management reporting.
- Built SQL-based fact and dimension tables optimized for analytics and KPI reporting.
- Created DAX calculations and reusable metrics to support performance analysis.
- Automated data ingestion and transformation using SQL and Python.
- Implemented data validation and reconciliation processes to ensure reporting accuracy.
- Supported month-end reporting activities and resolved data discrepancies.
- Worked closely with business stakeholders to improve dashboard usability and adoption.
- Integrated ERP transactional data into BI dashboards for real-time operational insights.
- Optimized SQL queries, reducing report generation time.
- ENVIRONMENT: Power BI, SQL Server, PostgreSQL, Python, T-SQL, ETL Pipelines, Star/Snowflake Schema, DAX, KPI Development, AWS (S3, Lambda), Git, Windows, Linux/UNIX, JIRA, Agile/Scrum.
Education
Master’s In Computer Science -
Campbellsville University
01.2024
Bachelor Of Computer Science -
CCSU
05-2015
Skills
Business Intelligence & Visualization
Power BI (Dashboards, DAX, Power Query), Tableau, Streamlit
Programming & Scripting Languages
SQL, T-SQL, Python (Pandas, NumPy, SQLAlchemy), C#
Data Modeling & Analytics
Star Schema, Snowflake Schema, Fact & Dimension Tables, KPIs, Metrics Development, Trend Analysis
ETL / ELT & Automation
Apache Airflow, AWS Lambda, Python ETL, Incremental Loads, CDC, Data Validation
Databases & Data Warehousing
Microsoft SQL Server, PostgreSQL, MySQL, Snowflake, Amazon Redshift, Google Big Query
Cloud Platforms
AWS (S3, Lambda, Redshift), Databricks, GCP
Version Control & CI/CD
Git, GitHub, GitLab, CI/CD Pipelines
Data Quality & Governance
Data Accuracy Checks, Reconciliation, Error Handling, Data Integrity, Documentation
Reporting & Business Analysis
Month-End & Year-End Reporting, Ad-hoc Analysis, Business Requirements Gathering, Stakeholder Collaboration
Operating Systems & Platforms
Windows, Linux, UNIX
Development & Database Tools
SQL Server Management Studio (SSMS), Power BI Service, pgAdmin, MySQL Workbench
Methodologies
Agile, Scrum
Certification
Microsoft Certified Power BI Data Analyst Associate
Projects
Cloud ETL Pipeline, Python, Airflow, AWS (S3, Lambda, Redshift), Architected a serverless ETL pipeline to extract data from public APIs, transform it using Python, and load analytics-ready tables into Amazon Redshift., Orchestrated multi-step workflows in Apache Airflow with dependency management, retries, and monitoring., Designed dimensional data models and optimized Redshift queries for downstream BI and analytics use cases., Reduced manual processing through fully automated scheduling and validation of daily data loads.
Timeline
Data Engineer
ICICI Bank
06.2020 - 07.2022
Data Engineer
Tech Mahindra
04.2019 - 05.2020
Junior Data Analyst
Wissen Technology
02.2018 - 03.2019
Master’s In Computer Science -
Campbellsville University
Bachelor Of Computer Science -
CCSU