System Administrator Resume
Milpitas, CA
PROFESSIONAL SUMMARY
- 10 years of professional work experience including Six years of Oracle E-Business Suite 11i & R12.
- Experience in implementing testing, training, live production supporting, on various Oracle ERP modules General Ledger (GL), Accounts Payable (AP), Fixed Assets (FA), I-Procurement (I - Proc), I-Supplier, Accounts Receivables (AR), Cash Management (CE), HR, Order Management (OM), Inventory (INV) I-Procurement, Purchasing (PO), System Administrator, I-Support, Teleservices
- Oracle Global Functional Support for Live Production in Oracle cycle, Procure-to-Pay (P2P), Record to Report (R2R), Vendor Drop shipment (VDS), RMA, Order to Cash (O2C), IPR/ISO, Min Max Plan.
- Two Full Lifecycle Implementations including Functional set-ups, business process analysis, process, gap analysis and creating functional specifications.
- Did implementation of new requirement including CRP, requirement gathering, impact analysis and testing based on City’s requirement and conducted UAT.
- Have experience in AIM Methodology and PMM Methodology for preparing documents like BR100, MD50, TE 40, BP 60, BRD, and DIA.
- Extensively used TOAD to retrieve data from the backhand
- Extensive knowledge of Setting up ADI and uploading data into the application
- Closely work with Technical Team for Customizations like Reports, Interfaces etc.
- Involved in Upgrading of version, Unit Testing, System Testing, and Integration Testing.
- Very good understanding of the Multi-org Structure and integration of financial modules and distribution modules
- Exposure to Multi-Org Access Control (MOAC), FSG, SLA, E Business Tax, Payments, Sub ledger Accounting, Advance Global Intercompany Segment (AGIS).
- Excellent Documenting skills, Communication skills, Client management skills, and Method based engagement management.
- Managing the Interfaces between Oracle AP and other existing systems (170 Markview), Tilde (Electronic Payment System), Poorman Douglas (Checks Payment System), Hyperion, BMA (Banking Management Application), Concur, Vertex.
- Responsible for Auto Invoice clearance, GL interface clearance, GL Transfer, Revenue Recognition process.
TECHNICAL SKILLS
Windows 95, 98, 2000, XP, Vista, C, C++, Tally 6.3, TOAD, ADI, SQL, PLSQL, UPS Tools HPQC, , MS OFFICE 2003/2007 (Word, Excel, PowerPoint,) PVCS, Kintana, Discoverer, Oracle Workflow
EDUCATION:
M.B.A
B.Com (Commerce)
Professional History:
Confidential, Milpitas, CA
Jan 09 - Present
Team Lead
Responsibility : We have upgrade the version from 11.5.10.2 to R12 and supported in Production support for GL, AP, AR, PO, I Procurement, HR, System Administrator CM,OM
- Prepared BR-100 Setup and Implementation documentation for GL, AP, AR, PO, FA, CM, INV and OM modules.
- Prepared analysis document for R12 upgrade from 11.5.10.2.
- Conducting user sessions to capture and document current RICE custom objects and provided TO-BE suggestions and documents.
- Implemented Oracle Cash Management for Bank reconciliation. Integrating Bank accounts from AP, AR.
- Work on oracle iSupplier Portal Setup, Supplier Registration, iSupplier Portal Home Page, Manage Orders, Manage Shipments, Receiving Information, Invoice & Payment Information, Supplier Profile Management
- Conducted UAT for AR documents such as Invoice, Open Balance statement, Dunning letters etc.
- Core member in the project involved in the create Invoice, Recognize revenue, and GL posting business functions. Responsible for creating functional specifications, technical design review process, verification of test scripts.
- Worked on Invoice Creation, revenue accounting and invoicing
- Once registered, the supplier can provide details about their company and describe the types of goods and services they provide.
- Work on Oracle Advanced Global Intercompany System to create invoices in payables and receivables sub ledger from intercompany transactions
- Developed Functional documentation as per AIM methodology
- Prepared functional document specifications on Oracle Centralized Payments with Funds Capture Process and Funds Disbursement Process
- Worked on Late Charges, Line Level Cash Application, Balance Forwarding Billing, Refund Process Automated, and Customer Enhancement.
- Created FSG reports on Balance Sheet, Combined and departmental Statement of Operations/Income Statement and other reports.
- VFI Hyperion GL Extract Concurrent Program in Oracle General Ledger
- Work On Reverse auctions, Electronic bidding
- Set up as per the client requirement for Supplier, Banks, Retainage, Recoupment, Payment Manager, AP/AR Netting
- Identified the gaps in the business processes and filled gaps in Procure-to-Pay process flows from PR in I Procurement and purchased order in PO.
- Cleared all stuck records from the Custom interface as part of Prod support
- Integration with the Oracle EDI Gateway to upload inbound Suppler invoices
- Designed approval workflow process, documented approval process, assisted in setting up Workflow (purchase requisition) in I Procurement
- Performed GAP analysis identifying GAPS in the business process, providing alternatives/solutions
Confidential, Milpitas, CA
Mar 08 Dec 08
Process Lead
Project Details: Responsible for 24X7 global Live supports on oracle cycles likeProcure-to-Pay (P2P), Record to Report (R2R), Vendor Drop shipment (VDS), RMA, Order to Cash (O2C), IPR/ISO, Min Max Plan.
Oracle ERP modules General Ledger (GL), Accounts Payable (AP), Fixed Assets (FA), I Procurement ,Accounts Receivables (AR), Cash Management (CE), Order Management (OM), Purchasing (PO), System Administrator, I- Support, Teleservices
Responsibilities:
- Communication with JDSU Management - Work closely with JDSU management and regularly provide them -Metrics on weekly/monthly module wise logged issues, closed issues, issue categorization and open issue trend analysis along with RCA issues. Resource wise utilization percentage, resource wise issue closure metrics, resource wise and provide team available bandwidth to work on other customization or enhancement activities.
- Involved in providing support on fixing the issues during end to end testing in P2P & O2C cycle.
- Co-ordinate SR reviews meetings every week with business super users on issues, solutions, testing and deployment. Extensively supported Hyperion, Concur Interface issues.
- Worked with Offshore: Prioritization of the issues, estimating the deadlines, KT and fixes
- Month, Quarter and Year end support: Provided extended support during period closings every month. Proactively monitored and provided the solutions/workarounds to time.
- Worked with Oracle On Demand (OOD for Database support): for urgent migrations, point and major releases worked with OOD for migrations. Also worked with Oracle product business to clear the stuck transactions for smooth period closings on group (TAR, SR) and OOD on Oracle product related bugs. Identified the issue prevent patches and did the patch impact analysis, recommended business for test plan and scripts for the testing.
- Enhancements: Gathered requirements from business for the enhancements and developed MD50 functional and co-ordinate with technical development team on MD70.
- I support and Teleservices Use and update these tools to track the issues raised by the users.
- Worked on personalization of OAF pages pertaining to Oracle I Procurement like customizing the List of values on standard OAF page using personalization and modified the look of the fields displayed on the OAF page.
- Developed many Data fixes and Bug fixes as part of Post Production support
- Working knowledge on Kintana Migration Tool and Version Controller PVCS
- Train new users on the transitions to new oracle functionalities and translate the current legacy systems and process to oracle functionalities.
- Communicated and updated business users and IT management as per the SLAs during P1 and P2 issues. Provided stop gap solutions and permanent fixes along with the RCA to prevent future issues.
Confidential,Milpitas, CA
May 07 Feb 08
Functional Consultant Order to Cash (O2C) & Procure-to-Pay (P2P),
Project Details: Providing production support on Oracle Order Management, Receivable, Inventory, Inventory modules, Purchasing, Payable , GL, CM
- Provided Global support and resolved several O2C related issues
- Contributed in 64 Bit data base upgrade O2C Swat testing
- Good Functional understanding of Order to Cash cycle
- Coordinated and held SR review meetings every week with business users on issues, solutions, testing and development
- Provided extended support during Inv period closing for every month end, Quarter end and year end. Proactively monitored and provided the solutions/workarounds to business users to clear all the stuck pending transactions for smooth period closing on time.
- Resolved setup issues like Auto Accounting, Auto cash rule set, Accounting rules, Transaction types, and sources, collectors, Dunning letters, Remit to address, customer profile class, customers Document sequence etc.
- Defining receipt class and source, receivable activities, memo lines, Approval limits etc as per the request.
- Configuration of Auto Invoice process to import invoices from Order Management to Accounts Receivables
Confidential,SCI Corporation.
Aug - 06 April-07
Senior Functional Consultant
Responsibilities
- Member of the core team responsible for implementing GL, AP, AR, CM, FA, .
- Performing the developing functional specifications for the modules and customized processes.
- Implementation of the Accounts Payables module, Trouble shooting and conducted demos for the end users.
- Worked on Revenue Cycle with Multi-Currency. Set up transaction types, standard, prepayment,, credit memos, debit memos expense report interest invoice , quick match po default withholding tax
- Transferring payables transactions to General Ledger.
- Setup for new supplier as per the client requirement
- Acting as a liaison between developers and clients to enable product development with a close fit to the client requirements.
- Testing customized programs under simulated environments and creating user manuals for all such programs.
- Defined the Business requirements for Oracle General Ledger, Receivable module and Accounts Payable.
- Involved in documentation of setup procedures and end-user training.
- Finalized objectives and scope for rapid implementation of Oracle Financial.
- Defining the work structure by defining GL Calendar, Chart of Account, Set of Books, Roll-up Groups, Summary Accounts and Cross Validations.
- Performing Currency Revaluation, Consolidations of Different Set of books
- Designed and configured Work structure, Organizations, Setting up of Banks both Internal and Supplier,
Confidential,(Dec - 05 - Aug- 06)
Functional Consultant
Responsibilities
- Member of the core team responsible for implementing GL, AP, AR, CM
- Manage Supplier Invoices: Match Invoices to Purchase Orders and Receipts
- Enter Invoice and a single Invoice Distribution, multiple Invoice Distributions; Place a Hold on the Invoice, Recurring Supplier Invoices
- Worked on the customizing of Standard Procure to Pay and Order to Cash cycle as per the client requirements.
- Issues relating to Cross validation rules and Security rules in approval process
- Defining business user required setup for Approved Supplier List
- Defining business required Sourcing rules
- Process Supplier Credit Memos
- Manage Prepayments
- Issue Employee Expense Payments (Manual & Quick Payments) and Issue Supplier Payment (Batch Payments)
- Import Invoices from Order Management via Auto Invoice Interface
- Enter Manual Customer Invoices with Transaction Batch and without Batch.
- Enter Credit Memo and Debit memo related to an original invoice: Credit Memos may be entered manually in Accounts Receivable to adjust a customer’s account balance.
- Manually Enter Customer Receipts, Enter Quick-Cash Receipt Batch, Mass Apply Receipts to Consolidated Invoices
- Process Manual refunds to Customers
Confidential,(Feb - 04 - Nov- 05)
Associate Consultant
Responsibilities
- Provide regular support to Global Finance team on Finance (AP, AR, FA and GL)
- Handling month-end period closing issues.
- Development of functional specifications for reports with Finance team.
- Coordination with technical team on development activities
- Testing the Functionality after development of the Requirement.
- Configuration and testing of setups in Accounts Payable, Accounts Receivable and Projects for Australia, Canada, India, Hong Kong
- Preparation of AIM documents and other process related documents like BR-100, MD-50, TE-40, SIT & UAT.
- Working with Oracle support and development to identify and resolve issues within the standard applications.
- Analyze functional end user requirements and create Oracle Applications functional detail design documents following Oracle Applications best practices.
- Involved in integration process for Projects and done end to end Testing.
- Uploaded Assets & supplier site data using ADI & Data Load.
- Facilitate knowledge transfer meetings and mentor junior team members on functional tips and techniques.
Confidential,(Accountant)
(Apr- 2000 Feb-2004)
Participated as an Accountant of a Financial Accounting System, which includes of journal, ledger, sub ledgers like account receivable, accounts payable, staff advance ledger, and preparation of trial balance, trading profit & loss a/c balance sheet. This system includes projected profitability analysis, reconciliation of accounts & customer credit history, and other management information reports.
Roles And Responsibilities:
- Audit of regular books of Accounts
- Preparation of books of accounts on system
- Preparation of Banks Reconciliation’s Statement.
- Identifying Training needs and planning.
- Preparations of p& l a/c, Balance Sheet.
- Release of monthly house journal -
- Following the creditors for payments