Resume 2

Visa Status : H1B held by CiberWay Inc., Open for both Contracting & Permanent Offer. Rate 35 dollars per hour for NYC/NJ.

Technical Summary:

Over 12 years of IT experience with strong Database Development of business application software using Oracle tools i.e. Developer 2000, Oracle Financials 10.7 to 11i and Data Warehouse, Business Intelligence with Discoverer 3i, 4i and COGNOS, Impromptu. 4 years of Oracle Financial 10.7/11i. General Ledger, Financial Statement Generator, Accounts Receivable, Accounts Payable, Order Entry, Order Management, Fixed Asset, Purchasing, iProcurement, Oracle Workflow, Application Object Library, XML Gateway & Oracle EDI e-Commerce Gateway, Discoverer 3i,4i . Including 4 years of Manual Testing, designing and developing test methodologies and test plan .

Implemented full life cycle project in iProcurement and core purchasing modules and carried out end to end integration between iProcurement, Core purchasing, Payables, Fixed assets and General Ledger. Experience in preparation of test cases, application testing Implemented full life cycle and upgrade projects. Strong PL/SQL coding experience using packages and stored procedures. Two Years of Discoverer 3i/4i Administrator and User Experience, including maintenance of Business Area and Work Book. Conversion of Oracle Financial 10.7 to 11i Developer 2000 and Oracle 7.3 to 8i Forms 4.5, Forms 5.0,Forms 6.0, Forms 6i and Reports 2.5, Reports 3,0, Reports 5.0, Reports 6.0,Reports 6i and Oracle Discoverer 3i, 4i Data Conversion with SQL Loader ver 7.3,PL/SQL ver 2.3.4

Technical Skills:

• Oracle Tool: Oracle 8i/8.X/7.X, Developer 2000 Forms 6i/6.0/5.0/4.5 and Reports 6i/6.0/3.0/2.5 , Designer 2000, SQL PLUS 8/3.3, SQL*Loader, Oracle Discoverer 3i

• Languages: PL/SQL, Pro*C, FoxBASE, Clipper.

• Operating System: Windows NT/98/95, Windows 2000, Unix and DOS 6.x

• Hardware: IBM PC compatible with Intel Pentium

• ERP: ORACLE Financial 10.7/11i.

PROFESSIONAL EXPERIENCE:

Developed interfaces in Oracle Purchasing and iProcurement.

• Upgradation of 10.7 to 11i and implementation of Self Service Purchasing 5 SSP5 Oracle Purchasing and iProcurement, Workflow.
• Implemented the upgrade project from Oracle financials 10.7 to 11i in a multi org, multi currency environment. Implemented an integrated iProcurement module SSP5, AP, PO for providing web enabled inquiries for merchant purchase orders, inventory availability and vendor purchase orders.
• Configured the set ups and validated the set ups in core purchasing and iProcurement modules and carried out end to end integration between iProcurement and GL modules.
• Carried out edi Gateway implementation for catalogue import and defined the code conversion values between the external suppliers system and Oracle Applications
• Created PO Approval hierarchy as per user requirements. Configured the workflow for requisition and PO approval including configuring the workflow process, mailing notifications and setting the profile options for iProcurement and auto creation of purchase orders during requisition import.
• Carried out initial catalog import and defined the mappings between catalog service providers and Oracle Purchasing. Setup various Account Regions, Procurement cards, attachments, catalog types, internal and external source catalogs. Performed application set up for AP and PO.
• Setup organizations and set of books in a multi org structure, including carrying out consolidation and translation in primary and reporting set of books before switching to multi org. Imported requisitions using Core Purchasing interface tables.
• Created template expense reports, enabled descriptive flexfields in the Excel spread sheets, customized documentation and messages by modifying the standard help files for the self-service expense module. Customized the Workflow process of expense reports by modifying existing procedures and developing new procedures in the Web Expense PL/SQL packages.

Loading the following through Oracle e-Commerce Gateway.

• PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, V_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE.
• Loading Some of the table using XML Gateway.
• Defining Suppliers Supplier Performance Evaluation
• Defining Items Locations, Organizations, Unit of Measure etc.

