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