DINESH S

Generic Sponsor Integration

• Designed and maintained data pipelines for efficient data flow.
• Collaborated with stakeholders to gather requirements and define specifications.
• Conducted data quality checks to ensure accuracy and consistency.
• Created documentation for ETL processes and data management standards.
• Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
• Developed ETL processes for data integration from various sources.

Monday.com Integration

• Optimized existing ETL workflows for improved performance and reliability.
• Participated in team meetings to discuss project progress and updates.
• Resolved complex issues related to ETL process through debugging existing code or writing new programs.
• Performed unit testing of all the mappings developed in the ETL layer before delivering it to production environment.
• Involved in creating database objects such as tables, views, indexes based on business requirements.

• Develop robust application, test and maintain application for the windows platform using PLSQL and .Net programming languages.
• Perform database defragmentation and optimize SQL queries, improving database performance and loading speed by 80%.
• Collaborate with stake holder & cross-functional teams, including business analyst and tester, to gather requirements and ensure that the application meets client requirements.
• Utilize joins and sub-queries to simplify the complex queries involving multiple table while optimizing store procedure, packages, views, functions and triggers.
• Debug and troubleshoot software issues and incident management to bug free application.
• Design and develop oracle application for windows platform using oracle-forms and report, PLSQL programming languages.
• Build and maintain forms using Oracle Forms.
• Build and maintain reports using Oracle Reports.
• Very high level programming- Packages, store procedure, trigger and functions as part of project.
• Maintain and development of ETL with large volumes of data (Oracle 10g/11g)