SUMMARY

• Data modeler/data architect with hands-on technical expertise in financial services, marketing, accounting, HR and scientific applications. Extensive experience in data and process modeling, business/systems analysis, data architecture, and relational db design and implementation. Excellent technical and non technical communication at all organization levels. Modeled and designed functional, performance effective, data bases for both operational OLTP and data warehouse systems. Developed complete accurate metadata information. Operational data bases were minimally redundant as well with. . Developed enterprise data models. Mapped source data to target data for etl, , evaluated software, queried data bases, developed standards, and improved data quality. Worked on metadata repository.
• Comprehensive experience in Oracle Unix environment Also have experience with SQL/Server, UDB and DB2.
• Skilled in use of Erwin, Rational Rose ,Oracle Designer and other software tools to define and document models.
• Results oriented contributor and team player with excellent project management skills.
• Substantial working knowledge of emerging technologies including information engineering, data warehousing Kimball and Inmon design methodologies and data mining.
• Hardware: Unix Solaris, PCs, IBM Mainframe, Teradata DB machine
• DBMS: Oracle 11G,10G,9I,8I,8.0 , SQL Server, UDB, DB2 , Access,VSAM,
• Case Tools: Erwin, Rational Rose, Oracle Designer, LBMS, ADW, BACHMAN, IEW, HPS, EXCELERATOR
• Query/Data Mining Tools:
• Worked with Business Objects developers on queries-explaining data base. Developed Cognos reports.
• Data Dictionary/Repository: Data Manager, CA Repository
• Languages/ETL Tools: SQL Plus, Toad, Did source target mapping for Informatica developers.
• PC Tools: Word, Excel, PowerPoint, Access, Project, Outlook, Lotus Notes, Visio

EXPERIENCE

Confidential

Data Architect Consultant

• Designed mortgage backed securities reporting data mart and made extensive enhancements to the enterprise wide operational data store data base now in Oracle 11g to support Ginnie Mae. Various application teams developed business enhancement requirements that I reviewed with them and designed the corresponding data base enhancements. I first used Erwin 4.14,7.3 and later 8.2. Have been very effective in understanding the business and developing and enhancing data models in a timely manner to meet the business requirements and deadlines of multiple groups. The enterprise wide operational data store consists of over 125 tables.. Developed logical and physical data models. Applied best practices for metadata specification both names and definitions. Created, logical data model entity and attribute naming to correspond to the data meaning. Developed and used physical abbreviation standards to create physical table and column names. Application systems enhanced included Issuer Status, Pool Transfer, Pool Number Assignment, Pool Logging and Issuance and Master Agreements
• Have also done extensive sql queries to understand the data. I have created source target mapping documents for the various changes to distribute to the etl group for their etl design. In addition, I have coordinated various software change implementations and have developed change management procedures. . I have effectively combined people and technical skills.
• The Reporting data mart was a warehouse designed using Kimball methodology and made extensive use of slowly changing dimensions to adequately document history of various dimensions. It was planned to be the archive component of a purge and archive strategy to minimize the volume of current operational data and to facilitate reporting.

Confidential

Data Architecture Consultant

Designed and implemented enhancements to Insurance operational and reporting systems in SQL/Server, UDB , Oracle and DB2. Generated ddl for data base implementation. Developed and ran sql queries against data bases to obtain information about data. Designed from scratch a sales and leads data mart. Extracted requirements from business and IT documents, from meetings with business analysts and it analysts. Models were developed and maintained in Erwin 4.1.4. I did some testing of Erwin 7.2 which was going to become the standard. at Met Life. Developed solid business understanding very quickly and worked well with users to understand their needs and to transmit and present data models and data issues.

Confidential

Data Architecture Consultant

• Designed and implemented major enhancements to a large Reinsurance Data Processing accounting system data model to effectively meet many additional requirements in a timely manner.. Participated in identification and clarification of requirements Generated ddl for data base implementation. Queried data base with sql plus to clarify contents of data. Provided extensive data documentation for better understanding. by team. Model was maintained in Erwin. System was initially in DB2 and was then switched to Oracle 9I. Rapidly developed business understanding. Managed extensive changes in an organized manner that enabled communication of changes to team personnel for review and understanding.
• Also designed and implemented enhancements for a number of varied insurance applications including claims, underwriting reporting etc in Oracle, SQL Server, UDB and DB2..

