SUMMARY:

Highly skilled Senior IT Software Engineering Test Lead with extensive testing and project management experience. Lead manual and automation testing on various projects for Oil & Gas, Energy / Utilities, Finance and Technology industry domains. Proven success leading multi - disciplinary QA teams throughout entire Software Development Life Cycle (SDLC). A decision maker with sense of urgency utilizing excellent planning, coordination, customer service, and communication skills. Able to work in cross-functional team environment.

EXPERTISE IN:

Data Warehouse and RDBMS Data Validation

CRM / ERP Systems Testing / API Testing

Implement Test Plan / Strategy in Agile / Waterfall Methodology

Quality Assurance and Project Management

TECHNICAL SKILLS:

Web Technologies: XML, JSON, VBScript, HTML

Languages: SQL, SQL *Net, SQL*Plus, Unix shell script, MS Access basic

Databases: Oracle 12, 11,10, 9i, 8.1,6, SQL server, Sybase 12.x, 11.x, MS Access, TeraData

Tools: Maana®, GraphQL, Microsoft TFS, MTM, Azure DevOps, CI/CD, Docker, Kubernetes, TestArchitect®, HP ALM, Quality Center, Automation Anywhere 7.0, Selenium webdriver, Selenium IDE, Postman, SpiraTeam / SpiraTest, Sharepoint, Trillium Software, Microsoft Visual Studio, Toad, ODBC, SQL*NET, SQL*PLUS, SQL*Loader, Putty, Telnet, FTP, VNC viewer, MS Access, MS Project, MS Office (Excel, Word, PowerPoint, Outlook), Wise Installation, PVCS, Visual Source Safe, Business Objects, SQL Server Management Studio, SSRS, SQL Server Express, Business Intelligence, ETL, Rational ClearQuest, Rational ClearCase, Borland STAR Team, Informatica

Apps: WellPlan®, DSWE®, Compass®, Confidential ®, MultiWell®, ACA, SCADA, DMS/OMS, Siebel Energy Services 8/7/6, Siebel Sales, Siebel Field Service, Siebel call center, Siebel ebusiness, Siebel Financial Services, LodeStar GUI 4.5.3, Pricing Expert, LPSS, ClearQuest, PEACE 8.0, Market Solutions

Platform: Windows 10/8/7, XP, NT 4.0/2000/98, UNIX (Sun Solaris and HP-UX), LINUX, AIX, Apple OS

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

QA/QC Lead

Responsibilities:

• Involved in design and model Computation knowledge graph using Model Based System Engineering methodology.
• Worked with team to setup AI and Machine Learning to identify key testing areas using GraphQL services and Ontology concepts.
• Actively lead and participated in troubleshooting and defect triage.
• Participate in team meetings to understand Business requirements and worked with Dev and Ontology team to identify key testing deliverables using Azure DevOps.
• Managed CI/CD pipelines to implement feature updates using pull request as implemented by developers after validating tests.
• Managed daily backups and restore for Maana® application workspaces and services using Azure FileShare and Putty.
• Worked with developers to create GraphQL queries to test backend functions and services to integrate with UI frontend applications
• Coordinated Unit, Integration and Alpha testing with Users from various Business Units SME during feature deployments.
• Assisted Scrum Master with daily backlog and refinement of Stories and Feature updates using Azure DevOps

Confidential, Houston, TX

Senior Test Lead

Responsibilities:

• Supported and managed QA testing effort for Halliburton / Sperry Drilling internal applications enhancements and upgrades during project life cycles.
• Managed creation and implementation of manual and automation test cases with onsite and offshore testing resources.
• Led testing effort to maintain test cases and test plan for manual and automation testing for Confidential WellPlan® and Sperry Drilling Confidential ® software upgrades and releases.
• Assisted team in maintaining ~1.1K manual test cases inventory by coordinating design updates and adding those test cases to automation TestArchitect® repository to be executed for ongoing regression testing.
• Implemented shared steps test cases to create process for data transfer validation for cross-product integration using JSON / XML format every time there was update to product catalog. This was later automated and added to regression scope. This helped manual effort to update each test case whenever shared steps were updated for any ongoing changes.
• Participated actively in agile methodology using Scrum process by leading and coordinating daily tasks during standups, Demo, Grooming, and Planning.
• Created test execution summary matrix for team deliverables and efforts in providing updates to Senior Management during iterations using excel spreadsheets that were integrated with TFS/VSTS with real-time updates.
• Coordinated additions / updates in TestArchitect® automation scripts with offshore resources by executing and confirmed script verification point meeting test objectives.
• Maintained SQL server and Oracle database version patches in EDM back-end tables by executing SQL scripts to keep version updates as part of ongoing Confidential ® releases.
• Tested web application using REST API and SOAP Postman , XML / SOAP , SoapUI verifying input and output data integration between Confidential ® and Landmark® WellPlan® apps.
• Monitored daily CI/CD process with Azure DevOps to execute Smoke test scripts using TestArchitect® to validate Confidential ® daily builds. Any failures reported were investigated and added with Bug fix to resolve build issues.

