SUMMARY:

• Oracle Applications Technical consultant
• Confidential has 14 years of experience in the IT industry.
• Throughout her career Confidential has worked on Oracle Apps projects at both onsite and offshore locations.
• She has been part of implementation and support projects and played roles like Technical Lead, Conversion Lead and Techno Functional Consultant. Her experience encompasses various phases of project life cycle, including Design, development, Unit Testing, Systems Integration Testing (SIT), User Acceptance Testing (UAT) and Production Support.
• She has hands on experience on business process customizations, developing extensions, interfaces and handling data conversions. Confidential has strong expertise in Oracle EBS supply chain modules - Order Management, Inventory, Purchasing and BOM. As part of her career, she also worked on modules - Accounts Payables, Accounts Receivables, General Ledger and Service Contracts.
• Confidential has worked with both 11i(11.5.19&11.5.10) and R12(12.0.6&12.1.3) versions of EBS. She has been part of 5 implementation and 3 upgrade projects.
• She has in depth knowledge on Oracle technologies SQL, PL/SQL, Forms and Reports, configuring workflows, WEB ADI, XML Publisher reports and developing Shell scripts.
• Confidential holds a Bachelor’s degree in Electrical Engineering from Jawaharlal Nehru Technology University (India)

TECHNICAL SKILLS:

Technical Expertise: SQL, PL/SQL, Forms, Reports, WEB ADI, configuring workflows, XML Publisher reports, Oracle Application Framework (OAF) and developing Shell scripts

Functional Awareness: Supply Chain Modules - Order Management, Inventory, Purchasing and Service Contracts. Finance modules - Payables, Receivables, General Ledger and Fixed Assets.

Operating Systems: Windows 8 and UNIX

Databases: Oracle 11g Database Design, Database Migration and Database Tuning

Tools: Oracle iSetup: For Data migration across Oracle EBS applications ORSYP, Control-M Scheduling Tools StarTeam, VSS Version Control Tools

EMPLOYMENT DETAILS:

Confidential

Technical Consultant

Responsibilities:

• Developed Check printing solution using Oracle BI Publisher thus sunsetting existing 3rd party software
• VAT reports in Excel format
• HRMS interfaces from Oracle to CIGNA insurance systems
• Web ADI developments for AP Invoice uploads
• Design and develop OAF Extensions for user interfaces
• Automated email mailers for created / retired Fixed Assets
• Design and develop GL interfaces between legacy applications to Oracle EBS
• Impact analysis on existing solutions due to R12 upgrade

Confidential

Technical Consultant

Responsibilities:

• Production Issue analysis and resolution for Order to Cash business processes in 11i
• Dealing with business users for day-to-day issue resolution process
• Performing root-cause analysis for recurring issues and suggesting proactive measures to avoid them in future
• Analyzing performance issues and provide technical solutions
• Error handling and reporting
• Design and development of new components for R12 upgrade track
• Remediate existing components from 11i to R12
• Perform Unit test, QA testing, test plan preparation
• Co-ordinate production deployment activities for user approved (UAT) fixes

Confidential

Business Analyst

Responsibilities:

• Conversion support and data validation
• Data analysis, cleansing and data enrichment
• Reach out external stake holders like suppliers for data management activities
• Act as a bridge between business and technical teams.
• Develop reconciliation scripts for quick business validations.

Confidential

Technical Lead

Responsibilities:

• Reviewing existing RICEFs in 11i system and identifying new developments, retrofits and retired entities thus compiling the final RICEF inventory
• Prepare templates for technical design and development - design document, unit and system test plan templates, development standards, check lists for release management
• Preparing technical design documents
• Develop and review code
• Perform system test
• Provide Level-1 technical support from onsite during SIT and UAT phases
• Define version control process using StarTeam tool.
• Technical support for R12 upgrade cutover phase
• Handling P1 tickets during warranty period (post cutover)
• Provide knowledge transfer on RICEF objects to IT teams as part of post go-live support

Confidential

Techno& functional consultant

Responsibilities:

• Writing interfaces for High Volume Order Import, Order release to WMS and billing interfaces from Oracle EBS to mainframe
• Custom program design and development for key functionalities like Order Allocation, pick release and shipment
• Design interface mappings between Oracle, ETL (Sterling EDI), WMS and Mainframe systems
• Develop OAF screens for additional data maintenance for customers and Vendors
• Preparation of test scripts, resolving issues, handling change requests
• Providing support for the cutover as well as post production.
• Analyzing production issues and identifying solutions
• Analyze data conversions requirements
• Identify conversion approaches i.e., Manual, conversion program or data loader
• Design and develop data conversion programs
• Analyze cleansing requirements
• Plan and execute conversion rehearsals and recommend data cleanings proposals
• Supporting conversions execution for entities - customers, items, price lists, sales orders, invoices and receipts