Kristopher Catton Email & Phone Number

State Of Michigan, Lansing

Client: State of Michigan, Department of Health and Human Services (DHHS) Create a SharePoint a site to aid project collaboration across multiple project management offices and organize unstructured content for the Systems Integration Administration (SIA) within DHHS.• Lead requirement gathering sessions for the SharePoint site structure and content.• Create sites for program management offices. • Create graphics for user interface and navigation.• Create lists and libraries that share meta data and content types.• Utilize jQuery, JavaScript, and JSON to create custom enhancements on sites for aesthetics and ease of use.• Identify meta data to improve the organization of unstructured data and manage content consistently across all PMOs.• Lead requirement sessions for SharePoint workflows. • Develop SharePoint workflows using SharePoint Designer to improve document management and process efficiency. • Implement SharePoint security structure to ensure appropriate use and dissemination of information.• Train and educate users on SharePoint functionality, use of search capabilities and collaboration.Senior Business Analyst January 2014 to October 2015Dewpoint Inc., Lansing, MI Client: State of Michigan, Department of Community Health• Configured IBM JAZZ Requirements Manager to track program and project requirements for the State of Michigan Affordable Care Act releases.• Configured IBM Quality Manager to track testing of requirements for the State of Michigan Affordable Care Act releases.• Developed meta data attributes in IBM JAZZ to allow requirements traceability.• Gathered and managed requirements for Release 4 of the Medicaid Compliance Program.• Developed requirements for the Case Management System to manage Adult Home Health clients.• Maintained Access databases for building test cases for the Medicaid Compliance Program, FOIA request tracking and longevity awards for DHHS.

Client: Treasury Department, Credit Risk and LiquidityData acquisition and analysis to manage and mitigate credit risk for GE Treasury• Created the data dictionary for liquidity and credit risk data.• Developed the data mapping and transformation documents for credit risk sources.• Developed the Business Information Model and the Canonical data model for SWIFT transactions. • Reduced 28 sources of option pricing data to one master data source.• Created counterparty master data.• Member of the GE Treasury data council.

Developed data management strategies, data warehouse structures, and integration process for the implementation of the SAP Human Capital Management (SAP/HCM) module and the Kuali finanacial system. • Analyzed Cognos Enterprise Planning (EP) application data and developed requirements for integrating data into the data warehouse for the following applications: Unit Budget Planning, Fringe Benefits, Base Budget Reconciliation, Salary and Wage Allocation, Revenue Based Initiatives, Research Facilitation, and Off Campus Credit.• Developed the star schema dimensional data models for reporting and analytics for the Office of Planning and Budgets (OPB).• Developed Oracle SQL and PL/SQL data queries on Cognos EP data structures, Kuali Financial System relational structures, HR data derived from SAP/HCM and the dimensional data stored in the MSU dimensional data warehouse (MSUDIM).• Analyzed OPB data transformations found in Excel spreadsheets and the Access database used in the union and non-union raise processes to design more efficient processes using IBM Datastage, Oracle, UC4 and Cognos EP import tables.• Developed the UC4 jobs that update the operational data store and the data warehouse.• Developed IBM Datastage ETL jobs to integrate data from the Kuali Financial System, SAP/HCM and OPB into the star schema dimensional model in MSUDIM.• Developed IBM Datastage ETL jobs for loading OPB data repositories in the MSU data warehouse.• Worked with Office of Planning and Budget personnel to develop annual data warehouse objectives.• Developed the project schedule and managed the project tasks for integrating OPB data into the datamart.• Managed the ETL development tasks/workload to load the OPB operational data store and the OPB dimensional model in the data warehouse.• Developed an MSU enterprise wide data stewardship matrix.• Presented MSU’s Enterprise Information Stewardship initiative at the Data Governance Conference in San Diego, CA.

Oregon Medicaid Implementation. Responsible for gathering requirements by leading discovery sessions and meeting with individuals at the Oregon Department of Human Services. Analyzing current business process flows. Changing business process flows to improve efficiency and working with clients to prepare for the new MMIS system. Environment: SEI/CMM Level V, UNIX, C, SQL.Completed new voucher business flow for the departments of Mental Health, Community Based Care, People with Disabilities, and Long Term Care for seniors. Designed new voucher forms to meet HIPAA requirements. Standardized incoming document handling procedures whether by mail, fax, voice or internet.Subject Matter Expert:Sybase Gateways: GM's Global Purchasing System. Environment: SEI/CMM Level V, MVS/SNA, DB2, CICS, C, UNIX, Cron scheduler, UNIX Scripts, Sybase Gateway 12.0, MDI Gateway; As part of the Lansing Solution Centre, was first to achieve SEI/CMM level V for process maturity in EDS. Maintained 24/7gateway availability for 2500 GM purchasing agents and their worldwide business partners ensuring access to high quality parts at the lowest cost. Managed gateway software upgrades including the creation of test plans and project schedules to ensure compatibility with current technology thus ensuring 24/7 access.Collaborated in the planning and participated in the design and execution of a disaster recovery plan to proactively reduce the negative impacts of a disaster. Reduced costs by training offshore personal and moving support offshore. Improved availability through the development of automatic test and restart procedures.

