SUMMARY

• Total **+ years of experience in analysis, design, development, documentation and implementation of business applications, from which 10 years mainly in Oracle Applications implementation and support projects.

• Technical competence to provide expert consultancy on Implementation, Integration with customization and functionality of AP, AR, GL, CRM modules in Oracle Applications.

• Expertise to develop the assigned RICE components i.e., Reports, Interfaces, and Forms by adhering to the Business Process Functional Specifications and development standards for the projects.

• Extensively experienced in Development of Interfaces to validate and load data from legacy and feeder system to Oracle Applications modules.

• Implementation of R12 Advanced features, including the functionality related to SLA customization for Receivables, and setting the SLA Supporting References logic to provide additional business information about a sub ledger journal entry at the header, line level for faster reconciliation of account balances.

• Excellent capabilities to understand, implement the Application Design, Configuration / module functional setup and documentation of functional design documents.

• Proficient in programming using Oracle (PL/SQL, Pro*C), Forms 6i, Reports 6i and JDeveloper.

• Having Knowledge in Oracle Applications Forms Development and customizations by using Forms Personalization, practical expertise in Oracle Application Framework Personalization.

• Web Services, including integration experience utilizing SOA based components to deliver integrated solutions with re-useable and multi-purpose Enterprise Business Services (EBS) and application interfaces.

• Sound Knowledge of the Oracle Applications AIM Methodology; its application to the various phases of the project implementation life-cycle.

• Good knowledge in the Technical Domain of the AOL (Application Object Library) module.

• Proven track record in managing multiple full project lifecycles from business requirement study, project development to final delivery.

• Ability to work & coordinate with IT functional and technical analysts to provide consensus based ERP solutions that are scalable, adaptable and synchronized with evolving business needs.

• Excellent Communication, Analytical, Interpersonal, Project Management skills with extensive

on-site client project management experience in U.S., and experienced in the onsite-offshore project delivery model.

Skills :

Operating Systems AIX, SCO UNIX, SUN Solaris, Linux, MS Windows NT, Windows XP

GUI Developer 2000, Forms 6i, Reports 6i, Designer 2000, JDeveloper

Databases ORACLE 7.3, ORACLE 8i, ORACLE 9i, ORACLE 10g, ORACLE 11g

CASE TOOLS Designer 2000

Language SQL, PL/SQL, C, PRO*C, Java, OA Framework

ERP Oracle Applications (Versions 11.5.9 and 11.5.10 of Rel.11i), 12.0.4

Modules worked (Oracle APPS) AR, AP, OM, GL and CRM

Other Tools TOAD, PL/SQL Developer, XML Publisher, SQL Loader,

Version Maintenance Tool : Clear Case (Rational Rose).

PROFESSIONAL EXPERIENCE

Project # 1.

Organization : HCL TECHNOLOGIES LTD., Noida

Client : GE Corporate, U.S.A

Project type : Consolidation of Corporate Ledgers into Centralized General Ledger

Duration : 17-MAR-2008 - till date

Modules : GL Implementation

Environment : Oracle APPS version 12.0.4, Oracle RDBMS : 10.2.0.3.0, Linux OS

Role : GE Corporate Consultant

Project Description :

• The main objective of this project is the integration of all the GE entities into the Central Corporate ledger, through the implementation of an Oracle GL with utilization of new enhanced features in 12i, along with management reporting and analytical tools for the merged entities of Corporate Components globally.

• To simplify and create a Lean Corporate environment with a single COA (chart of accounts), leveraging MARS (Management Audit and Reporting System) architecture to implement one general ledger environment for all Corporate, resulting in an optimized period processing and reporting process . Standardization :- Single COA Structure, Standard GE Processes e.g. tax & re-measurement, Standard close / open processes.

Salient Project Deliverables :

• Golden Tax Automation Process : The Golden Tax Automation is an initiative to achieve the complete automation for certain key processes of the Golden Tax Adaptor for China that have till now been available for use in ‘Manual mode’ within the GTA module to the GE China business users. There are 2 main processes that have been identified for automation to reduce the manual activity & increase the operational efficiency, namely the ‘Golden Tax invoice Export’ (to export VAT specific documents from Oracle GTA to Aisino 3’rd party system), and ‘Golden Tax invoice Import’ (to import VAT specific invoices from Aisino system to Oracle GTA).

