Providing modeling services for the IT Finance unit of Kaiser Permanente. Specifically using ERWIN to produce Dimensional models for Labor Resources and Assets/Leases. Also reverse engineered source tables for instantiation in the staging environment. Forward engineered

Provided interface between primary user community and the IT communityGathered business requirements in the form of an Erwin Model (logical) for the Engineering Product Data Hub data environmentProvided physical model for the above mentioned projectCreated physical tables from the physical model in the development environment (Sql Server ) using a combination of Erwin (forward engineering) and Microsoft SQL Server Management StudioLoaded a subset of tables with data to provide a sample of data to the end user and the IT organization as a proof of concept prior to full build out of the application.

Provided Business Enablement services for the Business Modeling Group within the Enterprise Data and Analytics group.Acted as a proponent of the business and provided requirements analysis services by working with the business and data providers to understand their analytic needs and turning those requirements into technical solutions.Profiled source system data to understand it from both a business and technical perspective.Documented business requirements primarily within the Deposit Products, Deposit products Risk and Deposit Products Fraud arena, Documented technical design and metadata for the for Teradata 12 data warehouse solution.Provided light project management where needed.Provided design facilitation where needed.Provided Quality Assurance assistance where needed.

FastTrack - Quick-hit agile-like process as well as traditional waterfall development.Provided Modeling Expertise for other Modelers in Design ReviewsData Base Platforms:• DB2 LUW version 10 for target platform.• Oracle for source and eventual target platform access.• Vertica for target platform usage.• Hive/Hue for Hadoop target/source data platform.Designs to support several data access platforms including Cognos and Tableau for reporting.Workstation Applications:• Aqua DataStudio 17.0.3 for DB Platform Data and DDL Access• ER/Studio Data Architect 11.0 for Data Modeling and Reverse/Re-engineeringFrom a Business perspective exposure to many retail oriented functions including • Data Hub processing for Individualization/MDM sourcing to Marketing teams.• Source to target mapping for customer tables.• Multiple vendor interfacing for sourcing and targeting of sales campaign email, SMS and Mobile Device push notifications.• Exposure to several retail star schema designs such as sales/merchandise and sales returns processing. • Participated in the reviews of existing/new data model standards and naming notation.

Provided modeling (logical and physical ) and DB design services in both Teradata 12 and Oracle 11 environments. Provided analysis of input data and transformation instructions and mapping for all source to target ETL processes. Train/Coach Business Systems Analysts on Logical Modeling using CA/Erwin modeling tool.. ● Help create Logical Models.● Review Logical Models for conformance/governance to modeling and metadata standards.● Provide Physical Models and DDL to DBA.Subject Areas of work• Schwab Intelligent Portfolio Reporting ( from Mongo )• Voice Biometric Reporting• Salesforce Dot Com data warehouse capture enhancement• Politically Exposed Persons reporting• Liquidity Coverage Ratio reporting• Liquidity Monitoring Reporting• Security Master Reporting• Cisco Phone and Phone Traffic Enhancements• Audit Vendor Interface• Asset Tracking• External Vendor Discovery Data• Compliance Review Reporting• Technology Support Services Reporting• Compliance Review Reporting• Technology Support Services Reporting• Depository Trust Services Reporting• Account Trustee Services Reporting• Customer Email Enhancements• Morningstar Reporting Enhancements• Mutual Fund Interclass Exchange Reporting• Web Channel Activity Reporting (Source from Hadoop)• Customer Representative Access Reporting Enhancement• Revenue Driver Reporting Enhancement

Currently working in the EDR project at the California Franchise Tax Board. Providing Data Modeling and consulting in other areas in an modeling/architectural capacity pertaining to creation of relevant Data Marts as an adjunct to Enterprise Data Store.

Sr. Business and Data Architect/Modeler/Designer/Tuner

Data Modeling, Data Analysis, Data Base Design for Data Warehouse and Management Information Systems Applications

Data modeling and design for an improved risk rating project that supported both Visual Basicand Web Interfaces.Data modeling in support of a consumer integrated risk Datamart.Provided ongoing support of the risk management area in utilizing IBM's Banking DataWarehouse Model and modeling tools.Provided ongoing DBA and modeling support in the development of a Global Payments MISsystem utilizing relational OLAP tools.Development platforms include AIX, Solaris, Windows, MVS Expertise in ERWIN, BPWIN and Model Mart· Database experience in DB2, Oracle, Sybase, SQL Server, Informix, TeradataTechnical Profile Languages SQL, PL/SQL, UNIX Shells , C, HTML, XML Database Tools/Applications Oracle SQL tools including SQL*Plus,SQL* Loader, SQL* DBA ERWIN, BPWIN and Model Mart DSSAGENT Databases Oracle 7x, 8x, 8i; DB2 UDB and MVS; MS SQL Server, Sybase, Informix, Teradata OS System IBM AIX, SUN Solaris, MS Windows NT 4.0/2000 Industry Exposure: Finance, Banking and Insurance

Worked on Real Estate Loan Document Preparation and Origination System requirements analysis and acquisition

Real Estate Loans system analysis procurement customization and installation.

Project manager for the real estate loan servicing system.

Primary programmer analyst responsible for Corporate Account Reconcilement application system and DB/CR Followsheet applications. Interfaced with North America Division and provided field support to national sales staff in making field calls to major corporate clients in NY, NY and Dearborn, MI.

Worked various shifts in computer operations running IBM Mainframe and various peripherals. Worked as a programmer doing maintenance on Assembly Language and Cobol. Designed a DDA system which supported overdrafts and multilevels of interest rate calculation.