We provide IT Staff Augmentation Services!

Lead Erp Consultant, Oracle Applications Resume

Boston, MA

SUMMARY:

  • 15 years of IT experience working with Oracle & Oracle Applications (GL, PO, AP, PA, GMS, PN, INV, AR, OM, HR,
  • EC, iProcurement, iExpenses, Workflow, AOL and System Administration modules) in implementation, support, enhancements and optimization which includes 13 Years in USA.
  • 5 plus Years of Team & Project management experience as ERP Manager / Project Manager for Oracle
  • Applications.
  • Experience in Financials, Procure - to-Pay (P2P) and Order-to-Cash (O2C) modules with Implementation, upgrades, enhancements and Production Support.
  • Team & Project Management experience for Supply Chain and Financials teams and also for Production Support.
  • Experience in Project Management activities, preparing the project schedules and assigning the resources as per requirement.
  • Experience in managing On-site & Offshore resources for Projects and 24X7 Support.
  • Worked with multiple ERP & Database upgrades and worked closely with business teams for projects success.
  • Create and manage an overall project plan (including structure, schedule, and staffing requirements) for Oracle
  • ERP engagements and upgrades.
  • Monitor and report progress/changes to all stakeholders against the project plan.
  • Drive implementation by motivating and directing the project team, a team which may include cross functional departments, third-party vendors, partners, and the client.
  • Worked on Gap Analysis and prepared the scope documents for Optimization Projects.
  • Worked with PMO at ALCOA and provided post live reports for multiple Business Units.
  • Experience in providing 24x7 production support for Oracle Applications 11i in multi-org environment.
  • Implementation of Financial and supply Chain Modules and creation of BR.100 & BR.110 documents.
  • Functional & Technical Design documentation, which involves MD.50, MD.70, MD.120, CV.10 & TE.040 Etc.
  • Good understanding and experience with AIM Methodology and have extensively used AIM Documentations.
  • Support and monitoring of EDI transactions which include 850, 860, 855 & 810 etc.
  • Experience with AP, PO, PA, INV (Procure-to-Pay), AR and Special funds (Grants) month end close.
  • Experience with redesign and functional testing for Chart of Accounts conversion in R12 global environment.
  • Worked with cross functional & consulting teams in the assessment for R12 implementation.
  • Provided the functional and data requirements for P2P cycle as part of R12 implementation.
  • Worked closely with R12 implementation team for CRP1 & CRP2.
  • Reviewed the functional design (MD50 & BR100) docs for R12 implementation & providing the deployment support for R12.
  • Used extensively Metalink for resolving TARs and Service Requests.
  • Oracle System Administration experience includes defining users, responsibilities, concurrent programs, profile ptions, workflow monitoring and monitoring concurrent managers.
  • Extensive Experience in Production and Deployment Support for Oracle Applications.
  • Exposure to Oracle Public Sector Budgeting and Time & Labor modules.
  • Migrated all types of Objects through multiple Instances Using HP-PPM, ITG, Kintana and STAT.
  • Experience with Remedy Tool for managing the Production & Deployment Support Tickets.
  • Experience with PVCS (Version Control), RCS, Clear case, Kintana / ITG and FTP tools.
  • Worked on SOD Issues to comply SOX (Sarbanes-Oxley) standards.
  • Worked extensively with Audit teams for SOX & quarterly audits.
  • Allocate, manage and utilize resources in an efficient manner & maintain a cooperative, motivated successfulteam.
  • Good knowledge in UNIX and Windows Environments.
  • Strong leadership skills & develop objectives with goals and plans.
  • Excellent verbal and written communication skills.

