Sumathi K Email & Phone Number

Coimbatore Area, India

Working as a Senior oracle Consultant.

Chennai Area, India

• Worked with the Oracle Support team to Support Petrofac in Oracle Financial, HR, SCM , Fixed Asset and Project Modules.• Closely worked with the end users and department heads to address their ongoing support issues and provide design approach for enhancement requests. • Business Requirements Gathering.• Involves Software Design, Development, Testing, Implementation and Maintenance• Involved in Design Reviews and Code Reviews.

Coimbatore Area, India

• Gathering requirements from Functional Team and Users• Involved in Database Purging.• To Develop ORACLE reports based on audit requirements• To develop Exception Reports using Mail Alert• To Tune the existing objects like Reports, Procedures and Value Sets• Involved in the development customized reports using techniques like temporary table for the performance tuning of queries• Customizations (Functional Design/Technical Design, Unit Testing, Integration Testing)… Show more • Gathering requirements from Functional Team and Users• Involved in Database Purging.• To Develop ORACLE reports based on audit requirements• To develop Exception Reports using Mail Alert• To Tune the existing objects like Reports, Procedures and Value Sets• Involved in the development customized reports using techniques like temporary table for the performance tuning of queries• Customizations (Functional Design/Technical Design, Unit Testing, Integration Testing) writing Application Logic, Coding for customization using Oracle 1gi database objects, SQL, PL/SQL programming, including effective use of Oracle Packages, stored procedures, database triggers and tools like SQL*Plus, PL/SQL Developer, Toad. • Comprehensive usage of performance enhancing tools in Oracle like SQLTrace, Explain Plan, indexes, materialized views, Global temporary tables, autonomous transactions.• Year End Finalization Support• Involved in Form Personalization.• Involved in the Interface Testing • Preparation of Technical Design Documents • Enhance and maintain existing functionality Show less

Coimbatore Area, India

• Developing Oracle Forms in 6i for Inventory and Purchasing Modules.• Developed reports in reports builder 6i/10g and Discoverer reports.• Creating Reports, Procedures, Functions and Triggers.• Reviewed the code as per Oracle standard and Shanthi gears norms.• Involved in the Interface Testing Developed reports and forms in Visual Basic for Shanthi social Services.

Master'S Degree, Computer Science, First Class

Bachelor'S Degree, Electrician, First Class

Activities and Societies: National Social Services.