CHIKKABALLAPUR JAYAKUMAR ANAND
Summary
Anand C.J has around 4 years of experience as a Software Engineer/Programmer with
Extensive computer skills in the following:
* Oracle 7.x, Oracle 8i
* Developer 2000 V 1.3 & V 2.x
* PL/SQL V2.x
Anand C.J has worked for various International organizations in Dubai.
Expertise
Extensive skills in business application development using Oracle 7.x and Oracle 8i
Good exposure to Developer 2000 V 1.3 and V 2.x
Experience in database programming with Triggers, Functions, Packages, Procedures & Sequences.
Excellent interpersonal and customer relational skills
Proven Planning, Organizational, Analytical, Communication and Presentation skills
Strong exposure to Business Analysis, design
Good exposure to the Software Development Life cycle
Good experience in preparing Requirement Analysis, Functional Specification, Design Document and Program Specification
Education
Bachelor of Engineering
Hardware
Pentiums, Macintosh
Operating Systems
MS-DOS, UNIX, Windows 3.1/95/98/NT
Databases
Oracle 7.3, 8.0 and 8i
Software/Programming Language
PL/SQL
Tools/Utilities
Export, Import, Server Manager, Security Manager, Storage Manager, SRS (Support Request System for Fault Logging) and CCC Harvest (Version Control Tool)
Professional Experience
1. Revenue Accounting, Proration, Interline Billing and Decision Support (RAPID)
Sep’99 to till Date
Client: Mercator, Emirates Airlines, Dubai
Environment: Oracle 8i, Developer 2000 (Forms 5.0 and Reports 3.0)
RAPID is a comprehensive solution for Airlines Passenger and Cargo Revenue Accounting, based on first coupon based data capture and pricing. It offers efficient revenue accounting and swift, comprehensive & timely information vital for commercial decision making.
It includes the following modules
1. Stock Processing 2. General Functions 3. Interline Billing 4. Passenger Sales 5. Passenger Fares 6. Passenger Flown 7. Cargo Sales 8. Cargo Rates 9. Cargo Flown 10. DML Processing 11. GHA Export and Import 12. P.O Mail Module
As a Software Engineer the responsibilities for this project included:
Involved in application Development of two Modules P.O Mail and GHA Export.
Maintenance and Support of other Modules like Stock, Cargo Flown and TACT Rates and General Functions.
Responsibilities for the Development:
Preparing User-Requirements Document (URD)
High Level Design of the Modules and preparing Design Document (TSD). Participated in Design Reviews
Writing Application Logic, Coding, Unit Testing and Support for Testing Personnel and End-Users (Airlines).
Prepared Unit Test Cases required for testing the modules.
Written Oracle Back-end Packages, Procedures and Triggers required for Processing Batch Details, Accounting and Billing functionality. Involved in writing Shell-Scripts required for Night-Job Processing.
Developing GUI Screens and Reports using Forms 5.0 and Reports 3.0
Responsibilities for Support:
Simulation of the Reported Problem / Bug.
Fixing the Fault and Promoting the Package / Modules to the Production Environments, using SRS, CCC Harvest and Promote Tools. Coordinating with Testing Personnel and Users.
Other Responsibilities:
Participated in QA Reviews, GUI Reviews, Building New Databases from Existing ones. Shell Scripts for Night Job processing and Control files to load external data into the RAPID system.
2. Goods Inwards System (GIS)
Aug '98 to July’99
Client: Heckel Magnetics
Environment: Oracle 7.3 and Developer 2000 (Forms 4.5 and Reports 2.5)
Goods Inwards System (GIS) is an integrated Module, which covers the activities of Stores, Purchase and Goods Inwards Functions of a Manufacturing Organisation. This Module has provisions to capture Supplier Details (Vendors) required for the Purchase Department. It facilitates Stores to check the stock of the Raw Materials used and System automatically places Purchase Requisitions to the Purchase Department. Purchase Department can place Purchase-Orders and keep track of the Work-orders given to the Vendors. When the raw material is received, corresponding Stock is updated.
As a Software Engineer the responsibilities for this project included:
Involved in Design Reviews and Code Reviews.
Involved in Coding, Unit Testing, Supporting Testing Personnel, Client
Preparing Unit Test Cases for the Modules.
Developing GUI Screens and Reports using Forms 4.5 and Reports 2.5
Written Oracle Back-end Procedures, Packages and Triggers.
Involved in Database creation, Managing Table Spaces, Estimating Storage requirements for Database objects, Auditing etc
3. Money Expense
Oct '97 to June’98
Client: Khemwell Pvt.Ltd.
Environment: Oracle 7.3 and Developer 2000 (Forms 4.5 and Reports 2.5)
Money Expense is a simple and easy-to-use travelling Expense Application, which helps to capture all the Travelling expenses by the employee and prepare financial travelling expense statements for management tracking.
As a Software Engineer the responsibilities for this project included:
Involved in developing Application Logic, Coding, Unit Testing, Supporting Testing Personnel, Client
Preparing Unit Test Cases for the Modules.
Developing GUI Screens and Reports using Forms 4.5 and Reports 2.5
Written Oracle Back-end Procedures, Packages and Triggers.
Involved in Database creation, estimating Storage requirements for Database objects, etc.
4. Banking Software
Nov '96 to Aug’97
Client: Lakshminarayana Co-Operative Bank.
Environment: Oracle 7.3 and Developer 2000 (Forms 4.5 and Reports 2.5)
This Application helps to maintain Customer information regarding Deposits and Withdrawals related to Current, Fixed and Savings Bank Account details. This software also helps to view Passbook and Chequebook details.
As a Software Engineer the responsibilities for this project included:
Involved in developing Coding, Unit Testing, and Supporting Client.
Preparing Unit Test Cases for the Modules.
Developing GUI Screens, Multi Form Applications and Reports using Forms 4.5 and Reports 2.5.
|
, All rights reserved.