Siva Palanimanickam

Executed installation, configuration, and administration of Oracle SOA Suite components.

• Managed Oracle databases (11g/12c/19c), overseeing backup/recovery and performance tuning.
• Fine-tuned middleware and database layers to enhance high availability and scalability.
• Developed integrations across diverse systems using SOA composites and SQL procedures.
• Diagnosed complex issues in WebLogic, SOA, and database environments effectively.
• Conducted regular health checks and implemented proactive maintenance strategies.
• Supported quality assurance and user acceptance testing environments.

• Designed enhancement and maintenance strategies for enterprise applications, ensuring scalability, and reliability.
• Developed testing strategies, impact analyses, and detailed design specifications aligned with business requirements.
• Verified front-end and back-end functionality across 15+ applications; conducted feasibility studies, and implemented optimized solutions.
• Installed, configured, upgraded, and managed SQL Server environments (2005–2014); performed performance tuning, and troubleshooting.
• Created and scheduled SSIS packages for ETL processes using SSIS Designer and SQL Server Data Tools (SSDT); coordinated with ETL teams to ensure accurate data flow.
• Utilized tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for database optimization.
• Conducted job monitoring and backend validation for SQL Server and Oracle-based applications.
• Used Import/Export Wizard for multi-server data migration, and automated tasks via Windows Scheduler.
• Supported HP ALM for structured test management, and Skype for Business for user provisioning and access control.
• Developed VBA-based automation tools to streamline application processes and meet delivery timelines.

• Designed and executed comprehensive test plans covering regression, usability, negative testing, and SQL database impact.
• Developed automated test cases using VBA, QTP/UFT, and Parasoft SOAtest; authored BDD scenarios in Gherkin format, and uploaded them to CA Agile Central.
• Planned test strategies aligned with project scope and delivery timelines; participated in design reviews, and created business process flow diagrams.
• Verified front-end and back-end functionality across multiple applications; validated back-end logic in SQL Server and Oracle environments.
• Created and optimized complex T-SQL scripts, including stored procedures, triggers, and views, to enforce business rules.
• Provided backend fixes and deployed them across environments; conducted feasibility studies, and implemented effective troubleshooting solutions.
• Evaluated business requirements, and regularly reported project status to stakeholders.

• Gathered requirements and conducted impact analysis to deliver code enhancements across multiple applications.
• Designed and optimized complex T-SQL scripts, stored procedures, and database objects for business logic implementation.
• Automated daily tasks and data transformations using Excel macros and VBA for increased efficiency.
• Developed unit tests and supported QA/UAT through thorough defect analysis documentation.
• Validated front-end and back-end functionality to ensure compliance with coding standards.
• Provided technical support for inbound and outbound systems while contributing to application maintenance strategies.