We provide IT Staff Augmentation Services!

Oracle Technical Consultant Resume

0/5 (Submit Your Rating)

San Jose, CaliforniA

SUMMARY

  • ERP Program Manager with 17+ years of core IT experience spanning multiple domains, technology and geographies.
  • PMP Certified since 2008
  • Currently based out of San Jose, California, USA working as Oracle EBS ERP Project Manager
  • 9+ years of onsite experience almost 5 years of which is in North America
  • Extensive experience in handling multi - million Oracle EBS upgrade, rollout and implementation projects
  • Managed projects with budgets ranging from 5-20 Million USD
  • Managed teams with maximum team size of 50+
  • Strong experience in handling end to end Oracle EBS implementation, upgrade and support projects across various business functions like Supply chain management, Financials and OTM
  • Well-versed with Oracle AIM and OUM Methodologies
  • Strong functional expertise in supply chain and financial modules of Oracle EBS including following modules - Purchasing, Accounts Payables, iProcurement, Cash Management and Property Manager
  • Experience includes requirements gathering, preparing setup, business requirements documents, functional design documents, technical design documents, writing system test cases, data migration, assisting in user acceptance testing
  • Upgrade experience includes involvement in upgrade planning, formulating data conversion strategy, data migration strategy, instance strategy, testing strategy, production cutover strategy and end user training strategy
  • Expertise in working closely with business to under their requirements and map those requirements with Oracle EBS functionality
  • Strong hands-on experience in Oracle EBS and Peoplesoft ERPs
  • Strong hands-on experience in Oracle SQL, PL/SQL languages
  • Strong experience in team management, schedule management, risk management, cost management and overall project integration management
  • Strong understanding of various test phases like Unit Testing, System Integration Testing, Performance Testing, Regression Testing and User Acceptance Testing
  • Worked in multiple SDLC lifecycle projects
  • Very good understanding of ISO and CMMI level-5 practices.

TECHNICAL SKILLS

Front End Tool: Oracle Developer 2000 (Forms 10g/6i, Reports 10g/6i), Oracle Apex

RDBMS: Oracle 11g/10g/9i/8i

Languages: SQL, PL/SQL, UNIX Shell Scripting

Database Tool: Toad, PL/SQL Developer, SQL Developer, SQL*Loader

Application Server: Oracle 9iAS/10gAS

Configuration Management Tool: PVCS, MS VSS

Designing/Other Tool: MS-Visio, MS-Office

Operating Systems: Windows, UNIX, Linux

ERP Package: Oracle EBS 10.7 to 12.1.3, PeopleSoft 7.53

ERP Modules: iProcurement, Purchasing, Accounts Payables, Property Manager, Cash Management

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

Oracle EBS Upgrade (11.5.10 to R12) Program Manager

Responsibilities:

  • Program/Project Manager for multi-million Oracle EBS upgrade (from 11.5.10 to R12) signature program
  • Overall responsible for the project planning, costing and schedule
  • Ensure compliance to Oracle AIM Methodology
  • Involvement in formulating and implementation of key strategies around data migration, code retro fitment, various rounds of testing, cutover and normalization support
  • Stakeholder management including working with key owners from various cross flow and boundary applications interacting with Oracle EBS
  • Functional reviews of MD50s, test plans
  • Managing deliveries from both onsite and the offshore teams
  • Responsible for management of change requests in terms of their evaluation, customer approval and incorporation
  • Regular Reporting to client and company senior management on project progress, risks and issues
  • Providing technical and functional support to the team
  • Responsible for Customer satisfaction and SLA reporting and adherence

Environment: Oracle EBS R12, Oracle 11g

Confidential, Houston, Texas

Oracle EBS Functional Program Manager

