Michael Ryser has over thirty-five years hands-on experience in software engineering including internals and application development, system design and database architecture, operating systems, application and database performance tuning, database architecture with Data Warehouse and OLTP systems, data migration from legacy systems to modernized systems, 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, DoDAF Viewpoints and Models, Federal Enterprise Architecture (FEA)/Consolidated Reference Model (CRM) reference models, NIEM, 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 CMMI, 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
DHS CBP Full BI security clearance, DoD Secret level security clearance.
HARDWARE
Compaq/DEC AlphaServer, HP, IBM, SUN Enterprise 3500, 4500, 6500, Sun Fire E10K, E15K, E25K, 280R, 3800, Oracle Exadata X2-2 half rack
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
Government Subcontractor
Data Architect; consulting assignment for data warehouse, business intelligence, federal analytics and reporting projects supporting the Centers for Medicare and Medicaid Services (CMS) and state clients. Design comprehensive solutions for diverse business requirements related to DW/BI and lead a team to achieve project goals. Analyze current analytical and reporting environments, recommend strategies and build roadmaps to achieve project goals. Develop data management strategies including master data management, data quality and data governance. Develop an implementation plan and work with the project management to track progress.
Additional responsibilities include leading requirements gathering and design sessions, working with analysts to establish and clearly define requirements that follow a business process model and conform to CMS standards (MITA, MMIS), work with state data suppliers to establish input and interface specifications for the implementation of the Transformed Medicaid Statistical Information System (T-MSIS). Direct and participate in the analysis effort for source-to-target data mapping documentation, for logical and physical models development using CA ERwin (9.0), Oracle (11.2), for the development of dimensional and ETL staging models that adhere to data warehouse best practices and comply with CMS and state standards that include maintaining physical and technical security and privacy of protected health information (PHI) mandated by HIPAA.
Provide consultation to, and work with state implementation team for delivery of MMIS Reporting and Analytics data warehouse running on Oracle Exadata using Oracle Database 12c, provide monitoring assistance using Oracle 12c OEM tools.
Government Subcontractor
Data Architect and Technical team lead; consulting assignment for an Enterprise Architecture/Data Management and Integration modernization project at the Pentagon for the DoD Security Cooperation Agency to develop strategy, planning and implementation deliverables for BI/Data Warehouse and ERP vendor services in support of a tri-service finance program. Work with the Government to develop an enterprise data management strategy, data management and master data management plan, data conversion and data cleansing plan. Document the As-Is system functions which will be retired through the implementation of the program, evaluate the To-Be business and technical requirements and translate into specific database solutions; structure, attributes and nomenclature of data elements, develop logical data models using CA ERwin (8.0). Translate strategic requirements into enterprise information architecture; enterprise data model, metadata, common business vocabulary, ontology and taxonomies to be used to guide enterprise solution development and achieve consistency of information assets.
Work with the Government to develop an enterprise data management strategy, data management and master data management plan, data conversion and data cleansing plan and Business Intelligence solutions.
Develop strategies and recommendations for the collection and dissemination of information that include traditional data warehouse technologies and developing technologies - Virtualization, Federation and Semantic Web architectures, structured and non-structured data, persistent, non-persistent storage, caching and NoSQL solutions.
Design, build, prototype and benchmark a NoSQL solution using MongoDB (2.4.9) on Windows 64-bit to populate and store semi-structured/unstructured data; test and document results.
Document the system functions for hardware, software, database and applications which will be retired through the implementation of the program. Conduct in-depth analysis of the business rules for the first increment of the legacy systems to be migrated, and other supporting documentation which will be provided to the vendor for implementation of the Data Warehouse and ERP solution.
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 Consulting Assignments
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