ANGELA Wyler
Atlanta,GA
Summary
- 25+ years of experience in Life Sciences, Banking and Financial Services 20+ years of experience in Database Development and Data Management 15+ years of experience in Business Intelligence Development 10+ years standing up Data Management Offices (DMO) 10+ years working with Banking Regulators including OCC, FDIC, SEC/FINRA Expert knowledge in Banking and Financial Analytics, Reporting and Systems Expert knowledge in Change Management; General IT Controls, Code Management; Policy and Procedure Enterprise Program Management Executive Board Presentations
- 2021 – Present FP&A and Tax Prep for Private Real Estate Firm; Professional consultations to prior employers; Private School Board Director of Community Engagement; and numerous other Educational and Community volunteer activities.
Overview
31
31
years of professional experience
1
1
Certification
Work History
SVP, Enterprise Data Officer, Head of Data Management Office
Opus Bank
Irvine, CA
03.2016 - 01.2021
- Stood up Data Management and Governance Office (DMO): Data Warehouses, Business Intelligence Platforms, Data Integrity/Accuracy Auto Checks, Data Security, Policy and Procedures
- Hired/Managed/Developed DW Architects, ETL Engineers, Sys Admins and BI Developers
- Rolled out internally built ODS/EDW and Oracle Business Intelligence platform
- Delivered in-house CECL platform 6 months ahead of 1st filing
- Instituted Change Management and GITC: Leveraged existing BMC system for CM Management – Including user requirements, SIT/UAT evidence, approvals, deployment roll-forward/roll-back instructions with code attachments, post implementation testing; leveraged SVN for Master Code and Documentation repository; JAMS for SSIS Package scheduling, triggers, success/failure messaging. Embedded DI checks and messaging from point-to-point data loads.
- Personally Developed/Coded Proof of Concepts (POC) for new DW subject areas and BI Reporting
- Personally Developed/Coded AI/ML for Data Integrity Checks on Databases
- Personally Developed/Coded AI/ML for BSA/AML
- Personally Mapped Data sources and authored Data Dictionaries, Transformations
- Personally refined Householding Algorithm
- Connected Vendor Data (ie) Experian and via API’s/ SFTP protocols to bring credit and economic data for modeling on prem.
- Provided Executive Level Dashboards and Analytics for business decisions and strategy discussions on Pricing, Credit Risk, Sales Compensation, Product Strategy
- Successfully passed GITC, IT Operations, Data Security internal and external audits. Rated “exceeds expectation”
- Business areas supported: Finance, ERM, BSA/AML, Credit Risk, Operations, Sales, Marketing, HR/Legal
Director, Management Information Systems, Business Banking
Union Bank - Mitsubishi United Financial Group (MUFG)
Irvine, CA
05.2011 - 03.2016
- Stood up Management Information Systems (Business Intelligence) Group: Financial Reporting and Operations Analytics. Loan Portfolio Analysis, Risk Monitoring, Operational Dashboards, Commercial Loan Pipeline Reporting, Commercial Loan Cycle Time Analytics.
- CCAR: Worked within Enterprise BASEL II & III, Advanced Approach and CCAR teams; Directed Data Provisioning from enterprise credit systems; translated regulatory rules into ETL calculation logic; provided testing and sign off.
- Managed Proven Engineers for Risk Scored Loan Approval Decision Engine, a statistical neural-net (AI/ML) decisioning engine; provided data provisioning strategy and development for ETLs and model updates.
- Managed Experian data connection, providing secured connection for live credit reporting.
- Compiled enterprise Data Dictionaries for 5 Data Warehouses for use by analysts and across enterprise, in an effort to standardize CCAR submissions.
- Developed and provided oversight of Compensation Reporting and automation on mPower reporting website.
- Developed Pipeline Reporting and automation on mPower reporting website
- Oversaw Key Data Element (KDE) Integrity and Quality for Data Custodians
- SME for Enterprise Data Warehouse, Data Virtualization, Big Data and Master Data Management
- Managed 2 Engineers, 3 Analysts and offshore contractors
- Business head for Union Bank MUFG, DMO Committee
Senior Applications Developer, Institutional Client Group Technology
Citigroup
Singapore
02.2010 - 12.2010
- Responsible for Business Process Re-Engineering of Institution Client Group Applications Development Teams, Capital Allocations
- Conducted Process Mapping of Financial Planning and Analysis Reporting
- Documented Financial Control Processes
- Maintained Master General Ledger and P&L Mappings, including Creation, Approval and Submission of Requests to Core Banking systems groups
- Architected ICG Tech Finance Data Warehouse
- Tracked and Reported Asia Pacific IT Allocations (Invoicing) intra Region and back to NY
- 2004-2010: See ASIA for Roles in Tokyo, Japan and Singapore
Business Manager
Expat Tax USA
Singapore
07.2009 - 02.2010
- Application set-up and maintenance, including contact management system and Internal Revenue Service (IRS) tax reporting software
- Client data storage and backup, and server set up and staging
- Reporting of clients’ foreign bank accounts (FBARs) for US Treasury Department
- Parsed trading history for reporting and estimation of capital gains
- Website maintenance of ancillary business
- Development of professional communications to clients
Consultant, IT&T Financial Services Industry
Hudson
Singapore
03.2008 - 11.2008
- Responsible for Investment Banking, Commercial Banking and Retail Banking IT recruitment
- Worked directly with line managers on hiring strategies and defining job descriptions
- Grasped complicated Banking roles immediately or in very little time due to personal familiarity with Banking Operations
- Wrote and placed online advertisements for clients’ positions
- Sourced candidates leveraging personal networks, referrals, and mining online databases such as eFinancials
- Established contact with 80 to 100 mid to senior career professionals per month
- Achieved 1:1 ratio in client introduction to interview
- Successfully negotiated salary and benefits packages during offer stage to the satisfaction of both clients and candidates
Consultant, Finance and Banking
Oak Associates K.K.
Tokyo, Japan
11.2005 - 01.2007
- Responsible for Investment Banking Operations and IT recruitment
- Worked directly with line managers on hiring strategies and defining job descriptions
- Wrote and placed advertisements for clients’ positions
- Sourced candidates via cold calling, attending networking events, referrals, and online databases; developed internal mapping of companies, positions and employee names
- Developed internal candidate database of 125 mid to senior career professionals
- Achieved 1:1 ratio in client introduction to interview
- Made professional presentations to clients, negotiated and finalized contingency/retainer contracts
- Within 1st quarter, became a preferred vendor to Goldman Sachs
- Met quarterly goals
Senior Technology Editor
Asian Technology Information Program
Tokyo, Japan
11.2004 - 11.2005
- Reported on advancements in nanotechnology, semiconductors, robotics, unmanned war-craft, fuel cell technology, and other developing technologies
- Worked with researchers and interpreters to convert research from native Japanese, Mandarin and Hangeul to English
- Transformed research into purchasing information for researchers, scientists, and developers at the US Department of Defense, Homeland Security and DARPA (http://www.darpa.mil/).
- Managed production queue, website design and layout, and updating of research reports on external websites
Vice President / Management Information Systems (MIS) Manager
Wells Fargo & Company
San Francisco, CA
06.1998 - 02.2004
- Responsible for electronic Data Management and Reporting on Business Loan Portfolio
- Responsible for centralizing Management Information Systems (MIS) for Business Banking
- Spearheaded standardized and automated MIS reporting for Finance, Accounting, Operations, Risk and Marketing Reconciled reporting to GL
- Created Data Mapping and Data Dictionary of Core Banking Systems to reporting databases
- Created library in Oracle PL/SQL and Cognos Impromptu of all standardized calculations for P&L and balance sheet items, product by product and by transaction. Calculations included average loan balances, commitments, COF, NIL, NOF, yields, losses, profit and sales compensation
- Productionized PL/SQL code that calculated and ranked Profitability all Business Banking customers, on a Household Basis.
- Nearly 2 years of effort during Norwest merger were required to Map Data from Mainframes, to create ETL files of monthly transactions using COBOL, which were then uploaded to Oracle tables.
- Developed algorithm to Household customers under 1 unique id.
- On an ad hoc basis, Valuated and monitored Credit Risk exposure
- Valuated Acquired Banks assets, loan portfolios, collateralization & securities
- Electronically merged Acquired Bank Portfolios into WFB portfolio
- Automated monthly and quarterly SOX 404 Regulatory Reporting
- Managed financial databases; oversaw development and maintenance
- Sat on steering committee for bank wide IT, CRM, and ERP planning projects
- Managed and developed the careers of my team of analysts, consultants, and developers
Management Information Systems (MIS) Manager Manager Public Services
KPMG LLP
San Francisco, CA
07.1996 - 06.1998
- Stood up Centralized Reporting Function for National Sales Management
- Reported on Profit, Revenue/Investment, and Proposal to Engagement pull through
- Automated Sales Reporting using Sybase, Oracle and VB
- Centralized Client Management; expanded contact management systems
- Developed internal CRM system for clients using VB Access
- Developed alumni database
- Ran direct mail campaigns; purchased lists, managed databases, coordinated printed collateral and mail house
- As Marketing Manager, responded to RFP’s and wrote dozens of proposals on behalf of partners - assembled national consulting team.
- Provided Market Research pertaining to clients in federal, state and local governments, healthcare, not-for-profit, and university sector.
- Clients included DOE, Catholic Healthcare, City and County of San Francisco, Los Angeles County, Orange County, both CSU and UC systems
- Prepared presentations for engagements
Senior Business Analyst
Agilent Technologies - J&W Scientific, Life Sciences
Sacramento, CA
06.1990 - 07.1996
- Provided Business Analytics (Chromatography Division)
- Produced Monthly Sales Reports and Forecasts for distribution channel and Pricing [Supply Chain Management]
- Produced Monthly Forecasts and manufacturing schedules by part number Pricing [Supply Chain Management]
- Project Managed development and maintenance of CRM system
- Trained employees on operation and use of CRM system
- Developed reports from CRM system to measure effectiveness of direct mail, telemarketing, sales programs, customer visits and technical seminars
- Presented recommendations on viable markets, market approach and delivery to senior management, compiled marketing and competitive intelligence
- Developed surveys, database, system of tracking and analytics
- Managed marketing assistants
- Distribution Strategy 6/1990 - 12/1994
- Primary contact for international network of 96 distributors; 4,000 sales representatives
- Provided new product forecasts, modeled businesses, provided business strategy
- Developed distributor pricing policies
- Developed basic chemistry and chromatography training programs for sales staff at Fisher Scientific, Baxter Scientific and Curtin Matheson
- Scheduled and coordinated sales meetings and vendor shows
- Conducted new product campaigns
- Executed direct marketing campaigns
- Supervised sales support staff
Education
MS/MBA - Decision Sciences
San Francisco State University
12.2003
BS - Bus Admin MIS
Sacramento State University
12.1991
Skills
BI Platforms: Oracle Business Intelligence (OBIE), Hyperion-Peoplesoft, Cognos BA, Quicken Business, Excel , Power BI, Data Analysis, Salesforce, Python MatLab, PyPlot
DataBricks (SDK)
DataCamp (SDK)
Data/Quantitative Analysis: Python: PySci, NumPy, Matplotlib, R, MatLab
Presentation: Adobe, PowerPoint, SharePoint
Databases: SQL Server, Oracle 11i
Languages: Python, MS-SQL, MSSS, PL-SQL, GIS/SQL, Java, NET
AFS, Fiserv, HOGAN/WEBS [AS400 (IBM) Mainframe]
Certification
- 11/2025 Python - for Data Sciences, Data Camp (Matplotlib, NumPy, Pyplot, SciPy, Seaborn)
- 5/2020 Oracle 12G Multitenant Database Training, Oracle
- 5/2020 Oracle 12G Golden Gate Training, Oracle
- 2012 Six Sigma Green Belt Training, MUFG
- 2003 Leadership Training, Wells Fargo
- 2002 Cognos Developer Training
- 2001 Visualization of Data, Edward Tufte, UCLA
- 2000 PL/SQL Functions & Procedures, Oracle University
- 1999 PL/SQL Fundamentals, Oracle University
Japanese Language
4/2004 – 2/2007 3kyuu Conversational
Interests
Political-Socio-Economical History, Cultural Anthropology, Landscape Gardening, Alpine Skiing, Hiking, Trail Running, HIIT
Affiliations
Association of Women in Finance; American Chamber of Commerce; Tokyo Press Club
Timeline
SVP, Enterprise Data Officer, Head of Data Management Office
Opus Bank
03.2016 - 01.2021
Director, Management Information Systems, Business Banking
Union Bank - Mitsubishi United Financial Group (MUFG)
05.2011 - 03.2016
Senior Applications Developer, Institutional Client Group Technology
Citigroup
02.2010 - 12.2010
Business Manager
Expat Tax USA
07.2009 - 02.2010
Consultant, IT&T Financial Services Industry
Hudson
03.2008 - 11.2008
Consultant, Finance and Banking
Oak Associates K.K.
11.2005 - 01.2007
Senior Technology Editor
Asian Technology Information Program
11.2004 - 11.2005
Vice President / Management Information Systems (MIS) Manager
Wells Fargo & Company
06.1998 - 02.2004
Management Information Systems (MIS) Manager Manager Public Services
KPMG LLP
07.1996 - 06.1998
Senior Business Analyst
Agilent Technologies - J&W Scientific, Life Sciences
06.1990 - 07.1996
MS/MBA - Decision Sciences
San Francisco State University
BS - Bus Admin MIS
Sacramento State University