Oracle Skills:

• Over 13 years of experience in EBS as Oracle Apps Technical in Analysis, Design, Data Modeling Logical and Physical , Implementation of Business Applications using the Oracle Relational Database Management System.
• Experience with the Software Development Life Cycle SDLC process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production install and support.
• Extensive experience in Design, Development, Customization and Implementation of business applications using Oracle Applications, SQL, PL/SQL, Oracle 10g/9i/8i/7.x, Developer 2000/6i.
• Proficient working in modules which include Accounts Receivables, Accounts Payables, General Ledger, Fixed Assets,Project Accounting , Inventory, Invoice, Cash, Purchasing and HRMS.
• Strong conceptual knowledge on business processes in Inbound and Outbound Logistics.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections nested tables and arrays , records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Worked out with EBS RICE components involved in creation of Reports that are not available as standard reports, creation of the Interfaces to external systems, creation of Conversion programs to transfer data from a legacy system to the new system and Extensions to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system.
• Experience in System Administration responsibilities such as registration of concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields in Oracle Applications.
• Developed SQL Program to load data from Excel files, flat files into temporary table using UTL FILE utilities and SQL loader.
• Experience in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications using Oracle Developer Suite 6i Forms, Reports and other front-end tools.
• Experience in Performance Tuning Optimization of SQL statements.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Ability to work individually as well as in a team with excellent problem solving skills, troubleshooting capabilities, learn new tools and concepts.
• Involved in preparing the functional specification, technical documentation, schema documents, test cases, flow charts, production support and user support documents using AIM Methodologies.

Technical Skills

EBS: Oracle Applications R12, 11i, 10.7 Multi Org. EBS Modules: - Accounts Receivables, Accounts Payables, General Ledger, Inventory, Bill Of Materials, Oracle Purchasing,Customer, Hierarchy, Statements, Order Entry,Invoice,Project Accounting, Project Costing,Project Billing,Cash, Fixed Assets, HRMS/Payroll

• Database Modeling, Tuning, Customization, Configuration
• Pro C, C, SQL Load, SQL Plus, Discoverer.
• PL/SQL Packages, Procedures, Functions, Triggers: Coding Troubles shooting.
• Forms and Reports: Coding and Debugging
• SQL Tuning, Indexing, Clustering
• SQL Loader, Export and Import
• Kintana, Starteam, Power Point
• Designer 2000
• HTML
• Unix, Shell Scripts
• MS Project, PMP Training
• Hardware: IBM, SUN SPARC/450 5500, HP-9000/T500, NCR, WIPRO Super-mini, Wintel
• OS: SOLARIS, HP-UX, SCO UNIX, Windows NT/2000

Database: ORACLE 6.0-11g, Oracle Application 11.i, PL/SQL, Developer 2000, Designer 2000, SQL Plus, Net8, Pro C

Tools: C, Shell scripts, HTML, Lotus Notes, MS Office

• Involved in reqirements gathering and resolution of functional issues related to EBS modules AR,AP,PO,PA,Inventory and GL during implementation of modules.
• Worked on solution design and setup of EBS modules AR,AP,PO,PA,Inventory and GL modules as per the client requirements and suggested business process changes.
• Implemented EBS modules AR,AP,PO,PA,Inventory and GL modules.
• Created interfaces, forms , reports and pl/sql packages, procedures and database triggers and
• Created functional design documents MD050 for conversion, forms and reports to address business requirements.
• Created Technical design document MD070 , BR100 setups to address the business requirements.
• Registered concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields
• Prepared training documents and assisted in user training.
• Assisted in period closing and also daily production support by resolving system user issues. Following up with Oracle Support on service requests.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Worked on 24 7 production support.

Role: Business Solution Specialist working on EBS R12 12.0.3 .

• Involved in resolution of functional issues related to AR and GL during implementation of modules.
• Requirements gathering of Invoice, Cash, Customer, Hierarchy, Collections and Statements for two different implementations.
• and Statements as per the client requirements and suggested business process changes.
• Worked on solution design and setup of Invoice, Cash, Customer, Hierarchy, Collections,GL
• Upgraded Oracle AR from 11i to R12.
• Implemented Accounts Receivables for US and Canada.
• Created interfaces, forms , reports and pl/sql packages, procedures and database triggers and
• Worked on data conversion from Mainframes into Oracle.
• Created functional design documents MD050 for conversion, forms and reports to address business requirements.
• Created Technical design document MD070 , BR100 setups to address the business requirements.
• Registered concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields
• Prepared training documents and assisted in user training in AR.
• Assisted in period closing and also daily production support by resolving system user issues. Following up with Oracle Support on service requests.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Worked on 24 7 production support.

Role: Senior Consultant working with Customer Support on EBS 11.5.10 on HRMS.

