OBJECTIVE:

To secure a challenging and dynamic position as a responsible and learning employee of an organization and enhance my knowledge by participating in active technical projects.

SUMMARY:

• Experience of a being part of a full - fledged implementation lifecycle for Oracle Apps R12 from Design and Development perspective.
• Have executed roles of Technical Designer, Technical Architect, Onshore coordinator for Oracle Apps R12 implementation projects; possessing strong written and verbal communication skills
• Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements.
• Extensive hands-on expertise using PL/SQL 10g,11g, XML Publisher Reports 10g, AME, Workflow, OAF and UPK in financial and HCM modules with strong business understanding of banking and TTH system domain.
• Involved in Preparing Technical Documents, Preparing the test Scripts andUnit Test Casesand Migration Activities and also migrate application from test to production environment.

TECHNICAL SKILLS:

Development Tools/IDE: Oracle Designer, Toad, PL/SQL Developer XML Publisher Report Workflow, Oracle User Productivity Kit, JDeveloper 10.1.3.3.0

ERP: Oracle EBS Release R12

Modules: iProc, PO, AP, Payments, iExpense,Cash Management

Additional: AR, Projects

FTP Client, Version Control System: FTP-WinSCP, Filezila, Putty, VSS 6.0

Languages: PL/SQL 10g 11g, SQL*Plus, Unix Scripting

Operating System: Microsoft Windows, UNIX

Awareness: SQL * Loader, Unix Scripting

Domain Experience: Banking, Travel Tourism and Hospitality

PROFESSIONAL EXPERIENCE:

Confidential

SKILL: PL/SQL 11g, XML Publisher Reports, Oracle DB, Unix, AME, Oracle Workflow, OAF,UPK, Knowledge in PO/AP/Payments modules.

Oracle Technical Developer

Responsibilities:

• Involved in R12 implementation, new interface designs, and data migration.
• Working in modules like iProcurement, AP, Payments, Cash Management and Projects.
• Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements.
• Writing Function, Procedure, View, Package, Materialized view, Trigger, Database link, Synonyms, Table and ERD creation.
• Designed and generated database objects and Reports.
• Worked in User Productivity Kit to develop content to facilitate knowledge transfer process to the users.
• Worked in OAF to develop basic search pages, personalisation and extensions.
• Developing and implementing AME and customized workflows as per business requirements.
• Developed XML Publisher Reports in PO and Projects module.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN Plan.
• Preparing Technical Documents, Preparing the test Scripts and Unit Test Cases and Migration Activities.
• Involved in gathering requirements and created design documents and mapping documents based on requirement provided from the Client.
• Provided UAT support.
• Involved with business in Pre-Production testing.
• Working on client location for post Go live support and worked as an onshore co-ordinator for Post-Go-Live activities.
• Implemented AME for Purchase Order Approvals as a part of CR to automate and simplify the approval system.

Confidential

SKILL:PL/SQL 10g, Unix, XML Pulisher Reports, Oracle Apps.

Team Member ( Oracle Technical Developer)

Responsibilities:

• Involved in Oracle Apps R12 up gradation and designing of interfaces and custom reports.
• Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements.
• Worked on deigning new Interfaces (Outbound/Inbound) for HRMS modules.
• Writing Function, Procedure, View, Package, Materialized view, Trigger, Database link, Synonyms, Table.
• Built various XML Publisher reports for HRMS / CWB.
• Preparing Technical Documents, Preparing the test Scripts and Unit Test Cases and Migration Activities.
• Provided UAT support.
• Migrated the complete module from test to production environment.
• Provided production support and implementing change requests to production environment.

Confidential

SKILL: Oracle DB, Unix, PL/Sql 10g, Oracle Apps

Team Member ( Oracle PL/SQL Developer )

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents based on requirement provided from the Client.
• Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements.
• Database query tuning, Performance tuning (Explain Plan utility) of Reports and troubleshooting Oracle Application issues
• Writing Function, Procedure, View, Package, Materialized view, Trigger, Database link, Synonyms and Table structure.
• Preparing Technical Documents, Preparing the test Scripts and Unit Test Cases and Migration Activities.
• Oracle jobs development, Window job development and scheduling (Window as well as Oracle) activity. FTP connector setup.
• Used Bulk Collect, FOR ALL feature to improve performance.
• Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Used partitioning and sub partitioning of tables to improve performance.
• Involved in Performance tuning of complex queries.
• Test case/data preparation, execution and verification of the test results.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Migrated the change requestes from test to production environment.