Fred G Celio

Software Developer

(818)401-3202

fredcelio@fredcelio.com
PROFESSIONAL EXPERIENCE
Extensive experience in all phases of applications development including Analysis Data Base Administration, Design Programming. Testing and Implementation Extensive experience using COBOL COBOL II COBOL III MVS and OS/390 CICS JCL and Utilities TSO/ISPF C++, EPIC, File-Aid, HL-7 Syncsort Xpediter Panvalet SQL BMS DB2 IDMS IMS SPUFI QMF Intertest Integral Princeton Softech InfoMan ChangeMan Attachmate SAS, Autosys, Liberian IRMA Passport Integral Test Director etc.
Experience creating applications using Visual Basic for Applications and Visual Basic Extensive experience developing applications using SQL on relational databases.
Experience creating enhancing and maintaining ACCESS databases including designing developing and implementing databases Improving and creating reports improving and creating forms Developing Web pages attached to ACCESS databases Experience Using Unix SQL-Server and Sybase Client/Server Windows NMS OFFICE MS WORD MS Excel MS Outlook MS Project PowerPoint Visio Adobe Acrobat ASP Dreamweaver HTML Test Director.
Extensive experience writing specifications for all phases of the System Development Life Cycle SDLC using various methodologies I have written design specifications.

Exceptional Achievements

Designed, coded and implemented a complete client-server system linking multiple mainframes using CICS Advanced Program to Program Communications, resulting in major cost savings for the client in reduction of licensing fees.

Designed, coded, and implemented a complete Service Request Management system, for a government agency and later purchased by other agencies.

Designed coded and Implemented JAVA GUIs

WEBSITE Development

Designed, coded and Implemented PERL and Shell Script

 

Detailed Work Experience

QA Engineer Consultant

CTG – Torrance, CA – December 2014 to Present

 

Position: QA Engineer

I am part of a team building a Data Warehouse ETL for a healthcare customer. My role is to work on SQL Server Management Studio, stored procedures, Test Plans Test Cases, Test Execution, Defect Tracking using agile methodology; perform Unit, Functional, Systems, and End to End Testing; execute SQL Queries.

Responsibilities:

  • Involved in gathering and defining Business Rules
  • Work on Developer Facing Testing and Business Facing Testing; Automated and Manual Testing
  • Involved in Data Mapping and Data Conversion
  • Work on various subsystems including: Claims, Pharmacy, and Provider
  • Write Test Plan and client facing deliverable documents; document all test results into developer and client facing documents
  • Make Go/No Go decisions
  • Write and execute hundreds of Test Scripts using SSMS

 

  • Liaison between Business/Client, developers and Project Management; responsible for Quality Assurance Reports at various Milestones

Skills Used: SQL/Server, SQL/Server management System, .net, windows, VB, MS Office Excel, Word, DWETL

Software Consultant QA Test Lead

CHI  – Denver, CO Tacoma, WA; and Atlanta, GA Jan 2014 – Nov 2014

 

Position: Software QA Test Lead

Write test strategy, test plans, and test procedures for CHI Franciscan Health Services portion for ICD10 conversion EPIC and windows upgrades applications. Web based online applications for EPIC and windows as well as Linux/Unix.

Responsibilities:

  • Worked in an Agile environment and was involved with Daily Standups
  • Gathered and defined Business Rules
  • Wrote test strategy document
  • Developed test cases from user stories
  • Coordinated UAT between various business units
  • Executed roadrunner to insure performance tolerances were within defined
  • Work on various subsystems including: Claims, Pharmacy, Admission, In patient, Out Patient

Skills Used: UNIX, Windows, Web, APIs, Web-based applications, JIRA, HP/ALM (QC), Loadrunner, MS Office, Rational Suite, RQM, HP ALM, SVN, Tortoise, REST, PHP UNIT, JetBrains, XAMPP, ADT, ASAP, Stork, Willow, Radiant, OpTime

 

 

Wellpoint, Woodland Hills, CA 03/2012 – 01/2014
Programmer/Analyst Consultant
Medical applications

  • Design develop and implement PHP scripts for web applications, UNIX, Cobol programs MVS Mainframe environment
  • UNIX, Windows, Web, Mainframe, MVS, JCL, .net, APIs, Web-based applications, Selenium, C, C#, Data warehousing,  Billing applications for the federal government, MS Office , QTP, Loadrunner, Suite Excel, Project, PowerPoint, Rational Suite, RQM, Clear Quest, ALM QC,  PHP unit Testng using SVN, Tortosie, PHP UNIT, JetBrains, XAMPP, JIRA


