MT odd Smith Resume by IeQib8


									M. TODD SMITH
123 Burris Court, Thomasville, NC 27360

Results driven, detail oriented Information Systems professional with 17 years of technical,
business, and reporting analyst skills including data analysis, database development and
programming, process improvements, automation, training, and documentation. 12 years of
Accounts Receivables and Customer Service experience, 6 years of Payroll and Benefits
experience, and 3 years of Wealth Management and Private Banking lines of business
reporting. Highly adaptable and able to assume any project, operational, or leadership role.

   VB/VBA/VBScript                                    MS Access
   SQL Server                                         MS Excel
   MS Visio                                           MS Project
   MS PowerPoint                                      MS Word
   MercuryQualityCenter                               AS-400 Mainframe
   Adobe Photoshop

Business Systems Consultant
Wells Fargo - Winston-Salem, NC (Feb 2011 – current)
 Increased productivity with process improvements via automation using VBA and
   VBScripts in both MS Access and MS Excel applications
 Developed automated solutions for Operations team within Technology Asset Management
   for importing, processing, and extracting server data
 Created automation tool within MS Access database using extensive front end user forms
   connected to SQL Server database tables on the back end
 SQL Server experience with creating tables and views, in addition to writing stored
   procedures, and refreshing links to tables within MS Access databases

Quality/Data Analyst
Republic Mortgage Insurance Co (RMIC) - Winston-Salem, NC (Sep 2010 – Dec 2010)
 Created and executed test cases and logged defects using Mercury Quality Center v9.0
 Created and mapped data requirements to create test plans and cases
 Utilized waterfall methodologies during regression test cases
 Write SQL queries for data validation when completing test cases
 Performed UAT functional interface testing using Microsoft Dynamics CRM application
Technical Data Analyst
Transamerica Reinsurance - Charlotte, NC (Apr 2010 – Aug 2010)
 Automated data import/data export of files via Access databases using VBA code
 Migrated multiple Access databases into SQL Server databases
 Responsible for data integrity, validation, profiling, as well as data manipulation
 Wrote detailed technical documentation on all databases and functional procedures for
   cross training purposes

Senior Reporting/Business Analyst
Wachovia - Winston-Salem, NC (Mar 2007 – Mar 2010)
 Developed, designed, and produced weekly and monthly reporting for Wealth Management
  and Private Banking lines of business
 Created reports from data tabs using pivot tables within MS Excel
 Acted as liaison with other departments to obtain special data requirements
 Evaluated Visio workflows and alternative data source ideas to be used and discussed with
  other team members in line with Change Management process
 Partnered with Quality Assurance Department to identify trends within quality reviews for
  training opportunities
 Documented all reporting processes for cross training purposes

Technical Business Analyst
Pepsi Bottling Group - Winston-Salem, NC (Feb 1994 – Mar 2007)
 Validated technical designs against functional specifications provided by members of A/R
   Leadership via Joint Application Development (JAD) sessions
 Conducted conference calls and led meetings with Subject Matter Experts (SME) to gather
   information regarding system enhancements and improvements
 Assisted Team Leads in developing Business Requirement Documents (BRD) and Visio
   workflows to submit to IT and Developers while managing different phases of
   implementation schedule and final sign-off from senior members of management
 Increased productivity with process improvements via automation using VBA scripts in both
   MS Access and MS Excel applications
 Documented all system changes and request for user access using Change Management
 SQL Server experience with creating tables and views, in addition to writing stored
 Wrote curriculum materials for Access database training and taught multiple classes within
   all departments of A/R

Completed 61 credit hours towards Information Systems degree at Forsyth Technical College
located in Winston-Salem, NC. Looking to transfer credits to Strayer University online to
complete degree beginning August 2011.

SQL PASS Summit – 2003
Access/VB/SQL Advisor Live – 2004
Effective Project Management – 2005

To top