• Provided user support to resolve various issues after implementation.
• Accounts Receivable, Purchasing, General Ledger , Grants Management and Project Accounting.
• Provided user support to resolve various issues after implementation.

Role: Senior Consultant working on EBS Conversion from 11.0.3 to 11.5.10.2

• Provided user support to resolve various issues after implementation.
• Converted all Custom Reports, Custom SQL Scripts and Custom Packages of the following modules Accounts Payables, Accounts Receivables, Purchasing, General Ledger Grants Management, Project Accounting, Labor Distribution, Internet Expenses and Purchasing from 11.0.3 to 11.5.10.2.
• Upgrade of Oracle AR,AP,PO,GL,GM,LD,IE,PA and PO from 11.0.3 to 11.5.10.2
• Converted all custom reports, Custom PL/SQL scripts and Custom Packages, forms , reports, pl/sql packages, procedures and database triggers from 11.0.3 to 11.5.10.2
• Prepared training documents and assisted in user training in AR.
• Assisted in period closing and also daily production support by resolving system user issues. Following up with Oracle Support on service requests.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Worked on 24 7 production support.

Role: System Analyst working on EBS 11.0.3.

• Implemented Accounts Payables, Project Accounting and Purchasing for US and UK.
• Provided user support to resolve various issues after implementation.
• Providing operational management overview and driving productivity improvement initiatives.
• Successful in growing client relationships across North America and UK.
• Expertise in full project lifecycle, MD050 Requirements , MD070 Design , BR 100 Configuration Setup , Software Development and testing.
• Development of Processes, Reports, Implementation and Support of Oracle Purchasing, Accounts Payables and Project Accounting for BP US, BP UK.
• Created interfaces, forms , reports and pl/sql packages, procedures and database triggers and
• Worked on solution design and setup of as per client requirements and suggested business process changes.
• Involved in Requirements Gathering and resolution of functional issues related to AP,PO and PA during implementation of modules.
• Created functional design documents MD050 for conversion, forms and reports to address business requirements.
• Created Technical design document MD070 , BR100 setups to address the business requirements.
• Registered concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields
• Prepared training documents and assisted in user training.
• Assisted in period closing and also daily production support by resolving system user issues. Following up with Oracle Support on service requests.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Worked on 24 7 production support.

Role: Senior Consultant working on EBS 10.7,11.0.3,11i.

• Implemented AR,AP,PO and GL modules.
• Provided user support to resolve various issues after implementation.
• Providing operational management overview and driving productivity improvement initiatives.
• Successful in growing client relationships across North America and UK.
• AP, PO, GL, AR Modules: Expertise in full project lifecycle, MD050 Requirements , MD070 Design , BR 100 Configuration Setup , Software Development and testing.
• Created interfaces, forms , reports and pl/sql packages, procedures and database triggers and
• Worked on solution design and setup of AR,AP,PO and GL modules as per the client requirements and suggested business process changes.
• Involved in reuirements gathering and resolution of functional issues related to AR,AP,PO and GL during implementation of modules.
• Created functional design documents MD050 for conversion, forms and reports to address business requirements.
• Created Technical design document MD070 , BR100 setups to address the business requirements.
• Registered concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields
• Prepared training documents and assisted in user training.
• Assisted in period closing and also daily production support by resolving system user issues. Following up with Oracle Support on service requests.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Conversion of Forms and Reports from 2.5 to 6i.
• Worked on 24 7 production support.

Role: Consultant Programmer working on Developer

Confidential is created in order to perform the calculation and reporting of direct levies and fees against parcels in Sacramento and other counties with joint Powers Agency commitments and to assist managers of these processes in comparing alternatives in creating new financing solutions. Management of these processes includes the processing of parcel reconfiguration and posting of demographic changes ,processing reapportionment of assessments, calculating preliminary and final annual direct levies, calculating development fees, modeling new direct levy or fee district information monitoring delinquencies and processing delinquent payments ,calculating payoffs or pre-payments ,processing refunds and preparing numerous listings and statistical reports.

Responsibilities:

• Used Programming tools Oracle 8.x, Developer 2000
• Developed forms and reports for various modules using Forms 5.0 and Reports 3.0
• Created libraries , packages ,procedures , functions and database triggers for the system.
• Maintained the system fixing bugs in it.

Role: Consultant Programmer working on Developer 2000 , Designer 2000 from June 1999 to March 2000

• Confidential deals with Marshal department's daily court related activities. This product facilitates the regional county marshal offices to interface with the application for Initial Case Entry, Return service ticket, both singles and writ, Update/Display a Case, Exemption Claims etc.
• Used Programming tools Oracle 8.x, Developer 2000, Designer 2000
• Prepared the specification design for the forms and reports.
• Developed forms and reports for various modules using Forms 5.0 and Reports 3.0 , designer 2000.
• Created libraries , packages ,procedures , functions and database triggers for the system using PL/SQL.
• Created templates to have standardization across modules