ADP, San Dimas, CA
09/10-02/12 – San Dimas, Ca
Programmer/Analyst Consultant
Telecommunications applications

  • Design develop and implement cobol programs MVS Mainframe environment
  • XML and eNET conversion testing, Mainframe, LINUX, and windows, working with on shore and offshore teams. Quality  Center/ALM

Skills Used: UNIX, Windows, Web, Mainframe, MVS, JCL, Cobol, TSO/ISPF SPUFI, QMF.net, APIs, Web- based applications, Selenium, VB, C, C#, Data warehousing, MS Office Oracle QTP, Suite Excel, Project, PowerPoint, Rational Suite, RQM, ClearQuest, ALM QC, Quality Center/ALM, LINUX, UNIX, Shell scripting, Perl scripts, APIs, MVS, C#, LoadRunner, scripts, framework, white and black box

 

.

 

Kaiser, Pasadena, CA 04/2010 – 08/2011
Programmer/Analyst Consultant
Health Insurance Applications

 

  • Design develop and implement Cobol/CICS programs MVS Mainframe environment
  • SQL/SERVER, windows, web based, mainframe,
  • Mainframe, LINUX, and windows,

 

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

 

CSC, El Segundo, CA 12/2006 09/2009
Senior Technical Designer Employee

Telecommunications applications

  • Requirements Gathering and analysis
  • Design develop and implement C programs MVS Mainframe and LINUX/UNIXenvironment

Skills Used: Mainframe, MVS, JCL, C, TSO/ISPF Teradata, .net, Visual Studio, Web-based applications, C, C#, Data Warehousing, MS Office , QTP, Selenium, LoadRunner, Oracle, Suite Excel, Project, PowerPoint

 

 

Consultant Quality Assurance Engineer Lead

Union Bank  –  September 2006 to December 2006

 

I managed 2 testers and I reported directly to the Program Manager at Union bank. Responsible for test planning and scheduling including phased implementation, test procedures and defect management.

Responsibilities:

  • Charted progress and estimated all resources needed for task completion
  • Created Test Cases, Test Procedures, Test Scripts
  • Reviewed and wrote requirements individually and in technical review meetings with the client
  • Performed automated and manual testing; monitored Build and Release packages
  • Mentored Team Members; close interaction with Client Program Manager, including JAD and SCRUMS
  • Executed Scripts; performed testing and logged defects
  • Executed loadrunner for final performance testing insuring performance across platforms met Business Rules.

Skills Used: QTP, Quality Center, Selenium, Windows, Excel, Project, PowerPoint, Mantis

 

Consultant Quality Assurance Engineer Lead

Digital Insight   –   Calabasas, CA  –  May 2006 to August 2006

Responsible for one tester and another QA manger that I mentored in QA best practices. Wrote test plans including scheduling and resource management. Attended all design meetings with designers and business and marketing executives; participated in design, requirements definition, use case definition, test procedures and scripts.

Responsibilities:

  • Charted progress and estimated all resources needed for task completion
  • Designed specific testing environments; involved in System and Integration Testing
  • Evaluated design and requirements documents; registered comments with the technical staff to ensure government mandated contract compliance
  • Wrote Test Plans; designed over 100 Test Cases, Test Procedures, and Test
  • Wrote automated and manual test scripts; generated SQL Scripts
  • Performed testing and logged defects

Skills Used: C#, ASP.net, APACHE, (MDAPI), Windows, SQL Server, Selenium, Excel, Project, PowerPoint

 

 

 

Kaiser Permanente, Pasadena, CA 12/05 – 04/06
Consultant Analyst

 

  • Analyzed programs for efficiency, provided feedback to the engineering staff.
  • Developed a prototype Resource Management Entry and Reporting system using ACCESS and VB to insure contract and government mandated compliance.
  • Design develop and implement cobol programs MVS Mainframe environment

Skills Used: LMIS, Mainframe, MVS OS/390, JCL, TSO/ISPF, Cobol, CICS, DB2, SPUFI, QMF, Web, Client/Server, Distributed, DB2, SAS, File-Aid (DB2) ChangeMan, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, JCL, File-Aid, CA AutoSys, LoadRunner, Pharmacy, UNIX, Shell scripting, Windows, Excel, Project, PowerPoint, .net

 

 

