SUMMARY

• 9+ Years of experience as Oracle Application Technical Developer in implementation, upgrade and customization ofOracle e - Business Suite Applications(R12, 11i). This includes Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Oracle EBS
• Domain expertise as Technical Consultant in Supply Chain Management(SCM), Customer Relationship Management (CRM), Financial Management and HRMS.
• Supply Chain Management - Purchasing (PO), Inventory (INV) and Order Management (OM)
• Financials - Receivables (AR), Payables (AP)
• HRMS - Time and Labor
• CRM - Field Service, Spares Management and Service Contracts
• CRM Foundation - Universal Work Queue, Resource Management, Tasks, Notes, Calendar and Territory Management
• Good knowledge in Procure To Pay (P2P) and Order To Cash (O2C) cycles and Supply Chain business flows.
• Good knowledge in Trading Community Architecture (TCA)
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Excellent technical development skills in RICEW components (Reports (6i, 10g), Interfaces, Conversions, Extensions and Workflows).
• Proficient in development ofinterfacesandconversionprograms to integrate Oracle Applications modules to import data from various sources into Oracle Applications usingPL/SQL, SQL*Loader.
• Excellent knowledge of System Administration, Oracle APIs and Open Interfaces
• Used Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development
• Expertise on designing and implementingOracle AlertsandLookups.
• Hands on experience with Oracle Discoverer which includes report development, Discoverer Administration
• Experience in creating XML Publisher (BI Publisher) reports and using various templates to publish the reports as per user requirements
• Experience incustomizing oracle workflowsbased on the business requirement.
• Proficiency in writing PL/SQL Stored Procedures, Functions, Packages, Cursors, ref cursors, Database Triggers, data types, objects, tables and SQL * Loader scripts, UNIX Shell Scripts
• Experience in Project go-live and post-implementation support
• Good experience in AIM methodology for implementing Oracle Applications. Familiar with all the Standard Documents (MD50, MD70, MD120, CV40, CV60)
• Interacted with users, fixed the bugs, and developed test plans for daily production support.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.

TECHNICAL SKILLS

ERP: Oracle Applications EBS 11i, R12

GUI: D2K (Forms 6i/9i/10g/11g, Reports 6i/9i/10g/11g)

Tools: Used: SQL * Plus, SQL* Loader, TOAD, Discoverer and XML Publisher

Other Tools: Oracle Workflow builder, Jdeveloper, APEX, OAF

Languages: SQL, PL/SQL

Database: Oracle 8i, 9i, 10g, 11g

Operating Systems: Windows, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior IT Consultant

Environment: Oracle Applications (EBS) R12 (12.1.3), HRMS Time and Labor.

Responsibilities:

• Responsible for developing and customizing time and labor process.
• Responsible to manage the flows check-in/check-out, absences, day approval and payroll close
• Need to create new processes or enhance the existing functionality based on the requirement
• Create and debug pl/sql Procedures, Functions, Packages and Triggers.
• Develop custom Forms and Reports
• Fixing issues with existing forms and reports
• Testing the fixes in development environment and progress the same to production
• Prepare Technical and QA documents.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Closely worked with business users to gather the requirements

Confidential, Princeton, NJ

Senior IT Consultant

Environment: Oracle Applications (EBS) R12 (12.1.3), Order Management, AR.

Responsibilities:

• Oracle Apps Technical Consultant fordevelopment and supportproject.
• Responsible to support the flow from order creation to Invoice (OM → AR)
• Monitoring and debugging daily issues faced by business users.
• Created couple of discoverer reports to analyze invoices by cost center and products.

Confidential, Redwood City, CA

Senior IT Consultant

Environment: Oracle Applications (EBS) R12 (12.1.3), Installed Base, Service Contracts, Order Management, AR and AP

Responsibilities:

• Oracle Apps Technical Consultant fordevelopment and supportproject.
• Responsible to support the flow from order creation to Contract maintenance (OM → IB → Service Contract -> AR)
• Involved in creation of custom flow between Fusion CRM and Service contracts which flows through opportunity, web quote, OM, IB, OKS and AR.
• Customized couple of OAF pages like Item Instance search page, Service Contract Admin Workbench.
• Customized contract process workflow (OKSKPRCS) to Auto Book/Auto Submit low dollar contracts
• Worked on solution for Auto Renew contracts which will avoid delays in approval process based on business requirements.
• Customized contract approval workflow (MISOKCA1) to export screening contract before approval/activation
• Customized contract approval workflow (MISOKCA1) to check credit limit of customer before contract approval/activation.
• Involved in IB/OKS setups and testing for new operating unit implementations for countries Kenya, Qatar and Macau.
• Developed a process to mark contracts as Fail to Pay based on paid amount and balance amounts.
• Developed custom solution to display user name in execution history for manually published contracts
• Created Pl/SQL report to notify higher management regarding contracts Billing/Invoicing issues on daily basis.
• Closely worked with users to understand business needs and objectives.
• Fixed various IB interface issues in which Instance not created after order line closure
• Fixed contract renewal issues and developed report for contracts not renewed
• Fixed issues with contracts stuck in approval process
• Worked on contract billing and invoicing related issues. Actively participated in creating report which will notify billing/invoicing issues on daily basis.
• Worked on contract termination issues.
• Designed/developed tables, views, indexes, stored procedures and functions using SQL and PL/SQL.
• Registered theConcurrent Programs, Forms, Reports and Requests Sets inAOLand System Administration.
• Worked in Oracle backend objects like:Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.

