PROFESSIONAL EXPERIENCE:

• Oracle Solution Provider
• Keep up with the latest technological developments in ORACLE products through attending professional meetings.
• Keep up with all aspects of Oracle and PL/SQL, holding practice sessions on Oracle 10g, installed on my personal computer network.
• Participate in technical discussions and helping resolve PL/SQL, and other Oracle Web Application Server related problems.
• Help resolve a cartridge related problem caused by inadvertent dropping of Oracle user ID referenced in Web Agent definition. Recreated the user again resolved the issue.
• Solve problems encountered while trying to create a Oracle Form executable on UNIX server.

Confidential

Senior Systems Analyst

• Worked with TOPS Telecommunications Ordering and Pricing System project for GSA as a Senior Systems Analyst with the responsibility of technical lead.
• Played a pivotal role in transforming the system from a character- based interface to a web based GUI system.
• Worked on a faulty Oracle Web Application Server installation and resolved all the problems.
• Resolved the installation issues of Oracle Forms Web server and got it working again.
• Resolved installation issues of Oracle reports web server and got it working again.
• Established and documented procedures for web enabling Oracle Forms and Reports.
• Mentored Oracle Forms and Reports developers in deploying them on the web.
• Developed UNIX cron jobs to shut down and restart web Application Server in an orderly fashion.
• Functioned as the Oracle Application server Administrator for TOPS project.
• Expert in troubleshooting Web Server-related problems. Successfully resolved many problems involving FORMS and REPORT components of Oracle Web Application Server.
• Responsible for the day-to-day maintenance and running of TOPS WEB server.
• Created and maintained all the Web Application Server listeners.
• Created and maintained all operational and test web-sites of Oracle Web Application server, which were modified frequently to cater to specific client requirements.
• Dealt with Web Application Server operational problems encountered from time to time.
• On one occasion, the user-id that was used in listener definition was inadvertently dropped resulting in a crypticmessage that there is a 'cartridge error' while attempting to start the server. The server wouldn't boot up. Successfully traced the problem source and remedied the situation bringing back the server into operation in a matter of a few hours.
• Corrected a situation of loss packets of data when a large number of users are accessing the server from the same port.
• Traced the problem to the client-site configuration and designed a solution to eliminate the problem. The solution involved creating 10 listeners operating on different ports, keeping track of the port the last user logged in and assigning a new port each time in a cyclic fashion. Created Dynamic html using a different port number for each new login and the solution worked fine.
• As part of TOPS project transition effort from one contractor to another, produced documentation and gave a code walk-through to the new team. The documentation included a user guide and a technical manual.
• Created a test Oracle Data Base in MS windows environment.
• Created Oracle tables, views, table indices.
• Created Primary and Foreign keys, synonyms, before and after INSERT, UPDATE and DELETE Triggers.
• For nearly ten years promptly served the needs of Federal Technology Service division of General Services
• Administration with ad-hoc data reports with extensive formatting, using PL/SQL and SQL Scripts.
• Managed Oracle users and their data access privileges.
• Loaded data into Oracle tables using CSV and Standard DATA FORMAT tables to test SQL LOADER.
• Created control file to run SQL LOADER operations.
• Performed data cleansing operations to reload rejected data from bad files populated by SQL LOADER operations.
• Performed export operations to create .exp to distinguish from dump files.
• Performed import operations to recreate database objects from .exp files.
• Resolved many installations, configuration problems and got Oracle web application server up and running for 10 years.
• Created ODBC connection to TOPS Database.
• Created MS access tables linked to TOPS database via ODBC connection to help non-Oracle personal access and analyze TOPS data.
• Created Dynamic data links from Excel spreadsheets to TOPS database via ODBC connection to help non-Oracle
• administrative personal in the central office and in the regions to access and analyze TOPS data.
• Played a pivotal role in transforming the system from a character- based interface to a web based GUI system.
• Performed Oracle forms conversion from 3.0 version to 4.5, 6i, finally 9i and web deployment. Handled a wide range of responsibilities.
• Created Oracle Forms and Reports in PC environment to test them in Client/Server mode.
• Worked with SQL Net to connect PC to HP UNIX server to establish Client/Server testing environment.
• Created PL/SQL procedures incorporating Web Developer Toolkit Library functions to generate Dynamic HTML pages as a part of Web deployment of Oracle Forms and Reports.
• Created PL/SQL stored procedures to authenticate system users.
• Created Special Access PL/SQL procedures to eliminate the problem of loss of data packets when multiple users access the same Oracle Forms listener port from the same IP address.
• Created a PL/SQL trigger to combine a large number Oracle report page windows into one report, in one window, to provide system stability and ease of printing.
• Analyzed and Optimized month-end billing procedures to reduce running time from 30 hours to 6 hours. Received a cash award and an honor for this achievement.
• Developed detailed procedures to migrate oracle forms and reports from PC environment to HP UNIX server and web enable them.
• Provided Help Desk support to help users resolve their technical problems.
• Mentored junior team members to work with Oracle Web Application Server.
• Created UNIX shell scripts to stop and start Oracle Forms listeners, Oracle Web Application server in the correct sequence to facilitate nightly backup and month end billing processes.
• Created a PERL based Vendor Tape Processing Menu system to provide a user-friendly interface to the console operator.

Confidential

Senior Systems Analyst

• Held Systems level position in a software support contract with EPA.
• Created SAS programs, Clists and Panels on IBM Mainframe of EPA computer system.
• Created Clipper programs to process environmental data for Office of Enforcement and Compliance Actions of EPA.
• Maintained interaction with personnel at EPA headquarters and various regions to provide data analysis and software support.
• Maintained Case Conclusion Database. Maintenance included receiving data from regions in a variety of formats and media, maintaining data-entry software, supervising data-entry operations and creating manual and programmatic procedures to QA/QC data.
• For SAMHSA of NIH, implemented a Case Tracking System from partially developed modules with little or no documentation.
• Developed new modules to upgrade the system to the latest version of Clipper Data Base Management System and Novel NetWare.

Confidential

Relational Database

• Provided 1022 relational database management support in DEC 20 environment for Interstate Commerce Commission through Unisys.
• Created 1022 data sets, flat files in 'comma delimited' and 'standard data' formats.
• Created FORTRAN programs and PL 1022 programs to manipulate tables and create reports.