SUMMARY:

• Over 15 years of domestic and international work experience in Oracle applications (11i and R12) as Functional, Techno - Functional, and lead Consultant in providing solutions for support and implementation
• An accomplished professional with relevant multifunctional expertise across ERP implementation and client management.
• Proven expertise in Finance, iExpense and Oracle Projects. Design and work around solutions for various business requirements
• Experienced in Solution, interfacing and addressing queries raised by clients/customers/Business users and ensuring satisfactory resolution and customer delight
• Experience in leading teams at onsite/offshore, Supporting UAT and post production.
• Experience conducting CRP session, Issue Resolution and Fit Gap analysis.

CORE COMPETENCIES:

• Business/Functional Consulting
• ERP Implementation - End to End
• Expertise in Client Interaction
• Project Management
• Team Management - Offshore /Onsite
• Management/ Financial Reporting
• Planning & Risk Mitigation
• Observation & Analytical skills
• Excellent Financial, iExpense and Projects.
• Good knowledge on Purchasing Inventory and Manufacturing domain.
• AIM Methodology
• Leadership

TECHNICAL SKILLS:

Oracle EBS : Oracle R12, 11i, 11.5.10.2 and Toad

Oracle Application Finance Modules: Oracle Receivables (AR), Payables (AP), General Ledger (GL), Cash Management (CE), Fixed Assets (FA), Trade Management (OZF), SLA

Concepts, AGIS (Intercompany), Projects (PA), Grants (GMS), iExpense,:

Report Manager, Vertex and Mark view:

Oracle Application Operations Modules: Oracle Purchasing (PO), Inventory (INV), Costing (CST) Order Management (OM), OTM, CRM applications .

Quote, Service, Costing, Oracle Sales and Marketing, WMS:

Oracle Application Manufacturing : BOM and WIP

Oracle Application Foundation Modules: AOL and SYSADMIN

OS Environment: LINUX, UNIX, HP-UX, AIX, LINUX, Sun® Solaris

AIM Methodology: CV10, CV60, TE40, BR100 BR110, MD50, BR10, BR030

Oracle EBS Phases: UAT, SIT, Project GO-NO Go, Oracle SR resolution

Migration Tools: Kintana, MKS, CVS, Winscp, Putty and Stat

Oracle DB: Oracle 10g, 11g, 9i and 8

COMPETENCY:

• Design standards (Custom Schemas, Custom Objects, RICE Templates, Documents) for ERP Project implementation
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Understand and modify Application Configuration as required (includes system setups, flex-fields, workflow builder, custom library, zoom functionality, profile options, Form customization, etc.).
• In-depth knowledge of Oracle Application Architecture and technical development tools
• AOL and System Administrator by creating the custom Menu and Responsibilities (SOX Compliance) for new implementation
• Successfully handled end to end implementation cycles fromDiscovery, Business Process Analysis, Process Redesign, Gap Analysis, solution, Configuration and testing. Implementation specifically in the High tech, Distribution and Discrete manufacturing vertical for Fortune 500 companies
• Expert level knowledge in all Oracle Financials, Oracle Projects and iExpense
• Good Knowledge on Financial integration modules like Purchasing, Inventory, Order Management, BOM, WIP, Oracle Grants, Contract and Service modules
• Vast experience in multi country implementations, support, rollouts and upgrades.
• Expertise in Requirement Analysis,Business Process Mapping,Business Process Analysis,Feature requirement analysis,Gap Analysis,Requirements elicitation,Business Impact analysis, As-Is Process Mapping,To Be Process Mapping,Problem simulation,Application Implementation,Integration Testing,System Testing,User Acceptance testing,Documentation,Production Support,Troubleshooting,Co-ordination with Oracle for Issue resolution. Custom solution designing. Coordination with Technical team, testing of custom enhancements for pre and post deployment.

PROFESSIONAL EXPERIENCE:

Functional Lead Consultant

