We provide IT Staff Augmentation Services!

Oracle Apps Consultant Resume

4.00 Rating

Nj Oracle Apps Consultant, NJ

SUMMARY

  • 25 + years of excellent expertise, 20+years of which is in ORACLE environment.
  • Functional Expert with heavy exposure in the Oracle Financial Modules of GL, AP, AR, CE, IE, FA, AGIS, O2C, P2P, OPM, TM, OTM, PA, RMB.
  • Well versed on report generating tools such as OBIEE, Discoverer, FSG, SQL queries.
  • Working knowledge of Sys Admin, GRC, E - Commerce modules and I -Supplier
  • Global oracle financials implementations with expertise in EBS R12 and Fusion.
  • Business process analysis, Solution Design, reengineering, mapping, global design, road maps and architecture.
  • Project management, team management, deliverables, timelines, resource allocation, job scheduling, quality assurance and design presentations.
  • Implemented R12.1.3 Oracle Application, Implemented Oracle Revenue Management and Billing application in various projects.
  • Multi-Currency, Multi Org, Multi Companies (Group), Multi Location, expertise.
  • Extensive Functional knowledge and expertise in Oracle Financials 10.7 through R12, Oracle 7.X - 10g, SQL*Loader, SQL*Forms 4.5 - 6i, Reports 2.5 - 9i, SQL, PL/SQL, SQL*Plus.
  • Extensive knowledge in business requirement analysis, user consultations, software implementation, tests planning, and user support.
  • Self-motivated and hard working with good leadership quality.
  • Excellent communication & interpersonal skills and efficient team player.
  • Excellent Accounting expertise as Chartered Accountant.

TECHNICAL SKILLS

RDBMS: ORACLE 7.X-11G.

Tools: & GUI: BI PUBLISHER, DEVELOPER 2000(FORMS 4.5 - 6i, VISIO, MS OFFICE TOOLS. REPORTS 2.5 - 6i), DISCOVERER 3.1, FSG, SQL*PLUS, PL/SQL, SQL*LOADER, ADI, TOAD, EDI, OFA, HUMMING BIRD, KINTANA, MKS, MS PROJECTS, HYPERIAN, EIS REPORTS, DISCOVERER, ARTIMIS, TRACK WISE, DEMAND MANAGEMENT, CRM HELP DESK

Packages: ORACLE FINANCIALS 10.7 through R12

Platforms: HP/UNIX, SUN SOLARIS, WINDOWS 3.11, WIDOWS NT

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle Apps Consultant

Responsibilities:

  • Configured and Set up modules/features with seamless Integration for a smooth transaction flow to suite the Business Processes amongst GL, PO, AP, FA, OM, INV, AR, TM, OTM, LCM, OPM, i-Exp, i-Supplier, EDI, CREDIT, REVENUE, ADVANCED COLLECTIONS. Configured OTM to integrate with OM, PO, AP, SMC3, Rate Uploader, LTL, FTL and Ocean Freight.
  • Initially implemented and configured the above Oracle EBS Finance modules in R12 and recently upgraded to Cloud and Fusion environment.
  • Designed BI Reports in the cloud/Fusion environment, to replace old discoverer and OBIEE Reports.
  • Spearheaded successful Hosting Migration Project, delivering $50K in monthly cost-saving by merging servers to a common provider, which simultaneously increased operational transparence and accountability.
  • Captained third-party integrations—e.g., EDI, Eximware, Eminent, Banks, SMC3, e-commerce sites — with an Oracle footprint including Financials, Supply Chain, Trasportation, Trade Management and Manufacturing modules.
  • Provided key support to Confidential consultants during the IT Audit by Confidential and participated in the Oracle License Audit.
  • Plan and implement Disaster Recovery plan and site.
  • Performed SOX and JSOX Compliance Audits.
  • Oversee a large team in daily operations, identifying individual as well as collective goals and conducting reviews on a quarterly basis. Continuously work to improve processes and save costs by eliminating obsolete or needlessly redundant equipment, servers, and systems. Lead comprehensive disaster recovery planning; coordinate cross-functionally to support project and cutover planning; and implement milestones while balancing and prioritizing resources to achieve core business goals.

Confidential

