Oracle Apps Techno Functional (SCM, FIN, HRMS, CRM

Objective:

To obtain a competitive and challenging position in a global organization that gives scope to share, contribute and upgrade my knowledge for development of self and organization served. Also, to acquire latest cutting edge skills in emerging trends of Oracle Applications.

Professional Summary:

Having 8.3 Yrs. of experience in Oracle Applications.

Excellent Technical skills in developing & analyzing RDF and XML Publisher Reports, SQL, PL/SQL and OAF in the domain of Oracle Applications E-Business Suite.

Technical Skills on Informatica Life Cycle Management (ILM) tool for data archival.

Good analytical, design, programming, problem solving skills, communication and presentation skills.

Stepping in to Solution Architect role.

Different modules worked includes SCM, AP, AR, GL, HRMS, OIC, TM, RM

Good Understanding of Anaplan Data Modelling.

Have Valid B1 US Visa till 2024.

Work Experience:

Currently working in Dell International Services as Software Dev Advisor from Jul 2011 to till date.

Worked as a Programmer Analyst with Intelli Group (Asia) from Aug’ 2010 to Jun 2011.

Worked as Senior Software Engineer in KEANE INTERNATIONAL (India) Pvt Ltd from Jun’2007 to Aug’2010.

Education:

B.E (Computer Science) from BMS Institute Of Technology (V.T.U) in 2007.

Technical Skills:

ERP

Oracle Applications E-Business Suite 11i, R12

Tools

TOAD, SQL*LOADER, Reports 6i, SSH Client,ILM, TFS, Kintana for Code Deployment

Operating Systems

Windows 98/95, Windows NT/XP, UNIX

Languages

SQL*Plus, PL/SQL, Unix Shell Scripts

Packages

Oracle Developer 2000, MS Office

RDBMS

Oracle 9i and 10g, 11g Database

Other Technologies

Anaplan Cloud Computing Model development Basics, Informatica Life Cycle Management Tool for Data Archiving on Oracle Apps environment.

PROJECTS:

Project 1:

Project Title : Compensation Incentive System (Oracle Application R12)

Duration : Jul 2011 to Till date

Role : Sr. Software Analyst

Technical Environment : Oracle 11g, 12.1.1 application SQL,PLSQL

Interfaces, Support and Development of new custom module on Oracle Incentive Compensation, Anaplan Cloud Computing Model development Basics, Informatica Life Cycle Management Tool for Data Archiving on Oracle Apps environment.

About the Project:

This is a R12 Development, Enhancement and Support project.

Purpose of the project is to provide Oracle Application Version R12.1 to support, enhance and develop custom modules for Oracle Incentive Compensation module used to calculate commission/bonus for the sales/non sales employees respectively.

Contributions:

Understanding MD50 and transforming functional requirements to design the code.

Involved in the development of new custom SCA module to replace the existing core of the calculation engine.

Transformed MD50 into MD70.

Have lead a group of 5 members team for Maintenance project handling the different support issues arising out from Production

Involved in the enhancement of existing functionality of Interfaces like Affinity, People soft Interfaces.

Involved in basic functional setups like Role Setup, Resource Setup, creation of Expressions, Formulas, Plan element, Compensation plan and setting up account as territory for testing purpose and hence have basic functional knowledge on OIC, TM and RM modules.

Involved in development of data archival solution using ILM.

Travelled Onsite for requirement gathering and stepping into the role of solutions architect.

PROJECTS:

Project 2:

Project Title : Open Link Financials Oracle Implementation R12

Duration : Sep’2010 to Till date

Role : Sr.Developer

Technical Environnent : Oracle 10g, 12.1.1 application SQL, PL/SQL, Interfaces, (General Ledger,HRMS),

Conversions (HRMS)&Reports.

About the Project:

This is a R12 Implementation project.

Purpose of the project is to implement Oracle Application Version R12.1 to support Open Link Global Financials and HRMS(Core HR, SSHR) functions.

Contributions:

Understanding MD50 and transforming functional requirements to design the code.

Have completed the Employee Personal details, Employee Address Conversion and Employee Assignment Conversions for HRMS module.

Involved in development of Currency Exchange Interface for GL module.

Involved in the development of HRMS report, SSHR outbound Interfaces.

Involved in client meetings for better understanding of the requirements.

Involved in preparation of MD70 for each object.

Project 3:

Project Title : Honeywell ACS Support

Duration : JAN-2009 – 06-AUG-2010

Role : Team Member

Technical Environment : Oracle 10g, 11.5.10 application SQL, PL/SQL,

Report 6i, Alerts, XML Publisher Reports, Oracle Apps Modules (OM, INV, PO, AP, AR,PA)

About the Project:

This is a Support project. It involved, Support and Maintenance of all ERP modules used in Honeywell ACS Europe and Middle East Operations

Contributions:

Resolved service requests raised by business users within the SLA slippage time.

Provided solution to technical issues in all the ERP modules involved in Honeywell.

Had status review calls with client IT management regularly and interacted with business users regarding requirements.

Led a team of 3 members.

Fixed issues associated with Oracle reports, PL/SQL packages, SQL scripts and UNIX shell programs.

Developed custom Oracle programs involving reports, PL/SQL packages, SQL reports as required by the business user.

Prepare installation guidelines / Patches.

Hands-on experience in migrating the modified oracle objects using Object Migrator tool.

Developing code for extracting data from production instances for data migration from oracle to SAP requirements.

Developed CTL scripts for SQLLOADER.

Performed Item uploads to Master, Validation and Inventory Organizations as per the user requirement.

Performed Price List upload

Involved in handling basic functional issues in the modules of OM, AP, AR, INV, PO and PA modules.

Involved in writing scripts as per user’s requirement. For Example, Vendor extract, Customer extracts, AP Matched with PO extracts and Expense claim extracts etc.

Involved in performance tuning.

Code Preservation using VSS.

Project 4:

Project Title :Honeywell ACS RAS Project

Duration : Nov 2007 – DEC 2008

Role : Team Member

Technical Environment : Oracle 8i, 10g, SQL, PL/SQL, Report6i

Oracle Apps Modules (OM, PO)

About the Project:

This is a Development and Enhancement project. This Project was involved in developing and enhancing PL/SQL packages, Oracle reports for Honeywell Automation and Control Solutions.

Contributions:

Identifying the basic requirement for the project.

Developing new programs and reports as per the requirement.

Modifying existing PL/SQL programs and Reports.

Prepare unit test plan document.

Performed role of CTL and uploaded the latest codes to central repository.

Project 5:

Project Title : Unisys Support Project

Duration : Aug’2007 – Oct’2007

Role : Team Member

Technical Environment : Oracle 8i, 10g, SQL, PL/SQL, Report 6i,

Oracle Apps Modules (OM, iStore)

About the Project:

This is a Support project. This Project was involved in Production sup

port of PL/SQL packages, Oracle reports for Unisys Solutions.

Contributions:

Identifying the basic requirement for the project.

Modifying existing PL/SQL programs and Reports to resolve the bugs.

Prepare unit test plan document.

Involved in preparation of documents MD70 for each issue.

Involved in providing workarounds and permanent fix for production support issues.

Version controlling and code preservation using PVCS.

Trainings Undergone:

XML Publisher Reports

OAF

Oracle Incentive Compensation Module certified

Anaplan certified

Oracle Forms Basic/Forms Personalization.

Business Knowledge and ERP Functional Training.

Recognition:

Silver Award – Has been recognized with Dell Silver Award for outstanding contribution in delivering project with 95% payout system.

Bronze Award - Has been recognized with Dell Bronze Award for being excellent team player and production support.

Contact this candidate