We provide IT Staff Augmentation Services!

Data Architect/modeler Resume

SUMMARY:

  • Accomplished Senior Business, Data and Process Architect/Modeler/Designer. Data Modeler/Database Designer/Database Administrator on various platforms from Mainframe, Midrange, Local Server including design development and deployment of a variety of platform solutions both at the hardware and software levels.
  • I have supported a variety of solutions ranging from ATM network databases in an OLTP environment, Operational Data Stores and Data Marts through Enterprise Warehouse environments.
  • Knowledge of CA/ERWIN, Teradata, Oracle, DB2, Informix, Sybase and MS SQL Server

TECHNICAL SKILLS:

Database: experience in DB2, Teradata, Oracle, Sybase, SQL Server, Informix, Vertica, Hive/Hue for Hadoop

Languages: SQL, PL/SQL, UNIX Shells, C, HTML, XML

Database Tools/Applications: Oracle SQL tools including SQL*Plus,SQL* Loader, SQL* DBA

OS System: IBM AIX, SUN Solaris, MS Windows

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect/Modeler

Responsibilities:

  • 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.
Confidential

Data Architect/Modeler

Responsibilities:

  • 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
Confidential

Data Modeler

Responsibilities:

  • Providing data modeling for EDR project at the Franchise Tax Board. Modeling includes supporting the EDW Data Team. Modeling all phases of a hybrid data warehousing / data mart environment utilizing 3NF modeling as well as Star/Snowflake schemas for access by Business Objects Universes. Providing data mapping support as needed for the ETL team.
  • Tools Utilized: Sybase Powerdesigner, IBM DB2 v9.7, Business Objects
Confidential

Data Modeler

Responsibilities:

  • Subject Areas covered:
  • CRM Data modeling.
  • LaserApp - Application forms printing tracking and measurement of Advisor adoption, Software license usage, forms/template usage.
  • Advisor Referral Tracking - Tracking of referrals and conversion of customer/accounts for high end customers to advisors which Schwab has a relationship.
  • Phone Traffic - Modeling data from existing phone traffic systems into a coordinated set of tables that will be linked to existing data warehouse infrastructure.
  • Prime Broker / Trade Away fees - Modeled new flexible fee environment for inclusion into the data warehouse environment.
  • Tools used: ERWIN v7.3.9, SQLNavigator v6.4, Teradata SQLAssistant v13.10, Teradata v12, Oracle v11
Confidential, Concord, CA

Data Modeler, Data Architect, Business Analyst

Responsibilities:

  • Provided Data modeling and design of structures to support a strategic privacy solution for multi product multi-affiliate access in the warehouse environment. Also developed procedural model specification for access to data within the requirements of the strategic privacy model.
  • Provided Data modeling, design and post implementation support of many products within the Confidential online banking data warehouse environment including web analytics and product specific databases.
  • Served on the data governance committee responsible for developing and monitoring standard abbreviations within the data warehouse.
  • Provided ongoing support of the risk management area in utilizing IBM's Banking DataWarehouse Model and modeling tools (M1) and CA/Erwin.
  • Data modeling and design for an improved risk rating project that supported both Visual Basic and Web Interfaces utilizing CA/ERWIN.
  • Data modeling and Database Design in support of a corporate and consumer integrated risk Datamart.
  • Provided ongoing DBA and modeling support in the development of a Global Payments MISSystem utilizing relational OLAP tools (Micro Strategy).
  • Worked on Real Estate Loan Document Preparation and Origination System requirements analysis and acquisition.
  • Real Estate Loans system analysis procurement customization and installation.
  • 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.
Confidential, San Francisco, CA

Programmer Analyst

Responsibilities:

  • Designed a new DDA system which supported overdrafts and multi-levels of interest rate calculation.
  • Worked as a programmer doing maintenance on Assembly Language, COBOL and a little bit of Autocoder.
  • Worked various shifts in comp

Hire Now