SUMMARY:

• 8+ years of experience as Oracle Applications IT Consultant, worked mainly on Oracle EBS R12, Oracle Cloud Financial Modules in various Support and enhancements projects.
• Good Understating on Record to Report (R2R), Procure to Pay(P2P), Order to Cash (OTC) Processes in Oracle ERP.
• Proficient in Oracle SQL, PL/SQL, Reports.
• Expertise in developing RICE components like Reports, Interfaces, Conversions, Extensions and Workflow.
• Used various Oracle Open Interfaces to interface the data in to oracle applications system from various legacy systems.
• Extensive experience in Developing Custom Programs using PL/SQL.
• Hands on experience in understanding Oracle supplied TRM’s and well versed in understanding visual linking of the tables of TRM.
• Hands on experience in creating and following Service Request (SR) for standard issues for Oracle Support.
• Experienced in preparing Technical Solution design documents using Application Implementation Methodology (AIM) Templates.
• Experienced in writing ad - hoc queries to analyze underlying data for inconsistencies and integrity issues to find data issues.
• Experience in Using Perforce as a Version Control System and Kintana for migrations.
• Strong communication skills with ability to manage expectations of Business and IT users. Possess good organizational, analytical and problem-solving skill.

KNOWLEDGE:

Technologies: Oracle SQL, PLSQL, Oracle Applications Relese12, Reports (10g/9i/6i), Toad, SQL Navigator, XML Publisher Reports, Oracle Workflow, HP PPM (Kintana), Perforce, Zendesk, HP ALM and Service Now.

Functional Expertise: Oracle Cloud Financials (12.1.2), General Ledger (GL), Cash Management (CM), Accounts Receivable (AR), Accounts Payable (AP), Order Management (OM), AOL, Sysadmin.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Consultant

Responsibilities:

• Involved in gathering Business requirements, Fit/Gap Analysis, Design, development, Testing and deployment phases.
• Customizations and development of the Interfaces to import the Journals data from Legacy systems to Oracle Applications R12.
• Created various new Primary and Secondary Ledgers, Legal Entities using Accounting Setup Manager as per the business requirements.
• Setup new responsibilities, Data Access sets, Ledger Sets to segregate the access for different roles.
• Involved in Analyzing the Business Requirements (BR100), Functional Specifications (MD50) and Prepared the Technical Solutions (MD70).
• Developed Various Custom programs in GL modules.
• Developed various Reports as per business requirement.
• Developed various SQL Loader Control files to load the data from Flat files(.CSV) to custom staging tables.
• Designed various Technical Design documents (MD70) using AIM Methodology.
• Created various FNDLOAD scripts to migrate the AOL Objects like Concurrent Programs,Valusets, lookups etc.
• Coordinated with QA Testing team to perform Functional and SIT Testing.
• Coordinated with Business users to perform UAT.
• Worked with DBA and RTP Team for various PROD Cutover and Go Live.
• Used Perforce tool as version control, Kintana tool for migration and ServiceNow for Change Management.
• Used HP ALM as Defects Management tool

Technologies: General Ledger (GL), Cash Management (CM), Accounts Receivables (AR), Order Manager(OM), Shipping, Pricing, Service Contracts(OKS), AOL, System Administration Modules, SQL, PL/SQL, Forms, Reports 10g, XML Publisher, SQL Loader, TOAD, WinScp, Putty, Perforce, Kintana

Confidential, San Francisco

Oracle Cloud Support Consultant

Responsibilities:

• Responsible for Supporting Oracle Cloud Financials in R2R Track, Mainly GL, CM.
• Used Zendesk as tool for to track the Incidents for Production Issues and support.
• Handled various Production Issues in the Financial Modules like GL, CM.
• Interacting with Various Business Stakeholders to understand the PROD Issues and provided the solutions to the issues.
• Created Service Requests (SR) for standard issues and Worked with Oracle Support to resolve the Standard Oracle Bugs.
• Created various new Ledgers, Legal Entities using Accounting Setup Manager as per the business requirements.
• Actively involved in Period End and Quarter End processes.
• Responsible for COA Maintenance and Providing Access to the New Users.
• Performed various Functional and SIT testing for the enhancements.