Developing and Customizing Impromptu Reports:

• Customized data by adding calculations, summaries and functions.
• Queried from different database tables as per the requirement.
• Using Portfolio, reports were presented Created List Reports and Cross Tab Reports and Drill Through reports.
• Created the Business Mix report and Top Ten reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created reports in HTML format for easy navigation of data from web browser.
• Created standard and Ad hoc reports using Cognos Impromptu tool.

Discoverer 4i Administrator Responsibility

• Identifying User requirements.
• Building useful and robust business area choosing the database tables that best meet requirement.
• Control User access to business area.
• Creating usable relational structure in EUL with joins and complex folders.
• Creating Summary tables to improve performance.
• Scheduling workbooks for a user or role.

Discoverer 4i User Responsibility

• Building Workbook in Discoverer 4i and edited the existing workbooks; adding/editing worksheets.
• Defining calculations, Formatting worksheets.
• Pivoting data, Applying exceptions.
• Creating/editing graphs.
• Creating/editing parameters.
• Preparing Reports for printing, Sending Reports with emails, Scheduling Reports.

Environment : Oracle 8i, Oracle Financial 11i,Oracle Purchasing, Oracle SSP5, Oracle iProcurement, Oracle Workflow Builder, Discoverer 4i, COGNOS, Impromptu.

Boston Speakers is a company involved in manufacturing Speakers for Audio systems Stereo, TV, Car etc .

Responsible for the development and testing of FSG reports in version 11i of Oracle Financials.

• Summary Balance Sheet.
• Summary Income Statement,
• Detailed Balance Sheet,
• Internal Net sales,
• Internal Quarterly/Monthly Operating Statement.
• Marketing Department Detail.
• Manufacturing Department detail
• Internal Monthly Cost of Goods Sold Statement.
• Cash Flow Statement.
• Summary of Total Manufacturing.
• Summary of total G & A
• Summary of Total Engineering
• Summary of Total Sales & Marketing.
• Columnar Income Statement OEM & Core
• Columnar Income Statement OEM etc.

Developed interfaces in Oracle Purchasing in Oracle Apps. 11.5.4.

• Loading the following through Oracle e-Commerce Gateway. PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE.
• Loading Some of the table using XML Gateway.
• Defining Suppliers Supplier Performance Evaluation
• Defining Items Locations, Organizations, Unit of Measure etc.
• Purchase Requisitions import, Creating Requisitions using templates.
• Creating internal requisitions, Auto creating requests for quotations
• Managing Standard P.O., Blanket Purchase Agreements, Planned and Contract P.O., Auto creation of P.O.
• Managing P.O. Receipts, Defining document security.
• Customization in Work Flow
• Customization of Oracle forms & Reports of Purchasing module.

Oracle iProcurement 11.5.4 setup & Oracle Workflow.

• Configuring Account Region, Defining Information templates, Realms, Setting up Procurement Cards, setting up attachments, profile options.
• Loading cataloge data from internal and external sources.
• Customizations of iProcurement Workflows like P.O. Requisition Approval, P.O. Doccumnt Creation, Account Generator, P.O. Send Notifications, Confirm Receipt workflows.
• Created Workflow process definitions by using Oracle Workflow builder like Item types, lookup types, messages, Activities, Attributes and roles.
• Defined Standard API s for PL/SQL procedures.
• Customized Oracle default workflow API s.

Environment : Oracle 8i, Oracle Financial 11i, General Ledger FSG Financial Statement Generator , Oracle Purchasing, Oracle iProcurement.

Toysrus.com is the Internet division of Toys R Us. It sells toys through Internet in collaboration with Amazon.com. This company sends the toys to the warehouse of Amazon.com. Amazon.com sells the toys to customers through Internet.

There was Oracle Apps 10.7. That was upgraded to 11i.

Some of the forms were upgraded using flint 60.All Customized reports has been converted to 11i using Reports 6i Some of The Report Names: PO Summary, Open Requisition /PO Reports, GL Accounts Summary.

