We provide IT Staff Augmentation Services!

Oracle Techno Functional Consultant Resume

SUMMARY

  • 12 Years of IT Services experience as Oracle EBS professional in Oracle 11i & R12 Financial implementing globally for clients like Bank of America, Moneygram, Confidential & Veatch, Confidential
  • Experience in managing the financial track of Oracle cloud implementation
  • Extensive experience in Designing, Implementing, Migrating, Customizing of Account Payables (AP), General Ledger (GL), Oracle Incentive Compensation(OIC), Oracle Receivables (AR),HRMS
  • Knowledge and experience of Oracle Purchasing, Inventory, HRMS
  • Good understanding of the Software Development Life Cycle
  • Extensive Technical experience in design and development of complex RICEWP elements
  • Experienced in System Analysis, Design, Development, Customizations, Implementation of business applications using Oracle ERP.
  • Good experience of Team Leading activities such as Team management, effort estimation, activity tracking etc.
  • Possesses experience in working On - shore - Off-shore Model.
  • Developed re-usable solution that can be used across Industry verticals.
  • Experience in performance tuning, debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
  • Experience in the working with following Tools: Reports 6i/10g, Forms 6i/10g, TOAD, SQL Developer, SQL*Loader, VSS, ESP Cybermation workstation, Portfolio and Project Management, SQL*Plus, PL/SQL, developer, WinCVS, CMS, Putty, MOPS, Visual Studio, TFS

TECHNICAL SKILLS

  • Technical Experience in Building and Customizations of
  • Oracle SQL, PLSQL, Dynamic SQL, Advanced PLSQL, Shell Script
  • Packages, Procedures, Functions, Tables, Synonyms, Grants, Views
  • Oracle D2K reports (Text, HTML, XML, Excel, CSV)
  • Oracle D2K Forms, Custom pll's
  • Oracle inbound Out Bound Interfaces
  • Oracle Conversions
  • Oracle Extensions, OAF Personalization
  • Oracle Workflow Customization, New Custom Workflows
  • Oracle XML Publisher reports
  • Oracle XML Template, XML Source Code Customization
  • Desktop integrator
  • XML/BI Publisher, Workflow Builder
  • Reports 6i/10g, Forms 6i/10g
  • TOAD, SQL Developer, SQL*Plus, PL/SQL developer, SQL*Loader
  • VSS, ESP Cybermation workstation, Portfolio and Project Management
  • WinCVS, CMS, Putty, SVN
  • MOPS, Visual Studio, TFS

PROFESSIONAL EXPERIENCE

Confidential

Oracle Techno Functional Consultant

Responsibilities:

  • Leading team for various integrations between Oracle and other applications
  • Coordinating with workday team for inbound files for various integrations
  • Analyzed data with Biz Talk team for various messages mapping
  • Helped client to convert Oracle data into Workday Test Conversion
  • Developed enhancement using user hooks package for various events
  • Performed Unit Testing and supported System Testing and User Acceptance Testing
  • Coordinating activities between various team (Workday, Biz Talk, Oracle, Business)
  • Worked on SQL Server, power shell scripts and MOPS
  • Solution design and effort estimation for next phase for the project

Environment: Oracle R12.1.3, XML Publisher, Workflow Builder, PL/SQL, Reports, Forms Oracle Apps, AP, HRMS

Confidential

Oracle Techno Functional Consultant

Responsibilities:

  • Supporting business on issues faced on their day to day use
  • Understanding and documenting business requirements for new enhancements
  • Coordinating with Oracle on different SR for various issues with standard functionality
  • Worked on Integration with applications like Vertex, Concur
  • Played key role in performance tuning of critical custom reports
  • Designed and developed automation of various manual process/monitoring using ESP Cybermation
  • Coordinating with offshore team for critical production issues or new projects
  • Driving weekly meetings with business related to tickets SLA/projects status
  • Developed various scripts for data fixes in production

Environment: Oracle R12.1.3, XML Publisher, Workflow Builder, PL/SQL, Reports, Forms Oracle Apps, AP, AR, GL, PO Module

Confidential

Oracle Financial Consultant

Responsibilities:

  • Working with business to identify impact of OU/GST changes on their day to day business
  • Phase 1 included identifying code/setup changes required as part of new OU rollouts required before GST
  • Worked with business for requirements mapping to come up with HLDs and DLD and their integration with other systems
  • Worked with business in identifying all open transactions (invoice/PO/Requisitions) and finalizing approach to move them to new OU
  • Coordinating with other peripherals team to identify changes required in integration after changes in Oracle
  • Creating scripts for changes in Core HRMS for employee assignment to new circles and role assignment as per new OU
  • Developing scripts for high volume data migration activities as current OU got divided in multiple OUs
  • Prepared the test cases, and made sure we got the sign off for all the test cases before SIT.
  • Developed custom program to create employee as supplier and supplier site
  • Modifying existing components to handle new OU rollout/tax changes
  • Maintained defect tracker to track defects and their resolutions in SIT and UAT
  • Actively participated in functional and integration testing
  • Worked on form personalization’s to cater business requirements
  • Phase 2 included Identifying affected objects/transactions after implementing GST patches
  • Modifying custom objects to include all GST related changes
  • Identifying all custom reports/templates shared with end customers to include GST details
  • Designed and developed new interfaces as per business needs
  • Tested customized functions, programs under simulated environment and created user manual for the entire customized environment provided support to users during Go-Live by way of problem solving and instructions.

Environment: R12.1.3, XML Publisher, Workflow Builder, PL/SQL, Advanced PL/SQL, Reports, Forms Oracle Apps, AP,AR,GL, HRMS Module

Hire Now