Vinodh Kumar Email & Phone Number

Mumbai, Maharashtra, India

• Perform advanced Extract, Transform, Load (ETL) development activities using Informatica, PL/SQL, Oracle database tuning, SQL tuning, and Informatica Server administration.
• Developed efficient data pipelines to extract, transform, and load data from different sources into a data warehouse using Python - PySpark, reducing manual efforts by 60%.
• Established data storage solutions encompassing Azure SQL Database, Azure Data Lake, and Azure Blob Storage.
• Improved data processing performance by 20% by performing data partitioning and optimization techniques.
• Written Procedures, Functions, Views, and Triggers in Oracle to perform data operations.
• Leveraged Java Spring Boot framework to design and develop a wide range of business portals tailored for different operational needs.

Ahmedabad, Gujarat, India

• Designed, implemented, and maintained 15+ data pipelines for data ingestion, processing, and transformation in Azure.
• Collaborated over 1 year with data scientists and analysts to understand data requirements and develop efficient data workflows.
• Managed Azure Data Factory or comparable technologies for ETL (Extract, Transform, load) operations.
• Enforced data validation and cleansing procedures across approximately 50+ datasets to ensure data quality, integrity, and dependability.
• Monitored and resolved data pipeline issues, ensuring 98% data consistency and availability.
• Orchestrated the integration of real-time data streaming capabilities, leading to a 30% increase in operational efficiency and enabling faster decision-making for business stakeholders

Visakhapatnam, Andhra Pradesh, India

• Designed and implemented a sophisticated database schema for the supply chain portal, resulting in a 30% query performance improvement and a 20% reduction in response time.
• Developed intricate PL/SQL procedures, functions, packages, and triggers, achieving a 30% efficiency boost over 6 months to meet business needs.
• Improved senior management's decision-making with over 100 complex queries for data analysis support.
• Conducted unit testing and debugging on 150 PL/SQL components to ensure functionality and accuracy.
• Managed updates and server space for Linux DB systems as per client requirements.
• Automated space management with 15+ shell and batch scripts, enhancing operational efficiency