TECHNICAL SKILLS:

  • Methods, Techniques and Tools
  • AIM (Oracle’s Application Implementation Methodology)
  • Agile Methodology
  • Oracle Application Object Library
  • Oracle System Administrator
  • Workflow Administrator
  • Languages: SQL, PL/SQL, JSP
  • Database: Oracle 7.x, 8i (8.1.7) / 9i (9.2.0.5) / 10g (10.2.0.4) / 11G (11.2.0.2)
  • SQL Plus / SQL*Loader
  • Oracle Discoverer 4i / 10G
  • TOAD 6.0 / 7.0 / 8.0 / 9.0 / 10.6
  • ADI / WEB ADI (Application Desktop Integrator)
  • Reports 6i / Forms 6i
  • XML Publisher
  • Remedy 4.0.5 / 5.01 / 6.0
  • Kintana 4.5 / ITG 5.5 / HP PPM 7.1
  • PVCS / RCS / VSS 6.0 / Clear Case (Version Control tools)
  • ALM (HP- Quality Center) ePrentise for Oracle EBS
  • Gentran 4.0 (EDI Software)
  • Clear Orbit 5.4, HighJump
  • Vertex (Tax Software)
  • Reflection 8.0.2 / 9.0
  • Microsoft Visio
  • Microsoft Office Suite
  • MS-Project
  • O/S: HP/UX, IBM AIX, Sun Solaris, Windows
  • Oracle Applications (ERP) Knowledge through release R12 (12.1.3) & 11i (11.5.10.2, 11.5.10, 11.5.9, 11.5.8, 11.5.7, 11.5.3):
  • General Ledger (GL)
  • Accounts Payables (AP)
  • Purchasing (PO) iProcurement (Oracle) iExpenses (Oracle)
  • Inventory (INV)
  • Projects (PA)
  • E-Commerce Gateway (EC)
  • Human Resources (HRMS)
  • Oracle Property Manager (PN)
  • Grants Accounting (GMS)
  • Order Management (OM)
  • Oracle Advanced Pricing (QP)
  • Accounts Receivables (AR)
  • Oracle Diagnostics
  • Workflow Administrator
  • Application Developer (AOL)
  • System Administrator

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Lead ERP Consultant, Oracle Applications

Responsibilities:

  • Redesign, setups and functional testing of Global Chart of Accounts for 9 countries.
  • Prepared the COA Road show and Test Plan documents for implementing COA conversion.
  • Lead the ERP Business Analysts team for SIT testing.
  • Reviewed and finalized the module test scripts and business process test scripts with business teams.
  • Monitor and report progress/changes to all stakeholders against the project plan and test plan.

Environment: Oracle Applications R12 (12.1.3), SQL, ePrentise (FlexField Software for Oracle EBS), ALM (HP- Quality Center), MS-Project, MS-Office, Oracle 11g

Confidential, Philadelphia, PA

Lead ERP Consultant, Oracle Applications

Responsibilities:

  • Responsible for Support, Enhancements, upgrades and optimization of Oracle Applications (AP, PO, iProcurement, iExpenses, GL, INV, PA) modules as per business requirements.
  • Worked with cross functional & consulting teams in the assessment for R12 re-implementation.
  • Provided the functional and data requirements for P2P cycle as part of R12 re-implementation.
  • Managing and mentoring the resources (On-site & Offshore) for ERP Support & Development team.
  • Lead the database upgrade project and coordinated testing during QA & UAT process.
  • Create and manage an overall project plans (including schedule and staffing requirements) for Oracle EBS engagements.
  • Monitor and report progress/changes to all stakeholders against the project plans.
  • Supporting and monitoring EDI process and the documents. The EDI documents include 850, 860, 855 & 810 etc.
  • Worked closely with AP, Procurement & Finance business teams and responsible for Procure-to-Pay month end close.
  • Worked closely with cross functional SAP HR & Technical (DBA & Development) teams.
  • Worked with Business and User community for day-to-day support.
  • Worked closely with R12 implementation team for CRP1 & CRP2.
  • Reviewed the functional design (MD50 & BR100) docs for R12 implementation & providing the deployment support for R12.
  • Assigning the Tasks, Service Requests and Tickets to team members and coordinating with them to resolve them as per SLA.
  • Reviewing the Functional and technical design documentation and getting approvals from Business community. Providing Functional requirements to business analysis team.
  • Worked on critical TARs for day to day business support using Metalink.
  • Resolving the Production Technical and Functional issues to meet SLA.
  • Providing the weekly status report to ERP Executive Director and making sure that the tasks are completed as per schedule.
  • Coordinating with DBAs for Instances downtime (planned & unplanned) and Cloning schedules.
  • Worked closely with QA team and Change Management & Release Management team.
  • Responsible for custom code reviews, change management approvals & migrations to Production.
  • Documentation & to User community.

