PROFILE:

• Overall17 years of IT experience with 13+ years of progressive experience as a Senior Functional consultant in implementing, configuring, supporting designing Oracle EBS and effectively leading the Full Life Cycle implementation processes. Strong record of success in providing end - to -end Oracle business solutions for many Global organizations. Proven ability to bring the benefits of industry knowledge to solve business process issues while balancing the costs and risks involved. Led teams in both development and deployment of new customer acquisitions
• Hands on experience in P2P, O2C and R2R process stream across Oracle E-business suite (11i/ R12.1.x, 2.x and Oracle cloud/Fusion Financials 11.1 and OBIEE/Reporting.
• Full understanding of the Oracle Financials Accounting Hub (FAH).
• Experience in Supporting EPMA (Hyperion Financial Management and Hyperion Planning).
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials including General Ledger (GL), Account Payables (AP), iExpense, Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax), Vertex, Purchasing (PO), Channel Revenue Management, Account Receivables (AR), Advance Pricing, Inventory, Service Contracts, Oracle Project Costing and Oracle Project Billing.
• Experience in successfully leading all phases of diverse ERP projects (Oracle EBS) and Product Management; Experience with full ERP rollout, financial analysis to include utilization of ROI, net present value (NPV) and IRR; Proven ability to manage multiple projects to consistently meet deadlines and the associated business value.
• Expertise in Oracle Applications performing 5+ end to end implementations, 2 Upgrade and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing,, Cut off, Go-live and Post-Implementation Support.
• Hands on experience in design; development of Functional QC Test Strategy, Test Plans. Involved in all standards ERP SDLC activities like Business & Functional design, business analysis, process design, system integration Functional Testing, System Integration Testing, User Acceptance Testing, Preparation of material, and conducting actual User testing.
• Good understanding/conceptual knowledge of Change Management, Change Strategy, Change Measurement, Culture Change, and Business readiness, Stakeholder Management, and Communication Planning and Delivery.
• Well experienced in testing all the Custom objects i.e. CEMLI objects along with the other systems.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C) and Sub-Ledger Accounting (SLA).
• Good understanding of the menus, functions, concurrent programs, request groups related to ERP Security
• Setup Application Security using RBAC feature and UMX module.
• Hands on experience on Oracle System Administration functions and Oracle User Management setups.
• Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and developed Financial Statements (FSG’s) as per Business Requirement.
• Strong understanding of HRMS business flows. Actively involved in implementing various modules in HRMS including Oracle Compensation Workbench, Oracle Payroll, Oracle Time and Labor (OTL), Oracle iRecruitment, Oracle Learning Management and Oracle Self Service Human Resources (SSHR)
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle.
• Experience in maintaining documentation and using the Application Implementations Methodology (AIM) and OUM, which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BP 80,RD20, BR30, BR 100, BR 150, MD 50, CV 40 &TE 40)
• Expert in creating SR’s with Oracle Technical Support, coordinating and following on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Conducted CRP’s and provided wide range of functional to multiple business user groups and co-ordinate UAT sessions.
• Experience in writing SQL queries to extract data to validate transaction status
• Proficient in Finance Data Model and Transaction Process Flows.
• Deep understanding of multi-org, multi-country, multi-currency specific setups and dependencies in Oracle R12 systems.
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open items.
• Experienced in PMBOK, Waterfall, Test-Driven Design, and Agile Project Management Methodologies .
• Excellent communicator; leverage technical, business and financial acumen to communicate effectively with executives and their respective teams.

SKILLS:

Oracle Fusion Financials: 11.1.1.3( AP, GL, AR,CE, FA) and Fusion Accounting Hub, OTBI, Oracle ERP Oracle Financials R12.1.3, R12.2.4 &11i - GL, AP, AR, CE, FA, E-B Tax, SLA, Financials Accounting Hub, Vertex Q Series, AGIS, PO, Cost Management, Inventory, ASCP, iExpense, Fusion expenses App for iExpense, iSupplier, Sys Admin, SLA, P2P, O2C and Oracle Projects (Costing, Billing and Project Management)

Oracle HRMS: Oracle Payroll, OTL, SSHR, I Recruitment, Compensation Workbench

Other Tools: Web ADI, ADI, Toad, Data Loader, Discoverer, OBIE, SQL*Loader, SQL*Plus, OFSAA, Hyperion Financial Management and Hyperion Planning 11.1.2.2, FDMEE, ESSBASE, Confidential View

