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