Arunprasat R V
Bengaluru
Summary
- Dynamic professional with a strong background in ETL optimization and real-time data processing.
- Known for leading automation initiatives that enhance data quality and accelerate decision-making, effectively supporting cross-functional teams ,business objectives and streamlining the ETL patterns across the EDS Sales domain from various sources.
- Results-oriented advisor with extensive experience in designing data automation tools .
- Expertise in analytical thinking and collaboration, contributing to significant efficiency improvements and reducing load times from hours to under five minutes.
Overview
12
12
years of professional experience
Work History
Advisor
Dell Technologies
09.2021 - Current
- 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 from hours 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 , Salesforce , Databases.
Senior Analyst
Dell Technologies
03.2020 - 09.2021
- 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.
Application Development Senior Analyst
Accenture Solutions Pvt.Ltd
09.2016 - 03.2020
- Received various awards includes Performer of the Month from clients and Apex award (individual & Team) FY-18 Q4 & & FY-19 Q1 in Accenture.
- 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. This includes the delivery of 60+ objects in the span of 6 months with minimal resource availability.
- Integrated the Legacy Dell & Legacy EMC datasets for the Professional Services team to enabled the reporting for Project Financials , Timecard and Concur.
- 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.
Application Development Analyst
Accenture Solutions Pvt.Ltd
12.2014 - 09.2016
- 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 for 200+ objects in the database.
- Resolved dependencies to minimize impact across databases during key conversion process.
Application Development Associate
Dell Technologies
09.2013 - 12.2014
- 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.
Education
Bachelor of Engineering - Mechanical Engineering
Sona College of Technology
Salem07.2013
Skills
- Data quality assurance
- Data mapping
- Data integration
- ETL optimization
- Analytical thinking
- Problem-solving
- Informatica
- Python
- Spark
- CI/CD
- Salesforce
- SQL - Teradata , Greenplum , Oracle , SQL Server
- Lakehouse - ECS , Iceberg
- Data Governance - Federated Computational Governance
LANGUAGES
Tamil: First Language
English: C1 Advanced (C1)
WEBSITES, PORTFOLIOS, PROFILES
- Www.linkedin.com/in/arunprasat-r-v-47924562
Interests
Interested towards the Finance related information
Timeline
Advisor
Dell Technologies
09.2021 - Current
Senior Analyst
Dell Technologies
03.2020 - 09.2021
Application Development Senior Analyst
Accenture Solutions Pvt.Ltd
09.2016 - 03.2020
Application Development Analyst
Accenture Solutions Pvt.Ltd
12.2014 - 09.2016
Application Development Associate
Dell Technologies
09.2013 - 12.2014
Bachelor of Engineering - Mechanical Engineering
Sona College of Technology
Similar Profiles
Reventh Raj YataReventh Raj Yata
SENIOR PRINCIPAL BUSINESS INTELLIGENCE MANAGER at DELL Technologies (DELL EMC + Dell Entities)SENIOR PRINCIPAL BUSINESS INTELLIGENCE MANAGER at DELL Technologies (DELL EMC + Dell Entities)
Taarun RajBhalanTaarun RajBhalan
Principal Software Engineer – Performance Engg at Dell Technologies Inc, Dell International ServicesPrincipal Software Engineer – Performance Engg at Dell Technologies Inc, Dell International Services
M.Banu PrakashM.Banu Prakash
Senior Analyst, Sales at Dell International Services (Dell Technologies)Senior Analyst, Sales at Dell International Services (Dell Technologies)
Reginald WilkinsonReginald Wilkinson
Quality Engineer at DELL TECHNOLOGIES / DELL EMCQuality Engineer at DELL TECHNOLOGIES / DELL EMC
Pragya RajPragya Raj
Software Engineer (Frontend) at SwiggySoftware Engineer (Frontend) at Swiggy