Home » Other » Marketplace » Re: Oracle Developer wanted - Ottawa, Canada
| Re: Oracle Developer wanted - Ottawa, Canada [message #105112] |
Fri, 06 July 2001 08:33 |
satish m surana
Messages: 2
Registered: July 2001
|
Junior Member |
|
|
R E S U M E
Name:- Satish M. Surana
Address:- C/o R.D.Parakh
104/D YOGLAXMI COMPLEX,
MODI NO. 1, SITABULDI,
N A G P U R.
Contact.No.:- 91- 0712 - 757779 (Res.), 523527 (Off.)
Passport No. :- A-2544953
Email: sat_surana@hotmail.com
Date Of Birth : 22nd Dec.1968.
Sex: Male
Nationality: Indian
Languages Known: English, Hindi, Marathi
Objective : To Contribute productively to the profession of
software
engineering through
innovation, hard work and curiosity.
Current Position : System Analyst Cum Programmer
Expertise Summary :
* Seven years professional experience in all areas of software
engineering
including
project management, analysis, design, development and implementation.
* Involved in DBA activities such as ORACLE and FOXPRO installation,
creation and maintenance of tablespaces, rollback segments,
normalization of
tables and indexes and fine tuning of SQL scripts to achieve best
system
response time.
* Working with Lokmat Newspapers Ltd., Nagpur, India.Since May- 1994.
Office address : Lokmat Newspapers Ltd.,
Pt. Jawaharlal Nehru Marg, Wardha Rd.,
Nagpur 400 012, (Maharashtra) India.
Phone No. (91) 0712-523527, 523528
Available timing : 10.30 A.M. to 6.30 P.M.(IST)
Skills Summary :
Languages:- C, COBAL, BASIC, FORTRAN, VB, JAVA
Software Technologies:- DEVELOPER/2000, SQL*FORMS Ver 2.3, 3.0,
4.5 and 5.0
PASCAL, SQL, PL/SQL., SQL*REPORT (RPT)
REPORT WRITER AND PRO*C,
JAVA, SERVLETS, JSP and ADV. JAVA
Operating System UNIX, WINDOW'S 95, WINDOWS, DOS
Database ORACLE 8i, ORACLE 7.2.3, ORACLE 6.0 AND
FOXPRO.
Productivity MS-OFFICE, LOTUS, LOTUS SMARTSUITE,
WORD-STAR, QP
Project Experience DEVELOPER/2000 : 3 1/2 YEARS , ORACLE
7.2.3
TOOLS : 3 1/2 YEARS
ORACLE 6.0 TOOLS : 4 YEARS, FOXPRO :
5
YEARS
Platforms : Developer 2000 / Oracle 7.2.3 / Unix (Digital Alpha
Server)
Oracle tools Forms 3.0, 4.5, and 5.0, Report-Writer, Sql*Report
(RPT), under Digital Unix. (Digital
Alpha
Server)
* Oracle tools Forms 2.3, Report-Writer, Sql*Report (RPT), PRO*C
under Unix (ICIM Mini Computer)
* Foxpro under MS-DOS and Netware 4.1
CURRENT APPLICATIONS :-
Application currently under development using Developer/2000 Front
end on
windows 98
with back-end Digital Unix based Oracle 7.2.3 enterprise server. (
Aplha Server)
Linking of all centres.
SYSTEMS WORKED ON :
S.No Hardware O.S. Software /
Databases
Period
1. Digital Alpha Digital Oracle 7.2.3
Enter-
July
Server Unix prise Server
with
1997
( 128 MB RAM, (4.0) bundle tools,
onwards
333 Mhz, Sqlforms 3.0,Report-
12 GB HDD, Writter, SQL*Report
8 GB DAT ) (RPT), Pro*C etc.
2. Pentium 166 Mhz Windows Developer/2000,
July
32 MB RAM, 95 Forms 4.5 &
5.0,
1997
1.2 GB HDD Reports
2.5,Oracle
8i onwards
3. 386, 486 & DOS FORPRO 2.6
Oct.
Pentium Novell
1992
16 MB RAM, (2.2 & 4.1) onwards|
4. ICIM Mini Com. Unix Oracle 6.0 with
[[ 4 ]]
Krypton-1025, SVR 3.2 Sql-forms 2.3,
Years
16 MB RAM, Sql-report
(rpt),
25 Mhz,Dual CPU Report Writter,
300x2 MB HDD. Pro*C etc.
Educational Qualification:-
S.No. Examination Year Of University/ Percentage
and
Passing Board
Division
1. S.S.C.(10 th) 1984 Nagpur. 69 % First
2. H.S.S.C.(12th) 1986 Nagpur. 55 % Second
3. Bachelor Of Science 1989. Nagpur. 50 % Second
(Phy, Chem. & Maths)
4. Master Of Science 1991 Nagpur.
57 %
Second
(Statistics)
5. Post Graduate Dip. in 1992 Nagpur.
65 %
First
Computer Science.
Platforms : Developer 2000 / Oracle 7.2.3 / Unix (Digital Alpha
Server)
Oracle tools Forms 3.0, 4.5, 5.0 Report-Writer,
Sql*Report
(RPT),
under Digital Unix. (Digital Alpha Server)
* Oracle tools Forms 2.3, Report-Writer, Sql*Report (RPT),
PRO*C under Unix (ICIM Mini Computer)
* Foxpro under MS-DOS and Netware 4.1
* Oracle 8i, C, C++, Java & Visual basic under learning stage from
Mar-2001.
Project Responsibilites and Highlighting Features :
I have been a member of a developing team comprising 5 professionals in
an
EDP setup. Our development team hierarchy was as follows:
EDP Manager --( System Analyst(My self)--> 3 new Programmers
All the applications were initially designed and finalized by me along
with
EDP Manager. In all the applications the most critical and important
modules were development by me in coordination with EDP Manager. My
role,
responsibilities & highlighting features of the application can be
listed
as follows, As a team member of IT support was responsible for :
Database & System Design, Coding, debugging, user training,
implementation &
support.
Database normalization & optimization.
Presentation of very user friendly & flexible Entry/Update/Query Forms
and
Menus.
Provision of online help, validity checks and controls in all the major
routines.
Finalizing Entry Screens, Reports Format and logical flow required.
Generation of MIS reports/summaries/Query Forms with graphical
representation also.
Confidential modules protected using password and other security
features.
All the critical menus and Entry/Update modules are accessible by the
users
after entering their valid passwords store in the database. All records
are
stored
in the database along with the valid user-id.
Special care and efforts were taken to minimize total no. of distinct
forms,
reports and graphical programs.
Integration of the related application to avoid any duplicate Entry /
discripancies and ease out reconcillation process.
Extensively involved in writing PL/SQL stored procedures, databasic
triggers, function, and triggers,
participated in module testing and system integration.
Varied use of PL/SQL's, Stored procedures/packages, database triggers
at
various levels.
Skillfully handled forms triggers, program units, libraries,
LOV's/Record
groups, form build-ins, dynamic property changes and other GUI
features.
Professional Experience :
Oracle V.6.0 installation on Unix platform and setting various oracle
parameters in init.ora file. Database creation, Index creation, Stored
Procedure creation.
Server configurations and space requirements for new Projects.
Day to Day Database maintainence including refreshing the development
databases and backups.
Developed scripts for tablespace generation, tablespace / segments /
free
extends reorganization, table locks, creating roles and adding
priviledgers
management.
Responsible for developing various databases at various stages of
implementation of projects, (Databases for conversion of data) and
responsible for Backup.
Created number of Databases using methods Import & Export and at
Operating
System level using UNIX tar command.
Involved in performance management solutions team for testing old
reports &
new reports for time managements and debugging.
Trouble shoot various applicatiuon problems and system testing at
different
cycles while upgrating system.
Working on tuning of database and applications, maintaining security.
Created users and assigned the roles and managed the security of the
databases.
Modifying all custom procedures and packages according to new Oracle
application system.
Customization of Forms using SQL*FORMS
Generation of special MIS reports from the integrated system.
Additional Reports for auditing and reconcillation purpose.
Evaluation of all the systems developed to provide more informative and
flexible queries from the integrated system.
Cost Analysis System developed and generation of net profit of the
company
by analysis of source and application of funds.
Maintenance of all the applications developed.
Application DBA Soltware : Developer/2000, appling patches to update
Developer/2000 forms and reports, calling Oracle for various problems
and
downloading patches from their FTP protocol.
Created database and resized dababase files by expanding or shrinking
to
gain unused space, granting database priviledges, tune SQL, PL/SQL
statements to diagnose problems.
Created Indexes and views for better performances.
Trouble shooting of printer problems.
Developed PL/SQL scripts for procedures to import data from vendor
information.
Conversion from existing database to new Database.
(Period : As Per Requirement)
Data Conversion of All system from existing database to new database &
implementation of new software.
i.e. Upgrading oracle database from 6.0 to 7.2.3.
User traning, support and varification of various modules and reports
developed.
Development of additional MIS reports and maintainance of all the
applications.
Integration of All System with FA.
1) Advertisement Scheduling, Publishing, Billing System.
Role Sr. Programmer Team size : 3
Project Outline : The Software aims at Online Acceptance of
Advertisements
and its accouting and analysis of business and market trends :
Advt's are accepted and published after checkting the space
availability and
party's outstanding dues.
Pre-Paid Ad's are verified from F/A system.
Billing is done for the Ad's published on any combination of multiple
editions for any no. of insertions.
The calculation of bill amount depends upon various criteria's.
Generation of edition wise Schedules, various analysis reports and
summaries
related to Advt. Business/Revenue/Debtors, daily tracking of missed
Ad's and
comparative study of Advt's published in different Newspaers and many
more
MIS reports and very flexible and informative online Query forms.
Integration of advertisement system with F/A system.
Implementation of 4 projects developed.
Creation of New database objects converting from the old database.
Fine tuning of the program units and database objects and optimization.
User training and verification of all the application developed.
2) Payroll & Personnel Management System
Role Sr.Programmer Team size : 2
Project Outline :
Generation of Monthly Payslips of all the different types of employees.
Maintenance of Leave Records of the employees.
Maintaining database for Service details, Personal details, Educational
and
Other details of the employees.
Generation of Monthly/Yearly statement of PF, Income Tax, ESIC,
Prof.Tax,
and other Half Yearly and Yearly Returns. Finally generation of new
database.
3) Advertisement Recovery Accounting System
Role Sr.Programmer Team size : 3
(Period : SEP-98 to NOV-99)
Project Outline :
It deals with maintainance of individual advertisers account and their
outstanding position and generating various types of outstnading
reports.
The system is directly linked with advertisement and billing system.
The system allowes entry of various different types of transactions
such as
:-
Receipts Entry with reference to valid bills, On A/C receipt entry,
Updation of On A/C receipt to adlust bills, Real Debit/Credit Note
Entry,
Internal Debit/Credit Note Entry (On A/C or Against Bill), Internal
Debit/Credit Note appropriation, JV Entry.
Receipts are accepted in cash as well as thru bank. Cash transactions
are
accepted in F/A module and are transferred into Recovery module thru a
transfer procedure Other details are updated in the Recovery module.
Bank
Receipts,
Real Dr./Cr. notes, JV's are intered in the Recovery module and a
summary
datewise / bankwise is transferred to F/A module. Int. Dr./Cr. notes
are
transferred individually. If any branch rcpts are entered, then on
periodic
basis, system generates a int.debit note for branches.
The system does not allow to update any entry for correction. For that
purpose resp. Dr.Note/Cr.Note adjestment entry can be entered.
The system takes care of all the Inter Departmental / Inter Branches
transactions related with the advt. published and for that purpose
Int.
Dr.Note/Cr.Note are entered giving reference of the F/A Code.
Various different types of books of A/c's Ledger, Outstanding
statements,
Summary reports, reconcillation reports, other analysis and MIS reports
are
generated from the system. Very flexible and informative Query forms
along
with graphical representation are also provided for the management.
The system comprises of 5-6 very complex entry forms, 35-40 output
reports,
3-4 very flexible Query forms.
4) Financial Accounting System.
Role Programmer Team size : 3
All type of Journal Voucher related to Purchase, Expenses,
Payments/Receipts
By Cash/Bank, MJV's, Dr.Notes / Cr. Notes etc.
Payments all allowed to only thru link references if any.
Generation of Main/Sub Ledgers, Main/Sub Trial Balances, Profit and
Loss
Statements and other Reconcillation reports.
Automatic generation of TDS payment voucher on monthly basis.
Purchase and Sale of Fixed Assets and preparation of Yearly
Depreciation
Chart for Balance Sheet.
Integration of Circulation System, Newsprint Accounting System, Store
and
Inventory Management System with the F/A System.
Development of MIS system by way of Cost Analysis, Fund Flow
Statements,
Projected Expenses and Cost Analysis, Generation Of Balance Sheet
Schedule
etc.
5) Newsprint Purchase, Consumption and Wastage Accounting.
Role Programmer Team size : 3
The Software deals with accounting of :
Purchase of newprint from different suppliers.
The Stock Master is to be maintained separately for each newsprint
make.
Daily Newsprint consumption (makewise) and posting to Newsprint Ledger.
Consumption chart with cost analysis at any time. The consumption of
Newsprint
on FIFO basis. Integration with F/A System and Circulation System.
Analysis reports pertaining to Newsprint Wastages, MIS reports, ABC
audit
reports and summaries etc.
6) Newsprint Distribution, Billing & Recovery System.
Role Programmer Team size : 3
The Software aims generation of Print-Order (Route-wise/Edition-wise)
and
maintaining ledger accounts of distribution agents including following
modules:-
The generation of Bills for the copies distributed by each
agent/sub-agent
Accounting of A/c's Receivables and Payables.
Generation of reports involving records pertaining to Bills, Receipts,
Debit/Credit Notes and ledger balances of each agents etc.
7) Stores and Inventory Accounting System.
Role Programmer Team size : 3
The Software aims at generation of Integrated Material Management
System
which includes following modules:-
Entry and generation of requisition slip, Purchase Orders, Goods
Received
Note,
Bills Received, Payment of Bills etc.
Consumption and closing stock calculation on the FIFO method and
maintenance
of Item-wise Stock Balance.
Automatic generation of purchase orders when the closing stock falls
below
reorder level.
Automatic generation of Purchase Vouchers in the F/A system, based on
reorder quantity reports.
Printing of reports related to purchase register, pending other list,
Item
wise Stockregister etc.
Issuing of materials from main stores to different depts and costing of
items issued on FIFO method.
It supports ABC analysis and re-order quantity and Economic order
quantity
for Inventory.
Previous Experience Summary :-
I am working with Lokmat since MAY-94 as a Tr. Programmer and elevated
to
the Post of Programmer in APR-95. From May-94 to OCT-97, I have
contributed
in the development of various application packages required by the
company
from time to time (Including all the projects mentioned above) under
Oracle
Ver 6.0 using Forms 2.3, Sql*Report and Report writer, Pro*C and SQL
Scripts
under Unix. Also I have contributed in the development of various
application packages in FOXPRO 2.6 under Novell Netware 2.2.
With the introduction of multi tasking environment and GUI, in the
month of
Mar'96 the company opted to re-develop all the applications usings GUI
tools
Developer-2000 and back-end Oracle 7.2.3. database under Digital Unix
4.3 B.
The New System was finalized after considering various other options.
In the Month of Mar'96 all the existing application and data were
migrated
to the new computer system in Oracle 7.2.3 with bundled tools forms
3.0,
Report-writer, Pro*C, Sql*Report etc. Subsequently, development was
started
using Develop/2000 after establing its connectivity with Oracle 7.2.3
Database on Digital Alpha Server.
From Oct-92 to Apr-94, I was employed with Lokmat (Not on Payoll) as a
"On Job Trainee" and was assigned the job of user problems and system
study of the following system.
1) Advertisement Scheduling & Billing System.
2) Recovery/Account Receivable System.
3) Circulation, Billing & Account Receivable System.
4) Integrated Financial Accounting System.
5) Payroll & Personal Management System.
6) Marketing Survey System.
7) Library System.
8) Production Planning & Control System.
9) MIS System For Senior Managemnts & Executives.
----------------------------------------------------------------------
|
|
|
|
Goto Forum:
Current Time: Mon Dec 23 07:54:55 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
