Dwayne Bates Email & Phone Number

Columbia, South Carolina, United States

• Collaborates with the mortgage division's leadership team to create a strategic roadmap and implementation plan for meeting Community Reinvestment Act (CRA) and Community Benefits Plan goals.• Builds partnerships across the Mortgage and Community Development teams to identify and fill gaps in the product portfolio related to community development lending.• Serves as the program owner of data management, reporting and analytics in accordance with the Home Mortgage Disclosure Act (HMDA), CRA, and Federal Financial Institution Examination Council (FFIEC) requirements.• Monitors all aspects of Mortgage and Community Development Finance’s reporting for a 5-year $16.9B Community Benefits Plan.• Hires and trains data analysts to ensure timely and accurate reporting in alignment with established service level agreements (SLA).• Implements comprehensive engagement plans with community non-profit organizations and internal business line leaders to drive collaboration and generate CRA business referrals that directly impact the bank's CRA performance.• Advocates for key strategic partners such as local and regional community organizations focused on affordable housing, economic development, workforce development, small business support, and financial empowerment.• Establishes strong outreach plans by engaging key external community partners and senior executives leveraging new and existing networks.• Analyzes comprehensive CRA market performance data, using results to develop strategic initiatives to drive CRA performance.• Identifies, coordinates, and implements volunteer activities in the local community that increase CRA qualified service hours.

Columbia, South Carolina Metropolitan Area

• Responsible for delivering Executive dashboards end to end with actionable insights• Responsible for engaging Executives to gather requirements and use agile methodology to deliver dashboards• Conduct deep analysis to discover actionable business insights to grow the Mortgage Division’s bottom line. • Act as a Coach/Mentor for other Enterprise BI developers and influence Visualization best practices• Develop Customer and product analytics to support Quarterly Business Reviews (QBRs), executive briefings, and other executive-level business reviews. • Lead the vision, execution, and roadmap for data visualization for the Mortgage Division• Determine system requirements and communicate them through specifications, reports, project plans, or other forms of documentation. • Manage the launch of data products through training material development, training sessions, and ongoing support for business units.• Identify patterns, problems, and areas of improvement in the mortgage pipeline.

Lexington, South Carolina

• Involved in Tableau Server Installation, Configuration, Creating Users, Groups, Projects and Assign Privileges etc.• Worked on Data Model design (SSAS), Data Extraction, Transformations and Loading (SSIS), Mappings Workflows, Customized Analytics Reports.• Played a key role in the evaluation/comparison/selection of modern BI tools such as PowerBI, Tableau, Qlik.• Participated in the architecture and design of features associated with Collaboration and Scaling of Tableau across the business.• Created Dashboards to allow the users to dynamically interact with the data to the lowest level of granularity.• Created customized training for power users to increase our ROI and adoption of Tableau across the enterprise• Responsible for Tableau Server Admin functions of installation, configuration, performance tuning, sizing, license management, change control management, backups and upgrades. • Provided 24/7-production support for Tableau users.

Cayce, Sc

• Works with a team of professionals who liaise between IST and the business. The team is responsible for large technology implementations involving packaged vendor solutions as well as internally developed systems.• Responsible for gathering project requirements, reviewing project scope of work, setting goals and timelines for projects.• Interacts with business managers, business analysts, business users, database architects and other key personnel to develop and review project priorities, set expectations for projects, and provide status updates on progress.• Assists with multi-year projects related to measuring key performance indicators, setting base-line performance standards, and identifying process improvements and/or business related activities that affect the performance.• Produces Crystal Reports, Web Intelligence (WebI) reports, Business Objects Universes, and Excel spreadsheets created via SQL statements from report requirements identified through the requirements gathering process, recorded and updated in technical documents, and tested with thorough User Acceptance Testing (UAT) in order to provide managers with accurate, vital, and timely business information.• Reviewed, prioritized and resolved defects related to reports and documents during User Acceptance Testing. • Provide tools related technical coaching to business end users to ensure smooth transition.

Blythewood, Sc

• Worked with team of developers to design applications and analyzed user specifications for workability, completeness and business flow.• Participated in defining System Design, Architecture and Specifications and performed project and task estimation• Assisted with requirements gathering (business and technical) for insurance software customizations and enhancements.• Designed Web pages with ASP.NET, Javascript, XML, XSL.• Coded Business logic in C#, VB.NET using Visual Studio 2008/2010.• Worked extensively with SQL Server 2008 where I designed tables, and wrote Queries, wrote/revised complex Stored Procedures and utilized SQL Profiler for troubleshooting. • Performed Coding/Programming tasks to specification and in accordance with Development standards• Documented technical artifacts • Performed unit testing and code reviews for team members• Performed source control using Subversion (SVN) • Worked with Business Analysts to perform requirements gathering and put together business requirements for technical staff.

Charlotte, Nc

• Developed Transformer Gas Analyzer application using VB.NET that is used to monitor gases emitted from transformers.• Assisted with the modification of Hydro Bailer application (VB.NET) used to process data for Fossil Hydro.• Assisted in the deployment of Analysis Framework which is used to change the overall Plant Information System so that it evolves from a server-centric approach to a more company- or enterprise-wide approach. • Plan, test, and implement various Web-based applications using ASP.NET and C#• Worked with Midwest/Southeast regions in requirements gathering so that I could upgrade old VB.NET applications to C#• Assisted in developing custom Web parts for application support and field engineers. • Performed source control using Visual Source Safe (VSS)• Managed and upgraded Citrix server environment. Assisted with publishing new applications for support team and business counterparts. • Participated in vendor training for third party/vendor applications. • Assisted with application integration and knowledge transfer within team• Routinely troubleshoot issues, and assisted with coding enhancements to multi-tiered third party applications for internal users.• Participated in enterprise-wide Windows Server Consolidation Project in which I assisted with server migrations, virtualizations (VMware, Hyper-v), and decommissions. • Worked extensively with SQL Server 2008 and Visual Studio 2010 in .NET 4.0.