Oracle Project

Location:

Braddock, PA

Posted:

February 24, 2012

Contact this candidate

Resume:

Chandresh Shah

Citizenship Status: Green Card Holder

Summary:

Over fifteen years of IT experience in the area of system analysis, design, development, testing, implementation, Production Support of complex applications, database administration and performance tuning & optimizing using Oracle Applications and Oracle tool sets.

Looking for a Techno Functional, Team or Technical Lead position.

Over fifteen years of extensive knowledge and experience as a TECHNO FUNCTIONAL in Implementation, Extension, Customization, Interfaces, Conversions, Upgrade, Designing and Developing Extensions to Oracle Applications, Application Set up Activities and Production Support of AOL, GL, AP, AR, Project Accounting (PA), Fixed Assets, Manufacturing modules (like Purchasing, Inventory), Oracle Sales Compensation (OSC) modules of Oracle Applications (11i/10.x).

Experience creating the Oracle’s Application Implementation Methodology (AIM) using various MD50, MD70 document.

Providing production support to apps users for any technical or functional issues.

Solid Experience in Back-end development, support, Stored Packages, Procedure, Function, Database Triggers, Performance Tuning & Optimization and database objects / space management

Solid experience of migration of various components using change control software including TOAD STAT tool and Change Control processes established for SOX compliance.

Experience working in Sarbanes-Oxley controlled environment

Solid experience in different environments, including UNIX (Solaris, HP-UX, Linux, Sequent), Windows

EXPERIENCE:

Technical Lead, SDI, USA, 2009 to Current

Environment: Oracle Applications 11.5.10 and R12 (Project Accounting, General Ledger, Payable, Receivable, Purchasing, Trading Community Architecture TCA, Service Contract, Field Serivce, Application Object Library and Sys Administration) multi org/currency, Oracle RDBMS, PL/SQL, SQL, SQL*Loader, Oracle Reports, Discoverer, and shell script, TOAD

Role:

Leading a Oracle team for Global integration project between Oracle ERP and IBM Asset Management (Maximo) where multiple team involved. This global project is successfully implemented to various countries including North America and Europe.

I was involved starting from the requirement gathering for the Oracle / Maximo integration to Implementation. Designing Enterprise Application Integration (EAI) template, technical design template and document and reviewing and approving EAI, general CR and interface CR.

Leading and assigning the development tasks to the team member, Involved in System Integration Test (SIT), User Acceptance Test(UAT), mentoring the business users so they understand new processes, design and execute the test cases, designing various solutions during the UAT, post implementation support.

Most of the time spent with business community including upper management during project.

Designed the integration process between Contract Booking System (homegrown system) to Service Contract and Oracle Project, Which includes the changes occurred in Contract Booking System needs to be reflected in Service Contracts. To create and update a Service Contract used the Service Contract APIs using the PL/SQL. Designed the integration between Field service to Oracle project and Order to Cash process.

Sr. Oracle Applications Developer, Ames True Temper, USA, April 2008 to 2009

Environment: Oracle Applications 11.5.10 (General Ledger, Payable, Receivable, Fixed Asset, Purchasing, Inventory, e-Commerce Gateway (EDI), Order Management, iProcurement, Trading Community Architecture TCA, Application Object Library and Sys Administration) multi org/currency, Oracle RDBMS, PL/SQL, SQL, SQL*Loader, Oracle Reports, Oracle Forms, XML Publisher, Discoverer, Workflow and shell script, TOAD, Migration tool STAT, PVCS, Java, GPG

Role:

Customize the commercial Invoice in receivable to fulfill the VAT requirement for the different org using the Oracle Reports.

Conversion / migration of the Customers: Responsible for designing, development of conversion of customers and related attributes using the Oracles TCA API. This is for the Castle Harlan reporting and S&P budgeting purpose. This can also used in future for mass update of those attributes.

Developed the implemented the interface program to convert the journal entries from legacy system into Oracle General Ledger. After receiving file, data loaded into the custom tables and in turn loads the Oracle interface table with proper validation. After the interface tables loaded Oracle standard processes runs, which loads the base table. This provides the error reporting so user can fixes at the source.

Developed and implemented the EDI Invoice form, so it allowed user to update the EDI invoice related field for the federal SOX compliance.

Developed and maintained the Sales Analysis for the freight calculation for unique requirement.

Help the users to resolve the production problem by interacting with Oracle metalink.

Oracle Applications Consultant, CVS PharmaCare, USA, April 2006 to April 2008

June 2005 to August 2005

Environment: Oracle Applications 11.5.9 (Purchasing, Inventory, e-Commerce Gateway (EDI), General Ledger, Payable, Receivable, Application Object Library and Sys Administration), Oracle RDBMS, PL/SQL, SQL, SQL*Loader, Oracle Reports, Oracle Forms and shell script, PVCS, Java, AIM Methodology

