Michael Ryser has over twenty years hands-on experience in software engineering including internals and application development, in database architecture, operating system, application and database, performance tuning, database administration in OLTP and Data Warehouse systems. 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, SQL Server, ETL tools and other database tools in BI/Data Warehousing and OLTP environments

 

O Experience with E/R, relational, dimensional modeling, star, snowflake and denormalization schema techniques

 

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, Visual Basic, SDLC, ELC, Rational Unified Process (RUP), Rational Rose, Rational ClearCase, Rational ClearQuest, UML, CaliberRM, SEI CMM, CMMI, Function Point Analysis, RAD, Agile Modeling and eXtreme-XP methodologies

 

O Experience with business, user and functional requirements analysis and collection, data requirements, use cases, data sourcing, Business Intelligence, 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

 

OPERATING SYSTEMS

 

UNIX, AIX, HP-UX, MVS/VSE/ES, SunOS/Solaris, OSF1, VMS, Windows 2000

 

LANGUAGES

 

C, COBOL, SQL, Visual Basic

 

SOFTWARE

 

Oracle/SQL Server 2000/Sybase RDBMS utilities, Transact-SQL, SQL*Plus, PL/SQL, PRO*C, Oracle Enterprise Manager, Oracle Warehouse Builder, ERwin, MapForce, Quest Software Toad, Brio, Crystal Reports, UNIX utilities, XML, XSD

 

DATABASE MANAGEMENT SYSTEMS

 

Oracle, SQL Server, Sybase

 

SUMMARY OF EXPERIENCE

 

December 2006 - Present Government Subcontractor

 

Data Warehouse Architect - Technical Lead, consulting assignment within the Federal Sector; hands-on role responsible for team management, for project requirements analysis, management of defects using Rational ClearQuest and management of code using Rational ClearCase, data profiling, data source-to-target mapping documents, creation of technical design models and documents using Rational Rose, technical architecture and ETL diagrams. Analyze source data feeds, flat files and, database structures, translate business requirements into source-to-target mappings and transformation logic. Build and modify mappings for ETL layer, including C, Oracle Warehouse Builder 10.1 and PL/SQL code, SQL*Loader and UNIX shell scripts, design, develop and implement under Oracle10g on Sun Solaris 10 (SunOS 5.10).

 

January 2005 - December 2006 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, responsible for writing PL/SQL procedures and functions, UNIX shell scripts, design, develop and implement Extract, Transformation and Load code using Oracle Warehouse Builder 10.1. Prepare validation plan and validate data in the target database tables for implementation under Oracle10g on Sun Solaris 10.

 

September 2003 - January 2005 Lockheed Martin Information Technology

 

Consulting assignment within the Federal Sector for a multi-terabyte Data Warehouse project. 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.

 

January 1997 - September 2003 Lightbridge Inc, Director Database and Performance Engineering

 

Responsible for the management of the Database Engineering and Performance Engineering groups - for the development and support of commercial Telecom software and administration and support of all production and customer ASP 7x24 Oracle OLTP, Oracle Parallel Server and Oracle Financials databases, data marts and data warehouses. The staff includes team leads, developers, DBA's and performance engineers.

 

Responsible for database and performance engineering initiatives, database architecture, database development, new technology efforts, research and development using Oracle9i, Oracle8i, Oracle Parallel Server, Oracle Multithreaded server and Oracle Replication. Responsible for development, implementation and the maintenance of Oracle8i and Oracle9i database access code, establishing standards for application design and a code review process.

 

Monitoring of production systems, back-up and recovery verification of primary and fallback databases; hot standby databases, troubleshooting, installation of UNIX and Windows 2000 Oracle software and patches, database performance tuning - I/O balancing, memory, application and SQL performance tuning of systems running on Sun, IBM and Compaq Alpha hardware under UNIX and Windows 2000.

 

Data warehouse, Data mart design, development and implementation experience. Logical and physical modeling, dimensional modeling, logical and physical design with multi-terabyte data warehouse, gathering of data requirements and definitions, normalization techniques, tuning, ETL - extraction, transformation, loading, data source-to-target mapping, data conversions and data sourcing using Oracle Warehouse Builder, C and PL/SQL modules.

 

Additional duties include consulting; working directly with customers (Sprint PCS, MovilNet Venezuela, TelMexico, Rogers Canada) to provide tuning expertise in remote or on-site engagements in support of Lightbridge software products. Review UNIX system kernel file, Oracle initialization file, storage and database configuration, SQL and provide recommendations to customers concerning database, system capacity planning and server hardware configurations.

 

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.

 

Ryser Associates, Inc

 

Summary of Consulting Assignments

 

Assignments in hardware, software, IT, education, financial, government and military, manufacturing and retail included performance tuning, database architecture, database administration and programming in OLTP and data warehousing in UNIX and Windows environments. Projects included application development, database development with DBMS32, DB2, IDMS, IMS, Ingress, Informix and for Rdb in database internals development. 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 marts and data warehouses 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, Oracle PRO*C/ESQL code to extract, clean and sort data.

 

Oracle Corporation

 

O Participated in several projects managing OLTP, data mart and data warehouse databases (ranging many GB to 2TB) 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 sort 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 sort 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