Oracle Technofunctional Consultant Resume
Ga, Usa
PROFESSIONAL SUMMARY:
- Over 10 Years of experience in to Oracle EBS Technical consultant.
- Having 10 plus years of experience in development and customizations of oracle E business suite Release and Oracle Cloud (Demand) Offerings .
- Professional experience in end to end Implementation in Oracle Supply Chain/Demand planning .
- Expertise working knowledge wif Procure to pay (P2P) and having good knowledge in Order to Cash (O2C) flows
- Good Expertise in Workflow Builder and API programming.
- Excellent EBS Technical skills in Production Support, Designing, and Development of applications using SQL, PL/SQL, and having good experience in Oracle R12 Applications Implementation, Production Support and Customizations in the areas of SCM, FIN and HRMS wif expertise in Development of W.R.me.C.E Components using OAF, Oracle RDBMS, SQL, PL/SQL, XML reports, Oracle forms and Oracle Workflow Builder.
- Performance Optimization changes for Improving Performance in Applications, PL/SQL packages.
- Expertise as a Techno - Functional Consultant in SCM and FIN modules.
- Worked Extensively on Workflow Business events.
- Excellent Technical Development skills in Interface and Conversions.
- Hands-on experience in Oracle Integrations, Data Conversion, Data Migration, Report Generation and Developing Interfaces wifin several modules in Oracle Applications.
- Hands on experience wif creating custom JSP pages, extensions and personalization of existing OA Framework pages.
- Good Expertise in Trading Community Architecture (TCA).
- Certified Oracle EBS R12: Oracle Inventory and Order Management.
- Certified Oracle SQL 11g and PLSQL 11g.
- Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle EBS wif major focus in Depot Repair, Service Requests, Inventory (INV), Purchasing (PO), Work in Progress (WIP), Bills of Materials (BOM), me-Procurement, me-Expense, Order Management (OM), Accounts Receivable (AR), Accounts Payables (AP), General Ledger (GL).
- Worked extensively wif Oracle Support on Online Patching during Upgrade.
- Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA), Software Quality Management System and software Development Life Cycle (SDLC).
- Highly experienced in Software Design, Analysis, Coding, Development and Testing wif specialization in ORACLE 12c/11g/10g based Client-Server and Three-Tier Computing Architecture, Database Design and Development, Implementation, Production Support & Maintenance and Quality Assurance.
- Experience wif various technologies such as Oracle, Structured Query Language(SQL), Procedural Language and Structured Query Language (PL/SQL), Oracle Application Express (APEX), Oracle Forms (11g/10g/9i) and Oracle Reports (11g/10g/9i), SQL Loader, shell scripting.
- Extensive experience in writing/debugging Oracle Back-end PL/SQL development by writing Packages, Stored Procedures, Functions and Triggers. Strong knowledge in using Oracle built-in packages, Cursor management and Exception handling.
- Experienced in creating and maintaining Database Objects like Tables, Views and Materialized views, Indexes, Constraints, Sequences, Synonyms and Database Links and Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic.
- Experienced in Tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds)
- Experienced in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan and TKProf.
- Having good knowledge on ERP Modules CRM(IB/SA/TCA), OM, AR and GL.
- Experienced in application fine-tuning and database fine-tuning using Explain Plan and analysis tools, monitor performance and identify bottlenecks and System Tuning and Monitoring indexes and analyzing their status for performance tuning and query optimization.
TECHNICAL SKILLS:
Oracle Financials: Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Projects, Cash Management, Oracle Fixed Assets, me-ProcurementOracle Distributions Oracle Purchasing, Oracle order management, me-Procurement
Oracle Manufacturing: Oracle Inventory, Work in Process, Bills of Materials, Planning.
Oracle SCM: Depot Repair, Service Requests, Inventory Management, and Oracle Purchasing & CRM Technologies PL/SQL, Workflow Business Events, ISG, Reports6i/10g, Forms6i/10g, SQL*Loader, XML Publisher, Workflow, MS office, Toad, Sql Developer, SQL*plus, Shell Scripting, FND loader script, C, C++, Core Java, JDeveloper, ADF, OAF, Putty, Win sap, PVCS, HTML, DHTML, XML, Kintana, Oracle applications Release R12,115.10.2,11.5.10 &11.5.9, oracle 8i/9i/10g, OraRRP tool1, Web logic server, B2B, EDF&EDI
PROFESSIONAL EXPERIENCE:
Confidential, GA, USA.
Oracle TechnoFunctional Consultant
Responsibilities:
- Involved Design and Developed Oracle B2B wif Custom Modules wif Oracle Workflow.
- Developed Event Integrations between EBS and legacy systems in Internal Purchase Orders flow.
- Developed custom workflows to automate the process in B2B .
- Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and TKProf for faster and better performance of the SQL queries.
- In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables and use of various methods like global temporary tables etc.
- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE,TKPROF, and AUTOTRACE.
- Extensively used oracle hints to direct optimizer to choose an optimum query execution plan.
- Used Bulk collections for better performance and easy retrieval data, by reducing context switching between SQL and PL/SQL.
- Generating AWR and Execution plan at application level to find root cause for data flow from legacy systems and fixing the performance issues by using efficient SQL statements.
- Expertise in iProcurement, Purchasing and Accounts Payable functional step-ups including sub-ledger accounting, bank and bank branches, Party Model, organizational configurations.
- Designed Workflow to send PO attachments for expense Items Approval.
- Developed Custom Workflow for PO transactions like PO attachments, PO requisitions, Advanced Ship notice, Receiving Routing etc.
- Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
- Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain plan, Auto trace, TKPROF and tuned them for better performance.
- Worked on form personalization’s changes on Oracle PO Requisition form .
- Developed Supplier Master data like Suppliers, Supplier Sites, and Supplier Contacts and Supplier Banks interface to export from 11i system to R12.1.3.
- Developing reports through Oracle Reports and XML Publisher
- Developing custom interfaces between various Applications for integration.
- Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
- Requirement gathering in Oracle Application Procurement, analyze current process, and automate/improve the processes.
- Worked on interfaces and BI/XML Publisher reports as part of Implementation/integration of new acquisitions to Oracle EBS Application.
- Developed standalone PLSQL scripts to load Manufacturer Parts for master organization items in Oracle Application.
- Implemented Oracle INV module in current existing Order process.
- Developed Inventory Interfaces to share data across wif third party vendors.
- Developed programs to extract data for Inventory Logistics and Third-party maintenance like Item Master, new Organizations implantation.
- Design and Development of multiple programs to extract application attachments (Short Text, Long Text and File Type) from different modules like PO, INV, BOM, and WIP by using UTL FILE package and keep it in specified server path using Database Directories.
- Developed standalone SQL scripts and standard API's PL/SQL scripts to load or fixing production data on P2P modules like PO, PLANNING, INV and AP .
- Customized oracle standard form using CUSTOM.pll so dat the users cannot Reprint the custom Pick Slip report from Tools menu.
- Participated wif functional consultants to know the business functionality while design and development of technical components.
- Participated wif business users to understand the business flow and design and development of new custom objects.
- Developing Check Printing report in account payables wif template design.
- Developed Invoice out bound Interface to load the Invoice Payment details using UTL FILE Package .
- Developed Alerts to report Customers about Purchase Order Booking status during P2P flow .
- Increased performance by creating Indexes and Hints.
- All the deliverables will be delivered in Agile Methodology using the JIRA Sprint Planning .
- Customized and developed Oracle Forms/Reports, workflow and Data conversions in PO.
- Involved in the unit testing and conducted the UAT for all the conversion and interface objects.
- Created UNIX shell scripts for the data conversion from the legacy system to Oracle EBS.
- Generated PO XML data and send to Legacy systems on event based.
- Developed various Interfaces Invoking SOAP API's through PL/SQL.
- Developed Order Create Webservice and Publish from PLSQL package in JDeveloper
- Developed programs to call REST and SOAP API’s through SOA.
- Developed PL/SQL package which will invoke SOAP API's to generate PO receipt XML payload and transfer to SOA/BPEL.
- Worked wif Oracle Fusion Middleware Adapters, Oracle JDeveloper, BPEL, Mediator and transformation using XPATH, XSLT functions
- Modified Business Rules in EBS Code to support third party SOA integrations.
- Developed Integrations programs to call Webservices using SOA.
Confidential, FL, USA.
Oracle TechnoFunctional Consultant.
Responsibilities:
- Developed SQL s to extract data from various modules like AP, GL, PA, PO, BOM, WIP and EAM in Oracle EBS Application for target application.
- Extensive knowledge in Trading Community Architecture (TCA) and worked on importing customers into AR using TCA API s.
- Customized Standard AR Print Statements Report using XML Publisher.
- Developed and customized XML Publisher Reports in PO, OM, AP, AR, and INV.
- Developed Internal Requisition Interface and convert into Internal Orders in P2P.
- Developed custom WorkFlow process using workflow builder to send EBS Data to salesforce/Mango DB.
- Design and development of multi - language XML/BI Publisher report and customization changes on oracle custom reports.
- Setting of multiple approval hierarchies for various Purchase document types based on dollar amount, buyer and cost center.
- Developed XML Publisher Reports wif template as RTF, EXCEL and source as RDF Reports, PL/SQL and XML.
- Developed Custom Business events to send Customer data to Sales Force in Json format.
- Worked on internal EBS R12.1.3 and SOA projects for implementation and Customizations of new functionality related to Order Management (OM), Manufacturing (WIP, BOM), Procurement (PO) and WareHouse Management (WMS) modules
- Created Business Events as part of Supplier and Customer Interface.
- Created custom profiles and customized standard purchase printing process for PO Terms and Conditions based on operating unit specific.
- Worked Extensively on Order Management, Advanced Pricing, B2B, Inventory, WIP and BOM.
- Developed Workflow me-Supplier Module to send Product information as attachment details as document upon approval.
- Developed Many custom BI Publisher Reports wif bursting functionality.
- Developed and Modified Existing Forms using Custom.pll and Form Personalization s as per Business Requirements.
- Worked on developing custom program to streamline Receiving Transaction Interface (RTI) process in Oracle Purchasing (PO). dis involved writing error reports which show s records failed in the daily interface.
- Developed Order to Customer flow documents in OTC (ASN, Shipment Notice and Internal Orders, Routing to TPM), in B2B.
- Developed programs to extract historical data from Oracle EBS system for target application reference.
- Actively involved in the post-go live support to resolve the business issues wifin the time bound.
- Onsite Lead Analyst and data collector to pass and lead corrections and fixes wif the Offshore Team.
- Worked on a form personalization for a custom Quick Sales Order form in OM to display a pop-up message once per customer when the customer is entered on the order and the customer TEMPhas a special need whereas the special needs will be captured at the customer account level by creating new Descriptive Flex fields.
Confidential - Cleveland, OH
Oracle Sr. Application Consultant
Responsibilities:
- Participated in Upgrade and integration project from 11. .2.5
- Created Oracle Workflow vacation rules and changing approval hierarchies based on BPO's request.
- Created form personalization changes on UOM Conversion form to restrict Standard UOM tab for specific responsibilities.
- Worked on form personalization changes on Purchase Order form to display Manufactures Supplier Items at PO line level and display the same in PO Document.
- Design and development of customizing Picking List and Packing Slip XML Publisher Reports for different operating units in Oracle Shipping Module.
- Worked on Supplier Hub implementation project in Oracle 12.2.4.
- Worked extensively in Procurement process interfaces ( P2P ).
- Developed AP invoice import Interface to import invoices to Accounts Payables.
- Developed extensive modifications to PO Account Generator using work flow builder.
- Worked on Employee Conversion and Integration to Supplier hub using HRMS APIS.
- Worked on Geographical hierarchy load conversion using Oracle APIs to supplier Hub in Oracle R12.2.4 environment.
- Worked on Interfaces and conversions from various instances such as GEMS, LATAM, ASIAPAC to Supplier Hub using oracle APIs .
- Developed Supplier conversion and Integration to Oracle MDM to get the Supplier data like Supplier information, Sites and Contacts into R12 from 11i.
- Involved in Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
- Implemented the Integrated supplier import interface. Activities involved creation of Loader File, porting suppliers into the interface tables using SQL*Loader and then using Integrated Supplier Import Interface to port the data into the base tables.
- Involved in building SOA services for Locations, Supplier Interface using JDeveloper10g .
- Imported Suppliers from third party system (SWEEP) into Oracle system using SOA middleware Integration.
- Design and development of EDI947 inbound interface through SOA services to load Inventory Adjustment Transactions (Miscellaneous Receipts and Miscellaneous Issues) from legacy system to Oracle EBS application through Oracle Standard API's
- Design and development of EDI940 outbound interface integration to extract Oracle EBS Sales Order Shipment details to 3PL (DHL and DSV) through BPEL process using Oracle Business Events and Advanced Queues.
- Design and Development of MTO form to create batches for finished product process manufacturing based on Sales Order details using Oracle Standard API's
- Developed SQL* Loader Scripts to load the data from input files into staging tables to be ready for the interface programs.
- Worked on Business Events and subscriptions to Integrate data from source system to target system.
- Worked on Tuning of queries of the Custom BI Publisher Reports to improve the performance utilizing diagnostic tools (Explain Plan, TK Prof).
- Design and Development of custom changes like Bulk-Off and Write-Off options for users on OPM batch detail form while closing/cancel/ complete the pending and WIP status batches using CUSTOM.PLL changes.
- Development of BI/XML Publisher reports like LPN Pallet Label printing, reprinting LPN Pallet Labels reports in OPM modules.
- Developed FG Completion and Handheld Scan programs as part of Incremental Back flush in Oracle Process Manufacturing using Oracle standard API’s.
- Converting database-intensive jobs to PLSQL for performance improvement.
- Worked wif performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages, Procedures and Reports developed.
- Design and Development of new Sub-Inventory Transaction custom form to transfer the material between sub-inventories in OPM inventory module.
- Developed BI/XML Publisher HMIS Label print and Receiving Label Print Report in Oracle Process Manufacturing.
- Developed Multi Layout XML Publisher Customer Delivery Notes Report and customer statement reports in Oracle Order Management and Oracle Account Receivable modules.
- Involved in custom form changes and form personalization changes on Batch creation, Batch Details, Inventory Adjustment, Bank Statement Reconciled forms in Oracle Process Manufacturing, Inventory and Cash Management.
- Worked on customization changes on Price List and Customer WEB ADI objects to load the updated changes in Oracle application.
- Customized AR customer statement Report to send customer statements through email, fax and print using Bursting Technology.
- Design and development of SOA BPEL processes for real time interfaces like Supplier Master creation/update from Oracle EBS system, synchronization process of Supplier profile information back to EBS, Supplier invoice transaction number update back to order entry system.
- Designed and developed a custom error handling framework for the entire organization.
- Extensively used XSLT, XSD, and WSDL.
- Developed various Web Services using WSDL, SOAP and Oracle JDeveloper
- Implemented Exception Handling for the BPEL Process models to handle System, Business exceptions.
- Worked wif Oracle Fusion Middleware Adapters, Oracle JDeveloper, BPEL, Mediator and transformation using XPATH, XSLT functions
- Worked on Oracle Apps personalization changes using Oracle Application Framework (OAF).
- Developed custom OAF pages for Splitting Order Lines.
- Developed a new OAF Cycle count pages in Inv Module.
- Personalization and Extension of OAF Technician Portal page in Depot Repair.
- The requirement gathering, design and development of custom applications, customization of OAF pages, extension and creation of new OAF pages.
Confidential, TN, USA. .
Oracle EBS Technical Lead.
Responsibilities:
- Developed and modified various programs in Deport Repair.
- Migrated GL and AP custom interfaces and reports, during oracle financials upgrade project
- Worked on RICE components related to advanced pricing and its integration wif service contracts, Quoting and OM. Set up Price lists, Multicurrency Conversion Setup, Modifiers, Qualifiers, Formulas, Pricing Attributes and Factor Lists.
- Worked wif cross functional teams in developing the extension dat included multiple modules (Quoting/ OM/ EDI/ Pricing/ APC/ Service Contracts).
- Worked on Both Functional and Development areas in AR, AP, CRM modules, INV, WIP, BOM, PO and GL.
- Developed custom code for loading AR receipts through API's
- Migrated GL and AP custom interfaces and reports, during oracle financials upgrade project.
- Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules Setting of profile options at various levels.
- Created a new Legal entity and changed setups as per business requirements.
- Developed program to interface Customer Credit card charges to AR.
- Developed XML report Confidential TechConnect FXO RMA Notice in OM module
- Redesigned formulas, qualifier selectivity and minimized pricing calls during order creation
- Modified several program structures to introduce Performance Tuning techniques like Global Temporary Tables, Bulk Processing and Parallel Execution Methods to improve the performance by 90%.
- Converting database-intensive jobs to PLSQL for performance improvement.
- Developed custom code using standard APIs in order management and integrated wif SOA.
- Used TKPROF and Explain Plan utilities to analyse poorly performing PL/SQL packages.
Confidential, Chicago, USA
Oracle EBS Technical Lead.
Responsibilities:
- Implemented B2B model through Business events wif TPL and TPM (Third Party Maintenance).
- Worked on Supplier conversion for the upgrade from 11i to 12.2.5.
- Worked on BI publisher templates for Accounts payable.
- Worked on Reports to retrofit changes using Reports 6i/10g for OM, INV and PO Modules (Finance).
- Worked on AR Lockbox LLCA and applied the invoice lines to receipts
- Extensively worked on AR Invoices, Payments, and collections - Disputes, Adjustments, and Tasks
- Worked on AR invoice using API and Interface
- Developed custom code for loading AR receipts through API's
- Created Supplier/Supplier sites/Supplier contacts interfaces
- Developed AP Invoice Inbound interface.
- Worked wif Oracle support on online patching during up gradation.
- Implemented and executed the IRISO scenarios and trained the end users regarding it.
- Implemented Indirect Material Procurement planning wif the help of Oracle Inventory (Min-Max) and Purchasing (BPA/Sourcing rule etc.) Application.
- Developed outbound interfaces programs in order management module.
- Optimizations/Tuning for PL/SQL code at various level to improve the performance.
- Supplier Conversion fetching data like Suppliers, Sites, Supplier contacts, Bank Branches and Bank Accounts from multiple source system to MDM hub R12.
- Developed Export documents forms and interfaces of item origin in Order management
- Developed various concurrent programs in TCA Architecture.
- Created new Legal entities when business is merging into Services from Tech Connect.
- Worked on OM and AR invoice using API and Interface
- Generating XML payloads through Business event as per the client requirements.
- Developed various Interfaces Invoking SOAP API's through PL/SQL.
- Interfaces developed to generate payload/WSDL files to share between two systems through business events.
- Custom program to calculate Weighted Average Cost for Items upon receipts in Inventory through Business Events.
- Extracting data from various Data Bases and mapping between the EBS R12.1.3 to BIB file objects for reporting.
- Developed interface which will extract data from various data bases into the existing BIB standard integration data structures which can be used across Operating Units.
Confidential
Oracle EBS Technical Lead.
Responsibilities:
- Developed custom code using standard APIs in order management for cancel lines and release holds.
- Developed outbound interfaces programs in order management module.
- Developed PL/SQL Procedure for Interface program in PO Module .
- Created custom tables, sequences, synonyms and constraints.
- Created custom value sets and registration of concurrent programs.
- Developed custom Reports Using XML Publisher tool.
- Developed PL/SQL procedures for custom objects.
- Developed custom reports for several objects
- Analyze the critical issue and provide the solutions based on priority issue.
- Interact wif business users and provide the solutions for complex issue.
- Worked wif different client tools.
- Created custom value sets and registration of concurrent programs.
- Developed custom Reports Using XML Publisher tool.
- Developed the Technical Documents (MD070) testing Documents(TE020) and Migration Documents (MD120)
- Worked on Enhancement tickets coming as change requests.
- Enable transactions for trading partners through EDI.
- Developed interface data files to application data can interface wif EDI translators.
- Setups and Developed wrapper API programs in EDI and XML gateway for Third party tools to EBS Applications.
- Developed Interface UEDF files from PKMS legacy system to EBS system through EDI element mappings.
- Developed Interface invoke Business events and generates Inventory transactions XML Payload in BPEL.
- Developed PL/SQL package which updates Weighted Average Costs in Inventory upon transactions through Business events.
- Developed PL/SQL package which will invoke SOAP API's to generate PO receipt XML payload and transfer to SOA/BPEL.
- Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
- Supported technical team members for integration functions wif web services and business components.
- Worked in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions.
- Developed custom KITS admin pages for Inv module.
Confidential
Oracle EBS Technical Lead.
Responsibilities:
- Developed Item Master interface in INV from legacy to EBS
- Developed the Workflows and XML Reports
- Testing the functionality and preparing the test cases
- Created the test cases as per the functionality
- Tested the functionality and validated the data
- Analysing the requirement and designing the technical documents
- Developed Product update interface program in OM
- Developed Advanced Ship Notice program in OM integration
- Analysed the existing solution and provided a clean-up strategy of unused modifiers and qualifiers
- Redesigned formulas, qualifier selectivity and minimized pricing calls during order creation
- Actively worked on resolutions for Standard bugs
- Responsible for identifying necessary Order Management setups and preparing BR100 documents
- Designed Supply/Demand workbench customization dat allows Buyers, Requesters and Shippers to collaborate on Approvals, Order creations and shipments
Confidential
Oracle EBS Developer.
Responsibilities:
- Developed Procedures, Functions, Packages and Database objects.
- Presenting Deferrals and Releases amount for TBA on XML reports.
- Writing SQL scripts for fixing bugs and deploying into production.
- Study and analyze the business requirements in existing legacy system and provide solution to manage and streamline Data Migration between different systems.
- Coordinate wif onsite for technical development and provide support in resolving issues related to developing PLSQL Package, forms and Reports.
- Design & data migration from legacy System to Oracle System by using standard APIs, UTL File, and Oracle Open Interfaces.
- Credit Memo and Debit Memo XML Reports per operating unit as per the Business requirement.
- Developing SQL queries to obtain specific information as per requirements.
- Preparation of Technical Design Documents, Test Case Documents.
- Reviewing the code and test the functionality of the applications.
- Testing - unit testing & integration testing along wif test data preparation.
- Optimize the performance and manage the data quality issues.
Confidential
Techno Functional Consultant.
Responsibilities:
- Design & data migration from legacy System to Oracle System by using standard APIs, UTL File, and Oracle Open Interfaces.
- Inventory Reconciliation activities.
- Co-ordination wif the testing team in preparing test plans and test cases.
- Performing Code-walk through wif team lead/end users on regular basis.
- Generating Business reports as per client requirement.
- Done enhancements to PL/SQL Packages.
- Developed INV Reconciliation Report (SQL Report).
- Developed PL/SQL Packages, Stored Procedures, and Functions, triggers, packages & Services to implement the system’s business logic.
- Responsible for communicating wif customer to gather the report requirements and to document and develop/customize the reports using Reports 6i.
- Worked on Customization in EDF packages.
- RCA solutions for critical priority 1 issues in productions.
- Writing SQL scripts for fixing bugs and deploying into production.
Confidential
Technical Consultant
Responsibilities:
- Developed new pl/sql procedures and functions.
- Support throughout all the test instances and Knowledge Transition to Production support team.
- Troubleshooting and solving the issues related to Oracle apps SCM modules.
- Production Support and Maintenance in Oracle Distribution.
- Clearing of pending transactions during month end closure
- Working on SR and updating require information as requested by oracle.
- Preparation of Unit Test Cases and Unit Testing.
- Ad hoc Reporting as per client's requirement.
- Handling Change requests from Clients, Analysis and Bug Fixing to meet SLA..
- Working wif Oracle Support team for emergency bug fixes.
- Design, Development and Customization of Reports.
- Analysis and Development of interfaces code.
- Development of packages and procedures.
- Defining Executables, Registering and Scheduling the Concurrent programs.
- Created different types of Values sets in various modules of the application.
- Writing the Scripts to load the data from legacy systems into Oracle tables.
- Involved in Registering Apps forms, menus, data groups, and request groups and data objects needed for the project as per AOL standard.