Technical Summary:

• Specializing in database development and design, writing and optimizing stored procedures ETLs for MS SQL Server, Oracle Sybase ASE 15.
• Highly successful in writing and optimizing complex stored procedures, Expert in SSIS, Crystal Reports, can read .Net code. Can program in VB.Net, PowerShell, UNIX korn shell, awk, regex.

Skills also include: VBA Excel and MS Access , VB6, ADO, ADO.Net, Crystal Reports, Entity Framework, Ibatis.Net, XML, OLEDB, ActiveX, COM, COM , DCOM, DCOM , MS Word, MS Project Manager, Visio, UNIX Korn shell scripts, Perl.

Source control systems used: Team Foundation Server, Visual SourceSafe VSS , Subversion

Third party tools: Crystal Reports, Dundas Charts, DevExpress, DXperience, Ibatis.Net

DBMSs: Oracle 8i, 9i, 10g 11g RAC , MS SQL Server 2000 thru 2008R2 , Sybase

UNIX scripting Korn shell, awk, grep, sed

Professional Summary:

• 20 years software and database development
• 18 years relational database development design normalization, indexes, constraints, triggers , writing and optimizing queries and stored procedures, ETLs, reports, CTE
• 9 years MS SQL Server through 2012 , 2 years SSIS
• 8 years Oracle through 11g PL/SQL
• 1.5 years Sybase including Sybase ASE 15
• 10 years Crystal Reports through version 11
• 5 years writing EVMS software, ETLs and reports for Primavera Earned Value Management databases VB, Crystal, Oracle SQL Server
• 18 years promoting software process improvement, including coding guidelines, code reviews, configuration management, change management using defect-tracking tools Wrote SQL coding guidelines and database naming conventions for USAID
• 20 years SDLC, including requirements gathering, planning, design and documentation
• 1 year agile development
• 16 years rapid application development with prototyping
• Software Quality: Code is always thoroughly commented, documented and conforms to coding guidelines. Use intelligent error trapping and logging
• Supervision: 3 times technical team leader for software development and twice supervisor for electronics test repair group
• Background in Electronics: Over 20 years in telecommunications, computers, radio, television, avionics, and audio. Two years design of process control systems, high speed modems and spread spectrum modems, 4 yrs in Air Force electronics, 1 yr supervisor of test repair department, 4 years owner electronics repair company. FCC general class license

Detailed Experience

Confidential

Database Developer Contract Employee

Analyzed security in databases, set up missing backups, added missing indexes, fixed errors in stored procedures and in SSIS packages and SSRS reports, wrote and optimized stored procedures. Also performed minor DBA functions, such as creating indexes in 3 SQL databases, setting up missing backups, cleaning out old logins and reducing elevated permissions where not needed. They had no DBA.

Confidential

DATABASE DEVELOPER

Designed and created a new SQL Server 2012 database, based partly on a similar one, for a new manufacturing line. Wrote and optimized stored procedures. Stripped out or archived old data. Wrote ETL SQL scripts to transfer and merge data from two other databases into the new one, modifying and cleansing data as needed. Also performed minor DBA functions, such as creating indexes in the 3 databases, adding foreign key constraints and setting up missing backups. They also had no DBA.

Confidential

DATABASE DEVELOPER

Wrote and optimized stored procedures SQL Server 2008 R2 . Refactored and optimized SSIS packages, including VB.Net and C code. Moved SSIS solutions to TFS Team Foundation Server from VCS. Wrote PowerShell scripts to generate SQL scripts for all databases to put into TFS, and generated SQL scripts using VS2010 database solutions. Wrote 2 MS Access applications to report data quality problems. Wrote PowerShell scripts to parse a variety of files, including postscript, XML, text.

Confidential

PL/SQL developer

Wrote and modified stored procedures Oracle 10g 11g RAC , SQL scripts and UNIX Korn shell scripts using Regexp, awk, grep, sed, etc for large, complex ETLs for network provisioning. Analyze data to find best matches for data repair cleanup, de-duping, etc.

Confidential

Database Developer

Supported web application programmers by writing, correcting and optimizing stored procedures in a large, complex SQL Server 2008 R2 database. Wrote and maintained ETLs and reports that use T-SQL stored procedures, SSIS and SQL Agent.

Environment: SQL Server 2008 R2, SS Management Studio, SSIS, Visual Studio 2005, 2008 2010, Perfmon, Rally CM, Notepad , MS Access, Excel, Microsoft Team Foundation Server TFS for version control and build control.

Confidential

Technical Team Lead,

