Maxwell C. West, CSP, PMP

E-Ticket Systems, Inc.
19 Trout Farm Lane, Plympton, MA 02367
mwest1@e-tsi.net
781.910.3874

SUMMARY:

IT professional with 20 years of experience as a Database Developer, Business/Systems Analyst, Application Software Engineer and Technical Project Manager.  Leads and performs business/ systems analysis, detailed specifications and design, data analysis, data modeling, coding, Quality Assurance/testing and implementation.  Full life cycle/SDLC, methodology and standards responsibility for Client/Server and Web development using a variety of tools and languages across many industries.        

SKILLS:

• Systems Analysis/Business Analysis: Requirements definition (Software Requirements Specification/SRS), functional specifications (Detailed Design Specification/DDS), UML OOA, IEEE, Yourdon, numerous proprietary methods, Visio UML; context, process and output modeling; rapid prototyping/RAD; some Booch/OMT.
• Data Analysis/RDBMS/Database Administration (DBA): MS SQL Server 2000/2005, Transact SQL, DTS; data analysis, data modeling, data mapping, data definition and naming; XML, XML Spy, ERwin, System Architect; SQL Server backups & restores, job scheduling; security.
• Languages/Tools: Visual Studio 2003,  SQL Server 2000/2005, Visual Basic.NET, ASP.NET, Visual Basic, T-SQL, XML, HTML, MS Access, Crystal Reports, InstallShield, RoboHELP.
• Quality Assurance/Testing: Test plans, test cases, test execution, defect reporting and tracking; Change Management; Configuration Management; user training, user guides, online help; structured walkthroughs; various proprietary testing and Change Management tools; Visual Source Safe; RequisitePro, TestManager and ClearQuest.
• Project Management: Full life cycle/SDLC project management using MS Project 2003 and earlier; PMI; CMM; MS Word, Excel and PowerPoint 2003 and earlier; Kepner-Tregoe, Cadence, Kapur, IEEE, iterative/RAD/rapid development, numerous proprietary SDLC methods.
• Industry/Domain Expertise: Financial, securities, compliance, insurance, accounting, banking, construction, call center, military/DOD, academia, publishing, government, marine, telecom.

EXPERIENCE:

Protegent/Sungard – Hingham, MA (contract)
   Data Analyst; SQL Coder: May, 2005 – Present

• Data Analyst (NFS): Analyzed and mapped securities-related customer, account, balance, position, transaction, bookkeeping and suitability data between Fidelity’s National Financial Services (NFS) and Sungard’s proprietary broker compliance monitoring application. 
• SQL Coder: Implementing data exchange solutions in T-SQL stored procedures and DTS; parsing, translating, merging and moving NFS, Beta, Pershing and proprietary data feeds into Sungard’s SQL Server 2000 analysis database.  Proposed and built generic front end for receiving NFS data that provides 95% reusability for future NFS feeds.  Coded customized import, trade, exception and report defect fixes and enhancements; optimized procedures for runtime minimization.  Also modified some client-side ASP, VBScript, C#, HTML.
• Release Coordinator: Twice assembled 75-100 geographically-, developer- and functionally-disparate files for successful testing and release packages to a major client using Visual Source Safe and DTS.  Smooth first release was factor in sale of second phase.  Also coordinated many smaller releases.

Watch Captain LLC – Mattapoisett, MA (contract)
   Sr. Project Manager, Lead Specifications Analyst: March, 2004 – March, 2005

• Project Manager: successfully led fluid team of five local analysts, designers and testers with secondary responsibility for ten offshore (India) developers building shrink-wrapped business application in VB.NET and SQL Server 2000.  Multi-million dollar budget over two years; responsible for all SDLC phases, deliverable standards, project planning (MS Project 2003) and team communication.  Coordinated hardware and software assessments and acquisition, onshore team member interviews and hiring, and deliverable timing in fast-paced environment where team members averaged 70 hours per week. 
• Lead Specifications Analyst; Data Analyst; QA: Developed Software Requirements and Detailed Design/ Functional Specification processes and templates from multiple sources including IEEE. Led team of five analysts who used these to elicit and document over 1500 pages of requirements and detailed design.  The specifications spanned nine distinct subsystems and served as a solid foundation for class and data models.  Forward engineered over 125 tables and 1200 data elements and definitions from Word, Excel and SQL Server 2000 into ERwin.  Secondary role in QA support; used Rational RequisitePro, TestManager and ClearQuest.

U.S. Department of State – Washington, DC (sub-contract)
   Sr. Data Analyst, Sr. Requirements Analyst: March, 2004 – Jan., 2005

• Lead Data & Requirements Analyst: defined core and peripheral data elements for new historical cost database that tracks and predicts construction costs for US embassy buildings around the world.  Directed team of three analysts defining software and system requirements for US Embassy historical cost database/predictor.  Modified IEEE Software Requirements Specification (SRS) for requirements elicitation and documentation.

