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 with 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 with 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 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.
• 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 with Shared Services to synchronize 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..
• 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.

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