Conceptualized the Technical specification and responsible for the overall technical design of this complex customization, wherein the key most frequently used processes: GTA Invoice Outbound and Inbound interfaces have been completely automated to an extent that would provide the users with process completion status notification and enable greater ease of use & maintenance by reducing their manual intervention, and thereby increasing the operational efficiency for this entire process.

• Design and implementation of the CCLGL-DRM Integration Bridge process.

The CCLGL-DRM Integration Bridge is an automated core process that is required for the migration of flex-value set master data and COA (Chart of Accounts) segment related set-up information from different external systems into the CCL (Central Corporate Ledger) system.

All master data to be centrally managed and stored in the Data Relationship Management (DRM) application. This master data from DRM meant to flow periodically to CCLGL as required by the business through an integration process called CCLGL-DRM Bridge.

A set of processes needed to be developed to migrate flex-value data from different external systems like ‘COL’, ‘MARS’, ‘CORP’ etc. into CCL system, during the initial set-up phase of the CCL GL implementation.

The given process had been developed with a view to integrate all these steps in a logical sequence, to address this requirement and facilitate the successful migration from other external legacy systems into the CCL System (with incremental setup loads of flex values from legacy to the target ledger/ and customized program for synchronized updating of flex attribute(s) based on the attribute mapping between the source flex value set values with the corresponding matching flex set values in the target CCLGL ledger setup).

• Designed implementation of the CCL GL Check-in Process that is a custom built extension to handle data flow from external sub-ledgers. CCL GL Check-in process is initiated when the transactional data file originating from external sub-ledgers and sent through DXL (Data Exchange Layer) is received.

Process functionality : CCL is expected to receive transactional data from external sub-ledgers. All external sub-ledger feeds will be sent first to DXL (Data Exchange Layers) in a pre-defined format. DXL will log the file, perform file integrity validations and send the file to CCL GL environment for further processing.

All incoming data to CCL GL will be validated by this process against extensive set of business rules / business check-in edits before it can be booked to the common ledger.

Check-in process consists of the following subtasks:

- Receiving files from DXL in real-time in automated fashion.

- Applying mandatory and optional business rules (edits and/or transformations) to the file.

- Generating edit report for the file and sending back to DXL.

- Accepting good records and triggering import to CCL GL through Oracle’s Journal Import process.

• Technical Design and implementation of the Journal Entry Control Process.

As part of Global business services (GBS) and Corp Ops implementation on CCL a new business requirement was added: journal entries booked during quarter close period are subject to review and approval by corporate controllership team. The process of review and approval of journals during the final phases of the quarter close period is referred to as journal entry (JE) control process.

To enable JE control process logic needed to be added to Oracle JE approval workflow to determine if the journal should be sent to an approver.

In case of Approval is required the journal would be forwarded to an approver based on employee hierarchy maintained in CCL GL. Employee hierarchy allows assigning a supervisor to each CCL GL user. The supervisor must be an active CCL GL user with USER or SUPER user access.

When journal is forwarded for approval, an email is send to approver with an attachment containing

complete journal report (for review). For enabling this functionality, customized the GL standard

workflow process for the online journal approval. It triggers the online custom edits at the journal &

batch level as additional business logic specific checks that need to be completely validated before

the final batch approval.

• CCL ES COA Structure redesign :

The main objective of the ES COA project was to redesign the original COA (Chart of Accounts) structure, in line with evolving changes in the GE Corp business model, specifically related

with the need to have common & uniform COA structure across for all the GE wide businesses

and to comply with the revised statutory requirements for new segment-wise reporting

(e.g. Geographical, product-wise) for better management & financial control .

Entire ES COA project organized into 2 major phases :

In the initial phase, the Oracle standard object repository converted to the target ES COA

structure based on the mapping logic defined & which then used by Oracle provided software

product "ePrentise" known as "Oracle COA Switch Solution" to completely transform the impacted

standard components & objects per the new ES COA format.

For the 2'nd final phase, led major technical effort for the identification of CEMLI components

impacted by the COA change, followed by the complete retrofit for all the custom CEMLIS that had

been impacted with the new ES COA structure.

Project # 2.

Organization : HCL TECHNOLOGIES LTD., Noida