Project to revise multi-tier, object-oriented, flight attendant bid-award software: Oracle 10-11g, VB6, COM , DCOM, Visio. Gathered requirements analyzed existing software to list required changes to VB6 code and stored procedures for the overseas company HCL in India that the actual coding was outsourced to. Wrote VB6 coding standards cleaned up VB6 code: inserted Option Explicit, corrected coding errors, extended Hungarian notation to indicate variable scope, and inserted intelligent error-logging in all class methods so that if the offshore team ran into runtime errors, they would be able to find and fix them more quickly. Wrote Access application to track planned changes. Agile/Scrum methodology.

Confidential

Software/Database Developer

Fixed and optimized DNA lab sample-tracking software, including complex stored procedures: VB6 SQL Server 2005, 2008. Repaired simple web application for DNA tracking using SQL Server 2005 2008 R2, SSIS, C 2008, and ASP.Net 2008. Wrote SSIS ETLs. Wrote a C utility to scan RFID tags and log them into a SQL Server database. Created or repaired several data utilities in Excel optimized or modified MS Access reporting applications. Worked with users to resolve and prevent serious data issues they were having. Fixed extensive programming errors in VB6 code. Used Agile/Scrum methodology

Confidential

Senior Software Engineer

Optimized and re-architected several nightly ETLs billions of securities holdings data incoming to Portia from subdivisions and hundreds of thousands in trades outgoing to Swift . Wrote or optimized Sybase stored procedures, designed new tables. Wrote or updated extensive documentation including Visio diagrams. Sybase ASE 15 and MS SQL Server 2005 2008, Autosys JIL scripts, UNIX Korn shell scripts and Crystal Reports CMC, InfoView , Visio, Remedy, Embarcadero.

Passed FBI 10 yr criminal background check, with fingerprinting as per SEC rules

Confidential

Systems Analyst

Wrote reporting and ETL applications using Oracle 8i, 9i, 10g, 11g , MS SQL Server 2005 2008, SSIS, VB6, Crystal Reports, MS Access, VB.Net, and C . Interfaced with 300GB Primavera P6 EVM earned value management Oracle databases. Helped another programmer with a warehouse inventory system VB.net, Oracle, Dundas Charts . Wrote and optimized complex stored procedures in PL/SQL and MS SQL Server. Optimized MS Access applications. Wrote VB6 service application to unlock Primavera users on Citrix. Wrote other applications using C , Ibatis.Net Data Mapper, ADO.Net, Entity Framework, DevExpress DxPerience and Dundas Charts. Reviewed code for C framework. Wrote a data quality audit utility in VB6, Oracle, SQL Server and Crystal Reports that performed 31 checks to find bad or mismatched data or structure in Primavera databases This was instrumental in the success of a 12 million dollar contract. Wrote VB coding guidelines to increase software maintainability, robustness and reliability. Implemented intelligent error reporting and logging to allow faster correction of reported problems. Worked with Perl scripts in UNIX to run stored procedures. Worked with COTS vendors to add missing indexes in databases. Minor database design modifications using Visio.

Environment: VB6, VB.Net, C , COM , ADO.Net, Crystal Reports, Visio, Toad, SQL Navigator, MS SQL Server 2005 and 2008, SSIS 2005, HotSos, Oracle 8i, 9i, 10g, 11g, Oracle Analytics, PL/SQL, InstallShield, MS Access, Excel, simple java, Primavera 3.5 P6

Confidential

VB6 Developer

Wrote and documented data interfaces for a mortgage LOS loan origination system using Data Junction 7.5, VB6 and VB.NET and MS SQL Server 2000. Helped design logical and physical database models using Visio. Wrote requirements specifications and test plans. Tested the workflow and data entry modules. Took the lead in organizing documents, sample data, source code and in setting up CM procedures. Managed the defect tracking system. Agile/Scrum methodology

Confidential

VB6 Developer

Rewrote major parts of a large, complex, client-server, object-oriented VB6 financial services application built using over 80 custom user controls. Optimized code, added Hungarian notation and advanced error handling. Mentored junior programmers. More than doubled performance in parts of the application and uncovered memory leaks. Wrote documentation for code optimization techniques.

Environment: MS SQL Server 2000, TSQL stored procedures, VB6, COM , OO, 3-tier, custom controls, ADO, OLEDB, Data Designer, Data Provider, Bugzilla defect tracker

Confidential

VB6, Excel, Reports Developer

Wrote VBA scripts to automatically generate financial reports in Excel. Wrote an OO VB program to parse data from report files and to insert data into Excel files using Excel's COM API. Environment: VB6, MS Excel, SQL Server 2000, MS Access, COM API for Excel and MS Access, VBA Script

Confidential

VB6 Programmer and Business Analyst

Problem Analysis and Requirements Analysis for EPA CDX UCMR web application and information system. Rewrote COM VB6 middle tier for web application. VB, Oracle 8i, PL/SQL stored procedures, SQL, ASP XML, MTS, OLEDB, MS Word and MS Project Manager. Also wrote coding standards and code review procedures for CMM level 3 certification.

