SUMMARY

• 6+ yrs. of experience in domain and functional Oracle ERP implementation, support, upgrade in Financial Modules.
• Worked as an Oracle Functional Consultant and Oracle Functional Analyst and played a key role in designing and implementing applications in P2P and O2C wif specific expertise in AP, AR, GL and third party systems.
• Exposure and experience manly in Interfaces, third party integration and complex customizations. Experienced in all life cycle stages of implementation, SDLC, including GAP analysis, design, development, agile work flow, up - gradation, documentation and testing Applications in Oracle R12. Know to work best wif Agile planning.
• Worked as a Functional Consultant & Application Analyst Roles for ERP Oracle Busines Suite.
• Proficient in producing deliverables such as Functional Requirement Definition documents, Interact wif business customers to understand and document their business processes and requirements. Writing training documents, Use Case Realization documents, MD050, BR100, UAT and unit test scripts for teh Development & Test Activities in Oracle Financial Modules.
• Was involved in coordination wif teh development team & end users to ensure quality deliverables, approving test plans, set ups as per teh timelines and time scaling for SR’s.
• Create SQL queries against Oracle tables to troubleshoot, develop metrics, and create ad-hoc reporting as needed. Experience wif low-level ad-hoc query tools (Toad, SQLPlus) and a detailed working noledge SQL queries.
• Experience in engaging Oracle Support to research and resolve issues. Working noledge of bug tracking tools such as Clear Quest
• Experience in process flow from Legacy to AR, AP, OM through SQL* Loader and finally to GL. Core experience in Interfaces of AP, AR, PO and GL and resolving Auto Invoice Issues, Lock Box issues, Resolution of Interface errors and workflows and reports.
• Good skills in SQL Querries, Oracle Discoverer and TOAD.
• Highly efficient in Root cause analysis and complex problem solving skills and business process improvement. Has resolved many issues for client invloving thrid party systems and integration.
• Has good experience working in Reports performance improvement and extracting confidential Financial Reports to HQ using Hyperion & UpStream WebLink.
• Very strong analytical skills wif teh ability to translate business requirements into functional specifications wif an emphasis toward highly available and scalable global solutions.
• Ability to collaborate wif a diverse set of business customers and drive consensus when conflicting requirements are identified. Highly professional in working wif cross teams, confront problems, proposing unanimous solutions and take ownership through to resolution or ensure a clear hand-off. Has a positive can-do approach to work.
• Experience in system admin activities like creation & maintainence of user accounts, security rules, creating responsibilities etc.
• Highly motivated team player wif excellent communication, presentational, interpersonal skills, willing to work in challenging and cross-platform environment.

TECHNICAL SKILLS

Oracle Application Releases: ERP Oracle Applications Version 11.5.10, 12.1.3

Oracle Database Releases: 7.5, 8

Languages: SQL

Utilities: TOAD, Data Loader, SQL* Loader, Oracle Discoverer, Hyperion Reporting Tool, Business IntelligenceTools: Microsoft Visio, Microsoft Word, Excel

Operating Systems: Win-XP, Windows 2000, Win NT Server

Methodologies & Documents: Oracle Application’s Implementation Methodology (AIM), Functional Documents, Data Mapping Documents, BR100, BP080, MD050.

Oracle E Business Suite: Receivables, Payables, General Ledger, Inventory, Purchasing, Order Management, Cash Management iProcurement and iExpense.

PROFESSIONAL EXPERIENCE

Confidential - Seattle, WA

Functional Consultant

Responsibilities:

• Worked on teh on-boarding new AP sub ledgers in EMEA and APAC regions specific to Getty customized requirements. Involved in Project Less, to improve operational workflow, data management, budget management and invoice management solutions.
• Worked implementing and integration Concur Tech solutions to Getty payment system. Lead teh team wif Implemention teh interfaces from Oracle to Concur based on teh clients requirements and customizations. Implemeted expense, invoice and purchasing.
• Providede solutions to implement teh best method for integration. Working noledge of FTP and Client’s web services.
• Worked extensively in teh COA mappings of teh GL Segment structure from teh old to new ones. Played a major role in teh change of COA Structure for Getty. Designing teh test plans to verify dat teh system works as a whole, in a way dat is consistent wif what teh users expect, and to detect inconsistencies and omissions between partitions or iterations.
• Worked on testing teh custom wifholding requirements for wifholding Japan / France and Spain Freelancer invoices in AP module
• Implemented payment method change from check to electronic. Invloved customozation teh payment features which is excluisive to Getty. As Getty is a photo stock agency and teh photgrapgers are paid Royalties.
• Worked on IPM Project for Getty, which involved closing one of their Canada set up and merging it wif USA set of Books. Was involved in PhaseI, PhaseII project related to integration, vendor onboaarding, account validation and payment validation.
• Developed integration from WD to Oracle HRMS. Performed Gap analysis in teh existing workflow design and suggested solution for enhancement. Performed testing and full life cycle of teh workflow.
• Manage issue and change requests and track issues to closure while implementing teh new customizations for purchasing and payables.
• Worked on integration of PayPal and Payoneer to Getty and iStock portals. Designed MD050 on teh integration based on teh agile project and performed extensive end to end testing. Worked in context of both AP and AR
• Worked on drafting a Lockbox Process for Getty iStock Receipts sent via Lockbox methodby HSBC Bank. Automating EMEA and APAC Lockbox file transfer.
• Implementing Indian PAN numbers to teh Oracle AR and printing teh PAN number on teh invoice.
• Working noledge of More4Apps and Data Loader to validate and upload huge amount of data into oralce systems.
• Worked closely wif GL teams and top management in enhancing teh entire companies reporting structure based on teh client needs and projects. Used Noetix reporting tool for teh project.
• Worked in a Audit Prject, where implementied report building and validating teh report data in various currencies and SOB.
• Worked on Pre-Cutover Activities and test plans, Execution of Planned Tasks, Stakeholder Communication, worked on BR100 and implementing teh setups in multiple environments, maintained issue log, go live support and documented lessons learned.
• Ensuring process compliance by teh teams and reengineering of teh existing processes as needed.
• Provide regular updates and statuses to both finance and technology management
• Conduct test scripts for business processes based on teh business requirements and to confirm business users wif business processes for any defects.

Confidential, San Jose CA

Oracle Functional Consultant

Responsibilities:

• Set up Payables, Invoices, Suppliers, Payment terms, Distribution sets, Payables Match, Payables options and Profile options.
• Worked in teh interfaces of invoices through non appliation systems to AP interface tables through SQL* Loader. Knowledge in Payables Open Interface Workflow and resolving issues/errors during teh import.
• Worked in configuring teh Approval Hierarchies, Auto Create, Requisitions and Receivables in PO module.
• Worked on teh setup of Purchasing Options, Financial Options and Document Types inAP, PO Module.
• Work experience is in Process Flow from Purchasing to Payables and finally to Oracle General Ledger and flow from Order Management to Receivables and finally to Oracle General Ledger.
• Worked in Procure to Pay and Order to Cash cycles.
• Work experience in teh set ups and cycle of Procure to Pay (P2P).
• Performed Requirement and Gap analysis.
• Preparing BR100, MD050, BP080, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked extensivley in support and creating UAT, test documents and resolving post production issues wif IT support team.
• Raised and logges SR’s (Service request) assigned, resolved and closed issues wifin teh delegated time line.
• Worked on month end and year period close process ensuring dat all teh balances and invoices are validated before pushing it to GL and for teh Journal Import for AP and AR modules.
• Assisted wif training, creating user documentation and providing support to teams as in Analyst role.

Confidential, Redwood City, CA

Functional Analyst

Responsibilities:

• Worked on teh Functional Mappings for data conversion from 11i to Release 12 for Distribution and Financials modules.
• Implementing and set ups for AP, PO, AR & OM. Was also involved in handling daily AP processes, accurate processing of invoices and purchases, expense reports and payment transactions.
• Worked on Functional designing, Testing and Development of New enhancements including customization of Workflow, Developing new reports in Financials and Supply chain modules.
• Preparing of teh Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) & Functional Testing Documents.
• Worked in teh configuration of financials modules.
• Performed Requirement and GAP analysis.
• Resolving issues in teh interfaces and system admin activities for AR, AP & GL.
• Providing end to end functional support to end users and Finance back office application support.
• Provided documentation for teh Month end Closing process for teh financial Modules to facilitate Proper and timely closing of teh accounting Period. Involved in troubleshooting issues on Auto Invoice Import Program.
• Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on Worked on a customization for Deferred Revenue is AR using Revenue Recognition process.
• Good noledge in Receipts, AR invoices, setting up of customers and interfaces.
• Configured Auto Invoice in AR to import data from teh non Oracle ERP instance. Worked on teh Auto Lock Box process in AR.
• Conducted User trainings on financial modules.
• Experience in system admin activities like creation & maintainence of user accounts, security rules, creating responsibilities etc.
• Good understanding of teh systems issues, requirement analysis and solutions for daily support activities and resolving them in time to ensure smooth running of processes.
• Worked wif cross functional teams around teh globe, having good communication and interpersonal skills.