Responsible for analyzing the impact of changes proposed by the client, assessing the risks for the project, designing and then developing the proposed changes. Environment: VSAM, JCL, Cobol,Performed risk assessment and mitigated risks which brought project back on schedule.Analyzed system to determine specifications for new vehicle designations.Automated Licensing System for the state of Michigan. Responsible for gathering requirements from the customer, writing technical designs, construction, testing, implementation and trouble shooting. Environment: SQL Server, C++.

Massachusetts Medicaid Implementation. Responsible for gathering requirements during gap analysis between EDS core systems and the requirements for the claims adjudication and pricing sub system. Environment: SEI/CMM Level III, UNIX, C, SQL, UNIX Scripts.Completed requirements and documentation of change controls.Michigan Department of Education. Responsible for supporting and enhancing the Michigan Education Assessment Program (MEAP). MEAP is a statewide program designed to test student academic achievement. Environment: SQL Server, Stored Procedures, ASP, Java and Java Script. Designed and implemented enhancements to student demographic error reporting.Improved data quality by resolving student demographic discrepancies and researched data integrity issues. Pennsylvania Title XIX. Responsible for designing, coding and testing functions for processing claims. Environment: UNIX, C, UNIX Scripts.Reduced code development time by implementing procedures to create code locally and port tested code to UNIX environment.Reduced development time through modular design and reusable code.Improved consistency of work products by implementing mature SEI CMM Level III processes.Medicare claims processing. Participated in the Healthcare Integrated General Ledger Accounting System (HIGLAS) project to implement a standardized financial management system that complies with federally mandated HIPAA requirements. Environment: MVS/TSO, DB2, JCL, Cobol, Assembler.Implemented EDI ANSI x12 standards for the explanation of benefits sent to recipients of Medicare services.

MVS\DB2 application support for GM's Customer Satisfaction Information systemEnvironment: MVS Mainframe, DB2, SQL, EasytrievePlanned and implemented table resizing procedures to allow for expected growth of application data and improve database efficiency. Reduced response time by analyzing SQL queries and adding indexes where appropriate.Developed archive procedures to reduce storage space necessary for the database and reduce data retrieval response time. Applications Database Administrator for Sybase to Oracle 9i conversion: Signature Flight Fuel Systems in Florida. Environment: Unix 6.0, Cron, Oracle 9i. Ensured data integrity by implementing data constraints.Synchornized data across multiple tables improving data integrity.Altered tables to accommodate relational integrity and new functionality.Added indexes to improve processing efficiency, reduce response time and improve customer satisfaction. DB2\UDB development environment for GM's Global Purchasing System developers.Installed DB2\UDB database in Windows NT development environment making the test environment more robust and secure.Converted XDB data to UDB data allowing the test environment access to regression test data improving system tests and improving development results by reducing defects earlier in the development cycle. Project Leadership; Responsible for maintaining and supporting IDMS applications used by GM and their retailing business partners. Environment: MVS/TSO, JCL, IDMS, Cobol.Updated processes for three applications to meet SEI/CMM Level III standards improving efficiency through process maturity. Developed detailed requirements with customers for enhancements to ensure sales results matched sales regions.Managed enhancement projects and workload assignments ensuring the development staff met deadlines.

Enhanced and supported a manufacturing and parts distribution system for General Motors. PSIC was based on an IMS database and used PL1 as the primary programming language. Other languages included COBOL and ALC. The system was used by GM and its manufacturing plants.

Implemented the EDP Audit function for the corporation. Information Technology and physical audit procedures were designed and implemented to ensure data access by appropriate personnel and data integrity was maintained, reduced the impact in the event of a disaster and improve data security and awareness. A corporate wide risk assessment was planned and conducted for physical and data security. As the EDP Audit Specialist, I also acted as a liaison between the audit staff and the board or directors on technology issues and prepared reports and gathered data for the external auditors. Audits performed:CA-Top secret access security auditDisaster Recovery Plan auditIS system development methodology auditTape processing audit for bank transactionsAudit Programs to detect fraud, waste, and abuse:Statistical sampling method for the compliance auditors to pull claims for review when visiting a dental officeHigh dollar earnings report based on 1099 data

Project Management

M.B.A, 2005

B.S.N.R, Forest Management/Forest Resources Management

Associate, Biology

Activities and Societies: Soccer Team Captain