Role: Interacting with the user for gathering requirement, designing solution, development, testing, implementation with the best practice.

Developed and implemented the automated process for EDI standards like INI-Invoice (810/INVOIC), Ship Notice/Manifest (856), Price Catalog (832). This process is the interface to the Oracle e-Commerce Gateway. The trading partners send the electronic file to the secure site and PharmaCare download those files into their sites. After receiving files, load all the files to the custom tables and in turn loads the Oracle interface table with proper validation. After the interface tables loaded the program runs Oracle standard processes, which load the base table.

Customize various existing report and developed the various reports for various supplier as well as notification for users.

PO EXTRACT : The client was required to procure a certain group of products from an inter-company entity that does not use Oracle products. Designed and developed a custom process to extract and validate purchase order information from the Oracle Purchasing module and transmit the inter-company replenishment file to an external system for processing. This custom process featured a call to an FTP utility from within an Oracle stored procedure which placed the order replenishment file directly on the remote secure FTP server. These custom programs including all file manipulations and archiving is executed through a concurrent process. Also designed and developed the custom security to support the FTP process.

Oracle Applications Consultant, Vocollect, Inc, USA, August 2005 to March 2006.

April 2005 to June 2005

Environment: Oracle Applications 11.5.10 (e-Business Suite-Financials, Supply Chain, Manufacturing, Application Object Library and Sys Administration), Oracle RDBMS, PL/SQL, SQL, TOAD, Discoverer, Oracle Reports, SQL*Loader, Oracle Reports, Oracle Forms, XML Publisher, WorkFlow, shell script, and AIM Methodology

Role: Involved in conversion and customization from legacy system to Oracle ERP. Also interacting with the user for gathering requirement, designing solution, development, testing, implementation.

1. Developed custom views ( Orders, Backlog and Revenue ) required for business intelligence / management reporting.

2. Developed custom reports-oracle standard and discoverer reports required for business intelligence / management reporting. These reports based on custom views developed above.

3. Developed custom package that would calculate the actual cost of the configured ATO model before the sales order is released to manufacturing. This was required to report the actual cost the sales orders.

4. Developed the Budget Vs Actual report, which reports the information from General Ledger, Payable and purchasing for open and closed period.

5. Oracle and Optio Interface: Wrote the SQL calls for Optio which helps to get the important information from Oracle without modifying the Oracle application reports viz. Picking Slip, Commercial Invoice, Purchase Order, Advance Shipping Notice, Sales Order Acknowledgement etc.

6. Work with the production support team to debug issues with Optio and Oracle applications.

Oracle Applications Consultant, Bombardier Transportation, USA, June 2010 to September 2010.

November 2004 to March 2005.

October 2003 to March 2004.

Environment: Oracle Applications 10.7 NCA (AP, OPA, GL, AR, PO) Oracle RDBMS, PL/SQL, SQL, Oracle Reports, Oracle Forms, SQL*Loader, PERL and shell script.

As an Oracle Application Consultant, involved in the customization of Oracle Applications, interface and conversion of Invoices from SAP into Oracle Apps for Bombardier Transportation Pittsburgh, PA

Oracle Payable

• Custom Interface: Responsible for designing, development of interface and conversion using PL/SQL for inbound and outbound from SAP to Oracle application. This is a batch process, external system send text file, which needs to validate all the required information in Oracle. After successfully validated it creates, delete, release invoices using Oracle Payable standard API. This extension also provide the detail error and acceptance notification via email.

Oracle Projects (OPA)

• Custom Interface: Responsible for designing, development, enhancement and maintenance of custom interface using PL/SQL, Component Cost of Sales (based on order), Cost of Sales, Consolidation on Legal Entity by contract ( interface as well as based event type ), conversion of Oracle Project Accounting Project summary information into SAP,

• Custom Reports: Responsible for designing, development of custom reports using Oracle reports for Oracle Project Accounting (Costing and Billing). These reports are based on Event Type, Service Type viz. Customer Retention, Vendor Retention, Progress Billing, Retrofit, Vendor Advance, Work-In-Process by Project / Company, Contract Summary

Oracle General Ledger

• Custom Interface: Responsible for designing, development of custom interface using PL/SQL, Other Direct Cost shown in Expense Summary from Project Accounting to General Ledger( based on service Type and expenditure category).

• Provided technical expertise to consultants for successfully completing various SQL*Plus, PL/SQL and Oracle Reports and Forms

Oracle Applications Consultant, Tetra Tech Inc, USA, June 2004 to November 2004.

Environment: Oracle Applications 11.5.9 (OPA, AMG, AR, OTL), Oracle RDBMS, PL/SQL, SQL, SQL*Loader, Oracle Reports, Oracle Forms, Workflow, XML Publisher, AIM methodology

