Oracle Applications Tech Lead Resume
Charlotte, NC
SUMMARY:
- Confidential is an Oracle Applications Techno functional Consultant with 13.7 years of experience and has performed different roles in different E - Business projects.
- Has extensive experience with prime focus in Oracle Applications Technical Design, Development, Testing, Maintenance and Support.
- Worked towards leading and managing projects, worked with multiple stakeholders, communicated with them effectively, execution of Project according to Project Plan, Risk management, Requirement analysis, produced high quality deliverable within Project timeline and budgetary targets.
- He is proficient in Oracle Reports, Forms, XML Publishers, Interface, Conversions, ODI, Alert, Workflow, PL/SQL etc. He has worked modules like Oracle Payables,Receivables, GL, Inventory, OM, PO, Projects, i-Expense modules.
- Expert in Custom Form Development from scratch, Form Personalization and CUSTOM.PLL and also working knowledge on OAF and ADF.
- Involved in performance tuning in Oracle using Explain plan and TK prof.
- He has worked in both 11i and R12. In R12 has exposure Sub Ledger Accounting, MOAC, E Business Tax modules.
- Worked extensively on Procure to Pay ( Confidential ), Order to Cash (O2C) business flows
- He has excellent interpersonal skills with a strong desire to achieve specified goals.
- He is interested in communicating new ideas and concepts with other team members thereby achieving the identified goals and objectives.
- He has very good analytical, problem solving, written and communication skills.
- He has ability to learn quickly and adapt to new technologies and cross-platforms.
- He has performed the following roles in this time period:
- Managing and leading the technical team.
- Technical analysis and Due Diligence of a proposed project
- Interacting with client and gathering requirements.
- Analysis of Functional Design documents
- Development of Technical Design Specifications of Interfaces, Forms, Reports, Alerts, Workflows, Shell Scripts etc.
TECHNICAL SKILLS:
Operating System: Windows 10, Unix
Programming Languages & Tools: PL/SQL Developer,Toad, SQL Loader, Workflow Builder, BI PublishersOracle Reports, Oracle FormsPutty, WinSCP, Kintana, HPQCOptio, PVCS,Serena DimensionAPPWORX, Oracle Data Integrator
Databases: Oracle 10g/11g/12c
EMPLOYMENT HISTORY:
Confidential, Charlotte, NC
Oracle Applications Tech Lead
Responsibilities:
- Assessing the processes in the old 3rd Party Tool and translate them into Oracle Conversions Design
- Design and development of various conversions (e.g., Customers, Suppliers, AP Invoice, AR Invoice, Sales Order etc.)
- Conducting CV40 workshop to define the mapping rules
- Participated in Data Cleansing activities as part of “Advanced Business Readiness”
- Act as Data Conversion Lead to lead mini-projects to execute the conversion programs.
- Interacting with multiple stakeholders (e.g., Legacy Extract Team, Functional Analysts, and Technical Teams etc.) and executing the Project as per the plan.
- Developed Reports and Interfaces in GL and AP Modules ( Payroll Cost to GL Interface, Custom Trial Balance Report, Intercompany Detail Summary Report, Inbound and Outbound Daily Exchange Rate interface, Payment Outbound to Lawtrac interface, AP Local Check Printing Report, Custom Invoice Register Report, Payment Audit by Voucher Name, Prepayment Reconciliation Report enhancements)
Confidential
Oracle Applications Tech Consultant
Responsibilities:
- Assessment of the challenges faced with the Confidential Applications modules
- Assessment of the challenges faced with the Confidential Applications modules
- Deep dive analysis of the Oracle Confidential applications and its integrations
- Determination of customizations in the current system which can be done away with
- Determining customizations which can be de-customized because of the upgrade
- Assess the integrations and customizations for which there is a scope for improvement
- Utilization of Cognizant Proprietary tool Cupid to come up with the effort and timeliness for customization retro fitment for this upgrade
Confidential
Oracle Applications Technical Lead
Responsibilities:
- Managing a Project Team of 10 people from offshore who design and develop the integration of the Oracle E business suite and the other legacy system using Oracle Confidential and supervise their day-to-day work, managing team’s skill set development, performance appraisal of them
- Circulating Weekly status report among different stakeholders of the project
- Design of new enhancements which includes Oracle interfaces, reports, Form personalization in Procure to Pay modules.
- Ensuring effective delivery of custom Confidential CEMLI components.
- Actively involved in the Upgrade initiatives of Confidential system from 12.0.6 to 12.1.3.
Confidential
Oracle Apps Techno-functional Consultant
Responsibilities:
- Interacting with clients/Functional Team and Requirement gathering
- Technical Specification Design and Development of Interface/Conversion, XML Publisher reports in PO, AP, AR, GL, FA modules.
- Worked on GL Intercompany reports, Designed Hyperion outbound extracts for GL CoA, Balances (BEQ and Non-BEQ), Fixed Assets Details with locations and FA Depreciations.
- Customized Oracle Format Payments Programs for various banks.
- Designed and developed Payable Invoice and Supplier Conversions for acquired companies.
- Customization of Workflows with AME.
- Review of Code and Tech Specifications
Confidential
Oracle Apps Team Lead
Responsibilities:
- Implementing the Proof of concept (POC) of Probable solutions.
- Technical design and Development of custom RICE objects and OAF pages in PO, AP, GL, FA Modules.
- Customization of Workflows with AME. Customizations of AP Invoice Approval, Requisition Approval and PO Account Generator Workflow.
- Worked on Fixed Assets Mass additions Interface.
- Designed Inbound GL Journal Interface, GL Budget Interface, GL Daily Rates Interface, Fixed Assets Inbound interface through Mass Additions, AP Open Invoice, and Supplier Interface.
- Worked on Supplier, Site, Bank Accounts Conversions in AP.
- Customized Standard PO Print, Change PO Reports through XML Publishers.
- Review the technical specifications for RICE components.
- Perform the integration testing of RICE components.
- Interacting with clients/Functional Team to get the requirement/issue clear.
- Helping team members to successfully deliver objects within stiff timeline.
- Provide inputs for management status reviews
Confidential
Oracle Apps Team Lead
Responsibilities:
- The major responsibility was to analyze the root cause of the defects in Integration and End-to-End Instance/environment and put a quick fix on that so that the business flow doesn’t stuck up.
- Working on the Inbound interfaces for AP,AR,GL modules and also on the outbound extracts.
- Interacting with clients/Functional Team to get the requirement/issue clear.
Confidential
Technical Team Lead
Responsibilities:
- Interacting with clients and getting the requirements clear.
- Framing the solution framework for the development.
- Performing the Proof of Concept (POC) for the idea/concept/framework.
- Designing the Detailed Technical specifications (DTS) from Functional Documents.
- Developing Components through Oracle Data Integrator to feed the data (e.g.,AP,GL,AR etc) into COGNOS Reporting Systems.
- Mentoring the team members.
- Leading the team.
Confidential
Oracle Apps Team Lead
Responsibilities:
- Fixing up the critical issues in the Production system.
- Proposing solution of optimum scheduling of interface invoicing program.
- Designing Technical Design documents for AR inbound and outbound interfaces.
Confidential
Oracle Apps Senior Developer
Responsibilities:
- Analysis of customized components in 11i.
- Impact analysis of upgrade to R12.
- Planning the Approach and Strategy for the migration.
- Providing Technical Estimate of the total Upgrade.
Confidential
Oracle Apps Senior Developer
Responsibilities:
- Analysis of Functional Design documents of OM, AR, GL Modules.
- Development of Technical Design Specifications of Interfaces, Forms, Reports and Alerts.
- Development of Sales Order and AR Invoice Inbound Interface
- Development of Forms.
Confidential
Senior Developer
Responsibilities:
- Analysis Functional Design documents of OM, Inventory and AR modules.
- Design of Technical Design Document
- Development of “Tariff Details” form which is an extension of Blanket Sales Agreement (BSA) form.
- Development of custom form and personalization.
- Interacting with Onshore counterparts to understand requirements in both technical and functional terms.
Confidential
Technical Developer
Responsibilities:
- Analysis of client requirements (Preparing documents like MD70).
- Development of custom Programs in Oracle Applications in Order Management, Inventory, Purchasing modules.
- Development of custom Programs.
- Development of Conversion and Interfaces.
- Understanding the Confidential custom code components, process flow and preparing developer/application reference document.
- Addressing and resolving defects of the Confidential core application running in Oracle Apps and custom web based application
- Prepared Technical Design Documents while developing the Enhancements
Confidential
Oracle Developer
Responsibilities:
- Managing data between extracted flat files and Oracle Database.
- Development of Converter program using PL/SQL to stage data from Extract area to Staging area.
- Production Support during run of migration script.
- Instant fixing the Data Bug if any policy has any error and Re-run to process it.
- Interaction with client and gather their instant requirement and work to meet that.
- Interacting with Offshore counterparts and make them clear what the requirements are in both technical and functional terms.
