SUMMARY:

• Oracle Certified with 7+ years of experience as an Oracle Applications Technical Consultant.
• Extensive experience in Analysis, Design, Development, Testing and post - production support for Oracle EBS Suite R11 and R12 version.
• Experienced in Real- Time transactional reporting by Oracle-Business suite.
• Project experiences include, multiple full life cycle implementations, new functionality deployment and R12 Upgrades
• Experienced in the Order-to-Cash and Procure-to-Pay business flows. Good Knowledge in Data Model of Order Management (OM), TCA Architecture, Account Receivables (AR), Purchasing (PO), Account Payables (AP), General Ledger (GL), Inventory (INV), WMS, Credit Management, Advanced Collections, Approvals Management
• Experienced in writing AIM/OUM Documents, risk management, advance control management, order management, business plan, contract management, supply orchestral, supply chain collaborator, manufacturing, supply chain planning, quality management costing, cost accounting, financial supplier portal, inventory management, project.
• Technical Expertise in SQL, PLSQL, Oracle Reports 6i/10g, Discover, Oracle Forms 6i/10g, (XML) BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning.
• Solid hands on experience in designing, developing rice-w components (reports, interfaces, conversions, extension, workflow), discoverer and bi publisher in oracle r12 platforms.
• Experienced in transactional reporting in Excel using Oracle EIB
• Experience in development and customization of forms in Oracle applications using standard AOL functionality and CUSTOM pll and Template. FMB.
• Experience with pricing administration, finance, SCM, inventory, WMS, purchase order, pricing, shipping, manufacturing (BOM, MRP), procurement to pay (P to P), OTC, engineering, IM, logistics, transportation.
• Experience in System Administration & AOL: Application user/responsibility setup, value sets, flex fields, registering menus, forms, reports, concurrent program
• Excellent business knowledge across multiple verticals with the ability to understand the business process, perform a Gap Analysis and recommend an Oracle Solution across multiple modules
• Prior experience as a technical lead in conducting CRP's, test strategy & plans, training and post go-live support. Hands on experience in interface design, customizations, integrating and data conversion.
• Worked with Oracle Support to identify issues that arise and created Service Requests (SRs) with Oracle Support and tracking them to closure to track them to closure.
• Experience with the following tools: Forms Personalization, TOAD, SQL Developer, Putty, Win SCP and version control, PVCS, Kintana.
• Experience in Onshore-Offshore model Implementation
• Authorized to work in United States for any employer

EXPERIENCE:

Senior Oracle EBS Consultant

Confidential, Pennsylvania

Responsibilities:

• Working at client site as Technical lead responsible for managing offshore resources.
• Gather requirements or business rules and create functional solution documents to define the business needs of clients & stakeholders.
• Develop product design, architecture and test plans using requirements such as scope, processes, order management, alternatives and risks.
• Developed Oracle Payroll outbound interface for multiple geographies. Oracle Payroll Element entry data is interfaced to ADP for Payroll processing.
• Managing all the frames of supply chain management (SCM), WMS and order management.
• Analysis and solution design for changed functionality from R11 to R12.
• Participating in User testing, Code Review, Unit testing and Integration testing, Preparing DS140 for Change functionality, Preparing user training documents
• Managing Code Migration across instances, Working with DBA's on Databases changes related to Editioning Objects, WMS, managing all Technical SR's with Oracle, Customizing Seeded reports as per Business needs
• Requirement gathering and designing custom reports
• Remediating existing personalization and Creating new personalization in order to achieve desired functionality
• Working closely with Functional leads on testing functionality impacted by CEMLI objects
• Involved in Auto Invoice Interface to import Invoice, Credit Memo, Demit Memo, On account Credits into Interface table in Account Receivables.
• Managing CEMLI objects across different technologies like Pl SQL, Java, JSP, WMS, OAF, Forms, Reports, XML and AOL objects
• Post production support for all Modules and maintaining Share point for all CEMLI objects
• Responsible for all the order management and supply chain management projects. :
• Modifying the COGS workflow to in corporate Line type defaulting logic as per Quality Plan
• Modified Order Header and order Line Workflow
• OAF Form personalization for custom changes on oracle standard pages, JSP customization for I store pages, Preparing schema correction scripts for editioning objects
• Designing and Implementing Check Printing solution with customizations, WMS, remediate all Custom Functionalities to work AS IS.

Oracle EBS Consultant

Confidential, Boston, Massachusetts

Responsibilities:

• Worked at Client location, involved in requirements gathering, Client discussions and Knowledge sharing. Involved in the Interface scope of work and acted as key point of contact to offshore development team.
• Involved in developing complex objects in accordance with technical development standards and best practices. Involved in design and development of Interfaces and conversions advance control management, partner management, sales, service, revenue management, business plan, contract management, order management, supply orchestral, supply chain collaborator, supply chain planning, quality management costing, cost accounting, financial supplier portal, inventory management, project financial reporting compliance, pricing management, pricing administration, order management, WMS, finance, SCM, WMS, purchase order, pricing, procurement to pay (P to P), OTC, engineering, IM, logistics
• Involved in reviewing team deliverables i.e. Technical Design documents, WMS, build artifacts, order managements, Unit Test plan and Installation guide, and suggest the best practice methods for a quality deliverable.
• Retrofitted XML Publisher and D2k Reports, AMEX P-Card Spend Details, MD050 AMEX P-Card Invoice Load Details and R2P Reports Requisition Reseller Detailed Report
• Involved in designing the prototype, preparing MD60 technical specification, Unit Test cases document, coding and Unit Testing. Collaborating with business, operations, process, design, engineering and other key stakeholders to prioritize project tasks, collect requirements, develop schedule and deliver quality products in an agile environment.
• Developed data feed interfaces from Oracle HRMS to Java based applications used by Cisco Sales consultants for Commission payments.
• Involved in Customizing Invoice Approval Workflow to embed multiple approval Hierarchy and WMS.
• Work with DBA team and cross functional application teams for application change control and system performance Issues. Involved in Quarterly releases code deployment and post live support.
• Customization of business-critical Forms and Reports. Solution Designing for all technical tasks
• Identify and Purpose best practice methods, order management, Coding standards, Standard for documentations.
• Timely resolution of incidents based on the estimate and agreed date/ time and delivering Objects with High Quality. Code review for offshore and onsite developers.
• Created test scripts for every level of testing from unit testing stage to integration testing.
• Unit testing and Integration testing. Provide support for business-critical application problems and issues. Involved in deployment activities, and supported go-live migrations.

Business Analyst

Confidential, Mahwah NJ

Responsibilities:

• Support and assist in development of change request specifications that support a business/systems modification.
• Performed GAP analysis and provided rationale.
• Reviewed documents developed by other team members in the group for adherence to standards, consistency, and readability
• Exposure in WMS, Business Requirement Document (BRD), UML, USC case, Financial requirement document (FRD), user stories, activity diagram, sequence diagram, SPSS, SPC, MY SQL, SQL, Q charts, QFD matrix, ODM, JAD sessions, XML, EERS, Axions, scrum, agile, requirement gathering, stake holders, end users.
• Prepared use case model and experienced supply chain management (SCM)
• Participated in meetings with SME/Users as part of the requirements gathering process
• Conducted requirements walk through with business users and technical architect to obtain sign off on agreed upon requirements
• Processed SQL queries for querying databases and specification change in WMS, supply chain management and order management.
• Look up to the end users and developers to ensure user satisfaction and if any change in management.
• Proactively report on any issues and current project status.