Environment: Oracle Applications R12 (12.1.3) & 11i (11.5.10.2), Oracle 10g (10.2.0.4) / 11g (11.2.0.2), Oracle EPM, TOAD 10.6, SQL, Remedy 6.0, STAT 5.6, UC4, ADI (Application Desktop Integrator), WEB ADI, EssBase, MS-Project, IBM AIX

Confidential, Mahwah, NJ

Lead Functional Analyst, Oracle Applications

Responsibilities:

  • Functional support, enhancements of Supply Chain modules (PO, OM, INV & Workflow Administration) in multi-org environment (Orthopedics & Spine business units).
  • Business IT support for Purchasing and Sales departments as part of day-to-day operations.
  • Lead the projects for 10G & P6 upgrades and managed the Supply Chain functionality testing along with business teams.
  • Worked with Fujitsu team for R12 upgrade assessment as Project Leader and provided the recommendations to Management.
  • Worked with Multi-functional teams for R12 upgrade assessment.
  • Worked closely with Project Management team and reviews new requirements as part of PMO.
  • Worked with Finance business team to resolve SOX issues using ICM functionality.
  • Worked with IT-Audit teams and provides Audit reports to resolve SOX issues.
  • Functional design & scope documentation for multiple reports and extensions.
  • Worked with multiple Change controls and migrated through Instances as per business requirements.
  • Worked with 10G & P6 upgrade projects and involved in Supply Chain functionality testing along with business teams.
  • Worked with QCC (Quality Change Control) redesign process as part of IT-Quality project.
  • Optimization and redesigning of multiple BU specific custom responsibilities which helped field level employees.
  • Resolving Production Functional & business issues to meet SLA.
  • Works with Workflow Administrator for expediting stuck PO and OM transactions for day-to-day business issues
  • Worked with Developers and DBA teams to resolve system level performance issues.
  • Migrated custom objects using ITG (HP PPM) through multiple instances.
  • Worked on several TARs including SEV1 which is part of support / month end support.
  • Prepared documentation and trained users for new locations.

Environment: Oracle Applications R12 (12.1) & 11i (11.5.10.2), Oracle 10g (10.2.0.4), Discoverer 10G, TOAD 9.1, SQL, Service-Now, MS-Project, Rational Clear Case, HP PPM 7.1 (ITG / Kintana), IBM AIX (4.3.3), Windows XP

Confidential, New York

ERP Manager

