|
Summary
§
Over 8 years of experience in analysis, design, development,
support and implementation of commercial applications.
§
Functional Experience includes customised ERP system, Supply
Chain Management Systems, Back office Management system Ticket
Vending System and E-Broker System.
§
Worked in all stages of Software Development life cycle with
different roles and responsibilities.
§
I am a Permanent Resident in the UK so do not require a Work
Permit.
Technical Summary
Skills and Tools
·
GUI Oracle Forms 4.5, 6, 6i, 9i and Reports
2.5, 6, 6i and 9i.
·
Languages PL/SQL, SQL*Plus from version 7.3 to 9i,
COBOL
·
OS Windows NT, Windows 2000, Unix
·
Databases Sybase, Oracle 7x, 8i and 9i.
·
Case Tools Designer 2000 Release 1.3.2
·
Applications Supply Chain Management Systems, Back
Office Management Systems, E-
Broker System (an online Share Trading system).
·
Other Tools TOAD (Tool for Oracle Development), PVCS
(Program Version control system).
ER Win 3.2 Entity Relation Tool for Database design
Training Attended
·
Introduction to the features of Clarify a CRM tool.
·
J2EE conducted by Oracle. The course covered Servlets, EJB’s,
and Java Server Pages integrating all the components using
Jdeveloper to build a web site.
Education
·
Post Graduate Diploma in System Management from NIIT, Pune,
India 1993
·
Bachelor of Commerce, Pune University, India 1993.
 Work