Client : GE Healthcare, (GEHC)

Project type : Oracle ERP deployment for Intl sites 2007

Duration : 16-APR-2007 – 31-JAN-2008

Modules : AP,AR,PO

Environment : Oracle APPS version 11.5.10.2, Oracle 9i, UNIX SunOS

Role : GE Healthcare Consultant

Project Description :

• Oracle ERP Implementation project for GEHC Eastern Europe.

Co-ordination with the Functional Teams for the Setup of Oracle modules such as Purchase Order, Accounts Receivables, Accounts Payables, General Ledger.

• Customization and Development of the Global Automated Conversion Tool (based on interactive Unix shell scripting along with internal calls to pl/sql program units) and integration testing to enable the data conversion for external/affiliate Vendors, external/affiliate Customers

This project extensively involved the customization of Oracle reports using XML Publisher.

Also majorly this was a deployment of Oracle financials in four of the GEHC sites for the Czech Republic, Romania, Slovakia and Russia.

Project Deliverables :

• Customization and Development of the GE EU Receipt Note Report for the Czech Republic, using the XML Template methodology.

The report has been customized to implement the new Europe Receipt Note report called the

GE EU RECEIPT NOTE. This has been used for developing a new Receipt Note Format using XML that is not provided by Oracle as a Standard Format. The logic in XML template is incorporated to print the text labels in the corresponding European language(s) depending on the value passed in

the input language parameter of the Receipt Note Report.

• Designed / Developed the EFT Payment Interface for Russia as per the Citibank payment format specification for multiple types of payments; namely the Ordinary local payment, Tax local payment,

and Cross-border funds transfer. The logic within the payment program enabled the payment file generated to consist of multiple payment lines each formatted as per the corresponding payment type within the same payment batch file.

• Lead the resolution strategy to Handle the multi-language/ multi-byte character set data, utilizing the UTF8 character set during the ERP Conversions.

• Creation of the SOP (Standard Operating Procedures) to document the various Conversion and testing related activities performed during the implementation process, as per the GEHC standards.

• Tuning of the XML Publisher Reports ; also prepared the Performance Tuning documents for the Reports.

Project # 3.

Organization : Path InfoTech Ltd., Noida

Client : National Informatics Center, (NIC)

Project type : Oracle Apps 11i Implementation

Duration : 01-AUG-2006 – 31-DEC-2006

Modules : CDH (Customer Data Hub)

Environment : Oracle APPS version 11.5.10, Oracle 9i; CDH (Customer Data Hub) module based

on the TCA Architecture.

Role : Project Leader

Project Description :

The project involved mainly the process for upload/ migration of country citizen data to the Oracle Applications CDH repository. The citizen data comprises of the person’s entire Electoral Commission related data collected and accumulated from the Election Commission at the state & assembly level constituencies in India, and further mapped with the Party entity in the TCA model of Oracle Applications E-Business Suite.

Responsibilities :

Conducted the approach feasibility study/ planning for the migration of data from the ECI (Election Commission of India) to the Oracle CDH.

Preparing the M.D.70 Technical Documents after completion of each of the component.

Development and Customization of Reports and Developing of Interfaces using PARTY & CUSTOMER API’s.

Performance optimization of the Interface Program to import the data from legacy system to Oracle CDH Base Registry Tables.

Project Deliverables :

• Import of ECI Citizen data to the Oracle Applications CDH repository using the Standard Concurrent Program: Import Batch to TCA Registry.

The Import Batch to TCA Registry program is used to import a batch from the interface tables into the TCA Registry. The program provides optional pre-import processes that can be performed on the data before the actual import into TCA.

• Customization of the Online Customer Batch Dedupe Process for identifying the duplicate parties from within the Registry, based on various seeded and custom Match Rules.

• Plugging of the name matching web application in VB .Net, based on the AMIN algorithm (Approximate Matching of Indian Names) into the Oracle CDH. The entire program code needed to be converted from VB .Net to PL/SQL to enable the plug-in.

Project # 4.

Organization : Path InfoTech Ltd., Noida

Client : Maruti Udyog Ltd., Gurgaon

Project type : Oracle Application 11i Implementation

Duration : 01-JAN-2006 – 31-JUL-2006

Environment : Oracle APPS version 11.5.10, Oracle 9i; AR, AP, PO, GL, HRMS module.

