SUMMARY

• Oracle Applications Techno - Functional Consultant having around 13 years of IT domain experience in which 10 years for implementation of Oracle EBS applications technical development across teh supply chain management and financial domains.
• Area Of Expertise - Oracle Applications e-Business Suite Technical:
• Supply chain: Order Management, Service Contracts (OKS), Enterprise Asset Management(EAM), Purchasing, Inventory, BOM, Install Base, Fixed Assets, WIP, Procurement Contracts(OKC)
• Financials: General Ledger, Payables, Receivables, Costing, Project Accounting.
• Human Resources: Employee Maintenance, Oracle Advance Benefits.
• Worked extensively on data Conversion and migration to Oracle Applications using Oracle open interface approach or Oracle seeded API, writing functions, procedures, packages to validate legacy data, loading data into interface/staging tables, and handling teh errors.
• Thorough understanding of entire technical process involving Oracle Conversions including APIs, large scale extensions, Inbound and Outbound Interfaces and BI Publisher Reporting.
• Expertise in Design and development of Interfaces and Data Migration using SQL*Loader, Oracle open interfaces, procedures, interface tables, APIs and Control files
• Worked on RICE design, development and testing end to end solution for multiple client services.
• Configured Key accounting Flex Fields and Descriptive Flex Fields for various business requirement
• Extensively worked on Drop Shipment, Order to Cash and Procure to Pay functionalities
• Having good hands on experience on Procure to Pay and Order to Cash life cycles
• Experience in Oracle Purchasing Approval Workflows and Approval Management Engine (AME).
• Mentored and lead teh development team in past six years to achieve teh major mile stones for our clients especially in their critical business transformations in SCM and financial business areas.
• Have played key role in pre-implementation, implementation, and post-implementation scenario from onsite to meet teh end to end delivery.
• Extensively worked with Quality Analysis (QA) team to prepare use test cases and execution plan for critical testing phases like SIT, UAT and Performance Testing.
• SPOC for defect tracking and reporting.
• From onsite, played SCM track lead/lead developer role and cross-business implementation of Oracle Apps capturing AS-ISand TO-BE processes for various modules; handled data migration, UAT and GO-LIVE.
• Extensively worked on technical documentation for RICE developments as per AIM methodology.
• Designed custom data base design and integration to meet client back up strategy for their sun-setting ERP System.
• Involved in HRMS sustainment to help teh client to resolve teh critical defects and enhancements on priority.
• Having good communication, analytical and client interaction skills.
• Experience includes Application Object Library(AOL) activities like defining concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical or functional issues.

TECHNICAL SKILLS

ERP Product/Software: Oracle Applications e-Business Suite R12 and R11i:

Order Management/Service: Contracts Enterprise Asset Management (EAM) Purchasing and Procurement Contracts (OKC) Inventory Fixed Assets and Install base Bill Of Materials(BOM) and Work In Progress(WIP) Payables, Receivables and General Ledger

Programming Languages: PL/SQL, Forms 6i, Visual Basic, C, C++, JavaFoxPro, SQL, PL/SQL,SQL*Loader

EAI Integration tools: Oracle SOA Suite 10g(10.1.3.x (ESB & BPEL)), JDeveloper 10.1.3.x, JDeveloper 11.1.1.2

Reporting Tools: Oracle BI Publisher reports (XML Publisher), Discoverer and Reports 6i

Databases: Oracle 7.3, 8i and 10g, MS-Access

Other Tools: Informatica, DM Express, Data Loader, SQL Developer, TOAD, WinSCP 3.6.1

Operating Systems: Windows, Linux

Version Control Tools: Microsoft Visual Source Safe, Perforce, SVN

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Sr. Oracle Applications Analyst

Environment: Oracle Applications R12.1.3 (Order Management, Service Contracts and Install Base) Oracle 11g, BI Publisher, UNIX.

Responsibilities:

• Customized teh Oracle seeded pricing engine API to simulate teh quote/contract pricing for different sales channels like End Users, Resellers, Partners, etc.
• Developed Renewal Quote Document custom application to generate teh quote document and to send teh document to teh respective sales channel contacts.
• Designed and Implemented e-Mail bounce back program built in Java to supplement teh Renewal Quote Document.
• Developed Install Base Usage Counter recording interface program to import teh IB counters into Oracle. Worked with TIBCO and third party engineering systems to complete teh end to end integration design.
• Worked in service contracts business events to supplement teh IB usage provisioning.
• Worked in various reports using Oracle BI Publisher for Order Management
• Implemented customizations for order management and service contracts workflows.
• As it is scrum model implementation, closely worked with Business analyst and IT engineers to understand teh business requirement (AS-IS and TO-BE).
• Involved in INT-2 and UAT testing phase with Confidential global business users from EMEA and Asia Pacific.
• Prepared DS.140 Technical design document and me-90 Installation document for custom deliverables.
• Worked with Quality Control team to draft teh business test cases for teh deliverables and knowledge transfers on teh functionality of teh business requirement

