Data Analyst Project Management
Resume:
Charles Bender
Dearborn Heights, MI
SUMMARY:
Senior Solution Consultant with 25+ years of experience in designing and managing complex database solutions. Skilled in client consultation and end-to-end project management to optimize processes and drive significant productivity savings. Successfully managed projects that improved data export efficiency and identified substantial discrepancies, saving $3M in resources.
TECHNICAL SKILLS:
Technical Proficiency: MS Access, VBA, SQL Database Tables, MS Office Suite, Office 365, MS SharePoint, SharePoint 2010 Custom Site Owner, Active Directory, Oracle eBusiness Suite R12, FulcrumWay (SafePaaS), SAP
Business & Management: KPI's, Project Management Fundamentals, Change Management,
Business Analysis
Consulting & Client Engagement: Solution Consulting, Client Management, Training Skills,
Attention to Details
EXPERIENCE:
FIS Management Services (FIS) 03/2019 – 06/2025
Client: Comerica Bank Database Developer
Designed, developed, managed, and maintained 89 MS Access databases, in compliance with mandated restrictions, for several departments, including HR, Internal Trust, and Personal Trust.
Assisted in migrating 280 MS Access databases from an End-of-Life on prem server to an AWS cloud environment.
Modified linked tables, and VBA code for Forms and Macros, where required.
Performed database testing and modified slow running processes from the cloud drive so they could first be processed locally then migrated back to the cloud when the database closed, thereby increasing the database performance manyfold.
Identified databases and data files remaining on two End-of-Life servers and provided reports for management to review.
Created a database to track migration from End-of-Life servers to an AWS cloud-based environment. Specific locations and difficulties were reported during testing and recorded. This data was provided to the Project Team for research and to improve performance issues.
Updated an out-of-date database used to perform an annual audit of all files on separate network drives in compliance with Comerica’s File Retention Policy. Tested and verified the new database functionality. The database deleted network files seven years or older (with specific folders and file exceptions excluded). Files three to five years old were Zipped and stored and then migrated to SharePoint locations so they could be referenced, as needed.
Kelly Services 08/2018 – 03/2019
Client: Comerica Bank (Temp to Hire Position) Database Developer
Designed, developed, managed, and maintained multiple MS Access databases, concurrently in compliance with mandated restrictions for multiple departments including HR, Internal Trust Services, and Personal Trust Services.
Designed an annual Tax Preparation database for the Tax Trust Department which reviewed imported file data, created detailed individual status reports then emailed them to their respective Account Managers and Assistant Account managers. This allowed monitoring of their accounts and what their processing statuses were for the Accounting Company that they were being processed through.
VisionIT – Contract Worker 04/2016 – 07/2018
Client: Meritor Oracle eBusiness Access Administrator
Managed day-to-day access provisioning (new user definition, access modifications, user termination) and access control governance activities (SOD and access rule definition and administration) in Oracle eBusiness Suite R12.
Executed daily access provisioning actions and maintained audit records for use in tracking requests, through all approvals and into Oracle production eBusiness Suite.
Executed periodic reports and data extracts to test provisioning in Oracle eBusiness Suite.
Executed SOX-related tests for Segregation of Duties (SOD), General and Critical Access Reviews, and audits, including compliance testing, conflict analysis, and mitigations.
Understood the structure of Oracle eBusiness Suite and how Responsibilities grant various levels of access and control.
Supported the implementation / use of FulcrumWay (SafePaaS) SOD compliance application.
Executed Oracle eBusiness Suite data extracts for SOD testing in SafePaaS.
Created and maintained documentation and user manuals for processes within applications.
Identified and reported inconsistencies between FulcrumWay/SafePaaS and Oracle eBusiness Suite environments, specific to the Access Monitor (provisioning/deprovisioning) and SOD Monitor/Role Manager processes.
Assisted in Oracle eBusiness Suite responsibility, functions, and rules configuration.
Coordinated and facilitated conference calls with individual users, managers, Functional Approvers, and Global Process Managers for round table discussions to support requested Oracle responsibilities.
Provided status reporting on the progress of work completion at agreed frequency.
VisionIT 03/2012 – 04/2016
IT Specialist
Single handedly provided hardware and software support for 250+ internal and remote users.
Managed Local Active Directory for user and group accounts and policies.
Network Backups – Reviewed, researched, and resolved issues for backup error messages. Restored data from backup files as needed using server shadow copy and Barracuda Backup online services.
SharePoint 2013 Global Admin – Designed, implemented, and maintained a SharePoint Intranet site used by 250+ team members in more than 50 offices worldwide. Created and presented MS Word and interactive PowerPoint training material for Users and Managers.
Developed and maintained multiple MS Access databases, concurrently in compliance with internal and external processes for multiple departments; HR and Finance, IT Support, Sales Effectiveness and Talent Management. Designed unique ad hoc VBA queries for reports as needed. MS Access databases were used as supporting material for ISO9000 certification. Designed KPI Reports showing Trouble Ticket "time-to-resolution" category groups, for management review. Created reports to understand trends and designed user training around specific types of issues.
Set up and configured a SQL Server for use with Bullhorn DataMart. Used APIs, provided by Bullhorn, to sync near real-time data with SQL Database tables. Recommended a -1 version of SQL Server software at $2.5K cost savings.
Independent Consultant 1997 – Present
Installed networks for Windows O/S Peer-to-Peer and Small Business Server/Client topologies.
Built, upgraded, diagnosed, and repaired hardware problems for personal computers, laptops and small client servers supporting 1 to 20 users.
Trained to repair Hewlett Packard LaserJet printers.
Provided User assistance with MS Office Professional 2003 through 2024 products.
Installed CAT-5e/6 (PVC and Plenum) wiring for patch panels, switches, printers, and workstation locations.
Provided detailed and in-depth step-by-step resolution support to customers.
Consulted with clients regarding equipment needs and purchases – Provided 24/7 support, as required.
United States Marine Corps 07/1977 – 07/1997
Honorable Discharge.
Computer mainframe supervisor and operator; PC repair supervisor and technician.
Inactive Secret DoD Clearance – Deactivated when position no longer required it.
EDUCATION:
Employee Training Courses – 2025
FIS Annual Refresher Course – Anti-Money Laundering and spotting possible money laundering instances.
SharePoint 2010 Custom Site Owner
Received certificate from New Horizons Computer Learning Center.
Project Management Fundamentals
Received certificate for course completion from Lynda.com.
Total Quality Leadership (TQL)
Attended introductory and intermediate level TQL classes.
Basic and Advanced Personnel Management Courses
Basic and Advanced studies in professionalism, integrity, and personnel management.
Class Standings: 2/23 and 4/30 respectively.
Contact this candidate