Project Developer
Resume:
Title:SENIOR CUSTOMER ENGINEER AND WORKING THERE
************@***.***
Document
Source below
NAME: pratapagiri, satish
ADDRESS: *** ****** *****
ADDRESS2:
CITY: parlin
STATE: NJ
ZIP: 08859
CANDIDATE ID: 2257505
US CITIZENSHIP: US
Citizen
EDUCATION: Bachelor Degree
EXPERIENCE: 4
WILL RELOCATE: Yes -
JOB WANTED: Any
RATE NEEDED
: Open
TELEPHONE: 732-***-****
EMAIL: ************@***.***
HOMEPAGE:
HOTTEST SKILLS: ASP =3+ yrs, Java =2+ yrs, Oracle =4+ yrs, VB =4+ yrs, HTML,
Java&VBScript =3+ yrs
REVISION: 23-OCT-01
YOE: 4
RESUME:
Summary:
Around five years of experience in the areas of developing Web based Applications using
VB, ASP, Java, Visual Interdev, VBscript, JavaScript, HTML, DHTML, Oracle, MS-Access,
COM/DCOM. Used various Oracle tools (Oracle7.3/8.0, SQL*PLUS, PL/SQL, SQL*LOADER,
Forms4.5, Reports2.5). Extensive working Knowledge in Visual Basic 5.0/6.0 using DAO, RDO,
ADO & Active-X. Good team player with excellent communication, interpersonal and planning
skills. Had been exposed to the entire product development cycle, which includes client
interaction, design, coding, and integration.
Technical Skills:
Operating Systems : UNIX, Windows NT/98/95
Programming Languages : C, SQL, PL/SQL, Java2
Scripting Languages : JavaScript, VBScript
Databases : Oracle 7.3/8.0, MS-Access, SQL Server 7.0
GUI : Visual Basic 5.0/6.0, Developer 2000
Internet Technologies : HTML, DHTML, ASP 2.0, IIS 4.0, ADO, MTS 2.0
Project Profile:
Software Developer
AIG, Livingston, NJ
Project : PCG HomeOwners Management System (Nov00-Present)
Environment : Windows NT 4.0, Java 2, ASP, Visual Interdev, VBA, VisualCafe3.2, Oracle
7.3
Description :
This System is a multi-tier application with java Applet used as the front-
end that interacts with Mapper servlet running inside the java web server that in turn
interacts with the Rating engine and gets the policy premium values calculated. The
request is the generation of Base Premium, Total Premium values of a homeowner policy for
one location or a multi location. All the input data is converted as a vector and an xml
file is generated and parsed and sent to Rating Engine. The Rating.asp file takes the XML
file and Excel file as arguments and executes a VBA macro, which does the underlying
Premium calculations and returns a stream, which is converted back to the Wins Data Vector
and stored in the Oracle database based upon the Endorsments, Credits, Surcharges etc., of
a policy.The calculated premium values are displayed back to the client.
Responsibilities :
Involved in the complete Rating module from the stage of taking the input data from the
Java client in the form of a Vector, generating xml file and making URL connection to the
ASP file by passing the xml and Excel file as parameters and getting the premium values
calculated from the Excel spreadsheet.
Created an XML file using DOM and SAX parsers for the input data to be sent to the ASP
file.
Involved in Writing Rating.asp file using Visual Interdev, which does the job of
creating an object of the Excel application and passing the XML file to the
Inputcollection VBA macro.
Used Vbscript as the Scripting language for Interaction between Web Browser and Web
Server
Responsible for writing and executing stored procedures in PL/SQL on Oracle 7.3 for
checking the Endorsments records Premium values.
Also involved in writing the VBA macro that does the total premium calculations by
mapping the input data to the spreadsheet and generates an output stream that is sent back
to the client.
Also involved in creating an output xml file and parsing the input stream and finally
sending the updated data back to the mapper.
Software Developer
AT&T, Middletown, NJ
Project : AT&T Electronic Order
(EO FR/ATM) (Mar00Nov00)
Environment : UNIX, Windows NT 4.0, Java 2, Oracle 8.0( SQL, PL/SQL )
Description : AT&T Electronic Ordering System (EO) is a web based application that
interacts with AT&T Frame Relay provisioning systems located inside the AT&T firewall. It
provides AT&T Frame Relay customers with a set of features allowing them to place new
orders, modify existing orders, and check order status via the Internet. AT&T customers
access the EO FR/ATM application via a link in the AT&T Interactive Advantage (IA) home
page. IA provides a single point of entry for AT&T customers to access multiple AT&T web
based applications. The AT&T work center accesses EO FR/ATM application via a given URL.
IA authorizes the user and redirects the users to one of the pages like Frame Relay, ATM
or IP provisioning system based on the user input.
Responsibilities :
Designed and developed the modules involved in the creation of Frame Relay/ATM orders
for New Acquisition.These modules include the design and development of the applets used
as the web pages and the servlets that communicate with the back-end processes.
The communication between the servlets and the back-end processes involve in creation,
deletion and modification of orders.
Responsible for writing stored procedures and database triggers in PL/SQL on Oracle
8.0.
Responsible in testing these database objects in UT and IT environments.
Created triggers like CustomerProfileLoad, PreOrderCCDForm for dynamic generation of
customer profile information and Account and Billing information.
Executed various SQL queries to check the various states of an order.
Software Developer
Unilever Corporation
Project : Accounts Management and Planning System (June99
-Feb00)
Environment : Windows NT, Vbscript, JavaScript, ADOs, Active Server Pages, Visual
InterDev, Oracle 7.3, Internet Information Server 4.0
Description : In this project I involved in the user interface and business rules of the
project. This project is based on three-tier application. The project involved transaction
on a client and server basis using Microsoft Transaction Server, using ADO to access
Oracle database and ASP as front end.
AMPS is used for planning promotional events and the procedures for populating the
distribution, entering DPI shipment information, entering events; and modifying,
validating, saving, and posting promotion plans. It is divided into write checks, clear
deductions, plan new product initiatives, review category objectives modules.
Account Managers of Unilever usually use this system and take care of planning different
promotional events and executes them. Write checks for a payee associated with particular
events and post deductions for event details.
Responsibilities :
Designed and developed ASP pages using Visual Interdev.
Developed HTML and ASP Pages for write checks and clear deductions modules.
Involved in writing client-side validations using Java Script.
Used Vbscript as the Scripting language for Interaction between Web Browser and Web
Server.
Created Active Server Pages for Interaction between Database Server and Application
Server using ADOs.
Used Cascading Style Sheets for Designing Uniform Pages
Developed COM components using VB and hosted in MTS.
Involved in Testing, Debugging and Integration of Modules
Tested in IE and Netscape browsers. Fixed code to take care of IE and Netscape
incompatibility.
Visual Source Safe has been used for all the source code maintenance among the whole
team members.
Developed various Reports using Crystal Reports, for Promotion Event generation and
Customer Feedback Information.
Software Developer
(Sep98May99)
Wachovia Bank, Winston Salem, NC
Project : Management Information System
Environment : Windows NT, Vbscript, JavaScript, ADOs, Active Server Pages, Visual
InterDev, SQLServer 7.0,Internet Information Server 4.0
Description : In this project I involved in the user interface and business rules of the
project. This project is based on three-tier application. The project involved transaction
on a client and server basis using Microsoft Transaction Server, using ADO to access SQL
Server database and ASP as front end.
This system is used to keep track of the details of each and every member in the society
like membership details, Deposited amount details, Checking amount details, loan details
and various accounts maintained in the society and makes a report to be sent to different
branches describing the status of the members. Visual Interdev was used to develop the ASP
pages. The society uses this system to easily identify the different member details, the
transactions involved in their accounts and makes a way to decide on the cash flow in the
society by means of various accounting heads.
Responsibilities :
Designed and developed User Interface screens using Visual Interdev.
Created Routines for Client Side Validation and Alerts using JavaScript
Used Vbscript as the Scripting language for Interaction between Web Browser and Web
Server
Created Active Server Pages for Interaction between Database Server and Application
Server using ADOs.
Used Cascading Style Sheets for Designing Uniform Pages
Involved in Testing, Debugging and Integration of Modules
Software Developer
Solar Sail, UK (Jan98Aug98)
Project : Monitoring Tool for Solar Power Plant (SPP)
Environment : Windows NT, Visual Basic 6.0, ADO, Oracle 7.3
Description : The client is a leading provider of turnkey solutions in installation of
solar power plants. The software was developed to allow the user to monitor various
operating parameters of the solar power plant from a remote location and generate
performance reports. The power consumption, power utilization and other screens were
developed using Visual Basic. SPP stores all its operating parameters like the power
produced, power used etc., in the Oracle server. The operating parameters are obtained
from the SPP location using data logger supplied by third party vendors. ODBC was used to
interact with the Oracle database to retrieve information for user requests. The
information thus obtained is shown to the user both in tabular and graphical formats. The
user can also generate reports with the obtained information or modify the operating
parameters and set them in the oracle database.
Responsibilities:
Responsible for the design and development of user interface screens in Visual Basic
6.0.
Creation of Business Objects (COM) for Data Layer and Business Logic.
Responsible for writing stored procedures in PL/SQL on Oracle 7.3.
The reports were build using Crystal Reports.
Software Developer
ASA
Tools, CA
Project : Warehousing Control System (May97
-Dec97)
Environment : Windows NT 4.0, Visual Basic 5.0 and Oracle 7.3
Description:
This Project involves computerization of warehouse. The goods are stored in the warehouse
and all the movements of goods i.e. incoming and outgoing is documented. The Movements of
goods are due to Purchase, issues (Sales), returns (Purchase returns) and goods returned
from customers (Sales Returns) are monitored, weighted average method is followed for
price fixation of goods.
Transactions: Receipts, Issues, Purchase returns, Sales Returns Maintenance & Queries.
Items: New Items, Modify Items, and Delete Items List.
Order: New Orders, Delete Orders
Suppliers: New Suppliers, Modify Suppliers, and Delete Suppliers
Responsibilities:
Involved in developing user interface Screens using VB 5.0.
Used RDOs for Database Interaction
Used Grid Controls Extensively
Used Reusable code components
Software Developer
SBN Commercial Bank
(SBNC)
Project : Commercial Financial System (CFS
) (Jan97Apr97)
Environment : Windows NT, Developer 2000 (Forms 4.5, Reports 2.5), Oracle 7.1
Description : CFS will enable the user to maintain full set of Accounts for the Bank by
providing online data entry of transactions by interfacing with the modules like Accounts
Payable, Fixed Assets and Departmental Costing. CFS will enable SBNC to maintain branch
wise bank wise book of accounts and generate the various reports for the branch. I
primarily worked on Fixed Assets System. Fixed Assets System: This system includes
Capitalization, Depreciation, Insurance, Taxation, Transferring, up gradation, Sales and
Disposals, Developed screens using Oracle Forms.
Software Developer
Coromandel Cements
.
Project :Business Management Systems (May96
-Dec96)
Environment : Windows95, Visual Basic 5.0 and Oracle 7.1.
Description:
This Project deals with complete production, marketing and management of the products.
Deals with on-line Transactions about Purchases, Sales involving multiple Table handling
and generation of Reports (including Adhoc) Daily, weekly and monthly wise reports.
Responsibilities:
Screen Designing using Visual Basic 5.0
Used Field, Row and Form level Validations
Used Triggers, Stored Procedures extensively
Used crystal reports for Report Module
Professional Qualifications
B.S.
Post Graduate Diploma in Computer Applications
Technical Training
Oracle tools like Developer 2000,PL/SQL
Visual Basic 5.0
JAVA 2.0
Microsoft Certified Professional.
Contact this candidate