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