Responsible for the in-house development of the package including the Accounts Receivable, Purchasing and Payables and Order Management of Oracle Financials. The design was standardized with template forms, Tool Bar, Menu, Library and database packages and procedures. Responsibilities included modification of the existing forms and reports and registering those in Application, using Application Object Library of Oracle Financial, solving user vantives for existing forms and reports.

This development work was done using Oracle Forms and Oracle Reports and Application Object Library of Oracle Application, PL/SQL and registered in Application. Also written packages and procedures, which are linked with the forms and reports.

Order Management Project : Setting up Oracle Order Management including Profile Options, Enabling Order Management Parameters, Defining taxation rules, Quick codes, Freight and special charge types, Credit types, Price lists, Price agreements, Shipping tolerances.

Loading the following tables through Oracle e-Commerce Gateway : OE_HEADERS_INTERFACE, OE_LINES_INTERFACE, OE_CREDITS_INTERFACE, OE_CREDITS_INTERFACE, OE_PRICE_ADJ_INTERFAC, OE_LOTSERIALS_INTERFACE

Managing Orders: Entering sales orders, Closing orders, Scheduling orders, Copying sales orders, Entering returns, Canceling orders and returns, Applying and releasing holds, Pricing orders, Item cross referencing, Outbound purchase order acknowledges, Scheduling order concurrent program. The forms of the above screens were modified .

Modifying standard reports as per users need: Comprehensive order detail report, Sales Order acknowledgement report, Sales orders and purchase order discrepancy report, Order discount detail and summary report, Unbooked orders report, Returns by reason report, Salesperson order summary report, Defaulting rules listing report.

Discoverer 3i Responsibility

Used Oracle Discoverer 3i for building new workbooks, modifying existing workbooks. Used most of the Discoverers features for the Management Analysis. Such as pivoting and drilling up and drilling down data. Creating graphs and preparing reports for printing. Scheduling reports and shared the worksheets with other users. Created parameters and conditions for the worksheets. Sending Reports to management personnel via email.

Environment : Oracle 8i, SQL/Loader, Forms 6.08, Reports 6.0, PL/SQL 2.3.4, Oracle Designer 2000, Oracle Financial 11i G.L., A.R., AP, PURCHASING,ORDER MANAGEMENT, Oracle e-Commerce Gateway , Oracle Discoverer 3i, Windows 2000/98, Unix.

Center for Claims Resolution CCR is a company formed by eighteen companies, who sells Hazardous materials and chemicals. People who suffer from these materials and chemicals Files law suit against these companies. CCR settles these claims with some amount of money and avoids the lawsuit procedures.

Project: The task is to migrate the operations with the objective of optimal modifications in existing business processes and help the incoming unit to fit into corporate business practices and set up specific to Accounts receivable.

• Analyze the requirements of the corporate unit about safeguarding the resident data against the incoming data and users. As a switch over to multi org is not feasible a work around through Folder security has been suggested and to be implemented
• Analyze the business practices of the migrating unit, study the business practices of the corporate unit and perform Gap Analysis.
• Suggest the optimal operating practices and participate in the process of merger of the two units from Oracle Receivables point of view.
• Troubles shoot the problems in the modification of standard and customized Oracle Receivables reports.
• Analyzed the business process and collected the test cases. Executed the test cases as per the schedule. Performed Unit test and Integration test. Directly interacted with the end user and was responsible for user acceptance.

Environment : Oracle Designer 2000, Oracle 8i, SQL/Loader, Forms 4.5, Reports 2.5, PL/SQL 2.3.4, Oracle Financial 11, Windows NT/95, Unix.

As a senior Programmer/Analyst, involved in the development of Beneficiary, Medical Service Providers, Contact Tracking System, in short BPCT using Oracle Financial 11.0 AR , Designer 2000 and Developer 2000 Forms 5.0/Forms 6.0, Report Builder 3.0/Report Builder 6.0.

The Beneficiary, Provider and Contact Tracking system is complaints, grievance logging and maintenance application to assist Michigan Department of Community Health to function well and provide better customer service for their Medicaid and Health care Beneficiaries.

