OBJECTIVE:

To work with smart in a technically competitive and motivated Information Technology firm involving technical development of ERP projects where I can be an asset to the company’s growth by exercising my skills, which includes Research, Design, Development and Support where I can exercise my existing skill set, gather wide range of new skills. To put my abilities to the zenith towards achieving the organization’s values and goals and to see myself as a mature and thorough bred professional in the industry.

PROFESSIONAL SUMMARY:

• Having 9 Years of IT experience in ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing, Supporting/Maintenance and Migrating / Up gradation of Oracle Applications E - business Suite r12& 11i. These includes Analysis, Customizations, Design, Development and Implementation for applications based on Relational DBMS and in the field of Oracle e-business Suite and customer oriented, multitask professional with excellent analytical and logical skills possesses.
• Having excellent experience in development & maintenance of Oracle Applications r12& 11i.
• Good Technical skills in developing RICE Components in the domain of Oracle Applications E-Business Suite.
• Highly conversant with various modules of Oracle Applications Release r12 & 11i (ERP & CRM).
• Areas of expertise technical developments and having functional knowledge in INV, PO, AP, OM, AR, GL, WIP, BOM, Trading Community Architecture (TCA), Installable (CSI), Service Contracts (OKS) and Service Requests (CSF& CSD) of ERP modules.
• Having 4 full life cycle implementation experience with exposure to implementation methodologies viz. AIM 3.0.
• Having good knowledge on MD and CV documents for various components, good experience in development of functional/technical design documents.
• Experience in Implementation, Migration and Support Projects.
• Having excellent work experience with Oracle Business Intelligence Standard Edition Oracle Discoverer 10g and having knowledge on generating XML reports.
• Rich experience in registration/migration of Forms, Reports, PLSQL programs, Oracle Discoverer and XML Publisher Reports.
• Good Experience in registration of Menus, Functions, Value Sets and Concurrent programs.
• Having good knowledge on form personalization and customizing the forms using CUSTOM.pll.
• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
• Experienced in understanding of rules, functions and logic involved in any business and accordingly mapping them to Oracle Applications.
• Having Knowledge on Dataware House Concepts (Informatica, OWB & Reporting tools like OBIEE).
• Having excellent experience in the areas of D2K(Forms 6i&10g, Reports 6i&10g) based applications using Oracle 9i, 10g& 11g(SQL&PLSQL) Technologies.
• Having good experience in development and customization of Work Flow (WF), Oracle Application Framework (OAF) and Application Development Framework (ADF)according to business needs.
• Having knowledge on development of Business Process Engineering Language (BPEL) using Service Oriented Architecture (SOA).
• Well conversant in creation of database objects: tables, constraints, packages, stored procedures, functions, triggers and Indexes using Oracle tools to bring business requirements to completion.
• Involved in performance tuning of several objects using hints and several other processes, analyzing Tkprof files and Explain Plan.
• Having good expertise in Preparing Technical Documents, Unit Test Scripts (UTS), Code Review Checklist (CRC), Test Plan and Test Results documents based on the user/customer requirements.
• Having Experience on Oracle Fusion Middleware 11g with ADF and JDeveloper.
• Having Experience on perform documentation adhere to the JSOX & SOP.
• Participate in Class Room Prototype (CRP) meetings for gap analysis.
• Good thorough understanding of system development process, from initial planning.
• Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the technical issues.
• Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming, and performs testing and debugging of applications.
• Analytical and problem solving skills with ability to work independently when needed.
• As a member of the software engineering division, we will develop software according to provided design specifications. Analyze system specifications and existing business processes and information systems.
• Build enhancements and resolve bugs. Build and execute unit tests and unit test plans.
• Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management and team building.
• Team Player with Excellent Technical, Communication, Interpersonal skills and Leadership abilities.
• Adopting new technologies, Very flexible and perform tasks are ad-hoc basis.
• Work involves some problem solving with assistance and guidance in understanding and applying company policies and processes. Gaining competence in own area and acquiring a higher level understanding of role, processes and procedures.
• An accomplished and fluent communicator with strong investigation, problem-solving and decision-making skills combined with a pragmatic approach and sound business acumen and having a good understanding of Business Requirement gathering, Business Process Flow, Business Process Modeling, Scope identification and requirements gathering via meetings, interviews, interface analysis and Research

