Management Test Cases

Vasco Ronald Oguzua

**** **** ******* *****, #****, Bakersfield, CA 93308

E-mail: ******@*******.***; Phone: 925-***-****

Work Experience

GIS Data Analyst – Asset Integrity Management for Oil and Gas Production

Chevron North America Exploration and Production-Kern River Facility – Bakersfield, CA 93308

April, 2014 to Present

•Significant experience working with ESRI Software ArcGIS (ArcMap, ArcCatalog, ArcPad, ArcMobile, etc.) 10.0 or higher

•Use existing ArcGIS software to perform basic geo-processing tasks, data digitizing, feature creation or editing

•Create high quality oil and gas related maps for print and digital use

•Read and interpret oil and gas lease documents, deeds, engineering or regulatory documents

•Map oil and gas mineral tracts, leases, units, wells, pipelines, and other data as assigned

•Import, export, convert, re-project, manipulate, clean, sort, inventory GIS or related data

•Ability to integrate GIS functions, processes and systems to create, optimize and document GIS workflows for an organization

•Ability to interpret existing IT controls environment and apply them to existing and proposed processes to ensure compliance

•Ability to execute mapping projects for Land and Regulatory departments, and create lease maps, expiry maps, pipeline asset and facilities maps, update, maintain and administer the ArcGIS database

•Ability to process GPS data (export and import shape files to and from survey work) into the ArcGIS database

•Assist land and business development with prospecting and land/lease acquisition

•Conduct data research and compile spatial data and provide quality control for geospatial data and maps

•Perform analysis of data or spatial relationships and research oil and gas operations, movements, activity in order to optimize asset integrity management and visualize data

•Independently manage enterprise GIS projects and tasks as needed and create processes to facilitate efficiencies in workflows

•Provide GIS technical support and assist with testing of in-house GIS solutions

•Maintain intra-office communications to share data, procedures, efficiencies, and problem-solving and assume additional responsibilities and perform special projects as needed

•Strong Oracle or related RDBMS skills including transact-sql and SDE versioning with an Oracle database

•Strong GIS technical skill set including spatial analysis / geo-processes, Model Builder, FME, aerial imagery interpretation and geodatabase design and creation

•Knowledge of GIS tools / applications including HCA Gas Analyst, GPS, Alignment Sheets, Geo-processing and Model-Builder

•Ability to work directly with business owners to document and formalize detailed system requirements

•Ability to internally develop or work with third party vendors to develop, deploy and support project solutions per business requirements

•Participates in production support, issue resolution and change control management activities

GIS Quality Assurance Analyst/Tester – Asset Integrity Management for Gas Transmission and Distribution

Pacific Gas and Electric Company – Walnut Creek CA 94598

September, 2013 to October, 2013

•Worked on a really exciting project called Next Generation Linear Reference Project which was part of the Pipeline Safety Enhancement Program (PSEP) at PG&E facility at Walnut Creek, CA, a work effort associated with Gas Transmission Pipeline Asset Management Sandbox implementation

•Supported the company's PODS data model and ArcGIS Pipeline Data Model (APDM) database system. Worked closely with the System Integrity Engineers to ensure accurate data is available for use in risk ranking programs

Vasco Ronald Oguzua 925-***-****

•Processed pipeline related GPS, survey and schematic datasets and managed historical pipeline/facility maps and schematics

•Utilized Intrepid GIS solution software to produce and display HCA maps along pipelines (centerlines)

•Facilitated the translation and merging of data from outside sources and converted data for use in the ArcGIS Pipeline Data Model database Processed pipeline related GPS, survey and schematic datasets and managed historical pipeline/facility maps and schematics

•Created, modified and updated pipeline assets, including mapping existing pipelines, pipeline right of ways

•Conducted source document validation to ensure data was collected properly, processing GPS trajectories, alignment sheet creation, HCA Analysis, Class Location Survey, performing cleanup alignment sheet equations/algorithms

•Managed data and conducted QA/QC on managed data to ensure accurate and a reliable product

•Developed and wrote test cases, scenarios and scripts to ensure quality applications. Executed test scripts and ensured results achieved documented goals and objectives

•Defined criteria for testing, analyzed results of testing cycles and presented results in Test Summary Reports.

•Executed test scripts using test tools (HP Quality Center) following the defined testing methodology

•Was responsible for testing the integration of Intrepid Asset Management solution with SAP Linear Asset

Management (LAM), SAP-Geo.e (Geographic Enablement) and Documentum to provide a fully integrated

Asset Integrity information solution

•Was responsible for testing the Intrepid application which utilizes Pipeline Open Data Standards (PODS) data model for new pipeline GIS environment

