Tyler Weggel
76 4th Street North #867
Saint Petersburg, FL 33731
tylertyler@gmail.com
Skills Summary
25 Years of Professional Experience in IBM iSeries DB2 UDB Performance, overall iSeries Administration.
Heavy experience in Admin of IBM System I, including TCP/IP, User Authority, Single Sign On, and overall risk assessment.
Project Management, supervision, and responsibility for transitioning legacy systems to achieve peak efficiency and performance, requiring documentation, training, communication, and organization skills.
US Citizen
Work Experience
Cigna, Administrator of iSeries
Remote
August 2016 to Current
* Installed IBM fixes (PTF’s), worked with team to configure networking (ports) settings for optimal security.(SSL)
* Guided application group on changing default OS/400 values to be more secure (level 40)
Senior Data Analyst / Database Administrator (iSeries /400) DB2
Remote
University of Pittsburgh Medical College (UPMC)
Pittsburgh, PA
2013 January – August 2016
* Lead Database Administrator on iSeries DB2 for several projects.
* Team player implementing Informatica Change Data Capture (CDC) from DB2 to SQL Server.
* Team player implementing GoldenGate to move data from DB2 to Oracle.
* In both of the above conversion(s) IBM Query Options needed to be tuned by application.
* Configured iSeries to use Kerberos, LDAP, and single sign on with in the enterprise
* Assisted in operations and performance improvements on iSeries DB2.
* DB's: MS SQL Server; Access, Oracle, DB2 UDB iSeries.
eBay Enterprise (Formerly GSI Commerce)
DB2 UDB/400 Remote
Senior Database Administrator / Data Analyst
New York, NY
2009 July – January 2013
∗ Database architecture was changed to enable rapid business growth, maximum number of records was perilously close (4 GB) (DB max).
∗ Created indexes to support automated tool's SQL.
∗ Managed reporting projects and led the discovery of “hidden” trends in data sets, resulting in hundreds of thousands of dollars of savings in order fulfillment/delivery over a 5-year period.
∗ Designed (logical), developed, and implemented (physical) data architectures to support reporting needs of various departments using Erwin for modeling.
∗ Analyzed SQL for needed index creations, rewrites or structure redesign suggested RPG changes.
∗ Completed large structure changes of production tables within small time windows. (gigabytes in an hour)
∗ Designed and transformed existing legacy reporting platform to new web based version.
∗ Updated data model to reflect newer tools capabilities (star, hierarchical, flat, network)
∗ Used DBmon, iDoctor and PEX to hunt out most stubborn performance issues.(and solve)
∗ Analyzed and suggested changes (SQL rewrites, re-structured tables/models) to queries to use SQE instead of CQE, company wide, resulting in streamlined, simplified reporting to enable senior management to quickly identify contributions to top-line revenue.
* Configured TCP/IP, LDAP, Kerberos, servers to use Active Directory Service in the
Enterprise Identity schema.
∗ Enabled Iseries with in the single sign on proof of concept project.
∗ DB's: Oracle, AIX DB2, MySQL, iSeries DB2. (became largest iSeries during December with 64 cores)
Major League Baseball (MLB) Office of the Commissioner
Senior iSeries DB2 Database Administrator / Data Analyst
Park Ave, New York, NY
2009 February – 2009 July
∗ Oversaw the data indexing strategy in a data warehouse for consolidating statistics across legacy systems to overhaul and modernize reporting company wide, and bolster the expansion and popularity of the audience fan base.
∗ Captured system-wide performance data, made improved performance speed by up to 40X, and integrated over 200 new attributes to quantifying the revenue impact of advertising each game and each play.
∗ Designed (logical), developed, and implemented (physical) data architectures to support reporting needs of various departments using Erwin.
∗ Developed backup and restore scripts to deploy in production to ensure ongoing maintenance.
∗ Used SQL plan cache to analyze past SQL for candidates to index or rewrite or data model re-architect. (MQTs)
∗ Used DBmon, iDoctor and PEX to double check efforts of database re-design and indexing efforts and trouble shoot pesky performance.
∗ Gathered customer requirements and generated reporting dashboards to give senior management and product marketers supporting marketing collateral to improve sales.
∗ DB's: Microsoft SQL Server; Access, Excel, Oracle, DB2 UDB iSeries.
Harry Fox Agency (Music)
Database Administrator / Data Analyst
New York, NY
January 2008 to 2009
Architected the logical and created physical data models (ERwin) for tracking , measuring, and auditing millions of songs played, with a music song database of over 1.5 million songs.
Modernized data access methods using SQL to accelerate speed-to-market and boost profitability for traditional music licensees such as record labels and distributors, as well as non-traditional entrances into the music space.
Maintained meta data and generated reports to support end-to-end business solutions services for licensing, database management, content consulting, and auditing.
Adjusted QAQQINI to optimize different SQL.
DB's: MS SQL Server; Access, Excel, DB2 UDB on iSeries..
United Parcel Service (UPS)
Senior Global Capacity Planning Architect
Mahwah, NJ
July 2007 to December 2007
∗ Worked with various levels in management in a large multinational organization.
∗ Translated business plans into technical requirements, and generated reports to fulfill requirements.
∗ Analyzed and graphed performance trends using Excel and other IBM and 3rd party tools.
∗ Benchmarked overall performance of applications, application upgrades and Operating System upgrades and projected future impact to hardware and overall throughput.
∗ Projected workload needs and planned hardware capacity.
∗ Increased throughput by increasing I/O resources (disk arms, I/O cards CPU) and rewriting SQL.
∗ Found application bottlenecks and recommended solutions, such as increasing disk arms or increasing memory resulting in objectives being met during peak holiday times where the web site will receive 40 million unique visits per day.
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series.
Wall Street consulting firm
Database Administrator / Data Analyst
New York, NY
2006-2007
∗ Data warehouse project, (AS/400) DB2 UDB for (Miami-Dade) county government.
∗ Used Erwin to reverse and forward engineer physical models.
∗ Wrote stored procedures, triggers, converted SQL objects from DB2 to SQL Server and vice versa.
∗ Used SQL Server Integration Services (SSIS) to move data from and to .
∗ Developed performance tuning strategy.
∗ Tuned indexes and adjusted DB2/400 SQL optimizer knobs for best performance. (QAQQINI)
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series.
Movado Group
Engineer / Data Analyst / Administration
Paramus, Moonachie NJ
2005-2006
∗ Used wide range of skills needed to plan, build and test a complex warehouse automation project to be able to ship 500,000 watches in one day.
∗ Used wide range of skills needed to plan, build and test a complex warehouse automation project.
∗ Replaced core network switches with Cisco stacks, upgraded Bay stacks in outer closets.
∗ Developed DB2 on to SQL Server interfaces.
∗ Determined query job priorities and ended run away query jobs.(QZDASOINIT)
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series.
Pernod Ricard (liquor importer / manufacturing ) (Seagram, Absolut Vodka)
White Plains, New York
2003-2004
* Rescued OS/400 upgrade gone bad.
∗ Provided DB2 UDB on performance consulting, support, training and strategy.
∗ Increased over all performance of production after previous problematic OS/400 upgrade.
∗ Re-established QAQQINNI values and other systems values.
∗ Collected and analyzed performance data using WRKACTJOB, STRDBMON, STRPFRT and WRKOBJLCK.
∗ Provided recommendations to increase throughput. (subsystem memory partitioning, job priority(JOBD) and expert cache)
∗ Conducted training classes for developers on how SQL affects general AS/400 performance and modern tools available in Access (formerly called Client Access).
∗ Provided on and off site services.
∗ Tuned indexes and other optimizer knobs for better performance. (QAQQINI)
New York University
New York City, NY
System design / System architecture / Builder
2003-2002
∗ Designed and implemented web-based application using LAMP (Linux, Apache, Mysql and PHP). This system managed the city's largest real estate holder (NYU) attributes of each building and its inspections.
∗ Designed (logical), developed, and implemented (physical) data architectures to support reporting needs of various departments using ERwin.
∗ Compiled Linux kernel to support various special features 2.6.xx.
∗ Wrote Linux scripts to start, control and shutdown servers and check status of other servers.
∗ Provided on and off site services.
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series, MySQL
Henry Schein Inc
Melville, NY
General Performance Lead / Administrator Consultant
2002-2003
∗ Data warehouse project included a web front end, a Windows middle tier and DB2 UDB for the data of the warehouse itself.
∗ Lead team responsible for overall performance of all tiers.
∗ Estimated work load, specified server configuration (memory, DASD and IOP’s), (all system values, subsystems, and users authorities)
∗ Tracked utilization and determined bottlenecks to improve performance.
∗ Staged, tested and controlled PTF, OS upgrades, system values and changes into production. Wrote policies / procedures and documentation. Developed functional and performance tuning procedures. Controlled promotion from: development into testing and into production. Used ERWIN to build and populate schemas.
∗ DB's: MicroStraegy, MS SQL Server; Access, Excel, DB2 UDB i Series.
Harley Davidson
DB2 UDB Database Administrator - Operations
Milwaukee, WI
1999 to 2001
∗ Led teams in the selection, testing and implementation of BRMS (tape management), DataMirror (data replication and high availability), and network upgrades (away from SNA to TCP/IP).
∗ Planned capacity, coordinated and installed software, and hardware upgrades.
∗ Developed trouble shooting procedures and standards documents for client-server and n-tier applications enterprise wide.
∗ Enabled access to legacy data within DB2/400 UDB by designing and maintaining: ODBC, JDBC, DDM, FTP, file transfer (CA) and DataMirror projects interfacing to / from Microsoft SQL Server and Oracle.
∗ Developed data standards for replicating data from AS/400 applications to SQL Server / Oracle based applications.
∗ DB's: MS SQL Server; Access, Excel, Oracle, DB2 UDB i Series.
IBM Small Business Partner
Application Specialist / Database Administrator / Infrastructure Consultant
Milwaukee WI
1996 to 2002
∗ Provided strategy / support to a conversion team migrating an application to AS/400
∗ Planned and executed migrations including: transition of all objects (data and programs), user libraries, and security objects
∗ Determine requirements and built systems to specs, achieving customer satisfaction.
XL Datacomp Inc. StorageTek (IBM National Reseller)
National Training Instructor
Chicago IL
1987 to 1996
∗ Trained Customer Service Engineers from around the world on installation, configuration, and maintenance of AS/400 (iSeries) systems.
∗ Selected as a National Technical Support specialist responsible for providing the highest level of technical support to field personnel.
Education, Training and Certifications
Milwaukee School of Engineering
Electrical Engineering (1987)
Certified Novell Administrator (1994)
Certified Novell Engineer (1994)
DataMirror
High Availability Suite (2000)
Transformation Server (2000)
Team building
Captain of team that raced sailboats in Midwest and Northeast.
IBM
IBM VLDB Workshop, planning for partitioning (2013)
Rational Data Architect, proof of technology, NYC (2008)
DB2 UDB Version 8 Performance Workshop, Toronto (2005)
DB2/400 Database Coding and Implementation (1999)
IBM Certified Specialist - Technical Solutions (1998)
IBM Certified Specialist - Sales Solutions (1998)
Microsoft
803 Administering Microsoft Windows NT 4.0 (1999)
832 System Administrations for Microsoft SQL Server (1999)
833 Designing and Implementing Databases Microsoft SQL Server (2000)
Federal Communications Commission
General Class Operator KB9UKM
Federal Emergency Management Agency (FEMA)
IS-100 Introduction to Incident Command. (2006)
IS-700 National Incident Management System (NIMS) (2006)
Linux World 2003, 2004
Tyler Weggel
76 4th Street North #867
Saint Petersburg, FL 33731
tylertyler@gmail.com
Skills Summary
25 Years of Professional Experience in IBM iSeries DB2 UDB Performance, overall iSeries Administration.
Heavy experience in Admin of IBM System I, including TCP/IP, User Authority, Single Sign On, and overall risk assessment.
Project Management, supervision, and responsibility for transitioning legacy systems to achieve peak efficiency and performance, requiring documentation, training, communication, and organization skills.
US Citizen
Work Experience
Cigna, Administrator of iSeries
Remote
August 2016 to Current
* Installed IBM fixes (PTF’s), worked with team to configure networking (ports) settings for optimal security.(SSL)
* Guided application group on changing default OS/400 values to be more secure (level 40)
Senior Data Analyst / Database Administrator (iSeries /400) DB2
Remote
University of Pittsburgh Medical College (UPMC)
Pittsburgh, PA
2013 January – August 2016
* Lead Database Administrator on iSeries DB2 for several projects.
* Team player implementing Informatica Change Data Capture (CDC) from DB2 to SQL Server.
* Team player implementing GoldenGate to move data from DB2 to Oracle.
* In both of the above conversion(s) IBM Query Options needed to be tuned by application.
* Configured iSeries to use Kerberos, LDAP, and single sign on with in the enterprise
* Assisted in operations and performance improvements on iSeries DB2.
* DB's: MS SQL Server; Access, Oracle, DB2 UDB iSeries.
eBay Enterprise (Formerly GSI Commerce)
DB2 UDB/400 Remote
Senior Database Administrator / Data Analyst
New York, NY
2009 July – January 2013
∗ Database architecture was changed to enable rapid business growth, maximum number of records was perilously close (4 GB) (DB max).
∗ Created indexes to support automated tool's SQL.
∗ Managed reporting projects and led the discovery of “hidden” trends in data sets, resulting in hundreds of thousands of dollars of savings in order fulfillment/delivery over a 5-year period.
∗ Designed (logical), developed, and implemented (physical) data architectures to support reporting needs of various departments using Erwin for modeling.
∗ Analyzed SQL for needed index creations, rewrites or structure redesign suggested RPG changes.
∗ Completed large structure changes of production tables within small time windows. (gigabytes in an hour)
∗ Designed and transformed existing legacy reporting platform to new web based version.
∗ Updated data model to reflect newer tools capabilities (star, hierarchical, flat, network)
∗ Used DBmon, iDoctor and PEX to hunt out most stubborn performance issues.(and solve)
∗ Analyzed and suggested changes (SQL rewrites, re-structured tables/models) to queries to use SQE instead of CQE, company wide, resulting in streamlined, simplified reporting to enable senior management to quickly identify contributions to top-line revenue.
* Configured TCP/IP, LDAP, Kerberos, servers to use Active Directory Service in the
Enterprise Identity schema.
∗ Enabled Iseries with in the single sign on proof of concept project.
∗ DB's: Oracle, AIX DB2, MySQL, iSeries DB2. (became largest iSeries during December with 64 cores)
Major League Baseball (MLB) Office of the Commissioner
Senior iSeries DB2 Database Administrator / Data Analyst
Park Ave, New York, NY
2009 February – 2009 July
∗ Oversaw the data indexing strategy in a data warehouse for consolidating statistics across legacy systems to overhaul and modernize reporting company wide, and bolster the expansion and popularity of the audience fan base.
∗ Captured system-wide performance data, made improved performance speed by up to 40X, and integrated over 200 new attributes to quantifying the revenue impact of advertising each game and each play.
∗ Designed (logical), developed, and implemented (physical) data architectures to support reporting needs of various departments using Erwin.
∗ Developed backup and restore scripts to deploy in production to ensure ongoing maintenance.
∗ Used SQL plan cache to analyze past SQL for candidates to index or rewrite or data model re-architect. (MQTs)
∗ Used DBmon, iDoctor and PEX to double check efforts of database re-design and indexing efforts and trouble shoot pesky performance.
∗ Gathered customer requirements and generated reporting dashboards to give senior management and product marketers supporting marketing collateral to improve sales.
∗ DB's: Microsoft SQL Server; Access, Excel, Oracle, DB2 UDB iSeries.
Harry Fox Agency (Music)
Database Administrator / Data Analyst
New York, NY
January 2008 to 2009
Architected the logical and created physical data models (ERwin) for tracking , measuring, and auditing millions of songs played, with a music song database of over 1.5 million songs.
Modernized data access methods using SQL to accelerate speed-to-market and boost profitability for traditional music licensees such as record labels and distributors, as well as non-traditional entrances into the music space.
Maintained meta data and generated reports to support end-to-end business solutions services for licensing, database management, content consulting, and auditing.
Adjusted QAQQINI to optimize different SQL.
DB's: MS SQL Server; Access, Excel, DB2 UDB on iSeries..
United Parcel Service (UPS)
Senior Global Capacity Planning Architect
Mahwah, NJ
July 2007 to December 2007
∗ Worked with various levels in management in a large multinational organization.
∗ Translated business plans into technical requirements, and generated reports to fulfill requirements.
∗ Analyzed and graphed performance trends using Excel and other IBM and 3rd party tools.
∗ Benchmarked overall performance of applications, application upgrades and Operating System upgrades and projected future impact to hardware and overall throughput.
∗ Projected workload needs and planned hardware capacity.
∗ Increased throughput by increasing I/O resources (disk arms, I/O cards CPU) and rewriting SQL.
∗ Found application bottlenecks and recommended solutions, such as increasing disk arms or increasing memory resulting in objectives being met during peak holiday times where the web site will receive 40 million unique visits per day.
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series.
Wall Street consulting firm
Database Administrator / Data Analyst
New York, NY
2006-2007
∗ Data warehouse project, (AS/400) DB2 UDB for (Miami-Dade) county government.
∗ Used Erwin to reverse and forward engineer physical models.
∗ Wrote stored procedures, triggers, converted SQL objects from DB2 to SQL Server and vice versa.
∗ Used SQL Server Integration Services (SSIS) to move data from and to .
∗ Developed performance tuning strategy.
∗ Tuned indexes and adjusted DB2/400 SQL optimizer knobs for best performance. (QAQQINI)
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series.
Movado Group
Engineer / Data Analyst / Administration
Paramus, Moonachie NJ
2005-2006
∗ Used wide range of skills needed to plan, build and test a complex warehouse automation project to be able to ship 500,000 watches in one day.
∗ Used wide range of skills needed to plan, build and test a complex warehouse automation project.
∗ Replaced core network switches with Cisco stacks, upgraded Bay stacks in outer closets.
∗ Developed DB2 on to SQL Server interfaces.
∗ Determined query job priorities and ended run away query jobs.(QZDASOINIT)
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series.
Pernod Ricard (liquor importer / manufacturing ) (Seagram, Absolut Vodka)
White Plains, New York
2003-2004
* Rescued OS/400 upgrade gone bad.
∗ Provided DB2 UDB on performance consulting, support, training and strategy.
∗ Increased over all performance of production after previous problematic OS/400 upgrade.
∗ Re-established QAQQINNI values and other systems values.
∗ Collected and analyzed performance data using WRKACTJOB, STRDBMON, STRPFRT and WRKOBJLCK.
∗ Provided recommendations to increase throughput. (subsystem memory partitioning, job priority(JOBD) and expert cache)
∗ Conducted training classes for developers on how SQL affects general AS/400 performance and modern tools available in Access (formerly called Client Access).
∗ Provided on and off site services.
∗ Tuned indexes and other optimizer knobs for better performance. (QAQQINI)
New York University
New York City, NY
System design / System architecture / Builder
2003-2002
∗ Designed and implemented web-based application using LAMP (Linux, Apache, Mysql and PHP). This system managed the city's largest real estate holder (NYU) attributes of each building and its inspections.
∗ Designed (logical), developed, and implemented (physical) data architectures to support reporting needs of various departments using ERwin.
∗ Compiled Linux kernel to support various special features 2.6.xx.
∗ Wrote Linux scripts to start, control and shutdown servers and check status of other servers.
∗ Provided on and off site services.
∗ DB's: MS SQL Server; Access, Excel, DB2 UDB i Series, MySQL
Henry Schein Inc
Melville, NY
General Performance Lead / Administrator Consultant
2002-2003
∗ Data warehouse project included a web front end, a Windows middle tier and DB2 UDB for the data of the warehouse itself.
∗ Lead team responsible for overall performance of all tiers.
∗ Estimated work load, specified server configuration (memory, DASD and IOP’s), (all system values, subsystems, and users authorities)
∗ Tracked utilization and determined bottlenecks to improve performance.
∗ Staged, tested and controlled PTF, OS upgrades, system values and changes into production. Wrote policies / procedures and documentation. Developed functional and performance tuning procedures. Controlled promotion from: development into testing and into production. Used ERWIN to build and populate schemas.
∗ DB's: MicroStraegy, MS SQL Server; Access, Excel, DB2 UDB i Series.
Harley Davidson
DB2 UDB Database Administrator - Operations
Milwaukee, WI
1999 to 2001
∗ Led teams in the selection, testing and implementation of BRMS (tape management), DataMirror (data replication and high availability), and network upgrades (away from SNA to TCP/IP).
∗ Planned capacity, coordinated and installed software, and hardware upgrades.
∗ Developed trouble shooting procedures and standards documents for client-server and n-tier applications enterprise wide.
∗ Enabled access to legacy data within DB2/400 UDB by designing and maintaining: ODBC, JDBC, DDM, FTP, file transfer (CA) and DataMirror projects interfacing to / from Microsoft SQL Server and Oracle.
∗ Developed data standards for replicating data from AS/400 applications to SQL Server / Oracle based applications.
∗ DB's: MS SQL Server; Access, Excel, Oracle, DB2 UDB i Series.
IBM Small Business Partner
Application Specialist / Database Administrator / Infrastructure Consultant
Milwaukee WI
1996 to 2002
∗ Provided strategy / support to a conversion team migrating an application to AS/400
∗ Planned and executed migrations including: transition of all objects (data and programs), user libraries, and security objects
∗ Determine requirements and built systems to specs, achieving customer satisfaction.
XL Datacomp Inc. StorageTek (IBM National Reseller)
National Training Instructor
Chicago IL
1987 to 1996
∗ Trained Customer Service Engineers from around the world on installation, configuration, and maintenance of AS/400 (iSeries) systems.
∗ Selected as a National Technical Support specialist responsible for providing the highest level of technical support to field personnel.
Education, Training and Certifications
Milwaukee School of Engineering
Electrical Engineering (1987)
Certified Novell Administrator (1994)
Certified Novell Engineer (1994)
DataMirror
High Availability Suite (2000)
Transformation Server (2000)
Team building
Captain of team that raced sailboats in Midwest and Northeast.
IBM
IBM VLDB Workshop, planning for partitioning (2013)
Rational Data Architect, proof of technology, NYC (2008)
DB2 UDB Version 8 Performance Workshop, Toronto (2005)
DB2/400 Database Coding and Implementation (1999)
IBM Certified Specialist - Technical Solutions (1998)
IBM Certified Specialist - Sales Solutions (1998)
Microsoft
803 Administering Microsoft Windows NT 4.0 (1999)
832 System Administrations for Microsoft SQL Server (1999)
833 Designing and Implementing Databases Microsoft SQL Server (2000)
Federal Communications Commission
General Class Operator KB9UKM
Federal Emergency Management Agency (FEMA)
IS-100 Introduction to Incident Command. (2006)
IS-700 National Incident Management System (NIMS) (2006)
Linux World 2003, 2004
Geographic Preferences:
Security Clearances:
ard