Michael Ryser has over thirty years hands-on experience in software engineering including internals and application development, in system design and database architecture, in operating system, application and database performance tuning, in database architecture with Data Warehouse and OLTP systems, in data migration from legacy systems to modernized systems, in Enterprise Information Management, Business Intelligence and Master Data Management. Mr. Ryser has worked extensively as a consultant in the United States, Europe and South America and has worked in management at the director-level.
O Database experience with architecture, database performance tuning and administration with Oracle and other database products and tools in Data Warehousing and OLTP environments
O Experience with Entity-Relationship modeling, Dimensional modeling, Star schema, Snowflake schema, Federal Enterprise Architecture (FEA) reference models, TOGAF and Zachman Framework
O Experience in Master Data Management (MDM) methodology, strategies and governance
O Experience with enterprise and application server systems, multi-platform environments, strong knowledge of UNIX operating systems, kernel, paging and swapping, inter-process communication, devices, file system concepts, scripting, performance analysis and tuning performance, scaling, capacity planning and configuration planning, storage, CPU and memory, backup, recovery, RAID and high availability
technologies
O Software development experience with C, SQL, PL/SQL, with case and software tools CA Erwin, Rational Rose, Rational ClearCase, Rational ClearQuest, CaliberRM, CVS, Visual SourceSafe; with Rational Unified Process (RUP), UML, ELC, SDLC, SEI CMM, Function Point Analysis, RAD, Agile Modeling and Extreme-XP methodologies
O Experience with business, user and functional requirements analysis, collection and development, data requirements, use cases, data sourcing, JAD sessions, technical architecture documents
O Management experience with local and remote direct reports, salary reviews, resource planning and allocation, product development, budgetary process, preparation of proposals, RFP and project management responsibilities
HARDWARE
Compaq/DEC AlphaServer, HP, IBM, SUN Enterprise 3500, 4500, 6500, Sun Fire E10K, E15K, E25K, 280R, 3800, Oracle Exadata Database Machine
OPERATING SYSTEMS
UNIX, HP-UX, Linux, MVS/VSE/ES, SunOS/Solaris, OSF1, VMS, Windows
LANGUAGES
C, COBOL, SQL
SOFTWARE
Oracle/SQL Server/Sybase RDBMS utilities, Transact-SQL, SQL*Plus, PL/SQL, PRO*C, Oracle Enterprise Manager, Oracle Warehouse Builder, Oracle Data Integrator suite - Oracle Data Quality and Oracle Data Profiling, Oracle Data Miner, MapForce, Quest Software Toad, Brio, Crystal Reports, UNIX utilities, XML, XSD
DATABASE MANAGEMENT SYSTEMS
Oracle, SQL Server, Sybase
SUMMARY OF EXPERIENCE
Present
Data Architect and Design team lead; consulting assignment at a government agency in Washington DC; responsible for the design of logical and physical data models to support the development and maintenance of Data Marts as a component of an Enterprise Data Warehouse. Responsible for the development of Dimensional models and staging area models using CA ERwin (7.3), the physical models were developed using Oracle 11g (11.1) under Oracle Enterprise Linux on an HP Oracle Database Machine. Assist in evaluation of ASG-Rochade metadata dictionary which will provide a centralized location for all enterprise-wide business and technical metadata and to reduce the risk for non-compliant regulatory adherences with governed definitions. Participate in Data Management group meetings, working with the teams to support and enhance the Master Data Management efforts, and to promote a shared foundation of common data definitions and to reduce data inconsistency where applicable to the data warehouse and business intelligence design efforts. .
Additional responsibilities include System requirements decomposition, Gap analysis between As-Is and To-be requirements, To-Be System components analysis and System deployment analysis. Work with management, business stakeholders, end users, analysts, modelers, ETL developers and QA; identify data requirements, determine systems of record, analyze source system data feeds - flat files and database structures for the development of data flow diagrams, ETL source-to-target mapping, data transformation and data cleansing documents, conduct and participate in model and code reviews..
Government Subcontractor
Data Architect, Analyst and Technical Lead; Data Migration and Data Warehouse project, responsible for the leadership of data migration from legacy systems to modernized systems; consulting assignment with a government subcontractor for the Defense Information Technology Contracting Organization (DITCO) DOD, Scott AFB, Illinois - a modernization effort to migrate Defense Information Services Agency (DISA) data from over twelve source legacy systems - mainframe (DB2, CA Datacom), flat file, database structures, etc. Develop in conjunction with the client the conversion design blue prints used in identifying, extracting and in the movement of data across all data stores. Responsible for the development of Dimensional models for the Data Warehouse effort, team leadership and for providing operational support. Responsible for leading the data rationalization efforts in mapping of source data - financial, vendor, contract, logistic, procurement and acquisition systems; extracting and moving data into test and development databases and operational data stores; and to continually improve the technical quality and stability of all the data extraction systems. Assess data quality using the Oracle Data Quality and Oracle Data Profiling tools, Oracle Data Warehouse Builder (10.5) to build mappings for ETL layer, as well as develop SQL*Loader scripts and PL/SQL procedures and functions for implementation under the Linux operating system.
Participate in the Master Data Management (MDM) effort, provide technical advice and support toward the development of strategic and tactical plans for client master data management strategy, data inventories, data governance, data management, storage, and distribution alternatives in support of client MDM strategy. Assist with standards, guidelines and processes to address strategic enterprise master data issues and in the preparation of a draft documenting master data strategies and best practices.
Additional responsibilities include conducting requirements elicitation JAD groups, analysis and development of functional requirements documents, source to target data mapping and related documents, research, selection and implementation of data mining and data transformational analysis tools - Oracle Data Miner used in conjunction with other tools to migrate legacy systems data into an Oracle 10g database. Map and extract data from source systems to target data stores, validate data loaded into the data stores, troubleshoot technical issues and support partners through the data cleansing process.
Computer Sciences Corporation
Data Warehouse project, consulting assignment within the Federal Sector. Managing Architect, hands-on role responsible for project and team management; for the initial high level project requirements analysis and Business Intelligence, including defining business requirements and objectives, data profiling, data source-to-target mapping matrix spreadsheets, creation of Technical Requirements documents, Functional Specification documents using Rational Unified Process (RUP) and UML, Rational Rose, technical architecture and ETL diagrams. Creation of technical due diligence activities, assessment of appropriate technologies, solution designs, and vendor selections, create detailed project schedules and milestones. Architect data models, analyze source data feeds, flat files, DBMS, XML, translate business requirements into source-to-target mappings and transformation logic. Build mappings for ETL layer using Oracle Warehouse Builder 10.1, for development of C, PL/SQL code, SQL*Loader and UNIX shell scripts. Prepare validation plan and validate data in the target database tables for implementation under Oracle10g on Sun Solaris 10 (SunOS 5.10).
Lockheed Martin Information Technology
Consulting assignment within the Federal Sector for a multi-terabyte Data Warehouse project. Data Architect, responsible for data analysis, requirements gathering, data profiling, traceability, Business Intelligence, business rules development, report analysis, user interviews and JAD sessions. Data source-to-target mapping and frequency analysis for ETL component, process flow diagrams, documentation and project management. Determine facts, dimensions and architect Dimensional model using ERwin 3.5.2, ISO / IEC 11179 Specification/Standardization of Data Elements for implementation under Oracle 9i on HP-UX. Validate data in DB2 ODS database source tables and in the target Oracle database tables using UNIX scripts, PL/SQL, Brio Intelligence 6.6.4. Participate in the design of dimensional models and in the development of the ETL layer using Oracle Warehouse Builder 9.2, Rational Rose and Rational ClearCase. Determine, assign, track, and manage project tasks, activity, documentation and time information per internal standards. Assess the risks associated with each project.
TelCom Inc, Director Database and Performance Engineering
Responsible for the day-to-day management of the Database Engineering and the Performance Engineering organizations; staff includes managers, developers, database engineers and performance engineers. Responsible for support of the service bureau database components, software product offerings and internal database systems, for employee development and mentoring, employee career path growth and training programs. Responsible for Database and Performance Engineering organization initiatives, database architecture and database development, and performance characterization efforts to support current software product releases, new product releases and for new technology research and development programs. Responsible for the technical and the financial performance of projects - for customer satisfaction, status reporting, vendor collaboration, estimation of required resources and the evaluation and alignment of goals. For development, implementation and the maintenance of Oracle8i and Oracle9i database access code, establishing standards, application design and code review of product software. Responsible for internal administration and support of all production and customer ASP 7x24 Oracle OLTP, Oracle Parallel Server, Oracle Financials databases, data marts and data warehouses running on Sun, IBM and Compaq Alpha hardware under Unix and Windows. For hardware and software strategic planning, capacity planning, vendor management, negotiations, acquisition, implementation, SOW and RFP process.
Responsible for the development of the consulting services practice to address operational performance characteristics; working directly with customers to provide expertise in remote or on-site engagements. Customer consulting engagements to support, customize, troubleshoot software products, provide recommendations to customers concerning database and system performance tuning options, capacity planning and server hardware configurations, review UNIX system kernel file, Oracle initialization file, storage and database configuration.
Summary of Customer Consulting Engagements
O Sprint PCS, OLTP application, and Oracle 8.1.6, Sun E6500 with a Hitachi sub-system. Analyze I/O performance problems using Glance, Oracle Statspack tool
O MovilNet Venezuela, OLTP application, Oracle 8.1.6, Sun E10K with a StorEdge sub-system. Analyze performance problems using SAR, Oracle Statspack, Tkprof tools
O TelMexico, DSS application, Oracle 8.1.5, Sun E10K with a Hitachi sub-system. Analyze performance problems using SAR, Oracle BSTAT/ESTAT, Tkprof tools
O Rogers Canada, DSS application, Oracle 8.0.5, Sun E5500 with an EMC sub-system. Analyze performance problems, review user generated OS statistic reports, Oracle BSTAT/ESTAT tool
Participate in hardware and software strategic planning,
capacity planning, vendor management, negotiations, acquisition,
implementation, SOW and RFP process.
Summary of Consulting Assignments
Ryser Associates, Inc
Assignments in hardware, software, IT, education, financial, government and military, manufacturing and retail included database architecture, database administration, performance tuning and programming in OLTP and Data Warehousing with MVS, VMS, UNIX and Windows environments. Projects included application development, database development with DBMS32, DB2, IDMS, IMS, Ingress, and Informix. Rdb database internals engineering with Digital Equipment Corporation. Database performance benchmarking - working with the major hardware and database manufacturers (IBM, DEC, Sun, NEC, Stratus, Oracle, Sybase, Microsoft) and the Transaction Processing and Performance Council (TPC), high speed computing, parallel processing and cluster systems. Participated in several projects in US, Europe and South America developing Data Warehouses and Data Marts using Oracle and Oracle Parallel Server, responsibilities as a project manager and as an individual contributor included design and implementation of physical database architectures, performance, design and development of C application code, SQL, Oracle PRO*C/ESQL code to extract, clean and load data.
Oracle Corporation
O Participated in several projects managing OLTP, Data Mart and Data Warehouse databases using Oracle and Oracle Parallel Server in Unix and Windows environments with financial and manufacturing applications. Additional tasks included design and implementation of physical database architectures, database tuning and performance recommendations. Code ETL PL/SQL modules, C and PRO*C/ESQL to extract, clean and load data
O Participated in TPC-B, TPC-C and TPC-D benchmarks with Oracle partners DEC and SUN, and with custom benchmarks for potential customers
Blue Cross of Puerto Rico (La Cruz Azul de Puerto Rico)
O Provide assistance and support to customers at various stages in the Data Warehouse project life cycle - conduct JAD sessions, prepare requirements, use cases, project evaluation and storage management configuration options and technical architecture documents. Review physical database architectures, ETL processes and work with project teams to implement physical database with Oracle
O Review physical database architectures and work with project teams to implement physical database using Oracle.
O Participate in data sourcing, extract data investigation process, work with teams to develop PL/SQL, C, PRO*C/ESQL ETL code and load data for flat file generation, code SQL*Loader control files to load data
Kodak Corporation
O Participate in data warehouse requirements collection, JAD, identify data requirements, data sourcing
O Participate in design of logical database model and in implementation of physical database using Oracle and Unix OS
Fidelity Investments
O Maintain and support fund performance Decision Support system, responsibilities include database administration tasks, implement database modifications, ensure that nightly data feeds and ETL processes complete within maintenance window and have executed successfully, troubleshoot, identify and resolve problems, code and test SQL*Loader control files, tune load process for performance
O Work with analysts to determine data requirements and identify data sources, provide estimates for task duration
O Provide assistance to developers and work with developers to maximize coding efforts, support development environments