JOHN J. PIRAINO, SR.

1170 Parwen Drive

Dallas, TX 75230

Contact

 

PROFESSIONAL CERTIFICATIONS

MCT

Microsoft Certified Trainer

MCITP

Microsoft SQL Server 2008 and Windows 2008 Enterprise

MCSD

Microsoft Certified Solution Developer

MCSE

Microsoft Certified Systems Engineer

MCSA

Microsoft Certified Systems Administrator

MCDBA

Microsoft Certified Database Administrator

 

EXPERIENCE

Data Analyst-SSIS/ETL Specialist

July 2009 - Present

M&I Data Systems

West Allis WI

Consultant:

         Assisted in design of Transactional Data Mart (Star Schema) for data migration on SQL Server 2008

         Preparation of data on Oracle Netezza and SQL Server 2000 and 2008 for migration to SQL Server 2008

         Migration of data from Oracle and Netezza to SQL Server 2008 using SQL Server Integration Service (SSIS / ETL)

         Creating, Deploying and Scheduling SSIS packages for execution.

         Performance monitoring and tuning of SSIS packages and queries.

 

Technical Trainer

January 2009 - Present

Self Employed

Dallas TX

Training and delivery of Microsoft and 3rd party Curriculum at Microsoft training centers and onsite corporate training. Specializing in SQL Server 2005, 2008, BizTalk Server, SharePoint Administration, .NET development and Active Directory.

 

Sr. Database Administrator -
Business Intelligence Analyst

December 2007 January 2009

The Hub Group

Downers Grove IL

 

         Lead designer and developer for SQL Server 2000-2005 conversion.

  • Managed multi-terabyte data storage system
  • Experience gathering requirements, and designing to product specifications
  • Responsible for data base query and index performance monitoring and tuning using SQL Trace, Apex Database tools and Quest Database management suite
  • Isolated problem queries by creating and monitoring server side SQL Trace
  • Managed backup and recovery for multi-terabyte systems using Idera SQL Safe
  • Managed SQL Databases with Apex SQL suite of utilities
  • Provided data masking for development using Net 2000 Data Masker
  • Applied service packs and hot fixes for SQL Server 2000 and SQL Server 2005
  • Provided capacity planning and analysis
  • Designed and implemented security model for SQL Server 2005
  • Migrated SQL Server 2000 to Microsoft SQL Server 2005
  • Migrated SQL Server DTS / DTSX from SQL Server 2000 to SQL Server 2005
  • Created custom .NET scripts for administration and performance of DTSX packages.

The Hub Group (Continued)

  • Designed documented and created ETL / SSIS applications gather data from OLTP databases on SQL Server, DB2 on AS400 and Oracle into OLAP cubes
  • Implemented database resizing and table partitioning on SQL Server 2005
  • Implemented database purge operation for rapidly growing transactional databases
  • Setup and managed Transactional and Merge Replication
  • Database monitoring and setting up automated disaster recovery
  • Configured scripts for remote deployment and migration
  • Set up self monitoring and self healing; calls were sent out to / via Blackberry devices.
  • Designed migration to SQL 2008

 

Technical Trainer

February 2002 November 2007

Self Employed

Milwaukee WI

 

Training and delivery of Microsoft and 3rd party Curriculum at Microsoft training centers and onsite corporate training. Specializing in SQL Server 200) & 2005, BizTalk Server, .NET development, Exchange Server, SharePoint Server Administration, Networking and Active Directory.

 

Sr. Technical Trainer

June 2000 February 2002

Information Management Group

Chicago IL

 

Training and delivery of Microsoft and 3rd party Curriculum

Courses taught:

         Microsoft Exchange 5.5 and 2000

         Microsoft Content Management Server

         Microsoft SQL Server 7.0 and 2000

         Microsoft .NET (Visual Basic .NET & C#)

         Microsoft Visual Basic 6.0

         Microsoft Windows 2000, Networking and Active Directory

         Microsoft BizTalk Server

         Microsoft Windows XP

 

Chief Information Manager -
Director of MIS

October 1996 June 2000

Eye Communication Systems

Hartland WI

 

         Report directly to CEO and CFO.

         Planned, installed and managed corporate network.

         Developed and created software engineering team of 14

         Actively participated in design of Parts Online software

         Designed and managed the development of Parts Online for small engine and home appliance industry.

         Supervised the design of document management software.

         Planned, installed and managed internet connectivity and security for company

         Designed and Implemented terabyte Microsoft SQL Server 7.0 database for online parts lookup application.

         Designed, Developed and Implemented Analysis database for Q&A of small engine and appliance manufacturers.

         Managed backup and recovery of SQL Server and Exchange Server.

         Implemented Merge replication to support parts and diagram updates.

         Designed and implemented Internet Service Provider organizational unit for custom web design clients.

         Supervised development of Internet e-commerce software.

 

Project R & D / Q & A Manager

1993 1996

Data Retrieval Corporation

Milwaukee WI

 

         Developed Q&A Testing team for document management software

         Development using C/C++ for Windows

         Worked with software engineers to create Q&A standards for software creation and revisions

         Debugged Client / Server communication layer of existing software

         Prototyped and developed web server and application for internet document access

         Designed Microsoft SQL Server database for document and metadata storage.

 

TEACHING / TRAINING

Part Time Adjunct Faculty Member

1996 2000

Waukesha County Technical College,

Waukesha WI

 

         Developed and taught Windows Programming course using MFC (Microsoft Foundation Classes)

         Taught Visual Basic Development

         Taught Visual Basic Database Development

         Developed and taught Advanced MFC class.

         Developed and taught Advanced Web Design II class which taught Active Server Pages (ASP) JavaScript and DHTML

         Designed Advanced Windows Programming Certificate Program

 

Part Time Instructor Continuing Education

1996 1997

Marquette University

Milwaukee WI

 

         Designed and taught Windows NT Workstation and Server class

         Designed and taught TCP/IP class

         Assisted in design of Web Master Certificate Program

         Designed and taught Microsoft Internet Information Server (ISS) class

         Designed and taught Microsoft Exchange class

         Taught Introduction and Advanced HTML class

         Taught Web Design using Microsoft Front Page

         Taught Intro to Java programming

 

PUBLICATIONS

  • Technical Editor Mastering Microsoft Internet Information Server 4 Second Edition. Peter Dyson Sybex Books. ISBN 078212080
  • Technical Editor Mastering Windows NT Server 4 Fifth Edition. Mark Minasi Sybex Books. ISBN 0782121632
  • Technical Editor - Windows NT Server 4 Security Handbook. Hadfield, Hatter, and Bixler Que Books. ISBN 078971213X
  • Technical Editor - Mastering Intranets The Windows 95/NT Edition. Coleman and Dyson Sybex Books. ISBN 0782119913
  • Technical Editor - Visual Basic 5 No Experience Required. Steve Brown Sybex Books ISBN 0782120741

 

 

 

 

Skills

 

SQL Server
2000, 2005, 2008

SSIS

SSAS

SSRS

ProClarity

Visio

Erwin
BizTalk Server

Microsoft
Exchange

Blackberry
Enterprise Server

Windows Server
2003, 2008

Active Directory

Windows XP, Vista
Windows 7

SharePoint Server MS Office Suite

 

 

 

 

 

 

XML/XSLT

HTML/XHTML

Power Shell

VB Script

C#

Visual Basic .NET

ASP.NET