SUMMARY

Confidential goal is not to hire coders. IBM believes in hiring talented people which the company will provide the environment and opportunity for them to learn the technical skills and tools to become experienced and highly proficient Programmer Analysts, capable of handling System Develop Life Cycles Frank Brown IT Manager. It has been the acceptance and practice in what Frank Brown shared so many years ago that has led to my continued and successful career as an Information Technology professional working in mainframe, UNIX, client server and open system environments as a Senior Software Developer, Team Leader, and Manager for companies such as The Methodist Hospital, Lincoln Life and Health Insurance, State Farm Insurance, IBM, EDS, MCI, Duke Energy, Ashland Oil, Exxon Mobil, Toyota Manufacturing, INFODATA and The Nielsen Company. Additionally, I worked as contractor for Federal Agencies which included Department of Treasury, Education, Social Security and Bureau of Labor and Statistics.

EXPERTISE and CORE COMPETENCIES

• Database Skills
• ADABAS, DB2, EXCEL macros, vLookup, Pivot Tables , IMS DC-DLI , INFODATA, MSACCESS, MSWORK, Oracle
• Operating System Skills
• Client Server, LAN, OS/MVS/XA/E, System 36, 88, 370, 390 , Solaris, Windows 95, 98, 2000, XP , UNIX
• Other Skills
• Abend Aid, Expeditor, File Processing Direct, Indexed, Keyed, Random, Sequential , IDCAM, ISAM, SQL, Rapid SQL, Job Control Language JCL , IBM Utilities, ISPF, Panvelet, TSO, VSAM, Adobe Suite, Acrobat Reader, Power Point, Word, SQL Server, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS and SQL Server Analysis Services SSAS
• Software Skills
• Assembler, Cobol, PL 1, C and G , Natural, Visual Basic, Visual Basic Application VBA
• Java J2EE-mainframe/Unix-Applet-Bean-JPS-Mail-Servlets-Soap/WSDL-Struts
• SAS-MVS/UNIX/Windows Base-Connect-Graph-Macros-Procs-Stat . Version upgrades.
• CLIST, Easytrieve, HTML, PHP Script, Java Script, REXX, XML
• Business Intelligence tools in concert with SAS Enterprise Guide.

EMPLOYMENT HISTORY

Confidential

Business Intelligence Specialist

• Design and code SAS v9/ Enterprise Guide programs in concert with Business Intelligence tools, gathers, validates, maintains, analyzes, and manipulates data used in decision and reporting processes to support Network Health Plan, plan sponsors, and plan providers which impacts decisions, activities, and processes in Finance, Group Administration, Claims, Sales, Quality Improvement, and Care Management departments. In concert with SAS the position requires knowledge and utilization of a variety of methods and tools such as Output Delivery System, MS EXCEL and ACCESS to develop and document reports and processes that support ongoing activity or ad hoc requests. The position requires interpretation of data, identification of trends, establishment of benchmark data, and presentation of information to customers in clear, concise, and useful formats, including data visualizations and interpretation of information. The position calls for working knowledge of Confidential Healthcare Effectiveness Data and Information Set, as well as, Confidential codes. Finally, I volunteer as a Rapid Improvement Event facilitator, one to three day department driven projects, which provide the opportunity to utilize my Project Management interest.

Confidential

Employee Application Analyst III

• Designed and coded mainframe applications using COBOL and SAS v9/base/macros for a Payroll, Human Resources and Wellness Biometric system for staff employees, physicians, resident, faculty and patients. Designed a PHP web based application, setup and configured Apache HTTP server and Windows Application server. Automated Houston Methodist's internal Nursing Report system used by the hospital Confidential in his report to Nursing Boards. The manual process required several hours to complete by a single Application Analyst. One benefit to automating this process resulted in the Application Analyst being able to learn additional applications.
• Designed and implemented Wellness PHP web based Data Interface system for United Health Care
• Designed and implemented SAS/VBA Insurance Eligibility Interface system for Consova
• Designed and implemented SAS/VBA TMHS-WebMD Employer and Reseller FTP Interface Applications
• Produced year end HIPPA certificates and W2 Forms
• Other responsibilities include managing IT Projects, providing on time deliverables and status reports to area IT Director.

Confidential

IT Consultant

• This was a short term contract assignment with a Mail Marking firm which required that I sign a non-disclosure agreement. Developed mainframe applications using PL/1-DB2, SAS/base/connect DB2 , and extracted mainframe host data stored on DB2 tables and SQL to created data models and maps which were used by Marketing Department. Other responsibilities include managing IT Projects, providing on time deliverables and status reports to manager and users.

Confidential

IT Consultant

• This was a short term contract assignment with a Private Home Security firm which required that I sign a non-disclosure agreement. I developed Personal Computer and mainframe based SAS applications to produce forecast predictive reports used by the company to identify potential high crime neighborhoods. The forecast predictive reports assisted the Marketing department in its campaign and promotion efforts.

Confidential

Sr. Software Developer

• My proudest accomplishments while employed at The Confidential were a PL/1 Fixed Decimal Overflow and SV7Q Card SAS/Java/JZOS interface projects for which I received an Employee Peer Recognition award. In response to IBM's release of its new Enterprise PL/1 compiler PL/1 programs were scanned for variables defined as Fixed Decimal data to ensure they were defined appropriately to prevent programs from abending with a Fixed Decimal Overflow exception. The SV7Q Card SAS/Java/JZOS interface project required a bridge between the JZOS UNIX Data Warehouse and MVS mainframe environments which had not been performed prior to this project. Both of these efforts proved valuable in that technical resources and man hours were saved because possible system interruptions were identified and adverted.
• Saved resource man hours by negotiating SAS license renewal agreements .This was achieved through gathering, trouble shooting and reporting SAS software issues, working directly with System
• Developed OS/MVS applications using SAS v9/base/macros/connect/DB2-SQL and MS SQL mainframe host data was extracted to produce data models, maps and generate forecast reports which assisted our clients in targeting their advertising campaign revenue. Recommended and implemented source code changes to several of the Common Ant Builds that were used to compile and maintain Java/J2EE classes for our web base reporting applications and other Enterprise Processing functions.

