RICHARD S. TROUPIN
PROFESSIONAL SUMMARY
· Experienced Technical Manager / Project Manager / Programmer / Business Analyst
· Highly effective with customers, end users, upper management, and technical project managers and developers in teams. Self starter.
· Effective leader with analytical, business, financial, training skills, and MBA.
· Strong interpersonal, team building, and matrix management skills.
· Effective working with technical and non-technical functions and users
· Positive change agent and mentor familiar with the latest Microsoft products, initiatives, and n-tier system architecture and OO A/D and OOP
· Full Software Development Life Cycle (SDLC) design and development across many industries including financial services, manufacturing, health care, not-for-profit, government.
· Design, enhancement, maintenance of a variant of internet sites supporting consumers, businesses, and call centers.
· Effective in developing structured systems for unstructured and non-traditional environments utilizing vision, entrepreneurial spirit, strong sense of urgency, and personal integrity.
· Strategic and tactical thinker, team player, effective facilitator and change agent.
· Comfortable developing in iterative RAD, Waterfall, Rational , Microsoft or custom unified processes
· Actively involved in the leadership of all projects I have worked on.
· Skilled Analyst and interviewer capable of uncovering full system interactions and effectively writing use cases, application requirements, and test plans covering wide ranging business processes.
· Skilled senior business analyst capable of understanding, documenting and improving a wide range of business processes with technologically appropriate solutions.
Platforms: MS-DOS, Windows 3.x, 95, 98, 2000, XP, Windows NT 3.51, 4.0, NT Server 4.0, Windows 2000 Advanced Server. Windows Server 2003
Software BASIC, Visual BASIC 4.0 -6.0, VB.NET, ASP, ASP.NET, COBOL, HTML, ASP, JavaScript, MS Visual InterDev, VBScript, Active-X Data Objects (ADO), MS Visual Studio (5.0 and 6.0 Professional and Enterprise, VS.NET ), MS Visual SourceSafe, VideoSoft Flexgrid 7.0, MS Project 98-2003, Microsoft Visual Modeler (Rational Visual Modeler), .NET Framework (1.0-2.0), C#, JAVA, J2ME, Visio UML, Borland Caliber, Visual Studio 2005, CodeSmith and netTiers.
Databases MS Access 97, 2000, SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server CE, Sybase ASA 4.5, 11.2, Tandem, and Oracle 9i, AS400, and DB2.
Federal Security Clearance: USPS Sensitive (equivalent to military level of Secret)
RST Consulting, LLC, St. Louis, MO
Consultant
July 2006- Present
Contracted to work through SSE Inc. on a range of projects and roles including:
· Developer of an Intranet site for a client using ASP.NET 2.0 and C#
· Sr. Business Analyst role documenting current credit card processes for a legacy system used by a national firm. Also working with team of internal resources from all departments, developed requirements for and reviewed vendors for the new credit card system. Created functional requirements and detailed conversion and implementation processes for new credit card system.
· Business Analyst / Developer roles for new Windows Mobile 5.0 Smartphone application that was originally envisioned as a Tablet PC application replacing a paper and MS Access process. Device change provided significant savings in hardware costs to client while enhancing the productivity of field staff.
Environment: ASP.NET 2.0 XML Web Services, Windows CE 5.0, C#, SQL Server 2000, SQL Server CE.
Modis, St, Louis, MO
Consultant
March 2006 – June 2006
Environment: Visual Studio 2005, SQL Server 2000, ASP.NET 2.0, .NET Framework 2.0, Language: VB.NET.
Coded significant part of large government sponsored internet site with over 50 screens, including several Wizards in ASP.NET 2.0 using VB.NET. Integrated InstantForumsASP, used CodeSmith and .netTiers modules with custom classes to speed development and go live in under 8 weeks with only two developers (myself and one other FTE). Active in deployment and coordination of fine-tuning, once the site was live. Also, created web-based Administrative Management system for a site involving 20 plus screens, coded stored procedures. Managed one other developer during QA process.
RST Consulting, St, Louis, MO
Consultant
December 2005 – Present
Environment: Office and Visio, Visual Studio 2005, SQL Server 2000, ASP.NET 2.0, .NET Framework 2.0, Visual Studio 2005 Tools for Office. Language: C#.
Created an extranet site to support a new product launch for American Power Conversion Corporation (APC), a $2.0 billion revenue firm. Responsibilities include full SDLC including management of requirements gathering with Marketing and Engineering staff to define, screens, calculations, database design, deployment and integration. Coded stored procedures, created full documentation for the project, project planning, and coordination with IT resources, coding and unit testing of the site, deployment planning. Site includes MS Office automation using VSTO 2005.
RST Consulting, Springfield, IL and St, Louis, MO
Consultant
November 2005-December 2005
Environment: Office and Visio, Visual Studio 2005, SQL Server 2005, .NET Framework 2.0. Languages: VB.NET and C#.
Serve in a Sr. Business Analyst role, creating documentation for large client server project for a start-up firm in the software development stage. Artifacts created included UML Activity, Sequence and Use Case diagrams, descriptions of all methods, and identification of key processes for optimization. Provide recommendations for improving the scalability and security, designed custom testing architecture for complex, high volume, automated testing program.
Northrop Grumman IT, St. Louis, MO
Sr. Programmer / Analyst 3 for the U.S. Postal Service
February 2005 to September 2005
Environment: Large VB 6.0 client, DB2 client-server using NEON servers.
Perform wide range of functions on large project including requirements gathering meetings with client, requirements document creation, solution design and architecture, general and detailed design document creation of enhancements, VB coding, Crystal Reports creation, COBOL analysis, methodology and process improvement, and testing. The Delivery Operations Information System (DOIS) is used by over 9000 of the largest post offices daily. Served in senior role on team of 20 enhancement contractors; led design of 3 of 4 major components of Phase 1. In Phase 2, took concept from vision (PowerPoint presentations) through requirements, design, database definition, general design, and customer signoff into coding. Fall ’05 release.
RST CONSULTING, St. Louis, MO
Owner/Consultant
November 2004 – Present
Serve a variety of clients providing technology consulting services. Recent projects include website development application integration and network support for a law firm. Project management and custom application development.
TEK Systems, St. Louis, MO
Programmer/Analyst
July 2004-November 2004
Environment: VB.NET, ASP.NET, ASP 3.0, SQL Server 2000, AS400.
As consultant at Aon Information Systems, work on a wide range of issues including maintenance of applications that supported various internet sites and software for the call center for one of the nations largest appliance warranty insurers. Significant role in architecture, analysis, design, and coding of Enterprise file handling processes to create unified process to handle PGP, FTP, SQL Server DTS, custom file processing, and unified reporting using VB.NET. Also re-designed a portions of the payment financial settlement application in VB.NET adding transaction management
RST CONSULTING, St. Louis, MO
Owner/Consultant
May 2004-July 2004
Environment: VB.NET, ASP.NET, SQL Server 2000.
Contracted through Grace Technologies as Technical Lead in design of POS Application Integration with Regional Justice Information System’s (REJIS) systems using Microsoft Retail Management Software (RMS). Major role in meetings with technical and end users and overall system architecture. Developed initial Project Plan using MS Project 2003, coded portions related to RMS integration. Interface development and Application Customization uses VB.NET and ASP.NET, COM+ through .NET Interop within RMS HTML browser. Worked with third parties to resolve issues related to customization of RMS through COM calls through internal and external browsers.
MARITZ, St. Louis, MO
March 2004-April 2004
Environment: ASP 3.0, SQL Server 2000 stored procedures, DTS.
Contracted through Jupiter Consulting to support a Maritz Loyalty Marketing team’s launch of a new website. Stepped in to help covered for Technical Lead who had to take personal leave for a family medical emergency shortly before launch. Provided analysis of integration issues, content and programming changes to the front-end of the sites that supported the consumer web site and the customer support call center.
SPHERION, St. Louis, MO
Consultant
February 2004-March 2004
Environment: Microsoft Access 2000.
Designed, coded, wrote documentation for, and deployed for User Acceptance Testing (UAT), a Time Tracking system for a subsidiary of MasterCard. Enables disconnected asynchronous entry of time and expenses. Built with VB, Access 2002, XML on Windows platform.
RST CONSULTING, St. Louis, MO
Consultant / Owner
March 2001-Present
Environment: VB.NET, ASP.NET, C#, SQL Server 2000, Web Services, J2ME, JAVA.
Provide consulting services to diverse clientele including project management, technology consulting, hardware/software upgrades, PC training, productivity consulting, custom application design, programming, implementation. Design websites for retail clients. Managed the developed internet sites and Web Services that utilized .NET technologies (VB.NET, ASP.NET, C#). Some Java, J2ME and Oracle training and exposure (9i). Other projects have included a Law office system upgrade and design of an improved backup system (installed network, migrated and configured law office software including Casemaster and Wordperfect from Lantastic on DOS to Windows 98 TCP/IP network) and the Project Management, Requirements Gathering, Design (Visio) and Coding of a Material Handling / Purchase Order automation system for a small manufacturing firm.
KEYSTONE STAFFING, St. Louis, MO
Programmer Analyst
July 2003-November 2003
Environment: VB.NET, ASP.NET, SQL Server 2000, Microsoft Access 2000.
Short-term contract at Marketing Direct to provided data analysis, documentation, and code review of existing processes. Designed and wrote some utilities in VB.NET. Coded, tested, and implemented some business rule changes to existing VB.NET applications running against SQL Server 2000. Created recommendations, wrote implementation protocol. Managed the implementation of the changes into the production environment. Retained to design and code a Production Control System for managing mail events that improved coordination with less staff. Access 2000 front-end (requirement for first phase), VBA code, Access and SQL Server 2000 back-end.
BLACKBAUD, INC., Charleston, SC
Custom Programmer
November 2002-June 2003
Environment: VB.6.0, VB.NET, SQL Server 2000, Sybase 7, Crystal Report Designer 7.
As part of the Enterprise Software Customization Team, designed, coded, tested and deployed program customizations for clients using VB 6.0 and VBA to meet their business needs. Also designed custom reports for clients using Crystal Report Designer 7.0. Worked on Team Methodology and Business Process improvement and Knowledge Management teams. Provided suggestions to top management for developer productivity improvements using .NET. Worked with Sybase ASA, SQL Server, MS Access.
MAVERICK TECHNOLOGIES, Chesterfield, MO
Staff Consultant
September 2001-June 2002
Environment: VB.6.0, VB.NET, SQL Server 2000, Microsoft Access 2000.
As a member of the IT Projects team, involved in project management, design, programming, and implementation of projects using VB 6.0, VB.NET, ASP, ASP.NET, Access, NT, Windows 2000, SQL Server 7.0, and SQL Server 2000 for several manufacturing clients and internal projects. Created a Recipe application for major tire manufacturer that read and wrote directly to Modicom Programmable Logic Controller (PLC) registers to speed product run changes (VB 6.0). Led .NET initiative for firm- saw strategic impact, developed and wrote business case, presented it to senior management, received funding for training for firm’s VB developers. Member of team that developed n-Tier .NET applications using SQL Server 2000, ASP.NET, VB.NET. Implemented .NET Framework Security schemas. Served as Webmaster for the firm for part of 2002 (ASP).
INFORIZONS, INC., St. Louis, MO
Consultant
March 2000 - February 2001
Environment: VB.6.0, VSS,
As a Sr. Programmer/Analyst at A.G. Edwards, worked on a large client-server application. Upgraded and re-designed large VB 3.0 application to VB 6.0. Integrated MS ADO Recordsets with Sybase server-side cursors. Assisted in complete Object Oriented re-design of a major VB Client Server application using UML tools and objects to create a 3-Tier architecture separating User Interface, Business Logic, and Data layers. Wrote VB specifications for the application. Wrote Use Cases for VB Client from analysis of prior VB application versions and various specifications. Wrote Test Cases for the application. Utilized Microsoft Visual SourceSafe, Rational Visual Modeler. Following Microsoft 32-bit coding standards; rewrote SQL statements, upgrading third party and proprietary controls. Conducted code reviews, technical, and design reviews, provided re-design suggestions. Debugged prototype. Worked with Sybase, Tandem and mainframe databases and communication protocols, COM, and MS Project 98.
RST CONSULTING, St. Louis, MO
Consultant
May 1995-March 2000
Provide wide range of services to diverse clientele including project management, technology consulting, hardware/software upgrades, Y2K testing and upgrading, PC training, productivity consulting, internet marketing and web mastering, applications programming, including data conversions using Excel, Access, Visual BASIC, VBA, ASP, and marketing services involving innovative target marketing. Projects included:
Houlihan Office Solutions - Project Manager
Managed all elements of US Postal Service Dinero Seguro Project. Goal was to replace the pilot project's 1000+ leased PC's in 800+ US Post Offices in California, Texas, Illinois with USPS furnished equipment acquired from DEC. Responsibilities included creating and managing inventory control procedures, contracting labor. Developed procedures to implement on-site technical work including testing, revising USPS created procedures that involved ghosting image, LAN and dial-up configuration of WIN95 PC's. Recruited, trained, supervised teams of technicians in 3 states. Coordinated troubleshooting of WAN/LAN connectivity issues with USPS technical staff in Raleigh, N.C. Involved in hardware failure diagnostics/investigation procedures. Maintained positive relations with various USPS clients via E-mail, telephone contact to complete conversion to new hardware/software environment with minimal complications overcoming a variety of challenges. Designed, delivered all reports. Profitably completed project.
Talking Tapes- Managed the full cycle of the conversion of legacy Btrieve library and order tracking system and tape production system to a Client / Server system with Microsoft Access back-end, Visual BASIC front-end running on NT Server with NT 4.0 workstations. Conducted extensive user interviews to gather specifications. Completely re-designed and upgraded a custom library management system. Added greater order-entry detail, shipping information data capture and increased marketing data management functionality. Created automated module to produce web pages of new catalog pages. Provided user training. Configured and reloaded Server and workstations. Migrated btrieve bar code scanner functionality to VB 6.0. Environment: NT 4.0 Server on LAN with NT 4.0 Workstations.
Created online catalog of 5000+ items by converting a legacy print document utilizing Excel and VBA. Also provided the data as an MS Access database and provided training of staff to facilitate its maintenance. Environment: Win95 PC/ Internet.
Sprint PCS Y2K Remediation SWAT Team -performed upgrades and provided end-user support/problem resolution of Windows 95, Office 97, Outlook, Exchange issues.
US Tape & Label - Developed tool for data conversion for US Treasury to facilitate distributed label printing using VB 6.0.
Data conversions - Converted 8 years of data from legacy flat files to Access databases in less than one week. Environment: NT 4.0 Server on LAN / PC's running WIN95.
Internet development - As Marketing Consultant, created the strategic marketing campaign, then designed and built a large internet site focusing on senior healthcare issues for a skilled nursing facility that enabled it to build its market presence.
Project management – led the development of a large internet site, facilitated and coordinated bringing wide range of service provider's information together. Involved meeting with wide range of public and private organizations to secure information and authorization to post it on the Internet. Provided training to social workers and Mo. Div. of Aging staff in Internet search techniques. Provided PC support/maintenance at Skilled Nursing Facility. Also designed, implemented marketing program including brochures and advertising. Environment: Win 3.11 Win95 PC
Designed web-site for the St. Louis Society of the Blind and Visually Impaired for users with visually impairments and sited visitors. Very usable for the blind using current PC/ voice translators. It offers several ways to view each page-some more accessible to some vision problems than others. Environment: PC / Internet
Training - Designed and taught courses on Windows 95, Internet Basics, Advanced Internet search topics at various venues including Southwestern Bell Tele-Community Center at the University of Missouri-St. Louis.
MERRILL LYNCH, St. Louis, MO
Financial Consultant
1992-1995
Responsibilities included serving individuals and firms with business, financial planning, and investment management. Services provided included: credit and cash management, asset allocation, investment selection, management and review.
Built significant clientele offering customized professional services to high net worth clients.
Created and presented seminars in Equity Portfolio Management, Bond Portfolio Management that created significant client relationships.
METLIFE / CENTURY 21 INSURANCE SERVICES, INC. St. Louis, MO
Director of Agencies, Branch Manager, Sales Manager, Sales Representative
1978-1992
Chosen to establish new subsidiary (Century 21 Insurance Services, Inc.) to offer insurance products through Eastern Missouri Real Estate Brokers' operations, integrating insurance marketing. Hired and trained Account Executives to service over 30 offices. P&L responsibility for all operations of Branch office including recruiting, training, motivation and supervision of Sales Representatives and Administrative staff and did pioneering work in using laptop PC's in insurance field sales.
Developed procedures, techniques and materials, methods and training for laptop PC use that increased representative productivity.
Developed training modules, materials for use by Directors of Agencies across U.S.
Increased profitability 200% by increasing sales and sales reps, and by cutting expenses.
Designed, presented and installed health plans, Cafeteria plans, retirement plans, 401(k) plans, supplemental and key person insurance programs increasing revenues.
St. Charles County Community College, St. Charles, MO -programming classes
Washington University, St. Louis, MO
M.B.A. Management
Washington University, St. Louis, MO
A.B. Psychology and Philosophy
PROFESSIONAL DESIGNATIONS, CERTIFICATIONS, TRAINING
Microsoft® Certified Professional (MCP)
Designing and Implementing Desktop Applications With Microsoft Visual Basic 6.0
Designing and Implementing Distributed Applications With Microsoft Visual Basic 6.0
Various Microsoft Training programs including: Windows 2000 migration, SQL Server 7.0 migration, Exchange Server 2000 migration, Visual Studio.NET , MS Project 2002
Total Quality Management
Chartered Financial Consultant (ChFC), American College, Bryn Mawr, PA.
Chartered Life Underwriter (CLU), American College, Bryn Mawr, PA