Career Objective:

Seeking an oracle apps consultant position to work closely and characterize the architecture and implementation of the platform where my knowledge in consulting can effectively contribute to the successful and advantageous operation of the firm.

Professional Summary:

• Good Knowledge of Multi organization Access control MOAC architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Perform and maintain logs to track reporting activities.
• A distinguished IT professional with 8 years of Professional experience on Oracle Applications as a Techno-Functional consultant in Oracle ERP Application R12, 11i
• Main focus on Implementation, Upgrade, Support and tuning of Oracle Financials, Oracle Manufacturing and Oracle Purchasing, Order Management and Supply Chain modules.
• Experienced in ERP Applications Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Financials, Oracle Manufacturing, Oracle Purchasing, Order Management and Sales.
• Oracle Forms 4.5/5/6i/9i/10g.
• Oracle Reports 2.5/3/6i/9i/10g.
• Experience in all phases of the Software Development Life Cycle SDLC in an ERP environment.
• Outstanding Functional/Technical knowledge in Oracle Applications Oracle Financials like GL -General Ledger, AP-Accounts Payables, AR-Accounts Receivables ,FA-Fixed Assets, CM-Cash Management ,
• Extensive Programming experience in designing reports using Reports 9i/6i/3.0/2.5 like matrix reports, group above reports and designed user interfaces with Forms 6i/5.0/4.5
• PO-Oracle Purchasing, OM Order Management/Advanced Pricing , Manufacturing INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials , Install Base, Service Contracts ,iExpenses , iProcurement and AOL Application Object Library .
• Experience in developing reports using Oracle Reports 10g, Oracle Discoverer and BI Publishers.
• Strong implementation knowledge of O2C Order to Cash , P2P Procure to Pay and Drop Ship end to end Cycles.
• Excellent skills in SQL, PL/SQL, Developer 6i/2000 Oracle Forms and Reports , Discoverer Reports
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Designed Reports based upon specifications and also determined reporting needs based upon specifications.
• Hands on experience in implementing RICE Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions components, workflows, Oracle Alerts, Lookups, OA Framework OAF , XML Publisher Reports.
• Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies.
• Created a lot of Complex, Optimized data queries and performed constant QA checks.
• Hands on experience in using various Oracle technologies to effectively implement an end-to-end solution to an organization's strategic goals and objectives including: Oracle 11i E-Business Suite, Oracle Discoverer, Oracle Application Server and Oracle PL/SQL and SQL and Oracle RDBMS, Oracle Developer Oracle Forms and Reports Developer
• Possess good expertise in developing programs using SQL loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Experience in development of concurrent programs, customization and modifications of reports.
• Extensive experience in designing, developing and testing the RICE components Reports, Interfaces, Conversions, Extensions as per Oracle Standards.
• Possess good project management skills and also have lead in many projects.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also Testing documents throughout multiple Projects.
• Knowledge and Experience of TCA Trading Community Architecture .
• Expertise in developing custom reports in XML Publisher.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions
• Onsite coordination experience and work with the offshore team to knowledge transfer and development support.
• Excellent technical background for the accurate evaluation of customization efforts. Strong business, analytical and technical problem solving skills.
• Solid management skills, capable of leading and motivating individuals
• Self-motivated with the ability to effectively manage time and multiple projects.

Technical Skills:

Work Experience:

Confidential

Title: Oracle Applications Forms and Reports Consultant

Responsibilities:

• Involved in analysis, data modeling/design, development, testing, documenting of the above mentioned modules through Oracle EBS R12. Developed interfaces, batch processes, forms, and reports. Wrote SQL Loader control files to load data into the interface tables. Developed interface programs both inbound and outbound . Designed and developed custom forms and reports using Developer10g Oracle Forms10g / Reports10g tool sets. Worked on XML Publisher reports using RDF and Data Template and integrated it with Oracle Applications R12. Registered custom forms / functions, created menus, and registered reports in the application.
• Key user Training for the landed Costing custom Module and Integration with Oracle Purchase OP , Inventory, Order Management OM and Account payable AP .
• Developed RMA tracking reports using Oracle BI publisher and Oracle Discoverer 10g.
• Involved in the Order management -Landed Costing Custom module-Inventory-Account Payable and Purchase-Landed Costing Custom Module-inventory-Account Payable.
• This project was essentially an Upgrade Project and developed the below Custom reports using Reports 10g as per the client requirements in OM module
• Analyzed the various reports that require customization in OM module.
• Worked on obtaining solutions regarding delete reservations in Oracle Order Management OM
• Analysis and design of Application Security Documents, Multi Org Structure, Multiple reporting currencies and Financial Statement Generator reports.
• Import Work Orders from various legacy systems to Oracle Enterprise Asset Management and Oracle Order Management OM system.
• Worked extensively on Customer Conversion using interface tables to import customer data from Legacy AS/400 system. Was involved in data mapping, and interaction with functional consultant and business users.
• Developed a custom item interface program for loading legacy items information into Inventory Item Interface tables, by validating items according to their predefined item categories and category sets.
• Worked on Discoverer reports in the project phases.
• Extending Oracle receivables invoice entry, receipt entry forms using custom.pll
• Extract program for Open orders information Requisitions, Purchase orders, Internal Sales orders, Move orders information which are not materialized and corresponding stock amounts program, which shows the costing information for those open orders in Purchasing PO and Order Management OM .
• Designed and developed reports using combination of Report 6i and XML publisher for modules like Purchasing and Order management.
• Involved in Workflow customization for approval hierarchy level in Purchasing.
• Created several Requests and Request Set to attach the PL/SQL procedures, SQL Loader routine and Reports with Application.
• Took part in interactions with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
• Support and administer core manufacturing applications inside the Oracle E-Business Suite such as Work in Process, Bills of Material, Product Configuration and Shop Floor Management.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 10g and XML Publisher.
• Involved in implementation Sub Ledger Accounting for Primary Ledger and reporting secondary ledger.
• Experience with implementation and support of Oracle 11i R12 applications including Oracle Applications Framework, SQL, PL/SQL, Oracle workflow, Form personalization, Oracle Alerts, OBIEE, XML Publisher, and Forms.
• Suggest implementation practices..
• Customized the Print Purchase Order Report based upon user requirements
• Customized the following workflows: PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow, PO Account Generator Workflow
• Worked closely with the team responsible for Setups and Customization of self-service modules like iProcurements, iExpenses, iPayment, iReceivables, Modified XSL, JSP, XML files for additional functionality and GUI enhancement.
• Updated MD50, MD70 and MD120 documents.
• Environment: Oracle Applications R12.1.3, AR, AP, GL, PO, FA, iProcurement , Solaris, Oracle 10g, Forms 10g, Reports 10g, Discoverer 10g, Apex 4.2.0, PL/SQL, SQL Loader, Toad, Workflow, JDeveloper.

Confidential

Title: Oracle Applications Forms and Reports Consultant

Responsibilities:

• Involved writing complex SQL, Stored Procedures, Triggers and monitoring performance to ensure efficient data retrieval and generate forms and reports.
• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• Develop AP/AR/GL/PO reports using discoverer which include the following
• PO requisition reports,
• AR sales profit report with cost of goods,
• GL Summary Report.
• Worked with form personalization for customizing Oracle forms.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM.
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator FSG .
• Developed AP Invoice Conversion and vendors conversion programs.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Developing Data Entry screens using Oracle Forms10g.
• Customized several Oracle Forms using Oracle Forms10g.
• Developing PL/SQL code to obtain the required functionality.
• Changed the existing forms and reports of customized Accounts Receivables.
• Troubleshooting of the Order Management OM and Inventory INV modules within Oracle Applications.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Worked on complete Software development Lifecycle SDLC, from gathering requirements to deployment .
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Environment: Oracle Applications 11i, GL, AR, AP, PO, Reports 10g, PL/SQL, SQL Loader, SQL Plus, TOAD, Discoverer, UNIX, JSP, HTMLShell scripts

Confidential

Title: Oracle Applications Forms and Reports Consultant

Description:

Confidential has a full suit implementation of Oracle EBS to support its Supply Chain Management and Financials operations. The main objective of the project is to customize seeded functionality and integrate Oracle EBS with other custom applications.

Responsibilities:

• Participated in requirements gathering sessions with business users.
• Designed and implemented complete Return Material Authorization solution for Canon Business Solutions using Oracle Workflow builder and PL/SQL.
• Automated order import process from legacy systems into Oracle EBS using custom PLS/SQL interfaces, SQL Loader and UNIX.
• Designed and developed data conversion programs using PL/SQL, Oracle EBS standard API's to load data from legacy applications into Oracle EBS base tables.
• Developed several concurrent programs using PL/SQL, Packages, Global Temporary tables that run in the background to populate RMA orders in to reporting base tables.
• Created several database objects like packages, tables, indexes, triggers, custom data types and views to implement complex business processes.
• Developed Custom Oracle PL/SQL debugging module to streamline the error handling and debug mechanism of the system.
• Developed custom alerts using Oracle triggers and Java Mail API to send automatic emails for certain key business events in the system.
• Developed several SQL LOADER control files to load data from data files into staging tables to be used by interface programs and data conversion programs.
• Involved in code refactoring by moving the PL/SQL code from triggers to packages.
• Involved in performance tuning the application using indexes, global temporary tables, Tkprof, Explain Plan and partition pruning.
• Customized several Oracle Forms using Oracle Forms10g.
• Developed RMA tracking reports using Oracle BI publisher and Oracle Discoverer 10g.
• Environment: Oracle 11i, Oracle Forms 10g , Reports 10g, Discoverer 10g, Oracle 11g, Oracle Workflow Builder, PL/SQL, XML Publisher, PL/SQL Developer, UNIX.

