Data Analyst Engineer

Vijendhar P

Ó (91-863******* • R *******@*****.*** • https://www.linkedin.com/in/vijendhar-p-109b2a194/ About Me

Data Analyst and Data Engineer with 4+ years of experience across Manufacturing and Insurance sectors. Skilled in SQL for building robust data models and experienced in automating ETL pipelines using Informatica and Alteryx to integrate data from multiple sources. Proficient in visualization tools like Tableau and Metabase to validate and present data. Adept at working with stakeholders to design scalable and efficient analytical solutions.

Work Experience

Data Analyst - PLUM (Jul 2024 – Present)

• Engineered an organization-level data pipeline in PostgreSQL and Metabase to track claims settlement performance, surfacing bottlenecks in claims processing at scale.

• Developed an automated reporting pipeline for ICR (Incurred Claims Ratio) that consolidated claims, support, and communication data, ensuring a single source of truth across multiple touchpoints.

• Designed and deployed a Claims NPS (Net Promoter Score) pipeline with KPIs (MoM, YoY), fully automating reporting (100% manual effort eliminated) and enabling near real-time customer satisfaction insights.

• Built self-service data workflows to automate recurring team data requests, removing 100% of manual dependencies and ensuring uninterrupted daily operations.

• Implemented data quality frameworks to unify claims data from disparate sources, improving accuracy, reliability, and scalability for downstream analytics. Data Engineer - Tata Consultancy Services (Jul 2021 – Jul 2024)

• Designed and maintained ETL pipelines using Informatica and Alteryx to integrate data from flat files, Teradata, and Microsoft SharePoint into target systems including Teradata and Tableau data sources.

• Wrote advanced SQL queries in Teradata to track monthly P&L performance across multiple manufacturing plants, supporting finance and operations.

• Developed and supported Tableau dashboards with key KPI charts, enabling leadership to drive data-informed decision making.

• Established data governance practices by creating LLDs (Low-Level Design docs), performing unit test cases, and ensuring end-to-end pipeline reliability.

• Automated ETL workflows using Informatica Workflow Monitor and Alteryx Gallery, significantly reducing manual dependencies and operational overhead.

• Migrated and integrated 100+ SAP warehouse tables into the enterprise data warehouse using Informatica, while also assisting with production migration and support activities. Technical Skills

• ETL & Workflow Orchestration: Informatica PowerCenter, Alteryx, Apache Airflow (DAGs, Baisc knowledge)

• Databases & Data Warehousing: Teradata, PostgreSQL, Oracle, MySQL, Data Modeling

• Programming & Scripting: SQL (advanced query optimization, stored procedures), Python (Pandas)

• Data Engineering Practices: Data Pipeline Development, Workflow Automation, Data Quality Frameworks, Production Migration, Documentation (LLD, UAT)

• Data Visualization & Reporting: Tableau, Metabase (for validation and stakeholder reporting) Education

SASTRA Deemed University, Thanjavur, India Jul 2017 – Jul 2021 Bachelors of Technology • Mechanical Engineering • GPA: 7.63/10 Project

Automated ETL Pipeline and Tableau Dashboard for Australian Weather Insights [Project Doc.] Developed an end-to-end automated pipeline using Airflow, PostgreSQL (Docker), and OpenWeather API to collect and store daily weather data for Australian cities, and visualized insights through interactive Tableau dashboards.

Certifications

• Alteryx Designer Core Certification - Alteryx

• User Expereince: The Beginners Guide - Interaction Design Foundation

Contact this candidate