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 high quality results on time and/or within budget and understands corporate profitability as well as individual responsibility.

He has lived and taught both the Software Development Life Cycle (SDLC) and the Agile lifestyle and is effective in managing and developing employees.

He is experienced in the entire lifecycle of consulting engagements from cold calling and sales, through implementation and ongoing support. Major Accomplishments

Provided primary analysis and technical for data of merged Fortune 500 size retailer’s loyalty program acquisition merger.

Weened a Fortune 100 retailer’s Loyalty program from continuous vendor support and realized marketing’s goals.

Saved a major (Fortune 500) client from cancellation.

Took a tired software company (30 years old) from $300k/yr profit to over $1 million.

Served on Ansi X3 Standards Committee.

Led national Special Interest Group for a major manufacturer.

Created and operated a subscription database for thoroughbred racehorse genealogy and racing results which quickly became an industry essential for breeders and trainers.

Certifications

Security Clearance – Public Trust

CompTIA – Security+

Microsoft MCSA – SQL Server 2012/2014

Microsoft MCTS – SQL Server 2005, C#

Project Management Institute - PMP

AWS certified practitioner

Scrum.org – Professional Scrum Master I

SAFE – Certified Agile Practitioner

Microsoft MCDBA – SQL Server 7-2k

Microsoft MCSE – Windows NT4, 2000, 2003, 2008… 10

Microsoft MCTS Dynamics GP 10 – Financials & Installation

Microsoft Dynamics GP 2010 – Sales & Presales

CompTIA – A+

Road Warrior - Delta Million Miler

Professional Experience

Database Adminstrator, Sr 10/2022- 2/2024

Tiber Creek Consulting 571-***-****

Contracted through Leidos Inc 720-***-****

MODS (Medical Operations Sata System) project for the US Army Health Services. Design, development, testing and implementation of conversion from IBM Mainframe/Cobol/DB2 to Microsoft/SQL Server.

All functions of MODS system, especially medical readiness, were to be ported to new hardware software system. All functions including imports and exports to be recreated in SQL Server. Involved reading Cobol routines and creating SQLServer stored procedures and SSIS packages. Promoted to Team Lead to organize and lead team,

Sr. .Database Lead Developer 2/2022–-7/2022

Bealls Inc. 1806 38th Ave East, Bradenton, Florida 34208 941-***-****

Contracted through Insight Global, 4211 W Boy Scout Blvd, Tampa, Fl 33607 813-***-****

Design, development, testing and implementation of SQL Server databases and applications. SSRS Reports. SSIS ETL

Created and maintained ETL SSIS for Merchandising and Logistics

Managed two offshore (India) developers

Created a 2 day Agile methodology training session.

Sr. Database Developer 6/2018–-2/2022

Speedway division of Marathon Oil / 7-11, 500 Speedway Dr. Enon, Ohio 45323 937-***-****

Design, development, testing and implementation of SQL Server and Teradata databases and applications. SSRS Reports. SSIS Created and maintained multiple reporting packages and Business Analysis for Marketing, HR, IT, Accounting, and Loss prevention departments using SQLServer, Teradata, SSRS and Tableau.

Created and maintained multiple ETL steams for Loyalty platform

Managed and performed upgrade of multiple SQLServer platforms from SQLS008R2/Windows 2998 to SQL2016/ Windows 2016

Assisted and mentored Agile process

Mentored and provided resources/training to other developers, marketing personnel, and interns

Carried projects through start to finish including Business Analysis, design, implementation, installation and training. As required

Sr. Database Developer 8/2017 – 4/2018

AK Steel 227 Centre Pointe Dr, West Chester Township, OH 45069 717-***-****

Cohesion Consulting 5151 Pfeiffer Rd #105, Blue Ash, OH 45242 513-***-****

Design, development, testing and implementation of Data Warehouse combining data from diverse (AS400, Oracle, SQLServer) systems remaining from multiple mergers. SQLServer and SQLServer reporting services. Investigated and prototyped systems to send text messages and voicemail from SQLServer system. Agile Development Environment.

Sr. Database Developer 10/2016 – 8/2017

Kroger Technology 9935 Carver Rd, Cincinnati, OH 45242 513-***-****

Through Principal Solutions Grp 4000 Smith Rd, #130, Cincinnati, OH 45209 513-***-****

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. Agile Development Environment.

Successfully processed a diverse collection of inputs including transactional, website clicks, real-time transactional, campaign response, etc...

Tools supported included IBM Unica Campaign and Cognos Provided primary assistance to Dev Ops group.

Helped quality team design better tests.

All projects used agile and scrum methodology.

Sr. Business Intelligence Consultant 10/2015 – 09/2016

KiZAN Technology 130 Crowne Point Place, Cincinnati, OH 45241 513-***-****

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 Microsoft Azure.