•Tested the Intrepid –SAP integration interface to the PODS database which is critical for managing pipeline facility data to support day to day operations and long range planning activities

•Calculated and reported MOAP calculations using core asset data captured for the effort in Intrepid application

•Wrote and executed test cases based on the Intrepid Application functionalities and the gas transmission phases (Design, Construction, Operational and As-Built).

Independent Contractor

8239509 Canada Inc

March, 2012 to August, 2013

Reliable quality assurance analyst with over ten years’ experience in the IT industry offering the following core competencies:

•Handle and resolve critical quality problems using research abilities.

•Hands-on experience with GIS and statistical data collection, analysis and quality administration.

•Strong analytical skills, combined with effective communication, organizational skills and planning ability.

•Strong Requirements management, Test Management (HP QC), Performance testing (HP LoadRunner), Accessibility testing (Jaws, AccVerify, Infocus) and SAP skills

•Provided QA training and prepared presentations for junior testers in the company regarding issues of quality performance and testing.

•Managerial qualities – Time management, project leadership and team work.

•Independent and self-directed – Can work with minimum supervision.

•Has performed short-term contracts with various agencies including, but not limited to the following;

GIS Quality Assurance Analyst, Rolta Canada Limited - Markham, ON

•Reviewed Use Cases and application documentation for OnPoint GIS application to extract test case scenarios

•Reviewed test plans and test cases for web-based and desktop OnPoint GIS application

•Executed test cases for web-based OnPoint GIS application for accurate display of electoral geography, polling divisions, voting locations, urban and rural addresses, street networks and places for Elections Ontario

•Executed test cases for desktop OnPoint application using ArcGIS 10.1

•Executed test cases for OnPoint application using ArcGIS Server

•Documented test defects using Rational Clear Case, tracked defects and resolved test issues escalated

Vasco Ronald Oguzua 925-***-****

•Conducted test reviews and documented test results

•Participated in daily project and scrum meetings

Senior Software Tester, SAIC - McLean, VA

October 2006 to October 2011

•Reviewed and modified Software Development Life Cycle processes to improve Test Strategy for 2010 US Census Data and 2008 US Census Dress Rehearsal. Reviewed and analyzed systems design, table layout and requirements specifications and other relevant data files and documents

•Wrote test plans created and executed test cases used in the various applications

•Developed and executed automated test data loading scripts and simple queries in SQL and PL/SQL for validation of back-end data in various schema, resulting in improved quality of testing while reducing production time.

• Back-end tests ensure 2010 US Census edited data accuracy and correctness, and imputed data reasonableness

•Developed test plans, created and executed test cases, reported and tracked bugs, wrote test summary reports and created traceability matrix of test cases to requirements and test defects

