Oracle Developer
Resume:
Title:Digital PID Controller
abpi7z@r.postjobfree.com
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE:
ZIP:
CANDIDATE ID: 2565685
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 386-***-****
EMAIL: abpi7z@r.postjobfree.com
HOMEPAGE:
HOTTEST SKILLS: oracle, sql, database, html, java, perl, unix, informix, product,
javascript, cgi, engineer, credit, c++, cobol, microsoft, data modeling, e-commerce, nt4,
programming
REVISION: 07-SEP-02
RESUME:
Address: 1505 Crystal Drive
Arlington, VA 22202
Phone: 703-***-****
Atul Mehta Work: 703-***-****
Email: [1]abpi7z@r.postjobfree.com
Home Page: [2]www.allnic.com
[3]Objective [4]Summary [5]Experience [6]Expertise [7]Education
[8][shortcut.gif] [9]Click here to download my resume in MS-Word
format.
Objective
A career as an Oracle consultant involving innovation and practical
problem solving that will require my best efforts. Telecommute
preferred.
Summary
* Member of the world's first batch of recipients of Oracle8 DBA
Certification
* Oracle7 Certified DBA with a 8+ year successful track record in
client/server software
* Oracle 6/7/8, SQL, PL/SQL, Developer/2000, Java, Informix 5/7,
Informix 4GL
* Excellent knowledge of data modeling, data warehousing,
backup/recovery strategies
* Skillful problem solver with a strong foundation in Unix, RDBMS,
and Internet technologies
* In-depth understanding of Oracle, SQL, Unix and Web Server
performance tuning issues
* Good analytical and programming abilities using Oracle WebServer,
JavaScript and Perl
* Expertise in Windows NT, Unix, and WinFrame administration and
network programming
* Effective communication, organizing, presentation and leadership
skills
Experience
July 1998
March 1999
[10]Decision Support Systems
111800 Sunrise Valley Drive
Reston VA 20191
[11]Oracle Applications Custom Development
Performed as Oracle Applications Technical Consultant (Financials,
Distribution and HRMS) and Development DBA for building custom
extensions to the system at this computer parts distribution company.
Performed data conversions, created new tables to encapsulate business
rules for special price agreements, promotions, volume sales and
commissions. Developed several new forms and reports as well as
customized standard reports some of which were interfaced with the
[12]Optio [13]Document Customization Server. Wrote PL/SQL programs to
generate [14]EDI transaction files for scheduled transmission to
[15]trading partners. Deployed Oracle Self-Service Web Applications
(Oracle Web Customers, Oracle Web Services, Oracle Web Employees) to
provide secure, self-service access to Oracle Applications in an
intranet/extranet environment. Master minded the e-commerce system
design architecture to integrate Oracle Applications with the
intranet, extranet and the Internet. Gained excellent knowledge of
Oracle ERP application modules (INV, OE, AR, AP, GL, PO, BOM, and HR)
and familiarity with the Oracle Open Interface.
Environment: Solaris 2.6, Windows NT, Oracle 8.0, Oracle Applications
10.7/11 NCA, Oracle Web Application Server 3.0, Oracle Self-Service
Web Applications, ER/Studio, Developer/2000 2.1, PL/SQL, SQL*Plus,
SQL*Loader, SQL Navigator, TOAD
August 1997 July 1998
[16]General Services Administration
18 & F Street
Washington DC 20581
[17]Data Warehousing / Web Deployment at GSA
[18]RIS: This project primarily involved migration of the Regulatory
Information Systems (RIS) data warehouse from Model 204 mainframe to
Oracle RDBMS. In addition, the project work entailed deploying review
and error reports on the Web to enhance agencies' current access to
pertinent regulatory publications. Architected a thorough STAR schema
design using ERWin to consolidate M204 attributes. Analyzed system
requirements and wrote detailed functional specifications for data
migration. Created the RIS database and loaded data from M204. Wrote
batch jobs to automatically replicate Oracle with M204 data on a
nightly basis. Coded Oracle PL/SQL stored procedures to implement
security and to dynamically generate HTML forms for submitting report
requests. Helped debug complex reports developed using Reports 2.5.
More than 300 agency users are satisfied with the performance and ease
of use.
[19]TARGETS: Total Account Reconciliation and General Expense Tracking
System (TARGETS) was developed by the Northwest Region (Region 10) to
provide an automated record of financial obligations, adjustments and
pre-validations against the budget plans. Functioned as a DBA and
migrated the Region 10 TARGETS database to central office from a SCO
Unix environment to Windows NT4. Created database instances for 11
regions for nationwide deployment of TARGETS. Duties included
planning, establishing backup/recovery/failover schemes, tuning,
create database links to FMIS, loading data and provide production
support. Deployed the Developer/2000 1.5 forms and reports on the Web
using two load balanced WinFrame 1.7 servers. Resolved all problems
running the TARGETS application on WinFrame.
[20]TOPS: Deployed the Telecommunications Ordering and Pricing System
(TOPS) forms and reports on the Web using Developer/2000 1.5 and the
Cartridges provided with Developer/2000. Used Designer/2000 to fix
deficiencies in the TOPS data model.
Environment: Windows NT4 Server, WinFrame 1.7, Oracle 8.0, Oracle
WebServer 2.1, Developer/2000 1.5, PL/SQL, CGI, HTML, JavaScript,
SQL*Loader, ERWin, Designer/2000
September 1996
- August 1997
[21]Globecast
3872 Keystone Ave.
Culver City CA 90232
[22]GlobeCast E-commerce using Oracle WebServer
Created heavy-duty PL/SQL procedures with embedded JavaScript, which
maintain orders for GlobeCast services. Assisted in reverse
engineering the existing database design into PowerDesignor and made
corrections to the logical and physical model as well as created the
ERD for the database. An order can be for domestic or international
services and is used to schedule and manage the daily broadcast
business of GlobeCast. The information captured provides the basis for
revenue generation and cost containment analysis. Customers are
required to have a current contract in the system. Wrote 100,000 lines
of code for the most difficult order entry screens for this Oracle
WebServer based e-commerce application. Also worked as and Oracle DBA
with functions including creating and administrating of databases,
loading data, creating database objects, users and tuning of queries.
Environment: Windows NT4 Server, Oracle 7.3, Oracle WebServer 2.1,
PL/SQL, CGI, HTML, JavaScript, PowerDesigner
March 1996
- September 1996
[23]MCI
18&F Street
Arlington VA 22202
[24]networkMCI - Intranet/Oracle Data Repository
A recent legislature allows customers to change local telephone
companies. Worked as a web/database applications specialist at
networkMCI to provide for an intranet based solution and database
design. Completed thorough data modeling of the system using ERWin.
The database links with multiple Oracle 7.x databases. Developed the
Oracle WebServer 2.0 intranet front-end using HTML, CGI and PL/SQL
stored procedures.
[25]internetMCI - Automated Web Hosting Services
Worked as a technical specialist at InternetMCI for automated content
management, site/server monitoring and management, website reporting
using Netscape Servers. Worked relentlessly with JavaScript, Java,
JDBC, Oraperl, HTML, NSAPI and C. Worked on Java-Oracle database
connectivity using JDBC in a 3-tier architecture.
Environment: HP9000, HP-UX, Solaris 2.4, ERWin, Oracle 7.x, Oracle
WebServer 2.0, Netscape Servers, PL/SQL, CGI, HTML, JavaScript, Java,
JDBC, Oraperl, Perl 5, NSAPI and C
March 1996
- September 1996
[26]MBNA Corporation
Stanton Christiana Drive
Newark DE 19711
[27]Platinum Plus Card Credit Line Increase Queue Database
An online system for on call immediate processing of credit line
increases for privileged Platinum credit card customers and 15 minutes
turnaround time for others. Redeveloped and optimized 4GL libraries
for forms and reports. Designed a database and wrote all programs for
this automatic processing of requests, and went production in 3
months. The system is expected to increase turnover by a few million
dollars.
Environment: HP-9000, HP-UX, Informix 5.0, Korn Shell, Perl 4
August 1995
- January 1996
[28]OfficeMax
Shaker Heights
Cleveland OH 44122
[29]Credit Card Imaging System
An image of credit card slips from all stores is stored in this
database. Re-engineered the Informix database and wrote programs to
add workflow capabilities. Images of slips come on tapes from imaging
vendors. Redid the crucial nightly tape load process in Perl to load
images into an Oracle 6.0 database flawlessly - resulting in a monthly
savings of $200,000 due to higher hit rate during image retrieval of
slips and lesser downtime.
[30]Freight Invoicing and Payment System
Ryder ships OfficeMax products to stores throughout the US. Designed a
database and loaded it with records from indexed sequential files
originally handled by COBOL programs. Wrote programs in 4GL and ESQL/C
for entry, maintenance, edit checks and reports - for invoices,
receipts and shipments. A maintenance 4GL program provides a 'cruise'
mode i.e. instead of the user having to painfully go through a million
records manually to correct errors if any, the program automatically
searches in the tree of tables -- master, detail and purchase orders,
looks for errors and pops up with an appropriate maintenance form
window only when manual correction is necessary.
Environment: Unisys, Informix 7.11, Oracle 6.0, Korn Shell, Perl 4
Singapore
June 1993
- June 1995
[31]NEC Singapore
World Trade Center
Singapore
[32]Unix Support for NEC EWS/UP 4800 Servers
At Asia Common Technology Center, provided central regional Unix
support to NEC subsidiaries in Australia, Hong Kong, Malaysia, India,
Taiwan and Thailand. Involved in setting up a WWW site for NEC product
support and FAQ. Gained expertise in scripting Korn Shell and Perl, as
well as HTTPD configuration. Conducted product evaluation/benchmarking
of NEC and third party disk arrays, jukeboxes, DAT drives, QIC tape
drives for NEC MIPS-based servers and wrote HTML FAQs for them.
Environment: NEC Servers, SVR4.2, Informix 5.0, Oracle 6.0, Korn
Shell, Perl 4, CGI, HTML
[33]Government Security Systems Gateway
Independently designed and developed a high performance SCO Unix based
SNA gateway server between IBM MVS/ESA and NEC/ACOS-4/XVP using SNA
LU6.2 and TCP/IP protocols. Automatic LU recovery, fault tolerance,
network management, online monitoring and diagnostics, versatile
security, and dynamic configurability were key features of the server.
2 ministries in Singapore are presently using it.
Environment: SCO Unix, C, Korn Shell, NEC ACOS-4/XVP mainframe, IBM
MVS/ESA
[34]IRIS - Document Imaging System for Income Tax Returns
Involved in development of a client/server document imaging system for
the [35]Inland Revenue Authority of Singapore (IRAS). Income Tax
Returns and letters are scanned by a high speed Fujitsu scanner to be
stored as blobs by C programs in a jukebox controlled by Informix. The
returns get OCRed using XDR from Recognition Software, workflow (from
Imageflow) gets created by C programs in the database depending on the
OCRed data to be routed to clerks. Plexus 4GL programs allow 4GL forms
for Windows to give different work to clerks. Wrote several 4GL and
ESQL/C programs to gather statistics on OCR.
Environment: HP-9000, HP-UX, Windows 3.1, Informix 5.0, Korn Shell,
Plexus 4GL, ESQL/C
India
June 1992
- May 1993
[36]Frontier Computers
Shirole Road
Poona
Porting of RPC/XDR and X Windows from Unix to Windows 3.1
Top designer and programmer with this innovative software development
company. Involved in porting of RPC/XDR and X Windows from BSD Unix to
Windows 3.1 using Winsock v1.0. Currently being marketed in the USA by
Mequon-based [37]Frontier Technologies Corporation as a part of the
[38]SuperX Suite, which has [39]received several awards.
Environment: 486, Interactive Unix, Windows 3.1, Microsoft C/C++ 7.0
June 1991
- May 1992
[40]Indus Software
Deep Bungalow Chowk
Poona
[41]Synthesis Application Gateways
Synthesis is India's first Windows based CASE tool, which is a
structured systems analysis and design workbench with a central data
dictionary. Also present in Synthesis is a prototyping tool. Served as
the sole designer and development engineer of crucial Synthesis
gateways to Magic, Oracle, Sybase and FoxPro. Also wrote a COBOL
reverse engineering tool, using which COBOL code can be ported to any
other platform for third-party software integration with a CASE tool.
The software was written for English and German users. Several copies
of the software have been exported to Germany.
Environment: 486, DOS, Windows 3.1, Microsoft C/C++ 7.0
June 1990
- May 1991Nishko Instruments
MIDC, Bhosari
Poona
[42]Digital PID Controller
Primum Opus. As a final year industrial project, developed a digital
PID instrumentation controller using the Z80 processor. Designed the
hardware and developed software for closed loop PID control.
Implemented a fast 24-bit floating-point library using dual register
set of Z80 for real-time performance. It's in the market.
Environment: 486, Z80 emulator, Z80 assembly
Expertise
Languages
DBMS SQL, PL/SQL, SQLJ, Informix 4GL
Object Oriented Java, C++
Scripting JavaScript, VBScript, Perl, Oraperl, ksh, csh, sed, awk
High-Level C, Pascal, Fortran, BASIC, COBOL
Low-Level Assembly (Intel 80x86 / 8085 / 8057, Z80)
Strengths
Administration Oracle RDBMS (7, 8, 6), Server Manager, SQL*Loader,
SQL*Plus, SQL*Net, Net8, Oracle Web Server, MS IIS, Netscape, Apache,
NT Domain, Citrix WinFrame
Data Modeling LogicWorks ERwin, Embarcadero ER/Studio, Oracle
Designer/2000, Sybase PowerDesigner
IDEs Oracle Developer/2000 (Forms and Reports), TOAD, SQL Navigator,
Oracle JDeveloper, Symantec Cafe, Microsoft Visual J++, IBM Visual
Age for Java, Microsoft Visual C++
Programming Interfaces ISAPI, NSAPI, OLE, MAPI, TAPI, Win32
Oracle Pro*C, Informix ESQL/C, JDBC, ODBC, DAO
Office Tools MS Office, MS Project, Adobe Photoshop, FrontPage
Education
1987
-1991 [43]University of Poona, MH, India
Bachelor of Engineering
[Computer Science] First Class
References
Available upon request
References
1. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/at
abpi7z@r.postjobfree.com
2. http://www.allnic.com/
3. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/ur
l.947338605.8.html#Objective
4. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/ur
l.947338605.8.html#Summary
5. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/ur
l.947338605.8.html#Exprience
6. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/ur
l.947338605.8.html#Professional Expertise
7. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/ur
l.947338605.8.html#Education
8. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/re
sume.doc
9. file://localhost/home/beta/Easytrieve/cvsroot/root/data/www.northernlight.com/fetch/re
sume.doc
10. http://www.gsa.gov/
11. http://www.gsa.gov/
12. http://www.optiosoftware.com/
13. http://www.optiosoftware.com/products/ERP/dcs.asp
14. http://www.seagate.com/support/edi/edimenu.shtml
15. http://www.seagate.com/support/edi/index.shtml
16. http://www.gsa.gov/
17. http://www.gsa.gov/
18. http://reginfo.gov/
19. http://www.finance.gsa.gov/
20. http://www.finance.gsa.gov/tops/tops.htm
21. http://www.globecast.com/
22. http://www.globecastna.com/
23. http://www.mci.com/
24. http://www.mci.com/mcisearch/aboutus/products/glossary/intranet/index2.shtml
25. http://www.mci.com/aboutyou/interests/internet/connect/forbiz/index.shtml
26. http://www.mbnainternational.com
/
27. http://www.webapply.com/platinumplus
/
28. http://www.officemax.com
/
29. http://www.officemax.com
/
30. http://www.officemax.com
/
31. http://www.nec.com.sg
/
32. http://www.nec.com.sg/Product/servers.htm
33. http://www.nectech.com/afis
/
34. http://www.iras.gov.sg/info/cis_iris.html
35. http://www.iras.gov.sg
/
36. http://www.frontiertech.com/CONTACT/CONTACT.HTM
37. http://www.frontiertech.com
/
38. http://www.frontiertech.com/XSALE/HOMEPAGE.HTM
39. http://www.frontiertech.com/CORP/COMPETE/COMPETE.HTM
40. http://www.indussoft.com
/
41. http://www.indussoft.com/Products.html
42. http://instserv.com/orphn/pid.htm
43. http://cs.unipune.ernet.in
Contact this candidate