SUMMARY:

• 6 years of experience as an Oracle Apps Developer/Functional Consultant.
• Worked on Oracle Upgrade, Oracle Conversions, Implementation, and Production Support projects.
• Good technical skills in PL/SQL, RICEFW Components.
• Aware of Oracle standard practices, Software development life cycles, AIM, Agile Methodology, SOX Compliance.
• Functional expertise in Oracle Finance modules (AP, AR, FA, CM, and GL), in SCM modules including Purchasing, Order Management, Inventory, and in EB Tax, Projects, Property Manager, Oracle Time and Labor, and HRMS modules. Implemented Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Knowledge of accounting within ERP modules.
• Excellent client facing skills, strong will to learn, flexible, good communication skills, team player.

AREA OF EXPERTISE:

Languages & Tools: PL/SQL,UNIX,C, HTML and Java(novice), Toad, SQL * Plus, SQL Developer, SQL Loader, BI, Web ADI, Putty, Data Loader, Appworx, PVCS, Perforce, Service now, Remedy, HP ALM, ITSM, and Maximo.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Worked on Oracle Upgrade, Oracle Conversions, Implementation, and Production Support projects. Good technical skills in PL/SQL, RICEFW Components.
• Aware of Oracle standard practices, Software development life cycles, AIM, Agile Methodology, SOX Compliance.
• Functional expertise in Oracle Finance modules (AP, AR, FA, CM, and GL), in SCM modules including Purchasing, Order Management, Inventory, and in EB Tax, Projects, Property Manager, Oracle Time and Labor, and HRMS modules. Implemented Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Knowledge of accounting within ERP modules.

Confidential

Oracle Apps Techno - functional Consultant

Responsibilities:

• Responsible for addressing and resolving issues reported by the business users and finance team within defined SLAs.
• Providing and suggesting best practices in ERP to users. Managing all the issues and enhancements related to Finance and SCM modules being the primary point of contact.
• Scheduling and monitoring batch jobs. Dealing with Oracle support.
• Working on Order Management, Purchasing, Inventory, Receivables, General Ledger, Payables, Fixed Assets, Property Management and HRMS modules.
• Good knowledge in the Order to Cash process, aware of the data flow between each module and the tables involved.
• Implemented the related setups including the creation of Inventory Organizations and working on the customizations related to Landed cost and average cost calculations.
• Good understanding of the concepts of EBTax, Confidential Architecture, COGS/DCOGS.
• Worked in rollout projects creating new ledgers, Operating units, and configurations related to data flow between different sub ledgers.
• Worked in the integration of legacy systems with Oracle ERP.
• Providing ad - hoc data using SQL queries, developing BI reports based on the business requirement.
• Responsible for closing the Inventory periods during month end and supporting the finance team in the closure of Finance modules.
• Deploying change requests and patches weekly in Production by coordinating with DBA Team.

Confidential

Software Engineering Sr.Analyst

Responsibilities:

• Part of Oracle implementation team, worked on the development of Interfaces, PL/SQL packages, Forms, Reports (RDF, XML, OBIEE) and, APIs.
• Setups related to Approval Workflows/AME, Approval hierarchy.
• Preparing MD50, MD70 documents as per AIM methodology.
• Worked on Configurations, customizations in the P2P cycle.
• Participation and support in test cycles (Unit Testing, Functional, UAT).
• Developed procedures using HRMS APIs for interfacing data from Workday to Oracle HRMS, also developed related custom reports.
• Worked in Global Production Support team, dealing with users across the Globe.
• Experience of working in 24*7 support environments.
• Achieved system stabilization within a year from Go - live and reduced incidents count drastically.
• Worked as PEM (Production Environment Manager), routing the production issues reported to the respective teams.
• Managed high Severity and VIP Incidents by bringing in the correct set of people to work on and resolving without breaching SLAs.
• Performing Root Cause Analysis on the issues and make sure it is not repeated.

Confidential

Software Engineering Analyst - PL/SQL Developer

Responsibilities:

• Developed PL/SQL packages involving complex logic and calculations helping the client to manage the Orders effectively.
• Worked on Triggers, Indexes, Procedures, Functions, and on advanced PL/SQL concepts like collections and performance tuning.

Confidential

Software Engineering Associate - Oracle Apps Developer

Responsibilities:

• Upgraded RICEFW components to R12 standards, viz New/Obsolete/Replaced Tables, data flow and related setups.
• Worked on the R12 functionalities like MOAC, R12 EBTax, SLA - Sub Ledger Accounting, Confidential - Trading Community Architecture.
• Developed Oracle Discoverer reports and Forms from scratch, also worked on Forms personalization and OAF personalization. providing access to users based on the Job roles.
• Played a significant role in the test phase, worked on testing the R12 functionalities and data flow between sub ledgers in different modules, supported UAT, R12 Go-Live and PGLS (Post Go-Live Support) phases and ensured a smooth upgrade.
• Designed and developed the Inbound Interfaces, validation programs for loading the data into staging tables, used standard Oracle APIs.
• Performed the mock conversions of AP and AR invoices in the live Oracle system from legacy using standard open interfaces.
• Worked with the client teams and the users and helped in resolving the issues/service requests related to Finance and HRMS modules in Production.
• Worked with Oracle Support Team. Aware of the complete lifecycle of how Oracle SRs works, their Jobs and responsibilities and the process of escalations.
• Supported the Month - end process and worked on reconciliations related to Cash management and PA to GL.