SUMMARY:

• Over 10 years of experience in Oracle E - Business Suite Application (Release 12/11i) as Techno Functional consultant with expertise in Oracle Supply Chain and Manufacturing Modules (INV, OM, PO, BOM, WIP, Depot Repair) and Finance modules AP, AR, GL, FA and Project Accounting
• Have some working knowledge on ASCP data.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Experience in Order to Cash (O2C), Procure to Pay (P2P), Drop-ship and IRISO business flows.
• Good knowledge AIM methodology and documents and involved in preparing documents like setup documents BR100, Test cases and executionTE.050, MD50/70/200 and CF250s.
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Extensive experience in development of procedures, functions, triggers, cursors, stored procedures and dynamic SQL scripts and packages using PL/SQL.
• Efficient in UNIX shell scripting in UNIX Environment.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs .
• Have working knowledge on conversions for suppliers, customers, items, sourcing rules, quotations and ASLs.
• Expertise in developing and customizing Reports and Forms in Oracle E-Business Suite R12/11i, Oracle 11g/10g/9i/8i, Oracle Reports/Forms, XML Publisher.
• Extensive knowledge and work experience in design and development of database/web applications in Client/Server environment using Oracle Developer tools Forms (6i & 9i), Reports (6i & 9i), Developer 9i, PL/SQL Developer, Workflow Builder and TOAD.
• Personalized Oracle Application forms as per the client requirement using Forms personalization in Oracle Applications.
• Extensively worked on changing the reports according to client requirements and Optimizing the Report Performance.
• Solely managed the activities like design, development, coding, testing and End-user training.
• Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE,

TECHNICAL SKILLS:

ERP : Oracle E-Business suite R12/11i Inventory INV , Order Management OM , Shipping WSH , Purchasing PO , BOM, WIP, Depot Repair, Install Base , AP, AR, GL, CM and PROJECT ACCOUNTING Advanced Pricing, AOL, System Administrator Financial Modules AP, AR, GL and Project Accounting

Application Tools : Reports 6i/9i, XML Publisher, Oracle Forms 6i/9i, Workflow Builder, WINSCP, MS Excel 2010, MS Visio 2010, MS Word and PowerPoint 2010

Databases & Tools : Oracle 11g/10g/9i/8i, TOAD, SQL*PLUS, SQL*Loader, SQL* Developer, PLSQL Developer, HP UFT, Kintana and Clearcase.

Operating Systems : Windows NT/XP/2000/98/7, UNIX, Linux

Programming Languages : SQL, PL/SQL, C, XML

Scripting Languages : Unix Shell scripting Career Profile Since

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Oracle EBS Techno-Functional Lead

Responsibilities:

• Modified the PL/SQL package and setups related to AME changes for the requisitions and Requisition change orders based on the approver levels and authorizing limits and various rules and attributes as per the business requirements.
• Implemented the setups for IR-ISO process for multi-company project in Vertex Pharmaceuticals.
• Developed PL/SQL and UNIX shell scripting codes to import file based Item costs and Material overhead costs as per the business requirement
• Developed and maintained various pl/sql packages, stored procedures and shell scripts for monthly release enhancements in iProcurement, Purchasing, OPM and FA, AP, AR, Cash Management and GL modules.
• Prepared migration documents for the enhancements
• Performed unit testing and functional testing for the projects and enhancements in the monthly releases
• Provided UAT support for the projects and enhancements in the monthly releases

Confidential, Grainvalley, MO

Oracle Data extraction Lead for GSI SAP implementation

Responsibilities:

• As a project lead for the project from Oracle ERP side, responsible for the entire project deliverables in both functional and technical areas.
• Involved in functional discussions and data mapping discussions for Oracle to SAP implementation project
• Prepared SQL queries to extract data from Oracle EBS database based on the mapping rules defined for each transaction specific
• Provided extracts for transactions from both supply chain and Finance modules using oracle standard base tables as well as custom tables
• Prepared PL/SQL procedures and XML publisher reports to create
• Creating documents(.doc, .xls and .pdf files) from short text attachments in organization items, Routing operation sequences and BOM reference designators using UTL FILE concepts in PL/SQL and bursting concepts/wrapper programs in XML publisher reports.
• Extracted data for multiple iterations for both static and dynamic transactions and supported SAP team in resolving the issues related to data conversions and to meet the count
• Developed custom jobs to run all the AR and PO pdfs for Alstom OU and extracted the PDFs from unix server using shell scripts and renamed them as per the naming conventions provided by customers.
• Provided support to load the Oracle data using JIVS tool for Alstom future use
• Prepared and provided SQL queries for various views to build the reports using JIVS tool

Confidential

Onsite Techno-Functional Lead

Responsibilities:

• As a single onsite coordinator for the project, responsible for the entire project deliverables in both functional and technical areas.
• Provide functional support to implement ABC analysis for the manufacturing orgs in Alstom operating unit
• Provided support to perform ABC cycle counting for the manufacturing organizations GVP and WSB
• Modified the programs using ZPL for the changes in printing labels for Alstom OU
• Provided technical support to resolve the production issues for Alstom OU
• Modified the PL/SQL procedures and reports to meet the requirements from Alstom OU
• Prepared BR100, CR and code migration documents for the project deliverables
• Execute functional testing from Alstom OU for the changes in GE side.
• Prepared the check out and check in for all components in VSS and created Kintana lines for code migration
• Supported setup team for the setup migration

