SUMMARY

• He is having over 12 years of experience in several fields and having sound experience in Oracle cloud applications like Fusion Financials and EBS R12. He has been involved in many ERP projects across a wide number of industries, specifically Telecom, Financial Services, Retail, Chemical Manufacturing, Shipping, Auto ancillary etc.
• His expertise includes providing business solution, consulting, implementing Oracle applications, business process analysis, solution fitment analysis, working plans, functional integration, and production support and user trainings.
• He has solid experience in requirement gathering, solution designing, system configuration, data conversion ad production support of Oracle Fusion Financials and EBS R12.
• Extensive experience in Oracle Fusion Financials Rel10 and EBS Release 12
• Oracle certified Fusion Financial Implementation Specialist
• Expertise in all new features & functionalities of Oracle cloud applications
• Comprehensive experience in implementation of business systems including Procure to pay (P2P), Order to Cash (O2C), Record to Report (R2R) and Asset to Retire
• Having good experience in GL Consolidation, Revaluation and FSG Reports
• Experience with Oracle Cloud reporting tools like Oracle OTBI, OTBA, Smartview, Accounting Monitor and BI Reports
• Managed business requirements with the Finance teams to produce the high level design
• Oracle Cloud Financials Rel10 implementation experience
• Excellent experience and knowledge of Oracle database and SQL
• Experienced in deploying Customizations, Extensions and Personalization’s in Oracle Finance modules
• Prepared Test Scripts and assisted in the execution of testing scenarios
• Strong knowledge in Oracle AIM methodology and Expert in preparing BR100, MD050 and TE040 documents. Also, having good knowledge of SDLC processes
• Experience is customizing the Oracle Fusion Security Roles

TECHNICAL SKILLS

Application Packages: Oracle Cloud Fusion Financials Rel 10, Oracle EBS R12

Tools: Toad, Sql Developer, Data Loader, HP Service Desk, HP Quality Manager and Ringmaster.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

• Configured Fusion Payables, Cash Management setups
• Created approval groups, approval rules for Supplier and AP Invoice approval in BPM
• Created custom security roles ( Job Roles) to segregate the duty in Fusion apps
• Defined multiple real time OTBI and BI reports for various business functions
• Technically mentored my offshore team to fix the issues related to Setups, Reports and Analytics, inbound and outbound Interfaces
• Managed the coordination between Customer, Oracle Cloud support and Oracle Cloud Operations team for patch applications and application maintenance activities
• Handled day to day Fusion support issues and new change requirements
• Currently working on Advance collections implementation and AR Invoice automation
• Defined Collections module setup, Collections dashboard and dunning letter configurations

Confidential, Dallas

Oracle Developer

Responsibilities:

• Defined the loss allowance allocation rules
• Helped the business to reconcile the ledger balances after elimination and revaluations
• Designed the elimination rules and mass allocations for equity pickups
• Configured revaluation rules for I/C statement and balance sheet accounts
• Implemented the global consolidations for the client’s international operations with multiple ledger setup
• Conducted requirement gathering, Fit Gap meetings with business users and designed and implemented AP solution for North America operations
• Provided a solution to control their payments by adding custom logic in payment templates
• Developed a solution to reconcile the sub ledger balance with GL
• Involved in system Analysis, Design, Business Process mapping for AP module
• Interacted with the Business users in understanding the Requirements and subsequently developed the functional design to meet the client requirement for AP and GL module
• Designed a solution to customize the 1099 reports
• Designed the AP invoice approval workflow using Oracle AME
• Defined EB Tax setup like tax rates, tax regime and tax rules for Canada Operating unit
• Worked with business subject matter experts (SME’s) to ensure the system was designed in accordance with business requirements
• Engineered solution to supplier, invoice, payment data conversion and ensured that data appropriately extracted from Oracle 11i system and then loaded and reconciled with the associated Oracle R12 application

Confidential

Oracle Developer

Responsibilities:

• Studied the client business process and identified scope of business process to implement the RMB system
• Involved in parallel billing testing and identified the variations
• Implemented a solution to reconcile the Cash management with Revenue Management Billing
• Involved in billing interface development and reconciled the GL balances with RMB
• Involved in RMB configuration and prepared ORMB configuration guide

