We provide IT Staff Augmentation Services!

Oracle Resume

Atlanta, GA

SUMMARY

  • Over seven years of IT experience of ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing and Supporting Oracle Applications 11.0.3 and 11i (AR, AP, GL, PO, INV, OM, CRM, SCM), AOL of Oracle E-business Suite. These include Analysis, Design, Development and Implementation of different projects for applications based on Relational DBMS and in the field of Oracle e-business Suite.
  • Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer.
  • Strong understanding of business processes with good domain knowledge in Manufacturing and Supply Chain Management.
  • Oracle Certified Associate (OCA)

FUNCTIONAL EXPERTISE

  • Good insight into the functionality of Oracle General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Purchase Order (PO), Order Management (OM), Inventory (INV), BOM, WIP and Oracle Application Object Library (AOL)
  • Good functional expertise on Open Interfaces (inbound and outbound interfaces) in Oracle Financials.
  • Exposure to Accounting Business Practices used in Oracle GL
  • Very good practice and experience in setting up and customizing Accounting Flexfield of General Ledger based on the Organization’s business setup.
  • Adept in planning Security rules and Cross validations for GL, AR, AP Flexfields.
  • Experience in working with Enter Journals, Post Journals and Posting Programs, good understanding of Journal Entry Headers and Lines model.
  • Insight into AR Transactions and Receipts process flows and setups
  • Proficient with the architecture of Global Descriptive Flexfields and various Common Country Features.

TECHNICAL COMPETENCE

  • Good Expertise in developing applications using SQL, PL/SQL, Database Triggers, Stored Procedures, Oracle 11i/9i/8i and Developer 10g/6i (Forms 10g/6i, Reports 10g/6i).
  • Good Expertise in PL/SQL
  • Good Expertise in Query and Performance tuning in Oracle.
  • Hands-on experience in MS Access to Oracle 10g database conversion.
  • Hands-on experience in analyzing the Oracle SQL Raw Trace and TKPROF trace files in working query and database performance issues.
  • Hands on experience implementing and supporting Procure-to-Pay and Order-to-cash and plan-to -build processes in Oracle 11i/R12 applications.
  • Hands on experience in designing and implementing scalable OLTP and DSS database systems.
  • Experience with RAC Software Storage Principles & Database Storage Principles along with RAC and Instance/Crash Recovery, Database Storage Consolidation.
  • Hands on experience with Oracle RAC 10g Installation and RAC performance tuning.
  • Experience working with ERwin data modeling tool.
  • Skilled and experienced in UNIX Shell scripting and worked extensively on Unix/Solaris/Linux platforms.
  • Extensive experience in conversion of legacy data into Oracle Applications using SQL Loader and PL/SQL.
  • Good experience in working with Oracle Discoverer.
  • Strong expertise on Workflow customizations & Form personalization to meet functional/business requirements.
  • Proficiency in Oracle Application Implementation Methodology and Software Development Life Cycle (SDLC).
  • Worked Extensively in Conversions and Interfaces in most of the Financial Modules. Extensive hands on experience using most of the API’s.
  • Highly skilled in creating new XML Reports using XML Publisher and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
  • Experience with design and implementing oracle security with Oracle Internet Directory for data storage and synchronization services.
  • In-depth Experience in using Oracle Application Object Library (AOL) features including implementation of Flex fields (Like Implementing Cross Validation Rules, Implementation flex fields in reports, Security rules), creating and scheduling of Concurrent programs etc.
  • Highly skilled in the use and concepts of Global Descriptive Flexfields that are used to seed country specific features for Financials Globalization
  • Extensive experience in design and development of applications under UNIX and Linux environments.
  • Good insight into the process flows and data model of Oracle General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Purchasing (PO), Fixed Assets (FA), Inventory (INV), Service Contracts , BOM, WIP, Install Base modules and CRM.
  • Experience in creating and integrating custom built Forms with Oracle Applications and in using CUSTOM.pll library.
  • Keen focus on performance tuning, testing, and quality assurance.
  • Experience in supporting Production Systems on 24x7 cycle following Six Sigma standards.
  • Extensively used GE Support Central & HP ServiceDesk for issue tracking & reporting.
  • Skilled in preparing and delivering presentations to both technical and executive positions.
  • Good understanding of system development process, from initial planning through deployment.

TECHNICAL SKILLS

ERP

