Oracle Technical Consultant Resume
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