Objective|:

Software design, development. Interested in designing/ developing applications for Oracle RDBMS, Client/ Server Applications, Internet related applications, Oracle Enterprise Resource Planning (ERP)

Professional Summary:

17+ years experience including requirements analysis, specification creation, technical design, development, testing, and documentation, and maintenance, implementation of packaged software, data warehouse, and database administration.

Technical Skills:

Programming languages:
C, Pro*C, COBOL, PL/SQL (with Web Packages), UNIX Shell (ksh), awk
Hardware:
IBM, Sun, HP 9000, Intel Pentium/ 486 PCs
Operating Systems:
Different flavors of UNIX (HP/UX, SCO UNIX, Solaris, AIX).
Novell Netware, Windows 2000 Professional / NT 4.0/ 98/ 95/ 3.1, MS-DOS.
Databases:
Oracle RDBMS 9iAs/8i/ 8.0 / 7.x/ 6.0, MS Access 2.0/ 97.
Extensively used new features of Oracle 8i/ 8.0 including objects, user-defined data types, large objects, nested tables, etc.
Development Tools:
Oracle Forms v3.0, Oracle Report Writer v1.1, Oracle Developer/2000, Oracle Forms 9i/6i/ 5.0/ 4.5, Oracle Reports 9i/6i/ 3.0/ 2.5, Oracle Graphics 3.0/2.5, Oracle Designer/2000, Oracle Designer (Rel 6i/ 2.1/ 1.3), Discoverer and Oracle JDeveloper 3.2.
Internet Based Development Tools:
HTML, Java 2, Oracle Application Web Server 4.0/ 3.0, Oracle Internet Application Server (IAS).

Enterprise Resource Planning (ERP):
Oracle Applications v 10.7, 11.0.3, 11i/R12 (Modules: GL, AP, PO, AR, FA, HRMS, PAY BEN, PA, INV, OM, BOM, Procure to Pay, Order to Cash, Demand to Distribution, Budget to Close, Project Accounting, Costing, calendar/financial period change and Self Serviced Applications such as iProcurement, suppliers, iReceipts, iPayments, iExpenses, iStore, Quality, Inventory, Bills of Materials, Purchases, Order Management, Advanced Pricing, APS, Workflow, Self Service Web Applications, Cost Management, Engineering, Planning Products, and Work In Process)
Others:
Rational Clear Case / Clear Quest, MS Project 97/ 2000, MS Office 97/ 2000
Oracle Data Warehouse, Oracle database administration, PVCS, XML Publisher, Business Intelligence, ERWIN, Taviz and FSG’s.

Employment:

12/04 Till Date,Confidential
Lead Oracle Applications/Architect
Description: Oracle eBusiness Suite Global Implementation. Currently involved with the Global Design of Interfaces, Conversions, Oracle Warehouse builder, Workflow Extensions and Oracle Reports / Oracle Forms/ Oracle Discoverer/Business Intelligence Reports, Procure to Pay, Order to Cash, Demand to Distribution, Budget to Close, Project Accounting, Costing, calendar/financial period change and Self Serviced Applications such as iProcurement, suppliers, iReceipts, iPayments, iExpenses, iStore, Quality, Inventory, Bills of Materials, Purchases, Order Management, e-Order Book,
e- Invoices, Advanced Pricing, APS, Workflow, Self Service Web Applications, Cost Management, Engineering, Planning Products, WEB ADI, Work In Process, Advanced Supply Chain and Planning, DEMANTRA, CRM, OTL and HRMS
and Business Intelligence (OBIEE).
Contribution:

