Data Architect Project Management

DINA KWAN

*** ********** **., *** ***** NV *****

909-***-****

******@*****.***

SUMMARY

Responsible for aligning data architecture with enterprise strategy and ensuring data health to be in SOX compliant under competitive financial environment with extensive hands-on database knowledge and skill

PROFESSIONAL EXPERIENCE

VP, Data Architect (December 2024 – Present)

Banc of California – Brea, CA

Ensure smooth transition combining two data sources of both PacWest and BANC

Perform data gap analysis to ensure data migration of various enterprise applications

Oversee production support and maintenance including providing technical specifications as needed

Oversee data flow of multiple systems enterprise wide

Continue to carry on duties as transitioned from PacWest

AVP, Data Architect (March 2015 – November 2023)

PacWest – Brea, CA

Designed, developed and implemented ETL solutions using PL/SQL, T-SQL, C#, Python, SSIS, Informatica CDI.

Performed project management such as project scoping (FTE estimation and budgeting), risk assessment, resource management, priority management and cost estimation, statement of works, requirements and test plans

Liaised between vendors and other business units

Data Solution Architect

oRedesigned a single database into a data warehouse, used in enterprise reporting

oOptimized data solution: design data warehouse, data lakes, streaming data, ETL standardization, compliance, data quality verification, test result and approval

oImplemented procedures to ensure SOX compliance and audit requirements

oInterfaced with internal and external auditors

oImplemented procedures for data monitoring to increase data accuracy and relevancy

oStreamlined data accuracy and pipeline

oTrained users to perform monthly reconciliation, data file prep

oAdvocated for best practices, naming standards, standardizing implementation procedure

oCollaborated with data governance, as well as other key stakeholders

oImplemented and maintained data lineage for the enterprise data warehouse

oSubject Matter Expert on overall data systems and data flow

Sr. Systems Developer (April 2012 – December 2014)

ECCU – Brea, CA

Designed, developed and implemented applications using PL/SQL, SQR, C#, VB.net and VBA for Microsoft Excel.

For example,

oCreated dynamic C# applications to significantly reduce the FTE effort from 5 FTE to 1 FTE and from 2 days to mere minutes. For example, generating XML data files, generating letters, notifying consumers via emails, summarizing credit card information and account transactions.

oCreated an Oracle package to mask social security number from ACH transactions

oCreated automated batch applications to produce reports or execute C# applications

Performed peer to peer code review

Performed project management such as project scoping, risk assessment, resource management, priority management and cost estimation

Reviewed statement of works, requirements and test plans

Liaised between vendors and other business units

Subject Matter Expert on the enterprise document library system that interacts with LaserFiche

SKILLS

Database:

Oracle, Microsoft SQL Server

Programming:

C#, Python, SQL Server T-SQL, Oracle PL/SQL, VB.net, SQR, VBA, VB, Java, HTML, JSP, XML, EDGE

Application:

Informatica Cloud Data Integration, Visio, Microsoft Office, Microsoft FrontPage, Adobe Photoshop, Crystal Reports, Visual SourceSafe, Visual Studio

EDUCATION

●

●California State Polytechnic University of Pomona - Bsc in Computer Information Systems (System Analysis & Design emphasis) with minor in Accounting.

●California State Polytechnic University of Pomona - Oracle DBA/Developer Certification Course

●Sun Education - Java Programming Boot Camp

●Project Management Preparatory Institute - Business Analyst Certification

●Project Management Institute - Certified Associate Project Management

●Peter Block – Flawless Consulting I and II

Contact this candidate