Environment: VB, COM , Oracle 8i, PL/SQL Stored Procedures, SQL, ASP XML, OLEDB, MS Word, MS Project Management, MS Access

Confidential

VBA Developer

Designed and wrote a VB application to automatically create MS Word training documents from PowerPoint CBT presentation files, using the COM interfaces presented by Word and PowerPoint. This involved complex parsing and formatting rules and rules for which slides to link into the Word document

Environment: VB6, COM, MS Word, PowerPoint, OLE Automation, VBA

Confidential

Web Developer

Confidential

VB6 Developer

Wrote an online, hypertext-based document, Software Development Standards and Guidelines , used company-wide for Internet and Intranet Web Applications, including coding standards for ASP, COM , XML, VB6, VB.NET, SQL Server, SQL, MTS, OLEDB, ADO and other Microsoft Data Access technologies

Environment: ASP, COM , XML, VB6, VB.NET, SQL Server, SQL, MTS, OLEDB, ADO

Confidential

VB6 Developer

Part of team on a very large, object-oriented, multi-tier health care information system name: CHSII for the combined U.S. Armed Forces. Performed code reviews, corrected others' VB code, optimized VB code, inserted Hungarian notation and error handling

Environment: VB6, COM , DCOM , ADO, Oracle, Visual SourceSafe, Visual Tracker defect-Tracking System

Confidential

Lead Developer

Wrote a financial application system VB5, VB6, Access, Oracle used to generate purchase orders and to track invoices and payments on those P.O.s. This was for a system that was too complex for most commercial accounting packages to handle, since it had to track expenditures by business partners, networks, projects, subprojects and sites. Successfully deployed system which was used to track over 200 million by the time I left. Traveled to Plano, TX, to train users. Software had extensive error handling and an error logging system so that I could instantly see errors from my office in Georgetown, DC, as they occurred in Texas and I could see not only the user's ID, tel. and email address, but the exact code module, subroutine, PO , Invoice if applicable , line item if applicable and any SQL query involved. Designed the database, implemented first in Access and moved to Oracle

Environment: VB5, VB6, COM, MTS, MS Access, Oracle, SQL Server

Confidential

Lead Developer

Brought a 3-tiered automobile insurance project back on track. Introduced VB coding standards and my library of error trapping and logging code. Mentored the entire team of programmers in use of same and in advanced VB techniques. The VB coding standards were published on Geico's intranet

Environment: VB, COM, MTS

Confidential

Team Lead

Built a VB5 class library in a COM server application three-tier arch. for an application used to track government research grants and spending. Used MS SQL Server database. Wrote a data access wrapper class library, including added intelligent error trapping and messaging. Modified design of database to add tables, indexes. Managed and mentored junior programmers.

Environment: VB5, RDO, MS SQL Server database, Erwin, Visio

Confidential

Built two inbound 800 call centers using VB-based software developed by Versatility, Inc of Fairfax, VA. Built screens and navigation flow for a mortgage marketing system in Glen Allen, VA and for a customer service center in San Marcos, TX. Oracle and SQL Server databases

Environment: VB, Customer Service, Oracle, SQL Server databases

Various Other Consulting Projects - Confidential

GTE: Imaging and document management VB application

Developed USAID Congressional budget application VB4, Oracle .

Designed database using Erwin

Wrote the Software Development Standards and Guidelines manual, including

Coding standards, guidelines optimization tips for VB and SQL

Code Review Procedures and an Inspection List for Common Software Defects

Database Naming Conventions

State Dept secret clearance now inactive

Freddie Mac - Built financial/mortgage software applications and reports in VB. Trained Mentored junior VB programmers. Promoted VB coding standards and instituted use of version control system at team level. Tools: VB 4.0 Professional and Enterprise Editions , vsView, Source Safe, SQL Sombrero, Sybase and Oracle

GE Information Systems Wrote VB application to copy document imaging files and to create an index to a CD jukebox system

Fannie Mae - Built prototype in VB for possible new Windows based national mortgage software application. Designed and built SQL Server database and populated with test data

AT T FTS 2000 Customer Service Project Built data conversion and migration app. C language and Teradata Implemented source control using PVCS

Ogden/ERC Wrote feasibility study, requirements and built C program for EPA

Cable Wireless - Wrote 300 page ops manual for telecom switches. Redesigned software development process from two-week to three-day turnaround

Confidential

Built a prototype imaging application in Visual Basic version 2 in conjunction with an imaging API DLL , to read scanned images files of IRS 1040 paper forms from a UNIX server, to perform OCR and to store the information into a database. Allowed operators to view and manually correct text fields which the OCR software flagged as unsure

Confidential

Wrote information system applications in C, C , and Oracle. DOD secret clearance now inactive

Confidential