We provide IT Staff Augmentation Services!

Security Officer (consultant) Resume

Richardson, TX

SUMMARY:

  • Senior QA Consultant primary contributor, testing CC&B applications using SQL and Oracle to verify test results.
  • Writing and executing tests to confirm mapped tables are created and updated properly when adding new customers. XML generation.
  • In a lead capacity, have managed and mentored large test teams, giving presentations on how to write UAT test cases.
  • The gathering of requirements, Test Strategies, Documentation of test plans, Test Cases, Test Procedures and developing test scripts for database, WEB and client/server applications as well as using the Agile Testing Methodology and testing Customer Care Billing.
  • Database Consultant developed business requirements to automate businesses processes through IT applications.
  • Designed Tables, Forms and Queries; conducted data analysis and develop reports and presentations to convey information based on raw data.
  • Managed and rectified data.
  • Upgrade systems applications .
  • Generated weekly, monthly, quarterly and yearly reports.
  • Monthly reports were generated in timely and accurate manner.
  • Successfully lead a team of 100 testers in 3 states
  • Conducted training on the QA Testing Process, Defect Management
  • Successfully Implemented new system to allow customers to select Home Delivery times and dates online for delivery
  • Successfully completed part one of four process to convert billing from Verizon to Frontier in four states. Compared and validated both tax percentages and monthly reoccurring taxes per tariffs under projected timeline
  • Through continuous testing optimization, achieved moving client from SDA to G3 with major conversion to new billing system. Engineered new purchasing model to streamline data process module. Also, created new Change Management system
  • Completed Data Migration for financial mainframe platforms.
  • Conducted E2E SDLC Data and bill verification
  • Both COBOL and RPG ILE Developer

TECHNICAL SKILLS:

Key Skill Areas: Test Director, exposure to Load Runner. MKS, SharePoint

Programming Languages Tested: RPGIII, RPGIV, ILE, CL, COBOL, JVS, CICS, JAVA, DBASE, XML, .NET, XML

Operating Systems: HP - Unix, Windows 2003, 2007, 2010, Sun Solaris, AS400, iSeries

Methodologies: Software Development Life Cycle, Agile, Iterative, OSS, IVR

Databases: SQL, DB2, MY SQL, SQL Server 2000/2005/2008 , Oracle 8i/10g/9i, MS Access

Application/Billing Software: MS Office, Visio, MS Project, Outlook Express, Lotus Notes, Saville, AS400, SDA, SEU, DBASE, Certo 2, Kenan Arbor, CSM, CRM, DRI, MSP, ALS, RMS, ePMX, Kenan BP, Customer Care Billing, Confidential Billing, CommSoft Billing, DPI Billing, Maximo

CAREER HISTORY:

Confidential, Richardson, TX

Security Officer (Consultant)

Responsibilities:

  • Trained to observe and monitor buildings for incidents.
  • Entering data and monitoring of Ce-Cure system.
  • Checking in/out all visitors via VAM System.
  • Document all reports of all incidents while working second shift.
  • Ensure all buildings monitored are safe and secure at all times.

Confidential, Dallas, TX

Quality Assurance UAT Tester (Consultant)

Responsibilities:

  • Rewrite of CIS Oracle CC&B Application Test Cases
  • Review business, functional and design specifications to ensure full understanding for test development.
  • Execute and evaluate manual or automated test cases and reports test results.
  • Develop, document and maintain functional test cases and other test artifacts like detailed test script, test data, and test results.
  • Ensure that validated deliverables meet functional and design specifications and requirements.
  • Isolate, replicate, and report defects in ALM/QC and validate defect fixes.
  • Executed test scripts adding, removing and updating Maximo meters

Environment: HP ALM. Oracle CC&B, SBI, Maximo, MDMS, Inet, SQL Developer, MS Office

Confidential, Lafayette, LA

Quality Assurance Tester (Consultant)

