Arunprasat R V

• Designed a Data Mapping Automation tool to auto-generate data dictionaries, cutting manual effort by 70%.
• Collaborated with CI/CD and UI teams to streamline ETL pipelines, enhancing Marketing team efficiency by 75%.
• Developed a Foreign Data Wrapper function in Greenplum for rapid data transfer, expediting Dell's migration processes.
• Replaced traditional ETL loads with FDW-based automation, reducing load times for large tables to under five minutes.
• Architected real-time data integration for dashboards, enabling sites reporting within two weeks.
• Supported raw data availability in the Landing Zone for Marketing's Data Science initiatives on Copilot usage.
• Led sales dataset support, ensuring smooth Teradata migration as part of the Go-to-Market strategy.
• Integrated diverse systems' data, processing unstructured JSON via APIs.

• Led performance tuning initiatives that optimized Teradata spool space and CPU utilization, achieving a 60–70% reduction in overall system costs for the queries owned by our product team.
• Supported Business Data Lake catch-up activities during critical outages, loading and validating 180+ objects in 3 days to ensure timely month-end services reporting.
• Contributed to the 'Tiger Team' initiative to identify root causes of recurring product incidents, implementing SOPs that improved incident resolution by approximately 50% during quarter-end peaks.

• Led end-to-end ETL development and integration efforts using Informatica, Teradata, Greenplum, and Control-M by designing workflows, creating views, modifying data pipelines, and ensuring real-time and batch data synchronization across platforms, reducing data latency from 2 days to within a day.
• Collaborated with cross-functional teams—including testing, e-commerce, and business users—to gather requirements, develop test cases, perform unit/functional testing, and lead training sessions and knowledge transitions; mentored junior developers in Informatica, Control-M, and SSIS.
• Redesigned and enhanced existing ETLs to support the onboarding of new operating companies (opcos), enabling parameter-driven configurations and reducing integration time; integrated Aurora ERP datasets into Eclipse using lookup tables and conversion logic while ensuring data integrity through rigorous multi-environment testing.

Designed and optimized complex ETL pipelines using Informatica, implementing business logic-driven mappings.
Developed parameterized workflows and automated schema changes with stored procedures to enhance data warehouse scalability.
Conducted comprehensive analysis of project ETLs to convert integer primary keys to bigint, coordinating phased implementation.
Resolved dependencies to minimize impact across databases during key conversion process.

Attained 98% accuracy in PIM data cleansing for over 75,000 product SKUs through rigorous validation methods.
Improved completeness of product information by analyzing and filling missing attributes for Web Catalog inventory.
Cut data redundancy by 40% through consolidation of product records from multiple Operating Companies and ERP Systems.
Implemented Excel-based automation for product searches, reducing manual processing time by 75%, accelerating SKU migration from one year to six months.