Candidates About

 

Mir Abdul Wajid

Summary:

Overall 8.2 Years of total Industry experience on ERP System Design, Implementation, and Production Support on Oracle Apps Financial as a Functional Consultant. Extensive experience with Production Support.

§  Experience includes execution of 2 full lifecycle Oracle EBS Implementation includes the exposure to E-Business Suite Release 12 Applications, Numerous Application Support Projects, RICE Implementations, Roll-out, 11i to R12 Upgrade, Extensive experience with Oracle Imaging and Process Management (IPM) & Web Center

§  Extensive Experience on Procure to Pay (P2P) and Order to Cash (O2C) Cycles.

§  Worked on I Expense credit card interface with AmEx, MasterCard and P-card transactions

§  Debug and fix Workflow errors in I Expense and AP invoice approval

§  Design validation & Setups of AR, AP, Credit and Collections Management, GL, FA, and PO Modules.

§  Worked in Multi Org Environment and Configured the system as per Client requirement

§  Configured the application based on solution design, Very good understanding of the Revenue Recognition Process and US Accounting Standards of US GAAP

§  Worked on the Oracle Project Costing, Project Contracts, Project Billing module – setting up the Project Task, Project schedules, cross charging, burdening, etc.

§  Strong exposure to varied projects comprising of Implementation, Upgrade, Migration, Application Maintenance and Support, Global Rollouts, Period Closure, Support & Training.

§  Strong documentations skills of AS-IS and TO-BE processes, Prepare Feature Business Model to meet gap-fit

§  Possess strong knowledge of Financial modules of Oracle applications, with concentration on AP, Credit Management, AR, GL, AP, FA, CM, AGIS, I Expenses, Project Costing, Project Billing Oracle Imaging and Process Management (IPM), and Distribution modules I procurement OM and PO.

§  Experience with system integrations, Inbound/Outbound Interfaces, Reports and Customizations.

§  Creating Test scripts & co-coordinating executing of test scripts for RICEW Components.

§  Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, SIT, CRP, UAT, Cut-Over and Project Coordination activities.

§  Trained the clients’ super users on the application and conducted pilot testing, integrated testing.

§  Good understanding of On-Site / Offshore Model and worked on multiple engagements for business process

§  Strong Knowledge Writing SQL Quires for data analysis in database query tools (SQL Developer, TOAD)

Skill Set

·ERPs: Oracle Financials 11i, &R12, General Ledger, AGIS, Account Payables, Account Receivables, FA, CM.I Expenses, Oracle Web Center Imaging

·Good Knowledge: Purchasing, INV, Order Management, System Administrator

·Languages: SQL/PL SQL (Oracle)

Tools: Putty, FTP, TOAD, SQL Developer

Test Management Tools: HP ALM Quality Center

Other Software: MS Access, MS Visio, UML, Mark View.

 

 

 

 

 

 

 

 

 

 

PROFESSIONAL EXPERIENCE

 

 

Yahoo! Sunnyvale, CA                                                                                                                              Sep’16-Till Date

Role - Oracle Business System Analyst

Project – Oracle Applications Release 12.2.6 Upgrade from version & Production Support

Responsibilities:

·         Responsible for supporting and optimizing ‘Core Finance’ platform Billing/Revenue/Accounting applications for EMEA and US.

·         Support Production issues on a day to day basis including month end closure p1 issues for EMEA and US)

·         Working with Finance business process owners and relevant Finance stakeholders to translate business requirements to technology solutions related to Billing, Revenue and Payment Applications.

·         Involve implementation and support of Oracle Applications environment and Oracle Financials release 11i.

·         Release 12: Accounts Receivable, Accounts Payable, I, Expenses General Ledger, Fixed Assets and Procurement modules: Purchasing, I Procurement

                                                                                                                                                                        May’16-Sep’16

MARSH & MCLENNAN INC, NJ

Role - Oracle Financials Consultant – Re design of COA, & Production Support

Technology:  AP, FAH, CM, I-Expenses Oracle, AR, WebADI, and GL

Responsibilities:

• Worked on Functional designing, Testing and Development of New enhancements.
• Setting up Accounts Payables (AP) and working on Supplier setup, setting Payment Process Requests testing and training of the new release redesign of COA.
• Worked closely with FAH team and have adept knowledge of FAH/ SLA, Sub ledger Applications setup, Event Model, Process Categories, Accounting Event Class options, Journal Line Types, Account Derivation Rule, Journal Lines Definition, Application Accounting definition, Sub ledger Accounting Method.
• Reviewed and analyzed FAH/ SLA setup documents.
• Tested Revaluations, Open Close periods, Ledger sets, Journal Reversal, Posting Journals, Journal drilldown, Reconciliation, Journal approval workflow, CVR’s. Security rules, Multi-currency JE’s, Multi-period Journal Entry, Descriptive flex fields (DFF), Create Accounting program.
• Worked on business requirements gathering for loading Chart of Account value set in Oracle EBS
• Extensive experience in testing GL Web ADI and FAH Web ADI.

