OBJECTIVE

• With sound professional knowledge, expertise and creativeness, I aspire to render quality service to the organization to attain its goal, with purpose, devotion to the duty and determination to succeed. I also aim to achieve a challenging position that promotes professional growth and prospects.

SUMMARY

• Over 12 years in IT (8 years in Oracle E - Business Suite Applications as a Techno-Functional Consultant, 2 years in Oracle E-Business Suite Applications as a Technical Consultant and 2 years as a Software Engineer) with extensive experience in design, development, implementation and maintenance of application software.
• Experienced in Development, Interfaces, Migration & Data Conversion, Implementation, Customizations of Oracle Financial, Manufacturing & SCM Modules such as General Ledger (GL), Payables (AP), Receivables (AR), Manufacturing Modules, Purchasing Order (PO), Inventory (INV), Order Management (OM), Bill of Materials (BOM), Work in Progress (WIP), Procure to Pay & Order to Cash process flow in oracle application.
• Good functional knowledge in Oracle R12 Financial, Manufacturing & supply chain modules.
• Experienced in RICE(Reporting, Interface, Conversions, Enhancements / Extensions) components for Oracle Applications.
• Highly experienced in developing & customizing Oracle Reports using RDF and XML Publisher in Oracle Applications.
• Prepared Technical Design Documents for customizations and conversions using AIM documentation methodology.
• Conducted global technical status meetings, set priorities and schedule, Developed Coding standards, code management and deployment, UAT testing and production support.
• Worked for major corporations and clients including Cisco, Oracle, Accenture, Zensar Technologies, Confidential (CRIS).
• Strong Conceptual, Business and Analytical skills.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.

TECHNICAL SKILLS

ERP Suite: Oracle E-Business Suite R12/11.x; GL, AP, AR, PO, OM, WIP, BOM, Quoting, INV, Advanced Pricing, AOL. Database Tools SQL *Plus, SQL * Loader, Toad, SQL Navigator

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2000. Oracle Tools Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i, Oracle Workflow Builder 2.6.3.5, Developer 2000, XML Publisher.

Other Languages: PLSQL, C/C++, Java, JSP, JDBC, J2EE.

Document Methodologies: MD.070, MD.050, TE.020,MD.120 .

Operating System: SCO UNIX (Shell Scripting), Windows 8.1/7/XP/NT/95, DOS.

Other Tools: PVCS, Kintana, Selectica Model Builder 7.1, Dollar Universe, Mercury Quality Center, SoapUI, BMC Remedy.

PROFESSIONAL EXPERIENCE

Techno-Functional Consultant / Analyst

Confidential, Research Triangle Park, NC

Responsibilities:

• Proactively analyzing all CCW partner raised issues and working as a single POC for groups to escalate Adoption impacting issues.
• Actively participate in UAT testing in CCW Product Configuration/Quoting/ ordering scope item/CR during quarter end.
• Provided solution guidelines on different issues on CCW Quoting/Ordering/Configuration issues in order to optimize the CPE/ITDS case volume.
• Developed Conversion program to Imported OM data from Legacy system to Oracle OM of Confidential .
• Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and other design documents as MD050.
• Troubleshooting the production issues on various applications (Work in Progress, Bill of Materials, Purchasing, Inventory, Material Planning, etc), replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.
• Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application.
• Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing.
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle.

Techno-Functional Consultant / Analyst

Confidential, Research Triangle Park, NC

Responsibilities:

• SME for High Touch Partner for all Cisco / Partner initiated deals and quotes, quick quotes, pricing and discounting. SME for High Touch Partner for all Partner certification, specialization and authorization process, partner onboarding, partner access (profile) tools and processes.
• SME for partner created Lead, opportunity, deal management, promotions, standard and non-standard processes.
• SME in FAX ordering adoption and support.
• Worked on AR, AP, GL, PO to maintain consistency between legacy system and Oracle Apps. The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for Cisco Customers.
• Developed a custom BOM interface using APIs to load BOM from custom application.
• Troubleshooting the order management, invoices, inventory, BOM etc issues using SQL statements in Oracle.
• Preparing business requirement, functional design documents and working with the development team to build the custom reports in various applications in Oracle, testing the report and migrating it to the other instances
• Extensively worked with Oracle Metalink on a few SRs (TARs) to fix the issues in Oracle Inventory areas
• Gathering the requirement details from the super user and enhancing the Oracle custom report (in PL/SQL) in Bill of Material (BOM) application

