Benjamin S.

Benjamin S.

Data Architect, Business Intelligence Developer and college level computer systems instructor.

, Panama

Experience: 19 Years

Benjamin

Data Architect, Business Intelligence Developer and college level computer systems instructor.

80640 USD / Year

  • Immediate: Available

19 Years

Now you can Instantly Chat with Benjamin!

About Me

My IT project management and data architect experiences have lead me on a quest for balance.
Beyond the classical need for balancing performance, cost and schedule there is:
• The right mixture of data-driven orientation and the process ...

Show More

Portfolio Projects

Data Model creation with ER Studio and OneNote for UI.

https://www.tspersonnel.com/temporary-jobs-temp-to-hire

Company

Data Model creation with ER Studio and OneNote for UI.

Description

Provided data modeling services utilizing E/R Studio referencing significant tables with supporting views,
stored procedures and SSIS solutions as required. OneNote was found to be an easy to use UI tool in
describing project scope, links to data models, system-to-system and data-to-application data flows.

Show More Show Less

Campus data management

https://www.utsa.edu

Company

Campus data management

Description

  1. Enhanced existing SSIS ETL packages supporting student, faculty and staff data associated with

    Oracle-based student registration, course management, student conduct and campus management.

  2. Maintained campus wide Identity Management and Faculty Evaluation systems.

Show More Show Less

Data Modeling tool evaluation, purchase and implementation.

https://www.swbc.com

Company

Data Modeling tool evaluation, purchase and implementation.

Description

  1. Defined architecture and the build process for a new data warehouse focusing on insurance products and
    associated accounting systems. Profiled and documented data quality issues and assigned data stewards.

  2. Recommended and purchased ER/Studio and Len Silverston enterprise data models in support of a model-
    driven, Inmon style architecture. Simplified and adapted the standard enterprise models in the creation of

  3.  NF logical and physical data models for finance, HR and sales data subject areas. Derived dimensional star
    schemas, a data aggregation strategy and associated source-to-target ETL specifications.

Show More Show Less

Skills

Data Modeling

Teradata based marketing, Data quality and Data Maintenance

https://www.dell.com/en-us/shop

Company

Teradata based marketing, Data quality and Data Maintenance

Description

Assisted strategists in developing order attribution, marketing analysis via direct mail/email campaigns.

2 Participated as DA representative on a data warehouse engagements & quick impacts sizing team.

3 Provided data models and source mapping documents for several data warehouse projects such as
Consumer Price Optimization, Spanish Queue, Affinity, SFDC, Subscription Center.

4 Assisted with the initial implementation and change management of Dell’s enterprise data model based
on Teradata’s Manufacturing Logical Data Model utilizing Informatica and Business Objects

Show More Show Less

Data Architect

https://www.southwest.com

Company

Data Architect

Description

1 Oracle Datamart modeler and Ab Initio ETL graph developer supporting a Finance driven scorecard project
containing departmental performance metrics for Maintenance, Ground Ops, Flight Ops and Reservations.
2 Teradata data warehouse modeler for OLAP dimensional (star schema) passenger activity analysis and
terabyte sized relational airline operational data store.
3 Created prototype OLAP model supporting Cognos-based Revenue Management analytics.

Show More Show Less