Confidential

IT Contractor

• Developed mainframe applications using PL/1, COBOL II, SAS/base/connect /DB2-SQL/Macros, SQL and Confidential to create forecast reports for Engineering Analysts. Created sequential files which were FTPed to a workstation, imported text files were used in predefined file specifications stored in MSACESS tables. VBA programs read the MSACCESS tables as input, built RECORDSETS using DAO processing and performed inserts or updates to a Microsoft SQL server databases.

Confidential

IT Contractor

• This was a short term contract assignment which required that I sign a non-disclosure agreement. Utilized SAS/Data/Merge/Format/Freq/Means/Stat/Report Procs to develop statistical analysis and forecasting reports use by the company's Marketing and Sales Departments.

Confidential

IT Contractor

• This was a short term contract assignment which required that I sign a non-disclosure agreement. Worked on quarter releases to enhance and upgrade SAS/base/connect/DB2-SQL, COBOL II/DB2 applications and developed statistical analysis and forecasting reports used by the Life and Benefits Policy departments.

Confidential

IT Contractor

• Employed as a Team Leader, gave over site to several programmer analysts for Confidential Clean Management remediation project whose duties included scanning mainframe and PC generated PL/1 and COBOL II code to ensure all dates were Y2K compliant. Additionally, I developed weekly progress reports using SAS and/or Visual Basic Application to track and monitor code defects. This greatly assisted our efforts because it prevented duplication as it related to scanning source modules.

Confidential

IT Contractor

• This was a short term contract assignment which required that I sign a non-disclosure agreement. Developed mainframe applications using, PL/1, COBOL II batch CICS online and Assembler applications, and developed statistical reports using SAS. The reports were used by the Finance and Billing Department.

Confidential

IT Contractor

• Developed mainframe applications using PL/1, Cobol II, SAS/Base/Connect/DB2/IMS. Created sequential files which were FTPed File Transfer to a workstation in ASCII format , imported text files were used in predefined file specifications stored in MSACESS tables. Visual Basic Application programs read the MSACCESS tables as input, built Confidential using DAO processing and performed inserts or updates to a Microsoft SQL server databases.

Confidential

IT Contractor

• Developed mainframe applications using COBOL II /CICS for an Arrest Processing System used by local, county, and state law enforcement agencies, and created statistical reports using SAS and/or Visual Basic Application.

Confidential

IT Contractor

• Maintained and developed mainframe applications using, PL/1, COBOL II /CICS and Assembler.

Confidential

IT Contractor

• Maintained and developed mainframe applications using PL/1-IMS and PL/1-DB2 to update data on DB2 and IMS databases.

Confidential

IT Contractor

• Maintained and developed mainframe applications using PL/1-IMS and PL/1-DB2 to update data on DB2 and IMS databases.

Confidential

IT Contractor

• Developed PL/1, SAS, and Assembly programs for a mail marketing campaign database which contained information regarding prospects and purchasers. The system allows for many other corporate wide uses, such as advertising monitoring, sales projections, and response lead/lag time analysis.

Confidential

Sr. Programmer Analyst

• Developed PL/1 and COBOL programs for an Info Data Inquire Text database, Dialogue Management systems prepared status reports for team lead.

Confidential

IT Contractor

• Developed PL/1 and COBOL programs for Bureau of Labor and Statistics. Programs were developed to produce batch reports, update data on VSAM files. Created adhoc programs using PL/1 or SAS, created JCL test and production job streams, assisted junior level programmers in developing programs and resolving technical issues.

Confidential

IT Contractor

• Developed PL/1, COBOL and SAS programs for the U. S Treasury Department's Time and Attendance records system in OS/MVS and UNIX environment.

Confidential

IT Contractor

• Maintained and created PL/1 programs for Call Forwarding system, operated on System/88 machine.

Confidential

Sr. Programmer Analyst

• Coordinated SAS license renewals. By gathering, trouble shooting and reporting SAS software issues, working directly with System Support and the SAS Institute suitable resolutions were agreed upon. Developed an online menu driven test system for Confidential billing network using, PL/1, SAS, CLIST, JCL, VSAM files. The position required after hours on call responsibility. Applied software changes to the front end production traffic editor a PL/1 application which converts Binary Coded Decimal data in EBCDIC. Down stream COBOL programs utilize the output to assist MCI billing systems in generating customer invoices. Developed applications written in COBOL, Natural/ADABAS, SAS and Visual Basic Application. The position also requires rotational primary On-Call Production support.

Confidential

Sr. Programmer Analyst

• Developed an online menu driven invoice accounting system used to process credit and charges for customers, produce hardcopy micrographics and invoices for customers. Modified PL/G PC application to provide end users a way of processing applications for low income rental properties. The position required after hours on call responsibility. Also developed software using, PL1, SAS, Easytrieve Plus, Basic, Oracle, COBOL and Assembler in OS/MVS and UNIX environment.

Confidential

Sr. Programer Analyst

• Developed a monthly Pre-ship supplier vendor reporting system using, PL/1, JCL. Wrote system modification requests for end users to be submitted to the Information System Department. Provided interface between end users and technical consultants. Developed a Distribution Switch Data base using, PL1/IMS-DC/DLI and JCL. Developed test data bases, extracted data from production data bases and loaded the test database. Created IMS PSB program status blocks and PCB program control blocks . Created IMS include member declarations and PL/1 source module declarations.