781-910-3543
P.O. Box 93
Scituate, MA 02066 snag56@hotmail.com  


Roy Street

Summary

Over 35 years of design and engineering experience, in a diverse range of technologies, most recently focusing on SharePoint, SQL Server and system integration solutions.

 



Technologies 

MOSS 2007/SharePoint 2010, .Net 3.5, SQL Server 2008/2000/7.0/6.5, Oracle 11i/10g/7.3/7.0, Classic ASP, Windows 2003/2000/NT4.0, PowerShell 2.0/3.0, Log Parser, Visual Log Parser, InfoPath 2010.

 



Other Technologies

Linux Redhat, ASPMail, SunOs 4.0, Solaris 2.5/2.4, Java 1.5/1.4, MKS 2006, Interwoven Teamsite, Load Runner 8.1, PC COBOL, PC Assembler, CICS 1.7, Vignette Portal, Sun One Directory Server 5.1 (LDAP), IBM WebSphere Portal 5.1, IBM Tivoli Directory Server 5.1 (LDAP), Tivoli Identity Manager, Tivoli Access Manager.

 
 
 

Experience

2000 - 12/2013

Iron MountainBoston, MA
Software Architect


 ■    Acted as technical lead, transitioning work from an offshore team in Sri Lanka, to a team consisting of 4 engineers, in Bangalore, India. This involved training the India team with established SDLC processes, gathering requirements from business sponsors, prioritizing and assigning work items, and coordinating production releases.
 
 ■  Implemented SharePoint Variations, to extend intranet application (branded as Scout) to the global business audience. Translations for Microsoft-supplied content was managed using language packs, while translated custom content was provided by a combination of resource files (RESX), SharePoint resource lists and custom utility classes. Further, we chose not to leverage the Microsoft-supplied propagation functionality. Rather, we developed our own configurable propagation feature that provided more flexibility, to propagate only selected content.
 
 ■  Upgraded Scout from MOSS 2007 to SharePoint 2010. This included upgrading from UI3 to UI4, and establishing new user profile synchronization service (including MIIS/Forefront Identity Manager).
 
 ■  Acted as technical lead, overseeing an offshore team, in Sri Lanka, consisting of 2 software engineers, and 2 QA engineers. Conducted performance testing, using Load Runner automated testing suite. Coordinated all production releases. 

 ■  Trained and supported power business partners on how to build and publish browser-based forms, using InfoPath Forms Services.
 
 ■  Developed Capital Expenditure Request (CER) application, hosted upon Iron Mountain’s legacy intranet. Designed and implemented database schema, with focus on strong data typing, usage of triggers, foreign keys, unique keys, check constraints, and stored procedures. Installed, designed and implemented database topology, including optimum placement of database files (for distributed I/O) and developed all automated backup and maintenance scripts and stored procedures. Further, this application utilized multiple database integrations to Oracle Financials (Budgets and Actuals), Oracle Property Management, and Exchange Global Address List (GAL).
 
 ■  Installed, and developed Iron Mountain’s 1st intranet web site, based upon Site Server 3.0, supplemented by Front Page Server Extensions. Further, engineered ODBC integration between SQL Server 7.0 and Lotus Notes. Provided SQL Server DBA support, before the formation of Iron Mountain’s official SQL Server DBA team.
 
 ■  Stabilized and tuned critical keyword search functionality of an extranet web site servicing 150 major accounts that had previously outgrown the inherent design limits of Microsoft’s Full-Text Search option of SQL Server 7.0.
 


7/2000 - 2002

                             Street Machines, Inc. Scituate, MA
President


 ■    Started Street Machines consulting services, specializing in high-performance Web & Wireless solutions, SQL Server & Oracle database administration, systems integrations solutions.
 






2/1997 - 8/2000 TAC Worldwide Companies Newton, MA
SQL Server DBA/Web Administrator

 ■    Developed & deployed redesigned, mission critical, multi-homed (11) Corporate websites, including an extranet component that allowed distributed field offices to manage and maintain Job Postings.   System provided automated inbound job feeds from distributed Bond Resume Management Systems, and automated outbound feeds to GoJobs, Monster Board, Dice and Restrack.  System also included automated Fetch subsystem which would email job matches nightly to subscribers, based upon subscribers search criterion and skill sets.  Also responsible for administration and support of SQL Server, NT, IIS, MTS objects, and batch jobs related to this system.
 
 ■ Developed & deployed clustered Extranet application that acted as an invoice clearing house, transacting millions of dollars per week, receiving feeds from an external EDI Gateway, and extracting feeds to an external Computron/SAP AP system, a VSE mainframe AR system, and an Oracle8 data warehouse.  This system also contained a component that allowed on-site personnel to manage and maintain invoices and supporting requisitions. Also responsible for administration and support of SQL Server, NT, IIS, MTS objects, Cluster Server, and batch jobs related to this system.



3/1995 - 8/1997 TAC Worldwide Companies Newton, MA

Oracle DBA - Unix Administrator



 ■   Designed, installed, and implemented Oracle Data Warehouse server, hosted on a Sun Enterprise 1000 server, and an EMC Mass Storage system.  This also included the development of multiple Winbatch/DOS batch scripts to perform automated data transfers from IBM mainframe to PC and Unix platforms to support Data Warehouse.
 
 ■  Supervised Unix/Oracle/Internet team of 4 technicians.
 
 ■ Designed and developed first Client/Server applications using Power Builder, backed by Watcom database.  Later this also involved upgrading applications from Power Builder 3.0 to 4.0, and from Watcom to Oracle7 Server.



2/1990 - 2/1995

TAC Worldwide Companies Newton, MA

Senior Programmer/Analyst/Systems Integrator



 ■   Setup VSE/HTF (Host Transfer File) and related custom file transfer system to support many Mainframe/PC applications and feeds.
 
 ■ Designed & developed PC/Mainframe Payroll Interface, including a 3270 interface program written in PC COBOL, PC Assembler, mainframe COBOL CICS 1.7, and SDF 1.5.
 
 


9/1988 - 12/1989

            Foxmoor Specialty Stores W. Bridgewater, MA

Senior Systems Programmer



 ■   Installed and maintained multiple VSE/SP systems under VM/SP.
 
 ■ Installed and maintained of all third party software and hardware, including XEROX 4075 printer, CA/Scheduler 7.1., Quota 3.2, System Manager 5.1 (tape & disk mgr.), VSAMTUNE (VSAM tuning), CA/VTERM (Session Manager), Monitor for CICS (CICS tuning), IPCP (CICS batch open/close utility), OMNI-LINK  (micro/-mainframe file transfer), FOCUS/VM, (4-GL Database)
 
 ■ Converted all online applications from CICS 1.6 to 1.7.
 
 ■ Supported BTAM-based store polling applications.
 
 ■ Installed and configured RJE, NJE, VTAM/NCP and VM networks, including NCR Comten 5620 Communications Controller, Harris 9300 micro-processor running Xenix OS (used for 3780 RJE emulation, PC file server, 3174 emulation), Shadow 3.2., BTAM/ES, VSE/VTAM 2 & 3, NCP 4.0, VM/SP R5.1, VSE/SP 2.1.2 - 3.2.2, POWER (including PNET & RJE).  Also, note that I was closely involved with the NEU/VSE users group since 1984.  For part of that time, I served as secretary of NEU/VSE.


Member number:5562
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 1999 Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257