Oracle Applications Consultant Resume
OBJECTIVE
To secure a challenging, growth oriented position in a progressive organization, where I could contribute to their success and work in the field of Oracle and APEX technologies.
SUMMARY
- Experience in developing Oracle APEX applications.
- Working knowledge of Visual Basic 6.0 with SQL SERVER as the back-end
- Expertise in Technical aspects of Oracle Applications 11i Financialswith over Nine years of IT Industry experience which includes over four years of customization and development experience in Oracle Applications 11i
- Highly experienced in Software Design, Analysis, Coding, Development and Testing with specialization in ORACLE based Client-Server Computing, Database Administration, Implementation, Maintenance and Quality Assurance
- Experience in Oracle Applications E-Business Suite Modules: Oracle Financials (GL - General Ledger, AP - Account Payables, AR - Account Receivables, System Administration , AOL - Application Object Library)
- Excellent technical expertise in Reports, Interfaces, Conversions and Extensions; Implementation and Production Support in Oracle Financials Modules
- Profound Experience in development of Concurrent Programs, Customization of Forms and Reports, defining profile values in AOL and System Administration
- Experience in registering Forms, reports, concurrent programs, value sets, flex fields in Oracle Application using AOL
- Extensively worked on Stored Procedures, Functions, Packages, Database triggers and Performance Tuning and Optimization
- Extensive experience in each part of Software Development Life Cycle (SDLC) including analysis, specification, development, maintenance, testing and documentation using Applications Implementation Methodology (AIM)
- Good experience in using Automated Testing Tools such as Win Runner, developing test scripts using Test Director to manage the entire testing process
- Interaction with clients to ascertain the requirements to carryout Analysis & Design and meet user requirements
- Highly Solutions-minded, versatile, time-sensitive with excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels
- Excellent written and verbal communication skills
TECHNICAL EXPERTISE
Office Applications: MS-Office
Front End Tools: Visual Basic 6.0, Forms 6i/9i
Utilities: SQL*Loader, SQL Developer, TOAD
Languages:SQL, PL/SQL
Databases: Oracle 10g/9i/8i, SQL SERVER 2000/2005, Ms-Access
Web Tools: VB.NET, HTML, DHTML and MS-Front page
Application Servers: IIS 6.0
BI Tools: Business Objects XI R3/R2/R1, Designer, Infoview, Web-Intelligence
Reporting Tools: Reports 6i/8i, Discoverer 3i/4i, APEX 3.0/3.1/3.2 , BI Publisher
Operating Systems: Windows XP/NT/2000, UNIX
Testing Tools Win Runner, Test Director, Load Runner
Oracle Applications 11i E-Business Suite: Versions: 11.5.10/ 11.5.9/ 11.5.8
Modules: General Ledger, Account Payables, Account Receivables, System Administration, AOL, Alerts
PROFESSIONAL EXPERIENCE
Confidential, Dallas TX Mar 2008 - Till Date
Systems Programmer
Avail is now a Confidential. FlexMedical provides world-class design, manufacturing, and logistics solutions to medical device and equipment companies. It provides the full range of services necessary for the design and development of sterile, finished medical devices. As a large, recognized leader in the EMS industry, Flextronics Medical provides a broad set of capabilities for medical customers in the invitro-diagnostic, drug delivery, and lab equipment industries.
Responsibilities:
- Developed about nearly 55 reports using Oracle APEX for applications involving General Ledger, Accounts Receivables and Accounts Payables under Finance and Work Orders, Inventory, Issues to WO, Cycle Counts By Branch-plant, planning etc under Manufacturing and Production streams.
- Worked extensively on tuning the SQL statements to handle performance issues.
- Involved in the Tuning of APEX reports (includes PL/SQL, SQL scripts) using Explain Plan & TKPROF.
- Worked on Agile Report Writer which consists of nearly 250 reports, and also includes creation of several views and to check for performance issues and analyzing of tables required to get accurate statistics. Basically all the reports are created using APEX.
- Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting, conversion.
- Used Raise_APPLICATION_ERROR, PRAGMA EXCEPTION_INIT to capture error messages.
- Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
- Developed, modified SQL scripts, PL/SQL scripts, Views, Stored Procedures & Functions as per the Business Requirements.
- Webi Reports were created and deployed through Info View. Used aggregate awareness in universes and Involved in full life cycle of Business Objects reporting Application.
- Developed a complete system for Medtronic, Kinetic Concepts Inc and Boston Scientific Corp using VB 6.0, this system provides the functionality of scanning various Models of finished goods.
- Worked on Device History Records (DHR) , using VBA this application provides the functionality of creating box labels for archiving DHR records and also to develop a solution to accommodate database performance issues and modify searching capabilities
Environment: PL/SQL, SQL*Loader, Discoverer, Oracle 10g, APEX, Ms-Office, Business Objects, WEBI, VB 6.0, VBA, SQL Server
Confidential San Jose CA Aug 2007 – Feb 2008
Programmer/Analyst
Confidential is a company that provides medical equipment to the hospice care industry. They work closely with the hospice care providers to rent, deliver and setup medical equipment for hospice patients. We developed the architectural design for their new product tracking and order processing system that would tie into each driver’s mobile phone. The project is to be based on ASP.Net and Oracle.
Responsibilities:
- Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle.
- Create and maintain tables, views, procedures, functions, and packages, and update, delete, and insert statements and compile them.
- Involved in analysis, design and coding of data extraction, Transformation package in PL/SQL for loading data from online websites
- Analyzed the existing code and used SQL Trace and Explain Plan to fine-tune the code
- Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
- Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
- Designed, developed and enhanced custom Oracle Reports according to the functional specification.
- Constant monitoring and performance tuning of Oracle database, checking the most expensive queries.
- Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
- Detected and corrected bugs during system integration and user acceptance testing.
- Designed and developed forms and reports for easy data updating, that increased data entry efficiency over the existing system
- Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
Environment: PL/SQL, ASP.Net, Oracle 10g, SQL*Loader, APEX
Confidential, Naperville, IL Dec 2006 – Jul 2007
Oracle Applications Consultant
This Project involves implementing Oracle Applications 11i. As a part of development team, was responsible for Technical Design and Development activities involving development of Interfaces, Conversions, Reports and Packages.
Responsibilities:
- Wrote SQL*Loader scripts to migrate the data from the text files and populated the intermediate tables like GL_INTERFACE and GL_BUDGET_INTERFACE.
- Designed and developed interface to import Purchase Orders from legacy system to Oracle Purchasing.
- Developed custom alerts as per business requirements.
- Customized Payables Account Analysis Report in Account Payables (AP).
- Involved in the Tuning of 11i Applications (includes PL/SQL, SQL scripts) using Explain Plan & TKPROF.
Customized Expected Receipts Report, Contract Status Report andPurchase Order Detail Report in PO module.
- Worked on Order Import Interface
- Used FTP and UTL_FILE package extensively
- Developed, modified SQL scripts, PL/SQL scripts, Views, Stored Procedures & Functions as per the Business Requirements.
- Registered the SQL PLUS reports as the concurrent programs and being executed from the Oracle Financials environment.
- Developed reports using Discoverer for applications involving General Ledger, Accounts Receivables and Accounts Payables.
- Worked with Discoverer to aid end-users to generate ad-hoc reports.
- Customized Seeded Application Forms and Reports to meet the specific business needs.
- Registration of Reports and Concurrent Programs.
- Prepared the MD 070 documents for Development work done
Development Environment: Oracle Applications 11.5.8 – GL, AP, PO, FA, Alerts, Oracle 9i, Forms6i, Reports6i, SQL Navigator, Discoverer, PL/SQL, SQL*Loader, UNIX.
Confidential, Princeton, NJ May 2005 – Nov 2006
Oracle Applications Consultant
This Project involves implementing Oracle Applications 11i (11.5.9). Key tasks are Data mapping, Data conversions from the legacy systems, developing Reports as per the needs and performance tuning of the existing custom reports.
Responsibilities:
- Worked on Journal Interfaces Program in GL (General Ledger), reviewed Journal Import Execution, corrected Journal Import Data and initiated posting
- Developed Customer Interface Program to transfer the customer information from the Legacy System to Oracle Receivables.
- Worked on GL Daily Rates Interface Program
- Worked on the Invoice Import Program to load Invoice and Invoice Lines into the tables in AP (Payables)
- Developed Conversion Program to import Requisitions from flat files to Oracle Purchasing
- Involved in customization of standard reports such as Invoice Printing Report and List of Top Ten Customers Report in Oracle Receivables.
- Customized Fixed Assets by Category Report in FA module.
- Used CUSTOM.PLL to modify the functionality provided by standard forms according to client requirements and created custom forms.
- Customized the reports Purchase Order Report (by buyer), Purchase Order Report (by vendor) to show Purchase orders detailed by buyer or vendor.
- Writing test cases for functional testing.
- Creating test data based on the test cases and executing the test cases.
- Using SQL for checking the output of various reports.
- Involved in Application Performance Tuning
- Customized AP Positive Pay file seeded report in a specific format
- Customized Invoice on hold report, Vendor Payments and Analysis report in Oracle Payables.
- Involved in Production Support, problem resolutions and bug fixing. Actively involved in raising issues and coordinating between the Management & Users.
- Prepared the MD 070 documents for Development work done.
- Preparation of Technical specifications and User Reference Documents.
Development Environment: Oracle Applications 11.5.8 – GL, AR, AP, FA, PO, Forms 6i, Reports 6i, Oracle 9i, TOAD, PL/SQL, SQL*Loader.
Confidential, Stamford, CT Oct 2004 – Apr 2005
Oracle Developer
Responsibilities:
- Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
- Involved in writing PL/SQL Packages, Functions and Stored Procedures and DB Triggers.
- Developed database objects like tables, views, indexes, and sequences.
- Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting, conversion.
- Used Raise_APPLICATION_ERROR, PRAGMA EXCEPTION_INIT to capture error messages.
- Used PL/SQL Built-in Packages DBMS_STANDARD, DBMS_OUTPUT.
- Analyzed the existing code and used SQL Trace and Explain Plan to fine-tune the code
- Develop and maintain scripts for monitoring, troubleshooting and administration of the databases.
- Worked on analysis, design, writing technical specifications, development, and complete documentation of work, unit testing and going live.
- Provide timely Production Support by quickly analyzing the root cause and by providing alternatives to resolve issues.
- Customized the Task status form as per the requirement and made changes in the LOV.
- Involved in writing test plan, writing test specs and testing using Win Runner tool
Environment: PL/SQL, SQL*Loader, Oracle 9i/8i, Forms 6i, Reports 6i, UNIX, Win Runner, Load Runner
Education:
Post Graduation Diploma in Computer Applications PGDCA
Bachelor of Commerce
Certifications:
Microsoft Certified Professional (MCP) in Visual Basic 5.0 from Microsoft Corporation