We provide IT Staff Augmentation Services!

Oracle Apps Sr. Finance Consultant And Team Lead Resume

Collierville, TN

SUMMARY

  • Having around 12 years of total experience and 10 year’s IT experience in Oracle EBS Financials and SCM domain
  • Around 10 years of progressive experience in Oracle EBS as Oracle Financial/SCM Consultant and Team/Project Lead (Oracle Finance, Supply Chain Domain Distribution, Project Accounting, Procurement, i - modules, Oracle Fusion Finance, OPM and Manufacturing Key Oracle EBS Suite/Modules).
  • Have worked with Fortune-500 client across domains like Banking and Financial, Retail and Travel, Manufacturing and Automotive, telecom etc.
  • Have worked on different Oracle EBS Life cycles Implementation, Conversion, Migration, up-gradation and support/development projects.
  • Good SME and Expertise in Financial/SCM modules like Account Payable, Account Receivable, Fixed Assets, GL, SLA, Project Accounting, Order Management, P2P, O2C, Inventory, BOM and WIP, Purchasing, EB-Tax, i-procurement & i-supplier on different versions of Oracle Application(11ix & R12x-R12.1, R12.0.6, R12.1.3 and R12.2).
  • Responsible for meeting SLA and Project deliverables, by collaborating with all stake holders and between various departments like requirement and business analyst, development, marketing and other testing organizations.
  • Strong people management skills, able to positively motivate others, promoting teamwork.
  • Adept at extracting information from written materials and identifying the actions to be taken.
  • Enforcing teams for the adherence to the business process and procedures. Identifying gaps in the business processes and proposing improvements to management
  • Worked closely with Project management, program management and client team members during all the phases of Project execution
  • Strong analytical, design and problem solving skills. Proven ability to understand business problems and apply technology to formulate workable solutions.

TECHNICAL SKILLS

ERP: Oracle Apps E-Business Suite R11x & R12 (R12.1.3 and R12.2), Fusion Apps-Finanace Applicaiton

Languages: PL & SQL basics, SQL Developer

Database: Oracle PL & SQL basics, Apps Data base tables queries and execution with TOAD/SQL developer

Other Tools: OTAS, HP-Apps Testing Tool-Amex, HPQC-FedEx tool, Caliber, I-Rise Mockups, Teamforge, FWRS. Microsoft Project, Microsoft Office.

Domain: Oracle Apps SCM/Financial/Distribution/OPM Functional Consultant, Apps Fusion Finance

PROFESSIONAL EXPERIENCE

Confidential, Collierville, TN

Oracle Apps Sr. Finance Consultant and Team Lead

Responsibilities:

  • Working as Oracle EBS Sr. Financials Consultant and Team Lead on AP, AR, FA, SLA and GL Global Revenue system integration with other different 100+ third party revenue systems (Invoicing, CPG/EPA, Bill presentment, Invoice Adjustments, AWB/Invoice Repository, PeopleSoft AR & GL,SOA Services platform, Business Object and Data Warehouse (EDW), EDI, Shipping, Rating, Tax and Pricing Engine and Applications etc.)
  • Working with conversion tech. team on Oracle SLA accounting custom product development (Create, Review and Approve the BRS, SRS, BR100, HLD, LLD and System requirement, TSS/TCS documents)
  • End to end involvement in all the phases of Oracle EBS GL, FA, AR (12.1.3 Release) conversion Project execution includes, MD50, MD070, BR100, BR’s and SR’s, CRP’s Scope and Planning/designing, Data Migration, Execution, Development and Testing for Year2016 Launch
  • Creating business requirements, HLD, LLD, Test Cases, UPK, SOP, Use Cases and system requirements that satisfy the business needs as expressed by the business owners and documented by the Verification Sign-off of the work products.
  • Co-ordination & interacts with Solution Architect, SME’s Development teams team to provide efforts estimations (LOE) and production proposed load release.
  • As a working Finance and Accounting track Lead i had provided robust Solution, architecture, HLD and LLD for Oracle Custom Accounting Engine and Intercompany Extension Solution.
  • Provided Robust custom solution for Oracle AR Custom Line Level payment and adjustment Application functionalities & LL UI design/service definition doc. & provided my review comments which considered by HCL vendor team and FedEx team, i have been received customer appreciation for the new robust business critical features and Solution Provided.
  • Interact and Interpret with customers for understating of business requirements and existing architecture related to a significant elements of Oracle AR integration with other systems.
  • Prepared the Impact Analysis, Fit Gap, Success Criteria, Capacity/Resource Planning and Management, Project Plan, Status Dash Boards, reports & different scope document.
  • Completed end-to-end software development lifecycle (SDLC) for all customer-facing, under and over-threshold projects.
  • Ensure with work with Business Owners, Dev team stakeholders to Provide Quality Concept and on time Deliverables
  • Accomplished successfully Oracle AR Conversion CRP1 to 5 and UAT validation and testing sessions with new custom, End Users and Stake holders.
  • Production Roll out and Post Production Support on Oracle AR application.

Confidential, Denver, CO

Lead SCM/Finance Consultant