• Complete Design/Development and Deployment of Items, On-Hand Quantities, Inventory Transactions, Price Lists, Modifiers, Qualifiers, Sales Orders, PCARD Interface, GL Everest Extract Interface, Lockbox, Positive pay and Check Printing programs.
• Lead the development team and consultant’s teams globally.
• User training and production support of Oracle Applications 11i/ R12 (Procure to Pay, Order to Cash, Demand to Distribution, Budget to Close, Project Accounting, Costing, calendar/financial period change and Self Serviced Applications such as iProcurement, suppliers, iReceipts, iPayments, iExpenses, iStore, Quality, Inventory, Bills of Materials, Purchases, Order Management, Advanced Pricing, APS, Workflow, Self Service Web Applications, Cost Management, Engineering, Planning Products, WEB ADI, Work In Process, Advanced Supply Chain and Planning, DEMANTRA, OTL and HRMS ).
• Involved in the Customization of Pricing Attributes for Advanced Pricing and FA Account Generator (Workflow). Involved and reviewing the MD50’s and MD70’s for designing and developing Interfaces, conversions and reports for the Phase II
• Developed internal Service Request system by customizing Oracle Forms, alerts and reports
• Utilized AIM METHODOLOGY and created MD50, MD70 and CV40 documents for supporting applications
• Generating the Code Combinations using Account Generator and Workflow
• DevelopedPL/SQL program for Loading the Data from the file into Oracle Custom tables using UTL File utility
• Developed PL/SQL program for Processing the Data for customer and vendor validations and insert into AP & AR interface tables
• Worked on Auto Invoice, Auto Lockbox, and Customer Interfaces in AR module
• Customized Positive Pay Program.
• Customized the Variances reports for executive business requirement
• Customized the Depreciation Reports for Fixed Assets
• Customized the ACH and Positive pay process for sending to Bank
• Designed and developed the Sales Forecast, Raw Material Forecast and Planned Order demand reports by using the Supply Chain and Order to Cash applications
• Customized the AR Lockbox process.
• Designed and developed the Custom Check printing process
• Designed and developed the Segregation of Duties functionality and Access Review reports in Oracle for Sox Compliances
• Designed and developed the Service Request system internally to maintain all the bugs/enhancement requests.
• Designed and developed the Procurement Card Transactions process.
• Designed and developed Global Inventory Details by Account reports.
• Personalized and customized various forms (Shipping and HRMS, mobile, zoom functionality, etc,..) based on the business requirement
• Designed and developed Pick Slip and Packing Slip reports to include the Barcodes and additional business requirements.
• Designed and developed the interfaces to send the data into Content Management System (CMS)
• Designed and developed the WIP inbound and outbound process to load the data from the shop floor to Oracle directly and sends the details back to shop floor system.
• Customized Standard Oracle Un-Received Shipments using reports 6i to include the new required functionality.
• Involved in Unit Testing.
• Imported Customer Information by using Customer Interface in Receivables. Worked on Auto Invoiceto import Invoices, Debit Memos and Credit memos
• Created SQL Loader script to load data into temp tables from AS/400 data files and build program to validate the data for business rules and load the data to Auto invoice interface tables
• Created programs to validate the data received from banks and developed program to create lock box interface lines and header records to lockbox interface tables
• Performed system administration functions such as Creation of Users, Creation of Responsibilities and Set up user profiles specific to applications
• Designed and developed ADP inbound and outbound interfaces for HR, Benefits, OTL and Payroll requirements.
• Working with global users to gather the requirements.
• Involved in user meetings for Gap Analysis
• Coding the Custom Packages, Procedures and Functions for Custom Reports for all the various modules using PL/SQL programs

Environment: Oracle Applications R12, 11.5.10.2, Forms6i/9i, Reports 6i/9i, PL/SQL, Work Flow Builder, OWB, Discoverer, Forms server, Reports Server, Oracle 10g, Oracle 9iAs, 8i, Linux, SUN Solaris, TOAD, ERWIN, PVCS, XML Publisher, BI Publisher and OBIEE

06/02 03/03 and 06/03 11/04
Client:Confidential, Montvale NJ IBM

Description: IBM implemented Oracle applications for A& P. The Great Atlantic & Pacific Tea Company is a family of supermarkets with over 800 stores across the U.S. and in the province of Ontario, Canada. The objective of the project is to implement Oracle HRMS, Payroll, Benefits, GL, AP, PO, AR, FA and Cash Management in place of the existing legacy systems. This project involves data conversion, development of new interface programs, reports, forms and customization of reports and forms.
Contribution:

• Developed a Custom form - Legacy Oracle Cross Reference of Account Combinations for Oracle General Ledger module
• Defining Parent Accounts and Validating and Compiling the Flex Fields
• Helping the User with generating reports with Oracle Financial Analyzer and Standard Request Submission
• Utilized AIM METHODOLOGY and created MD50, MD70 and CV40 documents for supporting applications
• Generating the Code Combinations using Account Generator and Workflow
• Utilized Workflow Builder 2.6 to set notification/messaging system in order to analyze and improve relationships
• Training the end users with FSG’s
• Designed and Developed the Bonus Savings coupons interface Program
• Developed the Vendor Invoice System form to setup the Batch number, invoice number, Remote Office Addresses, Remit to Address and GL Accounts by division for Payables and Receivables modules
• DevelopedPL/SQL program for Loading the Data from the file into Oracle Custom tables using UTL File utility
• Developed PL/SQL program for Generating the invoice and Batch numbers for both AR customers and AP vendors by reporting division
• Developed PL/SQL program for Processing the Data for customer and vendor validations and insert into AP & AR interface tables
• DevelopedLogging Errors, Invoice Summary reports by Batch, Invoice Register, Invoice Prints reports
• Developed Rental interface program to load the data from the Domain System to Oracle Payables, This program looks up the Vendor number and Site Code based on the Vendor Site ID and updates the Vendor number and Site Code into the custom tables. This program also validates the GL Account against the Oracle GL tables to verify it’s a valid GL Account or not.
• Developedcustom program calls standard Open Interface Import program by Source and batch
• Developed a Custom Form that facilitate the user to correct any records that are in Error while loading into AP Interface Tables
• Designed and developed CCI Interface program to load the data from the Legacy system to Oracle Accounts Payables Interface tables based on the Business Requirement.
• Developed a custom program, validates headers and details and inserts into ORACLE Standard interface tables. This program also inserts the Vendor number and Vendor name into Oracle Standard Interface Tables based on the Vendor Site Id
• Worked on Auto Invoice, Auto Lockbox, and Customer Interfaces in AR module
• Customized Standard Oracle Un-Received Shipments using reports 6i to include the new required functionality.
• Involved in Unit Testing.
• Imported Customer Information by using Customer Interface in Receivables. Worked on Auto Invoiceto import Invoices, Debit Memos and Credit memos
• Involved in mapping of bank statement and wrote custom script to upload Bank Statement information into Oracle Cash Management
• Worked on Reconciliation Open Interface which involves reconcile bank statements in Oracle Cash Management
• Created SQL Loader script to load data into temp tables from Main Frame data files and build program to validate the data for business rules and load the data to Auto invoice interface tables
• Created programs to validate the data received from banks and developed program to create lock box interface lines and header records to lockbox interface tables
• Configured Work Flow mailer to send Approved Standard PO’s, Blanket PO’s as email attachments to Suppliers.
• Setup and Configured Standard Purchasing Module Alerts
• Defined concurrent programs and assigned to request groups. Performed registration of concurrent programs, implemented PL/SQL for invoking concurrent programs, defined value sets and parameters for custom reports, Performed system administration functions such as Creation of Users, Creation of Responsibilities and Set up user profiles specific to applications
• Working with users to gather the requirements.
• Did the Entire Employee Conversion process using appropriate Oracle provided API’s. Employee, Address, Assignments, Salaries and Salary History, Phones, Elements, Special Information Types.
• Involved in defining elements, element links, balances, element sets, consolidation set and assignment sets
• Designed and Developed several custom forms to Enter and Maintain for Entitlements, Union dues, New Hires, Update Employee and Void Check.
• Designed and developed an inbound interface to load the legacy time entry data to Oracle HRMS. This program runs before every payroll.
• Developed Merrill Lynch National Union (MLNU) 401(k) Plan Contribution out bound Interface. These Interface programs create a data file using the UTL_FILE package. This program runs after every payroll run and sends the data file to Merrill Lynch.
• Developed Personal data sheet report that shows the employees Medical, Dental, Life insurance and other information under “Full Time Non Union Ben flex Program”. The life events included in this report are open, hired, Part time to Full time and Union to Non Union
• Customized the Check Writer and Deposit Advice reports for US and Canada.
• Involved in fixing the production issues for CIGNA Interface and developing CIGNA interface for Open Enrollment.
• Involved in fixing Custom Forms issues
• Supporting all the production issues.
• Involved in user meetings for Gap Analysis
• Involved in supporting Payroll and Benefit FAST FORMULAS
• Involved in fixing the Christmas Bonus Interface and Reports for Canada
• Involved in supporting Entitlements and Accruals interface issues.
• Coding the Custom Packages, Procedures and Functions for Custom Reports for all the financial modules (GL, AP, AR, FA, PO,CE) and HRMS modules Payroll, HRMS using SQL, PL/SQL
• Developed Custom themes and Reports with Oracle Applications Desktop Integrator (Oracle ADI)
• Utilized Workflow Builder 2.6 to set notification/messaging system in order to analyze and improve relationships.