Techno-Functional Consultant / Analyst

Confidential, San Jose CA

Responsibilities:

• Developed a custom INV interface using APIs to load INV from custom application.
• Direct interacting with Cisco business and providing different logic to Development team to implement the code as per the business requirements.
• Unit testing and system integration testing of the developed code.
• Involved with the migration activities after developing the applications.
• Raising TD and providing the logic to fix the issues identified in testing phase.
• Provide production support for the deployed project till it is stabilized.
• Proactively monitoring all legacy PDT tools in Production Environment.
• Worked with Month end/Quarter end Cisco Release and Support activities.
• Actively participated in P1 bridge and weekly meetings.
• Shared many things technically as well as in functionally with the team and other team with different modules of Oracle Apps like AOL, OM, BOM, Pricing and INV.
• Designing Interface for Item Import and BOM Import.
• Co-coordinating with offshore explaining solution and technical approach to ensure the on-time deliverables.
• Ensuring code maintenance in PVCS & Ensuring code migration through Kintana.
• Enabling descriptive Flexfields and key Flexfield segments on some forms in Oracle Purchasing Application.

Oracle Technical Consultant

Confidential

Responsibilities:

• Imported BOM data from Legacy system to Oracle through Open BOM Interface.
• Customization of Pallet reservation form in Order Management as per the customer requirements.
• Interacted with end users and prepared functional doc MD 50/ Technical doc MD 70 / Design doc with all test cases TE 20/ Implementation manual MD 120 as per AIMS standard.
• Worked on modifying CUSTOM.pll to enable zoom functionality and to store customer UOM, Lot UOM, Total Line Quantity, Requested Quantity, Reserved Quantity for sales order form.
• Worked on customization on BOM Routing Form.
• Customized the standard oracle reports such as AR Invoice Print Report, Inventory Cycle Count Report, Transaction Register Report, Payment Receipt Report etc and converted them to XML Publisher format.
• Writing Stored Procedures, Function and Triggers for Auditing.
• Developed PL/SQL Triggers, Stored Procedures, Functions and Packages.
• Testing of the migrated changes in QA Instance and giving sign-off to move production.

Sr System Analyst

Confidential

Responsibilities:

• Imported BOM data from Legacy system to Oracle through Open BOM Interface.
• Performed system administration functions such as creation of users, creation of responsibilities, defining value sets, creation of concurrent programs and executables, registering applications.
• Registered concurrent programs, request groups for reports.
• Interacted with end users and prepared functional doc MD 50/ Technical doc MD 70 / Design doc with all test cases TE 20/ Implementation manual MD 120 as per AIMS standard.
• Customization of Pallet reservation form in Order Management as per the customer requirements.

Confidential

Responsibilities:

• Involved in creating secondary price lists, qualifier groups and promotional modifiers.
• Used GET CUSTOM PRICE function to calculate price of orders as part of formula.
• Developed Price list, Formulae, modifiers that gives promotional upgrade for specific item and attached qualifiers to it.
• Registered concurrent programs, request groups for reports.
• Interacted with end users and prepared functional doc MD 50/ Technical doc MD 70 / Design doc with all test cases TE 20/ Implementation manual MD 120 as per AIMS standard.

Software Engineer

Confidential

Responsibilities:

• Involved in creating secondary price lists, qualifier groups and promotional modifiers.
• Used GET CUSTOM PRICE function to calculate price of orders as part of formula.
• Developed Price list, Formulae, modifiers that gives promotional upgrade for specific item and attached qualifiers to it.
• Registered concurrent programs, request groups for reports.
• Interacted with end users and prepared functional doc MD 50/ Technical doc MD 70 / Design doc with all test cases TE 20/ Implementation manual MD 120 as per AIMS standard.

Confidential

Responsibilities:

• Worked on Enhancement and Implementation support.
• Writing Stored Procedures, Function, Triggers and Packages.
• Bug fixes, Enhancements and test the application.
• Installation of Oracle 8i database in UNIX server.
• Involved in developing various Custom reports, Customization on existing reports for several modules according to clients requirements.