Confidential, OH

Responsibilities:

• Gathered business requirements for Oracle Financial modules which includes AP, AR, GL, PA and iExpense
• Design the process diagrams; Conduct a system validation session with Business owners. Understand the business process, configure system setups and prepare Configuration Document (BR100), Month End Close Process, Test Script and User Manuals for Oracle Projects and Finance modules.
• Create and maintain OU, LE, Project Organization, Banks, COA, Cross Validations, Security Rules, PA and AR Auto accounting, Sources, Transaction types, Intercompany and Trade Customers
• Configure the Oracle Applications Setups to meet business requirements for GL, Oracle Projects, iExpense, AR and AP
• Design and implement solution for Account Generator for AP Supplier Invoice and iExpense Invoice related to Project Expenditures. Configure and setup for Bill rate and cost rates for Oracle Project in Costing and Billing. Setup and execute Integration of Costs to projects and Revenue to AR. Worked on Receivable AR Invoice and Receipts.
• Identified and implemented CEMLIFinance objects in R12 and showcased the business with AS IS working process
• Design, Configure and implement iExpense System and integrate to projects for Cost and Billing.
• Worked on POC for GL 4-4-5 to Fiscal Month, PA Expenditures and COA mapping.
• Design and implement Periodic and Event Alerts for AR and PA modules. AOL setups like DFF, Profiles and request set scheduling.
• Worked on RICEW objects for the AS-IS Process to work for ENP Business.

Lead Consultant

Confidential, MN

Responsibilities:

• Gathered business requirements, participated in setups & implementation and test scenarios for Oracle Financial modules
• Redesigned Pre Auto Invoice solution as a Global solution for Confidential Business units. Worked on F it Gap Analysis . Gathered requirements through various meeting/discussions/workshops .
• Design and solution for Product Code segment derivationfor COGS. Setup Category set and Category Accounts for COGS account of product code segment derivation. Derivation of Product code segment for PO, BOM and WIP transaction.
• Configuring Financial Setups and EPM Global solution for IR ISO and Factory Direct design. Design need to calculate the transfer price for a cost at the Intercompany Transactions.
• Solution, Design and implementation for Deferred COGS in SMMC Business unit which is as part of EPM global solution.
• CRP sessions, testingfor End to End process and resolving issues created from Finance Business Lead and users.

Confidential, Denver, CO

ERP Functional Analyst

Responsibilities:

• Configuring various finance and iExpense project. Design, Solution and implementation for Automation of Financial Month End Close Process (Pre closer, Closer and Post closer)
• Custom solution and prepare Functional Requirement Specifications documents (Data Migration, Customization, Interfaces and Reports)
• Finalizing the setups and configuration of the instance to meet requirements. Designed and executed several Projects, extensions, customizations in Oracle ERP as part of Revenue Recognition solutions. Projects include Blind Agency, Revenue and Cost Recognize by Location segment, FreightClassification and Sold to Location. Designed a solution for REV COGS report to excel upload functionality for Finance team for Revenue and COGS Reconciliation (Average Cost)
• Analysis, Design, Configure, Implementation and support for iExpense system which includes Integration with Amex transactions, HR data feed from Workday, Mark View and Account Payables. IExpense system is implemented with Requirement gathering, Business Process flow, Interaction with other vendors and Training.
• Design and Interaction application data with external sources like Banks (Lock Box Data/Stuck,Credit and Debit Card payment, NACHA File Data), Amex (Employee Expense Transactions),AR Collectors, Vertex, Oracle (SR for Critical Issue Solution), D&B, Web Method EDI team and CGI (AR invoice printing)for Cash flow and data Interfaces forbusiness issue resolutions.
• Setup, Design, Implement and Troubleshoot for GL, AP, AR, FA, Trade Management, PO ( Drop ship and Intercompany Functionality ), Credit Card payments /setups in Receivables, iReceivables and iPayment.
• Automation and Redesign for PO Receipts and AP Invoice Processes
• Setup, Monitor and troubleshooting for GL, AR and AP transactions. Creation and maintain of GLAccounting Flex field values, Security and Cross Validation Rules, Auto Post Criteria set, Rollup Groups and Recurring Journals
• Responsible resolving for all critical business process issues and also recommend improvements for the business process
• Setup and Monitor for Oracle Project Billing for Services provided.Coordinating with development team for development and testing of custom components
• Extensive testing of data migration components to ensure accuracy. Writing SQL queries on TOAD to address requirements for data-analysis, Fix and Reconciliation
• Preparation of Test scripts and conducting post go-live support, Business/ User training and ensuring smooth period closure
• Proactive monitoring of interfaces to minimize number of exceptions (Revenue and Cost Recognition)
• Management reporting on support tickets movement, nature of issues and timely identify the root cause and resolution