Responsibilities:

  • Support, Enhancements and optimization of Procure-to-Pay and Financial (PO, AP, GL, FA, GMS, PA, iProcurement) modules as per business requirements.
  • Prepared the project schedules and mentoring the resources for optimization projects.
  • Monitor and report progress/changes to all stakeholders against the project plan.
  • Functional and technical design documentation which involves MD50 and MD70 for enhancements.
  • Changes and enhancements to set-ups which include modifications to BR.100, BR.110, etc.
  • Supporting and monitoring EDI process and the documents. The EDI documents include 850, 855 & 810 etc.
  • Responsible & worked with AP, PO and INV (Procure-to-Pay) and Special funds (Grants, PA) month end close.
  • Worked with Grants and Project Accounting modules for Special funds business team and responsible for Day-to-day support at business and user level.
  • Worked with cross functional & consulting teams in the assessment for R12 implementation.
  • Provided the business and data requirements for P2P cycle as part of R12 implementation.
  • Worked closely with R12 implementation team for CRP1 & CRP2.
  • Reviewed the functional design (MD50 & BR100) docs for R12 implementation & providing the deployment support for R12.
  • Maintenance and support of POETA (Project & ) as part of P2P process.
  • Defining Budgetary controls, Key Members for Projects as per Business team requirements.
  • Defined new Project types, Expenditure Types, Expenditure categories for 3 Business units.
  • Worked and resolved rejected PA Transactions as part of import from different sources and re-imported them.
  • Resolved Issues with Expenditures and Expenditure batches in Project Accounting as part of month end close.
  • Worked with FA business team for running depreciation and closing the FA period for multiple books.
  • Works with HR team for defining Positions, Employees and assignments in HRMS module.
  • Lead the Supply Chain and Financials team testing for 10G database upgrade.
  • Assigning the Tasks, Service Requests and Tickets to team members and coordinating with them to resolve them as per SLA.
  • Reviewing the Functional and technical design documentation and getting approvals from Business community.
  • Working on multiple Service requests and Tickets as required for the business support.
  • Working on critical TARs for day to day business support using Metalink.
  • Created PO Hierarchy and Approval Groups.
  • Working on multiple Change requests for Supply chain and Financials modules.
  • Mentoring other team members and Client in order to resolve the issues in timely manner.
  • Resolving the Production Technical and Functional issues to meet SLA.
  • Providing the weekly status report to IT Director and making sure that the tasks are completed as per schedule.
  • Interacted with user & business community to resolve issues in timely manner.
  • Worked on User level issues and resolve them in timely manner.
  • Documentation & to User community.
  • Coordinating with DBAs for Instances downtime and Cloning schedules.
  • Communicating with User Community regarding Instances availability and Issues.
  • Prepared CHP Standards Document for Oracle Applications ERP.
  • Developed discoverer and Ad-hoc reports for Finance and Supply Chain modules.

Environment: Oracle Applications 11i (11.5.10.2), Oracle 10g (10.2.0.3), Discoverer 4i / 10G, TOAD 8.0 / 9.1SQL, Remedy 5.0.1, ADI 7.1, WEB ADI, Hyperion, MS-Project, VSS 6.0, Gentran 4.0, High Jump, IBM AIX (4.3.3)

Confidential, Malvern, PA

Senior ERP Business Analyst (eIKON)

Responsibilities:

  • Worked and supported GL, AR and INV modules at Business and user level.
  • Coordinated with technical, security and infrastructure teams for major releases.
  • Responsible for the escalation and resolution of production issues by coordinating with different functional teams including Invoice Management, Customer Systems and Supply Chain Management.
  • Functional design and customization of AR programs. Re-designed AR functionalities like Multi-Ship-To & Invoice Print Flag.
  • Lead the AR Legacy Conversions for Open Invoices and Open Receipts into 11i Production Instance.
  • Prepared CV.10 for the AR legacy Conversions as per Business requirements and Oracle standards.
  • Functional and technical design documentation which involves MD50, MD70, MD120, etc.
  • Changes and enhancements to set-ups which include modifications to BR.100, BR.110, etc.
  • Responsible for AR month end business closing.
  • Designed and Created Master AR Collections custom Responsibilities which were required by 170 Collectors.
  • Worked with TARs for Production, Deployment and month end Issues.
  • Support of O2C functional Issues and resolve them in timely manner.
  • Setup parties, roles, sources and access to Service contracts.
  • Resolved stuck Orders using Workflow administrator.
  • Involved in UAT and QA instances for testing of the customizations.
  • Worked on Issues to comply SOX (Sarbanes-Oxley) standards.
  • Prepare, review and approve change requests for functionality modifications.
  • Analyze business problems; design solutions involving business process and applications.
  • Worked with Oracle support for resolution of TARs using Metalink.
  • Performed quality checks on completed tasks and deliverables. Track and report project issues.
  • Recommended new approaches, policies and procedures to effect continual improvements in the efficiency of the department.

Environment: Oracle Applications 11i (11.5.9), Oracle 10g (10.1.0.4), SQL, Remedy 5.0.1, TOAD 7.2, ADI 7.1, VSS 6.0, IBM AIX (4.3.3), Windows XP

Confidential, Pittsburgh, PA

Principal Consultant, Oracle Applications (EBS)