Confidential

Onsite Technical Lead

Responsibilities:

• As a single onsite coordinator for the project, responsible for the entire project deliverables in both functional and technical areas.
• Modified the codes to remove hard coding for the OU names as the existing OU name is being changed
• Modified the output documents/reports to show the OU name correctly.
• Modified the setup documents to update the new OU name for modules INV, OM, PO, GL modules
• Conducted meeting to review the setup documents with the IT Program managers to confirm the requirements and signoff
• Prepared BR100, CR, CF250, CV100, MD 200 and TE050 documents for the project deliverables
• Completed unit testing for all the modified reports, interfaces and codes
• Conducted CAT meetings with all stake holders to execute end to end testing of the process and interfaces and Reports.
• Prepared the check out and check in for all components in VSS and created Kintana lines for code migration
• Supported setup team for the setup migration
• Supported post migration issues

Confidential

Onsite Techno-Functional Lead

Responsibilities:

• As a single onsite coordinator for the project, responsible for the entire project deliverables in both functional and technical areas.
• Modified the codes to reuse them for the newly created operating units for various interfaces and Reports.
• Major code changes involved in implementing the EDI interfaces (810, 850, 855,856) for new operating unit.
• Rolled out the responsibilities for the new operating unit using based on the existing OU for modules INV, OM, PO, CST, BOM, WIP, IB, DR, AP, AR, GL, PA, PJM.
• Conducted meeting to review the setup documents with the IT Program managers to confirm the requirements and signoff
• Prepared BR100, CR, CF250, CV100, MD 200 and TE050 documents for the project deliverables
• Completed unit testing for all the components
• Conducted CAT meetings with all stake holders to execute end to end testing of the process and interfaces and Reports.
• Prepared the check out and check in for all components in VSS and created Kintana lines for code migration
• Supported setup team for the setup migration
• Supported post migration issues

Confidential

Developer

Responsibilities:

• Modify the customer facing documents/Reports to display OU name correctly based on the responsibility used.
• Modify the PL/SQL codes to remove the hard codings for the Operating unit name
• Prepared the unit case document and consolidating the updates from supply chain team for the components that needs to modified as part of the project
• Prepared the clear case and Kintana lines for code migration
• Supported CAT testing for the supply chain team for OM, Inventory and Purchasing modules.

Confidential

Analyst

Responsibilities:

• Lead the offshore team to develop the shipment interface from Reynosa to NA 11i systems
• Review the codes and execute the testing from Development team
• Modify the codes for the development components during onsite hours based on the discussions with the customers on the requirement changes
• Prepared the clear case and Kintana lines for code migration
• Supported CAT testing for the interfaces developed

Confidential

Analyst

Responsibilities:

• Developed the codes for interfaces from legacy systems in 11i to upgrade them to suite for R12 for Asia 11i to R12 implementation project.
• Design and develop interfaces from Oracle to PPSS/3S4S system to process orders using PL/SQL procedures
• Design and develop interfaces from PPSS/3S4S system to Oracle for the ship confirmed orders along with the serial numbers using PL/SQL procedures
• Developed the RDF reports for the pick release documents to share the data to interface tables for the PPSS/3S4S systems to process the deliveries
• Designed, implemented and performance tuned interfaces and batch jobs using PL/SQL.
• Prepared Unit Test Cases.
• Prepared the clear case and Kintana lines for code migration
• Supported CRP testing and CAT testing for the interfaces developed
• Supported the Post production defect fixes and the implementation of the Change Requests.

Confidential

Developer

Responsibilities:

• Analyze the requirement and gather inputs from Support team and customers about the minor enhancement requirements for Q2O track
• Prepared design and technical development documents.
• Designed, implemented and performance tuned interfaces and batch jobs using PL/SQL.
• Prepared Unit Test Cases.
• Prepared the clear case and Kintana lines for code migration
• Supported the Post production defect fixes and the implementation of the Change Requests.

Confidential

Developer

Responsibilities:

• Analyze the requirement and gather inputs from Support team and customers about the break fix and minor enhancemnt requirements for Order Management, Inventory and Purchase order modules in NA 11i and EMEA 11i.
• Prepared design and technical development documents.
• Designed, implemented and performance tuned interfaces and batch jobs using PL/SQL.
• Prepared Unit Test Cases.
• Prepared the clear case and Kintana lines for code migration
• Supported the Post production defect fixes and the implementation of the Change Requests.

Confidential

Developer

Responsibilities:

• Analyze the requirement and gather inputs from customers for processing order sequence for rescheduling the orders
• Responsible for the programs to develop unscheduling and rescheduling the orders in the nightly schedules to achive ATP for CSCI
• Prepared design and technical development documents.
• Designed, implemented and performance tuned interfaces and batch jobs using PL/SQL.
• Prepared Unit Test Cases.
• Prepared the clear case and Kintana lines for code migration
• Supported the Post production defect fixes and the implementation of the Change Requests.

Confidential

Developer

Responsibilities:

• Analyze the requirement and gather inputs from Support team and customers about the break fix requirements for Order Management.
• Prepared design and technical development documents.
• Designed, implemented and performance tuned interfaces and batch jobs using PL/SQL.
• Prepared Unit Test Cases.
• Prepared the clear case and Kintana lines for code migration
• Supported the Post production defect fixes and the implementation of the Change Requests.