SUMMARY

• A result driven professional wif around 7 years of IT experience in financial domain (Oracle Implementation, Customization, Development, Reporting, Data Conversion, Interfacing, Upgrade and Maintenance) in Oracle Applications (EBS) R12/11i and Oracle Fusion R9/R10/R11/R12. Experience in major EBS/Fusion R12 Implementations, R12 Upgrade and 11i / R12 Production Support.
• Commendable Implementation of three full cycles in Designing, Implementing and supporting various Financial Modules including 11i & R12 versions of Oracle Financials: Purchasing (PO), Payables (AP), Receivables (AR), General Ledger (GL), Oracle Transportation Planning(MST), i - Procurement, EBTAX, Cash Management (CM), Fixed Assets, i-Supplier and Supply Chain Management (SCM): including Order Management (OM), Inventory (INV) Advanced Pricing and Shipping.
• Extensive experience in implementing Multi-currency, Multi-org/country solutions wifin Shared Services environments in numerous types of industries.
• Extensive experience on design documents for Oracle interfaces like Fixed Asset, Auto Invoice, Customer interface, Lockbox, Supplier Interface, Payable Import, Journal Import, Project interfaces, project extensions, and Employee load data.
• Worked as a Senior Business Analyst & Application Tester gathering information from business users for setting up various modules in Oracle applications mainly concentrating on P2P, R2R, OPM and O2C cycles.
• Extensive experience in registering Concurrent Programs, Form, Functions, Menus, Tables, developing Key and Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL) and System Administration in Oracle Applications.
• Expertise in Client Interaction, Requirement Gathering, Process walk through, Mapping, GAP Analysis and Technical Design documentation and Full lifecycle implementations, Upgrades and Production Support.
• Developed Test Plan and Test cases based on the user stories (Functional requirements)uploaded Business requirements, test scenarios, test cases and defects.
• Experience in testing various types of Invoices in like Standard Invoice, Debit Memo, Credit Memo, prepayment, Expense Reports.
• Extensive experience in OBIEE Administration including Migration, Debugging, Optimizing, Performance Tuning and Production Support.
• Worked on BI publisher reports like Overtime, Higher skills in HR/Payroll.
• Proficient wif Discoverer & XML/BI Publisher reports and using various templates to publish the reports as per user requirements.
• Experience in Discoverer Administration and User Edition for generating number of complex reports in Oracle Financials.
• Perform application tuning and performance monitoring.
• Experienced in FSM, BPM, IDM, FBDI, and FRS along wif Fusion Financials Applications.
• Experience in using and maintaining documentation of Application Implementations Methodology (AIM), SDLC which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE (Report, Interface, Conversion, Extension) components as a part of fit gap analysis, System configuration and testing (BR100, BP 80, BR30, BR 150, MD 50, CV 40 &TE 40), good understanding in various Oracle related products like SQL, PL/SQL, ADFDI and FBDI.
• Worked extensively wif development team members in resolving issues while using METALINK (Oracle Support).
• Good understanding in various Oracle related products involving SQL, PL/SQL, Oracle data integration, WEB ADI, OA Framework, Oracle Workflow, Form Builder, Report Builder, XML Reports/XSL Style sheets, Oracle Business Intelligence (OBIEE) and Oracle Workflow Builder.
• Experienced in communicating effectively wif clients to handle business problems, and excellent Organizational skills.
• Having strong experience in Support Life Cycle, SLA management and working wif Oracle Product and Cloud Infra support group.

TECHNICAL SKILLS

• Oracle Apps 11.5.9/11.5.10.2/ R12
• Fusion Cloud (GL
• AP
• AR
• FA
• CM
• Payment
• SLA
• OM
• INV
• Advance PricingHRMS (CRM) E-B Tax); Oracle (11g 10g 9i & 8i)
• Toad
• Data Loader
• QTP
• Visual Basic 6.0
• Windows
• SharePointMS-office
• Lotus Notes
• Visio
• MS Project
• MS Team Foundation Server (TFS)
• Flex Deploy
• Metaling.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Oracle EBS Consultant

Responsibilities:

• Setup custom financial reports in Hyperion using Financial Reporting Studio.
• Set-up Interfaces, Reports and Web Services for the synchronization of absence data from Workday into Oracle Fusion.
• Configured Punchout’s wif the suppliers and worked on setups in Production.
• Worked on Item Mapping and created Catalogs internally for the business.
• Worked on Setup and configurations of Smart forms in Procurement.
• Configured Contacts and Blankets wif the Vendors for CXML- Punchout.
• Trained super users the Whole Requisition and approval process in Self - Service Procurement.
• Setup custom packages, procedures, functions, sequences, triggers, tables and views in Fusion.
• Setup custom job roles and duty roles and assigned to user accounts.
• Managed user security and web services across Oracle Fusion for integration to third party applications.
• Data Conversion by using FBDI & ADFDI templates.
• Customized the applications UI appearance to differentiate the instance and customized the default application logo.
• Setup and load Budgets into Oracle Fusion and built Hyperion reports against budgets data using FRS.
• Setup Balance Sheet report, Overhead report, Management accounts, and P&L reports using Financial Reporting Studio.
• Setup reports wif multiple parameters and dependent parameters to update dynamically based on the user logged into the application.
• Setup custom reports in Excel template to fix the Excel merge cell issue and provide the default features of Excel.
• Setup Matrix style cross-tab reports and multi tab custom reports using BI Publisher and Interactive layouts.
• Setup Project Team Member allocation integration to dynamically allocate or revoke Project Team member roles based on the setups maintained in FND Lookups.
• Migration of BPM rules and UI personalization.
• Setup CIP Asset analysis report.
• Setup Delegated approvals report to display Override approvals for purchasing approvals.
• Setup custom report to analyze system performance by listing long running processes in the background.
• Involved in Payment terms, Distribution sets, Tolerances and Expense Templates.
• Involved in configuration web services, custom reports setup in GL, FA and PPM modules using BI Publisher and OTBI.
• Worked on the setups of Oracle General Ledger Cloud - defining ledger configuration, defining ledger sets, data access sets, journal approval rules, mass allocations, revaluation, financial reporting center configuration.
• Performed the task of Uploading Chart of Accounts to load the chart of accounts structure, including segments and value sets from spreadsheet, worked on deploying the chart of accounts, worked on Uploading the ledger, legal entities, and business units, etc.
• Worked on Configure tax setup according to local and international tax requirements in Oracle Cloud Financials.
• Worked in Oracle Fusion Cash Management to create banks, branches, and accounts in a spreadsheet and upload them.
• Integrated Cash Management wif Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• System has been tested to meet invoice to cash process applying manual and Auto Lockbox receipts, revenue reorganization in Receivables. Reviewed and confirmed location-based tax setups to meet the requirement.
• Analyze and fix the performance issues for large amounts of data in OTBI.
• Unit testing and documentation of custom objects setup, version control into Oracle Developer Cloud and migration of custom objects into other instances respectively.
• Supporting the business users to reconcile and upload the data by using standard Fusion - FBDI and ADFDI templates.

Environment: Oracle Financial Applications Fusion Cloud R12 (Purchasing, i-Expenses, Procurement, Payables, Receivables, Fixed Assets, General Ledger, E-Biz Tax and Cash Management)

Confidential, Charlotte, NC

Oracle EBS Functional Consultant

Responsibilities:

• Involved in the Conversion of Vendors from legacy system into Oracle Applications.
• Customized AR Invoice Report.
• Setup the new instance using create the Responsibilities, Menus, Concurrent Programs, Requests sets and Custom All, Custom Forms and Report Changes.
• Customized reports for Commercial invoice, packing list and PO print standard and release reports, Inventory Item out of stock report, large order, Back order summary and details of (MD050) reports.
• Extensive Experience in OM API's for BPA Price break update, order creation and order-updating.
• Developed Generic Matrix form for order management and Clarifications form for customer support to send emails and faxes wif attachments using Java mail to customers.
• Developed film positive process to print custom film imprints on the pens and job traveler report wif the order details, components, operations and resources associated to the discrete job for printing the films.
• Implemented MOAC to access data from multiple organizations wifin the same responsibility.
• Form Personalization done to seeded and custom forms as per client requirements.
• Created Sales orders using CTO items, Pick released and shipped the orders. Generated Invoice for the configured orders by submitting the Jobs.
• Worked on Journal Import Interface, Receivables auto invoice Interface, Customer Interface and Payables Open Interface and customized several other reports.
• Provided user training to the End Users on each component to be used at End user.
• Perform application tuning and performance monitoring.
• Worked on Order management, shipping and Discrete manufacturing modules.
• Developed alerts and distribution lists to monitor process activities.
• Created tar files to promote the CEMLI to other instances for Oracle on Demand.

