Business Analyst Systems

Jeff Mercer

Business Analyst

ad5ehe@r.postjobfree.com ● 305-***-****

LinkedIn ● Sugar Grove, NC, 28679, US

Highly analytical and detail-oriented professional with extensive experience in business systems consulting specializing in system development, metadata management, data governance, and system integration.

Adept at managing and enhancing business processes through technology solutions. Expert in utilizing various tools for data mining, modeling, and management. Innovative in streamlining operations, increasing efficiency, and ensuring continuity and operational excellence. Proficient in Agile methodologies, consistently contributing to improved project delivery through meticulous sprint planning and execution. Skilled in leading and managing cross-functional teams and driving technology solutions in alignment with business objectives. Committed to professional development, continually seeking opportunities to boost business analytics skills and knowledge.

Areas of Expertise

Business Intelligence Analysis

Agile & Scrum Methodologies

Stakeholder Engagement

Technical Documentation & Training

Data Governance Frameworks

Data Quality Assurance

Business Process Automation

Time Management & Scheduling

User Experience Enhancement

Business Continuity Planning

Team Leadership & Development

Strategic Planning & Implementation

Professional Experience

Career Break

2021 – 2024

Devoted time to address family needs during the global COVID-19 pandemic, demonstrating strong family values and crisis management skills. Engaged in a year-long world tour to explore diverse cultures and global business practices as well as enhance personal resilience, adaptability, and global perspective.

Wells Fargo, Enterprise Metadata – Charlotte, NC

Business Systems Consultant

2017 – 2021

Guided Data Stewards from various business units in integrating their business metadata into the Enterprise Metadata System. Utilized Collibra and Ab Initio for business glossaries, synonyms, terms, relationships, rules, custom types, taxonomies, and lineage. Employed Agile methodologies, participated in bi-weekly sprints, and contributed to sprint planning, daily standups, reviews, retrospectives, and creation of sprint artifacts. Streamlined metadata onboarding through automation of discovery, ingestion, modeling, and mapping processes. Oversaw Service Level Agreements as coordinator between internal business lines and external service providers. Spearheaded Business Continuity Planning and Enterprise Disaster Recovery initiatives.

Notable Contributions/Accomplishments:

Improved metadata management capabilities by advancing bank's data governance framework.

Acquired expert-level proficiency in the Collibra metadata tool and contributed to a more robust data governance environment.

Streamlined onboarding process for business metadata and enhanced efficiency and accuracy in metadata management.

Automated key metadata management processes, resulting in increased operational efficiency and data quality.

Developed and maintained critical documentation and training materials aimed at empowering users and promoting widespread adoption of the metadata system.

Wells Fargo, Corporate Properties Group – Charlotte, NC

Business Systems Consultant

2007 – 2017

Enhanced and supported CRE Direct, while performing full lifecycle activities from project planning through deployment and maintenance. Spearheaded Wachovia/Wells Fargo merger data migration to ensure seamless integration of property and lease information into the SAP real estate application. Developed a mobile solution for Property Managers and enabled efficient data and photo capture on Blackberry devices for direct upload to CRE Direct. Crafted a .Net application for Project Manager Dashboard with keen focus on improving daily task management and interfacing with SAP Real Estate application. Led Business Continuity Planning and served as Enterprise Disaster Recovery Lead. Directed migration of CPG documents to a new SharePoint site and enhanced document accessibility and collaboration. Provided ad-hoc reporting support and created user guides, facilitating end-user training for CRE Direct and SAP.

Notable Contributions/Accomplishments:

Automated lease-related processes and document handling by engineering front-end .Net application for Lease Document Storage and Workflow Management

Streamlined branch data collection and enhanced real-time reporting capabilities through Property Manager Mobility Project implementation.

Constructed a Project Manager Dashboard application, yielding significant efficiency gains for project managers and saving company substantial costs.

Conducted rigorous helpdesk and production support and ensured consistent system performance and user satisfaction.

Additional Experience

Business Systems Consultant Bank of America, Credit Card Services – Charlotte, NC, 2003 – 2007

Led data migration of legacy consumer credit card information during Bank of America's acquisition of MBNA and merger with Fleet Boston.

Devised a binary logistical regression model to predict credit card customer defaults, focusing on FICO scores as the key indicator.

Spearheaded a Six Sigma Greenbelt Project, targeting current DDA customers by analyzing transaction data from upscale merchants to promote premium credit card offerings.

Utilized SAS and SQL extensively for reporting and modeling requirements in data mining projects.

Technical Analyst Bank of America, Customer Knowledge & Decision Support – Charlotte, NC, 1998 – 2003

Innovated process applications for branch domiciling, identifying marketing customer groups, and analyzing customer profitability.

Managed and sustained Dun & Bradstreet business demographic data in the corporate data warehouse ("The W" - Teradata) for small business demographics management.

Executed RFP process for procuring business demographic data, engaging companies such as Dun & Bradstreet, Experian, Donnelley, and Fair Isaac.

Oversaw the loading and upkeep of Harte Hanks and Harland Clarke customer data for effective customer demographics management.

Contributed to the Y2K project by providing coding (COBOL, JCL), analytical, and testing support to address the necessary changes for the Y2K event.

Acted as a Business Analyst during the NationsBank/Bank of America acquisition, while facilitating migration of legacy NationsBank data and applications to Bank of America systems.

Education

B.S.B.A., Computer Information Systems Appalachian State University – Boone, NC

B.S.B.A., Production & Operations Management Appalachian State University – Boone, NC

Certification

Six Sigma Certification (Greenbelt)

Technical Proficiencies

Collibra (Business Metadata) Ab Initio (Technical Metadata) SAP SQL/Data Mining Data Modelling Unix Shell Scripting MS Office Visio Data Warehousing (Teradata, DB2, Oracle, MS Access JIRA

Contact this candidate