Finance Lead

Responsibilities:

  • Provided Application Architecture, run the Solution designs workshops and CRPs, worked closely with Business Leads, got the requirements, discussed and resolved the issues, got the signoffs and BR100s.
  • Lead the onsite Functional Team. Provided the guidance and monitor the day to day work of all Functional Consultants. Personally, took the module ownership of AP, EB TAX, Oracle Payments and AGIS.
  • Configured Sales and Use Taxes, VAT and Backup Withholding Taxes for various Counties, Tax Reports, Withholding Tax Certificates and Tax Payments.
  • Designed and configured AP, EB TAX, I Expenses, Oracle Payments and AGIS for about 90+ OUs. Prepared BR100s, all these modules new design is with two Business Groups and segregated OUs, which were running hitherto in one Business Group and combined OUs for Finance and Publications business segments. For new Business Group new OUs were created.
  • Reporting to Program Manager, PMO meetings. Prepared the Project Plans, Cutover Plans with mile stones and critical tasks. Maintained the Issue Logs.
  • Updated the Functional Design documents (MD50s) for inbound/outbound interfaces, Reports and Custom Components and worked closely with offshore development team to make these components work in the new structure of two BGs and segregated OUs.
  • Configured Project Costing and Billing and interfaced to AR and AP.
  • Performed the Conversions and Data Fixes of Master and Transactional data from current BG/OUs to the new BG/OUs.
  • Organized the meetings with the QA team, Development team, DBA team and Business Leads and performed the Defect management.

Confidential, NY

Oracle Financials Lead

Responsibilities:

  • Prepared global structures for COA, inventory orgs, Operating Units, Legal Entities and Ledgers, consolidation hierarchies. Prepared the COA values, mapped the legacy values with Oracle values along with business.
  • Done the conversion mappings from legacy to oracle for all the financial modules.
  • Helped the business users in CRP1&2 in testing all the business scenarios.
  • Logged the issues in TrackIT, assigned to the respective implementation team members and monitored the same until close.
  • Prepared and monitored Finance functional tracker to monitor various functional events and setups, inputs and requirements.
  • Collected various inputs required for implementation from different users and provided the same to the oracle implementation team on time.
  • Reviewed the implementation documents and specs of CV040, CV060, MD050, MD070, TE040 etc. Helped the business users to write the test scripts and execute the same to cover all their business scenarios.
  • Helped the Confidential Management in monitoring and reviewing the Project Plan, delays, legacy data collection, weekly project progress reports and preparation of reports to the project executive committee.
  • Organized the WEBEX meetings and conference calls for the remote users to participate in the meetings, CRPs and Testing.
  • Worked with DBA team in the back up plans, instance planning and patch applications.

Confidential, IL

Integration/Business Process Lead

Responsibilities:

  • Conducted detailed discussions with Business and Tech Leads. Analyzed current business processes and prepared the current and to be combined business process flows, system diagrams and data flows.
  • Prepared, global list of legacy systems which can be sunset and advised changes required in business processes, automation of processes eliminating or minimizing the manual processes. Prepared the road map to improve the period closing processes, accounting and financial reporting.
  • Gathered the high-level requirements and done fit gap analysis.
  • Prepared the global design and architecture with country specific localizations and tax structures of Oracle Financials with suggestions on the required modules and the legacy systems, based on the cost benefit analysis.
  • Prepared RFPs, helped in negotiations on RFP responses.
  • Prepared the project plan with deliverables, time lines and milestones, resource plan. Presented the budget and obtained approvals from steering committee.

Confidential, NJ

Oracle Financials Functional Consultant

Responsibilities:

  • Analyzed and prepared the current and to be business process flows from discussions with business leads. Provided global design and road map.
  • Prepared the project plan with deliverables, time lines and milestones, resource plan. Presented the budget and obtained approvals from steering committee.
  • Developed the custom Consolidated Billing feature, with Accrual billing and the ability to customer to enter actual and run auto adjustments on Revenue and Final Billing based on Actuals entered. This customization includes custom Forms and custom Accounting.
  • Done the requirement gathering, fit gap analysis, mapping, documentation, CRPs, obtained approvals, tested and implemented successfully.

We'd love your feedback!