Confidential, Palo Alto, CA

Sr. Oracle Applications Developer

Environment: Oracle Applications R11i (Oracle Receivables, Order Management, Service Contracts, Install Base, WIP, BOM and GL) Oracle 11g, BI Publisher, UNIX.

Responsibilities:

• Customized teh Oracle Receivables Pre-Processor program to meet teh Confidential SDP requirements.
• Extensively worked on Oracle Service contract, Order Management and Install Base integration for subscription products for respective Phases.
• Designed and Implemented custom EDI interface program to create recurring sales orders for direct customers and distributors from SDP to Oracle Order Management (Inbound interface)
• Worked on SKU Loader program to supplement teh sales order creation for both subscription and usage models.
• Designed and Implemented custom interface program to integrate teh direct customers invoice from SDP to Oracle Receivables(Inbound interface)
• Designed and Implemented custom interface program to integrate teh distributor/channel customers invoice from SDP to Oracle Receivables(Inbound interface)
• Worked in various reports using Oracle BI Publisher and Discoverer reports for Order Management and Oracle Receivables
• Implemented customizations for order management workflows
• Prepared MD.070 Technical design document and MD.0120 Installation document for custom deliverables.
• Worked with Cleverbridge (Third Party payment processing vendor) for design and integration for Pay-As-You-Go model outbound/inbound interfaces. This is 3 tier integration which integrates, SDP Platform, Cleverbridge system and Oracle Receivables.
• Involved with EAI team to design teh SOA Web Services and Informatica workflow for integrating teh SDP and Oracle Order Management.
• Involved in End to End design for SDP Platform to integrate SDP, Order Management and EBS databases.
• Worked closely with Business Analysts and cross functional team to freeze teh functional and technical design.
• Involved in all 9 Phases of development for SDP platform to meet teh demanding critical business requirements at each phase
• Worked with Quality Control team to draft teh business test cases for teh deliverables and knowledge transfers on teh functionality of teh business requirement
• Production support for Service contracts and trained teh end users
• 24/7 production support during GO-LIVE for all Phases.

Confidential, Houston, TX

SCM Technical Lead Developer

Environment: Oracle Applications R12 (Inventory, EAM, Purchasing, iProcurement, Procurement Contracts, Bill of Materials, WIP ) Oracle 11g, Reports 10g, BI Publisher, Oracle 11g, Unix

Responsibilities:

• Extensively worked in both master (Customers, Suppliers, Inventory Items, EAM Asset groups, EAM Asset Activity, EAM Asset Numbers, EAM Asset Attributes, EAM Maintenance Routings ) and transaction (On hand Inventory and Cost, Open Purchase Orders/Lines, PO Receipts) data conversions and interfaces.
• Design and developed condition code solution (RICE Extension) which is specific to Oil and Gas industry.
• Extensively worked on Oracle Purchasing workflows, Approval Management Engines (AME) and Forms Personalization.
• Lead teh offshore SCM technical team from onsite.
• Prepared teh development plan to meet teh client deliverables.
• Worked extensively on conversion, interface and extension development.
• Worked extensively with functional team and business team for project SIT, UAT testing and mock conversion phases.
• Interacted with SCM functional team, track leads and core business analysts for MD.050 sign off and to gather technical requirements in depth
• Coordination of RICEW design, development, testing and delivery with offshore team.
• Conducted review and audit on technical designs to ensure teh quality on client deliverables.
• Status update to key stake holders on daily/weekly basis regarding RICEW development and other risks associated.
• Managed RICEW development, delivery schedules and quality of deliverable.
• Interaction with functional person to understand teh client’s requirements and functional design document (MD050)
• Involved in Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
• Participated in teh design discussions of teh project, contributing to deliverables like to-be process flows.

Confidential, Houston, TX

Technical Lead Developer

Environment: Oracle Applications R12 (OM, EAM, AR, AP, FA, PO, HR), Oracle 11g, UNIX.

Responsibilities:

• Extensively worked on both master (Customers, Suppliers, Inventory Items, Asset Groups, Asset Activity, Maintenance Routings and Employees) and transaction (Fixed Assets, Install Base, On hand Inventory and Cost, Open Receivables Invoices, Payables Invoices, Open Purchase Orders/Lines, PO Receipts, AR Receipts and GL journals) data conversion.
• Extensively worked on conversion, inbound/outbound interfaces and BI Publisher reports.
• Interacted with functional team, track leads and business team to complete teh full conversion activity during SIT, UAT and Mock Conversion phases.
• Coordination of RICEW design, development, testing and delivery with our onsite counterpart.
• CAR coordinator role to analyze and maintain teh low defect rate across teh RICEW objects.
• Conducted review and audit on technical designs to ensure teh client’s quality on client deliverables.
• Status update to onsite counterpart on daily basis regarding RICEW development.
• Drafted functional design (MD.050) for RICEW objects.
• Prepared technical design (MD.070) for RICEW objects.
• Involved in common strategy and approach for conversion from number of source systems to single instance
• Responsible to collect & analyze technical data to identify any trends and issues or areas of improvement for teh delivery model or capability. Find out various plans and alternatives to identify teh source of teh problem. Performed a root cause analysis and suggested teh best possible solution or work around.
• Responsible to execute teh conversions in CRP, UAT and GO-Live environments and post GO-Live support.

Confidential, Phoenix, AZ

Technical Developer

Environment: Oracle Applications General Ledger R11i, UNIX.

Responsibilities:

• Developed teh interfaces for business validation (AEMP16 Validation).
• Design and build teh interface tool called ‘Chart of Accounts Mapper Program’. Teh tool which converts teh POD account code combination (Legacy Account) to POA account code combination (Oracle Account) and vice versa.
• Involved in Unit testing, System Integration testing, User acceptance testing and Go-Live activities as business system Analyst.
• Involved in teh warranty support at client site.
• Coordinating with teh business functional head and end users to identify and fix teh bug.
• Managed RICE development Managing delivery schedules and quality of deliverable.
• Foster an environment where best practices are identified and constantly applied on teh project deliverables.
• Helped team members by explaining them teh technical specifications and resolving their issues. Also guided them on better approach towards teh technical development of objects.
• Interaction with functional person to understand teh client’s requirements and functional design document (MD050)
• Helped team members in teh technical issues they have faced. Participated in deployment of objects on different instances as a part of Integration Testing and User Acceptance Testing using custom LDT’s and UNIX Shell Scripts.

Confidential, Louisville, Kentucky

Technical Developer

Environment: Enterprise Data Warehousing (EDW), DM Express, SQL, PL/SQL, UNIX.

Responsibilities:

• Involved in architecture/technical design and prepared teh Software Project Design document (SPDD).
• Involved in components technical build with adherence to teh application performance and prepared Program Specification document.
• Involved extensively in Unit testing, System testing and performance testing. Coordinated with business for functional gaps and performance and design issues.
• Scheduled teh jobs and scripts for smootan teh data flow with in teh EDW architecture. Working on Incentive and Rewards Phase III design.
• Involved in functional design discussion and did technical designing for different components.
• Helped team members by explaining them teh technical specifications and resolving their issues.
• Guided them on better approach towards teh technical development of objects.
• Developed UNIX script to migrate objects without manual intervention.
• Responsible to collect & analyze technical data to identify any trends and issues or areas of improvement for teh delivery model or capability. Find out various plans and alternatives to identify teh source of teh problem. Performed a root cause analysis and suggested teh best possible solution or work around. Performed and owned teh tasks to completion and help out other team members.

Confidential

System Analyst

Environment: Oracle Apps 11i (OM and Shipping, PO, INV, BOM, WIP, AP, AR, GL).

Responsibilities:

• Analysis, designing, testing, implementation and delivery.
• Oracle Service Contracts Interface/Conversion
• Gap Analysis, planning and implementation of Drop Shipment functionality.
• Design and development of Interface to supplement teh Drop Shipment to other third party systems.
• Proposed solutions and support for production issues in different modules.

Confidential

Developer

Environment: Oracle Apps 11i (OM, Shipping Execution, PO, INV, BOM, Routing), Oracle9i, UNIX, TOAD, Windows NT/2000

Responsibilities:

• Developed supplier/Customer interface using different API’s to bring those master data into Oracle as part of cut over process.
• Designed technical specification (MD070) and Installation Docs and Unit test Plans.
• Prepared scripts to move objects from one environment to another environment and did set up in testing environment.
• Post Conversion of Data with respect to technical doc
• Extensively worked on Sales Order conversion and understood each entity in it functionally and technically. Used teh Oracle seed PL/SQL API to convert/update sales order header, lines and sales credit.
• Extensively involved in teh verification and validation of converted Customers, suppliers, Sales Orders by executing teh program in various CRP environments.
• Participated in Functional Testing of converted data.