R.S. Means Company, Inc. - Kingston, MA (contract)
   Sr. Project Manager, Sr. Systems Analyst; Sr. Data Analyst: June, 1998 – Nov., 2003

Lead roles on four major projects: (1) Reduced distribution costs by 80%, enabled instantaneous core data update by converting VB 6/MS Access shrink-wrapped costing tool to ASP.NET/VB.NET 2003 and SQL Server 2000. (2) Reduced processing time from days to seconds by leading eight-phase migration of Ingres/character-based construction cost tracking and prediction system to VB 6.0 / SQL Server 7.0.  This data is R.S. Means' core business. (3) Led analysis and architecture; managed project for building a third-party, shrink-wrapped project cost and parameters tracking system. (4) Led OOA/D; class architect; wrote XML export scripts for core database supporting web/internet access.

• Requirements Analysis; Design: defined business requirements and functional specifications for new construction cost system, shrink-wrapped tracking and cost systems; IEEE SRS.  Rapid prototyped User Interfaces using VB.NET, VB 6.0 and MS Access; iterative user-review approach. Designed overarching flow and standards; subsystem-specific features.
• Data Analysis: identified, named, defined and modeled 1200 data elements in 100 tables using ERwin; mapped new/existing data for upload; built data dictionary; UML.
• Coding: converted VB 6 and MS Access system to ASP.NET and SQL Server 2000; complex CURSOR and OUTPUT data exchange, validation and integrity confirmation scripts and stored procedures totaling more than 15,000 lines of SQL code.
• Quality Assurance/Testing: wrote test plans; led testing of over 25 major and point releases and Means’ premier insurance industry cost valuator; led defect assessment and prioritization; designed, built and implemented defect tracking database in Access.
• Database Administration: DBA responsibility for SQL Server backups and restores, job scheduling and reporting, user/role security configuration, DTS and SQL scripting.
• Configuration Management: developed Configuration Management and release processes; Visual Source Safe Administrator: installed, configured and trained team; InstallShield lead.
• Project Management: developed project budgets and timelines; coordinated daily project team tasks and tracked/reported using MS Project.  Full SDLC responsibility.

Town of Plympton, Massachusetts (volunteer)
   Sr. Systems Analyst; Developer; Project Manager: Apr., 2002 – Present

• Designed and built web site management application in ASP.NET 2003, Crystal Reports 9 and MS Access.  Enables committee members to create, assign, edit and advise others of change requests, manage webmaster schedule and enroll/email news alerts to site subscribers.
• Chairing town committee that did high level requirements, design and testing of town web site that was detail-designed and built by Devine & Pearson.  Committee members collect and edit content while also serving as webmasters to maintain and build out the site.

Sippican, Inc. - Marion, MA (contract)
   Sr. Systems Analyst; Developer: Sept., 2002 – June, 2003

• Analyzed and defined client requirements for sharing Accounting and Project Management data (round trip) between MS Excel and MS Project.  Built three VBA macros to import and export actual and projected costs and work hours, including timescaled data; wrote user guides.

Seagreen Technologies, Inc. - South Easton, MA (contract)
   Project Manager, Sr. Systems Analyst: Feb., 1998 – Oct., 1999

• Led team of clients, analysts and coders developing Web-based XML Client/Server application for academic institutions.  Full budget, timeline, reporting and leadership responsibility; interface with two co-development firms.  Primary advisor for junior developers in areas of requirements, data analysis and QA/testing.  Invited to sit on Seagreen Technologies Steering Committee.

Relocation Resources, Inc. - Norwell, MA
   Director of Information Systems: 1997

• Directed start-up of new IT organization; initiated major turn-around; built team from ground-up. Fully responsible for team development and tasking in systems architecture and design, network structure, server acquisition and installation, RDBMS selection, PC configuration and deployment, and OTS software evaluation, acquisition and customization.  

John Hancock Mutual Life Insurance - Boston, MA (New Technologies & Solutions, Inc. contract)
   Project Manager & Senior Programmer/Analyst: 1996 - 1997

• Led team of 11 Business Analysts, coders and DBA’s migrating legacy, mainframe IMS international insurance system to Client/Server in full development life cycle.  Responsible for all SDLC leadership aspects including primary client interface, project planning and reporting.  Led and performed business requirements analysis, technical specifications, data dictionary/model, developer coordination, coding, configuration management, release packaging and QA/testing.

Pacific Bell  - San Ramon, CA, 1987 – 1996

• Senior Systems Analyst, Technical Lead or Project Manager on nine major software development projects including trouble ticket/call center application used by 5000 employees, state-wide call routing applications, employee time and task reporting systems. Requirements Analysis/SRS, Data Modeling, Design Specifications, QA/Testing, Project Management.