James D. Johnson

** ********* ******

Morristown, NJ 07960

adu9bt@r.postjobfree.com

862-***-****

PROFESSIONAL SUMMARY

A Senior Data Architect/Data Modeler/Database Design with over 25 years of experience in the financial/IT industry. Possessing strong communication skills and the ability to work on a team as well as taking on a task solely. Proven ability to prioritize, meet deadlines, and generate timely solutions in a fast paced environment.

SKILLS

Hardware:

Various IBM and Unisys Mainframes, Sun, HP, and IBM servers, including SMP and MPP types. Sun and Windows based workstations. Program Languages: C, C++, COBOL, FORTRAN, PL/SQL, Korn Shell, Bourne Shell

DBMS:

SYBASE, SQL SERVER, DB2, ORACLE, DMS1100, TeraData, Hadoop Hive, Greenplum

Modeling Tools: ERwin, Bachman, Excelerator, IEW, LBMS, PowerDesigner

SOFT SKILLS: Meeting Facilitator, 3NF database design, FSLDM modeling, Metadata management, Ralph Kimball dimensional database design including Snowflake.

PROFESIONAL EXPERIENCE

Pride Technologies, New York, NY

June 2015 – December 2018

Data Architect

Continuation of engagement with Data Modeling group at Morgan Stanley

Member, Enterprise Data Modeling group

Performing enterprise-wide data modeling using ERwin and PowerDesigner

Participate in implementation and testing of Metacenter

Enforced enterprise data standards

Advised development teams on implementation of database modifications

Collaborated with development teams to generate accurate business metadata

Collaborated with data modeling team members to generate and maintain an enterprise data dictionary.

Maintain an enterprise data warehouse in Teradata with data marts in Hadoop and Greenplum. About 70% of the work.

Maintained application databases in SQL Server and DB2.

Experis IT

June 2012 – June 2015, New York, NY

Data Architect

Member, Enterprise Data Modeling group at Morgan Stanley

Performing enterprise-wide data modeling using ERwin and PowerDesigner

Participate in implementation and testing of Metacenter

Enforced enterprise data standards

Advised development teams on implementation of database modifications

Collaborated with development teams to generate accurate business metadata

Collaborated with data modeling team members to generate and maintain an enterprise data dictionary.

Maintain an enterprise data warehouse in Teradata with data marts in Hadoop and Greenplum. About 70% of the work.

Maintained application databases in SQL Server and DB2.

New York Life, Clinton, NJ

July 2000 – March 2012

Data Architect

Established design philosophy and helped define initial scope

Designed core data warehouse including contract and claims data.

Data Architect for a Corporate Data Warehouse project developed in Oracle

Responsible for logical data model, physical data model and data marts designed using Bachman initially, then ERwin

Participated in the design of the processes used to populate the warehouse

Responsible for implementation of the database design in Oracle as well as several enhancements and expansions of the data warehouse and other applications. Provided production support including PL/SQL, scheduling backups, configuring database parameters and other tasks

Participated in the selection of ERwin to replace Bachman and executed migration of models from Bachman to ERwin

Redesigned metadata interface with Platinum Repository and procedures to fit new modeling platform. Specified data quality assessment procedures using PL SQL, SAS, UNIX and mainframe utilities, and participated in the selection of data sources

Responsible for E-R and Dimensional modeling standards

Created and maintained data models as lead DBA, including dimensional models, star and snowflake schema, fact and dimension tables

Assisted in design of procedures for populating Essbase cubes and Business Objects universes

Provided general support for applications in various relational environments as outlined above under Z/OS, UNIX and Linux

Environment: Oracle, DataStage, Essbase, Business Objects, and Crystal Enterprise. Data sources vary from VSAM to DB2, Oracle, Sybase, and a variety of other application data sources

Merrill Lynch Inc.

September 1996 – June 2000

Senior Data Modeler

Architect on two data warehouse projects: a Marketing project in Infomix and a Human Resources project in Oracle

Created entity-relationship and dimensional models in LBMS and PowerDesigner

Participated in the selection of PowerDesigner as the standard modeling tool to replace LBMS. Participated in the selection of Informatica as the corporate standard ETL tool

Established methodology for creating and managing the information delivery environment

Established and implemented change control procedures and techniques

Designed local metadata tables in Oracle and collaborated with consultants from Cognos and Informatica to provide access to metadata via the front end of each tool

Implemented three tier architecture in marketing and human resources data environments

Created and maintained entity relationship and dimensional data models, including star and snowflake schema and fact and dimension tables

Computer Task Group Inc.

February 1995 – August 1996

Senior Consultant

Developed standards for data modeling in Excelerator IE, OO and ERwin in connection with a data warehouse project developed in Oracle

Contributed to relational data model for the data warehouse at a banking institution known then as First Union

Provided data rationalization services and implemented same using Platinum Repository

Coordinated Object Oriented analysis with data modeling efforts in an interdisciplinary project methodology and provided instruction and support to the analysis team

Charming Shoppes Inc.

November 1994 – January 1995

Data Modeler

Developed standards for data and process modeling for an enterprise model project using

Excelerator. Provided instruction and guidance in IE methods and Excelerator techniques to 11 analysts engaged in the project

Assisted Manager of Data Administration by coordinating efforts of 3 project teams

Created data and process models for the project

Administered FirstCASE scheduling system

Provided guidance in adapting FirstCASE methodology to local conditions

Prism Inc.

1993 – 1994

Senior Consultant

Participated as a senior analyst in a large system development project to construct a Public Assistance Case Tracking system

Created flow diagrams, E-R models, screen and report prototypes and other deliverables using Excelerator as the primary tool. The development methodology was FirstCASE

Coordinated structured meetings using FAST and JAD methods

Reviewed and corrected scheduling reports created in Timeline

Ernst & Young/Arthur Young

1987 – 1993

Senior Application Specialist

Planned, scheduled, and tracked multiple projects using project management software

Acted as facilitator in structured walk-thrus as called for in the IE: CSM and Navigator methodologies. Supervised 1 – 6 programmers and analysts through full project life cycles on several projects

EDUCATION

Harvard University, BA, English Literature

University of Michigan, MA, English Literature

Contact this candidate