Profile

Over 10 years of life - cycle experience in project analysis, systems design, data modeling, programming, management, and user-training in an Oracle database environment.

Skills

• Languages: SQL, PL/SQL, XML, XSL, XSLT, XQuery, Perl, ASP, Java, Unix scripting languages, Oracle Developer 6, Oracle Forms Builder 6, Forms 4.5/Reports 2.5, Gupta SQLWindows, Visual Basic for Applications, Visual Basic 6, Crystal Reports, Rational Suite, Javascript, ProCobol, COBOL-CICS, JCL
• DBMS: Oracle 11g/10g/9i/8/7.3, Sybase, DB2, DBC by Teradata, Easytrieve, XDB, VSAM, ISAM
• Applications, Tools and Technologies: TOAD, SQLPlus, MS Team Foundation Server 2008, MS Visual Studio Team System 2008, BMC Remedy, Rational ClearCase, Rational ClearQuest, AutoSys, Telelogic DOORS, PLSQL Developer, SQLLoader, Altova XMLSpy, Eclipse, Rational Software Architect, ADW, TSO-ISPF, MicroFocus Cobol Workbench, SQLRouter 2.0, JES2
• Operating Systems: UNIX, HP-UX, MS-DOS, Windows XP/NT, MVS-ESA, DOS-VSE
• Hardware: HP servers, Sun Solaris Servers, IBM RISC-AIS, IBM ES-9000, IBM 3090, IBM 43xx, IBM RISC 6000, IBM PC, PowerMac, Novell Netware, Netframe Super Server

Work Experience

Confidential

Sr Oracle PL/SQL Developer/Database Administrator

• Designed and created new database objects for a new project for the AVS division
• Created deployment scripts for new and revised database objects
• Created/Revised database packages to implement new business requirements
• Optimized existing PL/SQL code to improve performance
• Performed Database Administration tasks in the development and test environments
• Created scripts and procedures to load reference data from Excel spreadsheets to database tables
• Generated ad-hoc reports pulling data from the database as requested by clients
• Tested and debugged all assigned programs

Confidential

Applications Development Analyst

• Performed duties of Release Coordinator which include generating code baselines for all projects using build scripts
• Created database packages to implement business requirements
• Created unit testing and component testing database packages with various possible scenarios to verify that the business requirements are properly implemented. These test packages use UTPLSQL, a unit testing framework for PL/SQL development
• Performed string testing of batch components in Unix servers using Autosys commands
• Coordinated efforts of the batch development team to resolve issues raised by system test and business compliance test teams
• Provided first level of production support by triaging production incidents reported by Technical Operations team
• Created SQL scripts to generate XML documents from relational data
• Participated in discussions to create data models to incorporate new Treasury programs
• Wrote sections of High-Level and Detailed documents for certain programs under the HAMP

Confidential

Applications Development Analyst Fannie Mae

• Created database packages to implement business requirements
• Created unit testing and component testing database packages with various possible scenarios to verify that the business requirements are properly implemented. These test packages use UTPLSQL, a unit testing framework for PL/SQL development
• Performed string testing of batch components in Unix servers using Autosys commands
• Coordinated efforts of the batch development team to resolve issues raised by system test and business compliance test teams
• Provided first level of production support by triaging production incidents reported by Technical Operations team
• Created SQL scripts to generate XML documents from relational data
• Wrote sections of High-Level and Detailed documents for certain programs under the HAMP

Confidential

Sr. SW Sys Technologist II USPTO Software Development and Integration SDI

• Lead programmer for all AISs in the Data Control Division DCD of the Office of Patent Classification OPC of the US Patent and Trademark Office. These AISs include client-server Oracle Forms and Reports Intranet Web forms written in ASP and Perl SQL scripts, PL/SQL programs and packages cron jobs and shell scripts in Unix servers. -Assumed duties of a Database Administrator after the CDS system's DBA position was removed due to budget cuts. Fixed problems when the Recovery Manager RMAN backups started having errors. Resolved tablespace and data file problems when space issues came up
• Participated in the reverse-engineering of the data model of the current system and design for a proposed new system -Revised, tested and deployed a process to use the new standard format ST 36 for data interchange between the World Intellectual Property Organization WIPO and USPTO -Participated in project management meetings during the initiation phase of the CDS 2.0 project -Successfully turned over the Limited Family process to the USPTO's DMB group. DMB group can now run the Limited Family process by themselves without the presence of any Raytheon maintenance or DCD staff -Received a rating of Exceeds Requirements for the previous 3 rating cycles -Recipient of the Raytheon Technical Honors for 2008 -Received letters of commendation from customers for exemplary performance resulting in cash awards from Raytheon -Coordinated the activities in the seamless shutdown of the CDS Desktop AIS -Exported backups of CDS Desktop master tables before the CDS Desktop AIS was shutdown. The backups were used when Senior Classifiers needed the markings made in CDS Desktop and copy them over to the CDS client server system. -Processed and deployed all 5 versions of the International Patent Classification symbols since 2006. The IPC symbols were distributed by the WIPO as XML documents. I created a process that parsed and loaded the IPC symbols to the PTO databases using XSL stylesheets and Oracle utilities. -Trained new members of maintenance staff to resolve most problems in the CDS systems. Assigned work to staff. -Processed the Working lists and propagated the transactions and markings for IPC harmonization projects. Generated results document in XML which was then sent by customer to the World Intellectual Property Organization. -Provided prompt response to all ad-hoc requests from users and Senior Patent Classifiers in the International Liaison Staff ILS -Wrote the Operations Support Plan document as a requirement to transfer operations of CDS systems to the data center
• Revised database structures in the CDS PGPubs system to address new requirements for International Patent Classifications Reform project -Modified all Oracle forms, reports, scripts in the CDS PGPubs system to address new requirements for International Patent Classifications Reform project -Created process to load IPC Valid Symbols in XML documents from WIPO to Oracle databases -Continue to perform all the responsibilities under the previous USPTO-SDM contract Contact Supervisor: Yes, Supervisor's Name: Usha Jairam, Supervisor's Phone:

