Frances Collins Email and Phone Number

As Senior Data Warehouse Analyst:• Identified and analyzed changes to the Credit Loss End User Computing (EUC) programs.• Executed the Credit Loss EUC and perform reconciliation to the sources of the data.• Maintained Credit Loss EUC programs.• Performed User Acceptance Testing (UAT) for the Extract, Transform and Load on tables in the Corporate Data Warehouse (CDW) owned by the Credit Loss Business Area.• Worked to identify the Critical Data Elements (CDEs) for Single Family Financial Accounting.• Provided analysis support to Non-Performing Loans Applications.• Analyzed programs that extract and load the CDEs written in COBOL, Java, C+, UNIX Shell, SAS, SQL, SQR, SQC, and IBM JCL.

As Data Architect:• Lead the effort to develop integrated data map for MSOF control applications in support of Mortgage Operations Redesign initiatives and MSOF onFIRE initiatives.• Served as domain liaison to data and data related efforts to ensure requirements and feedback are timely, accurate, and complete regarding data needs related to Mortgage Operations Redesign.• Supported data analysis for MSOF Control as it related to the Mortgage Operations Redesign.• Assisted MSOF Control Domain with data analysis to support tactical and redesign efforts including support in MSOF requirements and impacts through the MSOF Operations Redesign efforts.• Performed Technical SQL, data mining, metadata tracing, and data mapping.

As Associate:• Responsible for design, documentation, and guiding the use of data and database changes for complex, enterprise-wide databases and data warehouse integration.• Analyzed the needs and requirements of existing and proposed systems and developing technical, structural, and organizational specifications.• Created standards and performed modeling to monitor and enhance capacity and performance.• Developed specifications and designs, including access methods, access time, job control language, statistical methodologies, device allocation, validation checks, protection, and security.• Responsible for maintenance and enhancement of the technical aspects of database and data warehouse systems.

Project: Integration Support Contract for the Internal Revenue ServiceAs Data Architect:• Responsible for the design, documentation, and performance of an initially sixteen terabyte Enterprise Data Warehouse for the Custodial Accounting Project for the IRS. The data warehouse operates on an IBM mainframe using DB2. The data mart operates on a Sun using Oracle. Performance analysis is done using DB2 Estimator from IBM.• Interfaced with the customer, the Chief Financial Office, and the Information Systems Branch of the IRS. Prepared and presented briefings as needed on the project and the data warehouse.• Participated in the design of the system for documentation in the performance model and to ensure that the data warehouse is designed for the best performance for a very large database.Project: Identification Tasking and Networking Segment of the Integrated Automated Fingerprint Identification System for the Criminal Justice Information Services Division of the Federal Bureau of Investigation April 1994 - September 1997 as Principal Computer Engineer - Associate ManagerProject: Advanced Weather Interactive Processing System January 1994 - April 1994 as Principal Systems Analyst Associate ManagerProject: Proposal/Component Integration Demonstration Team for ITN/FBI Segment of IAFIS May 1993 - December 1993 as Principal Systems Analyst Associate ManagerProject: Personnel Records Management System January 1992 - May 1993 as Principal Systems Analyst - Associate ManagerProject: Scitex, LTD (Israel) August 1989 - December 1991 as Principal Systems AnalystProject: Defense Logistics Services Corporation Live Test Demonstration February 1989 - August 1989 as Senior Systems AnalystProject: classified April 1987 - February 1989 as Systems Application Specialist

Project: Applicant Violator System (AVS) for the Office of Surface Mining Reclamation and Enforcement (OSMRE) in the Department of the Interior (DOI)Project: Office of Child Support Enforcement (OCSE) tasks under SMC's General Services Administration (GSA Capital Region) contract.

• Assisted in the quality assurance of a CCA product, TEXT/204. Tested the functions of the new product and logged, reported, tracked problems, and interfaced with the developers.• Previously assigned to Seawatch III project, providing technical support for the development phase of this classified system. Provided support for the programmers in the use of Model 204.