Oracle System
Resume:
Title:Technical Instructor
**********@*******.***
Document
Source below
NAME: janaki, janaki
ADDRESS: ** ********** **
ADDRESS2:
CITY: montvale
STATE: NJ
ZIP: 07645
CANDIDATE ID: 2259417
US CITIZENSHIP: US
Citizen
EDUCATION:
EXPERIENCE: 10
WILL RELOCATE: Yes - NJ,
NY, OH, PA
JOB WANTED: Any
RATE NEEDED:
TELEPHONE: 201-***-****
EMAIL: **********@*******.***
HOMEPAGE:
HOTTEST SKILLS: Oracle,oracle finacials
REVISION: 28-OCT-01
YOE: 10
RESUME:
An Oracle Financials Technical Consultant with expertise in General Ledger,
Accounts Receivable, Accounts Payable, Purchase order, Project Accounting,
Application Object Library, Oracle Inventory, Order Entry and Bill of
Materials.
Able to customize and enhance Oracle Applications to cater to specific
customers, and proficient in PL/SQL,Oracle Forms (v6.0, 4.5 and v3.0) and in
Oracle Reports (v6.0, 3.0, 2.5, 2.0).
Excels in the Design, Development and Implementation of RDBMS (Oracle) with
Developer 2000, Oracle 8 database and Oracle Financial 11.0.3 /10.7
Experienced in System Analysis, Database Tuning, Requirements Analysis, Module
Design, Development, Conversion, Testing, Documentation, Implementation and
maintaining the application software using ORACLE 8.X, Oracle Applications
11.x, SQL, PL/SQL, SQLLoader, ProC, Oracle Forms and Reports, Toad, CONSTELLAR,
and UNIX
Exposure to client/server programming and GUIs.
4 years experience in Oracle Applications and 6 years in overall in Oracle.
A presentable professional with excellent communication skills.
TECHNICAL SKILL SUMMARY
ORACLE APPLICATIONS
DATABASE
Oracle Applications 11.0.3/ 10.6
Oracle v8i / 8.0 /7.6
Oracle Front Office Applications
LANGUAGES & DEVELOPMENT TOOLS
OPERATING SYSTEMS
Developer 2000
(Forms 6,Reports 6)
SCO UNIX (Open Server) 5.0
-Windows 3.11
PROC
Windows 95,WIN NT 4.0
SQLPLUS 3.1 & 8.0
Novell Netware 4.1
PL/SQL 2.0
MS DOS 6.22
Constellar 3.0.1
Eroom
EXPERIENCE
1.
Feb 01 Current
:
Readers
Digest, NY
Oracle Financials Technical consultant / Developer
Catalyst :
As a
Technical Analyst
at Readers Digest Inc., Janaki is currently involved in
developing Global interfaces between fulfillment systems to Oracle
Applications. Readers Digest is implementing complete suite of Oracle
Applications in US, UK, Germany, etc. Janaki is responsible for General Ledger
interface, Inventory Returns and Adjustments Interface, AP Open Invoice
Interface for UK and Nordic Countries. Legacy fulfillment system (Mainframe)
will provide journal entries, Inventory adjustments and invoice transactions in
an ASCII data file which will be loaded into Oracle Applications using PL/SQL
and Constellar Tool. She is also responsible for Sales Order process which
involves interfacing the Sales Orders with the fulfillment systems, She was
responsible for design and development of this Interface. Janaki also
participated in writing extract for BOM Packages and Components Outbound
Interface. This interface extracts product packages data for Nordic legacy
system from Oracle Bill of Materials and Inventory in a flat file andexports to
legacy system using Constellar.
She designed and developed custom VAT Reconciliation Reports between Order
Entry, AR and General Ledger, Weekly Invoice report and Invoice Aging Reports
using Oracle Reports 2.5.
Environment: Oracle Financials 11.0.3 (General Ledger, Accounts Payable) and
Supply Chain Management (Oracle Inventory, Bill of Material, Order Entry),
Oracle v8.0.5, Constellar 3.0.1 (Metadata & Transformation Manager), PL/SQL,
Forms 4.5, Reports 2.5, SCO UNIX.
2.
Apr 00 Jan 01
:
Rosenbluth International, Philadelphia
Oracle Financials Technical consultant /Developer
RIVER :
This project involves customization & implementation of Oracle Financials
Applications with Travel Management Application. Janaki Involved in designing
AR Custom Bank Account Interface that allows for the automated creation of
customer banks and bank accounts .She is also responsible to import GL daily
exchange rate data from an external exchange rate provider to Oracle General
Ledger by writing a custom import program and Purchase Order Requisition
Interface. Designed and developed AR Returns and Bad Debts Interface, Over-
Night and Gift Certificate Interfaces.
Janaki was designed and developed RI custom search Form using Forms 4.5, which
will allow users greater flexibility when performing searches in the Oracle
Applications by providingthe ability to search for Receiving Transactions,
Project Expenditure Items, and Payables invoices using travel data contained in
the DFF columns. She was also involved in customization of Purchase Order
Report using Reports 2.5.
Janaki is also responsible for designing Oracle Data Source (ODS) database for
travel information to develop Custom Reports using reports 6.0. These reports
are created to show specific transaction related financial data from the Oracle
Applications and Travel management system. Design and development of various
Travel Information reports like Commission Trend Air data History,Car and
motel booking, Fedex and Client Settlement Reports etc. these reports are
accessible through Web interface, which developed by PL/SQL Catridges. She was
also involved in writing Concurrent programs & UNIX Shell Scripts
Environment: Oracle Financials 11.0.3 (Project Accounting, Accounts Payables),
Oracle v 8i & 8.0.5, Oracle Forms 4.5 & 6.0, Reports 2.5 & 6.0, PL/SQL, SQL
Loader, SCO UNIX .
3. Sep
99
Mar 00 :
1800 FLOWERS, Westbury, NY
Technical consultant
Direct Pay Florist System
This Project replaces existing Payment cycle to Florist as direct pay without
involving with wire transfer services. Before existence of this system 1800
flowers used to send payments to Wire transfer services and Florist will get
payment from them .Now direct pay to the florist, In this system we need to
calculate charges, commissions, bonuses to Florist from performance of Orders
study. Existing order entry system will give this information for invoice
import. Statements will be send to the Florists giving all this information
accessible through web.
In first phase Janaki involved in designing the system for Florist( Vendor)
Interface from ATLAS Order entry system (external system) to Oracle Financials
Accounts Payables. In second phase Invoice Import Interface in AP. Also
Designed and developed conversion programs for Vendors, Banks, AP invoices and
payments.
Janaki also involved in writing Reports2.5 for Accrual Report, Statement to
Florist and designing forms necessity. She also worked on sending the status of
these concurrent programs (vendor interface & invoice import) to set of users
through Unix Shell scripts.
Environment: Oracle Accounts Payables &General Ledger 11,Oracle 8,
Developer /2000, PL/SQL, SCO UNIX
4. Feb 99
Aug 99University of West
Virginia, WV
Oracle Financial Consultant
MAPS (Mountaineer Administrative Process System)
MAPS is implementation and customization of Oracle financials and Human
Resource applications, which includes Oracle Payables, Oracle Receivables,
General Ledger and payroll modules. Janaki is mainly working on Oracle Payables
MAPS/FIMS interface and Vendor conversion. All the expenditures and receipts
must be recorded in the WVU Chart Of account and reflects in states set of
books. This interface will allow to transmit vendor Invoices and IGTs and
manual vouchers to the State agencies financials system according to their
specified format through electronic file, and also interfaces for the Payments
information to update MAPS .Janaki responsible for designing the system and
coding to generate packages using pl/sql. She also participating in designing
reports and coversheets for different types of transactions according to the
standards.
Environment: Oracle Financials 11 (Oracle General Ledger, Oracle Receivables,
Oracle Payables, Application Object Library, Oracle alerts) on SCO UNIX Open
Server v5.0, Oracle Reports 2.0, PL/SQL, SQLPlus, Proc, SQLLoader
5.June 98
Dec 98ORACLE CORPORATION HEADQUARTERS, REDWOOD SHORES, CA
Programmer/Analyst
Oracle Service Contracts
Oracle Front Office Contracts is designed to handle various aspects of contract
management, which includes contract authoring & pricing, contract
billing/renewal/termination and so on. Contract Authoring involves creation of
a contract quote from an offering, delivering the quote to customer and
obtaining approval on pricing, coverage and other terms & conditions. This
module is integrated with order entry for price list, sales orders and
shipping. Contract Billing involves determining extra amount to be charged to a
customer for service provided against a contract. Terminate contracts allows to
terminate individual service lines.
Janaki was responsible for the interface between Oracle Front Office Contracts
and Oracle Receivables to generate invoices, credit memos and tax calculations.
She was involved in design and development of Oracle Front Office Applications,
Oracle Service Contracts module. She developed forms for authoring and
terminating contract types, and groups and status codes etc. according to the
Oracle user interface standards. She also developed PL/SQL concurrent programs
to calculate transaction amount and final adjustment for service lines for
billing transactions created contract detail reports involved in generating
APIs for table handlers and to fetch transaction information program from AR,
converting duration etc.
Environment: Oracle Service, Oracle Receivables, Oracle v8, Developer 2000
(Forms 4.5, Reports2.5), PL/SQL, SQL Plus on UNIX
6. May 97
May 98CHEMINOR DRUGS LTD
., HYDERABAD, INDIA
Oracle Financial Technical Consultant
Financial A/C Systems (FAS)
Janakis work primarily included developing customized reports, modifying
existing reports, developing new forms to suit user requirements. She worked
extensively with General Ledger, Accounts Payable, Accounts Receivables, AOL,
Alerts, SQLLoader.
Janaki played a key role in Installation and Customization of OracleFinancials.
She contributed in the initial setup of Oracle payables and receivables such as
defining customer profile class, payment terms, payment terms, banks and
customization of reports like Payment Register, Trail Balance and Invoice
Register using Reports 2.0, planning, designing, flexfield structures, segments
and value sets for segments according to user requirements, setting up system
for foreign currency translation and revaluation, performing financial
consolidation of multiple currency set of books, developing reports of user
required formats using Financial Report Generator, developing interface
programs in ProC and usage of SQLLoader. She was also involved in auto
invoicing, budget uploading using open interfaces and implementing budgetary
control using budget journals, importing data through feeder systems etc.
Environment: Oracle Financials 10.6 (Oracle General Ledger, Oracle Receivables,
Oracle Payables, Application Object Library, Oracle alerts) on SCO UNIX Open
Server v5.0, Oracle Reports 2.0, PL/SQL, SQLPlus, Proc, SQLLoader
7. Nov 96
Apr 97COSMIC INDUSTIRES LTD
., HYDERABAD, INDIA
System Analyst/Programmer
Personnel Management System (PMS)
Application: This System helped to maintain the total account structure of the
organization. It featured the development of forms for voucher entry and
account master. The Personnel Management System covered bills payable, bills
receivable, loans and advances, cash and bank transactions, customer and
supplier details, payment schedules, discount status and interest receivables
on overdue invoices. Reports included general ledger, subsidiary ledger,
cashbook, bankbook, P&I A/C, trial balance and balance sheet.
Profile: Janaki was involved in all phases of the development of Personnel
Management System software. She was one of the three-member team that was the
primary client liaison for the entire project. She was involved in programming,
testing, database design, screen design and implementing the system and
developed different kinds of reports.
Environment: Oracle 7.1, Developer 2000 (Forms 4.5, Reports2.5), PL/SQL, Stored
Procedures, Triggers, SQL Plus, Windows 95.
8. Apr 96
- Oct 96BHASKARA AGRO CHEMICALS LTD
., HYDERABAD, INDIA
System Analyst/Programmer
Inventory Tracking System (ITS)
Application: The Inventory Tracking System aided business and inventory
management by monitoring product-wise stock levels, communicating optimum stock
levels by obtaining monthly averages based on history data, recommending
replenishment when the product stock reached set minimum levels. The System
also helped to maintain multiple units of measure stock and reorder levels,
transaction processing, stock receipts, stock issues, stock adjustments,
handling of return inward and outwards and inventory closing.
Profile: Janaki was involved in all phases of development of Inventory Tracking
System, She analyzed the system by meeting clients and obtaining the required
information. Her role included designing the system, coding database triggers,
stored procedures, debugging and implementing the system.
Environment: Oracle 7.1,Developer 2000 (Forms 4.5,Reports 2.5), PL/SQL, Stored
Procedures, Triggers, SQLPlus, Windows 95.
9. Dec 95
- Mar 96SREE RAYALASEEMA HI-STRENGTH HYPO LTD
., KURNOOL, INDIA
System Analyst/Programmer
Payroll System
Application: This system was designed, developed and implemented to process
payroll data to calculate and print salary slips of employees of the company.
It maintained a record of employee master data, personnel information,
performance, pay raise, promotion, bonus calculations, deductions towards loan
availed, contributions to provident fund, insurance etc. A consolidated salary
summary statement (monthly and yearly) was also generated.
Profile: Janaki was involved in designing, developing and implementing the
system.
Environment: Oracle 7.1, Forms 4.5, PL/SQL, Reports 2.5, SQLPlus on Windows
3.11.
10. May 95 - Nov 95
SREE RAYALASEEMA HI-STRENGTH HYPO LTD
., KURNOOL, INDIA
System Analyst/Programmer
Purchase Order System (POS)
Application: The system automated the process of purchase activities in the
form. It included the raising of requisition, obtaining quotations from
suppliers, preparation of invoices, issuing material indent and stock
maintenance. It was an online system linked to the financial and inventory
system, which generated reports for pending purchase orders, list of
requisition, vendor details and outstanding credits etc.
Profile: Janaki was involved in extensive system study and analysis of industry
requirements. She played a key role in all phases of development of the system
from the discovery phase when the project team made initial contact withthe
users to learn about the requirements. Her responsibilities included system
design, programming, coding Database Triggers & Stored Procedures in Oracle
Server, testing and implementing the system.
Environment: Oracle 7.0, Developer 2000 (Forms 4.5, Reports 2.5, Graphics 2.5),
Windows 3.11.
11. Nov 94
Apr 95ELECTRONIC CORPORATION OF INDIA LTD
., HYDERABAD, INDIA
System Analyst/Programmer
Automated Information Maintenance System (AIMS
)
Application: The system designed screens for quality assurance and contracts
modules. The QA module kept track of the quality assurance process that
finished goods undergo. Contracts module kept track of contracts and
contractors competing for the projects and various stages of contract bids and
so on.
Profile: Janaki was involved in database design, import export of Oracle
database from a synchrony database, front-end screen design and implementation
of the system.
Environment: Oracle 7.0 & Forms 3.0, SQL Reports 1.0, SQL Menu 5.0 on Unix
system
12. April 94
October 94ELECTRONIC CORPORATION OF INDIA LIMITED, HYDERABAD, INDIA
System Analyst/Programmer
Production Planning and Control (PPC)
Application: The system generated production scheduling based on forecast,
inventory, and work-in process and shipmentinformation. Production control
processes were designed based on quality control, inventory control and cost
control. The project also involved preparation of job cards, inspection
reporting, daily production report, and weekly performance analysis andprocess
sheet.
Profile: Janakis job profile included database design, creating the database,
front-end screen design, front-end development, writing of database and front-
end triggers and procedures and writing of programs to transfer flat files from
UNIX into Oracle using SQLLoader.
Environment: Oracle 7.0 & Forms 3.0, SQL Reports 1.0, SQL Menu 5.0 on Unix,
SQLLoader.
EDUCATION
Post Graduate Diploma
in Computer Applications, Indian Institute of Computer
Informatics,
Hyderabad, India
Bachelor of Technology
in Civil Engineering, SK University, India
Contact this candidate