SKILLS SUMMARY:

OS/Environment: Ms-Dos, Windows and UNIX.

RDBMS: Oracle 9i, 10g & 11g.

Oracle E-Biz Suite (EBS): Oracle Applicationsr12& 11i.

Manufacturing, DistributionSCM and Financials: Inventory (INV),Work In Progress (WIP), Bills of Materials (BOM), Purchasing (PO), Accounts Payables (AP), Order Management(OM/OE/ONT), Accounts Receivables(AR), Warehouse Management (WMS), Shipping Execution (WSH), General Ledger (GL), Sys. Admin and Appl. Dev.

CRM Modules: Installed Base (CSI), Service Contracts/Contracts Core (OKS/OKC), Service Requests (Field Service (CSF), Depot Repair (CSD) and Tele Services)/Customer Support/Customer Care (CS/CSS/CSC), CRM Foundation (JTF), Trading Community Architecture (TCA/HZ).

Languages/Frameworks: SQL, PL/SQL, JAVA, OAF, ADF, C, C++, and SQL Server.

Middleware: Oracle Fusion 11g (ADF & SOA(BPEL))

Front-end Tools (GUI): Forms 6i&10g, Reports6i&10g, Jdeveloper10g, Work Flow Builder.

Business Intelligence(BI): Oracle Discoverer 10g, XML Publisher and OBIEE.

Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*PLUS, SQL*LOADER, Winscp3, Putty, FTP, WSFTP, JIRA, Lotus Notes, FileZilla, MS-Office, Open Office & SQL Mgmt Studio.

Key Competencies& Skills: Client relations, Business Analysis, Product Mapping and Consultancy, Data Migration Mapping, Test planning, UAT & Testing.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Applications Consultant

Software: Oracle Applications 12.1.3, Oracle 11g(SQL & PLSQL), Developer 2000,Work Flow, OAF, SOA & BPEL.

Solutions: INV, PO, AP, OM, AR, GL and CRM (Install Base, Service Contracts & Service Requests).

Responsibilities:

• Senior Oracle Application consultant and Hands-on Team Lead and Supporting to Offsite.
• Gathering and analyzing functional requirements and Interacting with team and business users to clear the Requirements from different OpCos (Countries).
• Supporting to different countries (CN, HK, KR, MY, PH, SG, TH, TW, VN, AU and NZ).
• Supporting to FX-AU, FX-NZ implementations.
• Identifying functional and technical gaps.
• Development of technical design and installation documents.
• Involved in code review, code migration and code test.
• Involved to support work flows and frame work.
• Documentation for Unit Test Scripts, Test Plans, and Test Results.
• Involved to support business users in live.
• Designing interfaces and integrations between modules in Oracle EBS.
• Code Reviews of Vendor,
• Worked on Custom API’s in PL/SQL (Business Logic) for Change Requests.
• Enhancement on Forms, Performance tuning on Forms, Reports and PL/SQL.
• Developed the programs for SOA to get the readings from Machines.
• Technical analysis of existing RICE components of existing components functionality.
• Customization and Development of forms, workflows and worked on Forms Personalization.
• Worked on Oracle Reports & Discoverer reports to support based on user requirement.
• Development of custom interfaces using Oracle standard TCA APIs including DQM rules.
• Fully involved in CRM conversions for Migration & developed custom packages for migration.
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs.
• Procure to Pay (P2P) and Order to Cash (O2C) Validations.
• Developed program to import Orders and Customers to Oracle through Oracle API Order & Customer Import.
• Involved in Journal Import with validations.
• Creating and Registration of Procedures, Concurrent programs and Reports through AOL.

Confidential

Oracle Applications Consultant and Hands on Team Lead

Software: Oracle Applications 11.5.10, Oracle 9i (SQL & PLSQL), Oracle Developer 2000, Work Flow& OAF.

Solutions: INV, PO, AP, OM, AR, GL and CRM (Install Base, Service Contracts& Service Requests).

Responsibilities:

• Application consultant and Hands-on Team Lead.
• Gathering and analyzing functional requirements and Interacting with team and business users to clear the requirements.
• Identifying functional and technical gaps.
• Development of technical design and installation documents.
• Involved in code review, code migration and code test.
• Documentation for Unit Test Scripts, Test Plans, and Test Results.
• Involved fully on migration and production support.
• Involved in the post go-live support.
• Designing interfaces and integrations between modules in Oracle EBS.
• Worked on Custom API’s in PL/SQL (Business Logic).
• Technical analysis of existing RICE components of existing components functionality.
• Customization and Development of forms and workflows and worked on Forms Personalization.
• Worked on Oracle Reports to support based on user requirement.
• Development of custom interfaces using Oracle standard TCA APIs including DQM rules.
• Fully involved in developed custom programs to support to user requirement in both CRM and SCM.
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs.
• Procure to Pay (P2P) and Order to Cash (O2C) Validations and Form Personalization.
• Creating and Registration of Procedures, Concurrent programs and Reports through AOL.
• Support to modify Work Flows and Oracle Application Framework (OAF) based on business requirements.

Confidential

Senior Consultant and Hands on Team Lead.

Software: Oracle Applications 11.5.9, Oracle 9i (SQL & PLSQL), Oracle Developer 2000 and ADF.

Solutions: CRM (Install Base, Service Contracts, Service Requests& Contact Centre).

Responsibilities:

• Hands-on Team Lead.
• Gathering and analyzing user requirements and interacting with onsite team and business users.
• Day to day status track of issue logs.
• Involved in the project meetings to define/direct project goals and objectives.
• Architecting and developing customer specific solutions.
• Prepared Technical Documents (MD.070, MD.120) & Unit Test cases.
• Design, Code, Test and code review Preparation of test scenarios/cases for all technical components bases on functional designs.
• Involved in the post go-live support.
• Developing PL/SQL code to obtain the required functionality.
• Worked on Custom API’s in PL/SQL (Business Logic).
• Involved in setup and implementation of Service Contracts depending on functional setup Changes/enhancements.
• Customized and developed the forms and reports based on requirements.
• Creating and Registration of concurrent programs, forms and reports through AOL.
• Quality Control and Quality Assurance.
• Responsible for new development and change requests.
• Customization and Development of forms and workflows.

Confidential

Senior Consultant and Hands on Team Lead

Software: Oracle Applications 11.5.9, Oracle 9i (SQL & PLSQL), Oracle Developer 2000, Work Flow and OAF.

Solutions: INV, OM, AR and GL.

Responsibilities:

• Gathering functional requirements through interacting with team and business users.
• Prepared Technical Documents, Unit Test Scripts. (MD.070, MD.120).
• Technical analysis of existing RICE components of existing components functionality.
• Design, Code, Test and code review.
• Preparation of test scenarios/cases for all technical components bases on functional designs.
• Involved in the post go-live support.
• Custom API’s in PL/SQL (Business Logic).
• Order to Cash (O2C) Validations.
• Customization and Development of forms and workflows.
• Involved in Developing and deploying Oracle reports& Discoverer Reports10g.
• Registered Procedures, Forms and Reports in Oracle Apps.

Confidential

Software Engineer

Software: Oracle Applications 11.5.9, Oracle 9i (SQL & PLSQL), Oracle Developer 2000.

Solutions: INV, PO, AP, OM, AR and GL.

Responsibilities:

• Gathering and analyzing functional requirements.
• Interacting with onsite team and business users.
• Architecting and developing customer specific solutions.
• Prepared Technical Documents, Unit Test Scripts.
• Involved in Journal Import with validations.
• Technical analysis of existing RICE components of existing components functionality.
• Design, Code, Test and code review Preparation of test scenarios/cases for all technical components bases on functional designs.
• Quality Control and Quality Assurance.
• Involved in the post go-live support.
• PO conversions using Interface.
• Worked on Oracle Reports, Discoverer and XML Reports.
• Developed many PL/SQL blocks for the forms validation and to obtain the required functionality.
• Prepared Technical Documents, Unit Test Scripts. (MD.070, MD.120).
• Procure to Pay (P2P) and Order to Cash (O2C) Validations.
• Creating and Registration of concurrent programs, forms and reports through AOL.
• Involved to Developing and deploying Oracle & Discoverer Reports10g.
• PO Requisition, Open PO and PO receipt conversions using Interface.
• Custom report to list PO-s waiting for Approval (related to PO Approvals) for 'X' days.
• Custom Report on PO-s that are cancelled after 'X' days of creation.
• Purchase Orders pending report showing how many orders were pending beyond their promised date (0-7 days,