Sr. C# Developer 3/2015 – 8/2015

Cincinnati Financial Corporation 6200 S. Gilmore Road Fairfield, OH 45014 513-***-****

Contracted through Brooksource 455 Delta Ave #400, Cincinnati, OH 45226 513-***-****

Maintenance of insurance industry policy application, Target Markets policy project, C# and SQL Server programming, QA and testing.

Parsed and produced XML

Database Developer 1/2014 – 12/2014

Rumpke Consolidated, 11865 Old Colerain, Cincinnati Ohio 45252 513-***-****

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.

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 2012 – 2013

Harte-Hanks Inc., 2100 Cabot Blvd, Langhorne, Pa 19047 215-***-****

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)

Responsible for all development and operations.

When I became involved, the projects were in crisis with late deliveries, nearly every output to client being rejected for errors, and development 3 months behind schedule.

Installed management reporting devices to keep everyone appraised of status, plans, and progress. Issued weekly progress reports to client.

interacted with client to understand and communicate priorities and needs.

Little internal expertise existed on Netezza technology, collected information, personally solved most urgent issues, taught subordinates best practices

Focused team on critical path

Restored client confidence

Architected changes, did some coding, and conducted code reviews

Parsed and produced XMLTaught C# class to give developers needed skills for windows services and web services upcoming projects

Taught class on Netezza management for DBA group

Taught SQLServer 2012 Class leading to Ms Certification

Other similar clients included Amtrak, Boscov’s department stores, L’Oreal, and Elanco drugs.

PetSmart (3.5 TB SQLServer database with SSAS cube using SSIS packages for update)

Responsible for all development and operations.

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

SONY Consumer electronics (Netezza database with SQLServer SSIS package update)

Took over management of work in process

Website Development

Managed several Change request projects

Architected changes, did some coding, and conducted code reviews

Managing Director 2004 - 2011

Creative Microsystems, Inc., 52 Hillside Court, Englewood, Ohio 45322 937-***-****

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 modern 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

Web Development

Desktop development

Mandated biweekly progress reports to clients

Rolled out remote facilities management service for small municipalities antivirus and update management.

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

Adopted Microsoft Dynamics CRM for use in our help desk (1000-3000 calls per month). Modified and reported upon CRM to facilitate process.

Introduced agile and scrum methods to development team

Made user group and marketing presentations

Taught class on project management

Chief Software Architect 1998 - 2004)

Belcan ITD, 10200 Anderson Way, Blue Ash, Ohio 45242 513-***-****

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

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.

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

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 online 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

Vice President, Consultant 1987-1997

Timeline Inc., Bellevue, Washington (remotely based in Cincinnati, Ohio)

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 1985-1987

KMG Main Hurdman/ KPMG Peat Marwick, Cincinnati, Ohio

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.

Education

MBA (Management), Xavier University, Cincinnati, Ohio (GPA 3.6)

Engineering Computer Science (37hrs postgraduate - no degree) University of Louisville, Louisville, Ky

BA (Psychology), University of Illinois at Chicago Circle, Chicago, Ill & Baylor University, Waco Tx

The Bulletproof Manager®, Crestcom, Cincinnati & Dayton, Ohio

Technical Skills Intermediate A-Advanced E-Expert (T)-Have taught

Platforms:

I Azure

I AS/400

A (T) Windows Desktop (2000 thru 10)

A (T) Windows Server (NT4 thru 20012R2)

A Microsoft IIS

A Microsoft Exchange

A VMware

I Microsoft SharePoint

A Active Directory

I Windows Mobile

A Pick (JBase, Universe)

A (T) Routing & Networking

A UNIX

A Linux

I AIX

A IBM MVS

Database Management Systems:

E (T) Microsoft SQL Server (6 thru 2019)

E (T) Netezza

A Teradata

E AMP

I Oracle

I DB2

E Big Data

A Multivalued (Pick)

E (T) Database Administration

Software:

E Microsoft Project

E (T) Microsoft Office

E Microsoft Visio

A (T) Microsoft Dynamics GP

I Microsoft Dynamics CRM

I Cognos

I IBM Unica Campaign

I MicroStrategy

I Tableau

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

E (T) MS Office, Word, Excel

A MS Project

I AI

I Machine Learning

Programming Languages:

A C# (Desktop & ASP.Net)

E (T) VB.Net (Desktop & ASP.Net)

A Traditional VBScript ASP

A Dexterity

A COBOL

I Python

Application Areas:

E (T) Accounting & General Ledger

E Payroll

E A/R, A/P, PO, Inventory

A Banking

A Classroom and Online Training

A Fund Raising

E Human Resources A Healthcare – Insurance

I Healthcare – Medical Records

A Sales & Marketing

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

Contact this candidate