Timothy McSwain

Page 3

Professional Experience Continued

Timothy M. McSwain

5426 Flowering Dogwood Lane Mobile: (704) 771-6518

Charlotte, NC 28270 Home: (704) 846-3536

http://www.timmcswain.net

Software Solutions Consultant / Systems Engineer

Detailed, personable Software Solutions Consultant / Systems Engineer with 10 years of experience implementing and supporting large-scale, Linux / UNIX web-based systems. Over 2 years of deep experience in CRM (specifically SugarCRM) including installation and customization on Linux systems. Overall 18 years of experience in systems engineering and systems analysis in the financial services industry.

¨  Proficient in widely-used technologies including LAMP stack (Linux / Apache / MySQL / PHP), Oracle, SQL Server, SharePoint, Apache web server, IIS

¨  Excellent verbal and written communication skills; unique ability to communicate and build lasting relationships with both business and technology groups

¨  Proven track record of securing budget dollars and project approvals through highly effective demonstrations and presentations

¨  Performed various consulting roles including requirements gathering, project planning / project management, data analysis

¨  Received numerous company awards for demonstrations of developed technology solutions

¨  Frequently sought-after to present and discuss best practices and cost savings when using Open Source software in a regulated, secure environment

Professional Experience

Wells Fargo – Charlotte, North Carolina August 2009 to present

Reporting / Data Analytics Team Manager – Wholesale Banking

·  Serve as liaison between business users and technology staff to design new reports and provide ad-hoc data extract requests in a timely manner

·  Implemented processes to boost team productivity and accountability such as our quick, daily “SCRUM” / status meetings and SharePoint request queue tracking

·  Work closely with QA / Testing to manage defects during our test cycles

Wachovia / Wells Fargo – Charlotte, North Carolina April 2006 to August 2009

Product Manager / Systems Engineer – Corporate Investment Banking Technology

·  Collaborated with users, technical staff and management to build, produce and show our product suite through web meetings and live / recorded demonstrations; each demonstration is customized to address customer’s interests and needs

·  Developed highly successful “Post and Point” support methodology by creating self-service support wiki complete with FAQs and videos; this enabled over 1,000 users to be supported by only 2 FTEs

·  Implemented and customized Linux-based SugarCRM system to manage and track product demonstrations, audit / compliance issues

·  Called on to participate in and define requirements for vetting/proof-of-concept trials for CIBT, Open Source Software Forum, and also at the Enterprise level

·  Created customized training sessions and follow-up support for user groups

Major achievements

·  November 2006: Designed and implemented Automated Build/Release “Framework” for the Investment Bank Technology group; our system was later adopted in February 2008 for Enterprise-wide use
Result: First year savings (for Investment Bank only): $800,000

·  November 2006: Developed “Post and Point” end-user support strategy where support engineers use a wiki site to document FAQs “on the fly”
Result: Reduced support costs; only 2 FTEs support version control systems for 1000+ users

·  August 2007: Requested to present a live demonstration of our Automated Build/Release Framework to senior management
Result: $16MM budget win and major efficiency gains for software development teams

Bank of America – Charlotte, North Carolina November 2002 – April 2006

Software Configuration Management Engineer

·  Responsible for software builds and deployments for critical, high-availability web banking systems using Rational ClearCase, IBM Websphere, Solaris, Linux and various UNIX tools and scripts

·  Served clients by proactively developing “self-serve” dynamic web reports showing real-time status of requests using Oracle SQL, HTML, and Perl at no cost to organization resulting in a decrease in deployment errors, faster software deployment timeframes, and better communication among teams

·  Chosen as one of the leads to study and undergo examination by a 12 member panel for our department-wide SEI CMM Level 2 certification; achieved certification in August 2003

Wakefield Technology LLC – Charlotte, North Carolina July 2002 - November 2002

Database Administrator / Consultant

·  Performed multiple data conversions from legacy systems to Microsoft SQL Server 2000

·  Wrote data transformation packages and SQL scripts to convert data

·  Designed and programmed custom user interface in Microsoft Access and Visual Basic which served as a front-end for data conversion scripts and custom reports

Bank of America – Charlotte, North Carolina June 2001 – July 2002

Application Systems Engineer

·  Served on the Infrastructure team for the LoanSolutions software development team, a web-based mortgage product that allows loans to close in 7 to 10 days

·  Performed customized software installation and troubleshooting on 15+ Solaris and Windows NT/2000 servers, including iPlanet application/web servers (test and production)

·  Provided rotating, third-level on-call production support; supported over 1,000 users across the US; proactively monitored systems to ensure maximum uptime


marchFIRST – Charlotte, North Carolina April 2000 – June 2001

Senior Technical Consultant

·  Served as Application Server Engineer/Oracle Database Administrator for multiple client development teams on Sun Solaris and Windows NT servers

·  Installed and configured Java applications on Solaris and Windows NT/2000 platforms; wrote batch files and shell scripts; installed WebLogic web servers

·  Frequently communicated concise, clearly written/verbal project status to both technical and business partners

Bank of America – Charlotte, North Carolina September 1996 – April 2000

PeopleSoft Data Conversion Team Lead

·  Responsible for analyzing, mapping and converting data from legacy Personnel/Payroll systems to PeopleSoft HRMS and Oracle databases

·  Promoted to Team Lead position; lead team of six programmers

·  Designed, wrote and executed SQL/SQR custom data conversion scripts on HP UNIX

Price Waterhouse LLP – Charlotte, North Carolina September 1995 – September 1996

Technical Support Specialist

·  Provided technical support for all PC/LAN/WAN infrastructure including servers, laptop and desktop computers for five Southeast regional practices

·  Performed Novell server administration (disk space management, tape backups, upgrades)

·  Also provided Lotus Notes server administration and database application development

NationsBank – Charlotte, North Carolina September 1992 – September 1995

Programmer/Analyst

·  Designed, coded and implemented departmental Error-tracking database using Oracle database tools, Oracle SQL*Forms, and DCL procedures on UNIX servers

·  Designed and implemented departmental incentive program in Microsoft Access that tracked the performance and payouts of the department’s 200+ associates

Education and Training

Bachelor of Arts in Music Education (Choral conducting)

Wake Forest University – Winston-Salem, North Carolina

Activities and Interests

Served on the Wake Forest University Presidential Scholarship committee

American Field Service exchange student to France

Fluent in French; also studied Italian, German, and Latin

Enjoy road biking, mountain biking, snow skiing