Title: Oracle Applications Forms and Reports Consultant

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Responsible for Analysing requirements, designing, maintaining and updating data models
• Analyse the current data management procedures in practice and suggest ways for automating the process or improving the existing system.
• Developed stored procedures to pull the data from the distributed systems.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Developed and implemented complex data models and logical database designs.
• Involved in unit testing and integrated testing.
• Developed Forms 10g and reports.
• Extensively worked on forms production support.
• Extensively used SQL Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
• Defined database requirements and designed data model.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Schedule Backup and recovery from database.
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
• Involved in importing the production data to work environment through TOAD.
• Involved in handling the changes in compiling scripts according to the database changes.
• Environment: Oracle 8i/9i/10g/11g, Oracle Forms 6i,9i, Reports6i,9i, UNIX Shell Scripts, PL/SQL, Toad, PL/SQL Developer, SQL Optimizer, Putty.

Confidential

Title: Oracle Applications Consultant

Responsibilities:

• Worked actively with the Reports Development Team in creation of specific customized reports according to user needs.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Was primarily involved in the design and development of certain reports like Income Statement with Variance, AI Annual Income Budget Statement, Cumulative Balance Sheet CBS and Budget/Actual Report, CBS and Income Statement consolidated report.
• Involved in the requirement gathering, analysis and design of the interfaces and reports.
• Creation of new customized reports in XML/BI publisher and upgraded Standard 6i reports to XML/BI publisher reports.
• Developed various Form letter reports and Mailing list reports using Reports 6i.
• Customized Supplier Paid Invoice History Report, Supplier Merge Report, Supplier Audit Report, Chart of Account Detail Listing Report and Supplier Payment History Report in Account Payables using Oracle Reports 6i.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.
• Created required shell scripts for secured FTP with error handling capability.
• Developed design and implementation documents such as MD050, MD070, MD120, Unit Test scripts and user-documentation.
• Environment:UNIX Shell Scripting, Developer Forms reports 6i, XML publisher , PL/SQL, SQL Loader, TOAD, Oracle Apps OM, WSH, INV, BOM, WIP, PO, AR, GL

Confidential

Title: PL/SQL Developer

Responsibilities:

• Extensively involved in coding of the Business Rules through PL/SQL using the Functions,Cursors, Triggers, Stored Procedure, and Packages in the server side.
• Participated actively in the technical and functional discussions.
• Extensively involved in designing the project and coordinating a highly professional team.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Designed ER diagrams and normalization of database.
• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Implemented Order Management Workflow extension for RMA Finance approvals for various financial validations which Carnival requires during Order to Cash process.
• Seeded OM Workflows are copied and customized.
• Designing and developing the following custom forms. By Show, Daily statistics By Hour, Item History Performance, Total Sales by Sales Channel, Select a Show, Maintaining Shows, Roles, Show Templates, Objects, Show types, Show Formats, Airing Show, Show Scheduling Workbench, Selection Criteria, Show Run Down, Call Center, Traffic Workbench, and Revise Schedule Goals.
• Registering the above developed forms into Oracle Applications 11i.
• Developed scripts to create tables, views, procedures and functions and executed them using SQL Plus.
• Seeded OM workflows were copied and customized accordingly.
• Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis,
• Design, Development, System Testing and Production support
• RMA Approval workflow notification for Sales Order will be triggered at the launch of Sales Order Book event.
• Migrated the data from external files into Database tables using SQL Loader.
• Extensively involved in performance and tuning of all SQL and PL/SQL code.
• Used Built-in Packages provided by oracle for debugging.
• Reviewing / Testing Procedures Functions developed by the team members.
• Wrote triggers to handle user-generated events.
• Developed UNIX shell scripts to schedule the cron jobs.
• Used Developer 2000 to generate reports of statements for users.
• Environment: Developer 2000, SQL, PL/SQL, Oracle 9i, UNIX, Windows 2000