Summary

Hands on IT Project Manager / Software Architect

• This broadly experienced IT professional can bring to your organization a wide variety of skills and experiences, which will translate to bottom line, cost effective productivity for himself and those around him. He is especially effective in changing situations where both short term and long term goals must be balanced.
• He can deliver on time and within budget and understands corporate profitability as well as local responsibility. He is experienced in the entire lifecycle of consulting engagements from cold calling and sales through implementation and ongoing support. He is also has lived and taught the entire Software Development Life Cycle SDLC , and is effective in managing and developing employees

PROFESSIONAL EXPERIENCE

Sr Developer

Confidential

Insurance industry, Ciber crime protection policy project

Database Developer

Confidential

• SQLServer programming and support of Cognos reports. ETL primarily from an AS400 system.
• System averaging two or three aborts of various TL jobs every night. Many jobs running four to ten hours each day.
• Repaired and reprogrammed stored procedures so that aborts became a rare 1 a month occurrence.
• Reprogrammed long running jobs many going from several hours to several minutes
• Participated in new data warehouse design and implementation
• Build SSIS based ETL from AS400 to new SQLServer data warehouse
• Made requested changes and additions to Cognos reports

Development Manager / Team Lead

Confidential

• Managed and lead a team of 7 database and C developers supporting large marketing databases for national clients. Provided both project management and hands on coding to solve most difficult problems and to mentor more junior developers.
• Bed, Bath, and Beyond 4.5 TB Netezza database with SQLServer SSIS package update
• When I became involved the projects was in crisis with late deliveries, nearly every output to client being rejected for errors, most deliveries late, and development three months behind schedule.
• Little internal expertise existed on Netezza technology, collected information, personally solved most urgent issues, taught subordinates best practices
• Installed management reporting devices to keep everyone appraised of status, plans, and progress.
• Interacted with client to understand and communicate priorities and needs.
• Focused team on critical path
• Restored client confidence
• Architected changes, did some coding, and conducted code reviews
• Participated in RFP process for contract renewal
• PetSmart 3.5 TB SQLServer database with SSAS cube using SSIS packages for update
• Initially took a technical role to resolve issues, then handed maintenance off to a subordinate
• When I became involved the cube had failed to build successfully every week for 3 months.
• Resolved issue first week
• Installed changes to both ensure reliable and resilient cube build and improved performance of 2 day duration weekly update.
• Restored client confidence.
• Toyota SQLServer SSIS packages and web services, Development project in process
• Took over management of work in process
• Managed several Change request projects
• Architected changes, did some coding, and conducted code reviews
• Taught class on Netezza management for DBA group
• Taught C class to give developers needed skills for windows services and web services upcoming projects
• SONY Consumer electronics Netezza database with SQLServer SSIS package update
• Took over management of work in process
• Managed several Change request projects
• Architected changes, did some coding, and conducted code reviews
• Other similar clients included Amtrak, Boscov's department stores, L'Oreal, and Elanco drugs.
• Taught SQLServer 2012 Class leading to Microsoft Certification

Program Director

Confidential

• Full responsibility for budget, management, and delivery of 7M portfolio of public sector software products
• Initiated, supervised, and in some cases lead rewrites of all software from legacy PICK software to Microsoft .Net and SQLServer .
• New functionality was added with focus groups of existing clients and analysis of lost bids.
• Existing personnel had to be retrained for new technologies.
• Conversion and cutover for existing clients needed smooth transition.
• Managed or oversaw projects
• Database design, SQL implementation, SQL stored procedure coding
• Designed or reviewed software designs
• Coded in VB.Net and ASP.Net, user controls
• Rolled out remote facilities management service for small municipalities.
• Designed technical service, marketing plan, and roll out plan
• Used this as an opportunity to mentor two staff members to build future capability in this area
• Lead certification effort leading to 35 certified individuals, and Microsoft Gold Certified Partner status with six competencies.
• Taught classes covering Networking, Windows Server, Desktop support, SQLServer, Project Management, personnel management, and Dynamics GP
• Adopted Microsoft Dynamics GP as replacement financial product. Numerous modifications were required for Ohio public sector use. Also client expectation of compatibility with legacy products needed to be managed
• Project Manager
• Learned and used Dexterity to modify GP
• Designed reports with FRX and management reporter
• Converted data to SQL server
• Coded in Dexterity, VB.Net, and Access

Chief Software Architect

Confidential