SYSADMIN: RBAC Implementation, UMX wizard setups, User Management, Identity Manager UNIX, Linux, Windows.NET/2000/XP, Windows98 Developers/2000, Developer 6i,9i, SQL, PL/SQL, Java, Xml publisher, Work Flow, JSP, Business Intelligence and Business presentation layer, Jdeveloper, OAF, ODI, Informatica. Oracle Web DB, 9iAS Portal, Apache etc, MS Office, MS Project, WEBADI, SQL Developer, Oracle Report Manager, TOAD, (AME) Approval Management Enterprise, FSG, MS SharePoint, INSIGHT, Oracle DBI, Discoverer, SQL Developer, HP Load runner, Jdeveloper, OAF.

Internal: PMP Project management framework, Six Sigma, SCRUM/SLIM Agile Methodologies, AIM Methodology, SOX etc.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Systems Analyst | Project lead

Responsibilities:

• Involved in multiple on-going concurrent projects aimed at increasing business process efficiencies (scope includes operational and back end support processes).
• Rollout of R12 Modules (P2P / O2C) for new entity - Seattle.
• I Expense Implementation Company wide along with Fusion expense Mobile app.
• Production Support of existing R12 footprint, OBIIE and Hyperion Applications support
• Involved in setting up Fusion Financials applications for Canadian entity.
• Assisted in analysis, design, modeling, testing and implementation activities by providing guidance and recommendations for process enhancements and efficiencies for the modules within the Oracle ERP suite of applications.
• Interacted with business and analyzed existing business practices, Prepared and maintained business requirement gathering documents BR 100, BR 30, functional extension and design document MD 50 using AIM Project Methodology.
• Collaborate with team to assess current processes and identify process improvement opportunities through the collection of facts and data.
• Worked with client to develop business solution designs that achieve business requirements. Assisted in documenting and performing application set ups according to project plan.
• Created Change Management Strategy including the approach required to manage the change associated with the deployment of the Solution.
• Developed Communications Strategy and Plan and identified risks and issues associated with changes and develop mitigation plans in collaboration with Project Manager.
• Outlined all change management activities and associated dependencies on other project activities in the implementation plan and delivered communications to the business based on the Communications Strategy and Plan.
• Carried out operational analysis (AS-IS), solution design (TO-BE), Building Stage along with functional configuration of complete P2P/O2C modules for US entity -Oracle GL (General Ledger), AP (Accounts Payable), AME, E-B Tax, Vertex Q series, Fixed Assets, AR (Accounts Receivables), Order Management, Advance Pricing, ASCP, Cash Management, iProcurement, Oracle Purchasing, Procurement contracts, P-Card, Oracle Inventory, iSupplier and I Expense.
• Tracked the status of requirements throughout the project lifecycle, and redefining them as necessary.
• Performed a leadership role in defining business requirements and identifying application best practices at for the organization.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Communicated technical concepts and information to non-technical audience and communicated business information to technical audience.
• Coordinated CRP’s, UAT and Go Live schedule as per the project plan and contributed to cut over task list.
• Collaborated with 3rd party vendors consistently by delivering quality solutions, on time, within budget.
• Performed Functional configurations like - COA Structure, LE, Primary Ledgers, Secondary Ledgers, Reporting currencies, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies,
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Setting up legal entity, business group and operation unit using ASM.
• Setup and configured Oracle AGIS to ensure the global operation was able to have better control for intercompany transactions. Used clearing company.
• Setup AP payable system options, financial options, payable options, suppliers and operating units.
• Defined Invoice attributes, payment attributes - Approve, hold and release, special calendar, payment formats, pay group, payable document.
• Worked in Payment process profiles, defined banks, bank accounts using UMX wizard & documents.
• Setup CE and auto reconciliation process in CE which includes Auto import and reconciliation of bank statement Bank file integration/mapping.
• Setup iSupplier and P-Card / iProcurement related to P2P business stream.
• Created, submitted and Tested Different Purchase Requisitions, Catalog/Non-Catalog, Inventory, Expense, Capital, Professional Services and approved it using iProcurement and its Notifications
• Created and Tested Standard Purchase Orders and Approved it and Printed it. Created Automatic and Manual Purchase Orders and Blanket Purchase Agreements and Blanket Release for Procurement. Matched/ Quick Matched to Purchase Order Shipments/Distributions.
• Performed all Agile and waterfall Project Management Activities.
• Helped clients with Month end closing.
• Conducted Service Advisory Committee Meetings between all Business Unit heads for discussing on the upcoming projects and new Enhancements. That way we partner with business users to prioritize changes, set expectations and ensure alignment of the team’s work with business demand.
• Tracked the status of requirements throughout the project lifecycle, and redefining them as necessary.
• Contributed to contract negotiations and finalizing on terms for the project and implementation requirements with 3rd Party Vendors.
• Implemented iExpense and AMEX credit card Company wide for Canada and US. This includes all Employee creation, Profile options, signing limits, Expense Templates and approval workflow setup.
• Collaborated with DBA to deployed patches for Fusion Expense App to work with existing R12 release for Expense Entry and approval.
• Implemented E-Business Tax for Canadian provinces and Vertex Q series for US entities.
• Involved in Implementation of O2C Modules (Inventory, Purchasing, Order Management, Advance Pricing, Service Contracts, iStore) on R12 for new Entity - Seattle. Collaborated with offshore Team and monitored progress of development, testing and implementation of enhancements like (Delayed Invoicing, UCP Point etc.) as per the expanding business requirements.
• Automate revenue recognition for sales arrangements with 3rd party vendor UCP Point to determine the value of individual services sold in order to recognize partial revenue before the entire contract is fulfilled.
• Integrated Order Management with Depot Repair to create RMA and Sales Orders, validate customer accounts and invoice customer repairs.
• Setup Service Contracts to OM/ AR interface.
• Configured Internal Sales order/Internal requisitions process to establish simplified Intercompany sales across operating unit.
• Performed all the setups in relation to Order Management Module.
• Configured Oracle Advance Pricing Module for Price list security per Operating unit.
• Involved in ASCP implementation - Confidential ’s Data collections (items, BOM, on-hands, sales orders, purchase orders and receipts etc.) for short term detailed and long-term aggregate Planning.
• Configured RBAC roles using User Management and responsibilities, menus, functions, concurrent programs, request groups.
• Implemented Oracle Enterprise GRC and use it as a SOD tool for ERP application modules like Financials and HRMS
• Work with auditors from KPMG and Deloitte on SOX audits.
• Worked on Reporting Tools like Discoverer, XML/BI Publisher, ETL and OBIEE.
• Monitored and troubleshooted quarterly ETL loads - Sales Budget Load, OPEX Budget Load, Sales Target Load
• Gathered business requirements and collaborated with the team to develop dashboards for subject areas -Sales - Order Process, Confidential Sales - Invoice Distribution Lines, Financials - GL Detail Transactions, Financials - AP Transactions and collaborated with team.
• Responsible for managing Hyperion production environments (Hyperion FM and Hyperion planning), applications, upgrades, gap analysis and enhancements, bug fixes.
• Implemented a companywide product and cost center reorganization for Hyperion Planning and Financial management in collaboration with third party vendor.
• Verifying data and metadata loads on a daily basis.
• Troubleshooting issues in data and metadata loads.
• Working with Oracle support to solve running issues.
• Load Metadata in Hyperion Planning using outline load utility.
• Troubleshooting data calculation issues in Hyperion Planning.
• Provided security reports and provisioning users/groups.
• Execute ad-hoc data and metadata loads
• Created and modified existing BR's and Calc. scripts as per customer requirements.
• Administer the Hyperion Essbase environment running on Linux with multiple applications employing BSO, ASO, partitioning technologies and automated metadata loads.
• Support a complex Data Integration environment.
• Research and resolve data reconciliation issues using SQL.
• Update mappings, Load Rules, Run Schedules and MaxL scripts.
• Created OTBI analysis using OBIEE answers.
• Involved in implementation of Fusion Financials11.1.1.3 Offerings for Canadian Entity - Oracle Fusion Financials options (AP/AR/GL/CE/FA) Financial Reporting Center and Financials Accounting Hub).This includes- Identifying business requirements and aligned them to Oracle Cloud Financials functionality and configured the system.
• Carried out operational analysis (AS-IS), solution design (TO-BE), Building Stage along with configuration of complete Oracle Fusion Financials Offerings with options -Oracle GL (General Ledger), AP (Accounts Payable), Fixed Assets, AR (Accounts Receivables),Cash Management and FA.
• Worked with client to develop business solution designs that achieve business requirements. Assisted in documenting and performing application set ups according to project plan.
• Setup Legal entity, Business units, Facilities, multiple Primary and secondary ledgers using Fusion Setup Manager, multiple ledgers and Hierarchies in Fusion GL.
• Performed core FAH setups and created Journal Entry Accounting Rules for various custom scenarios in FAH.
• Setup Integration between Oracle Fusion GL and Oracle Fusion Accounting hub that involved synchronization of COA, Calendars and ledgers, Transfer of data and financial results from GL to FAH Ledger and drilldown to Oracle GL from FAH.
• Configured Fusion GL to serve as corporate book to perform real-time reporting and analytics and designed OTBI reports in FAH for re-conciliation, drill back to legacy transactions..
• Integrated FAH with HFM leveraging FQDM to pull information from FAH for reporting purpose.
• Generated a list of setup tasks and configured Fusion options -Account Payables, Fusion Account Receivables, Cash Management & Fixed Assets.