Environment: Oracle Applications R12 (AP, AR, GL, FA, BOM, PO, WIP, INV, ONT, OE, WSH, MES, AOL, SYSADMIN), PL/SQL, SQL, Forms 10g, Reports 10g, OAF, ADF, Workflow Builder 2.6.3.0.1, SourceSafe, BI Publisher, Putty, Windows XP

Confidential, New York, NY

Oracle EBS Analyst

Responsibilities:

• For purchasing, setup the assigned approval assignments, approval groups and approval hierarchy.
• Setup of AP, Mapped GL Accounts and setup Purchase Requisition form routed in Work Flow for approval, on material procurement set vendor invoice in AP for payment approval.
• Setup the Planning and replenishment tasks for Inventory management on Cycle Counting, Physical Inventory ABC Analysis, and Max-Min Planning.
• Oracle - Customized the existing Auto Lockbox interface and added a new payment type to the already existing two payment types during the Validation steps.
• Interacting wif business process owners and steering committee members to expedite the decision on crucial issues and build the consensus on conflicting issues.
• Workflow - Customized the PO approval workflow based on the cost center validation rule setup for client additional requirement.
• Pre-upgrade testing and Post upgrade production live support.
• Involved in upgradation for Purchasing, E-Business Tax, I-Procurement, AP, Inventory, and Procurement Contracts.
• For the organizations, setup of inventory items, got the catalog RFQ, retrieved approval from supplier in R2R cycle and customized the Purchase requisition and auto creation of a standard purchase order by quote to generate receipt.
• Support Production issues on a day to day basis including month end closure p1 issues.
• Define the standard test cases for PO, receipts, invoices, invoice validation/approval, invoice payment and transfer to GL.

Environment: Oracle Applications R12 (AP, GL), Oracle R12, SQL, Forms, Reports 10g, OAF, ADF, Workflow Builder 2.6.3.0.1, Windows XP.

Confidential

Tivoli Storage Manager (TSM)

Responsibilities:

• Design and implementation of enterprise wide Identity and Access Management solution using IBM Tivoli Identity Manager (ITIM) and IBM Tivoli Access Manager (TAM) in Development, Staging, and Production environments.
• Configured ITIM and TAM components to run as non-root users where possible.
• Installed and configured ITIM 5.0 integrated wif AD in POC on AIX platform
• Secured communication between ITIM, TAM/GSO adapters, IHS and WebSphere components using SSL. Created self-signed certificates where possible using ikeyman utility.
• Installed and configured ITIM and required components including WebSphere Application Server, Deploy Enroll application, and IBM HTTP Server, TAM Adapter, TAM GSO Adapter and TAM reverse password agent.
• Designed workflow for password reset (If Help desk changes password then user is forced to change password on next login and if user changes his/her password then user is not forced to change password on next login
• Designed and implemented workflow to generate random PIN for password.
• Configured ITIM for Delegation Administration
• Installed and configured AD adaptor in Dev.
• Created ACIs to give different level of access for different types of ITIM users.
• Created ITDI assembly line for periodic feed.
• Installed and configured Self Service application to facilitate user password management functionality.
• Provided documents and install processes.
• Provide support & review configuration for WebSphere and application integration.
• Mentoring and documentation of said products for smooth transition of ownership.
• Configuration and Administration of ITIM/TAM - design org tree structure, create provisioning and de-provisioning policies, implement id policies, password policies, ACL, reconciliation, service definition, configuring remote resources etc.

Environment: Tivoli Identity Manager (ITIM v 4.6, 5.0), Tivoli Access manager for E-business (TAM v6), IBM WebSphere 5.1.x/6.x, IBM Directory Server, IBM Directory integrator (IDI), IBM HTTP Server, AIX, Shell Scripts, Active Directory