Primarily focused on new Workday integration work under Administrative Systems Master Plan (ASMP). • Support Information Quest (IQ) by designing and implementing data models, ETL (extract, transform, load) processes, and related infrastructure information systems, with a focus on Workday to Institutional Data Store (IDS) integration • Conduct research and development with various tools and technologies to evaluate usefulness and applicability within IQ (XML, Oracle, DataCleaner, XSLT, Stonebranch, etc.)• Create documentation and share knowledge with other ETL and IQ team members Skills Used: Oracle, DataStage, DataCleaner, XML, Workday (Integrations, EIBs, Reports) and Stonebranch

Administer, maintain and support data de-identification process and procedures using Informatica as required for FISMA/Data Privacy. Also worked with Legacy IDMS team to convert IDMS to DB2. Continued System Analyst projects in spare time.Skills Used: TSO, JCL, COBOL, DB2, Informatica, SharePoint, Agile, VSAM, SAS, Mainframe Z/OS 390, SDLC, ScrumAccomplishments: Recoded all Informatica workflows due to time consuming and inaccurate process resulting in reduced CPU usage, more secure NPI data, identified inaccuracies, removed duplication of data elements, and inconsistencies between database tables resulting in a 1 week turnaround for masking all production data vs. original 8 weeks. Documented all workflow processes and kept statistics for each masking run using SharePoint. The new masking process resulted in improved consistency and accuracy to meet FISMA compliance, increased reliability of data masking, quicker creation of valid, masked test data for developers/quality assurance testers, and better customer service.

Development of software for mainframe projects assigned by Enterprise Project Management OfficeWork with internal and external business partners to research problem requestsExamine and correct production problemsPerform quality reviews of project deliverablesMaintenance development work: COBOL/DB2, Overlays, TSO, JCL, SharePointTechnical consulting to End Users, Project Teams and othersMainframe application support: Default Prevention, Claims, Default Recovery, Accounting, Data Reporting

Texas Department of Public Safety, Austin, Texas Programmer Analyst/Database Administrator IV • Performed logical/physical data modeling, design, data flow diagrams, creation of physical data models/data elements • Developed policies and procedures designed to ensure data integrity of the data base environment• Established documentation policies/procedures to provide detail process descriptions to aid in error resolutions• Converted all Legacy M204 applications to COBOL/DB2/CICS using TSO on Mainframe Z/OS 390 • Single handedly converted Motor Vehicle Database system from M204 to DB2 which involved researching old data elements and online processes to load all TXDOT Vehicle Title and Registration data to new layout• Responsible for all test scenarios definitions, unit testing, system testing, integation testing and UAT of all Legacy conversion processesSkills Used: TSO, JCL, COBOL, M204, DB2, CICS, VSAM, RACF, CDB, Mainframe Z/OS 390 environmentAccomplishments: Converted entire M204 Legacy System database and all its applications and processes. Responsible for large application (300 Million rows) called Motor Vehicle Registration which required communication with Texas Department of Transportation and DB2 utility load of data each week of current vehicle registrations for our historical database.

Burlington Resources/BNSF, Fort Worth, Texas Contract Programmer Analyst – Legacy Conversion Project • Analyzed all Santa Fe railroad M204 programs to identify necessary business edits for BNSF merger• Responsible for the maintenance and documentation of the Burlington Resources Authorization for Expenditure, Cost Allocation Processing, and Revenue Recognition Processing Accounting Systems coded in M204/COBOL/DB2• Responsible for identifying necessary test scenarios/test cases to test success of new business edits due to merger• Utilized strong object oriented programming skills to develop and maintain software infrastructure designed to test System Level Test (SLT) boards, systems and CPUs• Member of Smart Team – Mainframe Help DeskSkills Used: TSO, JCL, COBOL, DB2, SQL, Legacy Conversion, M204, VSAM, Mainframe Z/OS 390Accomplishments: Kept the production system running smoothly while documenting the business processes.

Westinghouse Motor Company, Round Rock, Texas Database Administrator/Programmer Analyst • Created and performed data flow diagrams, decision logic tables, and tested/validated database design• Performed design, capacity planning, monitoring, backup/recovery and installation of SQL/DS in a VM/ESA environment• Responsible for testing database software upgrades, designing, coding, testing and implementation of all database applications • Designed, coded, tested online and batch applications written in COBOL and SQL/DS • Created and documented every work process for ISO 9000 Skills Used: TSO, JCL, COBOL, SQL/DS, VSAM, ISPF, Mainframe Z/OS 390Accomplishments: Only mainframe employee in a startup company so had to quickly design/code Bill of Materials and Marketing application to prepare for business. Performed all designing, coding, testing, implementation and maintenance.

DBA consultant using Model 204.

BDM Technologies, Inc., Austin, Texas Contract DBA/Programmer/Analyst • Developed, designed, coded and installed database systems for Texas Employees Retirement System of Texas, and ORYX Energy Company using Model 204, TSO, JCL on IBM Mainframe environment Z/OS Skills Used: TSO, JCL, COBOL, DB2, M204, VSAM, Mainframe Z/OS Accomplishments: As contract DBA/ProgrammerAnalyst met contract requests on time and on budget.

M204 DBA. I designed, coded, tested, loaded, and taught user classes. I had a great career with the Texas State government. In the evenings I taught classes at Austin Community College.