Environment: R12 (GL, AP, OM, PO, CE, FA, AR, Inventory, Workflow Administrator, XML, AOL, XLA, EB-Tax, Vertex, OTL, SSHR), Informatica Power center 8.6,SQL, Windows XP, VSS, Service Now, Hyperion, I Expense and Oracle Fusion Financials, FAH

Confidential

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Working collaboratively with team members to provide ongoing techno-functional support on business streams that involves P2P, O2C, R2R and Hire to Retire. This includes -Oracle HRMS modules (HRMS, Payroll, iRec, Compensation workbench, OTL) and Oracle EBS Modules (Project costing, E-B Tax, Fixed Assets, Receivables, Payables, AME, Purchasing, CE and GL) responding to system issues with the appropriate level of urgency. Diagnosing the root causes of system issues and implementing fixes.
• Analyzed business requirements and translating them into efficient technical/Functional solutions that provide business value while understanding the impacts to other areas of the ERP.
• Actively derived the development life cycle from requirements analysis, feasibility estimates, design, code, documentation, testing, implementation and support.
• Supported change management processes to manage application patching and changes to production configurations.
• Maintained current knowledge and system functionalities.
• Provided on-time Functional/Technical support for production issues including fixes to existing interface and reports, creation of new objects, user acceptance testing and migration of objects from one instance to another on Oracle Financials modules. (R12.1.3).
• Modified existing and created new approval rules in AME related to Projects, Purchasing, Payables and iRecruitment based on the business requirements.
• Created reports using BI Publisher/XML Publisher including creation of data definitions, templates, concurrent programs etc.
• Worked with production support team to fix issues with customized objects such as interfaces, reports, OAF personalizations.
• Prepared Functional specs and Tested inbound /outbound Interfaces to GL, AP, AR and Inventory.
• Modified existing and created new approval rules in AME related to Purchasing, Payables and iRecruitment based on the business requirements.
• Tested end to end flow of Procure to Pay cycle (P2P) which includes - Identification of Requirement, Authorization of Purchase Request, Final Approval of Purchase Request, Procurement, Identification of Suppliers, Inquiries, Receipt of the Quotation, Negotiation, Selection of the Vendor, Purchase Order Acknowledgement, Advance Shipment Notice, Goods Receipt, Invoice Recording, 3 Way Match, Payment to Supplier.
• Performed configuration and setup for predefined approval styles and approval process “OTL Auto Approve” and “Projects Override Approver” as per the business requirements
• Involved in defining Elements, Element sets, Assignment sets, Consolidation set, Element links.
• Performed OTL setup by defining Approval rules, Hours types, Time entry rules, Approval styles and Setting up the Ps.
• Involved on Month end activities and worked on Reconciliation process to close the accounts as per month end.
• Raised SR’s with Oracle Support to resolve the issues which were part of Oracle Bug and provided necessary information as required.
• Manage the completion and documentation of assignments in JIRA queue ensuring adherence to IS team goals and service levels.

