SUMMARY

• Over 10+ years of IT experience as Oracle Developer & Oracle ERP packages in which Oracle Application Techno Functional Consultant with almost 7 years in Oracle Application in the area of Supply chain management (SCM) and Oracle Financials.
• 6 ERP Projects - 2 Implementation Projects/ 2 Enhancements and 2 Production Support (FAST Team).
• Good working knowledge on Multi-Org and TCA architecture.
• Experience in requirements gathering, gap analysis, business process redesign and mapping, testing and user training, documentation of activities, processes, test scripts and client interaction.
• Ability to understand business goals and implement best practices to improve the efficiency and productivity of supply chain.
• Experienced in customizing, developing and configuring Oracle Applications in the modules of Supply Chain and Manufacturing.
• Knowledgeable in Procure to Pay (P2P) and Order to Cash (O2C) business cycles
• Sound communication skills, result oriented, open to learning new technologies and a good team player.
• Stronganalytical, diagnosticandtroubleshootingskills and ability to work in a fast-paced and team-oriented environment
• Experience in the Implementation and Customization of Purchase Order (PO), Account Payable (AP), Account Receivables (AR), Order Management (OM), General ledger (GL), Order to Cash and System Administrator.
• Experienced in various full life cycle implementations, production support, and upgrading Oracle Applications in 11i and R12.
• Proficient in the E-Business Suite cycles of Order to Cash (O2C), Procure to Pay (P2P), Supply Chain Management (SCM).
• Involved in Month/Quarter/ Year End Closing actives for AP, AR Modules.
• Very good experience in preparing functional and technical design MD050, MD070 documents using AIM Methodology.
• Expertise in creating messages, processes, functions and notification workflows and Customizing Workflows using Oracle Workflow Builder 2.6
• Good knowledge on oracle application views, Synonyms, base tables, XML reports and workflow used for troubleshooting and resolution of production issues.
• Functional responsibilitiesinclude:Requirements gathering, Functional gap analysis, Application design,
• Configuration, module setup, Building test cases, writing training guides, training end users, and production support
• Technical responsibilities include:interfacing the Modules, identifying functional and technical gaps, Estimating work, architecting system interfaces, designing custom solutions, programming, scheduling, producing and documentation and providing production support.
• Hands on experience in development and extension RICE components using SQL and PL/SQL
• Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and exposure to WF
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Worked in various projects involving migration, conversions and customization of Oracle Applications and also integration of Financials and Supply chain modules.
• Developed Interface Programs using SQL * Loader and PL/SQL procedures to load data into the interface
• Tables from legacy systems and writing validations before transferring data from temporary table to interface tables
• Experience in debugging PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, Shell scripting, Performance Tuning.
• Experience in debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Good experience in Forms Personalization.
• Expertise in using tools like TOAD, SQL Developer and SQL*Plus.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs,
• Creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications
• Experience in using Oracle Application Object Library (AOL) features including implementation of Flex fields (Implementing Cross Validation Rules, Security rules).
• Good knowledge and experience in Software Development Life Cycle (SDLC).
• Experience in enterprise level integration of legacy systems with Oracle System.
• Excellent knowledge of Flex fields, Multi-Org and Multi-Currency.
• Interacted with users, fixed the bugs, developed test Plans and provided daily support.
• Experience in debugging, UAT testing and deploying the applications designed and developed interactive
• GUI screens and reports using oracle forms/reports.
• Worked extensively on preparing AIM documents like MD020, MD060, MD070 and CV040s. Coordinated with the Development Team to identify product gaps by creating SRs and ERs to resolve various issues and well experienced in working.
• Excellent analytical skills, strong verbal and written communication skills.
• Experienced in working in a team environment.

TECHNICAL SKILLS

Oracle ERP Modules: Oracle R12/ 11i E-Biz Suite PO, OM, INV, TCA, AP and AR modules

Methodology: Application Implementation Methodology (AIM), Agile, SCRUM

GUI: Oracle Forms 10g/6i, Reports 10g/6i, XML Publisher

Data Migration Tools: ChainSYS AppLoad/ AppMigrate, More4Apps, Oracle Web ADI

Tools: Toad, SQL * Plus, SQL * Loader, SQL Developer, Putty, WinSCP Unix Shell Scripting

Data Archiving Tools: Informatica Life cycle management (ILM), Oracle Workflow Builder

Code Migrations: HP Project Portfolio Management, KINTANA, CVN, SVN