Technologies: Oracle Cloud Financials(12.1.2),General Ledger (GL), Cash Management (CM), AOL, System Administration Modules, SQL, PL/SQL, BI Publisher, Zendesk.

Confidential

Sr.IT Applications Specialist

Responsibilities:

• Involved in gathering Business requirements, Fit/Gap Analysis, Design, development, Testing and deployment phases.
• Working on Confidential Integration project as Techno Functional Consultant
• Customized and developed the Interfaces to import the Journals data from Legacy systems to Oracle Applications R12.
• Worked on Cash Management Reconciliation Open Interface to interface receipts from Legacy system to Oracle CM for reconciliation.
• Created various new Ledgers, Legal Entities using Accounting Setup Manager as per the business requirements.
• Involved in Analyzing the Business Requirements (BR100), Functional Specifications (MD50) and Prepared the Technical Solutions (MD70).
• Developed Various Custom programs in Finance modules.
• Developed various Reports as per business requirement.
• Worked on Forms Personalization to control the user to submit journals for approval without supporting documents in Oracle and also to validate the Journals data.
• Designed various Technical Design documents (MD70) using AIM Methodology.
• Create various FNDLOAD scripts to migrate the AOL Objects like Concurrent Programs,Valusets, lookups etc
• Coordinating with QA Testing team to perform Functional and SIT testing
• Coordinating with Business users to perform UAT
• Used Perforce tool as version control and Kintana tool for migration.
• Used HP ALM as Defects Management tool
• Used Service Now to create CHG requests for the business requirement

Technologies: General Ledger (GL), Cash Management (CM), Accounts Receivables (AR), Order Manager(OM),Shipping,Pricing,Service Contracts(OKS),AOL, System Administration Modules, SQL, PL/SQL, Forms, Reports 10g, XML Publisher, SQL Loader, TOAD, WinScp, Putty, Perforce, Kintana

Confidential

Sr.ERP Consultant

Responsibilities:

• Worked in L2 Support team in the Post Go-Live Phase.
• Handled various Production Issues in the Financial Modules like Gl,CM,AR,AP.
• Used HP ALM as tool for to track the Incidents, Change Request for Production Issues and support.
• Actively involved in Period End and Quarter End processes.
• Developed various data fixes to resolve the issues.
• Created Service Requests (SR) for standard issues with Oracle Support.
• Experienced in writing ad-hoc queries to analyze underlying data for inconsistencies and integrity issues to find data issues.
• Worked closely with Business Teams and Functional Team to work on various PROD issues.
• Conducted Meetings with Offshore team to hand off/discuss the issues on daily basis.
• Worked with Enhancements team to get KT for the enhancements.
• Involved in Analysis, Unit Testing, and UAT Phases for production issues.
• Performed Unit Testing and written Test Scripts

Technologies: Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Cash Management,AOL, System Administration Modules, SQL, PL/SQL, Reports 10g,XML Publisher, SQL Loader, TOAD, WinScp, Putty,Perforce,Kintana.

Confidential

Responsibilities:

• Involved in Analysis, Design, Unit Testing, UAT,SIT Phases
• Worked in Enhancements and Support Team.
• Developed various custom Interfaces/extensions/XML reports.
• Developed the Monthly Aging Report by Collector and by Branch Of Owner to find out the Balances for the Customer Monthly Wise
• Developed custom Reports like AR Invoice Print Status Report, AR Claim Notification Report, AR Past Due Letter Report, AR Charge back Letter Report, GL Account Analysis Reports etc
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location.
• Customization of Interfaces in GL,AR and CM Modules by writing Pl/SQL programs
• Developed Various SQL * Loader Control Files for uploading Data from Flat Files to oracle Data Base Tables.
• Performed Unit Testing and written Test Scripts
• Written Technical Solution documents for reports, interfaces, data conversions and application extensions.

Technologies: Accounts Receivables (AR), Accounts Payables(AP), General Ledger(GL), AOL, System Administration Modules, SQL,PL/SQL, Reports 6i,Sql*Loader, TOAD and Unix.