• Responsible for full life cycle of several ASP.Net projects, taking developers with no .Net experience training and supervising them and managing the project as well handling the most difficult technical task myself. Buck stops here for technical issues and primary architect of all client solutions. Projects included:
• Multi-use single instance website customized via parameters and database entries for use by over 35 different county property valuation administrators.
• Sales support, analysis,
• Project Management, team of 3
• Database design, SQL implementation, SQL stored procedure coding
• Website technical design
• VB.Net and ASP.Net coding.
• Kidney transplant database for regional medical center using Microsoft Access -
• Sales support
• Analysis
• Project Management team of 2
• Database design, Access implementation
• VBA coding.
• Internet report delivery system for Federal Home Loan bank with over 1400 correspondents and 5000 users.
• Sales support
• Analysis
• Project Manager, team of 8
• Lead analysis design
• SQL Server database design and implementation to implement row level security with Active Directory administration, Coded SQL stored procedure coding
• Website infrastructure design
• VB.Net and ASP.Net coding
• Lead infrastructure installation and upgrade.
• Internet portal to replace a product from Computer Associates and providing additional functionality in support of medical billing and office management application. Five separately sourced COTS products had to be synthesized into a single look and feel. Requirements included single sign-on support for applications running on both Windows traditional ASP and Unix Apache . Several Microsoft SQLServer and Oracle databases need to be synchronized so that updates in one were reflected in the others
• Project Manager, team of 6
• Lead GAP analysis design
• SQL Server database and triggers design. SQL Server implementation, SQL stored procedure coding.
• Oracle database triggers design.
• Website infrastructure design.
• VB.Net and ASP.Net coding.
• Converted accounting system from Dec Vax Ross system to AS/400 based JDEdwards system.
• Gap Analysis
• Project Management, team of 4
• GL restructure
• Data conversion
• End user training
• AS/400 implementation
• Major upgrade of a property tax assessment system from Microsoft Access to VB/Net/ASP.Net/ SQLServer including a handheld application to facilitate field input.
• Sales support
• Analysis
• Project Management, team of 14
• Database design, SQL implementation, SQL stored procedure coding, conversion from legacy database
• Website design, built custom controls, designed website infrastructure
• VB.Net, ASP.Net and user controls coding.
• Replacement of an existing Unix/Apache MySQL on line training application and certification site with VB.Net/ASP.Net/SQLServer.
• Sales support
• Analysis
• Project Management, team of 5
• Database design
• Website design
• ASP.Net coding
• Infrastructure design and installation, conversion from legacy database

Consultant/ Project manager

Confidential

• Y2K compliance for COBOL programs.
• Lead conversion projects involving both internal and client personnel.
• Revised and created documentation
• Organized the help desk
• Created class presentation and material
• Organized and supervised off shore Y2K factory .

Project manager

Confidential

• Y2K compliance for COBOL programs.
• Lead projects
• Created and enforced standards

Vice President, Consultant

Confidential

Lead projects for eastern US clients of Seattle, Washington based international supplier of accounting and management software. Involved in many strategic initiatives and projects. Financial systems were tailored and installed for nonprofits, distribution, oil and gas, regulated utilities, government, newspaper, and retail clients.

Manager

Confidential

Built a turnkey computer software practice with a national scope for this Big Six CPA firm. Primary emphasis was on healthcare billing and manufacturing financial systems. Staff was spread across six offices from Pennsylvania to California.

TECHNICAL SKILLS

I-Intermediate A-Advanced E-Expert T -Have taught

Platforms:

• A T Windows Desktop 2000 thru 7
• A T Windows Server NT4 thru 20012
• A Microsoft IIS
• A Microsoft Exchange
• A VMware
• I Microsoft SharePoint
• A Active Directory
• I Windows Mobile
• I AS/400
• A IBM MVS
• A UNIX
• A Linux
• A CICS
• I AIX
• A Pick JBase, Universe
• A T Routing Networking
• I VOIP

Database Management Systems:

• E T Microsoft SQL Server 2000 thru 2012
• I Oracle
• I DB2
• A VSAM
• A Multivalued

Software:

• E Microsoft Project
• E T Microsoft Office
• E Microsoft Visio
• A T Microsoft Dynamics GP
• I Microsoft Dynamics CRM

Tools:

• E SQL Server Integration Services SSIS
• E T SQL Server Reporting Services SSRS
• A Microsoft Visual Studio 6.0 thru 2010
• E T SQL Server Management Studio
• A Microsoft Source Safe
• A Microsoft VS Team Foundations

Programming Languages:

• A C Desktop ASP.Net
• E T VB.Net Desktop ASP.Net
• A VB-6
• A Traditional VBScript ASP
• E VBA
• A Dexterity
• E T SQL Stored Procedures
• I Perl
• A COBOL
• A Pick Basic

Application Areas:

• E T Accounting Finance
• A Sales Marketing
• E Human Resources
• A Classroom and Online Training
• E Public Sector
• E Property Valuation Taxation
• A Regulated Public Utilities
• A Banking
• A Medical Billing
• A Medical Records
• I Manufacturing
• A Non-Profit
• A Membership

A Fund Raising