Mezgebu Lisanework
Phoenix,AZ
Summary
Subject matter expert for all TM banking products and services. Well-versed to work closely and collaboratively with the Enterprise Project Management Office, Product Office, Treasury Management sales & support, Marketing and IT relative to TM & Electronic Banking product development, File Monitor, SFTP Support, testing and roll-out. Experienced in identifying, assessing and recommending to management the implementation of operational control procedures relative to the electronic banking products and services. Extensive experience in coordinating special projects, forms, training material, and serves as the department's liaison to the Information Technology department for systems administration.
Overview
10
10
years of professional experience
Work History
Digital Banking Operations Analyst (TMAS Support)
Western Alliance Bank
Phoenix, AZ
01.2020 - Current
- Responsible for monitoring the health and maintenance of banks digital payment channels and online banking experience
- Responsible for monitoring business online banking, EPP Wire System, and Volpay on a 10-min interval checking for system interruptions or behavior that would indicate there are issues with the digital payment channels
- Monitoring BeB system for online banking
- Performing wire research as per client request
- Creating and resolving cases in CRM concerning wire monitoring
- Responsible for monitoring and tagging DBO BOT email
- Performs testing of product enhancement releases, user acceptance testing, and issue resolution
- Troubleshoots vendor supported and internally hosted applications and engages with correct departmental/vendor resources to assist in correcting problems when necessary
- Level 2 & 3 support for internal departments across all support applications
- Direct responsibility for coordination of special projects relative to gathering data, special reporting, etc for management, audit and other departments as assigned
- Partners with Product, Marketing, and Training departments to communicate product information to internal departments and customers
- Oversees the conversion of existing customers and new customers acquired through acquisitions into new/existing product lines
- Responsible for maintaining logs for product issues, enhancements, defects, and testing of electronic banking applications
- SFTP file management and API experience
- FIS BST/BEB/CEB, Fiserv EPP, FIS Integrated Payables, VolPay, FIS IBS core experience
- Advanced knowledge in digital channel/product management, application management and change management
- Creating and resolving treasury management products ticket to meet the required SLA’s
- Completing monthly testing accounts and bank control account certifications
- Managing CRM (Dynamic 365) tickets
- Responsible for Business and consumer bill Pay collection items
- Responsible for monthly testing account and Bank control certifications
SQL/ BI Developer
Department of Economic Security
Phoenix, AZ
02.2015 - 12.2019
- Gathered requirements, assured satisfactory data content, quality, data integrity
- Oversaw receipt of desired information from JRD sessions following the JAD methodology
- Conducted review Meetings for common understanding with business, development and test Teams
- Data warehouse design using Top-down, bottom-up, Data Mart design for Star Schema and Snow-Flake schema
- Data Extraction and Transformation
- Write SQL queries to extract data from various sources
- Transform data into a usable format for analysis
- Data Analysis and Reporting
- Analyze data using SQL to identify trends, patterns, and insights
- Create reports and visualizations to communicate findings to stakeholders
- Data Quality Assurance
- Develop and implement data quality checks to ensure accuracy and completeness of data
- Identify and resolve data quality issues
- Database Design and Maintenance
- Design and maintain databases to support data analysis and reporting
- Optimize database performance and ensure data security
- Data Integration
- Integrate data from various sources into a single database for analysis
- Develop and maintain ETL processes to automate data integration
- Data Governance
- Develop and implement data governance policies and procedures
- Ensure compliance with data privacy regulations
- Data Modeling
- Develop data models to support business requirements
- Optimize data models for performance and scalability
- Data Mining
- Use SQL to mine data for insights and patterns
- Develop predictive models to support business decision-making
- Data Visualization
- Create visualizations to communicate data insights to stakeholders
- Develop dashboards to monitor key performance indicators
- Collaboration and Communication
- Work with cross-functional teams to understand business requirements
- Communicate findings and recommendations to stakeholders in a clear and concise manner
Education
Bachelors - Electronics
University of Central Oklahoma
Edmond, OKMaster of Science - Cybersecurity
Grand Canyon University
Phoenix, AZDoctor of Business Administration -
Touro University Worldwide
Los Alamitos, CASkills
- Advanced Excel
- Power BI
- Visio
- Microsoft Outlook
- Dynamic 365
- Cleo Harmony
- Confluence
- File Fox
- NACHA Files and Rules
- SFTP
- CCX
- FXD
- Positive pay
- Payee positive pay
- Reverse positive pay
- Excellent oral communication skills
- Excellent written communication skills
- Excellent interpersonal communication skills
- Excellent analytical skills
- Excellent organization skills
- Account certifications
- Bill pay collection items
- Data Extraction
- Ad-Hoc queries
- Automation
- Troubleshooting
- Data visualization
- Problem solving
- Data analysis
- Monitoring
- Wireshark
- Nmap
- Kali Linux
- PfSense
- VMware
- Splunk
- Snort
- OpenVas
- John the Ripper
- Metasploit Framework
- Aircrack-ng
- Test Strategy
- Test Scripts
- Test Requirements
- Test Planning
- Test Cases
- Functional Testing
- Re-engineering
- Process Analysis
- Business Requirements
- Business Process
- Financial Systems Implementation
- Fiserv Application Support
- Mobile Applications
- Web Applications
- Integrated Payables
- Income Tax Specialist
- Unix
- Windows
- Mainframe
- SQL development
- Data warehousing
- Reporting
- Business intelligence solutions
- SQL Server 2005
- SQL Server 2008
- SQL Server 2008R2
- SQL Server 2012
- SQL Server 2014
- T-SQL
- OLTP
- OLAP
- Entity Relationship Diagrams
- Erwin
- Microsoft SQL Server BI Studio
- SSAS
- SSIS
- SSRS
Timeline
Digital Banking Operations Analyst (TMAS Support)
Western Alliance Bank
01.2020 - Current
SQL/ BI Developer
Department of Economic Security
02.2015 - 12.2019
Bachelors - Electronics
University of Central Oklahoma
Master of Science - Cybersecurity
Grand Canyon University
Doctor of Business Administration -
Touro University Worldwide
Similar Profiles
Frank Gracia IIIFrank Gracia III
Preferred Bank Advisor at Western Alliance Bank (Alliance Bank of Arizona & Bridge Bank)Preferred Bank Advisor at Western Alliance Bank (Alliance Bank of Arizona & Bridge Bank)
Oscar VillalobosOscar Villalobos
Lockbox Processor at Western Alliance BankLockbox Processor at Western Alliance Bank
Colleen FentonColleen Fenton
Staff IT Analyst II at Western Alliance BankStaff IT Analyst II at Western Alliance Bank
BJ SUPRAIBJ SUPRAI
Preferred Banking Manager at Western Alliance bankPreferred Banking Manager at Western Alliance bank
Alexandra BerryAlexandra Berry
Service Coordinator at Presidential Pools, Spas & PatioService Coordinator at Presidential Pools, Spas & Patio