Environment: Oracle Applications 11.5.9, Forms6i/9i, Reports 6i/9i, PL/SQL, Work Flow Builder, Discoverer, Forms server, Reports Server, Oracle 9iAs, 8i, AIX V4.3, TOAD, PVCS

03/03 06/03
Client: Confidential

Symphony ( Oracle Applications (11.5.8) Implementation ):
Symphony is an Oracle Applications 11.5.8 implementation project involving converting existing legacy systems to Oracle Applications environment and customizing standard Oracle functionality.

• Prepared technical specifications for customizations in General Ledger, Order Management, Receivables, Fixed Assets, Payables, Receivables, Inventory and Purchasing.
• Developed customizations in General Ledger, Order Management, Receivables, Fixed Assets, Workflow, Payables, Inventory and Purchasing.
• Developed interface program between Payables and Vertex for use tax calculation.
• Developed conversions for Fixed Assets, General Ledger
• Forms Development included writing PL/SQL packages and cursors..
• Forms Development, wrote pl/sql packages having procedures and cursors to develop customized forms pertaining to Customer in Order management such as Stand Alone Customer Info form, Order Import Error Management Form, Customer Frieght Account Form, that interact with Order to Cash modules
• Involved in implementation of OM moduleRel 11i.
• Involved in data conversion from Legacy system into Oracle thru API (interface process). Item imports, Cost detail imports, Routings, ECO and On-Hand Quantity data import. Same kind of work performed last year in adding another manufacturing unit
• Performed the whole Order Cycle, which includes Booking, Pick Release, and Ship confirming, and Interfacing to Receivables, Complete Line and Complete Order. Customized a report On time Delivery Analysis Report’ which gives detailed output of how many orders are shipped early, late and on time for each customer
• Bookings Adjustments tracking system and developed various Forms, Reports, Database Triggers and SQL procedures related to this task.
• Picking & Pack Slip
• Customization of Sales Order Acknowledgement report
• Order import error management form
• Custom Product Table Maintenance Form
• Registering forms using Application object Library (AOL), More than 50 Data Extract, SQL*Scripts and Reports developed for OE module alone.
• Worked on Oracle Order Import API to validate and load the PO information from the interface tables into Oracle Order Entry (OE)
• Customized the Workflow for the Order Line flow
• Developed many reports like Pick Slip, packing Slip, Mailing Label for shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management and also created new reports as per client requests
• Customization of Single Invoice Format report
• Customer Freight Account form
• Developed Item Entry form enhancement, will enable item information, additions and changes, in one simple form with all of the required item fields. Due to the fact that relevant item master information is held in several different forms (Item Master tabs, Item Category Assignments, Item Catalog Assignments, Sourcing Rule Assignments and Item Cross-References), this will significantly decrease the amount of time required to perform item information adds or changes.
• Developed Batch/Bulk Update enhancement will enable the user to make mass changes to a list of item’s information through the use of an Excel spreadsheet template. The Excel spreadsheet will then be converted to a flat file format and uploaded to the Oracle system. This will give specific Symphony users from the management Planning and Logistics department the ability to make mass change to item information in a timely manner.
• Customized The Separate Remittance Advice report is intended for Account Payable to complete the payment function.
• Customized the CIP Capitalization, Asset additions reports for fixed assets module.
• Developed the GL Inter company program for Invoices, which are frequently entered in AP with expense lines crossing many of the companies. The original design stated that these inter company transactions would be accounted for by using a GL process called Enhanced Inter Company Accounting. Unfortunately, the journals that are created in GL from AP are summarized in a way that results in many companies having out of balance credits and many companies having out of balance debits. With this kind of ‘many-to-many’ inter company transaction. It is not possible to determine which company is dealing with which one.
• Developed the Check Issue Interface Program, on a monthly basis, company sends the bank a file of all checks that have been issued for the month. This is used as a control for the bank to see what checks have cleared versus what checks have been issued. The bank then sends to a statement that outlines the checks issued that have cleared, the checks issued that have not cleared and the checks cleared that company did not say were issued.
• Utilized Workflow Builder 2.6 to set notification/messaging system in order to analyze and improve relationships