Longs Drugs Pharmacy IT, Northern California 06/05 – 12/05
Consultant Programmer/ Analyst

 

  • Design develop and implement cobol programs MVS Mainframe environment
  • Designed and wrote documentation to insure federal mandated compliance as it relates to software performance for the online, IVT and automated pharmacy system including customer billing, Internet/web-based ordering and in store functions.

Skills Used: Main Frame Windows NT, Informix, MySQL, ASP, DB2, JCL, SQL, MS Word, MS Excel, Cobol, Certify, HPUX, Client-Server, Distributed, MS Project, OS/390 – MVS, Mercury Quality Center, QTP, COBOL, JAVA, LMIS, Windows suite Excel, Project, PowerPoint.

 

Transunion, Chicago, IL 12/04 – 05/05
Consultant Analyst

 

  • Design develop and implement cobol programs MVS Mainframe environment
  • Conduct comparisons using Princeton Softech, JAVA and DB2.
  • Attended and hosted JAD sessions on regression/Integration testing.

Skills Used:

Environment: Mainframe OS-390 – MVS, JCL, Finance, DB2, Rational Unified Process (RUP), Data Warehouse, QuickTestPro, Loadrunner, Shell scripts, Windows suite Excel, Project, PowerPoint, Mercury Quality Center (Test Director), QTP, Rational Clear Quest, CA Autosys, Windows, (MDAPI), JAVA.

 

Kaiser Permenante

Consultant Programmer/Analyst 03/04 – 11/04

  • Designed coded and implemented enhancements to new releases. CICS, DB2 C++ UNIX EXCEL MS Project COBOL JCL OS/390 File-Aide MS WORD Attachmate Extra etc
  • Write SQL Design Documentation

 

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

Consultant Sacramento Professional Network Facilitator 02/03 – 03/04

  • Facilitate professional classes
  • Write professional training documents
  • Creating and implementing an ACCESS databases Visual Basic Programing Windows XP


State of California Children s Welfare Service/Case management System Contract
01/01 – 01/03

Consultant Programmer/Analyst

  • Designed programmed tested and implemented fixes and enhancements to the third tier of a three tiered client/server system
  • Designed coded and implemented enhancements to new releases Datawarehouse Data Modeling Generate SQL to modify the Production Database Respond to Service Requests from all counties January

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

McClier

Consultant Data Base Administrator 01/00 – 12/00

  • Create triggers stored procedures T/SQL for an MS SQL Server database
  • Modified existing ACCESS databases Created a new database using MS Access and Visual Basic
  • Ccheduled and tracked tasks Monitored performance Data Modeling Designed web pages using HTML and ASP

California State Lottery

Consultant/Employee Programmer Analyst 11/98 – 12/99

  • Designed programmed tested documented and implemented enhancements and modifications to a financial accounting process
  • Provided support for the Client/Server systems Documented Y2K compliance of the existing client/server system
  • Attended and documented JAD sessions Created GUI front ends

Skills Used

Mainframe, MVS, JCL, SPUFI, QMF, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

 

Intel Corporation

Consultant Programmer/Analyst 03/98 – 09/98

  • Designed programmed tested implemented and documented processes for a major Data Warehouse
  • Produced Post update reports for the end user Evaluated Data Analysed results with the end users
  • Built an ACCESS model of the target database Attended led and documented JAD sessions
  • Data Modeling

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.
Data Dimensions Inc

Senior Millennium Consultant 07/97 – 01/98

  • Modified financial applications to insure Y2K compliance
  • Wrote documentation illustrating the most efficient way to convert programs for millennium compliance
  • Made Oral presentations to the end user in this case the State of California Data Modeling

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.
Kaiser Permanente

Consultant Programmer Analyst                           04/97 – 06/97

  • Maintenance and Enahncements of the Accounts Payable system
  • Production Support
  • Wrote an evaluation and complete documentation of the Accounts Payable system in support of the data center relocation

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

ALLTEL

Consultant Programmer Analyst                                       02/97 – 03/97

  • Responded to Service Requests
  • Evaluated Service Requests
  • Modified programs tested and implmented the changes for the Accounting system

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

NEC Inc

