MGS Associates, Inc: Our Consultants

Michael G. Sadof

SUMMARYchemas-microsoft-com:office:office" />


Michael G. Sadof has over 25 years of experience as an Information Technology professional. As the owner of an Information Systems consulting company which specializes in the design, analysis and reporting of large databases of a financial or statistical nature, Mr. Sadof has experience in full lifecycle application development and support with the SAS® system. Additionally his experience includes development in SQL, JCL, UNIX Shell Scripting, and COBOL. He possesses strong analytical skills and can interface effectively with business users and client managers to gather and translate application requirements. Mr. Sadof is currently a SAS Certified Professional at the Data Management Level.


Most recently he has been involved in design and development with the SAS Business Intelligence products, optimization and data warehousing projects, information visualization and the presentation of survey and test results utilizing the SAS® System. He has been responsible for designing, developing, optimizing and testing SAS systems on the three common platforms namely: z/OS, UNIX, and Windows. He is proficient in the installation and configuration of SAS BI tools. Mr. Sadof stresses a strong liaison between the customer/user and the developer to produce efficient, maintainable and user friendly information systems.





Mr. Sadof has worked with SAS Institute on several consulting projects to install and configure the SAS v9.13 Business Intelligence Platform. He has also developed a system using the Data Integration Studio under the BI-Platform. This DI Studio project involved SAS SPDS, SAS Metadata Server and SAS Data Quality Server to develop a data warehouse used for market analysis and the SAS Campaign Studio.


Mr. Sadof has participated in the development of a data warehouse and data mart that will eventually contain over 8 billion records. His specific responsibility was to develop a SAS® Warehouse Administrator application to maintain the database as well as to extract, transform, and load the data into the warehouse which has an Oracle 8 database backend. The warehouse exploits the SAS®/Connect, SAS®/Share, and SAS®/Access features of SAS and has been implemented on the both the desktop workstation and the server for redundancy and disaster recovery purposes. This application is written in SAS version 8.2 and utilizes a series of multiple ‘RSUBMITS’ to balance the workload across CPU’s and servers to dramatically reduce the time required to load the data. This system was developed without the benefit of V9’s parallel processing capabilities and without Oracle 10g’s automatic partitioning system. Within the warehouse a series of data marts and MDDB’s have been created to help the users explore the vast amounts of data with ease. Eventually this database will be exploited with the SAS® Enterprise Miner.


In another project Mr. Sadof was responsible for the optimization of collateral model system for a large financial institution involving data cleansing, transformation, and warehousing (z/OS, SAS, COBOL, UNIX KORN shell scripts). This project involved the processing and warehousing of over 100 gigabytes of data per month. Mr. Sadof was instrumental in working with the business users to determine requirements and business rules to transform data. The system was developed primarily in SAS with IBM/OS-Utilities, UNIX shell scripting and some COBOL to speed up processing. Several unique tricks were used to overcome space limitations and process the data with pipeline parallelism to improve performance and reduce the processing time.


For Marriott Corporation Mr. Sadof created a Performance Data Profile reporting system (a decision support system). This system was developed in EIS utilizing SAS/GRAPH, MDDB cubes with drill down capability. This enabled hotel management to make better decisions concerning the opening and closing of new hotels across the nation.


Mr. Sadof has extensively used the Enterprise Guide and he has taught classes in it and used several of the other SAS vertical products which use a similar interface. Mr. Sadof is as comfortable in hard coding data steps as he is using the point and click drop down approach. His goals have always been to make it operate seamlessly and effortlessly for the end user.


Additional relevant skills:

· Presenting and leading training seminars;

· Teaching SAS programming classes using base SAS, Macro and the Enterprise Guide;

· Experience with large databases from 10 million to over 5 billion records;

· Processing large data input files via mainframe, and UNIX servers;

· Experience in mainframe JCL, UNIX KORN shell scripting, and Windows Server scripting;

· Experience in administrating Windows Server networks including Active Directory;

· Experience in integrating Microsoft Access and Oracle databases with SAS;

· Data cleaning and manipulation;

· Data presentation;

· Version control and change management utilizing various CM software including Rational Rose products such as Rational ClearCase/ClearQuest and MCM (a mainframe product);

· Experience in health statistics and maintaining health related data warehouses such as the Champus Data Integration Project.






IBM 3090 series, DEC VAX, HP 6000, Sun-Solaris, Windows Platforms



IBM z/OS, JCL, TSO/ISPF, VAX/VMS, UNIX, Sun-Solaris, Windows xx, Visual Basic, COBOL, DB2, IMS (DL/I), FORTRAN, PL/1, SPSS, SAS®, dBASE‑xx, Clipper, MS-Access.




Optum Health/United Health Care       



Consulting services toward strategic usage of SAS Data Integration in support of an implementation of the SAS Business Intelligence based reporting system and SAS marketing Automation for SAS 9 Solution. This project entailed:





·         Statistical Reporting with Enterprise Guide.

·         Development of extracts from Oracle and MySQL databases.

·         SAS Integration with Microsoft Excel.

·         Worked closely with marketing analysis team to develop marketing reports.

·         Involved the use of Oracle and MySQL databases.

·         Developed automated schedules and triggers to run production schedule.

Freddie Mac





Nutech Computer Institute


Freddie Mac




AAMC (American Association of Medical Colleges)


Freddie Mac


Marriott Corporation




Copyright © 2009, MGS Associates, Inc. website built with
Copyright © 2009, MGS Associates, Inc.
MGS Resume

Copyright © 2009, MGS Associates, Inc. web hosting provided by