Oracle Financials Release 11i/R12, Financials (AR, AP,GL,FA) ,Manufacturing (PO, OM, INV) and CRM

Others

Oracle Application Object Library (AOL)

Databases

Oracle9i/10g, SQL Server (v7.0)

Development Tools

Oracle Developer 6i, Forms 6i, Reports 6i, Workflow Builder, Oracle Discoverer, XML Publisher

Programming Languages

C, C++, SQL, PL/SQL

Operating Systems

Windows XP/2000/NT/98/95, UNIX, Linux, Solaris.

Case Tools

Oracle Designer 2000

Version Control Tool

CVS, RCS

Tools

TOAD, SQL*Plus, SQL-Navigator, Informatica, ERwin data modeler and SQL*Loader.

CERTIFICATIONS

Oracle Certified Associate (OCA)

PROFESSIONAL EXPERIENCE

Confidential, 10/08 to 12/09
Oracle Application Developer

Role & Responsibilities:

  • Worked on Oracle Applications Release 11.5.10/ R12. Responsible for the technical design, program development, unit testing and migration of AP Invoice Interface.
  • Involved in design, development and testing of new and existing Interfaces using PL/SQL to interface non-oracle and Oracle systems to Oracle applications Modules AR, GL, AP , FA, OM, SCM, INV, Service Contracts , Install Base modules and PO. All the interfaces were registered and run through the concurrent manager.
  • Customized Reports and Forms to meet user requirements mainly in financial modules (AP, GL, and AR).
  • Hands on experience on Oracle EBS 11i/R12 P2P (iProcurement, AP, PO, iSupplier) modules.
  • Hands on experience on Oracle EBS 11i/R12 SCM, BOM, WIP modules.
  • Involved in creating new XML Reports using XML Publisher and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
  • Experience on Oracle Fixed Assets (FA) module - General Ledger entry processing, Journal entries, asset set up , year end process and global updates.
  • Hands on experience withOracle RAC 10g Installation, RAC performance tuning and Connection Load balancing in RAC .
  • Experience working with ERwin data modeling tool.
  • Used Oracle Directory Service Manager to integrate OID with Oracle Enterprise Manager to centrally manage and monitor all services, including Oracle Fusion Middleware, Oracle Databases, and Oracle Applications.
  • Experience with testing and debugging Oracle Internals, Architecture and Performance issues.
  • Install, create and manage several development, test and production Oracle 9i database.
  • Setup client/server connections for developers, create databases, table spaces for different application schemas; enroll users, and setup auditing.
  • Write scripts to create tables, indexes, views, aliases and synonyms to meet developer requests.
  • Write extensive PL/SQL procedures, functions, packages, cursors.
  • Created validation procedures to execute along with customer interface and vendor programs to support the interface requirements
  • Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
  • Created triggers for transaction adjustment, Auto Adjustment, defined Vendors, Invoices, Tracking of payments, Prepayments.
  • Integrated Legacy purchase order Information with Oracle Payables Interface.

Environment:
Oracle Applications 11.5.10/ R12 (GL, AP, AR, FA and PO), Service Contracts , Install Base modules Oracle Database 9i, Developer 6i – (Forms and Reports), SQL*Loader, Windows XP, UNIX

Confidential, Atlanta, GA 12/06 to 10/08
Project Oracle Application Developer

Role & Responsibilities:

  • Worked on various Financial and manufacturing modules (GL, AP, AR, PO, FA,OM, INV, SCM,CRM).
  • Configuration of General Ledger for multiple sets of books and integration with AP & AR.
  • Hands on experience on Oracle EBS R12 P2P (iProcurement, AP, PO, iSupplier) modules.
  • Hands on experience on Oracle EBS R12 SCM, BOM and WIP modules.
  • Performed data conversion from legacy system to oracle modules using SQL*Loader.
  • HRMS integration with other Oracle Applications, including Shared and Full installation considerations.
  • Implemented Oracle Demantra applications like demand management, sales & operations planning, and trade promotions management solutions.
  • Worked on integration interface, workflow, methods, series and system parameters of Demantra.
  • Provided Technical support activities resolving internal TARs and RFCs. Responsible for TAR creations & escalation process and resolving functional & technical issues by coordinating with oracle corp. support staff working remotely.
  • Provide data fixes to GE Energy wherever required.
  • Worked on hosted CRM using Oracle CCA (Contact Center Anywhere) product.
  • Worked on Oracle CRM modules (Oracle foundation, Contracts, Installed base)
  • Worked on code modifications and project enhancements based on client requests.
  • Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs.
  • Customized standard reports like open Sales order report and AR Customer Invoice Report.
  • Developed XML Reports using XML Publisher.
  • Involved in custom objects integration activity with Oracle Applications and interaction with other functional and technical teams.
  • Testing applications including unit testing and pre-integration testing.
  • Work on preparing documentation (Technical and functional) conferring to GE standards.

