Professional Synopsis:

• 15 years of Professional IT experience with more than 8 years as an Oracle Financials Functional Consultant in multiple versions of Oracle E-Business Suite Financials
• Excellent skills with playing vital role in conducting numerous business meetings for all key important business process decisions and proposed solutions in Oracle according to the size and nature of the organization
• Extensive knowledge in General Ledger GL with Advanced Global Intercompany Systems AGIS , Sub-ledger Accounting SLA , Account Receivables AR , Account Payables AP , Fixed Assets FA , Cash Management CE , E-Business Tax EB-Tax , and Purchasing PO .
• Tremendous knowledge of Multi-org, Advanced Global Consolidation Systems, Advanced Global Intercompany Systems, Financial Statement Generator, and Sub-ledger accounting
• Expertise in working on multiple versions of Oracle in both 11i and R12
• Worked on multiple Global Implementations, Up gradations, and Post Production Support projects
• Played key role in providing manual work around solutions for critical business scenarios in order to minimize the customizations and provide sophisticated solution for constructive business transaction process
• Having process knowledge on Order Management, Purchasing, and Inventory moreover, Procure to Pay P2P , Order to Cash O2C , Acquire to Retire A2R process cycles with cross function integration
• Providing application requirements gathering, designing, development, functional documentation following with business approvals
• Excellent knowledge in preparing and maintaining Oracle AIM methodology documentation including BR100, BR30, BR150, BP80, RD20, MD50, TE40, and CV40 and Change Management Process documentation
• Preparing test scripts, performing quality assurance tests Smoke testing prior to user testing.
• Proficient in providing design solution for all custom components RICE
• Adept in Data Conversion with data migration Lifecycles
• Experience in using some tools, but not limited to, are ADI, Web ADI, Hyperion, BI/XML, and Discoverer
• Excellent in process mapping, process improvement, configuration, development, functional documentation, training documentation, and production support
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through financial closing revenue and expense cash/accrual concepts adjustments and financial statements
• Configure Business access as per SOX compliances and setting up responsibilities accordingly to maintain the proper internal control mechanism

Technical Skill Set

• Oracle Financials: GL, AGIS, AR, AP, FA, CE, E-B.Tax, PO, Sys Administrator, iExpense, P2P cycle, A2R
• cycle, and O2C cycle
• Operating Systems: Microsoft Windows: 98/XP/Vista/7, Windows NT 4.0/2000 Server/Workstation,
• Other Tools: ADI, Web ADI, Discoverer, SQL Plus, Data Loader, TOAD, PL/SQL Developer, QTP, SQL
• Loader, Load Runner, HP/Mercury Quality Center, BI/XML Publisher and Hyperion
• Programming SQL PL/SQL, FORTRAN, JAVA, JavaScript, HTML5, PHP
• Languages:
• Other software: Microsoft Office: Project, Word, Excel, Power point, Visio, Access PVCS Tracker, Mercury
• ITG TD, IBM Clearquest, Lotus Notes.

Confidential

Key Activities:

• Coordinate with Business team on day to day application issues and provide quick updates on issue resolutions along with status updates on open items tracked in ACSI Service Centre.
• Create and maintain documentations in MBS McDonald's Business System for the proposed solutions along with Impact analysis.
• Coordinate with Offshore team for speedy resolution of open issues based on priority
• Provide detailed root cause analysis on all assigned issues with reproducing the same in latest cloned copy of test environment.
• My core responsibilities involved with trouble shooting in the area of AR, AP, and GL modules.
• Worked closely with the team members who conducted trouble shoot activities for the other Oracle applications such as Oracle Projects, Oracle Fixed Assets, AP Check Printing, BI, Discoverer, XML both in US and Canada operations
• Daily monitoring of incident issue tracker in Service Center site and assigning jobs to Offshore team
• Worked closely with offshore technical support team
• Conducted and participated for daily upgrade teleconference meeting with Off-shore team, discussed about findings and issues. Advised the team to raise Service Request with Oracle support team which is dedicated for McDonald's
• Attended and discussed issue resolutions and work-in-process update at the meetings with clients in regular intervals.
• Test the resolution to fix the issues and explain business team with cause of issue and impact, if any
• Create and follow-up on multiple SEV1 SEV2 SRs for speedy resolution
• Followed up with Oracle team to fix errors while conducting sql code writing, upgrading, manipulating, editing, inserting using Toad for Oracle DBS
• Oracle base table analysis related to form errors and coordinate with technical team for speedy resolution and test the same
• Sql/plsql codes for EBS applications extensions, field additions, attribute introductions
• Provide Analysis in identify sql code logic to trouble shoot application errors at different intervals
• Generate eSox for code migration communication
• Worked closely with Client-side IT team to discuss and present resolutions for application errors with proposed fix
• Coordinate with DBA team to apply patches proposed by oracle after following up on existing issues
• Conduct OWC with Oracle Technical Support Team
• Provide impact analysis on proposed changes and document the complete Change Management Process

Confidential

Key Activities:

• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents
• Worked closely with Grants and Project modules to interact data to financials modules
• Identified sources generating revenue through grants to AR module
• Funding segments are set to identify the sources from federal, state, local and member agency local and SCRRA
• Prepared summary charts, decision made list, future considerations and Parking lot items based on requirement gatherings.
• Prepared To Be Docs for all five modules including GL, AP, AR, FA, and CE
• Identified process flow through Grants module to introduce accounting activities to AR and FA
• Prepared chart of accounts structure to meet the Metrolink funding source requirements
• Identified and configured as per Client's Requirements two future segments in COA
• Defined one Legal entity, one Operating unit for the one ledger introduced to SCRRA
• Roll up groups to identify project funding source category
• Setup manual journal entry only with user responsibility and no auto journal post
• Set up supplier auto numbering
• AME workflow for invoice approval process and hold resolution
• Introduced TCA to manage customer/supplier information and Bank information
• Set up 1099 supplier tax reporting through AP to replace current third party service
• Participated in Client awareness meetings regarding R12 proposals for new implementation
• Presentation of To Be Docs to clients for their opinion on proposed set up and processes
• Templates creation for Cash Forecasting, Cash positioning in CE module
• Defined auto-reconciliation process to handle electronic bank statements with Cash Management module
• Identified category, location, Asset key FF for FA module
• Defined one Corporate Book for managing assets
• Defined asset cost, asset clearing, depreciation expense, accumulated depreciation, CIP cost, CIP Clearing, Depreciation Adjustment as Fixed assets accounting
• Per clients requirements, defined Straight Line Method STL asset depreciation and proposed depreciation ceilings and bonus rules
• Identified the use of the current Descriptive Flexfields in Purchasing into AP
• Set up asset retirement feature
• Discussion how to integrate Metrolink's current Asset Work to proposed FIS
• Identified the flow for Fare Revenue accounting through Grants to AR automation
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components
• Prepared test scripts/smoke testing prior to user testing
• Configuration of CRP and UAT instances

Confidential

Key Activities:

• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents
• Designed chart of accounts to meet the client's business requirements
• Set-up accounting period types and accounting calendars
• Developed cross-validation rules
• Set up Fixed Assets including defining category, location, and asset key flexfields
• Defined the prorate convention, prorate calendar, depreciation rate and calendar, fiscal calendar, book controls and system controls
• Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
• Defined Asset TAX Book Performed Quick Additions, CIP Additions, Mass Additions and Capitalized CIP Assets.
• Performed Asset Transfer, Mass retirement, Reinstate the retirement and Mass Changes in Assets
• Worked on Construction in Process CIP assets, adjustments, and classification of assets
• Grouped assets associated with a specific project, department, and location to track CIP assets in the organization
• Participated in planning and set-up of accounting flex-field structure and chart of accounts
• Setup Oracle Payments for Check, ACH, and Credit Card Payment Methods
• Set up the financials and payables options and created different bank accounts for Payables
• Involved with migration of historical data for Account Payables
• Created newer FSG reports depending on the business requirements
• Involved with study of existing system, preparing the Functional MD50 with Conversion Mapping Document CV40 to extract data from legacy system into Oracle Applications open interface tables
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components
• Configuration of CRP1, and UAT instances
• Preparing test scripts and performing smoke testing prior to user testing
• Keeping track of and updating issues with proposing resolution in Bugzila issue tracker
• Involved in month-end closings, interfaces maintenance, and change management
• Designing of user-manuals for the modules and training the end users

Confidential

Key Activities:

• Conducting Orientation with client to discuss R12 upgradation
• Interaction with Business Users to understand better their main points and Key requirements
• Understanding current Chart Of Accounts and propose a future design to enhance the way Atrium does Business currently with a new Chart of Accounts in R12
• Configuring/Updating Functional Setups of GL, AP, AR, and CE modules
• Discuss and Suggest a new Chart of Accounts structure to enhance the Performance of the current Business
• Designing and Developing Demo sessions for the Modules with the Respective users for R12 Environment.
• Defined and generated FSG's for Balance Sheets where rollup groups are considered for aren't/child relationship
• Configure and setup Tax in E-B. Tax module
• Prepare custom financial reports for month-end MU process using FSG
• Discuss and analyze handling of Project Capital Assets As-Is and To Be Process
• Design and set up scoring engines for Receivables.
• Setting up collections lookups to ease of maintenance and data entry
• Define Scoring models and Credit checklists for validated/ Approved customer list
• Gathering Business Requirements for Upgrade considerations and documenting them
• Configuring Working session exercises for the key processes performed
• Developed Workflows to customize the approval Process for Journals
• Preparing Visio Process diagrams for AS IS and To Be Scenarios
• Capture and upgrade all the Custom Processes and Reports
• Provide a Demo environment to show the Intercompany AGIS Future transactions in R12
• Interface PeopleSoft Financials to Oracle GL/AR for creating transactions
• Upgrade and modify the current Revenue Recognition schedule in AR to reflect R12 changes and Future Business needs
• Develop Unit TE.020 and System Integration Test Scripts TE.050

Confidential

Key Activities:

• Provided post production support for all financial modules with month end closing related as well as regular issues
• Implemented new Auto accounting rules for Receivables to help drive the right accounting
• Supported procure to Pay issues with month end and additional configurations
• Set up the auto accounting and accounting rules
• Provided Test cases and executed them for any new projects
• Setup MOAC for Payables module to restrict access to different operating units
• Setup Sub ledger Accounting for Receivables third party merge activity
• Resolved any month end related issues involving and data fixes or configuration changes
• Configured AGIS for mainstream to handle their intercompany transactions along with defining intracompany rules
• Implemented Dunning letters in Receivables for customers to send on a monthly basis based on the aging of the invoices
• Resolve month end reconciliation issues in GL Reporting standard and FSG reports
• Defined Subledger accounting SLA rules to handle third party transactions in Receivables
• Provided solution for cleaning up Security access with the appropriate responsibilities as per the employee position
• Correct any autoinvoice errors while importing the invoices and while working with Oracle wherever necessary
• Resolved month end issues with Projects and helped import successfully any accounts or invoices related
• Setup various rollup groups to reflect in reporting for financials
• Work with oracle and resolve any data fixes needed for month end close

Confidential

Key Activities:

• Worked on business requirement gathering with documentation of BR100 and BR150.
• AS IS and gap analysis.
• Detail business process analysis and research to enhance the business process
• Provide resolution of the issues related to AR, AP, and GL worked in collaboration with business users, technical team and other concerned stakeholders
• Member of the core team responsible for implementing GL, AP and AR
• Interacted with the client team to understand the existing business practices and prepared the business requirement definition document
• Participated in designing the chart of accounts to meet the client's business requirements
• Configured the Multi-Organization Access MOAC , Ledger Setup, and Legal Entities
• Used Accounting Setup Manager for Inter-company Transactions
• Provided solutions for all custom components, RICE
• Created Customized responsibilities, customized menus, customized request groups
• Created BR100 documentation for GL, AP, AR, SLA
• Created Test Scripts TE040's for UAT sessions
• Provided various custom solutions for client's specific needs.
• Prepared and executed test scripts and created user-manuals and trained the end users
• Provided various custom solutions for client's specific needs
• Provided with Post production support for various issues after go live
• Resolved the application issues interacting with oracle support through SR
• Drafted extensive set of requirements, questionnaire and gap analysis
• Involved in the design and configuration of chart of accounts, accounting periods and accounting calendar for each legal entity
• Designed the primary ledger, secondary ledger, functional currencies and reporting currencies using the accounting setup manager
• Involved in the design and setup of legal entities and the related inventory organizations
• Involved with the integration of sub ledger for meeting multi GAAP corporate and physical accounting requirements
• Used accounting methods builder in sub ledger accounting for analysis, auditing and reporting of journal entries
• Defined security and cross validation rules
• Worked on CV40 conversion documentation.
• Involved in the setup of tax configuration using the Regime to Rate flow and setup of tax rules
• Setting up of fiscal calendar in FA that maps to the new GL calendar
• Configure new prorate conventions based on the fiscal calendars.
• Create new corp. books and tax books that are associated with new calendars and prorate conventions.
• Assign asset categories to corresponding new corp. and tax books and convert assets from old books to new books.
• Reviewed business processes initiated setups, developed and executed test scripts
• Setting up of PO matching options, invoice tolerance, term holds, expense report templates
• Setting up of banks ,bank branches and bank accounts, and configured the financials and payables options
• Involved in the setup of auto invoice workflow
• Involved in end user training and user acceptance testing ,preparation on test scripts TE 040 and integration testing
• Worked on Hyperion Shared Services and created numerous users, groups and provided them with different privileges.
• Worked on Financial reports Income statements, Balance sheet, and Cash flow using Hyperion Financial Reporting Tool.
• Created and involved Users, Groups, Application, Assigned securities, Application Profiles in Hyperion Financials Management.