Database Resume
Silver Spring, MD
SUMMARY
PROFESSIONAL EXPERIENCE
Confidential,Silver Spring, MD
Database/Software Developer/, Feb. 2010 – Present
Sr. developer/analyst working on the Dealbuilder Application. Dealbuilder utilizes PB 9, with an Oracle 9i back end. Primarily a back end application, with the majority of business logic placed in stored procedures. Responsible for developing Oracle Stored Procedure code in PL/SQL, unit testing, and deploying to QA environments. Tools used are TOAD, SQL Plus, Source Safe and Remedy for ticket tracking. Also developed and maintained SQL Server (SQL Server 7.0 and SQL Server 2005/ Visual SQL Server Studio ) using Transact-SQL to develop, packages and procedures for other PB 9 applications.
Confidential,Suitland, Maryland
Sr. Powerbuilder Developer/Analyst, Nov. 2008 – Feb. 2010
Sr. Powerbuilder developer/analyst working on the CMOCS (Coverage Measurement Operations Control System ) for the US Census Bureau. CMOCS is a control and tracking system for CCM operations in the Regional Census Centers. The system tracks and reports progress on CCM operations. System used for the 2010 Census. CMOCS is written in PowerBuilder 11.5 using Powerbuilders PFC and Object Oriented (OO) concepts. Backend processing is written in C/P/L SQL stored procedures on a SUN/Solaris UNIX server. Both of these components interact with an ORACLE 10G database, which reside on a SUN/Solaris server. TOAD for Oracle and PVCS Version Manager 8.2 were also used for project.
Confidential,Hyattsville, Maryland
Java Developer, May 2000 – Nov 2008
JAVA/J2EE / Sr. Powerbuilder developer for U.S. Department of Treasury. Responsible for developing and maintaining the FMS224 and FMS224 Bulk applications, which are used by the D.O.T. to receive information about the financial conditions and operations of federal agencies. The FMS224 provides Treasury with reports of agency payments and collections which serve as a basis of Treasury’s publications to Congress and to the public regarding federal revenues and expenditures. System developed using Powerbuilder 6.5/10.0 and Sybase System 12 on a UNIX platform. Re-engineered to be J2EE compliant, using IBM’s Websphere (v 6.0 ), JAVA, Javascript interfacing with Oracle 9i/10g. Other tools include EJB’s, Servlets, JSP, Struts and Clearcase for version control . Also coded C and C++ scripts and Oracle stored procedures.
Confidential,Linthicum, Maryland
Sr. Powerbuilder Developer, Nov. 1999 – May, 2000Developed and maintained a transportation management system (OrbCAD-NT) used for tracking and locating moving vehicles. Software was developed using Powerbuilder 7.0 and MS SQL Server 7.0. OrbCAD-NT incorporated object oriented development standards along with the use of Orbital Sciences pre defined base class object and Powerbuilders PFC. Lead Powerbuilder developer on an eight member team.
Confidential,Tysons, Virginia
Developer/Analyst, Aug, 1999 – Nov, 1999Part of a three member team developing RIS ( Rates Information System ) software used by Cable & Wireless for the purpose of tracking and adjusting phone rates for different customers. Software was developed using objects inherited from the PFC (Powerbuilder 6.5) and Oracle 8.0. Responsible for developing user objects which would allow the RIS system to read and validate Microsoft Excel spreadsheets using Powerbuilder.
Confidential,Columbia, Maryland
Sr. Powerbuilder Developer/Analyst, Feb, 1999 – Aug, 1999
Creating software to be used by Norwest and Wells Fargo Banks. Developed software using Powerbuilder 6.5 and 5.04 in a Windows NT environment. SQL Server 6.5 is used as the development and production database. The application is be used to track the stages and life cycle of bank loans. Sr. Powerbuilder developer on a five member team doing requirements analysis, window and database design, coding and testing.
Confidential,Bethesda, Maryland
Analyst, April, 1997 – 1999
Developed software in conjunction with a five member team for the NRC (Nuclear Regulatory Commission). Developed software using Powerbuilder 5.0 in a Windows 3.1 and Windows NT environment. Application is to be used by the Nuclear Regulatory Commission (NRC) for nuclear reactor inspections, activities, programs and scheduling. The primary database used is Sybase System 11. PFC objects used to develop application.
Confidential,Laurel, Maryland
Software Developer, 1996 - 1997
Designed and developed SPS (Standard Procurement System) software for Dyncorp. Software is to be used by the government as a standard system for awarding contracts. Developed windows, menus, and datawindows for application using Powerbuilder 5.0 in a Windows 95 environment. Performed OLE functions to open datawindows in MS-Word. Ensured that base class objects adhered to encapsulation (ancestor performs generalized tasks and the descendant performs specific tasks). Application to be deployed on a variety of platforms with databases including Oracle 7.1, 7.2, SQL Server, Sybase 10 and Informix5. (Contract ended )
Confidential,McLean, Virginia
Analyst, 1992-1996
Assigned as a software developer on TOPMIS II (Total Officer Personnel Management Information System). Involved in the conversion of the current TOPMIS system from a mainframe environment to a PC environment. Reengineered an existing system using Powerbuilder and other GUI tools. The TOPMIS II project is utilizing Powerbuilder 4.0, with the production database being Oracle 7 distributed across two RS/6000s SQL and PL/SQL are also utilized for database access.
Progressive experience in all phases of the system software life cycle. Programming and application design and development experience. Knowledge in design, development, testing, installation, and maintenance of online and batch systems in the IBM (compatible) environment. Extensive expertise in the use and operation of CASE tools (e.g., INTERSOLVS APS); CICS/VSAM, CICS/DATACOM environments, OS/MVS, TSO/ISPF, IMS/VS, OS JCL and ROSCOE operating systems.
EDUCATION
COMPUTER PROGRAMMING DIPLOMA
B.S., MARKETING
