SUMMARY : Senior Database Developer with extensive experience in all phases of software development lifecycle. Full SDLC with Oracle 10g databases, designing systems and applications using Oracle PL/SQL, triggers, creating table spaces and SQL. Able to effectively analyze designs and implemententerprise web-basedproducts with multi-tier client server architecture that encompasses client server, mid-range and mainframe computers. Enhance existing systems with new features and performance improvements that result in 30 thousand dollars in cost savings. Core strengths in:

• Oracle 10g/ Database Design & Programming -Oracle 10g - JAVA/Linux Shell Scripting
• Product Conception, Design & Specification -Oracle PL/SQL - MySQL/DB2/IMS
• Cross-Function Communication -C/COBOL -UNIX/MVS/IBM 390
• FTP Servers / Networking -SFTP/FTP -Toad/SQL/SQL PLUS
• Troubleshooting & Problem Solving -UML -SDLC/RDMS
  

PROFESSIONAL EXPERIENCE

Principal Systems Developer
Confidential, Reston, VA 2000-2012

Managed corporate Fraud Backend Database (FBE) system of Oracle 10g on Linux platform.Defined user requirements, validated user acceptance testing, trained users on Oracle application development, preformed data migration and identified enhancements for project management community. Wrote Oracle PL/SQL modules to process many types of billing systems.

• Developed, coded and implemented complex Oracle invoicing system allowing shutdown of Virtual Address eXtension (VAX) COBOL System and saved $50K in VAX recurring fees.
• Upgraded FBE systems from Oracle 9g to Oracle 10g for PCI audits to prevent security threats always passed security audits to get systems validated by outside security auditor.
• Wrote batch scripts to process numerous types of transactional files, increasing revenue by $10K per month via customer requirements using Oracle triggers and automated Oracle SQL scripts.
• Performed data analysis and data mapping to Identified process to migrate 20 million Comcast telephone numbers and other identifying information to a new data extract that was loaded into MySQL database tables, increasing revenue by $10K per month from revenue sharing agreements. Wrote unique mapping programs and procedures to map data into correct format.
• Performed user/system testing on Oracle data servers for new Java application, replacing old Stratus box for transaction processing that saved $500K a year in recurring fees. Validated all processes that went to old Stratus box directly to new Java processes and verified accuracy of all data inserted into billing tables and returned to customer, led to renewal of contract.
• Interacted with other highly technical specialists to provide complete business solutions.
• Resolved technical issues and wrote scripts and processes that interface with outside vendors and customers to exchange mission critical data via FTP/SFTP servers. Processed thousands of daily files for many applications, from TSD FTP servers to internal/external TNS applications.
• Did system integration testing for various CNAM releases between web servers and MySQL database servers to insure quality of release and increase revenue by 10K per month for increased business traffic.
• Made modifications to TSD webpages using Perl/JSP changes to enhance web screen usage per customer requirement changes which resulted in additional website usage and increased 5K in monthly revenue.

Software Engineer III
Confidential, Herndon, VA 1996-2000 (40 hours week)

Served as team lead for FTS2001 telecommunications contract project, which involved developing a multiplatform billing system for our government clients. Named team lead for 25 programmers in defining requirements and resolving technical issues and solutions for full lifecycle development. Held design meetings with developers to correctly develop program requirements. I help developers solve difficult technical issues involving JCL/Cobol problems. The FTS2001 project was an RFP project producing a combined telecommunications bill by Sprint for the government client GSD. In order for Sprint to win the contract, it had to produce a bill that the government signed off on.

• Helped meet critical software deadlines by creating solutions for many technical issues involving coding and processing issues to meet deadline deliverables.
• Designed, developed and implemented code and methods and procedures in converting Oracle pricing tables into DB2 pricing tables for FTS2001 project to insure billing rates were correct for invoices.
• Coded complex DB2-COBOL II programs for a variety of applications related to telecommunications that increased revenue by $20K per month.
• Formulated test plans and expected results to ensure process results matched desired results in client server/mainframe environments.

Programmer / Analyst
Confidential, Herndon, VA 1987-1996 (40 hours week)

Served as core team leader who ensured changes to private line applications were completed in quarterly releases. Managed and coded numerous COBOL II programs, customer reports and JCL job streams to make sure actual output matched desired results.

• Coded complex DB2/IMS COBOL II programs for a variety of applications related to telecommunications for many private line data quarterly releases.
• Served as core team representative for full lifecycle development of numerous projects that involved billing applications that billed millions of dollars a month.

EDUCATION

MSIS, Master of Science Information Systems
MBA
BBA, Computer Information Systems

BACKGROUND

United States Navy Operations Specialist 1980-1983 (Active Duty)
United States Navy Reserve 1983-1988

• Assigned to USS Nicholson DD-982 destroyer in Charleston, SC.
• Established understanding of teamwork fundamentals and participated in exercises in a combat environment.
• Obtained Secret security clearance for handling classified information.
• Served as track supervisor of Naval Tactical Data System.