Role : Senior Technical Consultant

About Client :

Maruti Udyog Limited is the premier car company in India, consistently having been recognized as a major automobile manufacturer in the Asia Pacific region.

The company has a wide range portfolio of select car models across various segments; and has State-of-the-art manufacturing facilities at Gurgaon, Manesar in Haryana.

Project Description :

Project assignment included the full life-cycle Implementation and customization of Oracle Apps E-Business Suite (Oracle Financial module) at Maruti Udyog Ltd. Gurgaon.

The existing system in Legacy has been migrated to Oracle Applications 11i platform. Major modules being implemented were AR, AP, FA, GL and the Oracle HRMS module.

Project Deliverables :

• Studying, understanding and analyzing the given AIM Documents (MD50), and creating the corresponding MD70 documents.

• Development and customization of the assigned RICE Components according to the Business Process Analysis and development standards.

• Data porting from existing system into Oracle Application database.

• Creation of Customers in an Operating Unit and setting up their profiles (AR Customer Interface).

• Defining the Set of Books and Chart of Accounts Structure (initial AR, GL Setup Activities).

• Implementation and planning of flex-fields for various business customization purposes.

• Customization of Reports, Form and Report Registration.

• Transfer and posting of Consumption journals from PMIS to the General Ledger using GL Interface and Journal Import.

• AR Invoice Interface designing / coding for porting of invoices related data from Legacy system to Oracle Applications.

• AR Receipt Interface designing / coding to import receipts from a bank file using and customizing Auto Lockbox, Defining lockboxes. For each lockbox, configured the lockbox number, bank name, batch source, bank account, bank origination number, payment method and cash account.

• Automatic application of Receipts, Credit Memos to Invoices using standard Receipt API’s in AR.

• AP Invoice Interface and EFT Program for transferring Vendor Payments through Bank.

• Development of Oracle Alerts in the PO Module, from the Requisition to the Approval Cycle.

Project # 5.

Organization : Path InfoTech Ltd., Noida

Client : LG Electronics, Greater Noida

Project type : Oracle Applications Tuning

Duration : 01-OCT-2005 – 31-DEC-2005

Environment : Oracle APPS version 11.5.10, Oracle 9i, SUN Solaris, AR, GL, INV, OM, CRM

module.

Team Size : 5

Role : Project Leader

Description:

While working in the capacity of a Project Leader, was managing the on-site team involved in the

performance & tuning of the existing forms/reports and developing new customizations for Oracle

Applications. The job profile also included providing technical guidance for forms, reports and on-line

support. The current responsibilities consisted of providing technical and performance tuning support

(with my team) on Oracle APPS (Version 11.5.10) by interacting directly with end-users and identifying

the performance key-areas.

Roles and Responsibilities:

• Interacting with client and requirement gathering & analysis.

• Preparing technical test-plans and specification.

• Tuning/ Optimization of sql/ plsql programs using dbms_profiler, explain plan etc.

• Preparing Test-Case Documents for the tuned objects.

Project # 6.

Organization : Path InfoTech Ltd., Noida

Client : XEROX INDIA Ltd.

Project type : Oracle Applications Upgrade and Customization

Duration : 01-JUL-2004 to 30-SEP-2005

Environment : Oracle 9i, Oracle Applications R11i, SUN Solaris, CRM module, EBS Service

Contracts, Field Services, Installed Base Apps Tech

Team Size : 5

Role : Technical Consultant

About Client :

Xerox India Limited (XML) is a part of Xerox Corporation (NYSE: XRX), the US $15.7 billion, Fortune 500 global document management company. Over the past 20 years, Xerox India has shaped the Document Management industry in India by ushering in the world's best document processing products and bringing innovative value-added concepts to cater to Print Industry. Xerox India has successfully transitioned three major movements in India since its inception, from copying to printing, black and white to color and stand-alone analog to digital, networked products.

Project Description:

• Customization of the Oracle Service Contracts module; enhancement of the various customized reports such as the Invoice Meter billing report.

• Enhancement of Meter billing programs by way of implementation of new features like VAT, Service tax etc. and to incorporate billing of machines with multiple B/W + COLOUR counters.

• Medium Exposure into the setup and configuration of Modules like: Tele Service with knowledge in: Service Contracts, Field Services, and Installed Base.