PROFESSIONAL EXPERIENCE

Confidential

Oracle ERP Consultant

Responsibilities:

• Develop business architecture using requirements such as scope, processes, alternatives, and risks.
• Designing Architecture for Seibel based Point Of Sale System integrating with Oracle Financial Suite
• Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Communicate client’s business requirements by constructing easy-to-understand data and process models.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Worked on the Configuration of the INV module including setting up of the Item Catalogs, Defining Catalogs, defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
• Worked closely with Client finance user team and Oracle finance consultant on issues like intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Delivered functional specifications for the new solution integration as a SME for Oracle EBS
• Capturing the Business Rules for IFTA and IRP accounting
• Defining Service based Items like Issue Drive License/ Titles/ Registration Permits/ OBL and developing logic to calculate the charge $ for each transaction
• Closely worked and coordinated with the technical teams to deliver the solutions as per the functional designs and customizations
• Implementing Purchase Order, Inventory, Account Receivables modules in First Phase
• Creating Inter-org transfer setups for Inventory application in Oracle R12
• Developed custom templates for the invoice reports by calling sub templates inXML/BIPublisher.
• Designed and developed customUSER APPROVAL WORKFLOWto meet the client application’s user creation and maintenance according to the business requirement.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Responsible for Business Requirement Gathering, Functional design of Business Objects and Technical component design (MD100)
• Responsible for Data Mapping (CV40)
• Draft the Data Migration Plans - Legacy to Oracle
• Developed and designed various reports using XML Publisher
• Setup Sourcing Rules and Load multiple Sourcing Rules through API
• Creation/ Updating of Price List Modifiers and Qualifiers
• Designed and developed all the setups and configurations for Inventory management.
• Customized Requisition Import Program
• Responsible for the technical design, program development, unit testing and migration of OM Sales Order Interface.
• Responsible for preparing procedures, functions, packages as per requirement. Involved in unit testing and acceptance testing.
• Configuring Purchasing Setups and PO Approvals
• Setup Approved Supplier Lists
• Oracle PO to AP Invoice Import and Payment
• Developed Employee Expense reports
• Gathered requirements and worked on the To-Be processes for inventory and purchasing modules.
• Worked on item conversions and prepared conversion documents (CV10, CV.040)
• Documented the training material, requirement gathering (RD20), setups (BR100) AS-IS, TO-BE (BP80) documents
• Coordinating closely with Technical development team, functional testing team for the smooth delivery of the component.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Guide offshore team on CEMLI Object development
• Migrate Data using Data Loaders like AppLoad
• Organizing client meetings
• Fixing the technical Issues encountered by the application users. Technical Issues include bug in coding the Reports, PL/SQL, Stored Procedures, interfaces and forms.
• Involved in Major and Minor Enhancements.
• Working with Oracle Product Support for getting support on Oracle standard components (Raised SR attended the SR call, done OWC Sessions in explaining the Issue)
• Involving in Wing to Wing testing activities

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Trouble shooting and resolving various day to day production issues including payment batch processing issues, check printing issues, Ledger (GL) and Sub Ledger period closing issues covering AP, AR, PO, OM; and inbound/outbound interface issues
• Developed custom wrapper to validate and import customer invoices, credit memos and debit memos into Oracle AR using Auto Invoice Import process
• Responsible for interacting with users, gathering and analyzing business/system requirements, design, development, unit testing and supporting through code lifecycle.
• Reduced processing times of SQL queries, night batch jobs by reviewing PL/SQL code and modifying database parameters
• Involved in R12 post production support and resolved various issues including but not limited to troubleshooting and resolving various day to day production issues as part of Oracle Payment processing, order processing, Expense report import and processing, AP invoice processing, create accounting, SLA drill down reports and sub ledgers and GL period closing
• Designed and developed a custom integration cycle to integrate Oracle Order system to third part inventory system
• Study of current business processes, future business flows and identification of gaps and provide business solutions in order to provide an integrated information system solution to meet the business needs of the company.
• Discussing project requirements, defining functional specifications and UI elements with the client, working as a mediator between the client and other team(s)
• Designing, developing, delivering best solution by using latest tools like Oracle PCG etc
• As an Onsite Co-coordinator am involved in Client meetings, presenting status reports and communicating project status to the client
• Responsible for code reviewing and testing the data fixes developed by Teams

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Involved in Month/Quarter/ Year End Closing for AP, AR Modules
• Developed Custom Oracle Alerts (both periodic and event based) as per business requirements.
• Resolved Critical Production Issues by debugging Reports, Packages, Work Flows, Alerts.
• Worked on solution design and setup of Purchasing & Order Management as per the client requirements and suggested business process changes.
• Involved in resolution of functional issues related to Oracle Manufacturing and distribution during implementation of modules
• Created functional design documents (MD.050) for customizing forms to address business requirements and to address the labeling requirements.
• Created new responsibilities request groups and defining the required system profile options
• Enabled Key Flex fields and Descriptive Flexfeilds.
• Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated information system solution to meet the business needs of the company.
• Training to the end users on the developed application.
• Responsible for code reviewing and testing the data fixes.
• Involved in Client meetings.
• Involved in AOL/FND tasks such as Value Set Creation & Defining Concurrent Programs etc
• Responsible for preparing procedures, functions, packages as per requirement. Involved in unit testing and acceptance testing.
• Scheduling and monitoring concurrent programs.
• Worked with Oracle Product Support for getting support on Oracle standard components (Raised SR attended the SR call, done OWC Sessions in explaining the Issue)
• Involved in the preparation of several documents like MD.070, MD.070, Setup and User training Docs.

