Fred Celio

QA Engineer Consultant

 

Los Angeles, CA fredcelio@fredcelio.com – 18184013202

 

  • Extensive experience on software development teams on many different contract opportunities specializing in all aspects of software testing, design, development, and analysis
  • Testing experience includes white, grey and black box; unit, systems, acceptance, integration, interface, UAT, end to end, and regression
  • Extensive experience writing design specifications, requirements, business rules, test plans, test cases, test scenarios, use cases, feature description, user stories, and test procedures(scripts) for all phases of the System Development Life Cycle (SDLC) using various structured methodologies, including agile
  • Experience with an array of automated test tools including the mercury/HP Rational(IBM), JIRA suites across platforms and languages that include VB, Java, C, C++, C#
  • Gather Business Requirements, write business documentation and white papers, conduct, and facilitate presentations, perform requirements analysis
  • Perform Test Script execution including first pass, regression, integration, end to end, UAT and product level across platforms, operating systems, and target languages
  • Manual test execution and development and execution of automated test suites
  • Reporting and tracking of defects and assurance of defect removal
  • Performed lead QA function in gathering and analyzing recruitments for a major government mandated change to pharmacy reporting form Medicare plan D for Longs Pharmacy
  • Worked for the State of California Children’s Welfare Service on a short term contract responsible for ongoing acceptance testing of the CWS/CMS
  • Worked as a DBA; created triggers, stored procedures, and shell scripts, T/SQL for an MS SQL Server database and UNIX

Willing to relocate to: Ireland, NS

 

 

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(scripts) and stored procedures.

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, Visual Studio, Stored procedures, 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), MS Office, SVN, Tortoise, REST, PHP UNIT, JetBrains, XAMPP, ADT, ASAP, Stork, Willow, Radiant, OpTime

 

Software Consultant QA Test Lead

Wellpoint   –   Woodland Hills, CA  –  March 2012 to January 2014

I was responsible for testing multiple projects including claims, HL7 transmission, ICD9-10 conversion, membership, benefits, and providers; this included all aspects of test planning and execution. My role was to contribute to the development of the testing framework, attend daily scrums leading two offshore teams, attend design review meetings, gather requirements, write test plans, assign resources, review test cases(scripts), write test cases(scripts), execute test cases (scripts), and preside at daily defect triage meetings.

Responsibilities:

  • Involved in System Integration Testing and End to End through to handoff to UAT
  • Work on various subsystems including: Claims, Pharmacy, Membership, Hl7, ICD9, ICD10, Benefits, Provider
  • Performed Unit Testing of web application for discrepancies; performed automated and manual testing using ALM, QTP, Rational Tool Suite
  • Reviewed and wrote Requirements; generated SQL scripts
  • Performed tests and logged defects
  • Performed final performance testing insuring performance requirements were within defined tolerances
  • Validated multiple reports, including multi-product and usage invoice

Skills Used: UNIX, Windows, Mainframe, MVS, JCL, TSO/ISPF, Cobol, SPUFI, QMF.net, APIs, Selenium, VB, C, C#, Data Warehousing, MS Office, QTP/UFT, Excel, MS Project, PowerPoint, Rational Suite, RQM, ClearQuest, Test Quality Center/ALM, ALM QC, SVN, Tortoise, REST, PHP UNIT, JetBrains, XAMPP

Consultant QA Analyst

ADP – San Dimas, CA – September 2010 to February 2012 Sep

 

Position: QA Analyst

Wrote test plans; designed, wrote and executed test cases (scripts) for multiple feeds from businesses transmitted to government agencies; worked with onshore and offshore teams.

Responsibilities:

  • Financial, Tax, and Payroll Applications
  • Performed System Integration Testing and End to End Testing following SDLC methodology; performed automated and manual Testing using QTP, record, and playback scripts, frameworks, record, and playback
  • Reviewed and wrote Requirements; wrote Test Cases
  • Executed Test Cases and logged and tracked defects
  • Attended design reviews; interacted with development and development managers as necessary
  • Generated SQL scripts

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,  ALM QC, Quality Center/ALM, LINUX, UNIX, Shell scripting, Perl scripts, APIs, MVS, C#, scripts, framework, white and black box

Consultant QA Manager

Kaiser Permanente  – Burbank, CA – April 2010 to August 2010 Apr 2010 – Aug 2010

 

Position: QA Manager

Set up various network configurations for testing purposes for multiple applications including membership and billing divisions.

Responsibilities:

  • Healthcare, provider, claims, vendor, Broker, and billing applications
  • Performed System Integration Testing as well as End to End Testing
  • Reviewed and wrote requirements for all aspects of healthcare applications including billing and accounting
  • Wrote Test Plans, Test Cases, Test Procedures, and Test Scripts; executed Scripts; logged defects
  • Involved in automated and manual testing using QTP, scripts, frameworks, record and playback
  • Generated SQL scripts including PL-SQL
  • Validated multiple reports, including multi-product and usage invoice

