SUMMARY:

• Astute, versatile and result oriented Professional with total 8 years of IT experience in Software and Application development including 7+ years of relevant experience in Oracle E - Business Suite 11i/R12 Applications as Oracle Apps Consultant.
• Lead/ managed various Implementation, Migration, Customization and Product Support projects.Repeatedly recognized for Project Planning and flawless execution by providing End-to-End solutions right from
• Building Interfaces/ Conversions for Importing/ Migrating the Legacy data (MDM) into Oracle E-Biz
• Customizing and Implementation of Various Oracle Application Modules OM/ AR/ PO/ AP/ GL
• Form Personalization s/ Building New Reports/ CEMLI - Packages, Procedures/ Functions
• Performing Business transactions in Oracle ERP using O2C and P2P Cycles
• Developed an Online Archiving Data Base solution to handle 15+ years old Financial data for legal purposes
• Oracle Application Techno Functional Consultant with 6+ years in Oracle Application in the area of Supply chain management (SCM) and Oracle Financials.
• 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.
• Good understanding of accounting principles and financial processes.

TECHNICAL SPECIALTIES:

Oracle ERP Modules: Oracle R12/ 11i E-Biz Suite PO, OM, INV, TCA, AP, AR and FA 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 Confidential (ILM), Oracle Workflow Builder

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

EMPLOYMENT CHRONICLE:

Confidential, Louisville

Oracle Apps SCM Techno Functional Consultant

Responsibilities:

• Responsible for Business Requirement Gathering
• Responsible to Functional design of Business Objects
• Responsible for Technical component design (MD100)
• Responsible for Data Mapping (CV40)
• Draft the Data Migration Plans - Legacy to Oracle
• 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 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, Columbus, Ohio

Oracle SCM 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, Bowling green, KY

Oracle Apps 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, Atlanta, GA

Oracle Apps SCM 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

Tools: Oracle APPS 11.5, UNIX - Putty and Winscp, IBM Tools - CoZ SFTP

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