Tech stack: MySQL, Pentaho, Informatica PowerCenter, Oracle BI Publisher● Leveraged advanced SQL queries and Informatica PowerCenter to execute seamless data transformations. Extracted, transformed, and loaded data with 99% accuracy and integrity, ensuring smooth migration of over 1 million records from legacy systems to modernized infrastructure. Utilized SQL for data validation and quality checks, reducing data inconsistencies by 95%, supporting overall project success.● Employed Pentaho to oversee and maintain existing processes. Adeptly troubleshot and resolved errors within an average of 30 minutes, ensuring uninterrupted continuity of operations and achieving a 99.9% uptime.● Successfully generated over 50 comprehensive reports with Oracle BI Publisher. Transformed and presented data from various sources using advanced data transformation techniques, resulting in a 40% improvement in report clarity and a 30% increase in report generation efficiency. Created visually appealing and insightful reports that enhanced decision-making processes for key stakeholders.

Tech stack: NestJS, JavaScript, PHP, Restful API● Assisted in the design and development of an advanced application using NestJS, JavaScript, and PHP to parse and interpret API data. Contributed to ensuring seamless integration with Restful APIs, helping to achieve a 30% improvement in data processing speed and handling over 500,000 API requests daily.● Developed functionalities using NestJS, JavaScript, and PHP to comprehensively interpret API data and documentation. Implemented algorithms to accurately parse various Restful API formats, ensuring compatibility with multiple data sources and achieving a 25% reduction in data parsing errors.