Skills Used: , Mainframe, MVS, Jasmine, JCL, Cobol, TSO/ISPF, DB2, MS?TSQL, Oracle/PLSQL, SPUFI, QMF, LINUX, and windows, VB manual and automated test execution,  Quality Center(ALM), LINUX, UNIX, Shell scripting, Perl scripts, APIs, MVS, C#,  HL7,  white and black box testing

Senior Technical Designer Full Time Employee

CSC – El Segundo, CA –  December 2006 to September 2009 Dec 2006 – Sep 2009

 

Position: Senior Technical Designer QA

I provided software quality assurance for telecom applications and other communications billing and financial applications. I managed four projects in UAT; these consisted of 4 to 6 resources from vendors and the  client AT&T. I was responsible for scheduling, test planning, working with on shore and off-shore teams, and performance.

Responsibilities:

  • Financial and Billing Applications
  • Set up client/server networks as necessary for testing including Linux and sequel/server
  • Wrote and designed test methodologies at the functional, systems and integration testing, and user acceptance testing levels (UAT)
  • Reviewed and wrote requirements; generated SQL scripts, including PL-SQL
  • Worked on telecommunications applications including applying taxes, usage fees and PUC taxes
  • Data communications including broadband audio and video teleconferencing
  • Billing and accounting
  • Wrote Test Plans, Test Cases, Test Procedures, Test Scripts; executed Scripts
  • Involved in automated and manual Testing using QTP, scripts, frameworks, record and playback; logged defects
  • Insure final performance for estimated number of nodes and performance requirements
  • Validated multiple reports, including multi-product and usage invoice

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:

  • Financial, Banking and Security Applications
  • 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 final performance testing insuring performance across platforms met Business Rules.

Skills Used: Quality Center(ALM), 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:

  • Financial, banking and Security WebBased applicaions
  • 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

 

Consultant Lead QA Analyst

Kaiser Permanente –  December 2005 to April 2006

 

Independently developed a resource management and reporting system. I was responsible for one other resource; worked closely with the development team and individual developers. Wrote test plans, performed requirements gathering and analysis, wrote test procedures, scheduled test execution, logged and tracked defects and monitored test execution progress.

Responsibilities:

  • Healthcare Claims, Provider, Pharmacy, EPIC
  • Wrote and executed 100s of Test Procedures, Test Cases, and Test Scripts
  • Performed System Testing including interfaces and GUIs; performed Internet/Web-based testing
  • Analyzed programs for efficiency, provided feedback to the engineering staff
  • Developed a prototype Resource Management Entry and Reporting system using Access and VB to ensure contract and government mandated compliance
  • Wrote SQL Queries; performed Report Validation
  • Followed/complied to HL7 standards
  • Involved in automated and manual testing; system, integration, and acceptance testing
  • Documented and tracked software defects
  • Complete Documentation Responsibilities

 

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

Consultant Quality Assurance Analyst

Longs Pharmacy IT   –   Walnut Creek, CA  –  July 2005 to December 2005

Performed lead QA function in gathering and analyzing recruitments for a major government mandated change to pharmacy reporting form Medicare plan D. Wrote test plan, requirements matrix test procedures and scripts for this major enhancement. Attended meetings with design staff and business executives. Set up several testing networks including client server and IVR configurations. Test and trouble-shoot network configurations. White box, Black box, C++ wrote several test simulators to test batch process.

 

Responsibilities:

  • Healthcare Pharmacy, IVR, Billing
  • Design, document and perform tests for the pharmacy system including customer billing, Internet/web-based ordering and in store
  • Insure Government mandated
  • Provided detailed analysis to the programming
  • Hl7
  • Wrote and executed 100s of Test Cases, Test Procedures, Test Scripts
  • Wrote and tested shell scripts
  • Extreme SQL Queries
  • Automated and manual testing
  • Complete Documentation
  • Mentored Team Members
  • Created test environments and scenarios for HL7, billing and eligibility verification for Longs pharmacy throughout the
  • Wrote Perl and Shell scripts to unload and interpret various records, as well as front end simulation

 

Skills Used:

Environment: 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(ALM), LMIS, Windows suite Excel, Project, PowerPoint.

Consultant Quality Assurance Analyst

Transunion   –   Chicago, IL –  December 2004 to May 2005