Experience
[snip]
UK
Ltd
From April 2001 to date
[snip]
Ltd
From Feb
2000 to Nov 2000
DSS InfoTech Pvt
ltd
From Feb 1998 to Jan 2000
UBIT
Ltd
From May 1996 to Jan 1998
Western India Constructions
Ltd
From May 1995 to
Apr 1996
Projects and Responsibilities undertaken at Swisslog UK Ltd:
April 2001 onwards
Software:
Win NT, Win 2k, Unix, Oracle 8.x and 9i, PL/SQL, SQL*Plus, Forms
4.5,6,6i and 9i, Reports 2.5,6,6i and 9i.
Design Tools:
ERWin 3.2
·
As a member of the Supply Chain Management and Logistics
Solutions development team, my main role is to develop and
enhance the software based on the specifications of the
customer. I am involved in writing server side packages,
triggers, and cursors and developing client side forms and
reports, creating object libraries and standardising code
wherever possible. I have in-depth expertise in Forms versions
4.5, 6,6i and 9i.
·
I was involved in a project to release a thin client version of
our product, which was developed using forms 6i. As this was a
multi-site operation, I also had the opportunity to set-up and
install the Application server for Forms and Reports 6i. I was
also responsible to develop real time graphical representation
of equipment used on customer site using 6i graphs.
·
Being an ISO 9001 certified company, I am also involved in
preparing technical development specifications based on the
functional specification provided by the project manager.
·
I play an active role by providing technical support directly to
clients as well as our internal support department. I am also
involved in directly co-ordinating and developing any
enhancements required by our clients.
·
Apart from working on Windows OS, I have also largely been
involved in projects based on Unix OS. Some of the
responsibilities being creating a database, installing
application server and compiling and building a client on Unix.
Projects and Responsibilities undertaken at Silverline
Technologies Ltd:
Feb to Sep 2000
Project:
I-Broker System for the Hong Kong Stock Exchange.
Software:
Win NT, Oracle 8.x, PL/SQL, SQL*Plus Design Tools:
ERWin 3.2
Brief Project Profile:
This is a full life-cycle project. The system comprises of
various modules: Trading, Order Processing Client-Servicing,
etc. Key features of the system include multiple-level security,
selective audit capability, user-defined labels, and document
authorization limits.
Role: System and Programmer Analyst
I was involved in the
Database module. We mainly concentrated on the object types and
object views and invoking them through stored procedures. The
database and the front end communicated with each other through
SQLJ and CORBA.
As a member of the Database team, my main task was to create
object types and views and also the packages and stored
procedures based on them. Apart from this, I was also involved
in the database design reviews, preparing test cases for unit
test plans and assisting other team members with module
integration.
Team Size:
30
Projects and Responsibilities undertaken at DSS InfoTech Pvt.
Ltd: Feb 98 to Jan 2000
Project:
ERP System
Software:
Oracle 8.x, Developer/2000, Forms 5.0, Reports 3.0, PL/SQL,
SQL*Plus
Brief Project Profile:
This is a full life-cycle project. The system comprises of the
modules: Purchase, Stores, Order Processing and Financial
Accounting. Key features of the system include multiple-level
security, selective audit capabilities, user-defined labels and
drill-down facility.
Role: Programmer Analyst
I was involved in the Order Processing module. The
order-processing module involves processing of the confirmed
orders received from HO, maintaining stock at dispatch and
production department.
As a member of the team involved in the development of the Order
Processing module, I got a chance to do the requirement analysis
with the client for this module. Developed prototypes of the
forms and after getting a confirmation from the client continued
with functional development. While developing forms created
features like smart classes, templates and object libraries.
Extensive use of triggers both backend and front-end, stored
procedures to enforce data integrity.
Team Size:
20
Project:
BACK OFFICE ENTERTAINMENT SYSTEM for ICON Software Ltd, UK
Mar 98 to Sep 98
Software:
Retrieve 4GL, Oracle 7.3, Developer/2000, Forms 5.0, Reports
3.0, PL/SQL, SQL*Plus
Brief Project Profile:
The system was
developed to allow a user to book a ticket for a movie or
concert. The system could also allow customers to book tickets
through an Automatic Ticket Vending machine, by displaying a
series of screens depending on the user choice. The system
also allowed the customer to get a membership to the cinema or
theatre. If the customer accepted the membership, he/she is
given a card with a unique number. When the customer buys
tickets or any refreshments, he/she can swipe the card, and a
calculated number of points are credited to it depending on the
value of purchase. The customer then, on collecting a certain
number of points, can redeem them for a free ticket or any
refreshment item depending on the points earned.
Role:
Systems Analyst
Was deputed to UK to
work on site to work as a member of a four member team, I was
involved in the enhancement and support of this system for
clients based in the US and Australia. Besides development and
enhancement of other modules, I was also Involved in the design
and development of a new module called Customer Loyalty Scheme.
Team size
4
Project undertaken in UB Engg. Ltd, a part of the UB Group in
Kuwait - June 96 to Jan 98
Project:
STORES ORGANISATION SYSTEM
Software:
Oracle 7.3, Developer 2000, Forms 5.0, Reports 3.0, PL/SQL,
SQL*Plus
Brief Project Profile:
The system handles all basic transactions for inventory control.
The system also included an on-line printing request for
Materials forms. Apart from this, monthly stock statement,
item-wise reports, consumable statements were also incorporated
in the system.
Role: Programmer
Interacting with the
clients for designing and developing the database, which
included data structures, referential integrity constraints.
Developed interactive forms for data entry and query with
physical data entry reduced to drop down lists, ListOfValues
made available. Used the Oracle Report Writer tool to develop
reports.
Team Size:
4
Project undertaken at Western India Construction
LTD May 95 to May 96
Project:
PERSONNEL & PAYROLL SYSTEM
Software:
Oracle 7.1, Developer 2000, Forms 4.5, Reports 2.5, PL/SQL,
SQL*Plus
Brief Project Profile:
This system was
designed and developed for in house use to take care of all
Payroll utilities like Provident Fund, Loans, fully automated
calculation of Income Tax and also returns to be filed as per
the government norms. The system was designed so as to be
compatible for installation at various sites spread over India.
Role: Programmer
As I was in-charge of a four-member team, I
was involved in designing the system as well as its
implementation. This project gave me a good experience of how to
deal with the end user and crystallize his requirements.
Team Size:
5
Personal Information
Name:
Rajesh Varadarajan
Date Of Birth:
30th. August 1972
Marital Status:
Married, with one daughter
Other Interests:
Badminton, Tennis, Cricket, travelling |
