Aakash Veerapandian

• Analyzed business requirements and designed Talend ETL workflows, ensuring efficient data integration and processing as per client specifications.
• Owned the end-to-end development of Talend ETL jobs, from design and implementation to deployment in the production environment, ensuring seamless data integration and optimal performance.
• Implemented error and job logging in Splunk through Talend code, enabling efficient debugging and issue resolution
• Followed and contributed to ETL job change and design best practices developed by the team, while continuously enhancing and version-controlling the processes using Git and GitHub
• Seamlessly deployed code into the production environment using Kubernetes, ensuring scalability, reliability, and efficient usage of containerized applications.
• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
• Designed and developed solutions throughout the Software Development Lifecycle (SDLC) using Agile methodology, actively interacting with end users and participating in SCRUM meetings

• Designed and implemented the complete end-to-end BI architecture, ensuring seamless data flow from extraction to reporting.
• Collaborated with Subject Matter Experts (SMEs) to understand business requirements, analyze data sources, and identify relationships between database tables.
• Developed ETL workflows in Talend for efficient data extraction, transformation, and loading (ETL) into MySQL, ensuring data accuracy and consistency.
• Optimized ETL performance by implementing best practices for data integration, improving processing efficiency and reducing load times.
• Created and maintained Universes in SAP BusinessObjects (SAP BO) to facilitate customized reporting as per stakeholder requirements.
• Designed and generated dynamic reports and dashboards in SAP BO, enabling real-time insights and data-driven decision-making.
• Ensured data integrity and security, implementing proper validations and access controls to maintain compliance and reliability.
• Provided documentation and knowledge transfer, ensuring smooth handover and future maintainability of the BI solutions.
• As part of the migration process, redesigned and developed reports from SAP BO in Tableau, leveraging its advanced visualization capabilities, interactive dashboards, and real-time analytics to provide deeper insights and enhanced decision-making.

Anti-Money Laundering:

• Developed a PL/SQL procedure to identify and validate customers across multiple database sources, ensuring data accuracy, authenticity, and consistency for enhanced decision-making and fraud detection.

Data Lake Project

• Collaborated with cross-functional teams to identify and prioritize key datasets for storing into the Data Lake, ensuring optimal data availability and usability.
• Utilized Sqoop CLI to efficiently migrate structured data into the Data Lake, converting it into Parquet format for improved storage efficiency and query performance.

Data Warehouse Project

• As a part of migration of ETL code from Oracle Data Integrator (ODI) to Talend, ensuring optimized workflows for improved performance and scalability.
• Designed and implemented workflow enhancements, resulting in efficient data processing and scalability improvements.
• Managed ETL pipelines, ensuring data integrity, stability, and accuracy throughout the migration process.
• Executed end-to-end migration of data from Netezza to Amazon Redshift, focusing on strategic planning and execution to maintain data integrity.
• Migrated ETL metadata from Oracle to Amazon PostgreSQL, ensuring seamless data consistency and accessibility.
• Developed and automated a File Wrapper job using Shell scripting, enabling automatic triggers for new file placements.
• Optimized data integration processes and performed database performance tuning, leading to reduced processing times and enhanced system response.
• Conducted in-depth troubleshooting to identify root causes of issues, implementing timely and effective resolutions.
• Authored comprehensive documentation, outlining migration strategies, methodologies, and troubleshooting guides, facilitating knowledge transfer and future reference.
• Collaborated with cross-functional teams, including database administrators and business stakeholders, to ensure seamless communication and alignment throughout the migration process.