PROFESSIONAL SYNOPSIS:

• Worked for more than 8 years as Oracle Financials Functional Analyst with experience in multiple versions of Oracle E - Business Suite
• Worked on multiple Global Implementations, Upgradations, and Post Production Support projects
• Excellent skills with playing vital role in conducting numerous business meetings for all key important business process decisions and proposed solution in Oracle according to the size and nature of the organization
• Extensive knowledge in General Ledger with Advanced Global Intercompany Systems, Sub-ledger Accounting, Account Receivables, Account Payables, Fixed Assets, Cash Management, E-Business Tax, Purchasing & iExpenses including extensive work experience on integrated modules across SCM modules.
• Have process knowledge on Order Management, Purchasing, and Inventory; moreover, Procure to Pay, Order to Cash, Acquire to Retire process cycles with cross function integration
• Tremendous knowledge of Multi-org, Advanced Global Consolidation Systems, Advanced Global Intercompany Systems, Financial Statement Generator, and Sub-ledger accounting
• Providing application requirements gathering, designing, development, functional documentation follow-ups with business approvals for the same
• Excellent knowledge in preparing and maintaining Oracle AIM Methodology documentation including RD20, BR30, BR100, BR150, BP80, 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/CEMLI)
• Adept in data conversion with data migration Lifecycles
• Expertise in working on multiple versions of Oracle in both oracle R12 and 11i versions
• Experience in using some tools, but not limited to ADI, Web ADI, Hyperion, BI/XML, and Discoverer
• Excellent in process mapping, process improvement, configuration, development, functional documentation, training documentation, and production support
• Configure Business access as per SOX compliance and setting up responsibilities accordingly to maintain the proper internal control mechanism
• Played a 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
• Knowledge of financial accounting & financial business processes, not limited to, but including: financial accounting process through financial closing; revenue & expense cash/accrual concepts; and financial statements
• Other knowledge areas consist of finance strategies, financial accounting and reporting operations, budgeting, planning and forecasting operations, performance management and measurement, and statutory reporting systems
• People and functional management principles including planning and organizing team work, organizing and monitoring work assigned, motivating team members around shared vision, skill alignment with proper resources
• Excellent analytical, problem-solving, negotiation, task and lean project management skills
• Relationship management including building strong relationships between teams, excellent interpersonal skills, strong negotiation and prioritization skills, and strong communications skills

TECHNICAL SKILLS:

Oracle Modules/Cycles: GL, AGIS, SLA, AP, AR, FA, PO, E-B.Tax, CE, Sys Admin, iExpense, Procure to Pay(P2P), Record to Report (R2R), Acquire to Retire(A2R), and Order to Cash(O2C); Knowledge in cross functional modules.

Operating Systems: Microsoft Windows 98/XP/Vista/7, Windows NT 4.0/2000 Server/Workstation, Linux OS Red Hat Enterprise, UNIX OS

Other Tools: ADI, Web ADI, SQL Plus, TOAD, PL/SQL Developer, SQL Loader, Data Loader, Load Runner, QTP, HP/Mercury Quality Center, Discoverer, BI/XML Publisher and Hyperion

Programming Languages: SQL & PL/SQL, FORTRAN, C/C++, JAVA, JavaScript, HTML5, PHP

Other Software: Bugzilla, Mercury ITG TD, Microsoft Office Project, Word, Excel, Power point, Visio, Access, and Eclipse IDE

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Oracle Financials Functional Analyst

Environment: Post Production of R12.1.3

Responsibilities:

• Provided Post production support for R12
• Update/review business requirements and functional documentation including performing AS-IS and GAP analysis
• Worked with business on reconciliation between AR/GL and AP/GL,
• Worked with external auditors to fulfill Business and IT audit requirements
• FSG reports were configured as per business requirements
• Monitored, maintained, and fixed issues related to standard and custom interfaces
• Provided support in closing GL, AP,AR, FA, PO periods during month end
• Maintenance of software and application of patches as needed
• Collected/documented business requirements for CALPERS and Great West Interface.
• Prepared BRD and FD as needed for enhancements
• Worked with Oracle Support as required for production issues
• Assisted business in clearing sub-ledger exceptions for FA, AP, AR and PO
• Helped in documenting test scripts/plan for QA including conducting root cause analysis
• Use defect tracking, life cycle traceability, planning, reporting and process automation
• CALPERS and GreatWest interface requirement gathering and fixed issues/testing performed.
• Unaccounted invoices during month-end for AP fixed
• CEMLI traceability conducted and tracked as documentation was updated for future sustainability
• Collected business requirements for project capitalized interest for FASB34 and FASB64
• Gathered requirements for bank reconciliation and helped setup CE configuration for auto reconciliation
• Managed/Lead Oracle SI engagement for R12 Implementation Issues
• Initiating, planning, executing, monitoring and controlling, and closing plans and strategies were used
• Instance Management/planning- keeping track of environment changes, preparing instance refresh planning, Database backup planning
• Managed, lead, and conducted UAT, QA phases of the project
• Tracked, reported progress and completion status for all work streams in scope to CFO, IT Director, IT Manager
• Worked on cost, quality baseline, risk register, and scope baseline
• Constructed weighted matrix for vendor selection criteria based on the BF/RF requirements
• Worked on project scope which includes scope description, acceptance criteria, deliverables, exclusions, constraints, and assumptions
• Worked on milestone list, resource calendar and scheduling
• Developed strategy, policy, service delivery objectives and best-practices for design and delivery of the objectives
• Statement of Work (SOW), Request for Proposal (RFP), Request for Information (RFI), Contract Management

Confidential, Fort Worth, TX

Oracle Financials Functional Analyst

Environment: Post Production Support of 11.5.10.2 & R12.1.3; Re-implementation of R12.1.3

Responsibilities:

• Provided 24/7 support for oracle 11i & R12 globally for India, Mexico, North America, Canada, and European countries; furthermore, worked on R12 re-implementation
• Monitored, maintained, and fixed issues related to standard and custom interfaces
• Worked with Oracle Global Customer support in analyzing patches, data fixes, and applying solutions
• Documented root cause analysis (RCA) for all production issues
• Monitoring and fixing issues with upstream and downstream data flows with respect to ERP
• Incorrect payables template setup issues were resolved
• Create and assigned menus to custom responsibilities as per business requirements
• Tested various enhancement request (ER) and problem reports in production (PRP); furthermore, UAT was conducted and was signed-off
• Setting up budget templates and fixing issues related to budget uploads from Hyperion to ERP
• Worked on resolving issues with data files when file integration fails due to setup issues or incorrect data coming in from third party systems
• Worked with solution, release and global support manager to make sure that the changes are scheduled for production release based on business criticality
• Ensured root-cause analysis were conducted for issues; furthermore, made sure a corrective action plan is followed through by the support team
• Motivated and drove the support team to meet the SLA goals including create & update multiple documents
• Workload assignment/management with offshore and onsite
• Worked closely with the business on month-end critical issues; moreover, ensured the support team is addressing the issues in-time to avoid business outages
• Conducted in-depth functional impact analysis on proposed business change request
• Provided support in closing AP, AR, FA, GL periods during month end
• Fixed issues related to subledger accounting for AP, FA, AR, and PO
• Added new parent and child values for new stat accounts
• Resolved issues related to MT940 Quantum bank statement data files and fixed bank statements interface errors
• Fixed issues related to Financial Statement Generator
• Worked with external and internal Auditors to fulfill Business and IT audit requirements
• Cross-validation rules were revamped and issues related to them were fixed
• Worked on clearing import exceptions related to data flowing in from third party systems
• Set up new asset categories, asset locations, and KFF locations
• Resolved issues related to invalid subledger events
• Set up various taxes for Mexico, NA, and Canada suppliers
• Set up suppliers and iExpenses users; furthermore, worked on security attributes
• Fixed issues related to depreciation process; in addition, setup depreciation for new calendar year
• Maintained custom lookup tables whenever needed
• Setup missing batch processes; furthermore, worked on designing batch plans
• Set up PO Rate variance gain/loss accounts in AP
• Ensured resources are available 24/7 during month end to provide the necessary application support on-time
• Drive support meetings with the business and ensured support team is in sync with the client’s expectations
• Supported in identifying, justifying, and prioritizing enhancement requests based on client needs
• Worked with program manager to create and maintain plans on an ongoing basis
• Managed an integrated project schedule aggressively to ensure the project stays on track
• Tracked and reported progress and completion status for all work streams in scope
• Managed project agenda and communication with other working teams