Environment: Oracle Applications(11i) ,Workflow Builder,Vertex, Oracle, Forms6i,Reports6i, PL/SQL, PVCS, TAVIZ

10/99 04/02 Confidential, MI
Software Engineer, Technical Lead

• Crystallize is business change automation software for companies using Oracle Applications ERP. Crystallize Solutions enable companies to rapidly complete information technology projects driven by business changes.
• Developed application codes that integrate with and have the same look and feel as Oracle Applications.
• As a Technical Lead, responsible for Solution product requirements gathering, Solution product design & development, Solution product gap analysis, Development of solution product new features & maintenance of existing product solution.
• Project support for clients, managing the technical team.
• Developed a web-based system to download demo programs for some of Crystallize products like Duplicate Detector. The web-based system was developed using Java servlets and later converted to JSP. The system allowed users to registered at the Crystallize web site and download demo applications. The demo applications run against the Oracle Apps and present statistics such as the number of duplicate customers in the ERP based on certain pre-defined rules. The output is generated in tabular as well as graphical format.
• The demo utility itself was developed as a Java application using JDeveloper.
• Ran EXPORT, IMPORT for Load and populating data using Oracle Jdeveloper3.2.
• Provided on-call to business and technical support to crystallize’s various projects.
• Utilized ORACLE APPLICATIONS 11i/11.03/10.7, ORACLE FORMS 6i/5.0/4.5/, ORACLE REPORTS 6i/3.0/2.5, DEVELOPER 2000, PL/SQL and SQL to create and customized databases.
• Normalized Logical and Physical database design by utilizing ERWIN and DESIGNER 2000.
• Participated in the planning, implementation and customization of ORACLE FINANCIALS 11i applications.
• Involved in the creation of database and database activity, performance tuning.
• Utilized Application modules, e.g., GL, AR, AP, PO, HR, PAY,INV, OE, FA and PA for creating database functions.
• Utilized AIM METHODOLOGY and created MD50, MD70 and CV40 documents for supporting applications
• Wrote PL/SQL scripts.
• Solved the day-to-day database problems.
• Designed, calculated and resized TABLESPACES, TABLES, INDEXES, ROLLBACK SEGMENTS and TEMPORARY SEGMENTS.
• Restored utilities through UNIX SHELL SCRIPTS to run EXPORT, IMPORT for backup and restore.
• Created and refreshed client databases utilizing ORACLE 11i, ORACLE 7.x/8.x/8i DEVELOPER 6i, FORMS 4.5 and REORTS 2.5.
• Utilized ERWIN and DESIGNER 2000 for database modeling.
• Mapping and clean up of the existing data prior to loading the data into the new Oracle Database and reverse engineering the database definitions using Oracle Designer.
• Analyzed and migrated data from a number of different databases into a single Oracle Database.
• Tuned applications and stored procedures using Analyze Table, Explain-Plan, Trace and Tkprof utilities.
• Wrote scripts to create tables and their corresponding database triggers, sequences, synonyms, indexes and constraints. Also granted appropriate privileges on these objects to the users.
• Developed Menu module and handled security by granting appropriate access to users depending on their roles.
• Designed and maintained data model using Oracle Designer.
• Used SQL*Plus interface for adhoc querying, SQL statement creation and testing, and report generation

