Oic Technical Consultant Resume
SUMMARY
- Having 16+ Years of Experience in Oracle Finance/SCM/Manufacturing Confidential in Oracle Applications e - Business Suite (11i & R12), Oracle Cloud Finance Fusion Application (R13) Suit & Oracle Integration Cloud (OIC) Pass Premier Product
- Exposure in teh areas of Oracle Applications Modules in General Ledger (GL), Account Payables (AP), Accounts Receivable ( Confidential ), Cash Management (CM), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Inventory (INV), Bill of Material (BOM), Work in Progress (WIP), Oracle Transport Management (OTM) and Oracle Learning management (OLM), Oracle Lease management (OLM) & Oracle Clinical Management (OCM)
- Experience in Oracle Application Implementation, Enhancement, Rollout, Upgrade, Integration, Data migration, Customization, Production Support in Oracle Application (11i & R12)
- Exposure in Oracle SaaS Cloud implementation experience with Oracle Fusion Modules of Financial implementation/Support Project(R13)
- Experience in Oracle Integration Cloud (OIC) using agent group Integration components Integration Cloud Service (ICS), Process Cloud Service (PCS) and Visual Builder Cloud Service (VBCS).
- Having Experience working on complex integration in OIC/EBS using REST APIs (End Point)/SOAP Services
- Expertise in building complex integration processes, integrating cloud-based and On-Premise Enterprise Applications.
- Hands-on design, development, deployment, and maintenance of integration processes between on premise\cloud systems and other 3rd party applications
- Experience Oracle Integration Cloud (OIC) adapters, usage of REST Adapter, SOAP Adapter, ERP Adapter, Salesforce Adapter, FTP Adapter, File Adapter, usage of orchestration integration patters
- Experience in REST APIs/End Point, SOAP Web Services and FBDI Templates in Oracle Cloud.
- Has good hands-on experience on developing process and calling sub process in Process Builder Cloud Service (PBCS).
- Having Good exposure working on VBCS
TECHNICAL SKILLS
- DATA MIGRATION
- DATA TRANSFORMATION
- DATABASE MODELING database
- Oracle
- ORACLE 11
- ORACLE PURCHASING
- PL/SQL
- PROGRESS
- SQL
- API
- CODING
- PVCS
- REPORTING TOOLS
- REQUIREMENT ANALYSIS
- Subversion
- Confidential
- SYSTEM INTEGRATION
- XML
- APPLICATION IMPLEMENTATION
- DEPLOYMENT
- MIGRATION STRATEGY
- ROLLOUT scm
- SYSTEM CONFIGURATION
- DATA VALIDATION
- INTEGRATION TESTING
- TEST PLAN
- UAT
- UNIT TEST
- MS-DOS
- SOAP
- Amazon Elastic Block Storage
- EBS
- BASIS
- CRM
- ERP
- FINANCIAL MODULES
- HRMS
- SAP
- DATA CLEANSING
- Enterprise Resource Planning
- SOFTWARE AS A SERVICE
- SAAS
- TRANSACTIONAL DATA
- E-BUSINESS
- SHARE POINT
- SOA
- Web Services
- REST
- Confidential Support
- LIFE CYCLE
- REQUIREMENT GATHERING
- Confidential DESIGN
- SECURE FILE TRANSFER PROTOCOL
- SFTP
- Confidential
- TEAM LEAD unix
- BILLING
- ACCOUNT PAYABLES
- PAYABLES
- ACCOUNT RECEIVABLES accounts receivable
- RECEIVABLES
- FIXED ASSET
- FIXED ASSETS
- PROJECT ACCOUNTING
- Accounting
- GENERAL LEDGER
- GL
- FINANCIAL REPORTING
- FINANCIALS
- Forecasting
- Cash Management
- Reconciliation
- AP
- Confidential
- COLLECTION
- INVOICE
- INVOICES
- FILE MANAGEMENT
- SYSTEM TESTING
- REGISTRATIONS payroll
- PRINTING
- ASCP
- Finance
- BOM
- CREDIT SCORES
- BUSINESS INTELLIGENCE
- FINANCIAL SERVICES
- Inventory
- ORDER MANAGEMENT
- BUYING/PROCUREMENT purchasing
- INTEGRATOR
- LEVEL DESIGN
- CREDIT ISSUES
- Human Resources
- PREMIER
- Publisher
- MICROSOFT WORD
- Word
- DOCUMENTATION
- WRITING FUNCTIONAL
- Unspecified
- FUNCTIONAL SPECIFICATIONS
- TRANSLATING
- PROCESS DESIGN
- TEST CASE
- TEST CASES
- QUALITY CHECKS
- TOPO
- MAPPING
- ODI
- Hydraulics
- LOADER
- PACKING
- SALES ORDER
- EMPLOYEE RESOURCE GROUP
- Customer Relationship Management
- Human Resources Management
- BI
- B2B
- BUSINESS REQUIREMENTS
PROFESSIONAL EXPERIENCE
Confidential
OIC Confidential Consultant
Responsibilities:
- This is Oracle Cloud Application Implementation Project.
- Teh job involves to developed teh objects in OIC (ICS & VBCS).
- Working as a OIC Confidential Developer for AFH Connect IT Digital Project.
- Involved in understanding teh business process requirements & design teh new ICS objects.
- Involved in System Integration testing with Functional Team after develop teh ICS objects.
- Worked on Localization in VBCS for Confidential.
- Developed AMS Media Playlist, AMS UserInfo, Alert List Integration2 Project Title Vita-Mix Oracle Apps Upgrade Project.
Confidential
Confidential -Functional
Responsibilities:- Oracle Application upgrade project to move to teh latest stable version of Oracle e-Business Suite (EBS) me.e., R12.2.9 (Financial, SCM, CRM) and ASCP and Demantra R12.2.9, SOA 11g to SOA 12c.
- To take advantage of teh technology improvements in teh product to ensure compatibility and at teh same time to leverage additional features and functionalities provided by Oracle in its latest releases to achieve technology led business growth.
- Teh primary role in this Project is developing Configuring and Implementation new changed Objects Retrofitting in R12.2.9 and provides teh solution to customer.
- This upgrade project completed within timeline in COVID-19 pandemic and 100% remote working model from March 2020Job Responsibilities.
- Working as a Confidential -Functional/ Confidential Lead and Developer for this Oracle Apps R12.2.9 Upgrade Project.
- Involved in understanding teh business process requirement& upgrade changed Cemli Objects from R12.1.3 to R12.2.9.
- Coordinate with all project Stake holders & Team at Onsite & Confidential .
- Resolved teh all teh third-party system integrations issues after upgrade from R12.1.3 to R12.2.9.
- Vita mix Having Critical Business Integration objects AddressDr, PaymenTech, PayPal, ODI Sync Programs and other Integrations.
- Involved in System Integration testing after upgrade teh Oracle Apps system in R12.2.9.
- Responsible to Run teh Config Snapshot tool to find teh Customization impact analysis report of Oracle EBS R12.2.9 after upgraded.
- Responsible to identify all teh impacted Object after Upgrade teh system and provide teh solution to customer.
- Responsible for code review, document review, Document/Code versioning and file management control in GitHub Vitamix Common Share point.
- Worked with FNDLOAD utility to migrate objects from one instance to another instance till Production.
- Run teh GSS Program to Improve teh performance after upgrade teh system performance issue.
- Worked on Oracle Business Event/Alert/Form Personalization/Custom Hook &Custom Pll, XML Reports.
- Worked on to Modify teh Vitamix Auto Receipt custom concurrent program after upgrade due to Oracle system Bug in R12.2.9.
- Worked on to modify teh Dr. Address Validation Custom Program after Upgraded data base from 11g to 19C.
- Worked on PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes for modification and retro fitment in upgraded 19C Oracle Data base.
- Developed BR100, TE040, MD070, TE020 and MD120 Documents.
- Confidential Support, Guidance and Planning for Code migration from Development through Production.
- Managed Oracle Critical SR and Spinning SR with Oracle during Oracle Upgrade Time.
- Managing teh Tickets, resolving teh issues on day-to-day basis on priority after Confidential .
- Interacting with Users for required information about teh issues arise.
- Resolving user's day to day functional issues by understanding and analysing them.
- Raising Service Reques.
Confidential
Oracle Fusion Confidential -Functional
Responsibilities:
- This was an Oracle Application Cloud Implementation & Support Project.
- Teh job involves Implement/support on Financial Modules General Ledger (GL), Account Payables (AP), Account Receivables ( Confidential ), Cash Management (CM) and Fixed Assets (FA).
- Job Responsibilities Responsible for Configuration of Financial Modules (GL, AP, Confidential & CM).
- Finalized Data Migration Strategy for Financial Objects.
- Worked on Data Migration for General Ledger, Payables, Receivables and Fixed Asset.
- Design System Configuration Documents for Financial Modules.
- Worked on VBCS developing web application, Consuming REST, SOAP Services and Business events.
- Worked on to Manage Daily Rate using FBDI Templates, Load using Import and Calculate Daily Rates Programs.
- Worked on an integration to import GL Journals into ERP Cloud using Oracle Standard Web Service WSDL in ICS.
- Worked on inbound integration for Customer Creation/Update in ERP cloud to Integrate Sales force in Oracle ERP Cloud using Salesforce Adapter.
- Worked on in Data Migration using FBDI in Financial Modules for Suppliers.
- Worked on to develop new reports and enhance standard ERP Cloud reports using reporting tools (Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP).
- Worked on Oracle Integration Cloud (OIC) adapters, usage of REST Adapter, SOAP Adapter, ERP Adapter, Salesforce Adapter, FTP Adapter, File Adapter, usage of orchestration integration patters. Developed ICS Inbound interface to Create Invoices in Oracle Fusion cloud using ERP Cloud Service.
- Worked on VBCS to Build teh Custom Form for approval process.
- Worked on VBCS developing web application, Consuming REST API, SOAP services and Business events.
- Task and responsibilities performed include Work around, Development, application setup, documentation, training, testing, and preparation of end user manuals.
- Worked on VBCS to Build a Web application to manage ERP Banks Information using REST APIs provided by Oracle.
- Involved in understanding teh business process Requirement and design requirement/setup documents.
- Responsible for document review and Unit Test case Preparation.
- Conduct CRP1, CRP2 & UAT and System Testing.
- Handling teh Service Now Tickets, resolving teh issues on day-to-day basis on priority.
- Interacting with Users for required information about teh issues arise.
- Post Production Support.
Confidential
Confidential -Functional
Responsibilities:
- Confidential was looking to streamline teh accounting process with Confidential to accelerate accounting, consolidation and financial reporting.
- In order to support this initiative, Confidential IT organization is required to integrate teh Financials from Confidential 's Oracle EBS R12 into Global ERP running on SAP.
- This was Integration Implementation Project in Oracle Applications R12.1.3 and provided teh solution and design for this project in Oracle General (GL) Modules, Oracle Payables (AP), Oracle Receivables ( Confidential ), Oracle Project Accounting (PA) and Oracle Inventory (INV).
- Worked as a Confidential -Functional, Confidential Lead and developer for this project.
- Interacted with end users to understand teh business requirements from Confidential.
- Coordinate with all projects Stake holders (SAP, Oracle EBS & Webvan Team) at Confidential.
- Managed Senior Management Review (SMR) Meeting and Customer with weekly.
- Worked on to prepare teh mapping documents for inbound/Outbound interface Programs.
- Worked on to prepare teh High-Level Design document for Outbound/Inbound interface parallel processing Programs from Oracle Apps to SAP Integration.
- Developed a common PL/SQL Package Code Block Engine to generate teh SAP code block string, this value is held in a DFF on teh Accounting segment, teh engine translation mapping values/data between Oracle & SAP and used for AP, Confidential & GL Interface programs.
- Worked on to developed teh web service all teh parallel processing program using SOAP (WDAL to WSDL) format.
- Involved in Confidential design and development of teh Interfaces " Confidential - FI095 Confidential Invoice Parallel Program".
- Involved in Confidential design and development of teh XML Report " Confidential - FI095 Confidential Invoice Interface Error Report".
- Involved in Confidential design and development of teh XML Report " Confidential - Code Block Engine Error Report".
- Responsible for code review, document review, Document versioning and file management in Confidential .
- Worked with FNDLOAD utility to migrate objects from one instance to another instance.
- Writing PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes.
- Confidential Support, Guidance and Planning for Code migration from Development through Production.
- Responsible for post go live support resolution delivery.
- Development of packages & procedures as per client coding standards.
- Worked with FNDLOAD utility to migrate objects from one instance to another instance.
- Registrations of AOL objects.
- Based on Confidential process design MD50, TE040, MD070, TE020, MD0120 Documents.
- Involved in Development Integration test.
Confidential
Confidential -Functional
Responsibilities:
- Integration of Oracle EBS R12.2.6 to ECOM via DELL BOOMI trough Outbound Interfaces in XML Format.
- This is Implementation Project in Oracle Applications R12.2.6 and provided teh solution and design for this project in Oracle Inventory (INV), Oracle Order Management (OM), Oracle Receivables ( Confidential ), Oracle Transport Management (OTM) Modules.
- Contributed as a Confidential Lead for this project and worked as a developer in times of need basis.
- Involved in understanding teh business process Requirement and provided solution for this integration.
- Coordinate with all Project Stake holders at Onsite & Confidential.
- Involved in Functional, Confidential design doc and development of teh Interfaces for teh Integrations Objects from TMS (Oracle Application) to OTM Call via DB Link.
- Involved in Functional, Confidential design doc and development of teh Interfaces for teh Integration from ECOM to TMS (Oracle Application) & OTM Call via Dell Boomi.
- Involved in Functional, Confidential design doc and development of teh XML Report "Terex Fixed Freight Order Comparison Report".
- Involved in Functional, Confidential design doc and development of teh Interfaces "Terex AWP-ECOM Sales Order Update Freight Charge Program".
- Responsible for code review, document review, Document versioning and file management in PVCS.
- Worked with FNDLOAD utility to migrate objects from one instance to another instance.
- Writing PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes.
- Developed MD050, TE040, MD070, TE020 and MD120, Documents for all components.
- Confidential Support, Guidance and Planning for Code migration from Development through Production.
- Post Go Live Confidential.
Confidential
Confidential -Functional
Responsibilities:
- Integration of Oracle EBS R12.1.3 to PROS Master & Transactional Data trough Outbound Interfaces in XML Format and transfer to shared location via SFTP to PROS system provided teh solution and design for this project in Oracle Inventory (INV), Oracle Order Management (OM), Oracle Receivables ( Confidential ), and Oracle General (GL) Modules.
- Worked on with customer to understanding teh business process Requirement.
- Coordinate with all project Stake holders at Onsite & Confidential.
- Involved in Confidential design and development of teh Interfaces for teh Integration.
- Developed Hologic PROS Product Dimension Interface Program.
- Developed Hologic PROS Customer Dimension Interface Program.
- Developed Hologic PROS Sales Org Dimension Interface Program.
- Developed Hologic PROS Currency Dimension Interface Program.
- Developed Hologic PROS Date Dimension Interface Program.
- Developed Hologic PROS List Price Lookup Interface Program.
- Developed Hologic PROS Sales Cube Interface Program.
- Developed Hologic PROS Ready to Process Interface Program.
- XML File generation Process and FTP Process Quality checks.
- Worked on Confidential to Developed Custom Forms for all teh above interfaces.
- Responsible for code review, document review, Document versioning and file management in Confidential.
- Worked on SQL Loader Programs Development.
- Worked with FNDLOAD utility to migrate objects from one instance to another instance.
- Writing PL/SQL procedures, packages, Data base triggers and Functions, Tables, Sequence Synonyms, Views and Indexes.
- Developed MD70, TE20 and MD120, Documents for all components.
- Confidential Support, Guidance and Planning for Code migration from Development through Production7 Confidential Implementation, Rollout & Support
Confidential
Data Migration Confidential Lead/Developer
Responsibilities:
- This was an Oracle Application Implementation, Rollout & Support Project.
- me was at onsite Confidential lead, took ownership of Data Migration along with Confidential IT team.
- Data Migration included development of data loaders, complex data migration scripts, testing of these scripts and performing data migration & validation.
- Basically, a Confidential client who manufactures teh hydraulics related equipment in Oracle Inventory (INV), Oracle Purchasing (PO), Oracle Order Management (OM), Oracle Receivables ( Confidential ), Oracle Payables (AP), Oracle General (GL) Bill of Material (BOM), Work in Progress (WIP) Modules Oracle Application R12.1.3.
- Coordinate with stakeholders to understand teh requirements.
- Worked on to Support data transformation team.
- Worked on to Support data validation team.
- Worked on to design and development of Item, Locator, Stock Level, Routings and Bill of Material, Purchase Order, Skip Lot & Sourcing Rule, Payable Invoices, GL Interface Data Migration Programs.
- Worked on teh bug fixes during teh testing and support phase.
- Worked on development of new XML reports, Form customization & personalization, XML BI Publisher Reports.
- Developed Receiving Process Auto Delivery Transaction interface e program in Oracle Purchasing.
- Developed GL Daily Rates Conversion program by using Interface.
- Responsible for code review, document review, code versioning and maintaining teh same in Confidential.
- Worked with FNDLOAD utility to migrate objects from one instance to another instance.
- Writing PL/SQL procedures, Packages, Data base triggers and Functions, Tables, Sequence Synonyms, Views and Indexes.
- Developed MD50, MD70, CV60, TE20, and MD120 Documents.
- Worked on Support post go live activities8 Confidential.
Confidential
Confidential -Functional
Responsibilities:
- This was an Confidential #36950 Confidential Tax Reporting Development and Enhancement Project.
- Involved gather business requirement and development of Conversion/ Interface programs, XML Publisher Reports with bursting program in Oracle Human Resources Management System (HRMS) and Oracle Fixed Asset (FA) modules Oracle Application (R12.1.3) and Oracle 11.5.10.2.
- Developed Confidential Tax Credit Extract to Payroll Concurrent Program.
- Developed Confidential Transfer (FTP) Tax Credit files to Payroll.
- Confidential Payroll to Tax Credit tables -FTP and Upload.
- Confidential Payroll to Tax Credit tables -FTP.
- Developed Confidential Tax Credit Extract to Payroll Concurrent Program.
- Developed Confidential Transfer (FTP) Tax Credit files to Payroll.
- Confidential Payroll to Tax Credit tables -FTP and Upload.
- Confidential Payroll to Tax Credit tables -FTP.
- Developed 7 XML Publisher Reports for Confidential Ohio Tax Credit Reporting in Oracle HRMS and Payroll.
- Developed Active and Retired Asset XML Reports in Oracle Fixed Assets.
- Developed Confidential Tax Book Asset Number Initial Load Interface Program.
- Developed Oracle Standard 23 database PL/SQL custom procedures (for flex-builder to use) for teh new book ( Confidential TAX BOOK) to run depreciation program successfully through flex-builder to generate accounts in Oracle Fixed Assets.
- Done enhancement of custom workflow PL/SQL Package "EFACLOSE" for teh new tax book " Confidential TAX BOOK" which earlier had teh" MXN TAX BOOK" to close teh " Confidential Tax Book" by running teh program "FA Close" successfully.
- Responsible for post go live support resolution delivery9 Project Title: Balfour Beatty Implementation.
Confidential
Confidential Developer
Responsibilities:
- This was an Implementation Project in Oracle Apps R12.1.3.
- Teh job involves development/documentation of Workflow, XML Reports, Custom Business Subscription and Alert for Oracle Payables, Oracle Learning Management and Oracle HRMS.
- Teh primary role in this Product is Developing and Configuring and Implementations in Oracle Human Resources Management System (HRMS) and Oracle Payables (AP) Modules.
- Developed Joining Instruction Notification workflow using API User Hooks in Oracle Learning Management to send teh email notification to teh learners.
- Developed Financial Payment Run Extension using custom Hook to validate invoice during invoice validation time in Oracle Payables.
- Developed Payroll Cut-off Extension using API User Hooks in Oracle HRMS for creates/updates/deletes" teh absence from self-service and for creates/updates teh bank payment method from self-service.
- Developed MD070, TE020 and MD120 Documents for all teh development components.
- Duties include interaction with onsite for Requirement gathering, modification of Components as per client requirement, implementation & documentation.10 Flowserve Development/Enhancement
Confidential
Confidential Developer
Responsibilities:
- This was a Development/Enhancement Project in Oracle Apps R12.1.3.
- Teh job involves development and Customizations of Reports and Concurrent Program in Oracle Inventory (INV), Oracle Purchasing (PO), Oracle Order Management (OM), Oracle Receivables ( Confidential ), Oracle Payables (AP), and Oracle General (GL) Modules.
- Developed FLS Confidential SHG Sales Order BOM Report in Oracle Order Management.
- Developed FLS Confidential SHG Printed Purchase Order Report in Oracle Purchase Order.
- Developed FLS Receivable Confidential Receipt voucher Printing Report in Oracle Receivable.
- Developed FLS Prepayment Status Report in Oracle Payables.
- Developed FLS Confidential Book Report in Oracle Payables.
- Developed FLS Invoice Aging Report in Oracle Payables.
- Developed FLS Confidential SHG WSH Packing Slip Report in Oracle Order Management.
- Developed FLS Confidential SHG PO Receipt to Inventory Report in Oracle Purchase Order.
- Developed FLS Receivable Confidential in Oracle Receivable.
- Developed MD70, TE20 and MD120 Documents for all components.
Confidential
Confidential Developer
Responsibilities:
- This was an Implementation Project in Oracle Apps R12.1.3.
- Teh job involves development and Customizations of Data Migration, Interface Concurrent Programs and XML Reports in Oracle Inventory (INV), Oracle Purchasing (PO), Oracle Order Management (OM), Oracle Receivables ( Confidential ), Oracle Payables (AP), and Oracle General (GL) Modules.
- Worked as Confidential Developer, using Oracle Applications R121.3.
- Developed Oracle Custom Oracle Reports using Reports10g.
- Worked on development of Oracle XML/RDF reports.
- Worked on Item, On hand, Item Locator Conversion Programs.
- Developed MD70, TE20 and MD120 Documents for all components.
- Developed Test Cases for Reports, Alerts, Interfaces and Conversions.
- Developed system Test Cases & System Test Plan documents.
- Converted/Upload Test cases into Quality Center format.
- Worked on to mapped Test Cases to requirements in Quality Center.
- Involved in Development Oracle Custom Integration Testing.
- Involved in System Integration testing.
- Developed Common PL/SQL Package to used objects where applicable.
- Preparation of SQL loader scripts to load teh data into Staging Table to process in Oracle Apps System.
- Developed Understanding documents and corresponding Confidential documents.
- Worked on to creation of Data group, Request group and custom menu.
- Writing PL/SQL procedures, packages, Data base triggers and Functions.
- Creating custom objects like tables, sequence synonyms, views and indexes12 Confidential Oracle Apps Implementation.
Confidential
Confidential Consultant
Responsibilities:
- This was an Implementation project in Oracle Applications 11.5.10.2, worked as a Confidential Consultant in Accenture, Confidential, Confidential Development Center.
- Teh job involves design and development of Conversion, Inbound/Outbound custom Interface Concurrent Programs, customization of Oracle Standard Report and developed custom XML Reports in General Ledger (GL), Account Payables (AP), Oracle Receivable ( Confidential ) and Cash Management (CA).
- Developed Customer Conversion Program in Oracle Receivable.
- Developed Account Payables Open Interface for Prepayment in Oracle Payables.
- Developed Customer Extract Out Bound Interface in Account Receivables.
- Developed New Report Confidential Invoice Report in Xml Publisher in Account Receivables.
- Developed New Report Credit with Suppler Report in Account Payables.
- Customized Oracle standard Report "Customer Listing Details" in Account Receivables.
- Customized Oracle standard Report "Customer Listing Summary" in Account Receivables.
- Customized teh Oracle Standard Report "Cash in Transit Report" in Cash Management.
- Customized teh Oracle Standard Report "Bank statement Detail Report" in Cash Management.
- Customized teh Oracle Standard Report "Invoice Aging Report" in Account Payables.
- Customized teh Oracle Standard Report "Aging - 7 Buckets - By Account Report".
- Customized teh Oracle Standard Report "General Ledger - (180 Char)".
- Customized teh Oracle Standard Report "Transaction Available for Reconciliation".
- Customized teh Oracle Standard Report "Unapplied Receipt Register".
- Writing PL/SQL procedures, packages, Data base triggers and Functions. Creating custom objects like tables, sequence synonyms, views and indexes.
- Duties include interaction with daily basis onsite for Requirement gathering, modification of Components as per client business requirement, implementation & documentation.
- Developed MD070, TE020 and MD120 Documents based on Oracle Application Implementation Methodology (AIM).
- Follow teh coding standard during developed teh code based on customer coding standard document.
- After Confidential provided teh production support to resolved simple/complex issue based on priority in tickets.13 DLL Oracle Apps Implementation
Confidential
Confidential Consultant
Responsibilities:
- DLL Implementation project in Oracle Applications 11.5.10.2 worked as a Confidential.
- Confidential Development Center.
- Teh job involves design and development of Conversion, Inbound/Outbound custom Interface Concurrent Programs, customization of Oracle Standard Report and developed custom XML Reports in Oracle Lease Management (OLM), Oracle Account Receivables ( Confidential ) and Oracle Inventory (INV).
- Developed Custom Concurrent Program Using PL/SQL Package for Advance /progress Funding Interest Billing.
- Developed Custom Concurrent Program Using Pl/SQL Package for Uncollected Advance /progress Funding Interest Billing.
- Create 3P for advance booking Interest Billing Custom Concurrent Program.
- This 3P will be support various Interest treatment option while teh contract is booked in 3P.
- Customized teh Oracle Standard report Cancellation reason Report.
- Design MD070, TE040 and MD120 document based on Oracle Application Implementation Methodology (AIM).
- Developed all teh Interface/report based on teh DLL Coding Standard documents.
- Writing PL/SQL procedures, packages, Data base triggers and Functions.
- Creating custom objects like tables, sequence synonyms, views and indexes.
- Duties include interaction with client for Requirement collection, modification of modules as per requirement, implementation & documentation.
- Worked on to generate LDT files for Concurrent Programs, Value Sets and Request Groups.
- 14 Oracle Cane Management System.
Confidential
Confidential Consultant
Responsibilities:
- Oracle Custom Cane Management system in Oracle, worked as a Confidential .
- Teh job involves design, development and support of customer in Oracle Cane Management system in Oracle 9i, Form6i and Report 6ifor Tables, Views, Index, Sequences, Procedure, Function, PL/SQL Package, Forms and Reports in Oracle Custom Cane Management ERP System.
- Developed Custom Reports to display teh Grower Name, Village Name, Center Name, and Date of Delivery of Can by Grower to halp Management take decisions.
- Create one custom Form to enter teh subscriber details and teh subscriber details, system will auto generation of a unique subscriber's number.
- Developed a custom Report to display teh details of teh tariff of crop which tariff is decide by Government.
- Developed Proof of Delivery Slip Report, there will be a concept of POD (Proof of Delivery) according to which teh subscriber on receiving teh product will confirm so to teh organization by signing a Proof of Delivery slip.
- Generate Grower Payment Invoice Report based on teh Grower Details.
- Create Master Form to keeps details of teh tariff of crop which tariff is decide by Government
- Master Forms will be created which are generated predefined masters maintaining unique data to avoid redundancy
- Data security is maintained to relatively high level by implementing it at Database level, to ensure dat only authorized users has access to confidential client information.
- Attached custom Form and Custom Reports in Custom Menus of Can Management Custom Application
- Given Support to Production Unit in shift Basis and resolved teh production issue as high priority
- Design teh Technical, Test Case documents using Confidential Standard word doc Template
- Responsible to send all teh report which Management is required on daily basis.
- Coordinate with system Users and Can Manager, Finance Business Manger to Understand and resolved teh any Production Issue.15 Oracle Add Booking System
Confidential
Confidential Consultant
Responsibilities:
- Oracle Custom Add booking system in Oracle, worked as a Confidential Consultant in Confidential.
- Teh job involves design, development and support of customer in Oracle Add Booking system in Oracle 9i, Form6i and Report 6ifor Tables, Views, Index, Sequences, Procedure, Function, PL/SQL Package, Forms and Reports in Oracle Custom Add Booking ERP system.
- Create Master custom table to keeps teh details information of adds such as add type, add description, and add categories dat used in Oracle Form to enter teh transaction by business user.
- Developed custom corporate client details report to display teh details information of ads such as add type, add description, and add categories.
- Create Custom Form and Report to keep track teh add booking and along with Date of advertisement, Zone, Country or upcountry, Rate, colour type, Size.
- Developed invoice generated report based on payment mode, total Adds, customer code R.O Number from teh booking and docket no.
- Submission of Weekly reports to teh Client and Internal Management Service Now Ticket Statuses.
- Managing teh Tickets, resolving teh issues on day-to-day basis on priority.
- Design teh Technical, Test Case documents using Confidential Standard word doc Template.
- Writing PL/SQL procedures, packages, Data base triggers and Functions.
- Creating custom objects like tables, sequence synonyms, views and indexes.
- Given Support to Production Unit in shift Basis and resolved teh production issue as high priority.
- Coordinate with system Users and Can Manager, Finance Business Manger to Understand and resolved teh any Production Issue.