SUMMARY

• Having excellent experience in development & maintenance of Oracle Applications R12, 11i & Oracle Financials,SCM as Techno Functional consultant involving in implementations and support in the BI reports/XML reports
• Expertise in Data Conversions in SCM,Financials,HCM Modules.
• Experience in Web Services, SOAP, WSDL and Integration with RESTFUL services.
• Involved troubleshoot Financials/Procurement functional issues in Production and provide quick resolution guide the users for any navigational and training issues in Oracle Financials/Procurement .
• Excellent Knowledge on defining ESS jobs for custom BI Publisher Reports in various modules
• Good Technical skills in developing RICE Components in the domain of Oracle Applications E - Business Suite.
• Areas of expertise include technical developments in Order Management,Inventory,Procurement,Accounts Receivable, Accounts Payable, Payments, Cash Management, Fixed Assets, General Ledger, iExpenses, Sub-Ledger Accounting, Tax of ERP modules
• Good functional knowledge in Order to Cash(O2C) and Procure to Pay(P2P) cycles
• Having two full life cycle implementation experience with exposure to implementation methodologies-AIM
• Having good knowledge on MD and CV documents for various components, good experience in development of functional/technical design documents.
• Experience in Implementation, Migration and Support Projects
• Rich experience in registration/migration of RICEW components (Forms, Reports, Conversion, Extensions,Workflows), PLSQL programs, Oracle Discoverer and BI/XML Publisher bursting Reports
• Expertise with Oracle Workflow, Workflow and Notification administration, Workflow Builder
• Good Experience in registration of Menus, Functions, Value Sets and Concurrent programs
• Having good knowledge on form personalization and customizing the forms using CUSTOM.pll
• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs
• Well conversant in creation of database objects: Tables, Constraints, Packages, Stored procedures, Functions, triggers and Indexes using Oracle tools to bring business requirements to completion
• Involved in performance tuning of several objects using hints and several other processes, analyzing Tkprof files and Explain Plan
• Having good expertise in Preparing Technical Documents, Code Review Checklist (CRC), Test Plan and Test Results documents based on the user/customer requirements
• Participate in Class Room Prototype (CRP) meetings for gap analysis
• Good thorough understanding of system development process, from initial planning
• Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the technical issues
• Experience engaging Oracle Support(TAR) to research and resolve issues
• Analytical and problem solving skills with ability to work independently when needed.
• Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management and team building
• Team Player with Excellent Technical, Communication, Interpersonal skills and Leadership abilities
• Adopting new technologies, Very flexible and perform tasks are ad-hoc basis

TECHNICAL SKILLS

• PL/SQL, SQL, SQL Loader, iLoad,Oracle Reports, Oracle Forms, Forms Personalization,Discoverer,XML/BI Publisher,Oracle Oracle Workflows,XML/BI Publisher Reports,OAF,Oracle 19c.
• Oracle Cloud (FBDI,OTBI,BI Publisher),AWS
• Cognos,Informatica
• GitHub,Maven,Jenkins,Docker.
• Financials - GL, AP, AR, CM, FA, E-Biz Tax, SLA,TCA, iExpenses.

PROFESSIONAL EXPERIENCE

Oracle Technical Lead

Confidential

Responsibilities:

• Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team
• Involved in developing the objects/enhancements
• Liaise between vendors and internal Project teams for business/Technical requirements.
• Leading solution design for Financial modules
• Involved in month end and year end closure activities
• Build appropriate timelines and coordinate cross-functional teams and preparing high level and detail design document.
• Actively participate and work with business analysts and business teams to understand and document technical requirements for projects, enhancements/ features and integrations.
• Design and develop XML/BI Publisher Reports having Barcode and Bursting Functionality..
• Design,Built,Test & Support Interfaces,Conversions and customization of workflows.
• Engineered Autolockbox Interface and implemented the Line Level customization of payment receipts.
• Involved in development of custom automated reports integrated between Oracle Ebs and Brio for the entire user population (15000+ users).
• Oversees resource allocations and develop work plans. Managing projects, providing technical direction to all team members, and ensuring on-time delivery of all projects.
• Provides timely feedback to Leadership on open issues and provide quick resolution
• Understands and assist with the diversity of user requests including flexibility with work assignments.
• Strong internal-consulting relationships with managers and end-users in functional and technical areas
• Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), and Conversion Test Plans (CV70)
• Developed complex PL/SQL Procedures, Interfaces,Conversions using Apis,Functions, Packages and Database Triggers
• Written efficient, complex queries against very large data sets good knowledge of tuning of queries.
• Reverse engineering of legacy systems and mapping it with Oracle EBS application
• Providing post-production support to the end users on standard Oracle Application modules along with the customized Oracle Apps
• Supported production and non-production instances and coordinated with DBA's and other tech team for on time solutionProvided daily user support for financial modules and applied patches as and when required to resolve the application issues
• Experience in interacting with client/business and building the business requirements. Proficient in analyzing and translating business requirements to technical requirements and architecture the solution.

