• Having 4+ years of work experience in Oracle Applications in different areas like analysis, design, development and implementation of business requirements through direct interaction with customers. • Worked in Oracle technologies SQL, PL/SQL, Forms 6i, Reports 6i both development and support. • Experience in working with Oracle Utilities like SQL*Loader, UTL_FILE Package and Interfaces. • Having work experience in Financial (AP, GL, AR), Distribution (PO, OM) and Manufacturing (INV) modules in Oracle Applications 11i. • Development and Customization of Reports, Interfaces, Conversions as per client requirements. • Having ample knowledge in Procure to Pay & Order to Cash life cycles. • Good team player and strong technical and program solving skills.
• Currently working as Oracle Applications Technical Developer in Solix Technologies Ltd, Secunderabad from Feb 2007 to till date. • Worked as System Analyst in Octal Panax Technologies, Hyderabad from Feb 2006 to Jan 2007. • Worked as Programmer in Techmatics, Chennai from June 2005 to Jan 2006.
• B.E (Computer Science) with First Class from Madras University, Chennai, Tamil Nadu in June 2005.
ERP Tool : Oracle Apps 11i (184.108.40.206, 11.5.9) Modules : PO, OM, INV, AP, AR and GL Database : Oracle 9i Languages : SQL, PL/SQL Tools/Utilities : TOAD, FTP, SQL *Plus, SQL *Loader, Putty, Fnd loader GUI Tools : Developer 2000 (Reports 6i) Deployment Tool : Kintana (ECMS, PPM) Operating Systems : Windows, UNIX Knowledge on : XML Publisher, Discoverer
Agilent Technologies, US May 08 -- till date
Agilent Technologies is a world's premier measurement company and provides core electronics and bio-analytical measurement tools to advance the electronics, communications, life sciences research, environmental and petrochemical industries. Agilent have its main operation in US, Japan, Malaysia approximately 25 Countries around the world.
Environment: Oracle apps 220.127.116.11(PO, AP, AR, OM, INV), Developer 2000 and Oracle 9i Role : Technical Consultant
Responsibilities: • Involved in development of reports based on business requirements and registered them in Oracle applications. • Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages. • Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application base tables. • Worked on UTL_PACKAGE and SQL*LOADER for the interfaces and conversions. • Performed the unit testing for the code and migrated the files through kintana tool. • Involved in sysadmin activities and clearing monthly pending transactions.
Conversions: • Developed Customer Conversion to load historical data into Oracle base tables. • Developed Sales Order Conversion to load Historical Orders Data into Oracle Base Tables.
Interfaces: • Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report. • Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package.
Reports: • Purchase Report Detailed Item wise allows you to have a detail study of purchases Made during a given period using XML publisher. • Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details. • Developed Supplier Payments Report using XML Publisher.
Forms: • Designed and created custom form using Forms 6i tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated .fmx executable file to $AU_TOP on forms server of client. • Customized Sales Order Form.
PAXAR Corporation, US Feb 07 - Jan 08
Paxar Corporation is a leader in computer hardware and related services. The Company specializes in manufacturing of printers, security products software control systems and necessary supplies. They have operations in UAE and US
Environment: Oracle apps 18.104.22.168(PO, AP, AR, OM, INV, GL), Developer 2000 and Oracle 9i Role : Technical Consultant
Responsibilities: • Involved in the development of technical documentations, Release notes of reports and interfaces. • Development and customization of reports based on Customer requirements. • Involved in the development of interfaces and Conversions to import the data from legacy systems into oracle application base tables. • Involved in sysadmin activities related to all Concurrent Processing and Programming, Custom Application Development, System Administration, Flex field, Value sets etc.
Interfaces: • Developed outbound interface to extract supplier details data including Payment details with Check for a wide range of dates using UTL_FILE Package. • Developed supplier Conversion to load vendor details from legacy system into Oracle Applications base tables. • Developed interface program to Upload items into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table and wrote PL/ SQL Procedures for all the business validations.
Reports: • Custom report to obtain details on Purchasing, Receiving and Payables with in specified dates. • Customized the Invoice Aging Report to display only not paid Invoices with invoice status should be approved. • Customized Invoice History Report by adding few more details related to Bank (Bank Name, Branch Name and Account Number). • Customized Order Discount Detail Report by adding up two more fields (List Price Subtotal & Selling Price Subtotal) for existing List Price & Selling Price.
Forms: • Customized the sales Order Form using Personalization. It should not raise sales order on week ends or public holidays. • Customized PO Form using Personalization. When ever user enters data on Sunday, Form should get Exit.
Goodman, NA Mar 06 -- Jan 07 Goodman is one of the largest manufacturers of residential air conditioning and heating products. The company operated distribution centers in key states such as Texas, California in North America. Implemented various modules of Finance and Distribution Suit.
Environment: Oracle apps 22.214.171.124(PO, AP, AR, INV), Developer 2000 and Oracle 9i Role : Technical Consultant
Responsibilities: • Working as team member in the offshore technical development team. • Responsible for technical deliverables -- Reports, Data Conversions, etc including documenting the same. • Preparation of technical specifications. • Defining Executable Concurrent Program and assigning in to Request Group. • Delivering the code and Related Documents.
Interfaces: • Worked on Purchase Order Interface to upload the Purchase Order data into Oracle apps Database Tables.
Reports: • Material Transaction Report using XML Publisher. • Customized Print Requisition Report by adding one more field Accounting_Id Description. Only then End User may identify under which the Account is distributed. • Customized Incomplete Invoice Report, Previously the report was working only with Incomplete, after modification the report works for both Complete & Incomplete by taking as bind parameter. • Developed PO Report, in order to get vendor wise cancel details using XML Publisher.
MDC Systems Inc., Detroit, MI Jun 06 -- Jan 07
Environment: Oracle Applications 10.7, UNIX, Forms 4.5, Reports 2.5, Oracle 7.3 and PL/SQL. Role : Junior/Developer Analyst
• Involved in Future Business Model Design, Technical Design, Interface and Conversion Design, Development and Testing, Support function. • Involved in the evaluation of the existing software developed using Access and the migration of this to Oracle as required by the business. • Participated in workshops with users to understand current business structure and to collect additional requirements. • Participated in meetings with management and users and helped draft future business model. • Prepared functional requirements and Technical requirements document and developed modules in the package. • Developed and tested the interface and conversion scripts. • Developed several reports based on user specified criteria. • This project converted Access/Delphi data to an Oracle 7.3 Database. The front-end utilizes Oracle Developer Forms 4.5.