Environment: AP, FA, CM, I-Expenses, SLA/FAH, GL.

 

Cox Communications, Atlanta, GA                                                                                                              May’15-Apr’16

Role - Oracle Financials Functional Analyst

Project – Oracle Applications Release 12.2.4 Upgrade from version 11.5.10.2 & Production Support

Technology:  AP, FA, CM, I-Expenses Project Costing, Project Billing, Oracle Web Center, AR, Revenue, GL

Responsibilities:

§  As a Functional Consultant identified new & changed features of the new release, and assisted with the testing and training of the new release. redesign and implementation of Oracle Web Center Imaging module and configurations for AP, AR, Advance Collections, AGIS, GL, FA, Cash Management, e-Business Tax, i-Expense, Purchasing.

§  Worked on I Expense credit card interface with AmEx, MasterCard and P-card transactions

§  Debug and fix Workflow errors in I Expense and AP invoice approval

§  Tested approval hierarchy for AP invoice and I Expense approval

• Tested inbound interface of project-task from third party HP PPM Pre upgrade testing and Post upgrade production live support.

§  Worked with third-party vendor Workforce Logic to design and test AP invoice interface

§  Designed and tested Bank check printing program and verified with Wells Fargo bank

§  Worked on the Configuration of the ACH Process in Account Payables Module

• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle and legacy system

§  Worked on the integration of Oracle e-Business Tax with Vertex module

§  Worked on Revenue Recognition process in AR module setting up Invoicing and Accounting rules.

• Analysis of requirements to establish conversion strategy for Projects data
• Loading accounting codes Through Data Loader and Trail Balance Journal and Assets through ADI.

§  Provide work-around solution to the issues identified, Assess the intensity of the issues and resolve

• Conducted Regression testing to examine the effects of a new Org on the previous Org.

§  Prepared Test Cases, and carry out end-to-end testing for all patch analysis and deployments;

§  Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.

§  Provide support to business users during month-end activities.

 

Accelrys, San Diego, CA                                                                                                                      Mar’14 –May ‘15

Technology: AR, Revenue, GL, FA, Channel Revenue Management, AP, Sub Ledger Accounting, e-Business Tax, i Expenses, i procurement

Project – Oracle e-business Suite Upgrade from 11.5.10.2 to Release 12.1.3

Responsibilities:

• Prepare / carryout / Requirement gathering, Functional Design Document for RICE / CEML.
• Functional mapping of gaps identified for technical team reference and designing.
• Involved in preparation of Conversion Templates, and power point presentation documents for both configuration and process steps with navigations for end users.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• Implemented Auto Lock Box Functionality in AR for Bank of America & Royal Bank of Canada.
• Worked on the setups of Oracle GL Module – setting up Ledgers, Ledger Sets, Data Access Sets, defining and designing the chart of accounts, calendar, primary and secondary ledgers, cross validation rules, security rules, journal sources, etc.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for Project Costing, Project Billing, AP, AR, FA.
• Set up of Organization structure i.e. Business group, Legal Entities, Operating units and Inventory Organizations in CRP1, CRP2 and in UAT instance.
• Defined Collector, Aging Buckets, Auto Cash Rule Sets and Assign to Customer Profile Classes
• Pre upgrade testing and Post upgrade production live support
• Worked on defining the consolidation ledger in Oracle GL and defined the consolidation process.
• Configured AR, Advance Collections, AP and GL modules from scratch and simultaneously created BR100 documentation for the setups
• Creation of Auto Invoices, Application Rule Sets and Auto Accounting

• Define Payment Attributes -Payment formats, Bank Accounts and Payment Documents.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module.
• Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.

• Worked on the Auto Lock Box process in AR Worked on the Month End and Quarter End close and reconciliation process in oracle GL module

• Completed the Configuration in various instance like Test, Dev. and Prod.
• Testing business scenarios for processes mapped in Oracle Apps.

Facilitate Segregation of Duties in Oracle Applications.  Customize various roles and responsibilities as per the SOD Document in System Administration.  

                                                                                                                                                                                        Feb’13 – Jan’14

Riverbed Networks, CA, USA 

Project: Oracle e-Business Suite Implementation             

Financials Functional Resource

Technology: AP, AR, GL, i-Expense, FA, BPEL, SOA, IPM, AGIS, Cash Management, e-Business Tax, i-Procurement, Purchasing, Sub Ledger Accounting

 

Responsibilities -

§  Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.

• Worked on a deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.

§  Worked on the setups and configurations for AP, IPM, AR, Advance Collections, AGIS, GL, FA, Cash Management, e-Business Tax, i-Expense, Sub Ledger accounting modules.

• Understand Division-specific business processes from the end users and implement the same.
• Accounts Receivables – Worked on defining the Accounting and Invoicing rules, setting up the Revenue Recognition process, worked on setting up the AR Transactions types, setup the collection process in AR, worked on the Auto Invoice Setups in AR, worked on the Auto Lock Box configurations for Bank of America and Wells Fargo Banks.
• Worked on the support of BPEL and SOA.
• E-Business Tax – Worked on the setups of e-Business Tax for VAT and Sales tax, defined the rates, regimes, rate to regime flows, Tax Rules, etc.
• Worked on the Configurations of the Advance Collections module