Consultant Programmer/Analyst        02/96 – 01/97

  • Designed programmed tested and implemented programs for year enhancements to the micro-chip manufacturing system
  • Created a process for a series of steps in the computerized control of the micro-chip production process
  • Data Modeling Software quality assurance specialist for several tasks
  • Wrote test plans Wrote test procedures/scripts Executed Tests Documented results
  • Wrote design specifications including pseudo code for the micro based replacement for the existing production system November

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

 

 Wells Fargo Bank

Consultant Programmer/Analyst 11/95 – 01/96

  • Defined requirements Performed requirements analysis
  • Designed coded tested and implemented processes for the calculation and posting of finance charge reversals for the bank card section of the consumer credit division
  • Designed coded tested and implmented the balance adjustment process
  • Wrote SQL Data Modeling Performed acceptance testing
  • Wrote design specifications Wrote User manuals

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

County of Sacramento

Consultant Programmer/Analyst 04/95 – 11/95

  • Designed coded tested and implemented enhancements and modifications for the Department of Human Assistance Designed
  • Coded and implemented a complete Service Request Tracking for the agency and later purchased and used by other agencies
  • Defined requirements Performed requirements analysis
  • Wrote design specifications Attended design review meetings
  • Wrote test plans and test scripts for Unit Testing
  • Wrote training documents
  • Made major modifications to an existing security system
  • Made enhancements to month end processes

 

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

UC Davis Med Center

Consultant Programmer/Analyst 10/94 – 03/95

  • Designed coded tested and implemented major and minor modifications to a large scale claims processing system
  • Designed coded tested and implemented major enhancements to the Medi-Cal and Medicaid claims processing system
  • Designed a process to update the database Data Modeling
  • Made miscellaneous modifications to several programs
  • Attended JAD sessions

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 


Kaiser Permanente

Consultant Programmer Analyst 08/93 – 09/94

  • Designed coded tested and implemented major and minor modifications to the Group Contracts System
  • Designed coded tested and implemented online and batch processes to extract data from and update the database
  • Re-designed for efficiency a large process used for membership capitated rate determination
  • Created a two-tiered client/server for the In-Vitro Fertilization Online process producing significant cost savings on licensing fees
  • Coded tested and supported the implementation of major and minor changes to programs for the KPSA medicaid product

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.


Foundation Health

Consultant Programmer/Analyst 08/92 – 06/93

  • Designed coded tested and implemented major and minor modifications to the Q/Care commercial medical insurance processing system
  • Created the pharmacy utilization reporting system
  • Also worked as a member of a team developing applications for the Century system
  • Wrote various programs for the retrieval and update of data

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.

 

Vision Service Plan

Consultant Programmer/Analyst 09/91 – 06/92

  • Designed coded tested and implemented major modifications to a large vision coverage system claims processing system
  • Participated in the design of the system
  • Wrote design documentation including a structured hierarchy and narrative description of all assigned modules
  • Wrote 4gl generated pseudo-code
  • Developed GUIs and prototypes using an Ad-Hoc screen painter

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.
Deltanet

Consultant/Employee Systems Analyst 04/89 – 09/91

  • Designed coded tested and implemented major modifications to the claims processing system
  • Designed coded tested and implemented major modifications to the accounting system
  • Designed coded tested and implemented major modifications to the billing system
  • Performed systems analysis and design duties and wrote technical design documentation for a large Management Information System in support of Delta Dental
  • Wrote sections of the successful proposal to win a large Contract with the state of California
  • Produced trade studies
  • Produced market surveys
  • Designed a repeatable regression test of the entire claims processing system Perfomred a regression test of the entire claims processing system Documented discrepancies
  • Wrote user documentation and training Manuals

Skills Used:

Mainframe, MVS, JCL, SPUFI, QMF, CICS, and Web based, Client/Server, Distributed, File-Aid(DB2), OS/390, DB2, JCL, File-Aid, Changeman, SAS, Mercury Suite including Quality Center (Test Director), QTP, C++, COBOL, Loadrunner, UNIX, Shell scripting, Windows.
PROFESSIONAL CLASSES
Data Communications Systems Network Architecture OSI seven Layer Communications Standards for Distributed Systems IEEE standards and Ethernet LANs C Programming Client/Server Web Development Visual Basic 6.0 Windows NT MS Project MS ACCESS

PUBLICATIONS
Various Market Surveys Various National and State Government Proposals Design and Recommendation of a Local Area Network White Paper on the AFTAC Communications System XENEX Programming Standards Manual

EDUCATION
B.A San Jose State University

Graduate Studies

  • San Jose State University
  • Sacramento State University
  • University of Southern California