Oracle Techno Functional Consultant Resume
Sanjose, CA
SUMMARY
- 9 years of IT experience as an Oracle Techno Functional Consultant using Oracle Applications (11i and R12) across various modules with Strong SQL and PLSQL Skills
- 9 years of IT experience in Design, Implementation, Support, Upgrades, Coordination, Interfaces, Conversions, Customization, Testing and Documentation of Oracle Applications across different versions.
- Expertise in Solution Customization Cycle involving Business Requirement Study & Problem Identification (AS IS); Business process mapping with product; Gap Analysis & Customization Finalization (TO BE); Change Management for Customization; Solution Implementation, UAT & Support
- Have hands on experience in Order Management(OM), Advanced Pricing, Supply Chain (SCM), AOL, Advanced supply chain planning(ASCP), General Ledger(GL), Trading community Architecture (TCA), Accounts Payable, Accounts receivable and Oracle Projects Modules
- Have Sound knowledge on Service contracts and Install Base modules.
- Have excellent knowledge on the System Administrator and Application developer responsibilities
- 3+ years of Hands - on Experience on Order to Cash cycle and Implementation of New organization in Supply chain Module
- Hands-on experience of RICE components design and development in Oracle Applications 11i Technical knowledge in using database back end tables for querying and reporting purposes.
- Worked on creating PLSQL Interface packages using standard Oracle APIs for Order Management, Pricing, Oracle Projects and AOL modules
- Have good knowledge in tools like Kintana, Quality center, TOAD, PVCS, SVN, Dollar Universe.
- Experience in developing forms using Oracle Developer tools like Forms 6i and 10g
- Experience in customization of the Oracle workflows to suit the business process needs.
- Good Exposure on Tuning of SQL Queries to improve performance of a system, Tables using Optimization Techniques through Explain Plan.
- Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology and documents such as BR 100, MD 50, and MD 70.
- 3 years of experience working as Onsite and Offshore model and co coordinating with the offshore team and with the clients to meet the requirements and deadlines.
- Good experience in working with cross functional teams and effectively driving the meetings with Business and IT counter parts in both gathering the requirements, resolving issues and testing activities.
- Presently working on the R12 and 11i setup configurations for Order Management module
TECHNICAL SKILLS
Databases: Oracle Database Version 10g/9i/8i
Languages: C,SQL,PLSQL
Oracle Applications: E - Business Suite- 11i and R12
Oracle Apps Modules: Oracle Apps 11i - AOL, Order Management, Quality Pricing, General Ledger Oracle Apps R12 - Order Management, Inventory, Advanced Supply chain Planning and AOL
Oracle Tools: SQL*Loader, Toad
Operating Systems: Windows XP, Windows 7
PROFESSIONAL EXPERIENCE
Confidential - SanJose CA
Responsibilities:
- Worked on the providing solutions for Business requirements.
- Worked on the Order to cash cycle and Implemented the new requirement related to the Header level Discounts on manual orders using modifiers and Qualifier setups.
- Made changes to the pricing integration package to send the new discount details as per the business conditions
- Worked on modifier and qualifier migration from 11i to R12 using public API
- Worked on identifying/ owning OM related setups like OM Holds, validation templates, processing constraints, Transaction types, Defining and Assigning Document sequences, Defaulting rules, Attachment categories, OM system parameters
- Worked on the AOL setups needed for the flow like Value sets, validation values, Descriptive flex fields, Functions, Menus, responsibility creation, its profile option values and Lookup codes
- Analyzing the defects related to them and resolving as needed in daily basis
- Coordination with offshore team of 4 working on the above setups
- Supporting the transition activities for the release like TCA, TCB, FPR and Golive
Environment: Oracle Application R12, Oracle Order Management, Oracle Advanced pricing SQL, PL/SQL, TOAD, Kintana, SVN repository tool, Artifactory, Quality Center
Confidential - SanJose CA
Oracle Techno Functional Consultant
Responsibilities:
- Analyzed the existing functionality of Service contract mechanism in the system
- Based on the requirements formulated the scenarios to be considered
- Involved in the Development of PLSQL Interface packages that performs CHR functionality
- Involved in Issue fixing and few changes that came in later point of time due to change in Business requirements.
- As part of development team worked on the performance tuning of the SQLs to meet the SLAs of the CHR report
- Worked as an Onsite and Offshore model and coordinated the things from Business to the team.
Environment: OracleApps Implementation Release 11, TOAD, PL/SQL, Kinatana, PVCS, Quality center
Confidential, Sanjose CA
Oracle Techno Functional Consultant
Responsibilities:
- Analysis of Existing functionality in the system.
- Prepared the Technical Design document as per the Functional requirement and implemented the changes successfully.
- Identifying Cross flow dependencies and working with the cross flow teams
- Changed existing PLSQL packages and SQL queries to meet the requirements
- Supported the testing phase of the cycle and worked on the defects and issues.
- Performed performance tuning for the major SQLs to reduce the waiting time
- Worked as on Onsite and offshore model from Onsite and coordinated with Business requirements and the team
Environment: Oracle Service contracts, Oracle 10g/9i, TOAD, SQL, PLSQL, Kintana, PVCS, Quality center, Windows XPLarge scale services R12 implementation - Supply Chain Management August 12 - March 13
Confidential - SanJose CA
Oracle Techno Functional Consultant
Responsibilities:
- Worked on the setting up Inventory organization.
- As an analyst Converted business requirements into solutions and worked with Dev team
- Co-ordinated with cross tracks teams for inputs or clarifications.
- Worked on the setups to define Organizations, Organization Parameters, Defining locations, sub inventories, Unit of measure, Defining Conversions, and setting up the org for Container Items
- Worked on the Deliver setups like Shipping parameters, Release rules, ship confirm rules, defining freight carriers and ship method codes.
- Worked on the AOL setups required to support like Lookups, DFFs
- Coordination with offshore team of 4 working on the above setups
- Supporting the transition activities for the release like TCA, TCB, FPR and Golive
Environment: Oracle Application E-Business Suite R12,(INV, BOM, Oracle 10g, TOAD, Kintana,PVCS, Quality Center
Confidential - SanJose CA
Oracle Techno Functional Consultant
Responsibilities:
- Worked on the providing solutions for Business requirements.
- Worked on conversions to customer data from 11i to R12
- Implemented the new business enhancement to create duplicate customers with a special account type attribute
- Worked on the AOL setups needed for the flow like Value sets, validation values, Descriptive flex fields, Functions, Menus, responsibility creation, its profile option values and Lookup codes
- Analyzing the defects related to them and resolving as needed in daily basis
- Coordination with offshore team of 4 working on the above setups
- Supporting the transition activities for the release like TCA, TCB, FPR and Golive
Environment: Oracle Application R12, Oracle Order Management, Oracle Advanced pricing SQL, PL/SQL, TOAD, Kintana, SVN repository tool, Artifactory, Quality Center
Confidential - SanJose CA
Oracle Techno Functional Consultant
Responsibilities:
- Worked on adding the inventory orgs to ATP-Plan and MPS - Plan
- Owned the setups like defining the organizations in the instance, Defining Supply chain planning parameters, Sourcing rules, Defining Organization security, Planning parameters, Defining Plan names and Plan options, Defining and Assigning Allocation rules
- Worked on the AOL setups required to support like Lookups, Profile options
- Coordination with offshore team of 4 working on the above setups
Environment: Oracle Application E-Business Suite R12,(Advance supply chain Planning Oracle 10g, TOAD, Kintana,PVCS, Quality Center
Confidential - San Jose CA
Oracle Technical Consultant
Responsibilities:
- Analyzing the Customizations by Cisco to the Sourcing Module.
- Also working on the MRAP and CIP reporting tools which are developed on the Manufacturing side and analyzing on the enhancements that are presently in discussions with Biz.
- Provided extensive user support during UAT and Post Production phases
Environment: Oracle 11i Sourcing, TOAD, Kintana, PVCS,Quality center.
Confidential - San Jose CA
Oracle Techno Functional Consultant
Responsibilities:
- Analyzed and made changes to the Concurrent manager setups such that they point to their designated Nodes.
- Analyzed the behavior of the requests getting submitted in TCB instance on daily basis and made changes accordingly.
- Have been monitoring the status of Requests in Production on daily basis and making sure that no request should encounter issue due to Concurrent manager changes or should wait for a long time due to the number of processes that are allotted to each Manager.
Environment: OracleApplications 11i,PL/SQL, SQL, Kinatana, PVCS, Quality center
Confidential
Oracle Jr. Functional Consultant
Responsibilities:
- Performed and automated the Transaction types setup under Order Management module
- Performed setups such as Defining key flex fields, Creating Set of Books, Locations under General Ledger Module
- Performed setups such as Tax names and groups, Supplier setups under Accounts Payables Module
- Involved in performing Transaction types, Transaction Sources, Auto accounting under Accounts Receivables Module
Environment: Oracle Applications 11i (GL,AP,AR) SQL,PLSQL, Kintana, PVCS, Quality center
Confidential
Oracle Technical Consultant
Responsibilities:
- Automated the AOL setups and reduced the load of Kintana packages to be created because of the large number of configs that came as part of the release
- Made sure that the naming standards and other things are implemented.
Environment: Oracle Applications 11i (AOL) SQL,PLSQL, Kintana, PVCS, Quality center
Confidential
Oracle Technical Consultant
Responsibilities:
- Did several setups including Project Costing, Project Billing, Project Foundation, Project Resource Management
- Analyzing the functional flow and performing various setups in the above module and sub modules.
- Automated setups such as Defining Organizations, Defining Org Hierarchy, Defining Auto accounting Rules setups.
- Closely worked with the Projects team on the changes that were coming up in the testing phase.
Environment: Oracle Applications 11i (Oracle Projects) SQL,PLSQL, Kintana, PVCS, Quality center
Confidential
Oracle Technical Consultant
Responsibilities:
- Involved in the migration of AOL configs using the tool kintana.
- Automated several setups using standard Oracle APIs.
- Worked on the Concurrent program scheduling tool called Dollar Universe.
Environment: Oracle Applications 11i (AOL,OM, INV) SQL,PLSQL, Kintana, PVCS, Quality center