Business Systems Consultant

Mary Jane Garcia

San Leandro, CA ***** 510-***-**** ***********@*****.*** www.linkedin.com/in/maryjane-garcia/

Applications Support Engineer

Business Systems Consultant with extensive experience in business systems analysis, leading complex technical initiatives, troubleshooting both production and non-production issues, and performing in-depth root cause analysis. Proven track record as a technical project lead on major application projects and technical refreshes, ensuring seamless execution and system optimization. Skilled in proactive problem-solving and process enhancement, with hands-on expertise in application deployments, validation, and the remediation of vulnerabilities on Linux and Windows platforms. Regularly collaborates with internal lines of business, cross-functional technology teams, and external vendors to ensure smooth operations and successful project outcomes. Highly organized, reliable, and a resourceful team player known for consistently delivering high-performance results. Dedicated to exceeding expectations with a strong commitment to providing exceptional support and service, driving business success through efficient system management.

TECHNICAL SKILLS

Platforms: Microsoft Windows Server LINUX/UNIX Active Directory Microsoft SQL Server Microsoft Windows Server Update Services Cloud Management Portal (CMP) Venafi Certificate Management database Connect Direct Data Transmission Moxy Trading system Java Tomcat

Database Tools: Advance Query Tools for DB2 Microsoft SQL Server Management Server Studio Active Directory MongoDB

Methodologies: Agile Udeploy PDTool

Project Management: Kanban Board JIRA Confluence SharePoint

Monitoring Tools: Splunk AppDynamics

Utilities: J Meter utility SQL Queries ODBC Symantec Protection Engine (Anti-Virus scan) Qualys Enterprise monitoring Netbackup Avamar backup Tanium scanning tool

Change Management: ServiceNow Change Management Records Pac2000 change management tools

Business Continuity: Cutover Event Tracker

Productivity Tools: Microsoft Office Suite (Word, Excel, Outlook, Project, PowerPoint) Visio SharePoint Services Microsoft Access Notepad ++ Ultra Edit Ultra Compare Sumatra Acrobat Reader

SKILLS

Troubleshooting Data Analysis Solution Oriented Customer Service Research Documentation User Acceptance Test Window Server Migration and Configuration Software / Application Installations and Firewall Configurations Daily Backups and Restores Desktop Installations, Configurations, Upgrades, Deployments, Support Remote Server Management Streamlining Processes Production and BCP deployments Certificate management Patching

PROFESSIONAL EXPERIENCES

WELLS FARGO BANK, San Leandro, CA April 2000 – July 2024

Senior Infrastructure Engineer

Owned and drove technical initiatives, including technology build, remediation / vulnerabilities, servers technical refreshes, and divestiture of systems, applications, middle ware, and database in multiple environments.

• Enhanced customer satisfaction by ensuring trust statements were received accurately and on time. Subject matter expert for trust gateway statement processing for high end customers, complicated production application and server issues.

• Facilitated cost reduction and maximize system performance, managing and implementing server technical refreshes on all environments, and removal of the vendor application and migration to an in-house statement importer application. Collaborated with architecture, network, firewall, data transmission, and development teams. Updated run-books, documented new processes for production support, and led knowledge transfer sessions.

• Prevented data breaches, protected customer information ensured compliance with regulations, addressed vulnerabilities and remediated potential security issues proactively by performing thorough testing and validation. Conducted Windows security patching, hardware driver updates, and software updates.

• Enabled continuous processing ability by managing all trust certificates using the Venafi Certificate Management database. Created device, application, and certificate objects for automatic provisioning, renewal, installation, validation, and revocation.

• Minimized cost of business interruptions and assured customers that the bank is capable of weathering disruption, by initiating and leading annual Business Continuity Planning (BCP) simulation events. Oversaw fail over and fallback processes, coordinating testing/validation, created change tickets, hosted game plan reviews, conducted simulation exercise events, and updated cutover, event tracker, JIRA tickets, SharePoint and confluence pages.

• Resolved problems, prevented future issue, eliminated outages, troubleshot production and non-prod issues, applied fixes on servers/applications, resolved network-related and software issues. Conducted root cause analysis on complex end-user and server problems.

• Ensured with corporate and security policies by researching, investigating, and remediating production and non-production technology issues.

• Increased productivity, integrated new technologies and improved customer satisfaction by implementing, production deployments for trust statement processing, Wealth Management Cisco Data Virtualization, Trust Fee Experience, Legal Survey, and Trust Middle Office Experience deployments using PD tool or Udeploy deployment utilities.

Business Systems Consultant

Liaison between the technical team and the portfolio managers, planning and directing the analysis of business problem to be solved with automated systems.

• Improved customer satisfaction by, consistently provided solutions exceeding client expectations, establishing structure and controls, and maintaining service levels. Planned, deployed, and delivered strategic solutions. Established technical and business visions and analyzed trade-offs with developers, architects, and business subject matter experts.

• Ensured applications met requirements, identifying and addressing issues early in development that saved time and money. Insured applications worked as expected prior to production implementation. Contributed in devising test plans/scripts, executed test plans/functional testing, user acceptance testing, and application validation.

• Reduced the cost of implementation by identifying and documenting system requirements, obtaining business specifications, improving business efficiency.

• Identified improved courses of actions and solve problems, conducting system and data analysis, compiling findings, and providing reports.

• Ensured smooth system implementation transitions, preventing issues and staying on budget, by managing, monitoring, and directing projects. Delivered support, training and procedures.

• Enabled knowledge sharing, recording information for futures reference, creating comprehensive documentation on new features and functions. Simplified portfolio managers’ trading experience using the Moxy Trading system, delivered demos and trained new features and functions.

• Increased relevance to ensure ease of use and efficiency, establishing a personalized approach to users’ technology experience, delivering technical support.

• Improved efficient, secure access management and simplified the processes on-boarding and off-boarding user processing by, assigning and managing access right, managing systems, software, user account life cycles, and provisioning/decommissioning.

• Built customer trust and satisfaction, as the technical point of contact on trading applications. Delivered technical assistance, consulted with users and developers. Investigated and processed trading requests on the Moxy Trading systems from portfolio managers.

EDUCATION, TRAINING, CERTIFICATIONS

Bachelor of Science in Business Administration – (Accounting major), University of the East – Philippines

Certification: Microsoft Azure Fundamentals

Training: Advanced Query Tool Microsoft System Management Server

Contact this candidate