Responsibilities:

  • Developed a complete Regression Test, wrote the Test Plan Test Procedures Test Cases, Test Scripts and conducted the testing concurrently with financial applications
  • Automated and manual Testing
  • Extreme SQL queries
  • Performed trade study in support of regression testing a large-scale financial
  • Validate Reports
  • Conduct comparisons using Princeton Softech, JAVA and
  • Attended and hosted JAD sessions on regression/Integration
  • Complete Documentation

 

Skills Used:

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

Consultant Lead Quality Assurance Analyst

Fred G Celio   –   Kaiser Walnut Creek, CA –  March 2004 to November 2004

Responsibilities:

  • Healthcare, claims, Providers, Billing
  • Wrote Test Plans
  • Wrote, Executed, and documented the results of 100s of Test Procedures, Test Cases, Test Scripts
  • Mentored Team Members
  • Performed system testing for next-generation Claims Processing system, including interfaces, and GUIs and Internet
  • Led a team responsible for testing the Automated outside Management System, for referrals to non-Kaiser facilities.
  • Wrote SQL
  • Wrote Test Plans and executed Test Procedures for HL7 eligibility and billing verification for the AOMS system in a large-scale mainframe This included linking multiple mainframes for message, billing and eligibility verification.
  • Documented and tracked

 

Skills Used:

Environment: 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 (ALM), COBOL, , Windows.

 

EDUCATION

 

Bachelor of Art in Computer Science

San Jose State University   –   San Jose, CA

Graduate Studies Sacramento state University, San Jose State University, University of Southern California

 

ADDITIONAL INFORMATION SKILL SETS

Technical Skills

  • Access, ALM, ADABAS, APACHE, AUTOSYS, ASP, C++, C#, Citrix, COBOL, CICS, Crystal Reports, Data Warehouse, DB2, Excel, Easytrieve, File-Aid, ADT, ASAP, Stork, Willow, Radiant, OpTime, Informix, Jasmine, Java, Jmeter, JUNIT, JCL, Loadrunner, Mainframe, Mantis, Mercury API, ,scripting, SQL SUN Solaris Teradata, UNIX, LINUX, SOAAP, SOLARIS, .net, Visual Studio, ChangeMan, CICS, CLIST, Endevor, Linux, MS Project, Perl Scripting, Poweradata, B2, XML, AB, PHP, PHPUnit, tortoiseSVN, XAMMP, JETBrains, Selenium
  • Mainframe ADABAS, Teradata, DB2, Cobol, CICS, C, OS/MVS, OS/VS, OS/390 JCL, TSO/ISPF, REX, sync/sort, SAS, SPUFI, QMF etc.

 

Business Skills

  • Applications: ICD 9 to ICD 10 Conversions; EPIC upgrade; Provider Projects for Claims, Pharmacy, HL7 Transmission, ICD 9 to 10 Conversion, Membership, Benefits, and Providers; Pharmacy Subsystems to include Membership and Billing Divisions, claims processing; Telcom Applications for Billing and Financial; Program Manager Banking System; Health Insurance Provider Resource Management and Reporting System Testing
  • Provider Health Care Subject Areas: Claims, Pharmacy, Providers
  • Methodologies: Agile, RUP, SDLC
  • Phases: Requirements Gathering, Requirements Definition, Business Design, System Test Planning/ Strategy, Test Execution, Defect Tracking
  • Tools & Standards: Rational Clear Case, Rational Clear Quest, Mercury Suite (Quality Center), ALM, QTP, Test Director

 

Leadership / Management Skills

  • Team Size: Lead teams of up to 105 (5 local seniors and 100 remote junior tester multiple business analysts across project/departments/lines of business. (CHI) Worked with up to 24 developers and 4 development managers. (Wellpoint, ADP)
  • Off shore teams of 30 testers 15 in India and 15 in Philippines agile with twice daily stand-ups (Wellpoint)

 

  • Ad-hoc teams that included business analysts and developers from 5 different departments, these had to be scheduled and approved by the individual managers and scheduled sequentially for validation. These teams included generally 5 resources 4 developers and a business analyst (Kaiser)
  • Mentored QA Manager (Digital Insight)
  • Ad-Hoc 15 different projects 15 different vendors, 15 different communication protocols. two different business analysts, reviewed design documentation, developed mock data coordinated and reported issues on the testing effort. Had ultimate go no-go

 

  • PMI Disciplines: Wrote multiple test plan and test strategy documents for team’s lead and for individual projects where I was the sole tester. All Test Plan and Test Strategy documents included scheduling of resources, including development support as approved by their managers, risk management including exit criteria and issue or defect management. Lead defect or issue management in multiple
  • Industry Standards: HL7, HIPPA, Medicaid, SOX, ETL, Claims, Benefits, Plans, Copays, Deductibles, Providers including PCP (NPI), ICD9 ICD10 EP CPT, IC, McKesson, IVR,