SUMMARY:

• Over 12+ Years of experience in analysis, design, development and Implementation of complex applications using Oracle Applications 11i (11.5.4, 11.5.9, 11.5.10) and R12 (12.0.4, 12.0.6 & 12.1.3)
• A seasoned Techno - Functional Consultant skilled in the Implementation and Customization of OM,INV,WMS, BOM,WIP, Oracle Quality, Shipping, PO, Service Contracts, Installed Base, Configurator, AR, GL, QP, TCA, OIC, ADI, AP, ASCP modules of Oracle Applications in Multi-Org environment.
• Experience in Production support and System Maintenance.
• Expertise in the areas of Distribution & Manufacturing, Oracle Finance covering wide array of consulting and client management responsibilities.
• Experience in full life cycle ERP implementations as Functional and Technical.
• Experience in onshore - Offshore coordination, Solution Architecture using Oracle Application Implementation Methodology (AIM) and SDLC methodology.
• Demonstrated experience of working collaboratively with all levels of project organization to ensure smooth and successful implementation of projects.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, C++, J2EE, XL Macros

DBMS: Oracle 10g, Oracle 9.2.0.5/8i/7.x

Tools: Toad, PL/SQL Developer, Oracle Reports, Unix Shell scripting, Java, Advance Java, C++, Eclipse, Oracle Work Flow, Oracle Forms, Optio Design Studio, CLARIFY, Change Control, MS Office, PVCS, CMQA tracker, APPWORX,HP Quality Center, HP Quality Center Dashboard, HP LoadRunner, HP Quick Test Professional, Remedy, Microsoft VSS, Connect-Ship, File Zilla, Jira

Packages: Oracle Apps 11.5.9/10, Oracle Applications R12 (12.0.4/6 12.1.3 ), MS Office

Oracle Apps Modules: Order Management (OM/OE), Inventory (INV), Bills of Material (BOM), Work in Process (WIP), Purchasing (PO),Service Contracts (OKS), Installed Base (CSI), Configurator, Receivables (AR), Payables (AP), General Ledger (GL), Oracle 11.0.2, Oracle 11i (11.5.10),Oracle R12 (12.0.4/6, 12.1.3) AOL, Sys Admin

Operating Systems: UNIX, WINDOWS NT/98/XP/Vista, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Software: Oracle 10G R2 Database, Oracle Apps R12 (12.1.3) modules (INV,WMS,QA, PO, OM, BOM,WIP, WSH,QP, AP, AR, TCA, ADI), Oracle Apps AOL (Application Object Library), Oracle Reports 10g, Oracle Forms 10g, XML Publisher, Oracle Workflow 2.6,Unix, Linux, J2EE, XML, HTML, Windows 7

Tools: Toad, File Zilla, MS Office2007, Putty, EIS,Jira

Responsibilities:

• Gathering Business Requirements from business users and preparing Business Requirement, Functional Design, BR100, Test Scripts, Test Scenarios documents
• Working with Development team to build the functionality for the new requirements and testing in DEV / QA instances before migrating it to UAT and PROD instances
• Understanding / Reproducing / Analyzing / Troubleshooting / Resolving PDH functional issues and helping development team to resolve technical issues
• Working on Flexfields- segments, value sets, values and look up codes in ERP
• Working on File Upload tool for mass updates on Item Upload and Item Updates
• Understanding the current business process and troubleshooting the Production issues to find the Root Cause and replacing the issues in TEST instances and testing the resolution / work around to fix the issues in Production
• Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO
• Extensively worked on Change Requests (CR's) and preparing the BRD's, FD's on QA,OM, PO,INV
• Extensively worked on troubleshooting the issues on Custom Concurrent Programs in Oracle, providing the workaround and finding the Root Cause of the issues.
• Extensively worked on Quality Elements, Collection Plan, Master Child Collection Plans in Oracle Quality created the setups in TEST instance
• Monitoring the help requests created by the Business in Jira software and helping them in resolving the issues.
• Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, Order Management modules
• Worked and resolved the issues on Min-Max Planning in Inventory
• Extensively worked on different Inventory transactions and solved the period end issues
• Worked on the different Purchase Order setups, ASL, etc
• Created category sets, category codes, default category sets for the various items in Inventory application
• Troubleshooting the technical issues and preparing analysis on the issues in Oracle applications
• Worked on creation of custom menu for oracle quality access to business users
• Development/Customization of Interfaces using PL/SQL, Forms, Reports, Workflow in OM, AP, AR.
• Creations/Review of technical and functional design Specifications.
• Actively involved in development of oracle reports & EIS reports as per business needs
• Actively involved design and development of ADI l integration for various custom components
• Actively involved in development of code pack to migrate custom components across instances using FNDLOAD

Confidential

Oracle Apps Techno-Functional Consultant

Software: Oracle 10G R2 Database, Oracle Apps R12 (12.0.6) modules (INV, PO, OM, BOM,WIP, WSH,QP, AP, AR, TCA, ADI), Oracle Apps AOL (Application Object Library), Oracle Reports 10g, Oracle Forms 10g, XML Publisher, Oracle Workflow 2.6,Unix, Linux, J2EE, XML, HTML, Apache Tomcat, Windows XP, Windows 7, DB2, 4GL

Tools: SQL Developer, File Zilla, MS Office2007, Putty, UniTask

• Actively worked customizing BOM and WIP to meet the requirement using open interfaces
• Actively worked on automation of sales order progression using seeded programs
• Actively worked on shipping interface with legacy up on ASN
• Extensively worked on creating functional design documents for interfaces between ERP and Legacy system
• Development/Customization of Interfaces using PL/SQL, Forms, Reports, Workflow in OM, AP, AR.
• Actively involved in advanced pricing setup in calculating Freight charges on sales order
• Actively involved in design and development of custom components required for business.
• Actively involved in conversions
• Creations/Review of technical and functional design Specifications.
• Designed and developed Integration of shipping module with connect ship.
• Actively handled business requirements form personalization’s and CUSTOM.pll on OM and Receiving.
• Actively involved freight estimation of an sales orders.
• Designed and Developed Conc program on Fulfilment set as per business requirement
• Actively involved in designing and development of package weight estimate using custom tables and complex logic.
• Actively involved in development of reports as per business needs
• Actively involved design and development of ADI xl integration for various custom components
• Designed and Developed credit score interface with Experian.
• Actively involved in unit testing and code reviews
• Actively involved in development of code pack to migrate custom components across instances using FNDLOAD
• Actively involved in conversion of custom data across instances.
• Actively worked on demand load from Legacy to ASCP.
• Actively worked on production support to identify and address bugs or process issue.

Confidential

Oracle Apps Techno-Functional Consultant

Software: Oracle 10G R2 Database, Oracle Apps R12 (12.0.4) modules (INV, PO, OM, IB, Contracts, OIC,TCA), Oracle Apps AOL (Application Object Library), Oracle Reports 10g, Oracle Forms 10g, XML Publisher, Oracle Workflow 2.6, Unix, Linux, J2EE, XML, HTML, Apache Tomcat, Windows XP, Windows 7, DB2, 4GL

Tools: Toad, Win SCP, Help Desk, MS Office2007, Putty

• Creations/Review of technical and functional design Specifications.
• Development/Customization of Interfaces, Forms, Reports, Workflow.
• Actively involved in development of Integration of sales data with data warehouse for report generation.
• Actively handled business requirements form personalizations and CUSTOM.pll on PO, OM and Receiving.
• Actively involved and lead Inventory maintenance changes like changing Item to locator control without impacting business
• Designed and Developed custom screens for business requirements
• Designed and Developed Conc program on Fulfilment set as per business requirement
• Actively involved in development of data pulls for finance data like revenue, GP, Cost etc..
• Actively involved in root cause analysis and resolution of bugs in reports and online programs.
• Actively involved in design and development of SalesForce.com integration with Oracle in TCA, OM & PO
• Actively involved in development of OIC queries to pull commissions data as per business requirement.
• Actively involved in credit hold release customization
• Actively Involved in Inventory Consolidation

Confidential

Application Development Lead

Software: Unix, Linux, J2EE, XML, HTML, Apache Tomcat, Windows XP, Windows 7, DB2, 4GL

Tools: Microsoft Share Point, HP quality Center, Query Assistant, Eclipse, Microsoft XL, 2020 Kitchen Design, ODP, Labor, Paint, Webterm

• Development/Customization of Design application tools 2020, ODP.
• Involved in reviewing technical design and code review for the peers and to ensure that the quality process is maintained at all stages.
• Designed and developed an improved J2EE/Java based framework to the existing centralized file maintenance system for Paint which improved maintainability, security and performance.
• Actively involved in migration of Java and 4GL code from Unix to Linux platform for various applications like Depot Direct, Tool Rental, Hazmat, Email batch, OCB
• Appraising team members, twice a year H1 and H2
• Scheduling the internal team dynamics.
• Distribution of work with Offshore team
• Monitoring the Project plan to ensure no delay in deliverables
• Coordinating between functional team and PeopleSoft team on regular basis
• Appraising team members, twice a year H1 and H2
• Scheduling the internal team dynamics.
• Preparing and analysis of weekly performance reports. Team managerial activities like, leave approvals, Recommendation for promotions, Remove or recommend removal of employee from project, nomination to internal trainings etc
• Preparing associated work schedules on weekly basis
• Preparing and analysis of weekly performance reports.
• Attending meeting with Client and counterpart from onsite.

Confidential, Malvern, PA

Oracle Apps Techno-Functional Consultant (Onsite Coordinator/Lead)

Software: Oracle 10G R2 Database, Oracle Apps(R12 (12.0.6)) modules (INV, PO, OM, IB, Contracts, OWQ), Oracle Apps AOL (Application Object Library), Oracle Reports 6i.

Tools: Toad, PL/SQL Developer, Remedy, Microsoft VSS, HP Quality Center, HP Loadrunner

• Understanding the Customer business Process
• Creations/Review of technical and functional design documents using AIM methodology.
• Development/Customization of Shell scripts, Interfaces, Forms, Reports, Workflow .
• Involved in reviewing technical design and code review for the peers and to ensure that the quality process is maintained at all stages.
• Responsible for conversions, interfaces and customizations.
• Responsible for system integrity testing (SIT) and user acceptance testing (UAT)
• Involved in the development of stored procedures, Functions and Triggers.
• Handled system administration functions
• Have frequent calls with Client/User and the Functional Consultants.
• Developed/Customized various report using Report 6i, XML Publisher and Discoverer
• Actively involved in development of custom Module OWQ ( Oracle Work Queue) for End users to serve IKON’s customer in Service contracts.
• Actively involved in stress testing of R12 upgrades and
• Actively involved in stress testing projects like R12 Upgrade, WMS rollup, TMS implementation, Hyperion implementation, IKN2.11 (RUP6 & OATM) and On Target with activities like Scope identification, Planning, Development, Execution and result analysis
• Extensively involved in developing queries for functional testing team and for data analysis for stress testing team
• Extensively involved in scheduling meeting between Offshore and FIT to ensure deliverables on time
• Actively participated in cross functional testing like Contract Creation, Billing, closure etc...
• Actively involved in preparation of status dashboards of the team and addressing same in meetings.

Confidential

Oracle Apps Techno-Functional Consultant (Offshore Lead)

Software: Database Oracle 9i, Oracle Apps (11i) Modules (INV, PO, OM), Oracle Apps AOL (Application Object Library). Oracle Reports 6i, XML Publisher, PeopleSoft 9.0, People Tools 8.48Tools: PL/SQL Developer, Change Control, HP Quality Center, SQL Loader, Integration Broker

• Supporting in functionality related queries/ issues raised by PeopleSoft functional/technical team.
• Design, develop and deployment of Conversion like GL, Items, Vendors, customers etc ( historical data)
• Design, Develop and deployment of existing interface in apps instance to the legacy systems like eDHR, Dragon etc...
• Distribution of work with Offshore team
• Monitoring the Project plan to ensure no delay in deliverables
• Coordinating between functional team and PeopleSoft team on regular basis
• Appraising team members, twice a year H1 and H2
• Scheduling the internal team dynamics.
• Preparing and analysis of weekly performance reports. Team managerial activities like, leave approvals, Recommendation for promotions, Remove or recommend removal of employee from project, nomination to internal trainings etc
• Preparing associated work schedules on weekly basis
• Preparing and analysis of weekly performance reports.
• Attending meeting with Client and counterpart from onsite.
• Providing data from apps instance to PeopleSoft functional team

Confidential

Oracle Apps Techno- Functional Consultant (Team Lead/Track Lead - GPO- Tools)

Software: Database Oracle 9i, Oracle Apps Modules (INV, PO, OM, BOM, WIP), Oracle Apps AOL (Application Object Library). Oracle Reports 6i, XML Publisher, Optio Design Studio 7.7

Tools: Toad / PL/SQL Developer, Change Control, Clarify, PVCS, Putty, CMQA, Microsoft XL

Responsibilities:

• Managing a cross-functional team of resources
• Co ordination with Onsite and counter Offshore (Kolkata) team.
• Appraising team members, twice a year H1 and H2
• Looking into various team-building activities, team skills enhancement options, training sessions planning, new associate induction.
• Integral part of the CoE building activities.
• Dealing with escalations for issues.
• Scheduling the internal team dynamics.
• Preparing and analysis of weekly performance reports.
• Outlining the new releases and positioning the performers across them
• Preparation of associates shift schedule on weekly basis for 24/7 support
• Team managerial activities like, leave approvals, Recommendation for promotions, Remove or recommend removal of employee from project, nomination to internal trainings etc
• Scheduling cross module trainings/ KT between GPO and Tools.
• Co ordination with Onsite and counter Offshore(Kolkata) team.
• Post Implementation, various upgrade releases happen every 2-3 months for various enhancements, upgrades and new features. I am responsible for post-production support for Oracle Apps, in the OM, INV, PO & Item Costing Modules
• Has been a key resource, accountable in various releases since inception in the team.
• Providing functional support along with necessary technical analysis for set-up related issues like item, shipping networks etc.
• Monitoring and maintaining the background processes, chains and modules necessary to compile various orders.
• Scheduling & re-scheduling various chains dealing with inbound & outbound interfaces for interfacing various data details to the legacy systems through Oracle interfaces.
• Managing parts details, constant updating of part costs and attributes, doing the year round activities for cost roll-ups, dealing with various other internal teams for other costing related issues.
• Remediating failed transaction which is not in sync with Legacy.

Confidential

Oracle Apps Technical Consultant (Offshore)

Software: Oracle 9i database, Oracle Apps modules (INV, PO), Oracle Apps AOL (Application Object Library). Oracle Reports 6i, Oracle Forms

Tools: Toad, Putty

• Analysis of Functional Requirement.
• Creation of Technical design
• Development of code and Unit testing.
• Interface of Standard PO and Blanket Agreement with releases using Interface tables except for releases from EMPAC System.
• Item and Item Category Conversion
• PO Receipt Interface.