SUMMARY

• 13+ years of experience in Confidential Financials and supply chain in R12/11i versions of Confidential E - Business Suite. With IT Companies like Confidential ., Confidential, Confidential, Confidential, Confidential and CAPGEMINI.
• 9+ years of experience as a Finance/SCM Functional lead with R12 & 11i
• Completed PMP training
• completed CBAP training
• Completed Wharton accounting course
• Confidential E-Business Suite R12: E-Business Essentials
• Extensive knowledge in complete Functional Flow of Order to Cash (O2C) cycles, Record to Report(RTR)
• Subject Matter Expert in Modules including Order Management, Inventory, Purchasing, isupplier, WIP,BOM, Cost Management, Account Receivables (AR), Sub-Ledger Accounting (SLA), General Ledger (GL), E-Business Tax (E-BTax), Confidential Payments
• An extremely motivated and driven business professional. A leader who maintains perspective even in the face of diverse cultural barriers. Brilliant, quirky and talented; even in the face of challenging deadlines and budgets.
• Analysis - Being able to see beyond the standard, looking outside of the box and presenting these ideas in a non-challenging way, but instead, in an intriguing or inspiring manner.
• Planning and Designing - Planning is virtually designing in progress. I create a plan that progresses into a design as I go, changing throughout the process until all needs are more than met, they are exceeded.
• Implementing the right solution - This, in and of itself, is a rare talent because many may analyze, plan then designs fall short on what they promised to deliver.
• Strong expertise working with all phases of SDLC from project inception/initiation, planning to close
• Experience working with different stake holder s at all levels from executive to business partners
• Involved in planning and requirement gathering meetings
• Strong experience in maintaining AIMS documents such as BP-40,BP-80,BR-50, BR100, M50,T40
• Effectively work with the business partners to align business requirements with IT projects.
• Worked with different business partners to prioritize projects on monthly/quarterly basis.
• Effectively streamlined the change management and support process
• Worked with business partners on agreement on support SLAs.
• Coordinated among different team for smooth month end close of accounting and inventory periods
• Organized regular meeting with different stakeholders to streamline or set up new processes
• First point of contact for any new requirement or change in ebs due to change in existing process upstream
• Analyzed the requirement to assess the impact if any on existing process and impact on the downstream process
• Effectively planned the delivery of deliverables through different phases like development, QA and production migration
• Organized weekly meeting to monitor the progress of deliverable with onsite and offshore team
• Organized War room sessions for pre and post implementation support.
• Effectively communicated the project statuses to stakeholder at all levels.
• Worked with third party vendors for new product selection.
• Monitored resource utilization on the project
• Interviewed resources for project and support team.
• Planned cutover strategy and plan for go live.

TECHNICAL SKILLS

Oracle Apps Release: R12, 11i

Oracle Apps Modules: Order Management, Inventory, Purchasing, isupplier, WIP, BOM, Cost Management, Purchasing, Account Receivables (AR), Sub-Ledger Accounting (SLA), General Ledger (GL), E-Business Tax (E-BTax), Confidential Payments.

Process: BP40, BP80, RD.050, BR.010, BR.030, BR100, TE.040

Tools: Dataloader, Webadi

Languages (limited): SQL

Misc.: Visio, Power point, Excel, Word, HP Quality Centre, Textpad, Wincvs

PROFESSIONAL EXPERIENCE

Confidential,Los Angeles,CA

Business Analyst/Solutions Architect

Responsibilities:

• Organized and Planned meetings for new initiatives/enhancements and gather user requirements
• Set up new IR/ISO process
• Helped user remove revenue account from AR aging report by creating positive CM
• Created new order types to capture internal emp. Expense like employee drinks just to record the cogs

Environment: Confidential Applications Release R12

Confidential,Durham,NC

Business Analyst/Solutions Architect

