SUMMARY

• Database application development — Complete System Development Life Cycle (SDLC) including business requirements gathering, analysis, database and application design and development.
• Project management — Full System Development Life Cycle (SDLC), Agile development. Management and coordination of multi - discipline team including business, technical and support staff.
• Database Application Management — Business and user management, support, training, troubleshooting, debugging, maintenance and enhancement of existing database applications.
• Decentralized General Ledger processing at Citibank, N.A., saving teh company over $40 million.
• Developed teh main operational database application that allowed Mobile Diagnostic Services double revenue while reducing staff size and expenses in teh healthcare services industry. Teh application’s object-oriented design allowed for greater scalability and reduced maintenance costs. dis application was developed to automate 24/7 manual operations in a time- and data-critical environment and has been functioning daily since 1992
• Converted a major alternative investment (hedge) fund application from a Visual FoxPro backend database to Oracle resulting in greater scalability, reliability and performance.
• Subsequent to a three year failed attempt by a third-party consulting firm analyzed, designed and developed a mission-critical index review application used by a major index provider to manage teh composition of over 300,000 equity indices. As part of teh one-and-a-half year project managed a team of developers and was responsible for all coordination wif our business counterparts.
• Assumed responsibility for and stabilized existing out-of-control mission-critical applications at Westdeutsche Landesbank Girozentrale (WestLB) and Princeton Insurance Companies, allowing teh firms to reduce development expenses and meet new and changing business and regulatory demands.
• Ran and participated in several key projects in banking (personal, institutional and investment), alternative investments (hedge funds), insurance, publishing, medical and other industries.

PROFESSIONAL EXPERIENCE

Application Architecture and Development

Responsibilities:

• Successfully completed teh analysis (including business requirements gathering and user workflow documentation), conceptual design and program development for new custom-designed database applications for a variety of organizations. Systems developed include index composition management, market data (symbology), order entry, shipping, billing and control application, patient service request and medical technician dispatching, a placement agency candidates/position matching, database integrity checking and repair, and several system and end-user maintenance applications. Most of these applications resulted in improved business operations and reduced costs.
• Demonstrated ability to understand and assume responsibility for existing production applications, leading to improved application stability and enhancement. These applications often were in precarious condition wifout proper source code control, change control, technical documentation, etc. Immediately introduced various tools and procedures such as Visual SourceSafe, formal testing and production change control procedures, peer code review and walk-throughs, and development standards to improve application maintainability and reduce maintenance costs.
• Database schema design and implementation for mission-critical databases running under Visual FoxPro, Microsoft SQL Server (2000, 2005, 2008), Oracle and Sybase SQL Server.
• Extensive application migration experience including General Ledger decentralization and conversion of legacy FoxPro databases and applications to Visual FoxPro (OOP), PowerBuilder/Sybase SQL Server, Microsoft SQL Server and Oracle environments. Experience includes departmental as well as scale databases wif individual tables supporting over sixty million rows and over 26 Gigs of data space. Total server row counts into teh billions and data space in tens of terabytes.
• Extensive experience developing, maintaining and managing production batch operations in both mainframe and desktop/network environments, including teh implementation and use of Seagate’s Ashwin Job Scheduling software as well as custom-developed job scheduling sub-systems.
• Design and development of application programs, reusable classes, objects and tools to reduce development cost and improve application stability. Significant Visual Studio .NET and Visual FoxPro OOP experience, including teh use of teh StrataFrame and Visual FoxExpress OOP, n-tier application frameworks. Successful use of Structured Analysis and UML modeling tools and techniques, including data flow, class and sequence diagrams.
• Webmaster responsibilities including full site redesign and database management.
• Extensive application documentation (technical and end-user), user training, application deployment and production support experience, including off-hours and 24/7 support.
• Extensive management and user contact in all phases of application development and maintenance.

TECHNICAL SKILLS

Application Development Frameworks: StrataFrame (.Net OO/n-tier/layered architecture), Visual FoxExpress (OO/n-tier)

Database: Microsoft SQL Server, Oracle, Sybase SQL Server, Microsoft SQL Server Integration Services (SSIS)

Database Tools: Toad for SQL Server, Toad for Oracle, dbArtisan, Sybase PowerDesigner (UML), FoxFix, dSalvage, Data Junction, Sybase BCP (Bulk Copy), Stonefield Database Toolkit, Monarch (data mining)

Development Tools: Visual SourceSafe, SVN, CapCon, PVCS, Multi-Edit, Office Automation, Query Maker (Ad-hoc Reporting Tool), Crystal Reports, MS Project, MS Visio, UML, FrontPage, Xara Web Designer MX, MS Project, SharePoint, COM/ActiveX, Microsoft Virtual PC, Oracle VirtualBox

OSs: Microsoft Windows (all versions for workstations and servers), DOS, Macintosh OS—through 8.x

Office Suites: Microsoft Office, Corel Perfect Office, LibreOffice MS Publisher, Baler XE

Business Packages: Quicken, QuickBooks Pro, Pacioli Accounting, Hyperion, Seagate Ashwin (job scheduling), McCormack & Dodge

Languages and development environments:

Microsoft Visual Studio .NET - C#

Visual FoxPro - all versions through 9.0

MicroFour StrataFrame database application development framework for .NET

F1 Technologies’ Visual FoxExpress OOP database application development framework

FoxPro (2.x) and FoxBASE - DOS, Windows and Apple Macintosh; Visual dBase; dBase III

PowerBuilder 4.0 - 7.0

West Wind Web Connection