As an Oracle Application Consultant, involved in the conversion, extension, and customization of Oracle Applications for Tetra Tech Inc., Pasadena, CA.

Oracle Projects (OPA)

• Conversion:

• Conversion of projects, agreement and funding from legacy systems to Oracle Project Accounting using AMG API.

• Conversion of Projects inception to date revenue, Paid invoices and Open invoices. Program involved creating events using Project Accounting API for open/paid invoices and sending it all the way through to AR by applying cash receipts.

• Interfaces: Designed and developed the Compensate time off and computer usage interface between OTL and Oracle Project Accounting using client extension API( standard functionality ).

• Extensions: Designed and developed the labor transaction, billing costing client extension which are called in the Oracle Project Accounting standard processes using standard functionality.

• Billing Extensions: Developed billing extension for multiple revenue recognition and fee scheduling which are assigned to project and/or task level using standard functionality.

Oracle Account Receivables

• Custom Interface: Responsible for designing, development of extension of remit to address custom interface using PL/SQL which will retrieve the remit to address from customer transaction type.

Oracle Applications Consultant, Eaton Electrical, USA, January 2003 to March 2004.

Environment: Oracle Applications 10.7 NCA and 11i (PA), Oracle RDBMS, PL/SQL, SQL, Oracle Reports, Oracle Forms, SQL*Loader, PL/SQL Developer

As an Oracle Application Consultant, involved in the implementations and customization of Oracle Applications with Multi Org and Multi Currency for Eaton Electrical (Cutler-Hammer Engineering Services & Systems), Pittsburgh, PA

Involved as Technical specialist in the Oracle Project Accounting Implementation Team.

Oracle Projects (OPA)

• Custom Reports: Responsible for designing, development of custom reports, These reports are based on Country, Region, DOC, Customer Category/Number/Market Segment, Alliance Partner, Salesperson, Product code, Product line with Bill amount, actual/standard labor and material, margin etc.

• Custom Interface: Responsible for designing, development of custom interface using PL/SQL, Sales objective which contains information like forecast, Invoiced, entered with adjustment during the year. Order feed from legacy to Oracle Project Accounting. Wrote warehouse interface for Sales person objective used at various place and provide faster information.

• Custom Forms: Responsible for designing, development of custom forms, form allowed used the flexibility to retrieved the record based on various parameter also having opportunity to export data into excel with title viz. project summary query, project task query. Sales objective inquiry.

• Provided technical expertise to Eaton employees and other consultants for successfully completing various SQL*Plus, PL/SQL and Oracle Reports and Forms.

Oracle Applications Consultant, Parametric Technology Corporation, USA, July 2002 to December 2002.

Environment: Oracle Applications 11i (PA), Oracle RDBMS, PL/SQL, SQL, Oracle Reports, Oracle Forms, SQL*Loader, UNIX, Source Code Management CMS, TOAD.

As an Oracle Application Consultant, involved in the implementation and customization of Oracle Applications with Multi Org and Multi Currency for Parametric Technology Corporation, Needham, MA.

Involved as Technical specialist in the Oracle Project Accounting Implementation Team.

Oracle Projects (OPA)

• Custom Reports: Responsible for designing, development of custom reports using Oracle Reports 6i for Oracle Project Accounting (Costing and Billing). These reports are based on Service Type, Event Type, viz. Employee Utilization, Work-In-Process by Project / Company (contain event, invoices, expenditure transaction), Project Without Funding, Agreements to be Funded etc.

• Custom Forms: PTC had a requirement to send PA Report Outputs to Users (Project Managers, Client Managers and Report Requestors). In order to do this, I developed a custom form that would help maintain Report information like Report Parameters, Email Address to whom the output would be sent, etc. A procedure was created to read this information and submit Concurrent Requests to specified Email Address. This process was scheduled on weekly basis.

• Provided technical expertise to other consultants at PTC for successfully completing various SQL*Plus, PL/SQL and Oracle Reports.

Oracle Applications Consultant, Virtual Communication, USA, February 2002 to June 2002

Environment: Oracle Applications 11i (PA, Sales Compensation), Oracle RDBMS, PL/SQL, SQL, Oracle Reports, Oracle Forms, SQL*Loader, UNIX, TOAD.

As an Oracle Application Consultant, involved in the implementation and customization of Oracle Applications for Virtual Communication, Monroeville, PA.

Oracle Projects (OPA)

• Custom Reports: Responsible for designing, development of custom reports using Oracle Reports 6i for Oracle Project Accounting (Costing and Billing). These reports are based on Service Type, Event Type, viz. Work-In-Process, Agreement to be funded, Project Funding Status, etc.

Oracle Sales Compensation

