We provide IT Staff Augmentation Services!

Data Architect Consultant Resume

Brooklyn, NY

SUMMARY:

  • Hands - on technical expertise in financial services, marketing, accounting, HR and scientific applications. Excellent technical and non technical communication at all organizational levels.
  • Comprehensive experience in Oracle Unix environment, along wif SQL/Server, UDB and DB2. Skilled in use of Erwin, Rational Rose, and Oracle Designer to define and document models.
  • Substantial knowledge of emerging technologies, including information engineering, data warehousing (Kimball and Inmon design methodologies), and data mining.
  • Demonstrated skill in creating reporting warehouses and minimally redundant Operational data bases. Proven ability to develop complete accurate metadata information, map source data to target data for etl development, evaluate software, query data bases, develop standards, and improve data quality.

TECHNICAL SKILLS:

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

Query/Data Mining Tools: Business Objects, Cognos

Data Dictionary/Repository: Data Manager, CA Repository

Languages/ETL Tools: SQL Plus, Toad, Informatica (source target mapping)

PC Tools: Word, Excel, PowerPoint, Access, Project, Outlook, Lotus Notes, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

Data Architect Consultant

Responsibilities:

  • 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 while meeting the business requirements and deadlines of multiple groups.
  • The enterprise wide operational data store consisted of over 125 tables.
  • Developed logical and physical data models.
  • Created, logical data model entity and attribute naming to correspond to the data meaning. Developed 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
  • Executed extensive sql queries to understand the data and created source target mapping documents for distribution to the etl group for their etl design.
  • 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.

Confidential, Jersey City, NJ

Data Architecture Consultant

Responsibilities:

  • 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 wif business analysts and it analysts. Models were developed and maintained in Erwin 4.1.4. Conducted testing of Erwin 7.2 which was going to become the standard.

Confidential, Jersey City, NJ

Data Architecture Consultant

Responsibilities:

  • Designed and implemented major enhancements to Reinsurance Data Processing accounting system data model to effectively meet additional requirements. Generated ddl for data base implementation. Queried data base wif 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.
  • Designed and implemented enhancements for a number of varied insurance applications including claims, underwriting reporting etc in Oracle, SQL Server, UDB and DB2..

Confidential, New York, NY

Information Architect Consultant

Responsibilities:

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

Confidential, New York, NY

Information Architect Consultant

Responsibilities:

  • Developed model for Credit Risk Reporting Datamart, working wif Shared Services to synchronize wif a centralized CIT wide model. Contributed to the development of a generalized dimensional model dat was to be part of the overall Application and Information Architecture..
  • 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 data sources for client, instrument, calendar, industry and country subject areas to determine data needed for cit wide corporate repository. Maintained and enhanced models in Erwin and converted to Rational Rose. Developed model management procedures in Erwin and Rose. Tested product to convert from one tool to another.

Confidential, New York, NY

Senior Data Administrator/Architect

Responsibilities:

  • Developed functional, performance effective logical and physical data models for brokerage projects including 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.
  • 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.
  • Consulted wif 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 wif 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 wif a business information warehouse team dat 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 wif application and DBA teams.

Confidential, NJ

Data Modeling / Analysis & Design

Responsibilities:

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

Hire Now