Summary

• Possess 12 + years of experience in Information systems (Design, Development and implementation of commercial applications)
• 8 + years of experience in Oracle applications (Oracle General Ledger, Oracle Receivables, Oracle Payables, Oracle Cash Management, Oracle Fixed Assets, Oracle Human Resource Management System, Oracle Inventory, Oracle Purchase, Oracle Order Management and Oracle Projects)
• Working knowledge of CRM modules ( Sales Quote, Service contracts, Install Base, Tele Service and E-Mail centre)
• Sound functional knowledge on Order to Cash, Procure to Pay and Quote to Service.
• In depth knowledge of Oracle application data structure ( Backend table level)
• Involved in 5 full cycle Oracle application implementation
• Experienced on various roles including Technical lead, Team Lead and Technical team member.
• As a technical lead, capable of providing technical specification to technical team of 5 or more technical persons.
• Experience in implementation, migration and support projects
• In-depth experience on Implementing various modules of Oracle Applications
• Worked on migration projects
• In-depth experience on support projects
• Excellent experience in Requirements Analysis, Mapping Requirements, Process Flow-Charting and Gap Analysis leading to Functional Setup of Accounting and related Management Information Systems.
• Excellent Functional and Technical Knowledge of Oracle applications 10.7NCA, 11.03 and 11i versions in the Financial Modules, Supply chain Modules, Projects, Human Resources and Payroll modules.
• Experience in Full Life Cycle of Oracle Applications Custom Development: Analysis, Development, Testing, Implementation and Support.
• Rich Experience in Data Conversion and Systems Integration
• Excellent technical experience in Oracle Workflow customization
• Excellent technical knowledge of creating new Oracle Alerts and customize the existing alerts for various business requirement.
• Experience in preparing AIM 3.0 ( Application Implementation Methodology) technical documents for data conversion and applications extension
• Sound Knowledge of Form customization, Report customization and developing new reports.
• Sound Knowledge of Programming Standards, Methods, Techniques and Version Control aided by rich programming experience in a wide range of third generation languages.
• Sound Knowledge of the Oracle Database Architecture, SQL Plus and PL/SQL.
• Good understanding of Oracle Database Administration, Performance Tuning, Backup and Recovery.
• Possess Excellent Analytical Skills and a very good grasp of Entity Relationships.
• Extensive experience in planning and managing Oracle Application system, unit, integration and user acceptance testing strategy and procedures
• Excellent Problem identification and solving skills.
• Extensive experience in managing defects identification, reporting and resolution process
• Possess Good Communication and Interpersonal Skills

Technical Summary

• Hardware: IBM PC & Compatibles
• OS: Windows 98, Windows 2000, Windows NT, HP-UNIX 10.2, SCO UNIX System, Sun Spark Solaris 2.6, Red hat Linux.
• Tools: Developer 2000(Forms 4.5/5/6/6i and reports 2.5/3/6/6i) , SQL* Loader, SQL Plus, PL/SQL, Pro* C/C++, Oracle workflow builder 2.5, BI Publishers (XML Publishers)
• Oracle Applications: Oracle E-Business Suite 11i, Oracle Applications 1103
• Tools in Oracle Application: Oracle ADI
• Programming Language: Turbo C, Borland C++
• Database: Oracle 10g,9i, 8i, 8.0x, 7.x

Education

Master of Computer Applications (M.C.A)
Bachelor of Computer Science (B.Sc)

Professional Experience

Project Oracle CRM (Tele Service, Install base and E-Mail center - Support and enhancement)
Duration Sep2008 – Till date
Client Confidential – Washington DC, USA (PBGC is a federal corporation which protects the pensions of nearly 44 million American workers and retirees inmore than 29,000private single-employer and multiemployer defined benefit pension plans.)
Position Techno functional consultant
Environment Oracle Application 12i, Oracle 10g/Developer 2000(Forms 6i, Reports6i) on Red hat LINUX.
Project DescriptionPBGC have had implemented Oracle CRM12i –Tele Service, Install base and Email center to provide good service to its customers (Participants of pension plans). Oracle CRM tightly integrated with most of the legacy systems like GENISIS, CAS, ARTIS and MyPBA.

