Gowri Arumugam

• Assessed project milestones and team performance to keep staff on-task.
• Developed strategic roadmaps for technology initiatives aligned with organizational goals while maintaining focus on resource allocation efficiency.
• Spearheaded migration of legacy systems to cloud-based platforms for increased scalability, cost-efficiency, and security measures.
• Boosted operational efficiencies via automation of manual tasks, allowing team members to focus on more strategic projects.

· Worked as an Onsite technical lead and SME for Oracle FLEXCUBE v10.5, coordinating with international teams in a multi-branch bank to meet the local regulatory and business requirements.

· Involved in gathering a complete requirement cycle during Flexcube Customizations and CL/ OBCL Migration.

· Collaborated with Business stakeholders to collect their requirements and prepared the Business Requirements Documents (RD140), Functional Specification Documents (FSD), and use cases documents for Flexcube Customizations and CL/ OBCL Migration.

· Prioritized and coordinated with technical teams to meet project milestones, ensuring that the projects delivery without sacrificing promised deadlines.

· Involved in the Project Implementation sessions to discuss the roadmap, requirements and identify the dependencies with other upstream/downstream systems.

· Functional expertise in various Flexcube modules like CASA (Customer Accounts and Saving Accounts), FT (Fund Transfer), Payments, Loans, Nostro Reconciliation, Bills and Collections, Clearing and Generic Interfaces.

· Participated in Customer and Account Setup associated with UDF (User defined field), IC Products, Instrument, Account Statement configuration.

· Exposure on Interest & Charge Product and Rule setup using the Data elements which can be applied at Account/Account Class level.

· Have In-depth knowledge and exposure on consumer lending (CL) module, including loan product maintenance, CL Account creation, Loan disbursement, Loan Payments, and Amendments.

· Worked on Data migration from Flexcube v10.5 to FLEXCUBE v14.7 where I was involved into analyzing and mapping the current business requirement to migrate Pending Loan schedules, Active and Matured loans, Future Value Dated Loans, CL Product, Core maintenances into Flexcube v14.5.

· Have knowledge on all the Core maintenances like BIC Code, Branch Code, Transaction Code, CCY Code, GL, Bank Parameters and Interfaces.

· Good understanding on End of the Day Process which performs various Transaction posting, Accounting Handoff, IC Accrual, IC liquidation, Reconciliation, Date Change etc.

· Strong knowledge on SWIFT Messaging, PreSTP (straight through processing), STP maintenances, Info9 name matching process.

· Worked as Offshore technical lead for Oracle FLEXCUBE, coordinating with Desjardins Customers.

· Participated in Data migration from legacy systems to FLEXCUBE, developing scripts to migrate customer,transactional data and Loans into the new core banking system Flexcube v14.5.

· Analyze and modify the Flexcube customizations to restore the expected functionality.

· Developed and customized PL/SQL solutions to address specific client needs, resulting in improved functionality and client satisfaction.

· Involved in developing, customizing, and supporting Oracle FLEXCUBE core banking solutions.

· Track and report on the status on a periodic basis of all requests and incidents reported for the FLEXCUBE

application that affects the bank’s customizations and interfaces.

· Collaborated with senior developers and business analysts to gather requirements, perform gap analysis, and provide customized solutions for FLEXCUBE modules.

· Validate any break-fix provided by the FLEXCUBE Global Support team.

· Supporting customers in Implementation of software changes and in different testing phases like SIT and UAT.

· Created and optimized AWS DMS tasks to facilitate database migrations for 250+ Tables, managing data transformations and ensuring schema compatibility between source and target databases.

· Troubleshot AWS DMS migration issues such as network connectivity, replication lag, and data type mismatches using CloudWatch and detailed task logs.

· Involved in developing comprehensive schema mapping strategy for Database objects such as view, procedures, triggers, packages, functions etc. from Oracle 12c to AWS RDS Oracle 21c using AWS SCT.

· Involved in development of scripts for extensive testing strategy for validating the post migration data and DB objects.

· Automated movement of the Reporting files from On-premises reporting file system to S3 buckets using AWS Lambda functions.

· Maintained YAML-based CloudFormation templates for the provisioning of AWS services. Integrated these templates into the Bamboo pipeline for deployment using forge manifest processor.

· Configured ongoing replication using AWS DMS for real-time data synchronization between on-premises databases and AWS RDS for Oracle.

· Involved in implementation support activities Post Data migration activities.

· Design and Developed SSIS Packages for efficient data extraction, transformation, and loading process from various sources (Oracle, MySQL, flat files) into an Oracle DB with accurate data mapping.

· Automated ETL workflows using SQL Server Agent Scheduler and Shell scripting, reducing manual intervention, and improving process reliability.

· Conducted performance tuning and optimization of existing ETL processes, leading to significant improvements in efficiency.

· Responsible for development, support, maintenance, and implementation of small to medium non-complex components of a project module.

· Involved in the Development and unit testing of new developments and enhancements.

· Jobs monitoring in Production.

· Co-ordination with onsite personnel.

· Designed, developed, and deployed ODI solutions to manage ETL using Oracle Data Integrator (ODI) and Oracle Warehouse Builder (OWB).

· Implemented ODI Interfaces, Packages, Procedures, and Load Plans to automate daily and batch data integration processes.

· Assisted in the development and implementation of ODI flows and packages to support the organization’s data

integration needs multiple data sources (Oracle, SQL Server, flat files) to streamline business processes.

· Participated in ETL testing and validation to ensure that data was being correctly loaded into the target systems.

· Integrated multiple data sources (Oracle, SQL Server, flat files) to streamline business processes across different applications.

· Designed data validation processes and resolved discrepancies to maintain data accuracy.

· Involved in monitoring ODI jobs failures and implement error handling mechanisms and alerts.

· Worked with Business analyst during the requirement gathering.

· We had regular discussions with Schneider client manager to finalize the implementation approach.

· Involved into the elevated level of ETL development tasks.