Wayne Cunningham Email & Phone Number

Charlotte, North Carolina, Us

I am utilized as a Technical and Application Lead for technology applications within Truist. This support includes Data Warehouse Architecture, technical lead, technical management and a subject matter expert for multiple applications. I lead the maintenance of our address cleansing and house-holding processes within the bank and continue to be the primary lead for a revenue generating application that is a custom internal Sales Lead System.* For 2021, I have served as a SME in the entire redevelopment into StreamAnalytix of our Sales Lead System within the Truist ecosystem from SunTrust while maintaining current SunTrust marketing applications till end of life before our full merger into Truist bank. * In 2020, I lead a technical team to convert from IBM Detect to StreamAnalytix for our Sales Lead System. This includes the planning of user stories, coordination with our Scrum Master, technical requirements, data analysis, and development of our financial lead triggers. This project included coordinating server procurement and setup, reverse engineering of specific ACH triggers and the validation of all code changes.

Charlotte, Nc, Us

I serve as an Architect and Technical Lead for technology within the SunTrust Marketing Department. I primarily operate as a systems and application administrator. This support includes a Marketing Data Warehouse and management of multiple IBM applications: Campaign, Interact, Optimize and Detect. I lead the maintenance of our Trillium address cleansing and house-holding processes within the warehouse. I am the primary lead and execute development for a custom internal Sales Lead application that generates around $25 million annually. Last, I sustain Oracle databases, two intranet sites, and the support of our Windows and UNIX/Linux servers.• In 2017, I headed the effort to upgrade the Trillium application and providing multiple new ETL efforts to replace missing functionality from the software. We also converted from monthly to daily processing, driven by requirements for more effective marketing communications to new customers. The resulting data stream was integrated into our existing warehouse staging environment without changes to staging processes.• Headed the project management, technical analysis and requirements for migration of our four SAS Servers to the companies new SAS Grid implementation. This effort involved coordinating all code updates from our ETL staging environment, other application code changes, and organization of all parallel testing.• I serve as the technical lead on an automated Sales Lead Application within the bank. This revenue generating application converts financial behaviors into leads for cross-sales efforts and customer relationship management. In 2012, we re-architected this application to provide better maintenance and flexibility. • Worked on a large scale HP-UX to Linux Server Migration project and coordinated all marketing database and application migrations.• Altered partition and index methodologies within our marketing data warehouse producing lower latency reads for increased user query performance.

Charlotte, Nc, Us

Act as a database analyst supporting the implementation of ETL projects within our Marketing Information Warehouse. Exposure to various banking systems: FDR, ACAPS, Deposits, Online-Banking, ACH transactions, Credit Card, Rewards data, Student Loan and Installment Loan data.• Participated on the product launch of SunTrust credit cards and designed the data specifications for the new line of business within our warehouse which precipitated developing models and marketing campaigns after the initial launch of the product.• Served as the technical lead for the first quarter marketing campaign between SunTrust and Air Tran, accomplishing all technical deliveries for the project and a campaign with new deposits of $231 million.• Responsible for capturing and documenting data and business requirements, as well as, database analysis, transformations, mappings, and metadata documentation.• Developed and implemented the training of TOAD - Oracle to advance the skill sets of our clients and internal organization.

Performed the duties of Business Analyst, Developer and Quality Assurance for the Companies Vendor Negotiation System, a stream of data content for development by external call centers.• Curtailed manual testing from one day to full automation in less than an hour by creating the first automated scripts for nearly 100 regression tests using Winrunner around BellSouth’s external vendor ordering system. • Implemented Test Director within the development life-cycle for an on-going Sales and Compensation Application.• Conducted on-site coaching and quality assurance for newly launched products and application modules within many Tele-Sales Centers.

Functioned as a technical, subject matter expert, ETL Developer, Business Analyst, and Data Analyst for multiple projects within a Teradata and Oracle RDBMS environment. This support was within the companies Marketing Information Systems group to build data driven applications and solutions for the company.• Constructed the DotNet, Bellsouth Communication Systems, and long distance data marts and integrated them within our enterprise data mart. Some of these sources were utilized in the companies operational repair systems, direct sales initiatives and the successful corporate launch of BellSouth Long Distance.

• Doubled our service/data requests for the year 1999 and had a further 29% increase in 2000 which effectively transformed our group into a one-stop service shop for our client needs.• Increased the training of new users for multiple internal applications by a third and accomplished an 86% increase in usage rate after training versus 30% the prior year. • Introduced a new GIS product line for mapping analytics used to analyze on going company initiatives producing over 200 maps the first year.

Bachelor'S Degree, Art History

High School