•Performed functional, integration/systems and regression tests on web-based applications (Team Track, Inventory Database Management, Information Base Exchange and Management (IBEAM), Cost and Progress (Data Capture and Check-In) system

•Executed batch processes for various modules of the U.S. Census Coverage Management applications at the VAX System Environment

•Ability to interpret and transform Data Models, Business Use Case Diagrams, Environment and Data Needs into Testing Deliverables

•Performed test management for various applications using Quality Center (v9.2 and v10)

•Performed web-based application testing using Quality Test Pro (QTP v9.2 and v10)

•Demonstrated experience in Rational tools (testing and defect management): Rational Clear Quest, Rational Clear Case, Rational Rose

•Used ArcGIS to verify and validate map coordinates and map display used in Census spatial data at national, state, county, tract, and block levels

•Used ArcGIS to verify accuracy of attribute demographic and housing data associated with spatial data including feature networks

•Used ArcGIS to verify and validate Local Update of Census Addresses (LUCA) and Zip Code Tabulation Areas (ZCTA) used in Census Enumeration

•Used ArcGIS to check and validate accuracy of maps and attribute data used in Edit Review System and Count Review System

•Performed Accessibility testing (Section 508 testing) using JAWS and AccVerify 11

•Tested and delivered more than 20 Universal Control Management and Response Processing Systems developed in-house for the U.S. Census 2008 Dress Rehearsal within 18 months and was recognized and awarded $1,000.00 bonus for the effort to reduce production time.

•Mentored and trained new test engineers to improve their productivity in requirements analysis, test plan, test design, test case and test execution, debugging and general testing skills including creating traceability matrix of test cases to requirements and defects

GIS Programmer Analyst, SAIC - Falls Church, VA

June 2000 to October 2006

•At SAIC Project with U.S. EPA, analyzed and re-organized census data used in Integrated Geodatabase Mapping Interfaces, Facility Identification interfaces and Envirofacts applications

•Built the Demographic and Housing data used in EPA's Central National GIS Data Repository for various applications (EnviroMapper, Environmental Justice, Emergence Response Analyzer, Brownfields, Tribal Information Management Systems, EnviroMapper for Compliance Analysis)

Vasco Ronald Oguzua 925-***-****

•Tested all web-based applications developed for EPA's Environmental Information Warehouse Initiative (EIWI) and Tribal Information Management System built for the American Indian Environmental Office (AIEO) Tribal Enterprise Architecture Program

•Created standard testing procedures to meet user requirements, wrote and executed functional, systems integration test cases

•Performed unit, systems user acceptance and regression testing and documented online user guides for applications

•Analyzed schools and districts data, prepared charts and maps used for developing the proto-type

•Performance Based Data Management Initiative (PBDMI) Demonstration System used by SAIC for a proposal which won the One-ED Data Collection and Repository Contract with the Department of Education in 2002 and merited with an award of Excellency

•At SAIC Project with Geographic Products Quality Assurance (GPQA) Branch, Geography Division of the U.S. Census Bureau, analyzed business requirements, systems design and table specifications for testing spatial products used in the American FactFinder production for 2000 US Census

•Implemented QA for Master Address File/Topologically Integrated Geographic Encoding Referencing System (MAF/TIGER) during the 2000 US Census. MAF/TIGER is the main source and repository of the Census attribute and spatial data.

•Implemented quality assurance checks in spatial files (shapefiles), feature networks and other spatial geography files to ensure their consistency with the specifications in 2000 US Census Tiger Lines and DADS products using ArcGIS applications (ArcView, ArcInfo, ArcMap, ArcCatalogue, etc), Google Earth API

•Performed Accessibility testing (Section 508 testing) using JAWS and INFOCUS

GIS Technician, North Simcoe Privateland Stewardship Network - Midland, ON

June 1998 to December 1999

•Coordinated with Stewardship Network partners to review and finalize Systems design and requirements

•Mapped most suitable Sites for Potential Residential Development using Multi Criteria Location Method and mapped Forested Lands for the location of Suitable Logging Sites using ArcInfo within the Oro Moraine Landscape

•Generated digital Forest Resource Inventory Information from satellite images using Idrisi and Airphoptographs

GIS Technician, City of Peterborough - Peterborough, ON

September 1997 to May 1998

•Responsible for data input and updating of digital information from maps, streets, deeds, land parcels in ArcInfo GIS system

•Generated city maps, charts and tables from air photographs and satellite images. Generated maps used for the location of their work sites

•Surveyed and digitized land parcels for residential and commercial plots and zoning maps of the city

Education

Post Graduate Certificate in GIS Applications Specialist

Sir Sandford Fleming College - Lindsay, ON 1999

M.A. in Natural Resources Management

University of Windsor - Windsor, ON 1998

B. Sc. in Physical Geography

National University of Lesotho 1989

Skills

Software Quality Assurance/Testing, Systems Configuration Management, Requirements Gathering, Systems Design Modelling and Business Analysis using UML, Project Management, GIS and Remote Sensing Applications, Intrepid

GIS Applications, Test Automation, Databases, Statistical Analysis, HP Quality Center (v9.2 – 10), HP Quick Test Pro (v9.2 – 10), SAP, Quality Systems in Drug Manufacturing (implementation of cGMP including, GLP, SOP’s, Documentation, Manufacturing Control and Validation, Stability, Audit and Inspection).

Additional Information

Operating Systems: Windows (98, NT, 2000, XP, Vista), UNIX, Linux, Mac OSX, Open VMS

Languages: PL/SQL, C/C++, SQL, HTML, CSS, Visual Basic, Shell Scripting

Test Automation Tools: HP QTP, HP Quality Center (QC), LOAD Runner, IBM Rational Clear Case

Modelling and Design Software: Rational Rose UML, Altova UML Model, Visio, Smart Draw

Databases: Oracle, SQL Server, MySQL, MS Access, TOAD, SQL Developer, SQL Navigator

Web Design: HTML, XHTML, Dreamweaver, CSS, Home Site, Web Services, RoboHelp

GIS Applications: ArcGIS (ArcView, ArcInfo, ArcMap, ArcEditor, ArcCatalog, ArcPad, ArcSDE, ArcIMS,

Spans, FME, AutoCad, GPS, GML and Geo-Spatial Web Services, KML Map Services, Web Map Services, Web Feature Services.

Remote Sensing Applications: Erdas Imagine, PCI, Idrisi, ENVI, Surfer 8

Statistical Applications: SPSS, Systat, R

Systems Configuration Management: Remedy, Team Track, Version Manager

Section 508 Testing tools: JAWS, INFOCUS, AccVerify 11

Contact this candidate