• Added custom extensions for VAT / Sales Tax customization to the Service Contracts Main Billing Program, and to the Service Contracts Fetch Receivables Info for Billing Program.

The Main billing program sends the invoice amount to Oracle Receivables, which then generates the invoice. The process also populates some billing transaction history information in the History tab of the Billing Schedule.

• Custom development to call standard APIs in the Installed Base (CSI) and Contracts (OKC/OKS) modules. This custom process updates installed base instances and contract records to reflect correct ownership information for the shipped orders (PL/SQL).

Project # 7.

Organization : Churchill India Pvt. Ltd., Gurgaon

Client : Churchill Insurance U.K. (presently RBS Group U.K.)

Project type : Insurance Premium Collection Batch Re-architecture Project

Duration : 01-NOV-2000 to 31-JAN-2003

Environment : Oracle 8i, SUN Solaris, Pro*C, PL/SQL, PL Vision, and SQL Navigator

Team Size : 21

Role : System Analyst

Role(s) and Responsibilities :

Carrying of the Impact Analysis and Complete study of the functionality of various Insurance and

premium collection batches in Pro*C.

These batches were classified as per the various stages in the life cycle of an Insurance Policy; and the various sub-groups / functional areas to which these Batches are linked include the following:

a.) Codis: Churchill On-line Direct Insurance System

This system is responsible for the issuing of a new policy, maintaining the status of a policy through its various stages; renewal of a policy, as also to keeping a record of all types of transactions that are performed on that policy.

b.) Claims: For handling and dealing with the various types of claims on an Insurance Policy.

c.) Accounts: The batches under this category are responsible for the efficient collection of daily premium by generation of payment files and their timely submission to the Banks Automated Centralized Service.

The batches pertaining to the above-mentioned categories were converted from

Pro*C to PL/SQL using the advanced features of Oracle 8i like Autonomous Transactions, Bulk Collect, PL/SQL Records and Table types, Packages, PL Vision utilities etc.

Project # 8.

Organization : Info Team Technologies, Noida

Client : Samtel Color Limited. (Ghaziabad, U.P.)

Project type : Production Management Information System (PMIS)

Duration : 01-FEB-2000 to 31-OCT-2000

Environment : Oracle 7.3, Developer 2000 (Forms 4.5, Reports 2.5), and PL/SQL

Team Size : 3

Role : System Analyst & Database Designer

Role(s) and Responsibilities :

Systems Analysis and detailed database design for the various stages of the given Assembly Plant system.

Development and implementation of the system as per the System Specifications and

user requirements.

Implementation and Customization of system at the various branches of Samtel Color Ltd.

Project # 10.

Organization : Computech International Ltd.

Client : ISPAT KARMET -(Steel Plant) at Temirtau City, Kazakhstan.

Project type : Payroll and Personnel Management System

Duration : 01-AUG-1996 to 29-FEB-2000

Environment : SCO UNIX (Russian version) / Oracle 7.3 / Developer 2000, Pro*C, PL/SQL

Team Size : 5

Role : Team Member

Project Description :

Bilingual on-line application with Electronic attendance registering System.

The client manages around 30,000 employees in its Steel Plant. Oracle server & Unix OS installed with Russian language support.

Role(s) and Responsibilities :

Study of Russian payroll system,

Classification from Russian to English,

Designing of data entry screens in Developer / 2000 (Forms 4.5, Reports 2.5),

Development of Payroll reports in Reports 2.5 a

Embedded SQL and Pro*C, Program coding and unit testing.

EDUCATION

Earned the degree of Master of Science in Computer Engineering, with specialization in Real Time Automated Control Systems in 1996.

Trained as Computer Engineer at the Kharkov State Technical University, at the Ukraine (C.I.S).

(Indo - Russian Educational Exchange Programme).

PERSONAL DETAILS:

Name : Neeraj Pandit

Residence : 23, Uttaranchal Apartments,

Plot No. 5, Mother Dairy Marg, I.P. Extension,

Patparganj,

New Delhi – 110092.

Tel. (Residence) : 22786306

Mobile : +91-995*******

Language known : English and Hindi, Russian & German

E-Mail Contact : acxdsu@r.postjobfree.com

Contact this candidate