William Traylor Email and Phone Number

• Investigate a variety of code, network, configuration or database issues related to systems/applications which are currently being utilized by the end users.• Design C# and VB code using Visual Studio 2010 for Ista|Net, a CRM application.• Use Microsoft SQL Server Management Studio in conjunction with a thorough understanding of T-SQL to build complex scripts and design/alter database objects (tables, stored procedures, triggers, synonyms, etc).• Resolve printing issues that arise and provide subject matter expertise to anyone with issues or questions concerning the invoicing and printing process.• Make invoice/letter layout changes using the latest versions of Active Reports and Crystal Reports.• Maintain/Upgrade a correspondence delivery system responsible for processing and delivering thousands of invoices and letters on a daily basis.

• Monitoring and troubleshooting of application processes and system resources to ensure compliance with system performance KPIs.• Monitor error log(s), user activity and resource utilization of production environment. • Write VB scripts to monitor system applications & processes.• Write SQL statements for reporting and general troubleshooting.• Perform post-QA, pre-production testing on patches or new releases of application software.

• Maintain and monitor all Collection production jobs in a CIS to ensure proper collection activity and report generation.• Write PL/SQL code on an Oracle platform to automate correction of multiple problem accounts that have been affected by production issues.• Perform UNIX functions at command level including writing Korn Shell scripts to automate manual production processes to improve efficiency. Also use Korn Shell scripting to wrap around SQL and PL/SQL to produce reports needed by production teams and business partners.

• Provided analytic and diagnostic services to meet the requirements of the client.• Developed solutions to assigned defects that meet the requestor’s requirements and fit within the client’s business rules using PL/SQL• Modified stored procedures as needed to correct defects in code or to generate a modified result based on new requirements.