SUMMARY:

• 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

TECHNICAL SKILLS:

• I - Intermediate A-Advanced E-Expert (T)-Have taught

• A (T) Windows Desktop (2000 thru 10)
• A (T) Windows Server (NT4 thru 20012R2)
• I Axure
• 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
• I AIX
• A Pick (JBase, Universe)
• A (T) Routing & Networking

• E (T) Microsoft SQL Server (2000 thru 2016)
• E (T) Netezza
• E AMP
• I Oracle
• I DB2
• A Multivalued
• I Cognos
• I IBM Unica Campaign

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

• 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

• 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
• A COBOL
• A Pick Basic

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

PROFESSIONAL EXPERIENCE:

Sr. Database Developer

Confidential, Cincinnati, OH

Responsibilities:

• Design, development, testing and implementation of customer engagement system using Netezza and AMP Analytics on system involving 360 million loyalty cards and 23 billion items on 3.5 billion transactions/year.
• Successfully processed a diverse collection of inputs including transactional, website clicks, real - time transactional, campaign response, and others.
• Tools supported included IBM Unica Campaign and Cognos.

Sr. Business Intelligence Consultant

Confidential, Cincinnati, OH

Responsibilities:

• Technical and management consulting on various BI and Microsoft technology related clients.
• Set up Always On and Database mirroring high availability installations, created reporting packages (SSRS), and maintained and tuned Microsoft SQLServer installations (SSAS, SSIS, & SSRS).
• Installed and worked with Power BI.
• Helped to install and exploit Team Foundation Server. Provided proof of concepts on SQLServer on Azure.

Sr. Developer

Confidential, Fairfield, OH

Responsibilities:

• 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
• Built SSIS based ETL from AS400 to new SQLServer data warehouse
• Made requested changes and additions to Cognos reports

Development Manager / Team Lead

Confidential, Langhorne, Pa

Responsibilities:

• When I became involved the projects was in crisis with late deliveries, nearly every output to client being rejected for errors, and development 3 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
• Confidential 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
• Taught C# class to give developers needed skills for windows services and web services upcoming projects
• 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, Englewood, Ohio

Responsibilities:

• 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
• 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
• Introduced agile methods to development team

Chief Software Architect

Confidential, Blue Ash, Ohio

Responsibilities:

• 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
• Website infrastructure design
• VB.Net and ASP.Net coding
• SQL Server database design and implementation to implement row level security with Active Directory administration, Coded SQL stored procedure coding
• Lead infrastructure installation and upgrade.
• 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.
• Gap Analysis
• Project Management, team of 4
• GL restructure
• Data conversion
• End user training
• AS/400 implementation
• 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.
• 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, Blue Ash, Ohio

Responsibilities:

• Confidential 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 Confidential “factory”.

Project manager

Confidential, Cincinnati, Ohio

Responsibilities:

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

Vice President, Consultant

Confidential, Bellevue, Washington

Responsibilities:

• Lead projects for eastern Confidential, 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.