Major components includes Data Modeling, User and System Requirement analysis, Application and Systems Design using ORACLE Designer 2000, Developer 2000 for Forms and Reports and EDI Gateway interface with Bull mainframe to fetch the existing Beneficiaries, Providers and Health Plan information using C program to access GTEA Bull mainframe gateway, Oracle External Procedures and Stored procedures to capture the stream data passed.

Highlight of this application is the Online Interface with Oracle and Bull Mainframe and was successfully implemented in Michigan Department of Community Health MDCH for the first time and this has created more opportunities for the client to develop and implement more new Oracle Projects without migrating their existing and other mainframe applications.

Other responsibilities include Data loading and conversion to oracle from other products. The source data were in FoxPro. Programs were written in FoxPro to clean the data. Then, those data was transferred to Oracle Table through SQL Loader. Now, It was found that there is no key item in the data. So the data was sent to Bull Mainframe through GTEA / PL/SQL programs to fetch the key items by matching First Name and Last Name. We got multiple records from Bull Mainframe. Those data were loaded in Excel Spread sheet and sent to the end user to pick one record out of those multiple record. This clean record was again loaded to a Temporary Table in Oracle. From this Temporary table, the data was distributed to different working tables through PL/SQL.

Environment : Oracle 8.0, Oracle Financial 11.0, SQL Loader, Forms 5.0 / Forms 6.0, Reports 3.0 / Reports 6.0, PL/SQL 2.3.4, Oracle Designer 2000, Oracle Developer 2000, Windows NT/95, EDI Gateway.

As a senior Programmer/Analyst and ERP consultant, involved in the development of General Ledger Reports, using Financial Statement Generator.

Responsibilities included defining Row sets, Column sets, Content sets, Display sets, Row Orders and analyzing the business functionality. Coding and testing all financial calculations involved in the reports such as

• Cost of Goods sold,
• Cost of Production,
• Controllable Cost Detail,
• Advertising Summary,
• Greyhawk Penny Report,
• National Net Revenue,
• Income statement,
• Expense Statement,
• Budget vs. Actual by Prime,
• Custom General Ledger Detail,
• Profit and Loss Summary,
• Balance Sheet,
• Tax Q-21 and some others.

Other responsibilities include Data loading job; i.e. Loading GL_INTERFACE table from a flat file. Development of new programs using PL/SQL, Reports 3.0 and Forms 5.0, packages and procedures. Besides this, has maintained AR package. The responsibility was changing the existing forms and reports of customized Accounts Receivables.

Environment : Oracle 7.3, SQL/Loader, Forms 5.0, Reports 3.0, PL/SQL 2.3.4, Oracle Financial 10.7, Financial Statement Generator, Windows NT/95, Unix

ABC Software, Inc is a Houston based Software Consulting/development Company provides Various services such as Database optimization. It has clients in all over world 50 countries .

To keep track of the sales and after sales services, The Company has developed an account package in Oracle Financial 10.7. I was involved with Accounts Receivable system. Apart from Oracle Corporation s fixed modules, the company has added its own modules like Revenue accounting, billing, licensing etc. The design was standardized with template forms, Tool Bar, Menu, Library and database packages and procedures. Responsibilities included modification of the existing forms and reports and registering those in Application, using Application Object Library of Oracle Financial, solving user vantives for existing forms and reports. The development work includes new forms and reports like

• Revenue Recognition Summary State Wise ,
• Credit Memo for converted Invoices,
• List of Orders not billed
• Four types of Invoice Register.

Designed and developed test methodology and test plan and test schedules. Analyzed the business process and collected the test cases. Executed the test cases as per the schedule. Performed Unit test and Integration test. If any discrepancy, discussed with the design team and re-implemented with the modified programs.

Environment : Oracle 7.3, SQL/Loader, Forms 5.0, Reports 3.0, PL/SQL 2.3.4, Designer 2000, Oracle Financial 10.7 AR, AOL , Windows NT/95, Unix.

