SUMMARY

• A result driven professional with 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 within 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 teh 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 with Discoverer & XML/BI Publisher reports and using various templates to publish teh 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 with 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 with 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 with clients to handle business problems, and excellent Organizational skills.
• Having strong experience in Support Life Cycle, SLA management and working with 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 teh synchronization of absence data from Workday into Oracle Fusion.
• Configured Punchout’s with teh suppliers and worked on setups in Production.
• Worked on Item Mapping and created Catalogs internally for teh business.
• Worked on Setup and configurations of Smart forms in Procurement.
• Configured Contacts and Blankets with teh Vendors for CXML- Punchout.
• Trained super users teh 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 teh applications UI appearance to differentiate teh instance and customized teh 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 with multiple parameters and dependent parameters to update dynamically based on teh user logged into teh application.
• Setup custom reports in Excel template to fix teh Excel merge cell issue and provide teh 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 teh 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 teh 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 teh 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 teh task of Uploading Chart of Accounts to load teh chart of accounts structure, including segments and value sets from spreadsheet, worked on deploying teh chart of accounts, worked on Uploading teh 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 with 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 teh requirement.
• Analyze and fix teh 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 teh business users to reconcile and upload teh 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 teh Conversion of Vendors from legacy system into Oracle Applications.
• Customized AR Invoice Report.
• Setup teh new instance using create teh 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 with attachments using Java mail to customers.
• Developed film positive process to print custom film imprints on teh pens and job traveler report with teh order details, components, operations and resources associated to teh discrete job for printing teh films.
• Implemented MOAC to access data from multiple organizations within teh same responsibility.
• Form Personalization done to seeded and custom forms as per client requirements.
• Created Sales orders using CTO items, Pick released and shipped teh orders. Generated Invoice for teh configured orders by submitting teh 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 teh 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 teh 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 teh 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 teh Planning and replenishment tasks for Inventory management on Cycle Counting, Physical Inventory ABC Analysis, and Max-Min Planning.
• Oracle - Customized teh existing Auto Lockbox interface and added a new payment type to teh already existing two payment types during teh Validation steps.
• Interacting with business process owners and steering committee members to expedite teh decision on crucial issues and build teh consensus on conflicting issues.
• Workflow - Customized teh PO approval workflow based on teh 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 teh organizations, setup of inventory items, got teh catalog RFQ, retrieved approval from supplier in R2R cycle and customized teh 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 teh 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 with 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