Responsibilities:

  • Simple & complex query creation.
  • Working Agile methodology
  • Gathers and documents the outcome of test executions and all information needed to support ongoing measurements and reporting on risks, defects, tests, and coverage.
  • XML creation for automation and testing.
  • Creates test plans and cases based on requirements.
  • Oracle to MS SQL framework and testing.
  • Contributes to the design of test scenarios and performs peer reviews of test cases.
  • Evaluates test exit criteria to assess if additional tests are required or if test scenarios need to be adjusted.
  • Participates in and contributes to internal design reviews of testing materials.

Environment: UNIX, SQL, MS Office, Infra, XML, Mapping

Confidential, Champaign, IL

Sr. Quality Assurance Analyst (Consultant)

Responsibilities:

  • Executes functional test procedures and scripts manually and by automated tools for billing cycle runs.
  • Tracks and reports on the billing cycle execution in a timely manner with attention given to achieving a high level of quality.
  • Gathers and documents the outcome of test executions and all information needed to support ongoing measurements and reporting on risks, defects, tests, and coverage.
  • Reports discrepancies from billing cycle runs and analyzes them to determine the root causes.
  • Coordinates with Development and Infra teams/peers on the resolution of issues, overseeing the testing of billing cycle upgrades and ensuring that high standards of quality are being met.
  • Compares and analyzes system behavior vs. expected results/KPIs based on business and technical requirements. Identifies issues, proposes system improvements and performs repetitive test execution to resolve identified issues to databases.
  • Maintained Oracles databases to ensure daily processes were kept below 80% capacity.
  • Evaluates test exit criteria to assess if additional tests are required or if test scenarios need to be adjusted.
  • Participates in and contributes to internal design reviews of testing materials.

Environment: UNIX, SQL, MS Office, Infra, XML, Mapping, Oracle 8i

Confidential, Cleveland, OH

Sr. Quality Assurance Analyst (Consultant)

Responsibilities:

  • Interactive Voice Response Contract Routing Senior Analyst.
  • Call steering and Speech customer experience validation.
  • Wrote Test cases to follow call flows for each.
  • Held meetings to discuss call flows and skills.
  • Tested and retired IVR components no longer used.
  • Completed Adhoc queries to validate results
  • RISK Methodology training.
  • Created Test strategy workbook.

Environment: UNIX, SQL, MS Office, .Net, XML, Agile

Confidential, Dallas, TX

CSR Technical Support

Responsibilities:

  • Trained to take calls from Verizon customers with technical issues.
  • Troubleshoot issues for Voice, Data and Video.
  • Acted as team lead for internal team group.
  • Document all issues and dispatch technicians’ for in home wiring issues.
  • Analyze all Diagnostic issues from the central office to the router.

Confidential, Dallas, TX iSeries Quality Assurance Tester/Lead Tester

Responsibilities:

  • Trained other developers on using the HP ALM application.
  • Instructed team members how to create and write test cases from requirements on the AS400 billing platform.
  • Wrote and executed test for billing runs in both batch and interactive.
  • Taught team members how to upload test steps into HP ALM via excel spreadsheets.
  • Gave presentations on how to test batch, interactive and menu applications.
  • Assisted team lead in writing SQL queries to verify results for both existing and new products.
  • Assisted team lead in analyzing requirements for current projects and providing leadership when needed.

Environment: UNIX, AS400, SQL, MS Office, Agile

Confidential, Plano, TX

Information Tester/Test Specialist

Responsibilities:

  • Analyzed new process for any flaws or Gaps using Agile Testing method for HealthCare processing.
  • Analyzed the business rules for processing claims for testing purposes.
  • Updated ALS system adding functionality to the screens.
  • Completed writing manual testing on Mainframe migration for NON-Stop to NextGen HealthCare process
  • Tested and verified all GUI’s for Integration side.
  • Completed backend integration testing from billing to AR.
  • Wrote test scenarios, Test steps and executed all testing for new functionality in HP ALM.11 for all Claims, 837, 835 & 220 processing.
  • Completed ICD 9, 10 & claims training getting HIPPAA certified.
  • Wrote test cases and executed for claims opening all defects in HP ALM.11.
  • Wrote automated test scripts in HP ALM for manual regression tests.
  • Wrote test cases for change request submitted from production.
  • Assisted and tested all new requirements for folder structure and uploaded documents into HP ALM.

Environment: UNIX, Mainframe, SQL, MS Office, Agile

Confidential, Pittsburgh, PA

Senior Quality Assurance Analyst/Lead Tester (Consultant)

Responsibilities:

  • Analyze new process for any flaws or Gaps using Agile Testing method on iSeries AS400
  • Updated and tested metadata to validate added data.
  • Complete manual testing of New functionality to the CONDOR3.5 Project nationwide
  • Designed software or customized software for client use with the aim of optimizing operational efficiency.
  • Wrote queries to both compare and validate data elements for backend testing.
  • Tested and verified all GUI’s from the Integration side.
  • Wrote test scenarios, Test steps and executed all testing for new functionality in Sort, GUI, Location screens and Scanners and opened defects in QC.11 for all
  • Wrote test cases and executed for backend Integration opening all defects in QC.
  • Wrote and executed test cases for updates made to Data Dictionaries.
  • Validated all sorts and destinations/chutes and opened defects for all discrepancies found.
  • Worked as production support admin after screens were promoted to production.
  • Helped end users by answering questions and opening defects when found.
  • Validated scanners displayed all new functionality and routed packages to correct destinations
  • Conducted presentation to other team members on QC.
  • Validated both Destinations and Chutes are correctly displayed.
  • Validated all sort rules.

Environment: UNIX, AS400, SQL, MS Office, .Net, XML, Agile, Metadata

Confidential, Dallas, TX

Quality Assurance Analyst/ Lead Tax Tester

Responsibilities:

  • Completed manual testing of Taxes for new DPI billing system for 4 state conversion
  • Verified all tax transactions from billing and CC&B Module.
  • Wrote queries to both compare and validate rates for backend testing.
  • Validated all rate per tariffs and opened defects for all discrepancies found.
  • Compared current bills vs. new DPI bills.
  • Conducted presentation to other team members on QC.
  • Validated both Subscriber Line Charges and FUSF rates.
  • Validated all surcharge rates.
  • Validated customer care and billing modules.
  • Worked with both metadata tables and conversation team when discrepancies were found.
  • Wrote queries to determine impact analysis on multiple accounts when discrepancies found.
  • Completed presentation to new team members how to use and test scripts in QC.
  • Wrote AS400 queries to verify results for both existing and new rates.
  • Opened defects for all discrepancies found in analyzing bills in QC.

Environment: UNIX, AS400, SQL, MS Office, DPI, SDLC

Confidential

Lead Tester

Responsibilities:

  • Wrote Process flows for Purchasing System.
  • Knowledgeable and experienced with Database applications People Soft, MS Access, Visio and SQL.
  • Participated in the analysis of current business process and systems to recommend process and system enhancements to improve business performance and maximize the effectiveness of technology.
  • Analyzed and tested process flows for the billing system.
  • Conducted UAT and walkthrough for Purchasing System (ePMX)
  • Did backend Integration testing for (ePMX) purchasing system.
  • Tested web entries that were deposited in the Oracle 11i database.
  • Conducted all testing for warehouse data process module.
  • Conducted training sessions for ePMX.
  • Wrote cases for testing wireless calls.
  • Helped production support staff after project promoted to production by answering questions on setup of wireless phones.
  • Manually added APN settings to handsets.
  • Conducted test on multiple handsets for new service.
  • Validated handsets ability to send/receive voice, SMS, and MMS calls.
  • Conducted test on Blackberry and Smartphone handsets.
  • Completed automated testing using LoadRunner.
  • Tested backend process flows created for the CC&B Module.
  • Conducted White Box Testing to post and prepaid rates service plans in Kenan CC&B Module.
  • Wrote AS400 queries to verify results for both existing and new rates.
  • Verified all International and roaming rates using SQL queries on CDR records.
  • Wrote test plans and cases for monthly system release upgrade to the customer care and billing modules.
  • Executed all test cases for Kenan CC&B Modules opening defects when found.
  • Created and Implemented Change Management Process.
  • Analyzed both target and source data for billing move.

Environment: AS400, SQL, MS Office SDLC

Confidential, Dallas, Texas

Quality Assurance Tester

Responsibilities:

  • Reviewed Business Requirements and offered updates where needed.
  • Wrote functional test plans for new I GET rewards program based on the process flows.
  • Analyzed and created test cases for Rewards Program based on the process flows.
  • Verified correct amount of reward points given.

Environment: UNIX, SQL, MS Office, .Net, Agile

Confidential, Dallas, TX

Quality Assurance Tester

Responsibilities:

  • Reviewed Business Requirements and offered updates where needed.
  • Conducted Black Box testing on .Net web Insurance application.
  • Validated result factors using AS400 queries.
  • Conducted test on manual CSR AS400 screens.
  • Used LoadRunner for all automated testing.
  • Conducted backend testing to ensure all the business rules routed the records to the correct service plans.
  • Wrote AS400 queries to verify results for both existing and new rates.
  • Verified all discrepancies found and sent results to manager who opened defect tickets for each found.

Environment: AS400, SQL, MKS, MS Office 7, .NET, Agile, LoadRunner

Confidential, Plano. TX

Senior Tester/Lead Tester

Responsibilities:

  • Wrote functional test cases and procedures for ALS mainframe processes.
  • Coordinated all organizational meetings for data testing phases for upgrade to ALS and RMS.
  • Analyzed results and opened trouble tickets for all mapping issues.
  • Gave presentation on how to create test plans and procedures were to be executed.
  • Verified test results which required batch and integrated runs and reports to be created.
  • Coordinated with Fidelity and Development staff all defects that were opened due to results using QC 10.0.
  • Completed backend Integration testing for all data mapping issues
  • Created automated test cases to be executed coordinating with batch runs.
  • Submitted weekly status reports and reported on daily conference calls progress for testing efforts.

Environment: MAINFRAME, AS400, ACQUIRE Reporting, MS Office, Quality Center 9.0 & 10.0, ALS, RMS, Agile

Confidential, Columbus, OH

Testing Lead

Responsibilities:

  • Wrote test plans and procedures for ALS data migrations.
  • Coordinated all organizational meetings for data testing phases for upgrade to ALS, and MSP.
  • Analyzed results and opened trouble tickets for all mapping issues.
  • Gave presentations on how to write test plans and procedures.
  • Created automated test scripts in Quality Center for UAT testing.
  • Verified execution of test scripts.
  • Assisted in scheduling of test scripts.
  • Coordinated daily meetings to discuss status of test scripts and opened new trouble tickets if needed.
  • Verified accounts migrated to new system using ALS screens.
  • Supported different departments in test execution of scripts.
  • Created spreadsheets for total number of trouble tickets, tracking all new tickets and helping team to document and close tickets when needed.
  • Verified that accounts updated correctly in new system.
  • Acted in support function once new system was implemented.

Environment: UNIX, SQL, MS Office, Quality Center, AS400, ALS, MSP, Iterative

Confidential, Charlotte, NC

Mediation & Rating Analyst

Responsibilities:

  • Analyzed and updated test plans when needed.
  • Validated CDR’s were rating properly in each division.
  • Validated process flows and mappings to new billing mediation system.
  • Created documentation for data mapping mediation from current to the new system.
  • Assisted in data mapping testing for integration issues.
  • Wrote SQL queries to verify results from both existing and new systems.
  • Verified all discrepancies found and sent results to manager who opened defect tickets for each found.
  • Created both positive and negative test cases for each test.
  • Conducted test to ensure all the business rules routed the records to the correct service plans.
  • Verified the report created daily from the new system was accurate.

Environment: UNIX, SQL, Oracle, MS Office, ORACLE

Hire Now