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.

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

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

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.
• 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.
• 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.
• Reviewed, prioritized and resolved defects related to reports and documents during User Acceptance Testing.

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.

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.