Confidential

Computer Scientist USPTO Software Development and Maintenance

• Support and maintain the CDS PGPubs, CDS Desktop as well as CDS 1.0 system
• Monitor and maintain the backend processes for PGPubs Web MTR, Patent Web MTR, Patent Sync with Desktop and PGPubs Sync with Desktop
• Converted 3 processes from UNIX to client-server using Oracle Forms and PL/SQL
• Converted 4 UNIX awk scripts into PL/SQL functions
• Optimized all of the SQL queries and scripts to improve response time
• Organized several SQL scripts into PL/SQL procedures and packages to improve performance and simplify system maintenance
• Created programs that generates Oracle reports into Excel spreadsheets
• Created a program that loads data from Excel spreadsheets in multiple formats into multiple Oracle tables. This program enabled the users to load hundreds of transactions in minutes
• Created 4 sets of procedures for the back-end processing of transactions entered through the PTO Intranet
• Applied all of the Certification and Accreditation fixes specified by USPTO's Security office onto the CDS PGPubs system.
• Converted all the forms and reports to conform to Windows-XP policies
• Assisted in user training for CDS PGPubs and CDS Desktop systems
• Generated various statistics and reports for both PGPubs and Patents data, even if there are other members in the team who have been handling the Patents data system longer than he has. These requests average about one per week. The clients trust me to be able to give them the information they need when they need it.
• Performed production data processing every 2 months to synchronize PGPubs data between several databases
• Performed minor DBA functions

Confidential

Systems Analyst Peace Corps Contract

• Converted and implemented the Client-server programs developed using Forms 4.5 on the Mac to Oracle Forms Builder version 6 on Windows NT
• Developed a Client-server system for the Domestic Programs Division to merge the databases of the RPCVs, the World Wise Schools, the Fellows Program and the Staff Alumni into one Oracle database
• Developed the Client-server system for the Office of Privates Sector Cooperation and International Volunteerism OPSC/IV which handles the solicitation of donations and funding of some of Peace Corps projects in foreign countries
• Converted OPSC/IV's FileMaker Pro data to Oracle
• Created reports and online programs using Oracle Developer 2000 for Client-server system
• Converted programs from Oracle Forms v2 to version 3
• Revised Oracle forms and reports programs for Year 2000 compliance
• Performed some minor DBA functions

Confidential

Systems Analyst and Project Leader

• Designed the General Ledger System GLS for the Trust Banking Division
• Coordinated the user-acceptance testing for the GLS
• Optimized and installed the Trust Fee computation module of GLS
• Revised all programs and stored procedures to improve the batch processing of the Trust Fee computation module

Confidential

Systems Analyst

• Team Leader for the Deposits Management System Project for a commercial bank in Jakarta, Indonesia
• Led the CA/SA module team
• Coordinated with the bank's user acceptance testing team
• Performed problem determination and resolution
• Debugged and optimized the conversion programs

Confidential

Software Engineer

• Created the General and Detailed design specifications for the Bids Evaluation module of the Caltex Materials Procurement and Inventory Control System for Caltex Pacific, Indonesia
• Performed programming and unit testing for online programs of the Bids Evaluation module
• Performed programming, debugging and integration testing of online and batch programs for the Product Inventory System for Telemecanique a French manufacturing company

Confidential

Analyst/Programmer

• Developed and tested online and batch programs
• Integrated and debugged all the online programs
• Assisted in user training

Confidential

Software Engineer

• Credit Card System for the Philippine National Bank Credit Card
• March 1990 to April 1990, June 1991 to March 1992
• Developed programs and integrated all online applications
• Assisted Project Leader in designing several modules
• Optimized some programs to improve processing time
• Developed online programs for the Retail Banking System RBS for the Security Bank
• Assisted in the design of the Conversion System for the bank's old data to data as required by RBS
• Coded, tested and integrated all programs for the Conversion System

Other Skills

• Proficient in MS-WORD, MS-EXCEL, MS-Project, WordPerfect,
• Lotus 123 and some experience in IBM mini-computers and utilities