Environment:
Oracle Applications 11.5.10 /R12(GL, AP, AR, FA, OM, INV , SCM, CRM and PO), SQL*Loader, Oracle Database 9i, Developer 10g – (Forms and Reports), Discoverer 1og and Stored Procedures for business logic using PL/SQL on HP-Unix.

Confidential, Atlanta, GA 03/06 to 11/06
Oracle Application Developer

Role & Responsibilities:

  • Worked on various Financial and manufacturing modules (GL, AP, AR, PO, FA, OM, INV, BOM, WIP) and CRM.
  • Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
  • Configuration of General Ledger for multiple sets of books and integration with AP & AR.
  • Worked on hosted CRM using Oracle CCA (Contact Center Anywhere) product.
  • Worked on Oracle CRM modules (Oracle foundation, Contracts, Installed base)
  • Worked on code modifications and project enhancements based on client requests.
  • Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs.
  • Customized standard reports like open Sales order report and AR Invoice Report.
  • Developed XML Reports using XML Publisher.
  • Created PL/SQL packages to perform validations on the imported data from legacy system.
  • Worked in creating menus, functions, sub functions, defining responsibilities and Segregation of Duties.
  • Developed Concurrent Programs and Executables for the SQL*Loader, Package and Report and run them as a request set.
  • Provide data fixes to GE Energy wherever required.
  • Provided Technical support activities resolving internal SRs and RFCs. Responsible for TAR creations & escalation process and resolving functional & technical issues by coordinating with oracle corp. support staff working remotely.
  • Involved in custom objects integration activity with Oracle Applications and interaction with other functional and technical teams.
  • Testing applications including unit testing and pre-integration testing.
  • Work on preparing documentation conferring to GE standards.

Environment:
Oracle Applications 11.5.10 /R12(GL, AP, AR, FA, BOM, WIP, OM, INV, CRM and PO), SQL*Loader, Oracle Database 9i, Developer 10g – (Forms and Reports), Discoverer 1og and Stored Procedures for business logic using PL/SQL on HP-Unix.

Confidential, India 08/05 to 02/06
Oracle Application Developer

Role & Responsibilities:

  • Customized Reports and Forms to meet user requirements mainly in financial modules (AP, AR, and GL).
  • Developed SQL scripts to transfer data from the Legacy system into the staging tables.
  • Developed PL/SQL packages to validate and load the data into the Interface table.
  • Imported journals through Journal Import, which imported the data into the base tables.
  • Enabled Descriptive Flex fields on Invoice Distributions to capture additional information
  • Involved in SQL Tuning using the TKPROF Utility.
  • Write scripts to create tables, indexes, views, aliases and synonyms to meet developer requests
  • Write extensive PL/SQL procedures, functions, packages, cursors.
  • Worked on SQL query optimization.

Environment:
Oracle Applications 11.5.5, SQL, PL/SQL, Oracle 9i, Developer 6i – (Forms and Reports), TOAD and UNIX.

Confidential, India 01/05 to 07/05
Activation Project Software Engineer

Role & Responsibilities:

  • Worked on Real time product support project on features related to call processing, barring and unbarring calls, routing and charging on Siemens and Ericsson Switch.
  • Worked on AXE810 ERICSSON for WIRELESS SWITCH & SIEMENS EWSD Switch.
  • Worked on CDMA wireless. Subscriber complains regarding routing, charging, subscriber features related to wireless & wire line.
  • Activation of Wire line, City Mobile, CDMA Technologies.
  • Wrote various shell scripts for WLN/WLL switch and core-DECT.
  • Making of various CENTREX’S and HUNTING GROUPS on Siemens EWSD SWITCH. Designed and developed a report showing accounts receivable by region.

Environment:
AXE810 ERICSSON, SIEMENS EWSD Switch, UNIX, WINDOWS XP/2000

EDUCATION

  • Bachelors in Engineering (Computer Science Engineering)
  • Masters level courses in Computer Science

Hire Now