Data Analyst & Automation Engineer

RAHUL KUMAR

Bengaluru, India

***********@*****.*** — linkedin.com/in/rahulkumar594 — Mobile: +91-819-***-**** Profile Summary

Results-driven Data Analyst and Automation Engineer with 6+ years of experience across BFSI, healthcare, and technology domains. Strong expertise in Python, SQL/PLSQL, Selenium, Pytest, Power BI, and Apache Airflow. Proven ability to deliver end-to-end analytics and automation solutions, improve operational efficiency, and collaborate with international stakeholders in Agile environments. Experience

Tata Consultancy Services Limited – Systems Engineer (Data & Insights) Apr 2023 – Sep 2025

• Delivered and maintained 50+ production Power BI dashboards for finance and operations teams, improving decision-making efficiency by 25%.

• Used SQL and Amazon Athena to extract, analyze, and validate 10M+ financial and transactional records stored in Amazon S3.

• Automated data validation and reconciliation using Python (Pandas, NumPy, Matplotlib), reducing manual reporting effort.

• Monitored and supported 450+ daily Apache Airflow pipelines, maintaining a 98%+ success rate and ensuring SLA compliance.

• Investigated pipeline failures, optimized SQL transformations, and performed root-cause analysis via ServiceNow.

• Designed optimized Power BI data models (star schema) and improved dashboard performance using query optimization and incremental refresh.

• Collaborated with UK-based stakeholders to gather requirements, support UAT, and translate problem statements into BRD-style documentation.

Practo Technologies Pvt Ltd – Product Support Specialist Jun 2020 – Apr 2022

• Worked extensively with PL/SQL to develop, modify, and optimize stored procedures, functions, packages, and triggers.

• Performed SQL and PL/SQL performance tuning using execution plans, indexing strategies, and query refactoring, improving response time by 30%.

• Used complex joins, subqueries, CTEs, and analytical functions for root-cause analysis and production data fixes.

• Executed validated data correction scripts for appointment, billing, and provider modules, ensuring data accuracy.

• Managed 200+ JIRA tickets per month, resolving 90% within SLA and reducing recurring defects by 15%.

• Collaborated with engineering teams during releases, schema changes, and post-deployment validations. Concentrix Services India Pvt Ltd – Automation / Technical Support Engineer Mar 2018 – Feb 2020

• Designed and developed Python-based Selenium automation frameworks for GUI and regression testing.

• Used Pytest for test execution, assertions, fixtures, parameterization, and managing smoke, sanity, and regression suites.

• Python automation with Selenium WebDriver, BDD (Cucumber), strong debugging skills, and solid knowledge of data structures.

• Applied object-oriented programming (OOP) concepts, reusable Python modules, and error-handling mechanisms to build scalable, maintainable automation solutions, integrated with CI/CD pipelines and scheduled executions.

• Integrated automation execution with CI/CD pipelines (Jenkins, Azure DevOps, GitHub Actions).

• Automated repetitive workflows, reducing manual testing effort by 80%.

• Worked in an Agile environment, participating in sprint planning, demos, and stakeholder reviews. Technical Skills

Programming Languages: Python, SQL, PL/SQL, Shell Scripting Automation & Testing: Selenium (Python), Pytest, Robot Framework, Automation Framework Design, Data-Driven Testing

BI & Analytics: Power BI, DAX, Data Modeling, Dashboard Optimization Cloud & Data Platforms: Amazon Athena, Amazon S3

ETL & Scheduling: Apache Airflow, JS7 Scheduler

CI/CD & Version Control: Git, Jenkins, Azure DevOps, GitHub Actions Tools: Oracle SQL Developer, OBIEE, SAP BO, ServiceNow, JIRA Methodologies: Agile, Scrum, Sprint Demos, Stakeholder Reviews Education

NMAM Institute of Technology, Karnataka, India

Bachelor of Engineering – Computer Science and Engineering

Contact this candidate