Confidential, Houston, TX

Senior Consultant

Responsibilities:

• Led QA efforts for white box and black box testing with development and configuration management team to validate application script dependency in Unix and client / server environment.
• Identified issues and gaps in manual test scripts during patch management and ensured updates and enhancements for repeatable scenarios with product development of DMS / OMS app with leads and managers.
• Executed UNIX scripts, validating back-end data updates resulted in front-end app display.
• Worked with scrum teams and Scrum Masters to identify testing scope and issue resolutions using agile processes during daily standup and planning for project releases.

Confidential, Houston, TX

Consultant - Senior Technical Analyst / Test Manager

Responsibilities:

• Supported QA activities for SERNA and Think Energy CRM application.
• Siebel modules and Web app used by internal end users for servicing Commercial and Residential external customers.
• Involved in testing activities for integration of third-party application with customized features for internal users.
• Led design, development, and implementation effort to automate process integrated with Siebel CRM, using Automation Anywhere tool to Web scrape usage and historical data from various utility Websites. The process helped eliminate manually downloading historical data in Siebel CRM that was used for pricing and up sell opportunities for external customers.
• Installed and configured Automation Anywhere® tool and maintained staging and production environment in sync for testing and release execution.
• Led and participated in coordination, development, integration, and testing effort for custom web-based application (WAPP). Web-based application was interfaced with Siebel and Pricing Expert® databases for internal and third-party sales staff to quote pricing for customers for upsell opportunities.
• Managed and monitored batch processes for data export from Oracle database into SQL server data warehouse to be used for WAPP application. Executed and validated SQL stored procedure results in SQL server database per requirements and design and troubleshooted issues with developers and business.
• Mentored team members in SpiraTeam testing tool usage for effective test execution and Incident resolution and matrix. Administered and supported issue resolution for internal users of SpiraTeam. Maintained user accounts, security, and project back-up in SpiraTeam.

Confidential, Houston, TX

Senior Data Quality Lead

Responsibilities:

• Managed and coordinated Data Quality efforts in Business Intelligence environment and CIS systems.
• Analyzed, profiled, and cleansed data during data loads from source into target systems.
• Managed installation, deployment, and release management of software installation and patches for Confidential .
• Administered scheduled batch jobs and services on Windows server in client / server environment.
• Played lead role in design and deployment of Trillium software integration with ETL to process daily loads using Trillium business rules to profile data and upload cleansed data into BI production data mart. Modified SSIS dts package to execute Trillium batch jobs and monitored and resolved exceptions during loads.
• Managed BI reports library in SharePoint and troubleshooted report issues as reported by business using SSRS. Coordinated report deployment in SSRS and validated and tested BI reports against CIS source systems mapping.
• Created SQL queries using SSMS and validated data load from source systems schema against fact and dimension tables in Business Intelligence data warehouse.
• Participated actively in post-production support and release effort for Trillium software.

Confidential, Houston, TX

Senior Technical Analyst / QA Lead

Responsibilities:

• Managed and coordinated testing, deployment, and implementation of Texas Platform consolidation and other DE projects with onsite and offshore teams.
• Coordinated validation efforts with CitiBank, FIS, ChoicePay and other third-party vendors, testing and validating remittances and collection processes changes and enhancements.
• Led and managed projects involved in market transactions interfaces with utilities for daily transaction processing.
• Validated and resolved Payment and Remittance processes and payment files received and sent from / to TDU/ERCOT into DE interfaces and uploads into DE SAP system for updating GL accounts and receivables.