As a senior consultant for Torren Standard, involved in design, development and Implementation of Flight safety parts system. It is a quality control system dealing with various part numbers, their characteristics, and safety category, model no. and other details for the parts used in space shuttle of NASA, helicopter and airplanes. Used Designer/2000 extensively during design phase of the system.

Responsibilities include all master file maintenance of safety history records, entry edit and query screen and overall project management. Designed the screens in Forms 4.5 and written all the triggers and procedures required.

Environment : Oracle 7.3, SQL/Loader, Forms 5.0, Reports 3.0, PL/SQL 2.3.4, Designer 2000, Oracle Financial 10.7, Windows NT/95, Unix Server.

As a lead, developed General Financial Accounting system for VideoElectronic Services Limited, a leading manufacturer of large-scale electronic products. Responsibilities included maintenance of various masters, sales/receipts transaction, sales/receipt register bill printing, dealer wise aging report, product category wise report, ledger printing, reminder to debtors, stock list printing.

Developed a system to handle the Customers/share holders letters and action taken by the company. Responsibilities include feasibility study and need analysis, design, coding, testing and quality assurance of various data entries and reporting module. Also, performed code walk through of fellow team members while managing a team of 10 programmers.

Developed Investment Accounting System to keep track of the various investments made by the company in the industrial sectors. The system consists of various module such as bill discounting, inter corporate deposits, hire purchase, lease finance, properties, investments, equity shares and debentures, daily payment reporting and voucher printing. Developed Share Debenture, Public Issue system to manage large and small public issues of a company. The system includes development of data entry programs, reporting required by Securities and Exchange Board of India, Certificate and Dispatch Report Printing, Bank Reconciliation reporting, Allotment Register, Refund Register and online queries.

Developed Share sub broking system to manage the customer query matching i.e. the sale and purchase of a particular script between the customer club, share purchase /sale entry, receipt entry bill printing and outstanding reporting.

Environment : Oracle 7.0, SQL/Loader, Forms 4.5, Reports 2.5,PL/SQL 2.3.4, Designer 2000, Windows 95, Novel LAN 3.1

As an analyst, developed Flat Sales System for Lodha Group to manage the Flat Sales activities to the customer. This system is used to collect installments from the customers and processes receipts, Invoice Printing, payment notice, customer wise outstanding reports are processed using these systems. Responsibilities included analysis, coding and quality assurance of the various modules such as Building Master Maintenance, Installments Entry, Receipts, Notice Printing and user training.

Environment : Oracle 6.0, Pro*C, SQL*PLUS, Novel LAN 3.1, DOS 6.x

As an analyst, developed Inventory Control System for Konkan Synthetic Fiber to manage the warehouse activities of cotton, thread and clothes. Responsibilities included analysis, coding and quality assurance of the various module such as Purchase Order and Issue slip entry, Inter warehouse transfer entry, Master maintenance and stock reports.

As a programmer, developed Financial Accounting System for Virash Diamond Company and Humphrys & Glasgow. Responsibilities included coding and quality assurance of the various modules such as maintenance of Department master, Customer master, General ledger, Sales register, Purchase register, Profit & Loss account, Trial balance, Balance sheet and Age wise customer outstanding report. As a programmer, developed Diamond Manufacturing System for Virash Diamond Company. Responsibilities included maintenance of Master and Transaction file, Export details report and Weight Loss report. As a programmer, developed Container Activities System for Kaybee Marine Pvt. Ltd. Coded and implemented data entry of Import and Export manifest, detention and transport charges, Billing and general ledger.

EDUCATION:

Bachelors Degree in Science, India
Diploma in Computer Science, India
Certificate Course in UNIX, Microsoft C, Oracle 5, Forms 2.3, Pro *C, India
Certificate Course in Oracle 7.3, Developer 2000 from Concourse Information Tech., India
Certificate Course in ORACLE FINANCIAL 10.7 from Concourse Information Technology, India
Certificate Course in Data Warehousing ERWIN, Cognos, Informatica, Business Objects, Data Junction, Microstrategy