Confidential

Oracle SCM Techno Functional Consultant

Responsibilities:

• Designed and developed a custom integration cycle to integrate Oracle Order system to third part inventory system
• Developed custom AR receipts processing API's by using Oracle standard receipt api's along with lock box implementation
• Created Materialized views to store data that is required for reports
• Worked on Setup Configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
• Adept in reviewing and analyzing the \'As-Is\' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Worked very extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of Oracle application E-business suite 11.5.10.All the above bases business logic was captured in OA Framework code.
• Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
• Worked in Parallel with the client is resolving the CRP 2 and Post go live Testing issues with offshore support.
• Co-ordinated with client through Concalls and WEBEX sessions to get the Requirements and also Coordinating with the Technical Team for fixing the Issues for proper Deliverables to the Client.
• Provided KT sessions to the Testing and the Technical Teams.

Confidential

Oracle Apps Consultant

Responsibilities:

• Imported sales orders using Order Import process from external system into Oracle OM.
• Involved in PL/SQL coding for data conversion to write transact, extract, validate and update procedure.
• Developed UNIX shell scripts to split the large volume data files into small files for parallel processing.
• Partitioned Tables and indexes for better performance of application
• Developed variety XML reports
• Coordinating with the Client by providing them Onshore Functional support on Oracle order Management, Shipping and Inventory modules.
• Coordinated activities with Testing and the Technical team to resolve daily reported Production issues. Facilitated discussions with end-users / managers to gather functional requirements on their issues.
• Assisting end users to resolve problems in carrying out their daily business activities in the above modules.
• Working with Oracle on SR management on high priority issues parallel.
• Preparing Training documents and presentations to assist Business users on newly released functionality in Oracle E-business suite.
• Co-ordinated on Production support issues.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Identifying existing FTP interfaces and respective servers
• Identify the Server Point of Contact (DBA) and get the basic details like OS, SFTP Feasibility, respective Dev and QA server details.
• Co-ordinate with TSG, GIS, Corporate, DBA teams to enable SFTP on all the servers, Generating and adding the keys to setup a password less SSH Connection.
• Co-ordinate with all Windows server support teams and helped them in installing and configuring SFTP
• Identifying FTP Concurrent Program’s - Converting the UNIX FTP scripts to SFTP.
• Created new Oracle Executables and Concurrent Programs based on business requirement.
• Performed Unit Testing Co-ordinate with FAST teams for Functional and UAT Testing
• Co-ordinate with Technical and FAST team’s and helped them in performing Functional testing in Development instances.
• Migrated SFTP scripts to Test instances and co-ordinate with Functional teams in UAT testing. Migration to Production Environment jsr
• Worked with DBA to migrate SFTP scripts to Production

Confidential

IT Consultant

Responsibilities:

• Involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation.
• SQL Script Coding to create the Development Database, Testing Database, Production Database, including Table spaces, added data files to table spaces, managed redo log files and control files, Rollback segments creation, Users, Synonyms, Roles, profiles, Privileges and changed init.ora file parameters.
• Created SQL*Loader scripts as a part of conversion process to load the legacy data from existing flat files into Oracle Application tables.
• Created PL/SQL packages, procedures and functions in TOAD necessary for validations before loading records into interface tables.
• Developed mapping documents to load purchase orders.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.