| Senior Data Architect / Data Modeler Senior Data Architect / Data Modeler with over 20 years comprehensive experience in relational database design within the government, telecommunications, utilities and manufacturing industries. Excellent logical data modeling and physical database design experience. Full-life cycle development for both functional areas and enterprise-wide systems using CASE tools. Understands both technology and business perspectives, and addresses database design concerns between information technology and business units. Skills include: - Requirements Gathering / Joint Application Design JAD sessions
- Logical Data Modeling / Entity Relationship Diagrams ERD
- Physical Database Design DB2, Oracle, Sybase, Datacom DB, IDMS
- Corporate Data Dictionary, Metadata Repository and CASE Tools
| - Enterprise Data and COTS Integrations
- Installation and Maintenance of CASE Tools
- Troubleshooting Data Design Issues
- Forward and Reverse Engineering
- LF Physical Schema Implementation
- Training users in RDBMS technology
- Excellent communication skills
| Experience | Confidential Senior Data Architect | - Consultant responsible for supporting the development team with database change requests for the Security and Exchange Commission SEC .
- LF Reviewed new designs and updates to existing database designs for adherence to data standards and guidelines as well as business requirements.
- Compared physical models to Sybase databases using ER/Studio Data Architect to document, report and resolve any variances.
- Created logical data model and physical model for the dataset used on the SEC s Data Governance website.
- Trained data analyst on relational database management concepts.
- Identified non-compliant metadata in the Enterprise Data Dictionary and produced a plan to correct the discrepancies.
| Confidential Specialist Senior Database Architect | - Managed database change requests for existing and new development for DB2, Oracle and MS SQL Server databases. Worked with Subject Matter Experts, Business Analysts, DBAs and application developers to ensure reliable database designs that met the business requirements.
- LF Served as data architect for Customer CRM , Billing, Accounting, Meter Data Management System MDMS , Pipeline Management, PeopleSoft, Work Management Information Systems WMIS , Marketer Portal, Enterprise Application Integration EAI , Business Activity Monitoring BAM Exception Handling and Sarbanes-Oxley Act SOX compliance.
- LF Facilitated JAD sessions with clients to capture business requirements in order to design the logical data model.
- Utilized ERwin Data Modeler and ERwin Model Manager to create, document and publish the metadata, logical data models, physical models and first-cut physical design for database change requests. Used ERwin to forward and reverse engineer databases, complete compare designs and generate reports.
- Provided Data Definition Language DDL scripts, physical model diagrams and metadata documentation to DBAs, application developers and clients.
- Managed and installed ERwin Data Modeler and ERwin Model Manager.
- Created and maintained the Data Administration Standard, Database Administration Procedure and Creating or Modifying Production Database Procedure documents.
- Contributed to Data Warehousing project by reviewing and approving conforming dimensions and fact tables using Kimball s methodology.
- Conducted logical data modeling classes for application developers, DBAs and team leads.
| Confidential Senior Data Architect | - Consultant responsible for COTS integration between TRIS legacy system to Ensemble new system for Nextel Communications Data Warehouse group.
- LF Worked with Ensemble software developer experts in order to transfer their knowledge of Ensemble to the Data Architects.
- Utilized Informatica to create and document data mappings and transformation rules from TRIS to Ensemble.
- Identified data and business requirements discrepancies between the TRIS and Ensemble databases and proposed resolutions to eliminate the discrepancies.
- Trained Nextel s application developers and Oracle DBAs with understanding the data and functionality of Ensemble to ensure a reliable and smooth COTS transition.
|
Privacy Policy
