SUMMARY

• 13+ years of Total IT experience in Oracle Financials and Supply Chain Management (SCM)in R12/11i versions of Oracle E - Business Suite.
• 5+ years of experience Leading and managing team
• Completed PMP training completed CBAP training
• Completed Wharton accounting course
• Oracle E-Business Suite R12: E-Business Essentials
• Managed team for support and enhancements for Confidential plc.
• Led for P2P and financials tracks
• Managed the month end close process for Confidential for IT perspective
• Create plan wbs(Scope) for deliverables.
• Created resource plan based on wbs.
• Involved in critical path planning.
• Involved in project status meetings with PMO/Steering committee for project GO-NO.
• Managed the component scope and schedule to meet the business objectives
• Participated from IT in planning meeting with business executive/VPs’
• Aligned the IT Calendar with the Accounting Close calendar
• Planned and Monitored deliverables across different phases like configuration, development, QA,SIT UAT and migration to PROD.
• Reengineered manual processes suggested oracle standard and custom solutions to automate the process
• Planned and managed implementation of several process improvement, enhancement projects improving efficiency and introducing new functionality to support the new and changing needs of business
• Motivated, ensured consistency and excellence, built consensus, mentored and managed the performance of the team.
• Mitigated risk by identifying, escalating and resolving issues across multiple groups and/or projects
• Managed all aspects of the team including hiring/retention/reduction of the team, development of skill set profiles and monitoring performance of team members
• Coordinate with Business users to introduce more rigor in their process so that the requirements are vetted and signed off before they are taken up by the IT team
• Led a team of developers and functional consultants to support the oracle EBS.
• Strong experience with different phases of project from planning to close
• Strong experience in technical and Functional roles with R12 & 11i
• Involved in planning meetings .
• Created project scope and requirement gathering plan
• Performed stakeholder analysis and created stakeholder communication plan
• Created support plan
• Utilized organization assets where possible.
• Created schedule plan for the deliverables
• Organized regular team meeting to track progress and monitor statuses
• Created resource weekly utilization plan support
• Effectively communicated the progress status to the executive team in a timely manner.
• Effectively worked and coordinated efforts with cross functional upstream and downstream team.
• Streamlined and set up ITIL processes such helpdesk documents, incident management and change management process.
• Aligned the IT Calendar with the close calendar
• Extensive knowledge in complete Functional Flow of Record to Report(RTR),Procure to Pay (P2P) and Order to Cash (O2C) cycles
• Subject Matter Expert in Modules including General Ledger (GL), Account Payable (AP), Payments,Account Receivables (AR), Sub-Ledger Accounting (SLA), Cash Management (CE), E-Business Tax (E-B.Tax), Fixed Assets (FA), System Administrator (Sys Admin), Oracle Payments,Iexpenses, Advanced Global Intercompany System (AGIS), Financial Accounting Hub(FAH),Order Management, Purchasing, Iprocurement, Inventory, AME, Property Manager
• Supplemental experience with manufacturing modules like WIP, MRP, Isupplier
• 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,MD70,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, 11.5.10.2, 11.5.9

Oracle Apps Modules: General Ledger(GL), Accounts Payable (AP),SLA/FAHProject Accounting (PA), Accounts Receivable(AR),AGIS Inventory(INV),Order Management (OM), IprocuremeentIexpense, Fixed Assets,Purchasing,Payments,AME Limited BOM,WIP, MRP.

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

Tools: Dataloader, Webadi

Languages: SQLDB ToadVisio, Power point, Excel, Word, HP Quality CentreTextpad.Wincvs

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst/Solutions Architect

Responsibilities:

• Managing the customer onboarding project planning, scoping, resource, planning, scheduling
• Documented the process flow diagram(To-Be) and high level requirements and solutions
• Priortized the requirement
• Attend Planning meetings for new initiatives and gather user requirements
• Documented Requirement for new operating unit with subledgers payables,receivables ebtax
• Set up new operating unit
• Worked with the user to understand the AS IS process for receiving and documented the AS-IS and TO-BE process for one of the inventories warehouse
• Provided solution for automating debit memo creation for RTS
• Provided solution for customizing the account generator workflow to use requisitioner’s account as the expense account instead of buyer’s account.
• Worked with the user to under the requirements for new ledger .
• Worked with user to gather the requirement for credit card tokenization process and designed the credit card process for prepay orders
• Configured ebtax to calculate use tax in procure to pay and sales tax in sales orders based on the business requirements
• Worked with the user to understand the pricing security requirements and based on that enabled the pricing security across operating units
• Gathered requirements for setting up the multiperiod accounting to amortize prepaid invoices
• Gather requirements for fixed assets for new operating unit and accordingly configured the corporate and tax books.
• Performed requirement gathering for cash managment
• Created webadi template for uploading the assets.
• Setup new bank,bank branch nad bank accounts
• Assigned bank account security access to legal entity
• Help your purge the translation account by purging the translation period translation
• Configure New Ledgers
• In SLA created custom slam,jldl,aad,linetypes.
• Created custom source and adr
• Tested End to End flow for procure to pay and order to cash
• Performed UAT with the users.
• Helped user with recon issues for fa,receivables,payables,gl
• Holding workshops with business to review process and re-engineer the existing 100% manual process
• Support month end close issues

Environment: Oracle Applications Release R12

Confidential

Manager/Lead Oracle Application R12

Responsibilities:

• Managed a team of onsite and offshore resources
• M anaged new projects, prod support and new enhancements requests
• Managed stakeholders by organizing monthly and bi monthly prioritization meetings to prioritize projects and new enhancements
• Created communication plan and effectively communicated the project status to executive and super user stake holders
• Identified risks and potential remediation and documented the risk mitigation plan like potential delay in go live time If network speed was not ramped up to copy data from Canada to US
• Organized weekly status meeting to monitor the progress of deliverables
• Documented the support plan
• Created resource utilization plan
• Created requirement plan
• Negotiated the SLA with business partners
• Worked on aligning the oracle Business Process Document with the Organizational BPD.
• Aligned the IT Calendar with the accounting close calendar for freezing prod migrations
• Interviewed candidates for different projects/onboarding.
• Monitored daily tickets resolution statuses
• Ensured that the support slas’ are meet by monitoring different reports like daily open issues, SLA breach report, incident resolution time.
• Managed and planned the month end close process for IT .Published the close plan with timeline of completion for each activity.
• Ensured that the business and support kpi like system up time, support availability are maintained,ticket resolution .
• Worked with QA manager for streamlining handshaking process like testing, timelines and signoffs
• First point of contact for user for any new initiative
• Performed impact analysis for any new changes initiated upstream
• 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)
• Created Disaster Recovery Document
• Reviewed the BR100s
• Provided prod support based on bandwidth and delegated tickets to team.

Environment: Oracle Applications Release R12

Confidential

Oracle Apps Prod Support Analyst

Responsibilities:

• 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 monthend close for different financial modules

Environment: Oracle Applications Release 11.5.10

Confidential

Oracle Apps Prod Support/Functional Analyst

Responsibilities:

• Attended planning meeting for adding the new company as operating unit or customer
• Performed analysis for integration of integration of oracle and ups
• Performed analysis for enabling ipayments 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 he 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 ap 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 oracle application as an system administrator
• Fixed the Inventory close period end errors. Applied data fix provided by oracle
• 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

Responsibilities:

• 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: Oracle Applications Release 11.5.10

Confidential

Responsibilities:

• 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 oracle 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: Oracle Applications Release 11.5.10.2

Confidential

Responsibilities:

• 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

Responsibilities:

• 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):