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 customers.•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 business requirements and processes. Understand project scope, project goals, product functionality, and desired features. Evaluate customer needs/issues, analyze business processes, assist in evaluating alternatives, and determine appropriate solutions with technical staff. Help determine level of effort and time required for delivery. Develop business requirements definition (BRD) from customer and user perspectives.•Designed process flow charts depicting complex systems and processes.•Leads others in the review, analysis and evaluation of business systems and user needs.•Ensure business requirements are properly documented, translated and satisfied in functional requirements and design.•Assist with system design and data conversion reviews as needed.•Create test documents and test plans and perform UAT and user training as needed.•Tools utilized: erWin, Affinium, Oracle, TOAD/SQL, Excel, Access, Visio, MS Office, UNIX

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 Pricing Project.Design and develop custom Unix shell and PL/SQL scripts to facilitate data migration from outside sources to internal Siebel application. Perform data analysis on resulting scripts and programs to ensure correctness of data.Develop and perform presentations to fellow developers and users on complex data processes.Supervises guides and provides analytic support and training to other analysts and assists the manager in the review and evaluation of the work of the staff, planning, organizing and controlling the activities of the section and in the development of the overall project plans and timetables.Tools utilized: Unix Shell Scripting, PL/SQL, Oracle, TOAD/SQL, Teradata, Query Man and Business Objects

•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 defining requirements and understanding future data/system needs. •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 best practices relative to analysis, testing, and implementation. Provide ad-hoc reporting, data gathering, and feasibility studies to support project business justification as required for management review. Suggest improvements or enhancements to processes and systems in order to increase customer satisfaction or improve productivity. •Tools utilized: Siebel escript/java script. Oracle, Crystal Reports, TOAD, Access VB. SQL and Siebel’s Enterprise Integration Manager

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 to identify critical information and how best to migrate it.•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 utilizing FoxPro, Access and PowerBuilder.

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, Filemaker Pro, FoxPro, DB2 and SQL.