Work Experience

GIS Data Analyst

Confidential

• Significant experience working with ESRI Software ArcGIS ArcMap, ArcCatalog, ArcPad, ArcMobile, etc. 10.0 or higher
• 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

Confidential

• 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
• 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

Confidential

• 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

Confidential

• 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
• Conducted Test Reviews and documented Test Results
• Attended and participated in project and scrum meetings

Senior Software Tester

Confidential

• 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

Confidential

• 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
• 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

Confidential

• 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

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 . 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,. 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