Responsibilities:

  • Worked 6 month on site as Oracle EBS SME and Financial Functional lead -AP, AR, OM, INV and SLA
  • Existing 11i system processes study, analysis & documentation According to Project scope retrofitted the 11i custom forms, Codes & other CEMLI to R12 upgraded instance.
  • Completed the validation/testing of all the Finance sub-ledger modules cycles/transactions on upgraded instance for each of Iteration/upgraded R12 Instance.
  • Analyzing feasibility and providing estimates for the new developments.
  • Developed custom reports for custom modules from scratch.
  • Worked on period end closure process, completed & tested period close process in R12 & prepared period Close documentation.
  • Interact and Interpret with customers for business requirements related to a significant elements of oracle applications.
  • Resolving the critical issues which occur during all the phases testing with the help of oracle support, worked on Sev-1 & 2 SR’s for quick resolution.
  • Customized SLAM i.e. modified & created Subledger AAD to default the AP, FA, PA & AR Control accounts at business transaction level.
  • Prepared Test Scripts, Setup update/change AIM’s document i.e. TE0.040, BR.0100 & 0120.
  • Worked with tech. team in CEMLI development and unit testing of the new requirements/ enhancements and Coordinating with business users for testing.
  • Worked with tech. team to automated (prepared LDT’s) the additional modules & system level set ups (menu, responsibility, Profile options set etc.)

Confidential

Sr. Functional Consultant

Responsibilites:

  • Involved in Roll Outs with IBM team & Post-Implementation support for Procurement & Financial modules (AP, FA, PA & GL) to US and Singapore Markets
  • Worked on Level-2 support for Oracle Financial Procurement modules, including trouble-shooting, testing, problem resolution, and implementation of fixes and enhancements.
  • Co-ordinating with level-1 & level-3 team to provide prompt resolution on the daily production issues.
  • Involved in the development & testing of SLA-AAD & ADR to default the Charge accounts, AP & AR Control accounts.
  • Involved in the bug releases testing & process improvements activities for Financial, SCM, IPM & BPEL management services.
  • Done yearly Closing & every quarterly Month Audit Successfully for Financial & Procurement Modules
  • Support to technical team in data verification & validation in migration, Validation of reports which developed by technical team.

Confidential

Functional Consultant

Responsibilities:

  • Involved in planning & design phases of implementation of R12.1.1 for Inventory, Purchasing & Order Management Modules.
  • Setting up the multi organization structure for the distribution center & 75 retail stores.
  • Configuration of the AP, INV, OM, BOM/WIP & PO setups for the distribution center.
  • Mapped OM tables from the legacy systems to map the client business process (to Migrate the legacy Customization in R12)
  • Configuring & testing the end to end business flows for Drop Ship, Internal Sales Order, Back to Back cycles by performing the required setups in Order Management, Inventory & Purchasing.
  • Testing of Item creation process by copying the organizations.
  • Configuration of locations, sub inventories, locators, item category, items

Confidential

Sr. Functional Consultant

Responsibilities:

  • Worked as a part of the SCM/Finance Functional Team on site for 6 months
  • Done PH-II Requirement Gathering & GAPs analysis after Interaction with internal IT Team & key users.
  • Preparation of the RD.020 Document after understands the current business process & PH-II requirements.
  • Provided functional solution design in new customize form development.
  • Preparation of the MD.050 Document for new form development as well for alerts & personalization as per the nature of Customization proposed to the client.
  • Configured the set up for AP, AR, INV, PO & OM Modules for PH-II companies on CRP/UAT/PROD Instance for 5 entities.
  • Done the CPR & UAT with users for the PH-II companies 5 entities.
  • Deployment of the SCM module set up on production instance for go-live after UAT sign-off.
  • Post-Implementation support for SCM modules daily user queries.

Confidential

SCM Consultant

Responsibilities:

  • Visited to the client Confidential & Jewelry Ltd. Mumbai for business study
  • Done the requirement gathering after interaction with key users.
  • Created the BP.010 document for their current business definition & Process Strategy
  • Then as per requirement of client done the POC demo set up for SCM modules (Inv, PO & OM with India Localization) on application R12i (12.0.6)
  • Completed end to end testing for Procure to Pay & Order to Cash cycle with Localization accounting entries.
  • Provided POC demo to the client.
  • Prepared the RFP (Request For Proposal) document & also created the GAPS details as per business requirements

Confidential

SCM Consultant

Responsibilities:

  • Existing business processes study, analysis, Requirement Gathering.
  • Worked on end to end testing of transactions (P2P, O2C, OPM Integration, India Localization, (PMA Costing) on upgraded instance for each Iteration.
  • Worked on India Localization i.e. RG Consolidation, VAT Settlement, 2-way matching process for VAT & ST as well as done the set up of RG - Register Opening Balances for RG23A&C, RG-1 & PLA registers.
  • Interact with clients & there end users to understand the issues & requirement.
  • Knowledge Transfer & resolving the issues which user will rise during UAT on upgrade instance.
  • Prepared the UAT test scripts (TE-40) & UAT result documents & same deliver to the clients & his end users for UAT.

Confidential

SCM Consultant

Responsibilities:

  • Involved in planning & design phases of 11i Migration.
  • Done the requirement gathering after interaction with key users.
  • Tested setups on development instants & deployed on production instance after business BR.0100 approval.
  • Completed end to end testing for Procure to Pay & Order to Cash cycle with Localization accounting entries.
  • Monitoring daily activities/Resolving the incidents tickets for users queries/issues
  • Done yearly Closing & every quarterly Month Audit Successfully for SCM Modules
  • Support to technical team in data verification & validation in migration, Validation of reports which developed by technical team.

Confidential

Production Engg

Responsibilities:

  • Planning day-to-day activities, production schedules and works allocation for achieving of monthly production targets
  • Assisting in production operations and achieving the preset production targets within the set time & budgets.
  • Managing the man power in shifts & monitoring the timely execution of various jobs for accomplishing targets within the set time frame.
  • Daily entries of production in the production report.
  • Group leader of around 30 peoples in respective shifts.

Hire Now