Responsibilities:

  • Program Manager for Oracle EBS rollouts and application enhancement development work for following Oracle EBS modules - Oracle Financials (Accounts Payable, Account Receivables, Fixed Assets, Cash Management and General Leader, Projects), Oracle Projects Billing, Oracle Projects Billing, Oracle HRMS Modules
  • Overall responsible for the project planning and schedule
  • Ensure compliance to Oracle AIM Methodology
  • Involvement in customer R12 upgrade planning
  • Directly responsible for managing enhancements and issues in purchasing and accounts payables modules
  • Stakeholder management including working with Oracle On Demand for any database related issues
  • Functional reviews of MD50s, BF16s and TE40s
  • Managing deliveries from both onsite and the offshore teams
  • Responsible for management of change requests in terms of their evaluation, customer approval and incorporation
  • Management of rollout and development team
  • Regular Reporting to client and company senior management on project progress, risks and issues
  • Providing technical and functional support to the team
  • Responsible for Customer satisfaction and SLA reporting and adherence

Environment: Oracle EBS 11.5.10.2, Oracle 11g

Confidential

Oracle EBS Program Manager

Responsibilities:

  • Program Manager for implementation of following Oracle EBS modules - Oracle Financials (Accounts Payable, Account Receivables, Fixed Assets, Cash Management and General Leader), iStore, ASCP, Configurator, WMS, Order Management, OTM
  • Responsible for upgrade of following from current versions to next versions - OTM 5.5 to OTM 6.2, Oracle EBS 11.5.10.2 to Oracle R12, Oracle DB from 10g to 11g, BPEL 10g to BPEL 11g
  • Overall responsible for the project planning and schedule
  • Review of functional deliverables like MD50s and BR100s
  • Directly responsible for managing implementation of purchasing and accounts payables modules
  • Participation in To-Be discussions as well as CRP sessions
  • Ensure compliance to Oracle AIM Methodology
  • Managing deliveries from both onsite and the offshore teams
  • Responsible for management of change requests in terms of their evaluation, customer approval and incorporation
  • Stakeholder management
  • Management of implementation and upgrade teams
  • Regular Reporting to client senior management on project progress, risks and issues
  • Providing technical and functional support to the team

Environment: Oracle EBS 11.5.10, Oracle 11g, Oracle PL/SQL, TOAD, SQL*Loader, PVCS, UNIX, Putty

Confidential

Oracle Program/Project Manager

Responsibilities:

  • Played program and project manager roles for Oracle EBS, JDE ERPs, Oracle BI, MSBI and associated integration, Oracle Database and Middleware and third party apps
  • Managed delivery teams located at various geographies
  • Directly responsible for enhancements in purchasing and accounts payables modules
  • Involvement in customer business transformation projects
  • Responsible for delivering the agreed delivery SLAs around discretionary and non-discretionary work
  • Involvement in senior management reviews both at customer and self-organization level
  • Driving and managing ITIL processes within the delivery team
  • Responsible for delivery Customer satisfaction across various facets of delivery
  • Escalation point for delivery of services
  • Engagement with both customer IT and the business units to build positive relationships
  • Providing technical and functional support to the team
  • Change requests evaluation and incorporation
  • Prepared document for deployment of CRs, Defects, and Merges.

Environment: Oracle EBS 11.5.9, Oracle 10g, Oracle Discoverer, Oracle PL/SQL, UNIX, Putty

Confidential, Webster, NY

Oracle EBS Techno-functional Project Lead

Responsibilities:

  • Overall responsible for working on defects, incidents and enhancements in iProcurement, Accounts Payables, General Ledger modules
  • Lead techno-functional analyst for P2P modules for application upgrade from 11.5.7 to 11.5.9
  • Responsible for coordinating both the onsite team and offshore team for above modules
  • Responsible for management of change requests to the project
  • Reporting to customer management
  • Providing functional and technical support to the team
  • Resolve queries after discussions with Xerox
  • Helping the team in prioritization, analyzing and resolving functional and technical incidents and problems related to Oracle iProcurement, Oracle Purchasing and Accounts Payables modules
  • Involvement in implementation of the approved set-ups and configuration changes
  • Helping in analysis, design and development of the components required to resolve the assigned enhancement requests
  • Review, walkthrough of documents / programs as part of internal QA
  • Set up test data /scenario as required for testing the resolution of the issues
  • Prepare weekly reports and communicate to Xerox team

