Senior Data Architect Resume San Dimas, CA - Hire IT People

PROFILE:

Accomplished in Data Management activities: Data Governance, Enterprise Information Architecture, and MDM.
Expertise in Database Design. Logical and physical data models, warehouse models, domain models, forward and reverse - engineering.
Extensive experience in Data Integration, Data Mapping, and defining Data Transformation Rules.
Experience with Data Profiling, Data Mining, Data Quality Analysis.
Effective Database Administration skills. Creating and maintaining database objects, defining capacity requirements for new database schemas.
Proficiency in Data Obfuscation to protect sensitive data in development and test environments. Experience includes identifying data elements to be obfuscated, writing custom scripts, and creating rules with Delphix.
Expertise in Client Interaction: translating business requirements into technical design, facilitating data modeling, process modeling, and JRP sessions.
Strong verbal and written communication skills.
Lead Data Architect in numerous Agile projects with experience writing, grooming, and sizing user stories.
Sound knowledge of financial services, payroll services, payroll tax compliance mortgage lending credit card operations, wage garnishments, and ACA compliance.

TECHNICAL PROFICIENCY:

Data and Domain Modeling: Erwin Studio and Erwin Model Mart, Enterprise Architect, SQL Developer, Oxygen XML Editor, Eclipse

RDBMS: Oracle 12c and lower versions, SQL Server, DB2 (Z/OS), MS Access, TOAD, Oracle Enterprise Manager (OEM)

Data Integration and synchronization: Some experience with Informatica and Golden Gate

Data Obfuscation: Delphix

Languages: DDL, DML, PL/SQL, XML, familiarity with JSON

Web Development Tools: Dreamweaver, Front Page

Architecture: Service Oriented and Event Driven Architectures (SOA / EDA), JMS messaging, SOAP and RESTful services

PROFESSIONAL EXPERIENCE:

Senior Data Architect

Confidential, San Dimas, CA

Responsibilities:

Played major role in securing funding for a client profile project.
Conducted extensive research and data mining to present problem statement and proposed solution to senior management.
As lead architect, designed and implemented a new database schema to serve as the system of record for client profile information shared across multiple products.
Worked with application developers to define APIs to exchange data with client profile database.
Acted as Lead Data Architect on project to automate database releases (Dev/Ops).
Defined requirements for creating pipelines. Documented procedures to check-in and check-out database objects and move database changes through the pipeline. Identified database design and achritecture standards to be programed into the tool. Worked with developers to create pre-and-post scripts.
Designed and implemented a database schema for a business intelligence project to analyze Cost of Service to clients. Led the effort (across multiple products) to track services provided to clients and revenue generated from fees. Created a common domain model to standardize data representation among all applications. Defined data transformation rules for data migration.