Confidential

Oracle Developer

Responsibilities:

• Configured receivable module in Fusion application
• Prepared the Config guide for Fusion receivables
• Configured common receivables configurations like receivables activity, receipt source, transaction types, transaction sources etc.
• Prepared the test scripts for the Fusion Receivables module
• Configured custom security roles and configured the common application setup for Fusion Financials
• Defined the OU specific reference sets
• Involved in end to end testing for Fusion Application

Confidential

Oracle Developer

Responsibilities:

• Tested integrity of customizations to ensure no overrides due to R12 upgrade
• Helped the business to reconcile the AR revenue balances after upgrade
• Tested their entire custom applications for R12 upgrade
• Studied the client existing application and their dependencies to identify the scope of system improvement/enhancement
• Developed SQL based reconciliation tool for AR - SLA - GL reconciliation after the upgrade and reduced 30% of manual work
• Provided suggestions and workaround for non-standard functionalities and reduced the involvement in third party systems
• Analyzed client’s existing custom designs and provided new standard solutions in R12
• Defined collectors and dunning letter configurations
• Streamlined the month end & year end process by providing a checklist

Confidential

Oracle Developer

Responsibilities:

• The project involved in Post implementation Support and enhancement of Oracle modules like AP, AR, GL, Purchasing, Inventory and Oracle Property manager
• Involved in Oracle R12 rollout for various geographic locations such as Colombia, South Africa, Ghana and Uganda
• Implemented Oracle R12 finance modules for Latin-American and African countries
• Developed functional designs for new enhancements of Property manager and fixed AR integration issues with project costing and Property manager
• Provided support for Finance and SCM modules for countries like US, Brazil, Mexico, Ghana, India, South Africa, Uganda
• Involved in Property manager & Finance modules configuration
• Assisted the team to resolve production issues for AR, AP and property manager modules
• Used the Ringmaster tool to analyze the Oracle patches and identify the impacted objects
• Mentored the team to conduct the root cause analysis of production issues
• Provided support for India, Brazil and Colombia localization issues and configured E-Business tax setups

Confidential

Oracle Developer

Responsibilities:

• Developed functional designs for OLM with AP, AR Integration
• Supported month end and year activities
• Involved in Fixed Asset Depreciation and Capitalization issues / Reconciliation
• Resolved the fixed asset depreciation calculation and OLM integration issues
• Worked on AP interface with OLM and also Involved in third party AP invoice integration
• Interacted with end users & Technical teams to clarify their doubts and resolve their issues
• Defined approval hierarchies for various workflows

Confidential

Oracle Developer

Responsibilities:

• Involved in contract approval workflow in property manager & PN module configuration
• Designed Property manager online audit report
• Designed and developed AR credit balance report
• Involved in property manager module reports design and development

Confidential

Oracle Developer

Responsibilities:

• Provided post implementation support for Oracle Applications R12 modules like GL, AP, AR & Fixed Asset
• Worked on Budget configuration and uploaded the Budget data using WebADI
• Prepared FSG reports for B/S & P&L for all companies
• Defined GL Consolidation setups
• Involved in GL and Fixed Asset depreciation reconciliation
• Involved in GL & Sub ledger Reconciliation
• Designed AP Payment voucher and AR Invoice details report
• Provided a solution for altering the asset useful life for fully depreciated asset
• Prepared MD050 (Functional Design) documents for Inventory Aging report and Quotation Analysis report

Continental

Responsibilities:

• Implemented Oracle Applications 11i modules like Accounts Receivables, Accounts Payables, General Ledger, Cash management Fixed Assets
• Performed requirement analysis and documented the future state design
• Configured India Localization Tax setups for Tax deducted at source (TDS), Tax Collected at Source (TCS) & VAT
• Performed system integration test and user acceptance test of AR, AP & GL modules
• Designed the Oracle chart of accounts
• Worked on master data and historical data conversion
• Involved in project documentation and end user training for all finance modules
• Helped technical team to develop custom reports