• Attend Planning meetings for new initiatives and gather user requirements
• Arranged requirement meetings with super users to understand current business process flows
• Based on the new requirement created the new process flows
• Performed fit gap analysis and created MD50 for custom solution
• Created BR100 document
• Configured OM setup for different operating units
• Configured setups such as system parameter, validation inventory org, transaction types, assign workflows as per the business needs to transaction types, processing constraints, defaulting rules, holds, hold sources
• Created md50 or requirement for different personalization to perform business checks while order entry
• Designed the TO BE process for a new customer onboarding and order fulfillment for customer consigned inventory
• Designed the inventory sourcing and intercompany order fulfillment flow
• Defined inventory location at new customer sited with items set to min-max planning.
• The internal requisition from min max planning is fulfilled by ISO from another operating unit
• Worked with intercompany accounting team to help them reconcile the intercompany accounts
• Performed the intercompany setup for new operating units and shipping networks
• As part of the process flow performed the requirement gathering for different pricing qualifier and modifier
• Performed the requirement gathering for setting up the pricing security across operating units.
• Based on this enabled the pricing security across operating units at responsibility level and thus helped meet SOX compliance of segregation of duties
• Helped costing team with reconciliation for different inventory orgs and provide them with solution for if there are any issues for variance in the system or was it due to business process change
• Worked with the users under requirement for any new process and suggested setting new order types for any new process where applicable
• Set up cycle counts for different inventory orgs based on item classification as discussed with the business
• Set up the shipping
• Configured the picking rules, pick slip grouping rules, release rules, shipping rules, shipping parameters
• Performed the requirement for prepayment order and according enabled the Confidential payments
• Set up the order payment with different credit card brands, processing rules
• Set the credit card masking in payments as per the company/PCI compliance policy
• Worked with user to understand the return process and according suggested them to set up new sub inventory and receive the material in those sub inventories
• As per the business requirement and steering committee approval set the order shipment, arrival and fulfillment set
• Performed requirement gathering with the receivables team to understand the requirement for setting up the transaction sources, transaction type, invoicing rules, accounting rules, revenue recognition criteria, payment method, internal bank setup and accounts, aging buckets, dunning letter, billing frequency, customer profile, credit limits
• Accordingly setup the automatic invoice processing for bank account transfers and credit card payments
• Worked with the tax team to gather the requirement for ebtax
• Configured ebtax to calculate sales tax in sales orders based on the business requirements
• In ebtax set up the content service (regiment to rate) and determination service(tax rules)
• Configured the receivables activities to process misc. receipts
• Set up the refund process for non credit card refunds to automatically process and create ap invoice.
• Set up the refund receivables activity and prepaid payment term
• Assigned the required menu to the responsibility in payables to be able to process the refund
• Held workshops with business to review process and re-engineer the existing 100% manual process

Environment: Confidential Applications Release R12

Confidential,Desmoines,IA

Manager Oracle EBS

• Led the team for new projects and prod support.
• Documented the support plan
• First point of contact for user for any new initiative
• Involved in SLA (service level agreements)planning and freeze meetings with the business users
• Aligned the IT Calendar with the accounting close calendar for freezing prod migrations
• Worked with users on a monthly basis for prioritizing the enhancements for each period
• Performed impact analysis for any new changes initiated upstream
• Worked with QA team for streamlining handshaking process like testing, timelines and signoffs
• Scheduled weekly status call with development team to monitor the progress
• Reviewed the project plan for separation of company operating unit to new instance
• Reviewed the BR-30 for purging, masking the data in different modules(AP, GL, FAH, Iexpenses)
• Determined the resource planning and utilization.
• Worked on aligning the Confidential Business Process Document with the Organizational BPD.
• Interviewed candidates for different projects.
• Monitored daily tickets resolution statuses
• Was the point of contact for month end accounting close for ebs and Coordinated the month end between different IT teams
• Created Disaster Recovery Document
• Reviewed the BR100s
• Performed requirement gathering for changes in defaulting the charge account in iproc and explored different options so as to pick the cost center of the employee requesting the item as against the employee entering/preparing the requisition.
• Advised the ETL/EDW team on how to improve performance for their queries for extracting data from R12
• Involved in the project meeting for changes to FAH(new event and modifications/additions to mapping set and ADR)
• Provided prod support based on bandwidth and delegated tickets to team.

Environment: Confidential Applications Release R12

Confidential,NYC, NY

Oracle Apps Prod Support Analyst

• Performed requirement gathering and prepared MD-50 for supplier interface
• Analyzed the reports for reasons of difference between cogs and dcogs account.
• Ran the record order management, collect revenue recognition information, generate cogs recognition events to move dcogs from cogs for transaction having high dcogs.
• Provided production support and assigned tickets to offshore as required
• Created new order type and assigned workflow to order types
• Helped accounting team with month end close for different financial modules

Environment: Confidential Applications Release 11.5.10

Confidential,Louisville KY

Functional Analyst OTC

• Attended planning meeting for adding the new company acquisition as operating unit or customer or inventory organization
• Performed analysis for integration of Confidential and ups
• Performed analysis for enabling ipayments in 11i and the point where they should be triggered whether at order entry or AR invoicing
• Attended meetings with business users to get clear understanding of the requirement
• Analyzed the requirement and provided the project estimate.
• Provided user solution for making inventory cost changes i.e. issues out inventory and receive it back
• Helped user sweep unaccounted transactions to next period during period close.
• Fixed issue in the invoice workbench where invoice name had an additional space and could not be cancelled
• Participated in change management meetings
• Setup new printer in Confidential application as an system administrator
• Fixed the Inventory close period end errors. Applied data fix provided by Confidential
• Create order types and assigned the workflows to the order types
• Fixed payable issue where payments where not being transferred to GL.

Confidential

Senior Oracle Application Support Analyst

• Working in Support and upgrade project(11.5.10.2 to R12)
• Analyzed the source module to verify if customization to standard workflow are supported.
• Worked on different modules like AP,AR, GL,TCA.
• Understood the requirement and created technical design documents (MD70).
• Developed another package for validating and generating xml file in the specified directory.
• Created UTPs’ (TE20) and performed unit testing
• Performed system integration testing
• Involved in the Integration and UAT test phases.
• Worked on data migration(RICE Components)
• Led a team of 5 persons. Coordinated between the development team and the onsite functional team got clear understanding of the requirements.
• Resolved issues for team members
• Worked on inbound and outbound interfaces like autoinvoie, supplier interface, supplier bank interface, gl daily rates
• Interacted with the business user for requirement gathering for system load testing.
• Created Test scripts for load testing

Environment: Confidential Applications Release 11.5.10

Confidential

• Developed a custom workflow (RICE Component) for sending notification with attachment to different groups.
• Prepared the technical documents such as MD-70, TE-20 as per the requirement in MD-50.
• Co-ordinated with the onsite team for issue resolution.
• Identification of the customer requirements for custom workflow (RICE Component),
• Translating the requirements in to technical specifications.
• Implementing and developing custom workflow for importing the orders from custom order tables into order management using the workflow builder 2.6.
• Designed and developed numerous packages procedure and functions for importing the orders into order management and then pick releasing the orders.
• Involved in importing supplier data from legacy system into Confidential applications using supplier conversion.
• Coordinated between business operational user, end user and project manager.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL
• Procedures and reports. In addition, also used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets.

Environment: Confidential Applications Release 11.5.10.2

Confidential

• Involved in Workflow Customization of standard workflow PA PROJECT WORKFLOW in Project Accounting (RICE Component).
• Designed and developed numerous packages, procedures, functions for different nodes in the workflow to perform to achieve required actions
• Submitted concurrent program from workflow
• Created temporary tables and developed SQL*Loader control files to load data from external systems for custom conversion to load employee cost rates and bill rates.
• Coordinated between business operational user, end user and project manager.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL procedures and reports. In addition, also used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets.

Confidential

Software Engineer

• Customer Item and Item Cross Reference Upload.
• Approved Supplier List Conversion
• Designed and developed reports(RICE Component) like negative inventory report, debit/credit memo report
• Prepared the technical documents MD70, MD120, TE20 etc
• Design of GL Conversion Interface(RICE Component):