Confidential

Information Architect Consultant

Reviewed data and ETL design of MS SQL Server credit data warehouse. Made recommendations for functional and performance improvement. Documented various aspects of design to enable more effective system use.

Confidential

Information Architect Consultant-Credit Infrastructure Transformation Department

• Work below enabled JP Morgan Chase to better manage their credit exposure by obtaining a more complete, more accurate picture of it on an ongoing basis. This enabled better plans to be made to bring exposure under desired limits.
• Developed model for Credit Risk Reporting Datamart. Worked with Shared Services to synchronize this model with a centralized CIT wide model. Contributed to the development of a generalized dimensional model.that was to be part of the overall Application and Information Architecture. Quickly learned business and needed data and developed a model that effectively met user requirements. Established excellent interpersonal relations that facilitated this rapid development.
• Developed information model for Facilities and Constraints Management project. Developed and reviewed use cases to describe the business requirements. Participated in development of application architecture.and development and enhancement of physical data model.
• Used Rational Rose to document the class model and use cases.
• Contributed to the evaluation of a business intelligence tool for the data warehouse.
• Analyzed reference data sources for client, instrument, calendar, industry and country subject areas to determine data needed for cit wide corporate reference repository. Maintained and enhanced models in Erwin and converted to Rational Rose. Developed model management procedures in Erwin and Rose. Tested conversion product to convert model from one tool to another.

Confidential

Senior Data Administrator/Architect, Corporate Applications Development

• Developed quality, functional, performance effective logical and physical data models for brokerage projects that met business needs under tight deadlines. Projects included: data warehouse, data marts for credit risk, market risk and marketing, compliance reporting, incentive compensation, revenue sharing, stock loan, order and trading, electronic delivery, contact management, data security, margin, break reports, and account transfer systems. Used Oracle Designer 6.0 and 6I and Erwin 3.0 and 3.5 software. Models limited redundancy by making effective use of existing data.
• Contributed to business requirements specifications and reviewed and enhanced user documents in addition to developing data requirements. Rapid business understanding successfully reduced time to develop models and facilitated effective program design and coding of programs that access the data. Produced clear definitions of data structures enabling effective use of that data.
• Performed initial data base design to implement data structures in Oracle 8i in a Sun Solaris environment. Served to offload DBA staff and provide rapid turnaround to developers. Participated in data base optimization studies.
• STEPHEN SANDBERG Fleet Securities Inc. continued
• Consulted with application teams on transformation of data and managing its creation. Mapped source data to newly designed tables, including correlation of data in home grown data bases with Siebel system data. This facilitated data conversion programs and data warehouse ETL programs.
• Extensively used SQL to query data bases and verify structures. Improved understanding of related data which facilitated better business definitions. Participated in product selection and data base design with a business information warehouse team that selected Business Objects as a query tool and developed an initial user friendly data mart.
• Acted as key point of contact for application development to locate or clarify data.
• Initiated projects to eliminate redundant data. Started working on Designer metadata repository.
• Set up data base design and naming standards. Organized procedures for producing data deliverables and interacting with application and DBA teams.

Confidential

Data Modeling / Analysis Design Developed data model using LBMS for procurement, equipment maintenance and Accounts Payable applications, as well as for the AS 400 files utilized by the J.D. Edwards software package. Rapidly developed understanding of data and created and ran many SQL queries against the data. Modeled data for Equipment Maintenance data warehouse and designed Oracle tables. Developed and implemented DDL to define the tables. Developed and ran Oracle DML to extract data from the AS400 and load the Oracle tables. Created Cognos Impromptu catalogs to present data in easy to use format. Developed sample Impromptu reports and sample Powerplay model for use in data mining to easily obtain information from the warehouse and analyze trends.