Confidential, Boca Raton, FL

Oracle Financials Functional Consultant

Environment: Implementation of Oracle R12.1.3

Responsibilities:

• Designed chart of accounts to meet the client’s business requirements
• 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
• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents
• Participated in planning and set-up of accounting flex-field structure and chart of accounts
• Developed cross-validation rules
• Set-up accounting period types and accounting calendars
• 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 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
• Involved with migration of historical data for Account Payables
• Created new FSG reports depending on business requirements
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components
• Configuration of CRP2, CRP3, 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
• Providing post production support to the business users

Confidential, Stockton, CA

Oracle Financials Functional Analyst

Environment: Upgrade from Oracle 11.5.10.2 to Oracle R12.1.3

Responsibilities:

• Conducting Orientation with client to discuss R12 upgradation
• Understanding current Chart Of Accounts and propose a future design to enhance the way Xsigo does Business currently with a new Chart of Accounts in R12
• Interaction with Business Users to understand better their main points and Key requirements
• Defined and generated FSG’s for Balance Sheets where rollup groups are considered for parent child relationship
• Configuring/Updating Functional Setups of GL, AP, AR, and CE modules
• Configure and setup Tax in E-B. Tax module
• Prepare custom financial reports for month-end process using FSG
• 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.
• 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
• Develop Unit (TE.020) and System Integration Test Scripts (TE.050)
• Modify the existing Revenue Recognition schedule in AR to reflect in R12 as per future business needs

Confidential, Duluth, GA

Oracle Financials Functional Analyst

Environment: Implementation of Oracle R12.1.3

Responsibilities:

• 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
• Resolve data fixes needed for month end close

Confidential, Tulsa, OK

Oracle Financials Functional Lead Consultant

Environment: Full Life Cycle Implementation of Oracle R12.1.1

Responsibilities:

• 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 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
• Prepared and executed test scripts and created user-manuals and trained the end users
• Provided various custom solutions for client’s specific needs
• 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 using the legal entity Configurator
• 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 cconfigured the financials and payables options
• Involved in the setup of auto invoice workflow
• Provide end user training & coordinate UAT sessions including update of existing TE40 for integrations
• Worked on Hyperion Shared Services and created numerous users, groups to provide 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.

Confidential, San Jose, CA

Oracle Functional Consultant

Environment: Implementation of Oracle R12.1.1

Responsibilities:

• Carried out module configuration, solution design, process analysis, and implementation of GL, AP, and AR
• Responsible for the documentation of BR.030, BR.100, TE40, BP80, and CV40
• Setups of the General Ledger, Account Payables, and Account Receivables
• Supervised the period close and quarter close processes by ensuring that all financial transactions have been accounted for accurately and on a timely basis in Oracle GL.
• Developed Custom reports, Standard Interfaces, Custom Interfaces linked to different modules of Oracle Applications from third party including conduct Unit Testing and Performance Testing
• Supported the implemented Receivables and Payables modules which involved daily issues and new customizations and enhancements based on the changing requirements in the system
• Created an interface to load Prime Vendors as Customers, match Vendor Invoices to Credit Memos from AP to AR, to reduce vendor payments in AP, and generate Customer Invoices to vendors in AR
• Created Auto Invoicing and Auto lockbox (Source of Auto Invoice was Project Billing) processes
• Configure and test the interfaces for automatic bank reconciliation and positive pay functionalities
• Prepared Test scripts and involved in Application Integration Testing and System Integration Testing
• Set-up of Chart of accounts structure, Cross Validation Rules, Data Access Sets, and Security Rules
• Defining Mass Allocation and Financial Statement Generator and Creating Ad-hoc Reports
• Set-up Oracle Receivables and Oracle Payables including System Options
• Defined Payment Terms, Accounting Rules, Banks, lookups, Auto Invoice Grouping Rules
• Defining Transaction Types, Tax Codes and Rates, Customer Profile Classes, Customers, and Customer Banks
• Setups included Defined Invoice Attributes- Payment Terms, Approve, Hold & Release and Distribution Set, Special Calendar for Recurring Invoice, Payment Terms, lookups, Entering Supplier and Site Information
• Setups included Defined Payment Attributes- Payment Formats, Bank Account, Payable Documents, Tax Code, Rates, Groups and Withholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL

Confidential, Windsor, CT

Oracle Financials Functional Consultant

Environment: Implementation of R12.0.6

Responsibilities:

• Designed and set up the Ledgers after defining the Calendar, the functional currency, and the 7 segment Chart of Accounts
• Designed the Chart of Accounts for the client
• Designed and set up accounting structure with CE/AR/AP/FA
• Defined system and financial options
• Created summary accounts and modified accounts hierarchy
• Defined value sets, key flexfields segments and roll-up groups with security and cross validation rules, used ADI (Application Desktop Integrator) to integrate the GL module to the Excel spreadsheet
• Developed reports and various data items using Oracle Financial Analyzer and Discoverer
• Mapped the Future Process Requirement into Oracle AP module and identified the gaps
• Defined payment terms and recurring invoice templates. Set up employee expense templates and distribution sets
• Create descriptive flex fields to capture additional information on client need basis in Global and Context modes
• Defined distribution sets, expense reports templates, Locations
• Defined financial options, Payables options, Payment programs, and Bank accounts
• Set up the format for expense distribution detail report and Aging report, special calendars for key indicators and recurring invoices, and profile options forms
• Participated in the Conference Room Pilot Test for the modules. Assist in end to end month end process
• Worked closely with the users to define Daily limits, roles, and locations in Expense reports
• Defined Expense report templates in AP and develop test scripts includes creating user manuals for reference

Confidential, Wood Dale, IL

Oracle Functional Consultant

Environment: Implementation & Support for R12.0.6

Responsibilities:

• Business process study and creating business process maps using MS Visio for Oracle E-Business Suite GL, AP, AR and FA modules implementation
• Worked with business users to define their business requirements in preparation for developing program solutions and translated the requirements into Oracle R12 Processes
• Identified gaps between system processes and Business processes and documented using Gap Analysis Document. Also analyzed and indicated proposed workarounds and resolutions
• Identification of master data like Items / Suppliers and setting up the master data
• Requirements gathering, analyzed and document the same for follow-ups with business to sing off
• Involved in Unit testing, QA testing and User Acceptance Test
• Extensively worked on cross-functional and interdependent test scripts and test execution like import order, order correction, Auto invoice and revenue recognition
• Month end support in financial module (AR, AP, GL, and FA)
• Developed several BRD 100 on required reports to fulfill the business need
• Configuration of new customers, new products in Order Management. Developed High Level
• Design Document (MD 50) based on the business requirements for enhancements. Also coordinate extensively with developers to ensure development / testing the data migration and validate the same with business
• Reviewed the existing reports and collected requirements to develop additional custom reports for Engineering change order report, Warehouse summary report etc.
• Involved in data conversion for data like supplier data, customer data and Address details
• Prepared end user training material with specific business cases and conducted end-user training
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities
• Involved in post production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions