SUMMARY

• Twenty years experience in accounting demonstrating a solid billing/data background
• Fifteen years experience in the Telecommunications Industry
• One year experience in Pharmaceuticals, HealthCare and Finance Industries
• Seventeen years experience in QA, including Test Design, IT Software Testing, and Network Testing
• Expertise in developing Test Strategy, Test Scenarios, Test Plans, Test Cases, Test Execution and Defect Reporting by reviewing functional, user interface and business requirement documents for all phases of Testing
• Skilled in various testing methodologies including Web Services API (XML SOAP), Exploratory, Functional, Regression, System, UAT, End - to-end testing, Unit, Application Web Testing, and SS7 Network Connectivity testing
• Expertise in Root Cause Analysis by identifying and locating errors in Unix logs or data
• Developed Defect Reports, Execution Logs and maintained Test Cases in various defect management tools
• Host meetings for SEV 1 defects and liaison between Developers, Business Analysts, key project stakeholders Confidential various stages of testing
• Strong understanding of Waterfall, Iterative and Agile SCRUM Testing Methodologies and Software Development Life Cycle (SDLC)
• Performed backend data validation testing in SQL Oracle Database systems using complex SQL validation queries
• Developed Business Intelligence data validation test cases for 2008 SQL Server developing complex Confidential -SQL queries for validating source to target data
• Expertise with billing tables, Data Mining with complex SQL queries, Data Integration, Data Migration and Data Validation for both Oracle, .Net and AS400 based applications
• Customer Relationship Management (CRM), Billing and Provisioning expertise
• Provided Support at Levels 2 and 3 for IT functionality issues and Billing Production Support.
• Participated in Change Management
• Development Database Administration and Product Configuration
• Experienced with general user and environment security
• Meticulously attentive to detail leading to an earned reputation for handling multiple projects with accuracy, efficiency and high productivity
• Demonstrates excellent time management, analytical, communication, documentation, multi-tasking and decision making skills
• Self-starter who has the ability to work independently in a time sensitive environment
• Interfaces comfortably and effectively at all levels with internal and external clients

TECHNICAL SKILLS

Testing tools: HP ALM, HP/Mercury Quality Center, TestDirector, QuickTestPro, WinRunner, Jack Track, CVS, Rational ClearQuest, Remedy, SOAPUI, SOD, Serena Dimensions, JUnit, Logbot, Splunk

Languages: HTML, SQL, PL/SQL, XML

SQL Applications: BI, Confidential -SQL, SQL Server 2008, MySQL, PL/SQL PVCS Version Manager, Queryman, SQL Navigator, Toad, PL/SQL Developer and WinSQL

OS: AS/400, Red Hat Linux, Unix, Windows

Databases: Oracle, SQL Server, DB2, MS-Access

Others: Business Objects, Cognos Impromptu, Citrix, Hummingbird Exceed, Lotus Notes, MS Office, Post XML, Putty, Reflections, Tortoise CVS, Webtrends, WinSCP, Worldspace Deque, XML Spy

Billing Systems: CRM, Telegence, OPUS, OPUS Mobile, PDC, MyATT, System-X, CARE, Precedent 2000 (P2K), Retail Cofee, Salesforce, Unicorn, Uverse

SDLC: Agile, Iterative, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Help Desk Technician

Responsibilities:

• Answers help desk telephones and responds to basic customer inquiries to ensure customer needs are met.
• Assists customers in resolving basic technical problems by providing scripted guidance regarding software and hardware problems.
• Resolves and/or refers more complex technical problems through a defined escalation process.
• Logs and tracks inquiries using a problem management database and maintains history records and related problem documentation.
• Identifies, evaluates, and prioritizes customer problems and complaints to ensure that inquiries are resolved appropriately.

Confidential, Richardson, TX

CC&B Analyst

Responsibilities:

• Lead for DotCom and Aggregator (Retail Web Services)
• Develops functional, system and regression test scripts in ALM for Confidential
• Conducts root cause analysis by identifying various errors in defects opened
• Demonstrates excellence in efficiency for test suite by using templates to call to test rather than making possible changes in hundreds of test cases
• Executes Web Services API testing via XML in SOAPUI and Sales Channel Test Harness (in-house developed front end) for Aggregator retail applications
• Develops Oracle queries in PL/SQL Developer for data mining and validation
• Log defects and work with development and key stakeholders for defect resolution
• Received recognition and award voted by my team for excellence in developing test suite and productiveness
• Trains and assists new employees

Test Engineer

Responsibilities:

• Executes daily smoketests for CRM end-to-end flows
• Executes manual new functionality and regression test cases via GUI, validates and logs results
• Conducts root cause analysis by searching Unix logs to identify errors to include in defect reporting
• Executes various originating app manual test cases (CRM, OMS, OPUS, OPUS Mobile, PDC, System X, MyATT), validates and logs results
• Executes Web Services API Testing via XML in SOAPUI
• Opens and hosts defect chatrooms for severity 1 issues to effectively collaborate with onshore and offshore testers, Project Managers, Business Analysts and Software Developers
• Develops SQL Oracle queries in TOAD or PL/SQL Developer for data mining and validation
• Log defects and work with development and key stakeholders for defect resolution
• Audits monthly customer statement billing mockups for formatting, look and feel, rating, voice and data usage and verbiage on the Informational sections of the bill ensuring everything is displayed as expected

Confidential, Richardson, TX

Lead QA Software Engineer

Responsibilities:

• Executes manual test cases via GUI, validates and logs results
• Executes manual API and SOA test cases via SOAPUI, validates and logs results
• Executes manual CRM and IVR test cases, validates and logs results
• Conducts root cause analysis by identifying various errors in defects opened
• Develops Oracle SQL queries in TOAD for data mining and validation
• Log defects and work with development and key stakeholders for defect resolution
• Bounce test environments as needed via Confidential Monitoring and Control

Confidential, North Richland Hills, TX

Lead QA Software Engineer

Responsibilities:

• Develops Test Cases, Test Plan, Test Scenarios and Test Strategy by reviewing Business Requirement documents
• Executes manual test cases via GUI, validates and logs results; reports and track defects in Quality Center
• Develops and executes manual Business Intelligence test cases via SQL Server 2008 for EDW validation of the flow from source to target
• Conducts root cause analysis by identifying various errors in defects opened
• Log defects and work with development and key stakeholders for defect resolution
• Hosts Defect and Test Case Review Meetings
• Authors testing documentation

Confidential, Fort Worth, TX

QA Analyst

Responsibilities:

• Develops Test Cases, Test Plan, Test Scenarios and Test Strategy by reviewing Business Requirement documents
• Executes manual test cases via GUI, validates results; reports and track defects in Target Process
• Develops and executes manual Business Intelligence test cases in Confidential -SQL via SQL Server 2008 for EDW for data mining and validation of the flow from source to target
• Conducts root cause analysis by reviewing the debug logs to identify the defects
• Analyze Web Services XML request/responses to validate loan underwriting and decisioning by external clients
• Work with development and key stakeholders for defect resolution

Confidential, Farmers Branch, TX

Senior Testing Engineer

Responsibilities:

• Develops Test Cases, Test Plan, Test Scenarios and Test Strategy by reviewing User Interface and Business Requirement documents as Atlas Test Designer
• Validates automated test cases results
• Performs data validations in PL/SQL Developer
• Conducts root cause analysis by searching Unix logs to identify errors to include in defect reporting
• Executes manual test cases for front-end and back-end data validation for Enterprise Services (ES) Atlas test cases, validates results; reports and track defects in Mercury Quality Center. Executes and validates Web Services API testing via xml requests and responses against the current schema
• Executes manual test cases to validate table enhancements and tests involving replication to other environments.
• Also validates data updates in DTI and CCR environments, and also LDAP browser.
• Executes manual test cases by running stored procedures and validating data between different databases to ensure they are in synch
• Utilize Z-Tracker for metrics review
• Review debug logs to identify the defects
• Logs defects in Quality Center and work with development and key stakeholders for resolution
• Authors testing documentation for functional projects for new testers and uploads to Sharepoint

Confidential, Richardson, TX

Senior Quality Assurance Analyst

Responsibilities:

• Develops Test Cases, Test Plan, Test Scenarios and Test Strategy by reviewing User Interface and Business Requirement documents
• Executes manual test cases and validates results; reports and track defects in Mercury Quality Center
• Effectively collaborate with onshore and offshore vendors, Project Managers, Business Analysts and Software Developers
• Works Data Service Requests submitted by Development and the eBusiness Testing Team. Data mining via SQL queries and copying data from other environments by running batch jobs in AS/400 DB2 mainframe
• Ensures 508 Compliance by using Worldspace Deque Tool

Confidential, Richardson, TX

Lead Regression Testing Engineer

Responsibilities:

• Execute manual regression test cases via XML SOAP request/response transactions to test existing functionalities of CSI middleware and billing applications
• Perform Sanity tests and on-call for daily Smoke tests
• Conducts root cause analysis by reviewing the debug logs via Unix to identify errors to include in defect reporting
• Performs SQL data validations via PL/SQL Developer or TOAD
• Log defects in Rational Clearquest and Jack Track for troubleshooting by development
• Work closely with clients development team to analyze, debug and resolve any issues
• Communicate effectively with client architects, developers, managers, QA peers and other stakeholders in the QA organization
• Execute planned testing tasks and provide timely and accurate analysis of findings
• Utilize Z-Tracker for metrics review
• Demonstrates ability to multi-task and re-prioritize responsibilities based on changing requirements
• Mentors consistently to junior engineers to improve their technical ability
• Performs data mining from the billing tables for Telegence (Oracle) and CARE (AS400) via SQL queries to provide data for the Regression Team’s test cases
• Prioritizes tasks to ensure critical deliverables are completed on time
• Keeps management well-informed. Provides status across the organization

Confidential, Grapevine, TX

Business Data Analyst

Responsibilities:

• Built product configurations and definitions in National Console for maintenance updates
• PLM Systems Application Support
• Developed, provisioned and executed regression test cases
• Created Adhoc reports

Confidential, Richardson, TX

Billing Systems Analyst

Responsibilities:

• Developed Access databases for validation of price plans and features ensuring data integrity and automating the validation process
• Created Excel templates, reports and tracking sheets which increase efficiency and productivity
• Analyze ticket data for updates to conversion environments
• Build price plans in conversion environments to mirror legacy data
• Ensure data integrity by SQL scripting for data copying to other environments
• Security administrator for mock environments
• Ensure GUI connectivity by performing shakeouts after new environment setup or after data merge
• Run reference rules/integrity checks on new or merged environments
• Interface with DBA’s for troubleshooting environment issues

Confidential, Irving, TX

QA Testing Engineer

Responsibilities:

• Ensure data integrity by opening defects for functionality and data issues
• Conducts root cause analysis to troubleshoot test defects for resolution recommendation
• Analyze invoicing for mapping issues
• Interfaces with development engineers for issue resolution
• Created spreadsheets to assist supervisor in automation for efficiency
• Received Achievement award

Confidential, Grapevine, TX

QA Testing Engineer

Responsibilities:

• Ensure data integrity by opening defects for functionality and data issues
• Performs root cause analysis by troubleshooting test defects and resolution recommendation
• Analyze bill compare for mapping issues
• Interfaces with development engineers for issue resolution
• Proactive to assist peers to meet their deadlines and become familiar with other billing functionalities

Confidential, Dallas, TX

Billing Systems Analyst/Rating Specialist II

Responsibilities:

• Table developer ensuring data integrity by product configuration and auditing all business requirements in the tables design
• Initiated Change Management functional requirements, implementation and validation
• Created Adhoc Reports via SQL statements and maintained KPI reporting
• Liaison with USHA Developers, IT, Customer Care and Product Development for design specifications and functionality issues
• Designed and built Billing Department Intranet Web Page
• Created Access databases, forms, reports and macros for automation and time management
• Created Excel templates, tracking sheets and status reports which increased efficiency
• Train, coach and develop new employees

Confidential, Westlake, TX

Programmer/Analyst

Responsibilities:

• Ensured minimal downtime for outages affecting the billing system by coordinating and communicating with internal and external departments and vendors, providing technical support, tracking, monitoring and follow-thru to resolution.
• Provided technical support for ECP upgrades affecting the billing system by coordinating and communicating with internal and external departments and vendors, ensuring minimal or no impact after installation.
• Provided functional requirements and design specifications for an enhancement, a new GUI which enhanced the loading of roamer agreements without the use of a vendor created script, saving the company $120 per hour for daily maintenance.
• Provided functional requirements and design specifications for InterAct, an interface which allows indirect retailers to provision new customer accounts saving time and revenue.
• Developed, implemented and revised policies and procedures relating to foreign roaming to ensure process flow efficiency was maintained.
• Created/developed Excel templates, tracking sheets and status reports which increased efficiency and productivity.
• Ensured data integrity by validating data
• Received an award for ‘Personal and Team Best’
• Received an award for ‘Reference Data Overachiever’

Confidential

Switch Translations Roaming Analyst

Responsibilities:

• Maintained/provisioned roaming data in all Lucent switches (ECPs)
• Ensured data integrity by performing periodic audits of data loads in all switches
• Performed SS7 connectivity testing, troubleshooting and resolution
• Developed several Excel tracking sheets which isolated network connectivity issues and root causes, resulting in better roaming service for consumers and revenues for the company
• Created weekly reports for upper management, which provided a status of network connectivity issues
• Proactive in obtaining additional training for Network Analyst position for Lucent 5ESS which isolated and corrected network trouble, both service and non-service affecting and responded to alarms and system trouble indications