RICHARD DONSON
Naperville, Illinois 60565
****************@*******.***
SUMMARY
Accomplished and resourceful Enterprise Data Architect with expertise in leading teams in the development of operational, transactional, and decision-enabling systems, specializing in conceptual, logical and physical data modeling, including star and snowflake schemas, master data management (MDM), Meta-data management, data governance, data quality, project management, and joint application development (JAD) facilitation. Takes on increasing challenges, while implementing the critical short- and long-term organizational objectives, while working in a time-sensitive environment.
KEY STRENGTHS
MANAGEMENT: Leadership, team and relationship building, customer and vendor management
DATA MANAGEMENT TOOLS: Power Designer, Erwin, ER Studio, CA Advantage Data Repository, IBM Websphere Information Integrator
DESKTOP TOOLS: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Project, Visio
METHODOLOGIES: Waterfall, Agile, Service-Oriented Architecture (SOA), Object Oriented, Information Engineering, Structured Analysis and Design, Total Quality Management
PROFESSIONAL EXPERIENCE
NEXT GENERATION INC. – CLIENT JOHNSON CONTROLS INC.
Milwaukee, Wisconsin
2010 - present MDM Project Manager - Contract
Responsible for the delivery of the Global Supplier Data Master application, automating manual paper workflow process to maintain vendor data in an MDM hub and distribute updates across the enterprise of a Fortune 100 company. Quickly established productive working relationships with business and technical management teams, infrastructure, application development, data architecture, QA and training teams. Manage project resources, both internal and external. Maintain project timelines and status reports. Facilitate issue and conflict resolution.
TEKSYSTEMS – CLIENT US CELLULAR
Bensenville, Illinois
2010 Lead Data Modeler/Architect – Contract
Led data modeling process improvement with a specific focus on data modeler DDL generation and hand-off to DBAs for the enterprise with the goal being 100% data modeler DDL generation for all databases.
Developed data maps from conceptual data model levels 0 and 1 to physical data models, while working with other data modeler to develop logical data model for the EDW-CRM data warehouse.
TEKSYSTEMS – NORTHERN TRUST
Chicago, Illinois
2010 Lead Data Modeler/Architect – Contract
Led data modeling process improvement with a specific focus on data modeler DDL generation and hand-off to DBAs for the enterprise with the goal being 100% data modeler DDL generation for all databases.
Led the development of the conceptual and logical data model for the Regulatory Evaluation and Validation business application from scratch. Facilitated data modeling sessions with subject matter experts to gather data requirements and meta-data. Utilized advanced functions of Power Designer to import and use the enterprise lexicon eliminating the time needed to enter table and column abbreviated names into the model.
TRANSUNION LLC
Chicago, Illinois
1995 - 2010 Manager, Data Resource Management
Led and managed an enterprise-wide shared service data architecture team of data modelers, Master Data Management developer, and meta-data repository administrator. Established and continuously improved processes to manage 5000+ tables for operational and business intelligence applications across the organization at the enterprise, business unit, and application area levels.
Collaborated with business and technical leaders to maintain resource alignment that reflected corporate priorities, goals, and objectives. Worked with Project Managers, Business Analysts, DBAs, developers, QA testers, vendors, and business users throughout the System Development Life Cycle to ensure on-time and within-budget system delivery.
• Developed logical data model transforming credit reporting database to a relational DB2 database with 24 x 7 availability, reduced database update cycle time to 1 day from 7 days, and provided capability for rapid enhancements to the database with new kinds of data allowing the business to offer new products and enhanced credit reporting services for additional revenue.
• Facilitated workshops to design data warehouse for the Mexican Credit Bureau within the International Division for customer, product, and sales data over time.
• Designed data warehouse model to track trends of credit attributes over time by various geographic areas.
• Developed and implemented department vision and strategic and tactical plans for attaining vision.
• Assumed responsibility for 4 Master Data Management system applications.
• Implemented 5 MDM solutions to improve efficiency, improve data quality, and reduce business risk.
• Transformed Enterprise Reference Data updates to a predictable process, while providing flexibility to update data in response to unplanned business needs, and application-specific release schedules.
• Led implementation of data distribution technology, IBM WebSphere Information Integrator. Results were predictable updates to over 200 master tables and distribution of data updates from MDM to 12 target systems across the enterprise, across DB2, Oracle and Sybase databases on mainframe and open systems environments, and elimination of redundant and inefficient ETL.
• Developed and implemented data governance processes.
AMERITECH
Hoffman Estates, Illinois
1995 Joint Application Development Facilitator (Contract)
Held responsibility for the facilitation of 1- to 4-day sessions for various business units delivering project plans, business process models, business requirements, screen and GUI designs, problem analysis, test planning, and alternative prioritization.
ADDITIONAL EXPERIENCE
FIRST CARD, Elgin, Illinois, Business Systems Specialist, 1994.
AMERICAN AIRLINES, SABRE COMPUTER SERVICES, Fort Worth, Texas, Senior Business Analyst, 1989 - 1994.
KEANE INCORPORATED, Westchester, Illinois, Programmer/Analyst Consultant, 1988.
GENERAL DYNAMICS, Fort Worth, Texas, Programmer/Analyst, 1985 - 1988.
EDUCATION AND TRAINING
INDIANA STATE UNIVERSITY
Terre Haute, Indiana
Bachelor of Arts in Computer Science, 1984