Learn Data Skills
Beta
Gilbert Drummond

Gilbert Drummond

Certified

Consultant

Consultant Agency | Charlotte, NC

Technologies

My Portfolio Highlights

My New Course

Analyzing Data in Tableau

My New Course

Intermediate SQL

My New Course

Corporate Finance Fundamentals

My New Course

Analyzing Data in Tableau

Data gardener, nurturing insights to bloom and thrive in the data ecosystem.

My Work

Take a look at my latest work.

course

Intermediate SQL

course

Corporate Finance Fundamentals

course

Intermediate SQL

My Certifications

These are the industry credentials that I’ve earned.

AI Fundamentals

AI Fundamentals

Data Literacy

Data Literacy

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Introduction to R
Understanding Cloud Computing

My Work Experience

Where I've interned and worked during my career.

Wells Fargo | May 2024 - Aug 2024

Business Execution Consultant

• Led research and data validation efforts for daily trading risk and P&L reports, ensuring data integrity and accuracy. • Managed UAT testing for system upgrades, analyzing production vs. test environment datasets and reporting discrepancies. • Developed Excel macros to automate data reconciliation processes, reducing manual errors and improving efficiency, improving reporting time and data accuracy by 25%.
Show More

Municipal Credit Union | Sep 2022 - Jan 2024

Senior IT Operations Analyst

Created various dashboards and reports to build library of models and reusable knowledge-based assets which pull and combine metrics to produce consistent, streamlined business intelligence results; leading to increased ATM uptime and availability. Collected and analyzed data on customer demographics, preferences, and buying habits to identify potential markets and factors affecting product demand which allowed upper management to make decisions on where to allocate limited resources. Reviewed historical records, current operational data and forecasting information to identify and capitalize on system enhancement opportunities; synthesized current business data to produce reports and polished presentations, highlighting findings and recommendations.

Municipal Credit Union | Feb 2021 - Sep 2022

IT Operations Analyst

Contributed to development, implementation and execution of maintenance programs. Monitored multiple priorities and liaised between maintenance team and management, delegating tasks to ensure timely completion. Shrunk knowledge gaps with ongoing training and close employee mentoring for new and less experienced team members; quickly learned adopted new technical skills and applied them to daily tasks while improving efficiency and productivity. Identified cost savings and reduced expenditures by effectively negotiating vendor and service contracts, leading to over $1M in annual savings.

Bank Leumi USA | May 2020 - Feb 2021

Junior Project Manager

Worked as part of a team to create and execute automated software test plans, cases and scripts to uncover, identify and document software problems and their causes for varies systems including CounselLink and Image Centre. Recommended, developed and reviewed procedures for all functions involved with or related to the CounselLink software. Verified historical records for completeness and accuracy. Documented software defects using bug tracking system and reported defects involving program functionality, output, online screen and content to software developers. Demonstrated methodical, detail-oriented and thorough approach to all assignments while adhering to compressed timelines. Complete all assignments on or ahead of schedule.

Bank Leumi USA | Dec 2019 - May 2020

Quality Assurance Analyst

Worked as part of a team responsible for coordinating and performing System Integration, Functional and Data-related testing. Led weekly UAT recap meetings with various business groups, took ownership of gathering and communicating any test results/feedback. Interacted with developers and Users/Client to discuss functionality changes of the Products and review the Change Requests. Involved in validation of different modules such as Wires, ACH, Loan Payments, Changing Passwords, etc.. Validated and executed hundreds of Test Cases in different two environments (User, Back-End) and logged the defects in a Sharepoint drive folder. Escalated high-priority defects to system developer to ensure quick fixes.

Municipal Credit Union | Feb 2017 - Aug 2019

Operations Analyst

Served as a liaison between IT Operators and ATM service vendors to resolve ATM software and hardware issues while ensuring that all ATMs are operational and in compliance. Accessed ATMs remotely to rectify issues when possible. Grew the ATM Fleet by analyzing service areas, purchasing and overseeing the installation of ATMs at 30 new locations.Conducted user testing on ATMs to ensure proper functionality for existing and new products. Verified the accuracy of and recognized discrepancies on all ATM vendor bills and invoices, and ensured that payments are completed before or by all deadlines. Spearheaded various key initiatives (New ATM testing and deployment, ATM windows conversion, ATM alarm installation, etc..) to improve performance or streamline operational processes in the ATM Fleet. Handled, prioritized, and problem-solved multiple tasks connected to multiple projects at one time using Microsoft Project. Conducted user testing on ATMs to ensure proper functionality for existing and new products. Overhauled the cash management system by creating an excel sheet of the residual reports for each ATM to forecast usage and adequately prepare the ATMs for members' upcoming activity. Maintained meticulous records of ATM contracts and ensured license agreement fees are remunerated in a timely manner. Worked to provide strategic, operational, and fiscal leadership while working to reach the company’s long-term goals and maintain organizational vision. Performed tasks central to project progress, including scheduling, budgeting and accounting, and resource management.

Bank of America | Feb 2015 - Sep 2016

Client Service Representative

Assisted in lobby management and increased customer engagement 15% by scheduling and following up on customer appointments, reduced customer traffic in the bank by demonstrating and migrating customers to convenient banking options, while informing customers of new banking products to meet their financial needs. Processed 25+ customer transactions per hour with extreme attention to detail while delivering superior customer service, fostering strong rapport, retention and satisfaction, and adhering to BSA/AML guidelines. Processed standard teller transactions for customers including servicing client accounts, accepting loan payments, cashing checks, balancing cash drawers, handling night deposits, balancing ATMs often totaling more than $150,000 and correcting discrepancies. Assisted management with the training of 4 new tellers ensuring that they received a comprehensive education on proper banking policies. Assisted the supervisor with audits and daily balancing of the vault which exceeded $500,000. Assumed a leadership role in the absence of the supervisor and maintained bank’s normal operations and procedures. Managed my personal goals aside from the company’s goal, for example, 5 new customer referrals and 10 migrations per day. Conducted due diligence and thorough verification of all relevant documents which effectively prevented possible losses by negotiating forged and counterfeit documents.

My Education

Take a look at my formal education

High School Diploma Oak Ridge Military Academy | 2010

About Me

Gilbert Drummond

Strategic and detail-oriented BA with expertise in data analysis, research methodologies, and project execution. Adept at leading data-driven research projects, optimizing workflows, and ensuring the successful implementation of BI solutions

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free