PROFESSIONAL SUMMARY:

• A dynamic professional with 7 years of IT experience in Oracle EBS Applications with expertise in Oracle SCM/Finance, ASCP, Dmantra,Package Consulting, and Business Analysis .
• Consistent team player with excellent communication skills.
• Purchasing (including iProcurement); iSupplier; E - Business Tax; Payables (including Sub Ledger Accounting), Payments, Cash Management
• Performing various transactions like miscellaneous issue, Miscellaneous receiving, sub inventory transfer, Move Order, Back Order,Shipping, Inventory adjustment.
• Install base Depot Repair cMRO module, creating repair order, Repair site Setup according to the supplier, creating the issue and return order in install base.
• Preparing and managing different document like BR100,MD-50,MD-70,MD-120,CV-20.
• Completed Oracle Purchasing Cloud Training and one year of on training experience in cloud.
• Strong Leadership, interpersonal, analytical & negotiation skills with proactive thinking.
• Ability to manage multiple priorities and work well under pressure.
• Hands-on in Oracle PL/SQL, SQL Tuning, Forms, Reports, XML Publisher Desktop all RICEW components.
• Good Expertise in Query and Performance tuning in Oracle
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Creating Purchase order, requisition, RFQ, Inventory receiving, Buyer setup.
• Currently seeking opportunity to leverage and enhance my experience across different business processes. Sound in swiftly executing projects and ensuring on time deliverables

TECHNICAL SKILLS:

Languages: Oracle SQL/PL/SQL

Tools: & Packages: PLSQL Developer, Clear-case, Kintana, Quality Center, TOAD, PPM

Web designing tools: HTML

ERP: 11i, R12.1.3

RDBMS: Oracle 9i, 10g and 11.2.0.4.0

Operating System: Windows 95/98/2000/XP/7/8.

PROFESSIONAL EXPERIENCE:

Confidential, Tukwila, WA

Techno Functional Analyst

• Onsite coordinator managing the team of 5 people at offshore, interacting with business and customer gather the information and explain to off shore and do setup accordingly.
• As per the BR-100 Document do setup for Inventory, Order Management and Purchasing and ASCP module and defining the business process.
• Purchasing (including iProcurement); iSupplier; E-Business Tax; Payables (including Sub Ledger Accounting), Payments, Cash Management
• Working on Production Support in SCM module and ASCP.
• D-Mantra Series creation, Integration Interface, Workflow defining Causal Factor definition, Business setup In Dmantra Engine.
• Defining Item, Item parameter, Organization parameters, Item Type Serial controlled, UOM, Item Service Relationship, customer Item, Customer UOI, Supplier UOM, Min-Max Planning, Inventory replenishment.
• Order Management, O2C process, Drop Ship process, Scheduling ATP check, Back Order, Shipping transaction, Customer Invoice report, Pick and Ship Notification, troubleshooting the issues.
• Creating Purchase order, requisition, RFQ, Inventory receiving, Buyer setup.
• Approved Supplier list setup, assigning supplier to Item as per the Operating unit, Defining sourcing rule, Assignment set, Price List, assign item to price list.
• Defining Bill to/Sold to address, Ship to address, Supplier, shipping network,
• Install base Depot Repair cMRO module, creating repair order, Repair site Setup according to the supplier, creating the issue and return order in install base.
• ASCP Defining plan, collection assignment set sourcing rule, GOP.
• Bill To/sold to address setup, Ship to address setup, Repair site defining.
• Performing various transactions like miscellaneous issue, Miscellaneous receiving, sub inventory transfer, Move Order, Back Order, Inventory adjustment.
• Analyzing the issue and find out the root cause of issue and fix it in given SLA.
• To prepare related technical documents based on the change request received. Change request may be modification of the existing program or creation of a custom program.
• Work with Oracle on the SR, update the SR as per the request in Metalink and implement the solution provided by Oracle.
• Worked on processing of ASN (Advances ship notifications) coming from supplier to capture the shipment details in oracle EBS and provide out bound notifications to customer.
• Responsible in developing XML BI publisher reports with respect to printing of repair order information that is send to supplier (XML Bursting for emailing & Bar Codes in Report)
• Identifying the key problem areas and optimizing the existing business processes for improved performance, providing suggestions/ recommendations on the best practices.

Environment: Oracle PL/SQL, SQL Tuning, Forms, XML Publisher, Reports, Workflows.

Confidential, Renton, WA

Programmer Analyst

• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Redeveloped multiple custom programs like vendor interface and other programs to work in R12.
• Developed custom reports from R12 reports same as 11i reports.
• Customized forms to make changes related to R12 for MOAC changes and tables changes.
• Retrofitted various custom components for R12 upgrade which invoices PL/SQL packages, views, Triggers, Value sets, AOL components.
• After successful R12 upgrade worked multiple custom enhancements which include development of custom Reports.
• Involved in analyzing the system stability after the upgrade and identified enhancements that can be infused in the new system to improve the business process.
• Developed and customized various custom forms as per new MD50 requirements and R12 changes.
• Developed various custom PL/SQL components as per business requirements which mainly include interfaces and custom validation program units.

Environment: Oracle PL/SQL, SQL Tuning, Forms, XML Publisher, Reports, Workflows.

Confidential

Programmer Analyst

• Understand the business requirements of the application from client.
• Working for IR-ITS Production Support in SCM module.
• Resolving the production Support issues related to Interfaces, Reports, Preparing the extracts tune the query and optimize the performance.
• To program using PLSQL programming language. All the PLSQL queries are tuned for best performance.
• To develop reports using Oracle Reports and XML Publisher. These reports are used mainly for business purpose like financial reporting and they are basically cost cutting methods.
• To prepare technical documents based on the change request received. Change request may be modification of the existing program or creation of a custom program.
• Gathering business requirements from client
• Providing business knowledge to the team.
• Provide observations/suggestions based on the Drilled down analysis of the performance metrics.

Environment: Oracle PL/SQL, SQL Tuning, Forms, Reports.

Confidential, Houston, TX

System Analyst

• Understand the business requirements of the application from client.
• Working for GE Oil & Gas Enhancement in SCM module.
• Change the calendar from LFS to Confidential .
• Change the setup of calendar and analyse the performance.
• To program using PLSQL programming language. All the PLSQL queries are tuned for best performance.
• To develop reports using Oracle Reports and XML Publisher. These reports are used mainly for business purpose like financial reporting and they are basically cost cutting methods.
• To prepare technical documents based on the change request received. Change request may be modification of the existing program or creation of a custom program.
• Gathering business requirements from client