DERRYL L. LAWRENCE
Sanford, North Carolina 27332
Phone: 919-***-****
E-Mail: ********@*****.***
HIGHLIGHTS OF QUALIFICATIONS
Experienced Information Technology professional, with experience in all phases of the Software Development Cycle. Extensive experience developing client/server applications using GUI tools and relational databases.
TECHNICAL SKILLS AND TRAINING
Computer Languages: Visual Basic4.0, SQL, C, C#, XML, COBOL, JavaScript,
Java
Databases: ORACLE8i, Sybase11, Sybase12, Microsoft SQL 6.5, SQL Anywhere
Operating Systems: UNIX, JCL, VAX, Novell Network, Windows NT
PC Hardware: NCR 3300, NEXT, SUN, Macintosh, IBM PS/2, Gateway
PC Software: PowerBuilder5.0, PowerBuilder(6.5, 7.0, & 8.0, 10, 11.5), Cold Fusion,
ASP, ASP.NET, Visual Studio
WORK EXPERIENCE
Bank of America, Charlotte, NC 2020-2022
Senior Support Analyst (TCS Consultant)
Migrated the CSP PowerBuilder system from RTC to Bitbucket for version control.
Maintained the functionality and system capability for the CLAS System using C#,
DB2, Splunk, REST and Bitbucket for version control.
Maintained the functionality and system capability for the SIPH System using
Web Methods, SOAP, Java, MQ Series, DB2, UNIX and Bitbucket for version control.
Researched systems problems to find root causes and develop solutions.
Worked with other team members and other groups to triage very difficult problems to develop solutions.
Bank of America, Charlotte, NC 2019-2020
Senior Support Analyst (Collabera Consultant)
Maintained the functionality and system capability for the PTS (Personal Transaction
System} using Oracle, Informatica, Splunk, Remedy, Unix, and Java.
The transactions include both online and mobile
The transactions also include internal transactions within Bank of America and transactions between
Financial institutions using Zelle
Monitored the JVM and MQ series jobs and servers using AppDyamics, Appwatch, and Sitescope.
Researched systems problems to find root causes and develop solutions.
Mentored new team members.
Duke Energy, Raleigh, NC 2012-2018 Senior Programmer/ Analyst
Design, develop, and maintain the functionality and system capability for the PowerPlan
using PowerBuilder (11.0), and Oracle11g.
Update stored procedures, functions, triggers and tables on the Oracle database.
Performed tuning and developed schema for the Oracle database.
Used Picasso for keeping record of changes made for PowerPlan
Maintained Batch jobs for PowerPlan using ESP and Informatica
Extensive documentation of modifications made to the PowerPlan system.
Maintain Open Pages using C sharp.
Use SharePoint to maintain documentation.
Supporting security system for the Progress Energy website using SOAP, Java, Site Manager and Identity Manager.
Used Agile development techniques.
Used Citrix to execute applications.
Maintained Java applications Regsmart and UI Planner using also LINUX and ESP.
Co-ordinated members of different department in order to implement changes and fixes to the applications supported by me.
Wells Fargo, Charlotte, NC 2011-2012
Senior Programmer/ Analyst (Consultant)
Design, develop, and maintain the functionality and system capability for the YOM system
using PowerBuilder (10.5), and Oracle10g.
Create and update stored procedures, functions, triggers and tables on the Oracle database.
Performed tuning and developed schema for the Oracle database.
Unit, System, And Regression test on added functionality to the YOM system.
Extensive documentation of modifications made to the YOM system.
Maintain Java interface.
Use SharePoint to maintain documentation.
Torrential Data Inc., Virginia Beach, VA 2008-2010
Senior Programmer/ Analyst (Consultant)
Design, develop, and maintain the functionality and system capability for the Delta Seven system
using PowerBuilder (8 and 11.5), C#, Visual Studio.net (2005 and 2008) and Informix.
Create and update stored procedures, functions, and tables on the Informix database.
Unit, System, And Regression test on added functionality to the Delta Seven system.
Extensive documentation of modifications made to the Delta Seven system.
Vanguard, Charlotte, NC 2007-2008
Senior Programmer/ Analyst (Consultant)
Designed, developed, and maintained the functionality and system capability for the Beacon system
using PowerBuilder 10.5, Visual C++,Unix Shell Scripting, Java and Sybase 12.
Created and updated stored procedures, functions and tables on the Sybase database.
Unit, System, And Regression test on added functionality to the Beacon system.
Extensive documentation of modifications made to the Beacon system.
BB&T, Raleigh, NC 2005 - 2006
Senior Programmer/ Analyst (Consultant)
Designed, developed, and maintained the functionality and system capability for the Proactiv system
using PowerBuilder 9 and Oracle9i.
Created and updated stored procedures, functions and tables on the Oracle database.
Unit, System, And Regression test on added functionality to the Proactiv system.
Extensive documentation of modifications made to the Proactiv system.
Division of Social Service, Richmond, Va. 2004 - 2005
Senior Programmer/ Analyst (Consultant)
Designed, developed, and maintained the functionality and system capability for the Oasis system
using PowerBuilder (8,10) and Oracle9i.
Created and updated stored procedures, functions and tables on the Oracle database.
Unit, System, And Regression test on added functionality to the Oasis system.
Extensive documentation of modifications made to the Oasis system.
Received training in Java.
Helped in the creation of development standards for migration to the web.
Bank of America, Charlotte, NC 2004-2004
Senior Programmer/ Analyst (Consultant)
Designed, developed, and maintained the functionality and system capability for the Insight Cost Allocation
System using PowerBuilder (7.0) and Oracle.
Created and updated stored procedures and tables on the Oracle database.
QA tested Insight Cost Allocation System to make sure customer specifications were met.
Answer PowerBuilder questions for the fellow developers.
Rail Inc, Cary, NC 2002-2003
Senior Programmer/ Analyst (Consultant)
Created re-engineering documentation for converting the INFO PowerBuilder(7.0) application to the Command web application.
Converted MS SQL stored procedures of INFO to Oracle PL/SQL stored procedures for Command
Created reports for the Command project using Style Report Designer, Java and XML.
QA tested Command web application to make sure customer specifications were met.
Answer PowerBuilder questions for the Java developers.
Wachovia Securities, Charlotte, NC 2001-2002
Senior Programmer/ Analyst (Consultant)
Designed, developed, and maintained the functionality and system capability for Reporting system using PowerBuilder(6.5, 8.0) and Sybase.
Gathered requirements to produce the functionality for the Restricted Positions application.
Created web pages for the Restricted Positions application using Cold Fusion4.5,
JavaScript, Sybase and Fusebox as the framework.
Created and update stored procedures and tables on the Sybase database.
Created Crystal reports for the Cold fusion application.
Created documentation for our users to use the Reporting system.
Received training in Active Server Pages and Advance Active Server Pages.
Received training in Java.
Write system specifications and test specifications for Restricted Positions application.
QA tested Restricted Positions application to make sure customer specifications were met.
EDUCATION
HAMPTON UNIVERSITY, Hampton, Virginia
Bachelor of Science Degree, Cum Laude
Computer Science