• Custom Reports: Responsible for designing, development of custom reports using Oracle Reports 6i and SQL*Plus for Oracle Sales Compensation. These reports are Pay Analysis, President Club, Eight Quarter, Raking report etc.

Oracle Applications Consultant, Bombardier Transportation, USA, September 1998 to January 2002.

Environment: Oracle Applications 10.7NCA/11i (PA, GL, AP and AR), Oracle RDBMS, PL/SQL, SQL, Oracle Reports, Oracle Forms, SQL*Loader, UNIX, Workflow.

As an Oracle Application Consultant, involved in the implementation and customization of Oracle Applications for Bombardier Transportation, Pittsburgh, PA.

Involved as Technical specialist in the Oracle Project Accounting Implementation Team.

Made numerous recommendations as work around for gaps identified during the BPR stage.

Involved in the customization and implementation of Oracle Project Accounting, GL and post-implementation support.

Oracle Projects (OPA)

• Custom Interfaces: Responsible for designing, development, enhancement and maintenance of all custom interfaces for Financial Cost of Sales, Component Cost of Sales, Burden Redistribution, Adjustment Entry, Fringe for Project Cost using PL/SQL packages.

• Custom Processes: Responsible for designing, development, enhancement and maintenance of all custom processes for Project Summarization or Total Pricing Cost for Project (include cost and budget), Contract Summary for Project (include cost, budget and billing), International Accounting Standard - Balance Sheet & Income Statement (include costing, billing, receivables, payables) using PL/SQL packages.

• Functionality of Auto Accounting: Designed, Developed and Utilized Auto Accounting to distribute usage costs for concurrent processing.

• Resolved issues that were identified during the User acceptance testing.

• Responsible for mapping legacy data to projects, tasks, budget and expenditures. Files received from legacy system of projects, tasks, budget and expenditures uploaded into Oracle Project Accounting tables using SQL*Loader, SQL*Plus, PL/SQL and concurrent processes ( transaction import, distribute usage cost).

• Involved in implementation, production support, customization, development and testing of Conversions, Interfaces.

Oracle General Ledger

• Responsible for mapping legacy data to Journal Entries and Accounting information. Files received from legacy system of Journal Entries and Accounting Information are uploaded into Oracle General Ledger tables using SQL*LOADER, SQL*PLUS, PL/SQL and concurrent processes.

Oracle Receivables

• Oracle Reports and Gaps Development:

• Customized the Invoice Printing Report to match the client's invoice format, using Dynamic PL/SQL and Oracle Reports, to capture extra header and line information for invoice.

• Customized the Aged Trial Balance - 7 Buckets - By Agent to variable Aged Trial Balance - upto 6 Buckets - By Agent using Oracle Reports.

Oracle Payables

• Built an Interface between Oracle Payable and ConCur, which is Travel and Expense Software, for efficient execution of payment.

Technical Skills:

RDBMS

Oracle 10g, Oracle 9.0.2, Oracle 8i, Oracle 7.x, Oracle 6, Oracle 5.x.

ERP / CRM

Oracle Applications 10.7NCA, 11i (Single and Multi Org Environment)

Modules : Oracle Project Accounting PA, Oracle General Ledger GL, Oracle Receivables AR, Oracle Payables AP, Oracle Order Entry OE, Oracle Sales Compensation OSC, Oracle Purchasing PO, Oracle Fixed Assets FA, Oracle Inventory INV, Activity Management Gateway AMG, Familiarity with Oracle Workflow, Oracle Application Object Library AOL, SYS ADMN

Software

PL/SQL, Oracle Developer 2000 (Oracle*Forms 4.5, Oracle*Reports 2.5), Oracle Developer 6i ( Oracle Forms & Reports 6i ), TOAD, Pro*C, SQL*PLUS, SQL*LOADER, SQL*FORMS 3.0/2.3/2.0, Discoverer, Designer 2000 1.3, SQL*REPORTS 1.1, SQL*IMP/ EXP, SQL*DBA, COBOL, Pascal, BASIC, FORTRAN, CMS, Turbo Analyst 2.2, UNIX Shell, VAX DCL, SQR 3.0.13, C (CC/Borland Compiler), XBase.

Operating System

Sun Solaris 2.x, HP-UX, Sequent UNIX with Dynix4.2.2 Release 4.0, Iris 6.2, DRS/NX, SMOS, UNIX SVR 4.2, Open VMS 6.2, Novell NetWare 3.12, Windows 2002 / NT / 98 / 95, Windows 3.11/3.0, MS-DOS.

Hardware

Sun Sparc20/10, HP-9000/887, Sequent I386 NUMA UNIX, Silicon Graphics Indy (SGI) R/5000, RISC based ICL DRS-6000, DEC VAX Alpha Clusters, ORG SuperMax (SMOS), Wipro S-386, IBM-PC compatibles.

Contact this candidate