Kalyanasundaram Loganathan

ASGC Construction is a vertically integrated construction conglomerate. Founded in 1989, the group’s corporate headquarters is in Dubai, UAE. ASGC has offices in Egypt and the United Kingdom. The company owns the majority of its supply chain and utilizes mostly in-house resources, giving it a high degree of control over project quality and timely delivery. ASGC has grown and developed over the last 30 years, to become an industry leading Construction Company for the execution of turnkey special projects in the UAE.
Projects
• Oracle Upgrade 12.2.11/19c from 12.1.3/12c
• Primavera Administration
• Hyperion Administration

• Key role in upgrade and stabilising the environment with less business impact on downtime
• Managing and enabling Co-ordination between the business users & N/W Consultants during scope and requirement gathering phase and implementation
• SAN storage Management
• HP Server management and handling related issues
• Handling backup and backup policies using HP data protector (HPDP).
• Shell scripts to monitor the systems and send notifications to DBAs.
• Worked on Hardware and OS Sizing requirements.
• Cloning of Multi node to Multi node / Multi node to single node EBS.
• Setting up RMAN for database backups and building scripts for Incremental Backups.
• Handling Router and VPN configuration.
• Handling roll-out DBA projects covering various regions in EMEA, APAC
• Handling DBA team and managing on support activities

• EBS Cross Platform/Hardware migration from HP-UX 11.11 to Solaris 10.
• Upgraded EBS from 11.5.10.2 to R12 (12.1.1) on HP-Unix 11.11.
• Migrated Tablespace model to OATM (Oracle Applications Tablespace Model).
• Re-Implementation of R12 (12.1.3) and 11.2.0.2 on Solaris 10 on Sun SPARC T4-2 Server.
• Cloning of Multi node to Multi node / Multi node to single node EBS.
• Setting up RMAN for database backups and building scripts for Incremental Backups.
• Configuring Workflow notification mailers, Printer Setups & Pasta Configuration.
• Patching Oracle Environments with One-off, Minipacks, family packs, RUP patches.
• Shell scripts to monitor the systems and send notifications to DBA’s.
• Support Functional Issues related to Supply Chain Management Modules(INV and OM)
• Worked on Hardware and OS Sizing requirements.
• Administered Hardware virtualization and OS Virtualization (Solaris containers).
• Configuring Workflow notification mailers, Printer Setups & Pasta Configuration.
• Experience in Oracle software Audit and Licensing.
• Experience in handling SCM related issues and requests.

• Support and Maintenance of 11i instance with 10.2.0.4 on Solaris 10 on SUN Server.
• Transition and betterment of existing support process
• Cloning of Multi node to Multi node / Multi node to single node EBS.
• Automation of Cloning procedure through shell script
• Database cloning using RMAN Duplicate method
• Handled Hyperion application with SQL Server on Windows platform
• Setting up and maintenance of Standby database
• Installation and maintenance of Business intelligence tools
• Implemented SSL on e-business suite as part of successful web expenses deployment.
• Upgraded Discoverer to 10g and implemented Sun JRE to replace JInitiator.
• Cloned Oracle Hyperion 9.3.1 instances. Performed exports and imports.
• Carried out database administration on SQL Server 2005 including backup and restore.
• Used various tools for SLA and release management e.g. Cerberus, M/S Visual SourceSafe and Subversion.
• Administration of Oracle Application Server 10g (9.0.4.1).
• Managed user sessions, locks and package analysis. SQL and PL/SQL.

• Involved in Analyzing the business requirements, estimating the user growth and Define Hardware Requirements and Sizing requirements and design the new system.
• Migration of EBS 11.5.10.2 system from RHELAS3 on HP Proliant RAID-5 complaint servers to RHEL AS4 IBM Blade server.
• Upgrade of Oracle Applications Release 11.5.10/9.2.0.8 on RHEL AS4 to 12.1.1/10.2.0.4.
• Upgraded EBS from 11.5.10.2 to R12 (12.1.1) on HP-Unix 11.11.
• Migrated Tablespace model to OATM (Oracle Applications Tablespace Model).
• Cloning of Multi node to Multi node / Multi node to single node EBS.
• Maintenance of Honeywell Oracle Applications Development, Test & Production Single-Node Instances.
• Monitoring the growth of instances and estimating future hardware sizing requirements.
• Cloning of Oracle Applications Single node instances - Development, Test and Productions
• Analyzing and Applications of Oracle 11i Application patches using adpatch.
• Routine Database Tasks - Space management, Hot Backups, Lock Monitoring, Performance Monitoring, Tuning SQL, PL/SQL jobs, Custom Concurrent Programs, O/S Load Monitoring, Partitioning of large tables, online index/table rebuilds.
• Monitoring the Oracle Applications System performance and taking the necessary actions during the Month-End, Quarter-End and Year -Ends.