Responsibilities included data conversion from Oracle Applications ver 10.7 to 11i and 11.0.3 to Oracle applications ver 11i. Converting Oracle Forms 3.0 to Oracle Forms 4.5 and Oracle Forms 4.5 to Forms 6i, product requirements gathering, product design & development, product gap analysis, development of new features & maintenance of existing product solution, client project support. I managed a team of 6 developers and testers.

Environment: Oracle 8i/ 8.0, Oracle Applications v10.7, 11.0.3, 11i on IBM/ Sun/ HP machines. Object related features for Oracle 8i/ 8.0. Developer Oracle 2000 (Forms 6i/ 5.0, Reports 6i/ 3.0), Oracle Designer 2000 (Rel 2.1), Designer 6i, PRO*C, Oracle Internet Application Server (IAS), Oracle Application Server 4.0, SQL Loader, Pro*C, PL/SQL, JAVA, Servelets, JSP, J Developer JavaScript, JInitiator, Oracle 9IAS(Internet Application Server), Forms server, Reports Server SQL*Plus, Windows NT, UNIX, SQL Loader, Pro*C, Business Objects, Toad and JDeveloper 3.2 on Windows NT 4.0/ 2000 OS.

7/98 9/99,ConfidentialHouston, TX
Oracle Technical Consultant
Client: Confidential FL, USA
07/98 09/99
Position: Oracle Technical Consultant

• Involved in development, customization and data migration into Oracle Applications project.
• Involved in the creation of database and database activity, performance tuning.
• Utilized Application modules, e.g., PO, INV and PA. Involved in the customization of forms and reports using developer/2000 tools and loaded legacy data into Oracle applications modules.
• Familiar with registration of new programs in Oracle Applications as concurrent programs. Involved in data load using Interfaces to load legacy data into Oracle modules
• Used SQL * Loader and PL/SQL to load data into Apps production tables from flat file via temporary tables.
• Worked as a member of Oracle Applications ERP Data Migration Support Team.
• Responsible for registration of new programs in Oracle Applications as concurrent programs.
• Used UTL_FILE packages, DBMS Packages and PL/SQL to develop batch programs.
• Developed “Electronics File Transfer Payment” programs to automate payment transfer.
• Wrote Shell scripts that were directly called from Oracle Applications.
• Conducted training on SQL, PL/SQL and Oracle Developer.
• Prepared design and deployment documentation provided deployment and data migration services and assisted with user training.
• Involved in registering the reports, screens and batch programs, unit testing, and verification with users.

Environment: Oracle 7x, Oracle Applications v10.7 on Sun Solaris. Developer 2000 (Forms 4.5, Reports 2.5), People soft, SQL*Loader ,PRO*C, PL/SQL, SQL*Plus, Windows NT, UNIX, SQL Loader, Pro*C, Business Objects, Toad on Windows NT 4.0/ 2000 OS

9/94 6/98,ConfidentialIndia
Software Engineer
Worked with team of four software engineers to develop airline reservation system for airline travel. Wrote the PL/SQL sub programs, and database triggers for the reservation module. Designed users interface screens, showing alerts, listing the values and wrote various validation and interface triggers. Had extensive interaction with the users, and was responsible for implementation and on-site training for users.

Environment: Oracle 7.2, Developer 2000 (Forms 4.5, Reports 2.5) and PL/SQL 2.2 Windows NT3.51

7/93 8/94,Confidential, India
Customer Support Engineer
Responsible for assembling and trouble shooting of the systems, installation of networks and operating systems(Unix, Novell NetWare, Windows NT) and installation of software for numerous clients.

Education:

Bachelor of Engineering (Electronics)
Advanced Diploma Course in Computer Application