Lead Consultant

Confidential, Atlanta, GA

Responsibilities:

• Analyzed previous Claim system of Rheem and designed a New Custom Extension solution which is interfaced to Oracle Trade Management (Claims), Install Base, Service Contracts and Finance. The solution is implemented with custom objects, which integrates with Oracle Inventory and Finance (AP and Trade management). This extension solution involved design of several ADF custom forms with complex business logic.
• Involved in study of existing business process, Identify the required GAPs. Data Mapping, Design and create BRD, Functional, Technical and data flowfunctionality for custom identified Gap process.
• Responsible for RICEW (Data Templates, Data Mapping, and Business Validations) objects solution for Finance and PO and Inventory modules. Identified the Gap and Designed Functional designdocuments and solutions.
• Finalizing the setups and configuration of the client instance to meet client requirements for GL, AR Receivableand AP Account Payables Setups.
• Creation and maintain of GLAccounting Flex field values, Security and Cross Validation Rules, Auto Post Criteria set, Rollup Groups and Recurring Journals
• Understand and modify Application Configuration as required (includes system setups, flex-fields, workflow builder, profile options etc.).
• Developing functional specifications for custom enhancements & coordinating with technical team for final deliverables
• Setup, Monitor and troubleshooting of GL, AR, PO and AP modules.
• Managing offshore team, load balancing and team allocation on deliverables and issue resolution
• Finalizing the New setups and configuration of the client instance to meet client requirements
• Coordinating with development team for development and testing of custom components changed due to Upgrade.

Confidential, Mansfield, OH

Lead Consultant

Responsibilities:

• Involved in all the process of Confidential project starting from Analysis to Confidential . This project included with modules like Finance, Inventory, Purchasing, CST, OM, BOM and WIP.
• Presentations to client to explain Oracle new architecture and flows
• Responsible for Test integrity,Data Conversions, Interfaces, customizations to ensure no overrides for Oracle 11 migration.
• Finalizing Design and conducting detailed discussions for Solution forRICEW custom components
• Finalizing the New setups and configuration of the client instance to meet client requirements
• Managing Deliverables, Milestones, Resource Planning & Work Allocation for onsite and offshore.
• Preparation of CRP scripts and demonstrating Oracle flows to the client
• Discussions with client team to understand roles and responsibilities in the organization to design Menus in the System Administration module to meet the SOX requirements
• Responsible for Migration strategies (PVCS and Kintana) and cutover planning for UAT and Confidential
• Extensive testing of data migration components to ensure accuracy
• Responsible for Revenue and Cogs reorganization

Confidential, Boca Raton, FL

Techno Functional Consultant

Responsibilities:

• Conducting detailed requirement analysis and preparing the Fit-Gap Analysis documents
• Finalizing Design of the implementation and conducting detailed discussions for development of custom components
• Preparing Functional Requirement Specifications documentsfor Approved Supplier List (ASL), IR ISO and Item master and Cost Conversion and Interface.
• Finalizing the setups and configuration of the client instance to meet client requirements
• Coordinating with development team for development and testing of custom components
• Extensive testing of data migration components to ensure accuracy
• Preparation of CRP scripts and demonstrating Oracle flows to the client
• Co-ordination with Oracle support for issue resolution
• Proactive monitoring of interfaces to minimize number of exceptions
• Developing functional specifications for custom enhancements & coordinating with technical team
• Writing SQL queries on TOAD to address client requirements for data-analysis, audit
• Testing of custom enhancements pre-deployment& validation of components

Confidential, NY

Associate Consultant

Responsibilities:

• Configuring various finance and project modules
• Conducting detailed discussions for development of custom components
• Preparing Functional Requirement Specifications documents (Data Migration, Interfaces and Reports)
• Coordinating with development team for development for all RICE custom components
• Managed as well as participated in cross-functional (Mainframe and Legacy) teams from task initiation through task completion.
• Interaction with Domain managers to understand the requirements and convert design document into a IT solutions Conducting
• Co-ordination with Oracle support for issue resolution
• Functional Support for Oracle issues in Production Environment
• Proactive monitoring of interfaces to minimize number of exceptions and also help in analysis and approval of data-fixes and patches
• Manage team at Onsite and Offshore and responsible for all deliverables

Confidential

Project Lead

Responsibilities:

• Configuringsetups various finance and project modules
• Preparing Functional Requirement Specifications documents for Oracle Projects, Purchasing and iProcurement modules. Finalizing the setups and configuration of the instance to meet client requirements
• Designed Functional solution for custom payroll forms (Integrates Oracle Project (PA), HRMS and Custom tables) for breakup of HR details by Project, Department and Business Unit
• User Training/ Support/Maintenance and enhancements.
• Responsible for Design and build Interfaces, Development, Customization and Production Support
• Point of contact for Oracle Application business and IT issues

Confidential, Tulsa, OK

Techno functional Consultant

Responsibilities:

• Interacted with Technical Lead and after discussion, devised a standard Template Design for custom module (Expense Distribution) in the project. The idea was appreciated by the Technical Manager.
• Knowledge transfer to support/maintenance team with complete concepts and evolution of the project.
• Responsible for all the deliverables related to the Expense Distribution Module
• Techno functional support for users with thorough inputs for perfect configuration and clean Sign-off.
• User Training/ Support/Maintenance and Production Support of Oracle Apps Project.

Confidential, Troy, MI

Technical Consultant

Responsibilities:

• Worked as an on-site coordinator/ Team Lead and was involved in the Technical Design, Development and Knowledge transfer to offshore consultants.
• Interaction with Domain managers and understand the requirements.
• Managed as well as participated in cross-functional (Mainframe and Legacy) teams from task initiation through task completion (INV Item Master, PO Master, Receipts, Supplier Invoices Data Interfaces from Oracle Apps to Mainframe.
• Designed and developed API for mobile devices which call Move Order and Material transactions (Issue and Receipts).
• Modified and Updated Scripts (Interfaces-Material Transactions) / Forms and Installation scripts) for final deliverables.
• Responsible for all the deliverables for technical design, AID, UTP, Customization, Conversions, Scripts and Reports.
• Resolved technical and data issues and made enhancements for the technical design.
• Worked as production support for (Job A bends/ Data issues/ Code changes and migration to production

Confidential, Chicago, IL

Technical Consultant

Responsibilities:

• Led a team of off-shore Developers based in India from Client-site at Chicago
• Analysis and Design and developed Technical Specification for Development of Oracle Projects Reports.
• Designed and developed Interfaces for Oracle Projects, Grants, and PO and AR-Customer data.
• Expertise in Oracle Projects and Grants Module.
• Designed and developed deliverables for technical specifications/ UTP/Interfaces scripts and Reports.
• Post implementation support for Confidential .
• Designed and developed Interfaces and Conversions.