Data Management

DENNIS SCHOEN

**-** ******** ******* *****: ******@***.***

Fair Lawn, NJ 07410 Phone: (H) 201-***-****

CAREER SUMMARY

Results-oriented data modeler/business analyst with ten years of experience

in the finance industry analyzing data requirements and designing logical,

dimensional and relational data models in multi business areas. Promoted to

a leadership role in the data modeling team. Business domain expertise in

wealth management and brokerage. Strong communication, management and

project planning skills. Excellent team player and technology partner to

business and application development teams.

PROFESSIONAL EXPERIENCE

2000 -2010 UBS WEALTH MANAGEMENT, NJ

Associate Director, Data Modeler/Business Analyst

Worked on designing major projects and initiatives including BASEL II Risk

Management, FASB Compliance, Broker Trading, Alternate Investments,

Entitlement Systems, Managed Accounts, Branch Organization, Accounting, and

Human Resources.

Achievements and deliverables include:

. Partnered with business users senior management and application

development team members to collect and analyze data requirements.

Used JAD sessions successfully to resolve issues.

. For both mainframe DB2 Z/OS, oracle and sybase database systems,

created Conceptual, Logical & Physical models for various subject

areas each covering around 5 to as many as 40 entities.

. Integrated and Designed logical and relational models for US and

Switzerland entitlement systems

. Analyzed and designed Deposit and Disbursement models that are used by

clients and internal users

. Designed the Alternate Investment data model for storing client

application, product data and investment in hedge funds.

. Designed organizational/party firm hierarchy model that is used as a

core source model for all other applications.

Participated in the development of the Enterprise Data Warehouse and

associated data marts using dimensional modeling techniques in oracle

. Reverse Engineered & documented the existing elements of DB2, oracle

and sybase systems which had no model

. Worked extensively in forward engineering processes, creating DDL

scripts for implementing data models. Published data models to PDF

files and created data dictionaries

. Facilitated the creation and agreement of data modeling standards and

procedures across Wealth Management .

. Initiated and led the Data Modeling Best Practices Forum to facilitate

cross-team training in business knowledge and data modeling patterns.

. Led the internal review of data models to ensure development of high

quality models.

. Developed a scorecard for management reporting of the team's

deliverables increasing productivity

. Effective in work situations requiring an ability to manage multiple

and concurrent projects and responsibilities.

. Managed the team's work assignments to ensure timely delivery of

modeling commitments increasing speed to delivery.

. Possess excellent communication and interpersonal skills with a proven

track record of ability, adaptability, creativity and innovation

1998 -2000 FAMILY COUNSELING SERVICES OF ORANGE COUNTY, NY

Program Director

Responsible for administering the multi-program social services agency,

including government compliance, and audit preparation. Key achievements

included

Computerizing the client intake process

Design and development of the Client Database Program

These automation initiatives resulted in improved staff productivity,

quality of care, and client satisfaction.

TECHNICAL SKILLS

Modeling Tools: Erwin 7.3. Modelmart, Enterprise Architect

Modeling Skills: Data Analysis, Entity-Relationship modeling, Dimensional

modeling, knowledge of Object Modeling and XML

Databases: Oracle, Sybase, DB2

Computer Languages: Knowledge of SQL

EDUCATION

Columbia University, NY

Certificate in Database Application, Design and Development

Hunter College, NY

MSW

Lehman College, NY

BA

Contact this candidate