Roles/Responsibilities:

• Design and develop the BI Publisher (XML Publisher) reports. Developed around 6 new XML publishers reports
• Wrote shell scripts to send mails to vendor to conduct customer survey with a attachment of BI publisher generated excel file and registered as host type concurrent program.
• Prepared technical design documents.
• Customization of Contact center and Service center forms based on new Requirement.
• Customize around 20 Oracle Reports as part of SSN reduction functionality of CRM4.1 and CRM4.2 release.
• Customized existing inbound customer interface (PL/SQL Procedure) to rectify some existing bugs.
• Work with production support team and Resolved many production tickets related to CRM issue.

Project Oracle Financials with Oracle Projects, Oracle HRMS with OTL
Duration Apr2007 – Aug2008
Client Confidential– Vienna- Virginia, USA (Leading IT/IS service provider to the nation\'s federal intelligence community) 
Position Techno functional consultant
Environment Oracle Application 11i (11.5.10.2), Oracle 10g/Developer 2000(Forms 6i, Reports6i) on Red hat LINUX.
Project DescriptionNJVC-LLC is an Alaska Native Corporation which provides Information Technology (IT) and Information Services (IS) support to the nation\'s federal intelligence community. 
NJVC-LLC used Deltek and MSL systems to maintain their Financial, Human resource, Payroll and WBS (Work breakdown structure) information. As along with the growing business NJVC-LLC decided to implement ERP – Oracle applications. This implementation comprises of Financials, HRMS, and Project suite modules.

Roles/Responsibilities:

• Design the mapping of the legacy WBS structure with oracle project structure and development of interface to bring the legacy WBS transactions into projects. WBS transaction includes Labor and non labor transactions and burden transactions.
• Design and develop the project Budget interface
• Design and develop the project Roles interface (There is no standard interface/API available)
• Customization of project Role screen to accommodate 12 more additional fields apart from Oracle apps standard DFF.
• Design and develop the project billing events interface (Both Revenue and Billing)
• Design and develop API for loading legacy asset information into Oracle Assets.
• Design and developed custom extension for labor distribution cost (Total time accounting) which is fully integrated with Payroll and OTL.
• Customized purchase Order, Purchase Requisition account generator workflow in Oracle Purchase.
• Customized project supplier invoice account generator workflow in Oracle Payables.
• Prepared MD050 and MD070 for customizations

Project Oracle Financials /CRM /Supply Chain Re-implementation
Duration Jun2005 – Mar2007
Client Confidential– Florida, USA (Leading provider of automated Document Accounting Solutions in USA)
Position Technical Lead ( 5 Technical people)
Environment Oracle Application 11i (11.5.10), Oracle 9i/Developer 2000(Forms 6i, Reports6i) on Red hat LINUX.

Project DescriptionEquitrac Corporation has been the world\'s leading provider of automated Document Accounting Solutions for the professional and commercial markets. Equitrac is the first American company to develop, manufacture, market and distribute its own line of computer hardware and software systems designed to track, record and report on office automation expenses. 

This re-implementation is to bring in the business process changes of the client in the Oracle applications system and to enhance/streamline the current setup. This implementation comprises of financials, Supply chain and CRM modules

Roles/Responsibilities:

• As a Techno functional, responsible for design mapping process to map the 10.7 NCA char of Account with the 11.5.10 new chart of account.
• Design and development of interface to bring the open documents (QOH, PR, PO and Open Invoices) from 10.7 NCA to 11i (11.5.10) instance.
• Assist the functional team to prepare BR100.
• Customized COGS account generator workflow in Oracle Order Management
• Customized OEOH and OEOL workflow for sending email notification to customer while Book and Ship the order.
• Created new notification Alerts for various business needs.
• Prepared AIM technical documents

Project Oracle Application (11.5.9) support.
Duration Apr2004 – May2005 
Client Confidential – Mexico City, Mexico (Leading Telecommunications Service Provider)
Position Techno-Functional consultant
EnvironmentOracle Application 11i (11.5.9), Oracle 9i/Developer 2000(Forms 6i, Reports6i) on SUN SOLARIS 8.

Project DescriptionThis is purely post implementation support of Oracle Application 11i. Along with application support activity we integrate lots of third party tools with application. FILON, ALTAMIRA, PAYROLL systems were integrated with Oracle General Ledger.

Roles/Responsibilities:

• Identify and solve problems faced by end users when using Oracle Applications
• Support for existing customized objects
• Given Technical support to Telefonica Moviles team
• Design and Development of new reports & customizing application reports as per client requirement
• Develop ad-hoc queries for auditing
• Integrate Third party tools with Oracle Applications.

Project Oracle Application (11.0.3 & 11.5.7) unification.
Duration Nov2003 – Mar 2004
Client Confidential – Mexico City, Mexico (Leading Telecommunications Service Provider)
Position Technical Lead
Environment Oracle Application 11i (11.5.9), Oracle 9i/Developer 2000(Forms 6i, Reports6i) on SUN SOLARIS 8.
Project Description 
Telefonica was using Oracle Application 11.5.7, using the following Modules Oracle Payables, Oracle General Ledger, Oracle Cash Management, Oracle Fixed Assets, Oracle Purchasing and Oracle Inventory. Telefonica purchased another company Pegaso which used Oracle Application 11.0.3. Both charts of accounts were different, so telefonica decided to re-implement Oracle Applications 11.5.9. As along with our team I have implemented Oracle Applications 11i (11.5.9).

Roles/Responsibilities:

• As a Technical lead, I was responsible for mapping the chart of accounts of both 11.0.3 &.11.5.7 applications to Unified application 11.5.9. Both 11.0.3 & 11.5.7 application had different chart of Accounts and 11.5.9 Unification Application also different Chart of account.
• Was responsible for design and development of interface to bring the open documents (PR, PO and Open Invoices) from both 11.0.3 and 11.5.7 to 11.5.9 instance.
• As part of unification I Implemented Oracle Cash management along with our functional consultant and wrote some APIs to load the bank statements.
• Provided technical inputs to the technical team

Project Oracle Application 11.5.4 (HR & Payroll Implementation)
Duration Jun2003- Oct2003
Client Confidential – Monterey, Mexico (Leading manufacturer of truck chassis and engine cradle components in México)
Position Technical Lead
Environment Oracle Application 11i (11.5.4), Oracle 8i/Developer 2000(Forms 6i, Reports6i) on SUN SOLARIS 8.
Project Description 
Metalsa was using Oracle Financial Application 11.5.4 and for Payroll and Human resource management they have used software called TARIK. They have decided to implement Oracle HRMS suit. As along with our implementation team I have implemented Oracle HR, Oracle Payroll and Oracle OTA and self service HR.
Roles/Responsibilities:

• As a Technical lead, was responsible for design and development of interface to bring the data from legacy system to Oracle HRMS 11i.
• Metalsa having a third party tool TARIK to maintain employee information and Payroll system. As along with our functional team we implement Oracle HRMS (Human Resource, Payroll, Oracle Training and Administration and Oracle Time and Labor). We have migrated all the employee information and Payroll Balances from TARIK to Oracle HRMS.
• Creating Locations and HR Organization through API.
• Creating Job, Positions, Grade, Salary and personal payment info. through API
• Creating employees and employee assignments
• Creating elements and element links
• Loading balance from Legacy
• Was involved in mapping of TARIK and Oracle HRMS and design payroll element for Oracle Payroll.
• Was also functionally involved in the integration with Oracle Financials.

Project Oracle Application 11.5.7 – Custom Application SCL Interface extension.
Duration Jan2003- May2003
Client Confidential – Monterey, Mexico (Leading Telecommunications Service Provider)
Position Technical Consultant
Environment Oracle Application 11i (11.5.7), Oracle 8i/Developer 2000(Forms 6i, Reports6i) on SUN SOLARIS 8.
Project Description 
Telefonica was using Oracle Application 11.5.7 along with several third party tools. As along with the technical team, integrated a third party tool SCL with oracle applications 11.5.7
Roles/Responsibilities:

• As a Techno-Functional Consultant, was responsible for design and development of custom application called SCL Interfaces and integrate it with the Oracle Application 11i.
• Telefonica Moviles having a third party tool SCL which is running in all its sales offices which generates invoice, inventory and miscellaneous transactions. These transactions will be generated in a flat file by SCL system by day to day basis.
• The custom application SCL Interface transfers the flat files from SCL server to Oracle Application server through FTP, this process was automated by shell scripts. The successfully transferred files will be extracted into oracle tables and based on the mapping information it generates accounting entries in Oracle General ledger
• Was also functionally involved in the mapping of SCL accounts structure with Oracle application 11i accounts structure.
• Other responsibilities included develop custom forms as per oracle application standard and integrate with the oracle application 11i.

Project Oracle Applications (two 10.7 instances into 11.5.7) - Unification
Duration Jul2002- Dec2002
Client Confidential– Monterey, Mexico (Leading Telecommunications Service Provider)
Position Technical Consultant
Environment Oracle Application 11i (11.5.7), Oracle 8i/Developer 2000(Forms 6i, Reports6i) on SUN SOLARIS 8.
Project Description 
Telefonica is a leading mobile service provider in Spain. It took over the two Mexican mobile service companies CEDETEL and MOVITEL. Both companies were using Oracle Application 10.7 with different structure of Chart of accounts. As along with Oracle Corp. Mexico, we implemented oracle applications 11.5.7 and migrated both instances open documents into 11.5.7 instance.

Roles/Responsibilities:

• As a Techno-Functional Consultant, was responsible for design and development of interfaces for porting data from two instances of Oracle Applications 10.7 to Oracle Applications 11.5.7 for Accounts Payable modules. Responsibilities included building of Interfaces and Preinterface tables, data validation scripts and porting scripts for the open invoices. All type of invoices such as Prepayment, Standard, Credit Memo and Expense Reports were ported through the open interface.
• Was also functionally involved in the design and setup of Accounts Payable module along with Oracle corp. functional consultant.
• Other responsibilities included mapping of 11i invoice interface tables with the 10.7 invoice tables, Extract the data from 10.7 instances prepare scripts to validate the extracted data and port into 11i interface tables.

Project Replace a third party tool SmartDB by PL/SQL
Duration May2002-Jun2002
Client Confidential, Florida, USA
Position Technical Consultant ( Off-shore)
Environment Oracle Application 11 (11.0.3), Oracle 8/Developer 2000(Forms 4.5,Reports2.5) on HP-UNIX 10.2
Project Description 
FRI is using SmartDB to port the sales, purchase information from COMMAND DATA into Oracle Apps. For the replacement project I wrote Auto invoice interface programs to load the COMMAND DATA invoices into Oracle Application, Customer new ship location interface to load the new ship location to existing customer. Through VPN connectivity we are working on the Client Database lying in Florida, USA
Roles/Responsibilities:

• As a Technical Consultant, working along with the off-Shore development team to replace the third party tool (SmartDB) by Oracle PL/SQL for FRI (Florida Rock Industries) which is one of the leading construction companies. Currently, FRI is using software called COMMAND DATA on Oracle Database for Sales and Purchase activity.
• Have prepared ‘Application Extensions Technical Design’ document (MD.070), ‘Perform Unit Test’ document (TE.070), ‘Perform Link Test’ Document (TE.080) and ‘Perform Installation Test’ document (TE.090) for this project. I have extensively used the AIM 3.0 templates for this project.

Project Oracle Application extension and Support
Duration Jan2002-Apr2002
Client Confidential, Chennai, India
Position Technical Consultant
Environment Oracle Application 11 (11.0.3), Oracle 8/Developer 2000(Forms 4.5, Reports 2.5) on Windows NT 4.0
Project Description
As part of AMC (Support contract) we developed new interfaces and reports for the existing application Release 11 for PSEG (Power Sector Engineering Group) Chennai, India, which is one of the leading powers generating company
Roles/Responsibilities:

• Data porting – move the legacy open purchase order and pending invoices into oracle Application.
• Defining Responsibilities and assigning responsibilities to users.
• Creation of executables and concurrent programs.
• Registrations of tables and forms for custom applications.
• Creation of value sets.
• Customization of descriptive flex fields.
• Design and development of custom reports.
• Delivered supporting technical documentation for the customized programs.
• Preparation of test plans & unit/module testing.

Project Oracle Application 11.5.4 (Financial Implementation)
Duration Jul2001-Dec 2001
Client Confidential, Jordan
Position Technical Consultant
Environment Oracle Application 11i (11.5.4), Oracle 8i/Developer 2000(Forms 6i,Reports6i) on Windows NT 4.0

Project Description
As along with the team, developed new interfaces and load the data from legacy system for FASTLINK, Jordan that is one of the leading mobile service provider in Jordan. We implemented Oracle Receivables, Oracle Cash Management and Oracle General Ledger. 
Roles/Responsibilities:

• Data Porting – move the legacy customer and supplier into Oracle application.
• Design and development of custom reports.
• Delivered supporting technical documentation for the customized programs.
• Preparation of test plans & unit/module Testing.
• Have written Customer Interface programs to import and validate current or historical customer information from other systems or flat files into Receivables. Once customer information is imported into the system and validated, the Customer Interface programs are used to import additional data for that customer (such as additional contacts or addresses, Customer Profiles, Bank details) and to update existing information. I have also customized few HRMS reports and alerts.

Project Oracle Application 11.5.4 (Support)
Duration Jan2001-Jun2001
Client Confidential, Jordan
Position Technical Consultant
Environment Oracle Application 11i (11.5.4), Oracle 8i/Developer 2000(Forms 6i, Reports6i) on Windows NT 4.0
Project Descriptions
As part of the AMC (Support) I have involved in the Customization of Oracle Applications Release 11i reports & Developing new financial statement generator reports for The United Pharmaceutical Manufacturing Co Ltd, Jordan which is one of the leading manufacturing company to produce Medicines in Jordan. The modules I have handled are Oracle General Ledger, Oracle Payables and Oracle Receivables. 
Roles/Responsibilities:

• Design and development of custom reports
• Delivered supporting Technical Documentation for the customized programs
• Preparation of Test Plans & Unit/Module Testing
• Developed row sets & column sets for balance sheet, profit & loss statement and income statement in FSG (Financial Statement Generator) as per the client chart of account.
• Created a periodic (daily) alert to send notifications to the receiving clerk about the shipments due on that date.
• Created an alert to send notification to the finance controller when a check, greater than a specific amount is issued.
• Created workflow to send the notification to the person who prepares the vendor invoice to indicate the list of hold invoices.
• Workflow to implement quotation process i.e. notification will be sent to the corresponding sales officer as soon as the quotation is converted into the sales order.

Project PUK Reports
Duration Jun2000-Dec2000
ClientConfidential, Bangalore, India.
Position Project Leader
Environment Oracle7.3/Developer 2000 / Windows NT 4.0

Project Description
Developed an small application in Developer 2000 called “PUK reports” contain Flash Report, Balance Report, Returns Report, Investment Report and Personal Report. Flash report displays the sales turnover, orders, pending orders up to the month of calendar year. This PUK report integrated with third party too LN-REP of lotus notes.

Roles/Responsibilities:

• As a project leader, was involved in design, testing and technical support to the team of PUK Reports for FESTO Controls Limited, Bangalore, India. The PUK reports contain Flash Report, Balance Report, Returns Report, Investment Report and Personal Report.
• Flash report displays the sales turnover, orders, pending orders up to the month of calendar year. Balance Report displays the balance sheet of the company for the calendar year. Personal reports displays the manpower used for the I, II, III and IV quarter separately.
• Investment report displays how much investment made for II quarter & I separately. These are the reports they are reported to FESTO Germany. For these purpose they are having one software LN-REP in Lotus Notes the PUK Report is integrated with this LN-REP.

Project Conversion project (Convert Forms 3.0 application into forms 5)
Duration Jan2000-May2000
Client Confidential, Bangalore, India 
Position Module Leader
Environment Oracle7.3/Developer 2000 / Windows NT 4.0
Project Description: 
As a Module leader, responsibilities included testing and implementation and user training of converted financial accounting system in FESTO Controls Limited, Bangalore, India. The Financial Accounting Package comprises of Cash and Bank Transactions, Journal Vouchers, Accounts Receivable, Accounts Payable and Fixed Asset Modules. This is fully integrated with the customer order processing and Purchase modules. This system takes care of the operations carried out by the warehouse of the CAP at various stages. The various modules contained within this system are purchase order, sales order, invoice, credit note and receipts. The system also enables to generate various General Ledgers and other management reports.

Project Merging of Financial Data & Management Information System
Duration Jul1999-Dec1999
Client Confidential, Bangalore.
Position Module Leader
Environment Oracle7.3/Developer 2000 / Windows NT 4.0
Project Description: 
As a Module leader, was involved in design, testing and technical support to the team of Merging of Financial Data & Management Information System for Vero President Systems Limited, India. The package has been designed to merge the financial data pertaining to various division of the manufacturing company. The package generates report like Trial Balance, Profit/Loss, Balance Sheet, Schedule Statements and Outstanding Analysis for the Company.

Project Customer Order Processing System
Duration Nov\'98- Jun ’99 
Client Confidential, Bangalore.
Position Team Member
Environment Oracle7.3/Developer 2000/Windows NT 4.0 
Project Description: 
As a team member, was involved in conversion, development, and testing of Customer Order Processing System for the client Vero President systems Ltd, Bangalore, India. The on-line Customer Order Processing System is used to computerize the entire sales transactions of both local and export orders. The features are Inquiry Processing, Quotation/ Performa Invoice Processing, Order Processing, and Pick Ticket Processing. It also handles Price Revision, Sales Return, and CRN note generation. This module also has sub modules such as Services, Branch Sales and OEM Discount.

Project EMS (Enterprise Management system)
Duration Feb1997-Oct1998
Client Confidential, Bangalore.
Position Team Member
Environment Oracle7.3 / Developer 2000 / Windows NT 4.0 
Project Description: 
As a team member, have involved in design, development, testing and implementation of Financial Accounting System, Fixed Assets for Vero President Systems Ltd, Bangalore, India. The Financial Accounting System had varied complexities like multiple currencies, multiple divisions, inter division transactions. The Financial Accounting Package comprises of Cash and Bank Transactions, Journal Vouchers, Accounts Receivable, Accounts Payable and Fixed Asset Modules. The package generates MIS statements like Budget Vs Actual, Cash-Flow Analysis, Trial Balance, Profit/Loss Account, Balance Sheet, Age-wise Analysis of Customer outstanding report etc.

The Fixed Assets Package has been designed to cater to the various requirements like creation of Opening Balances for the Assets, Asset Registration, Control Maintenance, Sale/Disposal & Transfer of Assets and Insurance of Assets. The package provides calculation of Depreciation for Provisional and Final. The Depreciation’s are calculated for IT and Company wise.