Environment: R12.0.5 (GL, AP, AR, AGIS, OM, INV, AME, Advanced Pricing, CE, iExpense), Bugzilla, SQL, TOAD, JIRA, Hyperion

Confidential

Functional/Technical/DBA

Responsibilities:

• Provided program oversight, guidance and leadership to business owners through: Status Updates, Program /Dependency tracking, Identifying and solving resource gaps, facilitating cross-functional collaboration, Change Management and communications, providing project management resources, Consolidating activities and Bi-weekly reporting to Executive Steering Committee/Leadership team, driving the program to meet financial goals and committed guidelines.
• Applied advance knowledge of the business and processes to manage risks and issues - applying appropriate enterprise process and technology integration approaches.
• Worked with Product Management to roll out Agile Scrum as a new process for ERP Project implementation.
• Managed all aspects (i.e.) SDLC of R12 upgrade project to ensure the overall program is aligned to and directly supports the of strategic objectives.
• Build and maintain relationships by engaging business sponsors, key stakeholders, SDEs and project team to establish creditability, solve problems, build consensus and achieve objectives.
• Facilitated the identification and mitigation of project risks and issues.
• Provide project estimates and capacity plans, budgets, status reports, and quality retrospectives.
• Partnered with internal customers to gather business processes as well as project and development requirements using industry best practices while directing multi-disciplined software teams.
• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Prepared PM/work plans, strategic placement of product roadmaps, with all associated project documentation and processes e.g. change management, communication plan, plans, test strategy, test plan, risk mitigations plan, project monitoring and control.
• Collaborate with team to assess current processes and identify process improvement opportunities through the collection of facts and data using Configsnapshot tool and performed complete impact analysis for the upgrade.
• Collaborated with Apps DBA and developed a strategy for database upgrade and a detailed plan for application of patches for respective modules utilizing Configsnapshot tool.
• Identified standard system functionality, analyzed GAP document and designed solutions for P2P and R2R streams for following EBS Modules (GL, AP, AR, FA, CE, Purchasing, Project Costing & PO) and HRMS Modules (Payroll/Benefits/Core HRMS/OTL) and Install Base - Enterprise Asset Management depending on Business requirement.
• Worked with Product Management to roll out Agile Scrum as a new process for ERP Project implementation.
• Delivered Delta s to the business users and prepared user procedures, process flows, month end close procedure for R12.
• Led system analysis and design and building functionalities and features in close interaction with the client, integrating quality standards and designed TO BE Process for Financial Modules. (AP, GL, AR, FA, CE, Project Costing and Purchasing) and HRMS Modules (Payroll/Benefits/Core HRMS/OTL) and Install Base - Enterprise Asset Management.
• Utilized config snapshot tool for setup documentation and to facilitate migration of setup from one instance to another during complete upgrade process and roll out Operating units/Business groups/inventory organization.
• Utilized Config Snapshot tool for CEMLI remediations.
• Collaborated with offshore development team to clarify requirements on CEMLI remediation, testing and issue resolution.
• Identified issues like setups /components (forms, functions)affected/related to upgrade patching using Configsnapshot tool
• Maintained Functional/Technical change logs on Share point.
• Ensure timely knowledge transfer with assigned client functional lead. Participate with assigned client functional lead throughout system testing.
• Provided guidance to assigned client functional lead in the preparation of materials and class agendas.
• Reviewed and approved Functional configuration document for financial modules as per business requirements.
• Implemented Electronic Funds Transfer (EFT) and Positive Pay file with Bank of America and Comerica.
• Configured E-BTAX and integrated it with Vertex as per business requirements.
• Setup/Configured SLA rules in replacement of FA Account generator workflow customization.
• As a part of R12 Upgrade configured AGIS - enhancement of existing GIS Functionality in 11i among 2 LE that belong to same Ledger/SOB.
• Defined payment terms, Accounting Rules, Accounting Periods, and Invoice Sources.
• Defined Bank information, receivables quick code, auto invoice grouping rules, transaction types.
• Setup AP payable system option, financial options, and payable options.
• Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list.
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Creating cross validation and security rules.
• Define DFF, Payment Terms, Signing Limits, Special Calendars and Expense Report Templates
• Define AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options
• Presentation of Financial Consolidation system to the Management.
• Involved in Month-end support for close and reconciliation for AP and AR modules.
• Configured E-BTAX and integrated it with Vertex as per business requirements.
• Setup/Configured SLA rules in replacement of FA Account generator workflow customization.
• As a part of R12 Upgrade configured AGIS - enhancement of existing GIS Functionality in 11i among 2 LE that belong to same Ledger/SOB.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period. Setup Auto Accounting to recognize revenue based on Sales Order line.
• Provide functional review & impact analysis on proposed changes with the existing functionality.
• Conducted several user- sessions on the system upgrade tasks- Trained in Sub Ledger Accounting, Budgets, Encumbrances and terminology changes from 11i to R12.
• Responsible for preparing upgrade plan for GL, AP, PO, AR, and I-Expenses with all customizations and form personalization.
• Prepared impact analysis document for the upgrade of financial module.
• Investigated the current system (11i) and provided the better solutions as per the business requirements.
• Facilitating end-user and developing the various users manuals and conducted the UAT sessions.

Environment: 11i/R12 (GL, AP, PO,AGIS, iProcurement, AR, iExpense, SLA, CE, FA, INV, OM) SQL, TOAD, Windows 7, HP Service Center, HP Quality Center, Config snapshot

Confidential

Oracle Business Systems Analyst | Oracle Functional Lead

Responsibilities:

• Identified Business Requirements & detailed Solution Design for P2P/ O2C and R2R process streams across Oracle EBS Modules -GL, AP, AR,OM, Advance Pricing, CE, Fixed Assets, E-BTAX, Latin Tax engine, Approvals Management Engine (AME), FAH, Oracle Project Costing, Purchasing, Inventory, LCM and Oracle HRMS Modules.
• Contributed to the project’s business objectives, scope, implementation strategy, methodology, success/risk factors, and provide a preliminary assessment of project management requirements for: Schedule, Staffing Requirements & Budget of $10 million to deliver IT solution (Oracle E-Business R12) across 3 continents in 5 countries.
• Global Business Process / ERP Solution Model: enhanced the organization's existing business process model in the Supply Chain, Finance and Project Costing domains. Developed the ‘global’ ERP solution model - incorporating requirements for South America (Colombia, Venezuela) and for the Middle East (Oman). Added new functionality/modules to the existing ERP solutions footprint (Landed Cost Management, iExpense, Fixed Assets, Latin America localizations). Further, established a complete ‘role based end user ’ package ( catalog, identified distinct roles, enhanced existing material. This package was successfully delivered at the entity's Australia entity).
• Developed the global business process/ERP solution model and a detailed ERP Roll-Out template for all future roll outs of the model.
• Merger Integration support - following a significant acquisition. Support the planning process of integrating multiple geographies into the existing ERP application environment.
• Prepared Impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.2.2.
• Involved in workshop sessions with business users in detailing out business requirements & map business design with Oracle EBS Financials/ SCM Modules
• Provided functional application leadership and guidance to client regarding “best practices” and functionality through all phases of an implementation.
• Worked with client to develop business solution designs that achieve business requirements. Assisted in documenting and performing application set ups according to project plan.
• Maintained enterprise application architecture with high-level visual schematic of key systems and business flows.
• Actively drive the development life cycle from requirements analysis, feasibility estimates, design, code, documentation, testing, implementation and support.
• Supported change management processes to manage software releases, application patching and changes to production configurations.
• Maintained current knowledge and system functionalities and actively seeks to understand new advances on the horizon.
• Managed multiple tasks and responsibilities in high-pressure environments; excelling at pinpointing and resolving problems in early project stages to avoid cost/time expenses.
• Identify & Document Gap Business Requirements.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data.
• Involved in design and configuration of chart of accounts, calendar and currency.
• Performed End to End Functional Configurations of both Oracle P2P and O2C cycle Modules
• Setup Financials Accounting Hub to account for transactions setup in legacy systems for non- oracle entities.
• Setup Supporting s in GL to report on business dimensions not added to COA.
• Developed Functional design documents to support AS- IS and TO-BE business processes.
• Performed Functional configurations like - COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies,
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Setting up legal entity, operation unit, Primary Ledgers, Reporting currency and Secondary Ledgers for Cash Basis Accounting using ASM.
• Create & updating BR100 / setup documents for all Oracle EBS Modules.
• Designed in Custom Invoice workflow for Non-PO invoices and invoice batches.
• Gathered business requirements for many Interfaces b/w AP and Third party systems.
• Configured of Approvals Management Engine (AME) for standard Invoice Approval Workflow.
• Lead CRP sessions during implementation, Design and Testing.
• During the course of project several MD-50’s are delivered for different CEMLI’s related to EBS Modules.
• Assisted team in developing Process Documents and Test Scripts.
• Closely interacted and assisted with users during UAT sessions in executing process documents.
• Trained users with all the new features of R12.
• Involved in the project scoping of the iExpense implementation
• Setup the iExpense Module along with AMEX Credit Card Company wide for US and Canada and then rollout for other countries.
• Setup the approval hierarchy for the expense reports and created signing limits for iExpense users in AME..
• Setup of Policy schedules such as Accommodations, Airfare, Car Rental, and Mileage
• Worked closely with the users to define Daily limits, roles, and locations in Expense reports
• Configured HR information in Oracle HRMS to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Setup EFT Payments Company wide and integrated with respective HSBC Bank.
• Configured auto Bank Reconciliation process via CE (Cash Management) module & Automatic Reversal of rejected receipts, and the ability to clear payments and receipts before Reconciliation with the HSBC Bank.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Setup Auto import and reconciliation of bank statement Bank file integration/mapping.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP) in Oracle cash management modules.
• Extensively used Toad and SQL Developer to view the tables to troubleshoot production issues.
• Supported Post-Implementation phase for Oracle Financials Modules. Involved in post-production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions for issues.
• Resolved the issues related to payment processing, payment authorization, and suppliers.
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Resolved the issues related to credit card refund, return, bills only, freight charge return, credit card authorization, consolidated invoicing and receivables
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report.
• Performed SLA Modifications for Accounting Rules for FA and AR Modules.
• Setup COGS recognition and Revenue recognition automation.
• Performed set up for Fixed Assets by setting up new categories, defining tax books and accounts (Expense, CIP, CIP Clearing, CIP Cost, Cost, Accumulated Depreciation, Gain and Loss Account).
• Suggested changes to reports to be incorporated for Account Standardization Project to suffice statutory as well as reporting requirements.
• Categorized and strategized reports into Additions reports, Reconciliation reports, Reclassification reports, Asset detail reports, Transfer reports, CIP reports, and Tax reports for additional customization in order for the reports to illustrate the changes in Chart of Accounts.
• Recommended modifications to the different forms of Oracle Fixed Assets for the information that needs to be masked/unmasked and also for the purpose of incorporating the Major-Minor category combinations and Account values.
• Suggested customizations needed for external file templates for Mass Additions, Retirements, Reinstatements and Cost Adjustments.
• Incorporated changes in Project accounting template to take into consideration the Capitalized and non-capitalized projects in order for the different business groups (Advertising, Travel and Expense, etc.) to track the cost for different Advertising and Promotional projects regardless of Capitalized or Non-capitalized projects.
• Configured Budgeting, setup Budget Organizations, Master and Detail budgets.
• Supported Project Accounting-Project Costing, Project Billing, modules.
• Involved in setting up project template, accounting rule, etc.
• Involved in the setup of Project Accounting Module .Setting up the Billing, Costing and expenditures in project accounting.
• Gathered and analyzed business requirements. Documented functional requirements pertaining to financial modules and security features in Project Accounting and OTL.
• Worked on Billing events, Project costing, Budgeting and Project Management.
• Worked on Billing Extensions to Create Event Holds.
• Added Accounting Rules for Auto accounting and creating Lookup set.
• Drafted the testing documents and participated in SIT and UAT testing.
• Created new Category Matrix for Fixed Assets as part of Account Standardization changes (Global Account Standards GAS)
• Involved in the month end closing process, generating reports and reconciliation after running the month end process.
• Responsible to figure out solutions for the errors while running the Create Accounting for Fixed Assets.
• Involved in General Ledger implementation for Latin American country - Columbia and Mexico
• Involved in various requirement gathering sessions with in country teams. Identified statutory reporting requirements from in country team for various ledgers.
• Defined Legal Entities and chart of accounts and set up ledger in R12 Accounting setup manager.
• Defined operating unit, Inventory organization and Asset organization using organization forms.
• Defined custom cross validation rules as well as Security rules in General Ledger.
• Experienced in Defining document sequencing and Assign those sequences.
• Defined outbound maps to feed data to legacy systems.
• Educate end users on maintenance of COA and web ADI functionality. Also educated users about CITI customization like prepaid functionality and single payer concept.
• Worked with feeds team to import the files from external systems to P2P system, process those files in P2P and send those data to respective legacy GLs.
• Interacted and worked with the development team to solve the problems faced in the test scenario run.
• Prepared Integration & Customization Unit Test Plans & supported Business / Functional users in testing Integration with Oracle GL, Purchasing & Oracle Payables Applications.
• Conduct CRP’s and work on open items to accomplish within the timelines.
• Create and update test plans and test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Collaborated with APPS DBA for patch application & database administration. Provided Post production support.
• Configured and testing of system administrator and user management functions including Users, Responsibility, Role Based Access, Menu, Request Group, Concurrent Requests, Workflow, Function Security, Profile Options, and Form Personalizations.

Environment: R12.1.3(GL,AP,AR,PO,Inv,iProc,iSupplier,LCM,EBTax,iExpense,CE,SLA),PL/SQL,SQL Developer, TOAD

Confidential

Oracle Functional Analyst

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document
• Performed analysis of present system and operations; documented existing procedures and operating methods; defines requested data requirements, analyzes documentation files and reports; designs improved system and methods of implementation around the application modules.
• Provided direct oversight of all vendors support and ensures incident resolutions and problems are correctly identified with the proposed final solution consistent with the end users’ project requirements.
• Setup the iExpense Module for different Operating Units
• Set up the approval hierarchy for expense reports and created signing limits for iExpense users in Payables
• Involved in the project scoping of the iExpense implementation
• Setup of Policy schedules such as Accommodations, Airfare, Car Rental, and Mileage
• Worked closely with the users to define Daily limits, roles, and locations in Expense reports
• Defined Expense report templates in AP.
• Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source& types
• Define system options, Accounting Option, Lookups, Payment and Billing term templates
• Worked with the business users, technical team to enable conversion of the lease from legacy system
• Performed developed and documented systems analysis, validation testing, and development of documentation, of internal staff of enhanced business system functionality
• Created test documents, performed unit, End to End and User Acceptance Tests for AP
• Administered business requirement definition and gap analysis, and defined business processes, setups, and test scenarios for Oracle Financial modules.
• Handled the application of Oracle Financials that automated accounts payable, accounts receivables, fixed assets and cash management;
• Created FSGs comprising row sets, column sets and content sets for reporting purposes.
• Participated in the design of Chart of Accounts and did the Setup of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Trained end users in AR, AP, GL, FA and CE and also created detailed user manual.
• Created corporate book, asset categories, system controls, flexfields - asset key, location and category in fixed assets.
• Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi OU through security profile in a secured environment; liaised with other personnel to deliver first-class customer service to clients; and adhered with governing policies and procedures enforced by the organization.
• Maintained proactive interaction with clients to understand business practices in rendering assistance in system configuration; analyzed various business functions to derive benefits that would be obtained in terms of cost rationalization and management control as a result of the implementation.
• Oversaw mapping business processes to Oracle Financials modules and conducted functional analysis, requirements, definition, and Oracle Financials module configuration and testing; designed and operated financial reports through the use of Final Statement Generator (FSG) tool; and trained users on various processes, such as AP, AR, GL, and CE(Release 12) while creating a detailed user manual.
• Documented the business requirements, current and future Processes.
• Created the Responsibilities for all the ledgers and attached the Responsibilities to the Ledger.
• Worked on SLA (Sub-Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.
• Implemented Electronic Payments, Positive Pay and integrated with Banks.
• Configured and testing of system administrator and user management functions including Users, Responsibility, Role Based Access, Menu, Request Group, Concurrent Requests, Workflow, Function Security, Profile Options, and Form Personalizations.
• Develop Functional Test Cases and perform Functional Testing of technical solutions like bank reconciliation, EFT, Positive Pay and Mass Invoice/ upload process.
• Involved in Defining Month End Close Processes. Involved in Post Production Support for Oracle Financials Modules.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Designed & developed material and undertook for all levels of users on new functionalities configured.
• Conducted analysis focusing on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, and functional specifications; analyzed and understood client strategic direction, issues, and project goals in order to deliver exemplary customer service to clients.
• Provided Production support on HRMS Modules Core HR, SSHR, I Recruitment, Compensation Workbench, OTL and Oracle Learning Management.
• Installed Confidential View and integrated with Microsoft products (Excel and Word).
• Installed created, changed and deleted users and groups, and granted them with privileges on the Essbase applications, databases and subsets of databases.
• Utilized the Hyperion Reports tool to generate traditional financial reports such as balance sheets, profit and loss statements, and cash management reports.
• Made use of Query Designer to produce reports (i.e. quarterly forecast and annual budget) to support financial users.
• Hyperion Analyzer was used to run fast, accurate, and ad hoc reports.
• Performed data entry on Hyperion Planning creating forms to accomplish flexible data collection and analysis.
• Several web forms were created in Hyperion Planning base to accommodate senior level staff's requests.
• Maintained security for Planning, Business Rules and Essbase.
• Performed OA Framework personalization for Self Service applications.
• Involved in converting Discovering Reports to Dashboard requests. This is in addition to the seeded dashboards and requests delivered out-of-the-box using OBIEE Answers.
• Utilized ODI console to perform testing on work repository to validate the scenarios and transformations before releasing them to production.

Environment: Oracle Applications R12.0.6 Modules (EBTax, GL, AP, AR, CE and FA), Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer, Hyperion, OBIEE, ODI

Confidential

Tech Support Analyst

Responsibilities:

• Facilitated business process review sessions and helping client groups to implement process changes.
• Created the Business Requirement Document (BRD) and the Solution Design Requirements (SRD).
• Created Process flows using Visio ensuring current state and future state are appropriately documented.
• Support business with change management as it aligns to process improvements.
• Support the developers in order for them to understand the design and help see the development through entire SDLC.
• Responsible for the support of financial systems, including Consolidation, Inter Company journals of Oracle ERP.
• Manage the monthly, quarterly and annual financial closing process in conjunction with the different support teams.
• Work closely with the region finance managers to support the system requirements of the Finance Organization.
• Responsible for the implementation of the Financials modules like GL, AP, AR & CE. The role includes all tasks from business requirements gathering to user and go-live / ongoing support.
• Implementation of setups and configuration of Oracle Financials 11i GL, AR, AP and CE for AR Lockbox, Inter-Agency funds transfer, cash/funds position and forecasting processes.
• Configured setups of iExpense. Setup employee user account, default expense account and expense report templates for iExpense.
• Worked on integration of CE module with AR and AP module for reconciliation.
• Reconciling Bank Statements, Reconciliation Tolerances, Posting Amount differences within Tolerances, Changing the Reconciliation Status, Entering Reversals.
• Bank Statement Error Reconciliation, Matching Bank Statement Lines with Transactions.
• Worked on functional specifications and test scripts.
• Provide implementation and post implementation functional support for the Oracle eBusiness Applications suite Oracle 11i.
• Configured and testing of system administrator and user management functions including Users, Responsibility, Role Based Access, Menu, Request Group, Concurrent Requests, Workflow, Function Security, Profile Options, Form Personalizations.
• Conduct user s for financial modules and create material for them.

Environment: Oracle E-business suite 11.5.9, 11.5.10 .2 - CE, AP, AR, GL, SQL, PL/SQL, SQL* Plus, Forms 6i/4.5, Reports 6i, SQL* Loader, Oracle RDBMS 9i/10g, Oracle Developer.