Environment: Oracle EBS 11.5.9, Oracle 9i, TOAD, Oracle PL/SQL

Confidential, Columbus, Ohio

Oracle Techno-functional Consultant

Responsibilities:

  • Following AIM Methodology for implementation of PO and AP modules
  • Involvement in As-Is Analysis
  • Preparation of MD50, MD70, BR100 Documents
  • Data Mapping
  • Preparation of Functional Design Documents
  • Preparation of Technical Design Documents
  • Development of Custom API using PL/SQL
  • Preparation of unit test plans
  • Unit, System and Integration Testing

Environment: Oracle Apps 11.5.9 (iProcurement, PO, AP, GL), Oracle 10g, PL/SQL, TOAD, PUTTY

Confidential

Oracle Functional Consultant

Responsibilities:

  • Lead functional consultant for following ERP implementation modules of Oracle 11i e-business suite - Purchasing, Accounts Payables, Property Manager and Cash Management
  • As-Is Analysis, documentation of existing business flows
  • To-Be Analysis, documentation of future business flows
  • Customizations (Functional Design/Technical Design, Unit Testing, Integration Testing)
  • Participation in Conference Room Pilot with key business users
  • User Acceptance Testing
  • End User Training
  • Data Migration
  • Go-Live and Post implementation support

Environment: Oracle Apps 11.5.9 (iProcurement, PO, AP, PM, CM), Oracle 9i, PL/SQL, TOAD, PUTTY

Confidential

Peoplesoft Techno-functional Consultant

Responsibilities:

  • Lead techno-functional analyst for expenses and accounts payables modules of Peoplesoft
  • Prepare low level design documents for new enhancements
  • Fix production defects in production for above modules
  • Assist users in resolving business critical issues during month ends
  • Assist users in UAT for enhancements
  • Co-ordinate between onsite and offshore teams
  • Prepare weekly status reports on the issues fixed and enhancements worked upon for the mentioned modules
  • Problem management to find root cause and fix for recurring issues
  • Co-ordinate with customer change and release management team to put fixes in production
  • Develop data and code fixes
  • Preparation of unit test plans
  • Unit, System and Integration Testing as needed

Environment: Peoplesoft 7.53 (Expenses, Accounts Payables)

Confidential, Columbus, Indiana

Oracle Techno-functional Consultant

Responsibilities:

  • Lead techno-functional analyst for purchasing, accounts payables and general ledger modules of Oracle
  • Prepare low level design documents for new enhancements
  • Fix production defects in production for above modules
  • Assist users in resolving business critical issues during month ends
  • Assist users in UAT for enhancements
  • Co-ordinate between onsite and offshore teams
  • Prepare weekly status reports on the issues fixed and enhancements worked upon for the mentioned modules
  • Problem management to find root cause and fix for recurring issues
  • Co-ordinate with customer change and release management team to put fixes in production
  • Develop data and code fixes
  • Preparation of unit test plans
  • Unit, System and Integration Testing as needed

Environment: Oracle Apps 10.7, Developer 2000, TOAD, PL/SQL, Putty

Confidential

Oracle Technical Consultant

Responsibilities:

  • Worked in custom application development to develop a mini ERP system for customer
  • Analyze requirements and document/update SRS (system requirements specifications) document
  • Prepare high level design documents for advertising, sales and sales accounting modules
  • Prepare low level design documents
  • Development using PL/SQL and Developer 2000 (Forms and Reports)
  • System Testing
  • User Acceptance Testing support
  • Data migration from legacy system to new system

Environment: Developer 2000, TOAD, PL/SQL

We'd love your feedback!