Confidential, Pennsylvania 

Oracle Application Analyst & System Administartion

Responsibilities:

• Responsible for doing interface processes in AR and GL for various theaters and Responsible for resolving AutoInvoice and Lockbox errors.
• Worked on all teh Auto Invoice issues and service requests for AR and GL modules and on AR and GL set up related issues.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Responsible for raising Service Request (SR) for critical issues. Created test scripts for UAT (User Acceptance Testing).
• Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - CQSR, Oracle Meta Link.
• Responsible for doing reconciliation between ORACLE and legacy systems.
• Involved in setting up of supplier, vendors, employees as supplier, expense reports and validating invoices wif matching principals in AP and PO modules for APAC region.
• Responsible for book closing and opening of teh FTD (Financial Transaction Database) legacy system. FTD is a legacy system maintened by Confidential, which integrates wif different sub legacy systems, from where teh data flows into ORACLE.
• Responsible for teh mapping cost centers in ORATRANS (BlackBox) in alignment wif Oracle Application. Worked on Legacy
• Systems such as Conbil, Globil and WIA and inter transactions wifin Confidential .
• Responsible for implementing teh AR module for various Set Of Books.
• Creation of Users, Responsibilites, Menus, Request sets, Form Folders, Key/Descriptive Fles field Segments / Values, Security
• Rules, Cross Validation rules, Journal Sources, Categories, Document Sequence Assignement, Multi-org Set up, Profile options.
• Contribution in designing teh Chart of Accounts based on teh discussions wif teh Business Super Users as per teh requirements.
• Configures Security Rules and Cost center and local use set up to restrict invalid GL code combinations.
• Business requirement mapping for AR, GL, OM, Inv, Setup of AR, OM, CM.
• Providing end to end functional support to end users and Finance back office application support.
• Provided documentation for teh Month end Closing process for teh financial Modules to facilitate Proper and timely closing of teh accounting Period.
• Conducted User trainings on financial modules.
• Completed Multi-Org configuration by creating a new Organization Structure for Confidential by creating new Business Group, Legal Entity and Set of Books & Operating Unit.
• Developed Multi org Organization model, data security by application, cross organizational reporting and familiar wif OAF.
• Create responsibilities and system profiles/Options, reviewing teh set ups in different instances (development, testing, Quality) and approving it to production instances.
• Creation of Profile Options and Transaction set ups in AR.
• Test teh implemented modules in various (Development / Test / Quality) instances.
• Generated a interfacing program for transferring Data from legacy system to implemented system, using SQL Loader Script & Toad.
• Co-ordinate wif IT Team and DBA’s to make sure dat all teh database Concurrent requests run wif in appropriate time span and reporting.
• Responsible for setting, monitoring and controlling of SLA for critical and regular issues handled by teh Support Teams.
• Handled status calls wif Support Teams for requirement gathering and providing solutions for critical month end processes, involving AR, GL period close.
• Worked wif IT support for Requirement gathering, Study of teh existing Application, Detailed Analysis of teh Business Process Mapping, Compliance study and identification of teh gaps in teh system.
• Working noledge on Global System Administration roles, including giving & creating Oracle Apps user ID’s, granting Oracle Apps access, granting, legacy system access, Oracle Apps setup.
• Generating confidential financial reports & extracts to HQ Management using Hyperion Management Reporting System & Financial Analysis Tools like Up Stream Web Link.
• Very good interpersonal communication wif teams around teh globe APAC, EMEA and LAC regions. Worked wif teams at Amsterdam and USA for facilicating and improving teh month end and year close processes.