John Samson Email & Phone Number

Become subject matter expert in outside vendor internet systems and applications.Data mine vendor systems and incorporate data into Informix system.Assist in redesign of in house legacy Informix system screens.Migrate system critical data from Informix to SQL Server.

• Support Wachovia’s line of business and business units, as Business Analyst and Data Analyst, with understanding database as it relates to their business needs and also supporting their subsequent technical needs.
• Perform SAS/SQL code reviews for Wachovia team members for correctness and accuracy.
• Utilizing Affinium/Campaign tools, business analysis and flowcharts: create, test and support campaigns for major insurance and financial institutions for use in maintaining customer base and for attracting new.
• Provide business expertise, guidance and training during implementation and deployment as needed.
• Work with business units, operations, and other stakeholders to gather information utilizing a variety of techniques such as interviews, work sessions, storyboarding, and prototyping. Analyze, document, and communicate.
• Designed process flow charts depicting complex systems and processes.

Production support, problem and incident management for Tactical Pricing Project that allowed senior negotiators the ability to facilitate best pricing policies to meet competitive needs. Completed two Business Objects courses.Provide user support to user groups in Teradata data warehouse environment.Performed UAT exercises with user base for Tactical.

• Sole developer in charge of data analysis and conversion from 10 year old legacy system into Oracle utilizing FoxPro, Access and Oracle stored procedures. This effort was made possible with interaction with user base.
• Designed, developed, tested and implemented major enhancements and customization to Siebel application using Siebel escript and java script and Crystal Reports.
• Provide ongoing production support and incident management for CRM application including bug fixes, troubleshooting, testing and training.
• Optimize nightly download process improving efficiency by 33% by rewriting key component utilizing FoxPro and Unix Shell Scripts
• Assist with development of test conditions, scripts, and test cases. Participate in testing reviews and analysis of testing results. Assist with troubleshooting and providing recommendations.
• Effectively partner with business unit, operations, and IT personnel to deliver solutions. Resolve issues quickly and effectively to enable delivery and support of applications. Follow standard software development.

Maintained existing applications while designing/developing new applications to support Mutual Fund, Compliance Legal and various other departments using PowerBuilder and Sybase System 11.Converted more than 200 Infomaker reports and integrated new enterprise applications.

• Database analysis and conversion from FoxPro to Microsoft SQL Server for legacy re-write using PowerBuilder tunnels. System used for inventory/repossession tracking. Worked closely with line of business representatives.
• Solely responsible for maintaining existing and designing/developing new reporting interfaces to supplement a major Business Loan Development Center using PowerBuilder.
• Maintained relations with seven customer groups and supported their needs through above-mentioned design and development. Also utilized requirements gathering, UAT and interviews.
• Designed, developed, tested, and implemented PowerBuilder application to re-write the legacy PC based system for Bank of America Mortgage group.
• Created the interface between the PowerBuilder application and mainframe applications.

Conducted multiple regression analysis and demographic study to predict buying patterns for major New York bank using Excel, FoxPro and Access. Allowed for more efficient use of resources and higher success level during campaign.Analyzed both internal and external clients' processing needs, identifying areas of improvement and designing technical solutions.

Programmed, unit tested and implemented a Free Trade Zone inventory tracking system utilizing Visual Basic and Oracle.Programmed, unit tested, implemented and supported an Inventory Tracking/Forecasting system utilizing FoxPro, Excel, MSGraph and Access.

Redesign of 25 critical CICS systems over five-year project. Screen design, functionality and testing.Developed and prepared monthly Executive Summary Report for two divisions used by senior management. Report accounted for $650 million in labor and material resources with associated variance and trend analysis.Tools utilized: mainframe tools, Access.