SUMMARY:

• Having 9+ years of diversified IT experience in Oracle applications Implementation, Development, support and upgrade projects in different modules in oracle in R12 and 11i system.
• Certified (IZ0 - 521) in Oracle Order Management (OM).
• Deep Understanding of Modules Supply Chain Management (SCM),Order Management (OM), Inventory (INV), Purchasing (PO), Account Receivables (AR), Account Payables (AP) and General Ledger (GL), Advance Pricing, Oracle Manufacturing, costing, WIP (Work in progress), Advance Supply Chain(ASCP), Sales Representative and Acquisition integration.
• Expertise in Requirement Gathering, Solution Assessment and validation, Solution Construction, Authoring Functional documentation (Md.50), Technical documentation(Md.70) and Test Case creation as per Oracle standard AIM Methodology.
• Deep Expertise in Oracle PL/SQL and SQL with expertise on developing and enhancing Packages, Procedures, Functions, Triggers, Tables, Grants, Synonyms, Types, Advanced PL/SQL concepts like Collections, Bulk Binding, Performance Tuning, Indexes, Partitions, TkProf, DB Profiler and hints
• Deep Expertise on Oracle Application Object Library (AOL) setups, AOL migration using FNDLOAD, LCT files, LDT file creation, XMLLoader, f60gen, frmcmp utilities and DBMS JOBS.
• Familiar with EDI data like EDI 856 (Advance Shipment Notice) and B2B messages like 4B2, 3A4 and 3A9 Messages.
• Expertise RICE (Reports, Interfaces, Conversions and Enhancements) components, Oracle Forms, Oracle Reports, Unix, Oracle Application Express(Apex), XML/BI Publisher Reports Application Framework (OAF) pages and Data Loading.
• In depth understanding of Software Development Life Cycle (SDLC), Testing Life Cycle and Release Management, Software Release Automation, Release Ops, PVCS, SVN, Kintana and APPDB.
• Excellent verbal and written communication skills with an eye for detail, Highly conceptual and innovative problem solver with excellent organizational skills and coordination skills.

TECHNICAL SKILLS:

Modules: Oracle EBS Suite Applications R12.1.X, 11i Ver11.5.10.2 Order To Cash (O2C), Procure To Pay (P2P) Cycles, Order Management (OM), Oracle Inventory (INV), Account Receivables (AR), Account Payables (AP), General Ledger (GL), Oracle Advanced Supply Chain Planning (ASCP),Advance Pricing, Costing and Work in Progress(WIP),Oracle Manufacturing including, Plan, Source, Make, Deliver and Finance.

Domain: Oracle Supply Chain Management (SCM), Oracle Manufacturing, Dev Ops, Release Management.

Operating System: Solaris, Linux, Windows, Windows Vista/95/98/2000/XP/XP Pro/7, DOS, UNIX

Languages: SQL, PL/SQL, UNIX Shell Scripting, Basic Java

Tools: /DB/Packages: Application Object Library(AOL), Oracle Demantra,Oracle Reports 10g/9i/6i, Oracle Forms 11g/6i, Oracle BI Publisher(XML Publisher), SQL*Plus, SQL* Loader, Toad, Polytron Version Control System (PVCS), Kintana, Subversion(SVN), Oracle Application Express, Oracle Application Framework(OAF),Oracle Migration Assistant. Oracle Application Testing Suite(OATS)

Databases: Oracle 10g, 11g,12.2

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Techno Functional Consultant

Responsibility:

• Technical implementation on Buy-Sell and Buy-Hold-Sell process in Cisco R12 environment to have more visibility on components purchased by the partner from Suppliers.
• Create and maintain new inventory locations (SHUB),implement locator concept current process., Manage cut over orders, Implement custom reservation API.
• Technical implementation of Compliance frame work (Smart compliance) in Cisco Order Flow in order to meet import compliance criteria of different countries across the world.
• Develop data model and design and develop front end OAF screen to capture compliance data.
• Develop APIs to be used by Order Management and Planning team to access the compliance Rules.
• Senior Technical Consultant of the project.
• Managing EDI data like EDI 856, 4B2 Messages from partner and process the same for transactions in Oracle APPS Supply Chain Make Track.
• Code Development for Retro Invoice Creation (Differential amount to be settled with partner).
• Unit Testing on Procure to Pay Cycle by requisition creation from partner 4B2 messages, requisition import, Purchase Order (PO) creation, PO Approval and PO Receipt and Invoice generation as part of SCM R12 Implementation.
• Have worked on Order to Cash (O2C) cycle for SCM R12 Implementation.
• Have created Order, Booked, Scheduled, Pick release, Pick Confirmed Ship Confirmed, created invoice and posted to General Ledger (GL) for Configure to Order (CTO) and Build To Stock (BTS) in order to perform testing and automating it.
• Development, customization, personalization of Oracle forms and Reports.
• Code review, Coordinating with offshore team and Lead the Development activities.
• Create Automation test script using Oracle Application Test Suite (OATS).

Technologies Used: SQL, PL/SQL, Oracle Apex, Java, Oracle Forms, Oracle Reports.

Confidential, San Jose, California

Oracle EBS Techno Functional Consultant.

Responsibility:

• Design and Architect in-house tool (APPDB) for version control and object migration.
• Create maintain and review data model for the new tool.
• Create user interfaces using Oracle Application Express (APEX) tool for version commit and code review.
• Create and maintain PL/SQL APIs for version commit and deployment.
• Create and maintain dbms jobs for object migration and meta data synchronization.
• Work with sysadmin and DBA team for server space allocation and system maintenance.
• Develop dynamic PL/SQL APIs which utilize Oracle standard FNDLOAD and XMLLoader utilities to migrate Oracle AOL Objects and XML Publisher files.
• Create design documents, system maintenance documents implementation manuals and user manuals for the new tool
• Train users and developers on usage of the new tool and evangelize the tool across the cisco development community.
• Design and monitoring regression and progression test scripts for enhancements on the tool.
• Debug and fix the issues on tool at minimum SLA.
• Support Object commit, promotion to test and production environments.
• Co Ordinate with Release Management Team for any issues during Production Go Live.
• Identify and implement innovative solution to customers Problems.
• Technical Leadership and direction to Agile Software Development teams.
• Design and monitor regression and progression testing on any enhancements on the tool.
• Coordinating with developer community, Release management and SRA team during Go Live and new enhancements on the tool.

Environment: SQL, PL/SQL, Oracle Apex, Java

Confidential, San Jose, California

Oracle EBS Techno Functional Consultant.

Responsibility:

• Senior Technical Consultant of the project.
• Have Worked on Order To Cash Flow including Order creation, Booking, Custom work flow management and partner message management, Pick release, Ship confirm and Invoicing.
• Have worked on 4B2 message processing for purchase requisition creation, Purchase Order creation, PO receipt, invoicing and invoice communication.
• Have fixed data issues in Advance shipment notice and enablement data send to customer and suggested long term fix to enforce pallet info in partner message.
• Have worked extensively on BTS and CTO flow issues and handled daily order processing during Normalization period.
• Coordinating with offshore team.
• Lead the team on handling issues, cases and proactive monitoring.
• Onsite Offshore handover.
• Proactively find the system issues and resolving them.
• Daily monitoring of newly implemented R12 instance and normalization support
• Bridge between ITDS and Business.

Environment: SQL, PL/SQL, Oracle Forms.

Oracle Modules Used: Order Management (O2C), Supply Chain Management (SCM)

Confidential, San Jose, California

Oracle Apps Functional Consultant

Responsibilities:

• Senior Functional Consultant of the project.
• Define set ups required for Oracle Order management(OM), Inventory(INV) and help finance team to identify set ups required for the implementation of Order To Cash Cycle(O2C) and document in BR100 document.
• Identify set ups required to implement Procure to Pay Cycle (P2P), document the same in BR100 document and implement the same.
• Implement Configure To Order (CTO) and Build To Stock (BTS) Order Flow, JIT (Just in Time) Manufacturing concept in Oracle R12 system.
• Integrate newly acquired organization (Currently working in SAP) to Cisco R12 environment.
• Learn current data send in Advance Shipment Notice (ASN) and Enablement data from SAP system and implement the same from R12 with functional Md.50 and technical Md.70 design using EDI 856.
• Technical design for capturing enablement data (like MAC address, IMEI) for each serial number from Auto test data base using multiple concurrent programs and web service call.
• Co Ordinate Onsite Offshore activities and release cycles and Transition Lead for the release.
• Data Extraction from current 11i system, required conversion and loading into R12 system.

Environment: SQL, PL/SQL, Oracle AOL, UNIX, Java Webservices.

Confidential

Software Engineer

Responsibilities:

• Requirement Gathering Functional and Technical Design, Development and co ordinate development activity.
• Implement Custom Trade Agreement Act rules in the Order Flow
• Responsible for writing the code bug fixing, testing and implementation of the new enhancement in the system using PL/SQL, Oracle Application Framework(OAF), Oracle Reports, Oracle Forms, Shell Script, Java and review code from peers and juniors.
• Create Kintana Package and migrate the code to test environments.
• Enable New Organization and Country in R12 Instance
• Implement Demand Planning using Oracle Advanced Supply Chain Planning (ASCP) and Demantra.
• Implement Custom Costing Rules in Oracle 11i instance.
• Case Management and Support, maintenance of Order Fulfillment track
• Root Cause Analysis of issues in production and fix for same.
• Implement custom Compliance Rules in Order Management
• Partner Integration to Oracle 11i System.
• Implement Drop Ship flow in Oracle 11i system.
• Customize Oracle Apps 11i Order fulfillment cycle as per customer needs
• Understand the E2E logistics process in Cisco. Has done the E2E process on SCD validation from generation of repots and validating it.

Environment: Oracle Forms and Reports, Toad, SQL, PL/SQL, UNIX, Oracle AOL, UNIX, Java Webservices, Advance Supply Chain Management (ASCP),Supply Chain Management (SCM)

Confidential

Software Engineer

Responsibilities:

• Was responsible for validating the release environment by doing the functional testing.
• Gathering the functional testing requirement from onsite team, study it and provide the KT to automation team.
• Also responsible for testing on manufacturing & finance track and SCD.
• Learned the oracle order management functional flow. Have worked on PO and GL. Created the PO, received it and created invoice for the same.
• Have created the Journal voucher and posted it to GL.
• Have done Daily Cost Rollup for PID item.(Have updated the cost for PID item and reflected the updated cost in Local org and global Org.)
• Have validated the Oracle data against the Cisco tools MRAP and Siebel. SCV: Have validated the Contract Manufacturer files against the Cisco files and reported the discrepancies to the client. It was a very business Critical activity and got appreciation from client.