Environment: Oracle EBS - (INV,PO,OM,GL,AP,AR,PO,FA,BOM,WIP,Costing),R12.2.4 PL/SQL, SQL*loader,TOAD.

Oracle Technical Lead

Confidential

Responsibilities:

• Analysed, designed, documented and Integrated 3rd party system(Coupa) GL and AP modules
• Determined business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
• Design,Built,Test & Support Interfaces,Conversions .
• Outbound Interfaces - Designed and developed various PLSQL programs and registered them as concurrent programs to fetch the data and write to Comma Separated files in the predefined Server location for the extraction of files like Users, Chart of accounts, suppliers, Supplier sites and Payments
• Inbound Interface: designed and developed AP Invoice creation in Oracle using batches and sending details to users with an alert using email bursting program Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables
• Worked with integrated Oracle Application and their impacts on the General Ledger Sub-ledger Accounting. Worked with a multi-ledger Release R12 Applications configuration support multiple accounting treatments in a Global Oracle Applications instance
• Reconciliation Reports for invoice details of loaded invoices and 3rd party system(Coupa) invoices
• Developed Error handling Programs and sending alerts to respective business users
• Inbound Interface: designed and developed Suppliers interface in Oracle from 3rd party system
• Utilized UTL FILE Utility for writing data to the file in middle tier
• Utilized FND LOAD for data migration of various system administration objects, between various instances such as Menus, Custom Responsibilities and Programs, Value Sets and others
• Documented BR100, Functional Design(MD50), Technical Design(MD70), Testing Specification (TE40)
• Involved in requirement gathering and analysis and design of the application
• Worked with the client team to understand the current Business Process
• Developed test plans and scripts and conducted testing for quality assurance
• Integrated with 3rd Party Systems GL, AP modules in R12 Environment
• Extensively worked on Migration and Testing of the Deliverables in different instances
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location
• Developed a program to import Purchase accruals and reversed accruals in the beginning of the next open period in General Ledger

Environment: Oracle Financials (GL,AR,AP,PO,OM, BOM,WIP,Costing and SLA, R12, Oracle 11g), PL/SQL, SQL*loader,iLoad, R12.2.0.1

Oracle Technical Lead

Confidential

Responsibilities:

• Analyzed, designed and documented GL, OM, AR, AP, FA, SLA modules and Oracle Cloud (OIC)
• Documented MD50, MD70 and configured applications
• Closely worked and coordinated with the technical teams to deliver the solutions as per the functional designs and customizations
• Developing the Test suite cases on SOAP UI
• Involved in Migration from Dev environment to Test and UAT environments
• To provide the best solutions for integrations did most of the proof of concepts and got approval from architecture team
• Prepared functional design document OM Sales Order from legacy system
• Developed BI Publisher Reports as per the client requirements
• Designed customer conversion strategy, data mapping and development using APIs
• Customized several standard oracle reports (Pick Slip Report, Invoice Print Selected Invoice) and developed custom reports we later converted into XML templates
• Developed outbound interface to transfer the data from base tables to external System.
• Developed an interface program to bring AR Receipts from Legacy system into AR interface table
• Involved in Post Production Support for Oracle Financials Modules
• Demonstrated solid problem-solving ability with unique combination of strong technical and functional skills and provided fast, efficient and accurate services
• Managed team work from production support to implementation conversion activities and functional design on emerged business-needed enhancements (configuration or customizations)
• Played instrumental role as Functional Lead in multiple multi-phased R12 projects successfully implemented Oracle Financials
• Trained key functional users through multiple training sessions on all financial modules in both corporate office and international locations such as US, Mexico, Trinidad and Canada
• Documented Business process JOB Aids
• Presented solid and unique problem-solving ability of fulfilling client's large complicated business requirements by utilizing both functional and technical tools/skills

Environment: GL, OM, AR, AP, FA,BOM and SLA, R12.2.2, Oracle 11g, Oracle Cloud, PL/SQL, SQL