§  Worked on the setups of the Payment Manager in AP module

§  Fixed Assets – Worked on the configurations of the depreciation process, worked on Mass Additions, configured the Asset Key Flex field, Asset Category Flex Field, worked on defining the corporate book and Tax books, worked on the Mass Copy functionality.

§  Cash Management – Worked on the setup of the reconciliation process using both Auto and Manual reconciliation, setting up the bank codes, defining the mapping process for the bank statement interface.

• Preparing responsibilities based on the user’s job profile and attaching them to the particular users.
• Involved in verifying the migrated data from the front end to check the integrity of the data.

 

McDonalds, IL, USA                                                                                                                        Apr’12 – Jan ‘13                              

Financials Functional Resource

Technology: AP, AR, GL, FA, PO, AGIS, i-Procurement, Advance Collections, PO, Cash Management, e-Business Tax, Sub Ledger Accounting

Responsibilities –

§  As a Functional Consultant supported the financial modules: GL, Advance Collections, AGIS, AP, i-Expense, PO, i-Procurement, AR & FA Release 12.1.3

§  Involved in Configuration for GL, AP, AR, FA and CE in Test, CRP and Production environments

§  Baseline Outbound Consignment Business Process.

§  Jointly derive the ‘To-Be’ Process & Aid Code development.

§  Worked on the Conversions & Enhancements for Oracle AGIS, AR, AP module,

§  Baseline Outbound Consignment Business Process.

§  Worked on setting up of Revenue Recognition process in AR Module

§  Defined the Accounting and invoicing rules to be used in Revenue Recognition process in AR.

§  Preparing BR100, MD050, TE40, TE50, CRP execution, coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.

§  Worked on the functional design for the AR Conversion process.

§  Worked on the Lock Box configuration in Oracle AR module

§  Worked on setting up the collection process in AR Module

§  Defined the Transaction Types in Oracle AR

§  Worked on setting up the TCA in oracle AR

§  Worked on the receipt conversion process in oracle AR

§  Formulate Test Strategy, Test Scenarios & Test Cases

§  Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.

 

Thysen Krupp Elevators, Atlanta, GA         (Offshore, India)                                                                 Jul ‘08– Feb’12

Project: Oracle E-Business 11.5.10.2- PRODUCTION SUPPORT

Responsibility

• Involved in the Production Support of AR, AP, GL, FA, OM and INV modules.
• Coordinated with the client by providing them onshore Functional support of their daily reported production issues
• Provided 24*7 supports in co-ordination with Onshore/ Offshore model support to the business.
• Delivered excellent service and support to internal business customers, also was responsible for monitoring progress against service level agreements.  Also responsible for ensuring each reported problem is resolved in a timely manner, tracked according to standards, and escalated as appropriate.
• Coordinated activities with testing and the technical team to resolve daily reported production issues. Facilitated discussions with end-users/managers to gather functional requirements on their issues.
• Supported the Interface errors that occurred and resolved them in a timely manner
• Supported the month end and quarter end activities to help the business with the close process
• Supported the tax issues that arose between Oracle e-Business Tax and Vertex.
• Supported the business users for any enhancement requests that were raised.
• Manned the help desk ticketing system, taking ownership for issues and resolving them.

Worked with Oracle support to open service requests – analyze the read me file, work with the DBA team to apply the patch to the patch instance, certify the patch and work on a schedule of applying it to production

 

 

Lucidity, Bangalore, India                                                                                                             Feb-07–May ‘08

Role: Oracle ERP Tester

Project: Implementation of Oracle Applications 11.5.10 with OM, PO, AR, AP, OPM and INV

Responsibilities:

• Written standard test scripts for Oracle Financials.
• Written TE 020 Unit Test Scripts for Payment Methods in AP and interface with Parts Operating Unit.
• Written TE 040 System Test Scripts for Project Billing, Project Resource Management, AP and OM
• Performed Standard Functionality testing in GL, i-Expense, i-Procurement, PO, AP, HRMS and OM.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Worked closely with Developers team for different issues
• RTM preparation and get the required sign0off from the stakeholders
• Writing functional and regression test cases `

 

Skill Set

• ERPs: Oracle Financials 11i, R12, - GL, AP, AR, FA, CM.I Expenses, Oracle Web Center Imaging
• Good Knowledge: PO, INV, OM, System Administrator, Oracle Project Costing, Project Contracts, Project Billing
• Languages: SQL, (Oracle)

§  Tools: Putty, FTP, TOAD, SQL Developer

§  Test Management Tools: HP ALM Quality Center

§  Other Software: MS Access, MS Visio, UML, Mark View.

 

Education, Training, and Certification

§  Bachelor of Commerce (Accounting & Finance)

§  PGDCA (Post Graduation diploma in computer application)

§  Certificate course in Oracle E-Business Suite (Financials) R 12

§  Completed hands on training on SQL /PL SQL 11g