Confidential

Senior IT Consultant

Environment: Oracle Applications (EBS) R12 (12.1.3), Field Service, Spares Management, Order Management, Territory Management, AR and AP

Responsibilities:

• Oracle Apps Technical Consultant fordevelopment and supportproject.
• Involved in Field Service and Spare Management implementation and post production support
• Responsible to support the flow from Service Request creation - Close (FS -> Spares -> OM → AR)
• Handled Field Service related part in B2B integration between MOS (My Oracle Support where actual SR’s and Tasks will be created) and Field Service Module.
• Involved in B2B integration for inventory sync for FS transactions with DHL which is third party actually maintains Inventory.
• Customized couple of OAF pages like Parts requirement and debrief pages.
• Customized standard field service task notification workflow (CSFALERT) to send email notification and SMS to task assignee.
• Created Jeopardy process to update task statuses which will help dispatches to follow up on tasks progress
• Created program to auto close parts only tasks on inventory transactions completion
• Created report for labor debrief report
• Created report to extract resource shifts, skills and territories
• Created to program to handle the issues with status mismatch of task and assignment
• Worked Day Light Saving change issues
• Worked on issues with arts requirement and orders creation issues from tasks
• Developed Auto push process which will create auto orders to move Good/Bad items between different warehouse tiers.
• Created custom program to handle issues with time zone in Planners desktop
• Created custom program to Geocode locations of IB instances which will help in calculating distance to nearest warehouse
• Worked on Back Order process which will create auto orders to fulfill back orders
• Fixed various issues with Dispatch Center
• Worked with PD to resolve issues with Gantt Chart
• Fixed different issues with Field Service Technician Portal
• Developed program to fix issues territory organizations

Confidential

Senior IT Consultant

Environment: Oracle Applications (EBS) 11i, Inventory, OM, AR, AP, IB, Field Service and Service Contracts Forms 6i, Reports 6i, XML publisher

Responsibilities:

• Oracle Apps Technical Consultant fordevelopment and supportproject.
• Involved in Design Reviews, Code Reviews, Coding, and Testing. Involved in the OracleAIMmethodology throughout the project.
• Fixed issues with service contract details report
• Worked on custom pick slip report
• Worked on enhancement related to pack slip report
• Created PL/SQL extract report to extract invoice details
• Worked on issues with print invoice report
• Created PL/SQL extract report to extract closed contracts
• Created discoverer report for in transit inventory details
• Fixed issues with discoverer Loss and Gain report
• Used zoom functionality to open contract details from task form.
• Fixed issue with suppress credit check box while terminating the contract
• Worked on development of supplier change history report
• Fixed issues with Service Contracts meter billing report.
• Created new report extract details related to government customers.
• Fixed issues with dispatch center
• Worked on task debrief related issues
• Created and maintained Unscheduled tasks report with business requested fields
• Created process to release credit hold on sales orders created from Field Service.
• Fixed issues with Service Request Zoom form
• PreparedMD70,MD120using AIM Methodology.
• Worked in Oracle backend objects like:Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.

Confidential

IT Consultant

Environment: Oracle application (EBS) 11.5.10, AR, QP Reports 6i, XML publisher

Responsibilities:

• Prepared User Requirements document (URD) forData Migrationfrom legacy to Oracle Apps.
• Designed custom tables to hold AR data from legacy system
• Created programs to load AR data into custom tables from Excel sheets extracted from legacy systems using SQL Loader
• Developed validation packages to validate the data in custom tables
• Designed and developedAR Invoiceinterfaceimport program which will load data from custom tables to AR interface base tables
• Loaded data in to AR interface tables using Auto Invoice program
• Designed custom tables to hold Price Lists data from legacy system
• Created programs to load Price List data into custom tables from Excel sheets extracted from legacy systems using SQL Loader
• Developed validation packages to validate the data in custom tables
• Designed and developedPrice Listinterfaceimport program which will load data from custom tables to AR interface base tables
• Loaded data in to Price Lists tables
• Created custom pick slip Report using XML Publisher.
• Designed Technical and Installation documents.
• Documented all theconversionsaccording to the AIM documentation standards.