Responsibilities:

  • Implementation / Customization of Finance, OTC (OrderToCash), RTP (ReqToPay) Modules.
  • Functional & Technical Design and Customization of BU specific requirements and programs based on the required Operating Unit functionality.
  • Implementation of Finance Modules and creation of BR.100 & BR.110 documents.
  • Functional & Technical Design documentation, which involves MD50, MD70 & MD120 Etc.
  • Lead the production / deployment technical support team and provided weekly status to the Production Services Manager.
  • Responsible for production/development support (24x7) for Oracle Applications 11i for multiple operating units.
  • Worked with Multi-Org & Inv-Org setups as part of Implementation.
  • Resolution of production technical issues to meet SLA.
  • Worked with TARs and used Metalink extensively for Production, Deployment and month end Issues.
  • Worked with OTC and P2P teams for implementing multiple business units as per requirements.
  • Performed CRP1, CRP2, CRP3 and also prepared test cases for UAT testing.
  • Worked extensively supporting P2P modules and resolved issues at user level.
  • Implemented Price lists and supported them as per Business Units requirements.
  • Resolved stuck Sales Orders & Purchase Orders in workflow and processed them using Workflow Administrator.
  • Worked with setting up of the Master Items and assigning to Organizations in Inventory.
  • Worked with Replenishment counts and resolved day-to-day issues.
  • Performed Unit testing, integration testing with PO and OM including pricing and CRP testing.
  • Worked with Proc-to-Pay month end close for multiple business Units.
  • Responsible for system administration activities including defining users, responsibilities, concurrent programs, profile options and monitoring concurrent managers.
  • System administration tasks also included bouncing concurrent managers, Apache servers, listeners, etc.
  • Created manuals and trained super users.
  • Prepared issue documents and post-mortem reports for production outages.
  • Participated in PMO (Project Management Office) meetings for implementations and tech reviews.
  • Prepared technical standards documents as part of deployment.
  • Coordinated the offshore resources for issue resolution during off hours.
  • Responsible for planning, interviewing and selection of team members. Trained new team resources per Team’s requirements.
  • Migrated all types of objects through multiple instances using ITG 5.5 (Kintana).
  • Worked with Remedy for management of production & deployment support tickets.
  • Interacted with user community to resolve technical issues in timely manner.
  • Prepared technical software requirements for application deployment.
  • Escalated functional issues to OTC and RTP teams to resolve in a timely manner.
  • Worked with CRP, UAT and QA instances for testing of the customizations.
  • Coordinated with developers and end users to resolve day-to-day issues
  • Performed testing of the applications and raised TARs with Oracle for additional patches.
  • Worked with stuck transactions (AR, INV, and WIP) for month-end closing.
  • Other tasks included preparation of functional and technical documentation, discussions with the client regarding the proposed solution, migration strategy, unit and user acceptance testing.

Environment: Oracle Applications 11i (11.5.10, 11.5.8, 11.5.7 & 11.5.3), Oracle 8i (8.1.7), 9i (9.2.0.5), TOAD 6.0 / 7.0, Discoverer 4i, SQL, PL/SQL, SQL*LOADER, Reports 6i, Kintana 4.0 / 4.5, ITG 5.5, Remedy 4.0.3, Clear Orbit5.4, Workflow, HP/UX (11.11), Windows2000 and XP

Confidential

Oracle Applications Consultant

Responsibilities:

  • Setting up of General Ledger module & Design, development and customization of reports in GL and AR Modules.
  • Participated in creation of the set of books and defined the accounting flexfield structure, segment values, flexfield security rules and crosses validation rules.
  • Setting up and implementation of General Ledger module.
  • Customized the Past Due Invoices and Collections by Collectors AR Reports.

Environment: Oracle Applications 11.0.3, Oracle 8.0, PL/SQL, SQL*LOADER, Reports 2.5, HP/UX and Windows NT

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Customized Personnel Info Report.
  • Designed Individual Absence History Report.
  • Imported Employee, Address, Position and Assignment information from the external system into the temporary interface table using SQL *Loader.

Environment: Oracle Applications 10.7 NCA, SQL, PL/SQL, SQL*Loader, Forms 4.5, Reports 2.5, HP/UX and Windows NT

Hire Now