OBJECTIVE:

• I would like to continue working in the Information Systems field and to utilize my mathematical, programming and business background. I would prefer a position programming, developing, doing business and data analysis, data gathering, statistics, data research, and evaluation of results in any business. I would like to continue using my programming/analysis skills to achieve this type of work.

SUMMARY:

• I have insurance business knowledge, actuarial experience, and statistical reporting background. I have 30+ years of programming, systems analysis, and data analysis experience on mainframe systems. I have extensive experience in requirements gathering, including translating business needs into systems functions and processes. I possess excellent analytical skills and experience with process improvements and requirements documentation. I have strong analytical, mathematical, research, problem - solving and trouble-shooting skills. I have experience in mainframe development using COBOL, PLI, SAS, and EZTRIEVE.
• And working with tools such as QMF, EXCEL, Access, SQL, some Crystal Reporting and some C++. I have a total of 8 years experience programming COBOL and PLI and 20 years in EZTRIEVE working on development projects and maintaining Production systems. I have Lead systems analyst experience managing small programming project teams and 25 years of ad hoc type data extraction and reporting. I have 20+ years of Business Analysis and Property and Casualty experience. I also have business knowledge of Insurance claims procedures and Underwriting concepts. I have 10 years of Marketing experience and 15+ years of Actuary Analysis support experience. Experience with Bank Mortgage data and SQL Development. 25+ years of Business Analysis and reporting.

TECHNICAL SKILLS:

OTHER COMPUTER KNOWLEDGE/SKILLS: Extensive experience in requirement gathering, evaluation and data analysis Some knowledge of dimensional modeling Knowledge of AGILE Methodology, CICS Experience in all phases of software development and testing Extensive experience with MAINFRAME IBM, TSO, ISPF, JCL, FTP, REXX, NDM, CMM, Control - M, FILEAID, Starbat, NDM, VSAM, DB2, COBOL, PLI, EZTRIEVE, SYNCSORT, IMS, COMPARE, and XPEDITER Experience with ASSEMBLER and RPG (about 3 years) Experience designing test cases, scripts (about 3 years) Understanding of test strategies, defect life cycles, and testing metrics Working knowledge of C++, VB, and SHAREPOINT, Visual Studio, Business Object tools, Crystal Reports Experience with SCM, MDM, Starteam, and SDLC/STLC Use of Outlook, Powerpoint, MS Office, and MS Word Experience with SAS, SAS Enterprise Experience with EXCEL and working knowledge of MS ACCESS Familiar with R and Teradata data management Experience working with various databases using SQL, SSIS, SSRS, UAT and SQL SERVER 2008 R2/ 2012 R2 Working knowledge of APEX

PROFESSIONAL EXPERIENCE:

Confidential - San Antonio, Texas

IT Systems Analyst

Responsibilities:

• I worked as a Systems Analyst documenting a Performance and Analytical Reports System that produces reports for Member Support Representative managers at Confidential . I documented the data bases using the IBM InfoSphere which is a documentation tool that does Data Governance and Information Analysis.
• Used SQL to Query databases for Data Quality and Analysis and to help solve isuues on our Reporting System. Used Aginity to query our Datamarts with SQL queries.

Confidential - San Antonio, Texas

Operations Business Analyst

Responsibilities:

• I worked as a Business Analyst supporting the Contract team at Oracle with statistical reporting to help control sales work and international contracts for all lines of businesses at Oracle. Reports were on APEX and also EXCEL reports and spreadsheets. I also used SQL to extract data for our reporting system and to created reporting for our clients.

Confidential - San Antonio, Texas

Financial Analyst Contractor

Responsibilities:

• I worked as a Financial Analyst creating reports for the Operational Department using Excel and SQL. Also providing data analysis on current clinical data. I am gathering requirements for new reports and maintaining a current Clinical Survey system. Used pivot table and V-lookups and extensive Excel usage.

Confidential - San Antonio, Texas

Analytical Consultant/SQL Developer

Responsibilities:

• I worked in the Home Preservation Department as a Business Analyst, Systems Analyst and SQL Programmer/Developer creating reports for various teams in the Mortgage department. Most of my work was gathering business requirements, creating Business requirements, documentation, doing the Systems analysis, creating the SQL code to produce the reports and validating results. Production and Ad hoc reports were created using SQL and SSRS on SQL SERVER 2012 R2. Also worked with VB scripting. I also researched problems with existing reports and modified, documented, and tested any changes or improvements.

Confidential - San Antonio, Texas

Support Analyst /Programmer

Responsibilities:

• I performed the role of a Business Systems Analyst and Reporting Analyst on the Actuary Department. I was the SME on Premium and Loss Data for the Department and produced data used for various actuarial decisions. I worked with the actuaries to create and maintain a documentation tool for the data used in the department. In this position I also researched data sources for valid information. Most of my work was on the mainframe using EZTRIEVE, COBOL, DB2, JCL, VSAM, various mainframe testing utilities, and SAS. I coded programs in COBOL to help validate mainframe data against Actuary SQL databases and ACCESS databases. I also used SQL on SQL databases and some experience with SAS Enterprise.

Confidential - San Antonio, Texas

IT Systems Analyst /Programmer

Responsibilities:

• I performed the role of a Business Systems Analyst on the Marketing Performance Data Warehouse Project. On this project I worked gathering the business requirements for Member data. During this project we used the Agile development methodology. I determined the requirements mainly from the analysis of the current Marketing
• Data Mart SAS programs and from the individual SMEs from the various marketing areas. Based on my business knowledge and programming skills I created the Logical requirements for the Developers use in coding. I worked closely with the IT analysts and I also helped validate, testing, creating test scripts, and reconcile the resulting data. Before this project I was primarily working as an IT support systems programmer analyst in the IT Market Support area. I worked on process improvements to the Marketing Systems. I supported various SAS systems, including the MDM system that provides data and data analysis for the P&C, Life, Investing, and Bank Marketing companies. Also continued to work on COBOL application systems doing maintenance and data extracting and using mainframe tools like JCL, DB2, IMS, VSAM, EZTRIEVE, FTP, ISPF, and SAS.

Confidential - San Antonio, Texas

Senior Business Technology Analyst /Programmer

Responsibilities:

• Primarily continued doing Ad hoc reporting work, but outside of the information systems area. I worked directly with the Actuary department providing data for various actuarial decisions including insurance rates. Developed several application systems in COBOL EZTRIEVE, SAS,, and SQL for Statistical reporting and for extracting data from flat files, VSAM files, and IMS. Used JCL, FTP, ISPF, FILEAID, and DB2 databases. I was the data source expert for the company and supported 40+ users in various business areas for 6 years. This support included resolving business needs thru computer solutions. Consulted with the user, gathered business requirements, and implemented the requirements with the other programmers on the team to create the needed systems. I provided data and analysis support to the Marketing Analysts in the company primarily thru SAS databases and SAS files.

Confidential - San Antonio, Texas

Lead Systems Analyst /Programmer

Responsibilities:

• Was the Lead Systems Analyst for the Confidential Ad hoc Reporting team and lead 3 other programmers. My role was to continue supplementing the business areas of Confidential with data and system support. I was the provider of information for all State Regulatory Compliance reports. I supported several IT Applications as a Programmer coding in COBOL, PLI, and EZTRIEVE. Using JCL, FTP, FILEAID, and various testing utilities. I also supported several ASSEMBLER systems that were being converted to the COBOL language. We coded and tested all the new code.

Confidential - San Antonio, Texas

System Programmer/ Analyst

Responsibilities:

• I worked as an Application Programmer/Analyst in various Information Systems teams doing development and maintenance work. I worked with COBOL, PL1, EZTRIEVE, VSAM, ISAM, IMS databases, and DB2 databases. I was a Team Leader on various projects and was responsible for the programmer on these projects. I worked as the data SME for the company doing Ad hoc reporting. This included requirements gathering, creating data analysis reports and creating data files for the Banking, Marketing, Life Insurance, Underwriting, Regulatory Compliance, and Actuarial areas in the company.