TECHNICAL SKILLS

• Oracle
• Unix HP
• AS/400
• SQL Server, MySQL PLSQL
• MS Project 2010
• Saville (CBP)
• Javascript 2015
• HTML/XML
• VISIO
• LSAMS
• DPI billing
• Unicorn .5 billing
• EMI/EMR Billing
• SinglEview Billing
• AMA
• EDW
• Informatica
• Vertex Tax
• Cofee FTTP
• CAMS/CABS
• CompuWare s QA Run/Track
• Serena Dimensions
• Sharepoint
• JIRA
• SDLC
• Planview
• Waterfall Methodology
• Agile
• Informatica
• Metasolve 6
• HP ALM
• QTP
• Rational ClearQuest
• Equator
• REMEDY
• SalesForce

PROFESSIONAL EXPERIENCE

Confidential, Texas

WSP Inspection Services

Responsibilities:

• Met with survivors to perform detailed, thorough and consistent inspections of damages to their homes and personal property utilizing Confidential established Guidelines, ACE - 4 software and equipment
• Responsible for managing and completing all appointment scheduling and travel in a timely manner Responsible for training new hires in Puerto Rico
• Exceeded Confidential ’s performance targets through innovation, preparedness and operational excellence
• Demonstrated the highest ethical standards in supporting Confidential ’s mission of providing compassionate quality and timely housing inspection services for disaster survivors

Confidential, Arlington, TX

Sr Quality Assurance Analyst

Responsibilities:

• Participates in the day-to-day QA activities
• Performed testing of the SalesForce RSS Servicing System data
• Provided critical and speedy resolution of issues found in the BRD, TRD and UI documents
• Prepared approximately 3k Test cases in ALM for End 2 End and Regression testing
• Create SQL queries to extract specific data from Servicing System
• Validated XML data matched data in RSS Servicing system, VIN, Account number, Vehicle Type etc.
• Created and tracked Defects/bug fixes to ensure data integrity

Confidential, Richardson, TX

EDW Test Lead

Responsibilities:

• Successfully served as EDW Lead for several projects annually ($300K+) from design through implementation and ensured deadlines were met within budget based on project plan and requirements
• The lead between Carrier and Engineering Business Clients and EDW development teams for Defect Management,
• QA and SIT in an Agile/Waterfall hybrid environment
• Developed SIT test strategy, test approach, high level test plans and SIT test matrices.
• Documented, implemented, monitored and enforced processes for testing as per standards defined by the
• Carrier and Engineering and EDW teams
• Assisted in Black box and Vulnerability scanning security testing of the system
• Created SQL queries/scripts to compare and contrast data for Carrier & Engineering Reports to M6 data for mapping purposes
• Validated the load process of ETL to make sure the target tables were populated according to data mapping
• Assisted UAT teams with Test Data Creation for Spotfire in a production like environment for testing
• Planned, organize and daily scrums and ensured action was taken based on the team discussions
• Integration of M6 and Informatica data into Spotfire applications for Business Clients
• Tracked and prepared the reports to management daily/weekly of testing activities such as Testing results, test case coverage, required resources, defects status, performance Baselines, etc
• Work closely with Business users and Development teams to review and resolve critical defects
• Responsible for SIT project/release estimating and Confidential analysis
• Created the SIT test schedule (tasks, dependencies and assigned team members)
• Updated reports and documents in Sharepoint
• Prepared, managed time estimates and SOWs
• Involved in hiring activities and mentoring of 10 team members
• Trained the team on Agile/Scrum processes, quality, impediment removal

Confidential

Test Lead, Richardson, TX

Responsibilities:

• Participated in the successful conversion of over 3 Million Voice local wireline customers from Verizon to
• Lead, managed and oversaw the testing of Local, LD, Directory Assistance, Monthly Usage charges and VOIP
• Participated in weekly meetings with upper management to give status on Usage teams progress
• Manage Usage team defects and testing efforts to ensure completeness
• Planned, organized and led team meetings to ensure action is taken based on the team discussions
• Provided daily and weekly project status to the Project Team and Management of critical Usage defects
• Compared Frontier FiOS package rates with Verizon FiOS package rates using ICOMS billing system
• Wrote SQL statements to compare data in DPI to that of the Verizon bills
• Trained Usage team on Verizon Vz450 and EMR data structure
• Trained Usage team of four on how to compare usage between Verizon and DPI/Frontier bill

Confidential, Wood Dale, IL

Sr. Consultant

Responsibilities:

• Performed technical analysis of production fallout orders for billing orders and data mismatch
• Performed testing of the Confidential CC&B system data
• Provided critical and speedy resolution of issues ranging from data manipulation, SQL scripting,
• DB updating, reformulating XML to help orders move along in the Confidential CES 8 Billing system.
• Communicated and assisted development teams in resolution of critical production fixes
• Developed proven Methods of Procedures (MOP) for common error fixes, and train new team members
• Reported, maintained and updated reports and defects in JIRA.

Confidential, Cedar Rapids, IA

Sr. Consultant

Responsibilities:

• Responsible for manual testing of IT CABS billing modules on an AS400 platform
• Monitored, report and analyze project schedules, milestones, deliverables, defects and test resources as to stay within the project scope in JIRA
• Created and Validate Test Plans and Test Cases, project documentation and developing quality assurance methodologies
• Wrote SQL queries to compare and contrast data with Windstream CRM Webservice frontend
• Validated and updated requirements of pending project implementations in Sharepoint

Confidential, Chicago, IL

Sr. Consultant/PMO

Responsibilities:

• The liaison between Confidential CES 8 testing groups and management to ensure conformity in testing and project objectives are being met
• Managed and maintained all project documentation, including creating risk analysis, test monitoring documentation and developing quality assurance methodologies
• Testing Production Billing runs for accuracy and providing reports via Unix scripts
• Provided SQL patches to correct Confidential defects in QC for all modules
• Created and Validated Test Plans for projects on a pre/post production basis
• Support, test and troubleshoot Confidential data issues during production implementation
• Performed issue resolution by creating SQL statements for testers to utilize and analyze data using Toad and Unix

Confidential, Lewisville, TX

Project Manager

Responsibilities:

• Assisted AVP of special projects and IT PM in development of policies and procedures for the Loan Admin Team
• The Project Manager between testing groups and management to ensure conformity in testing and project objectives were being met
• Managed and maintained all project documentation, including creating risk analysis, test monitoring documentation and developing quality assurance methodologies
• Created detailed BRDs for user needs and steps required to develop and modify systems
• Converted BRDs into test plans, test cases and functional and regression test scripts
• Created and Validated Test Plans for projects on a pre/post production basis
• Monitored, reported and analyzed project schedules, milestones, deliverables, defects and test resources

Confidential, Dallas, TX

BSA/QA

Responsibilities:

• Participated in all phases of the software development lifecycle for data, technology and marketing deliverables
• Gathered and managed requirements BRDs and business rules, translating those into operational specs and project tasks, and ensuring all requirements are reflected in every stage of documentation
• Managed and maintained all project documentation, including creating test plans and developing quality assurance methodologies
• Tested files and data to ensure all data elements are correct using SQL Development Tool

Confidential, Allen, TX

Sr QA Analyst

Responsibilities:

• Lead Conversion activities for Phase 3 & 4 (nine states combined) in converting customer data from CBSS and Kenan Arbor legacy systems to the DPI System
• Tested, researched and reviewed usage variances for each cycle in the DPI billing system
• Maintained, updated and tested control records, rate tables, structure/call code table, assembly control tables, carrier ID tables, directory assistance tables, and all other tables within the DPI
• Built product and service, Feature, Rate, OCC, tax and NRC Tables
• Identified and documented impacted Dollars per Bill Cycle for each defect using SQL queries and HP QC
• Wrote SQL queries to compare and contrast data.
• Mapped billing data from VZ450 to Frontiers DPI billing data (i.e. Products, rates, taxes, charges etc.)
• Tested and confirmed Heat Tickets and Scrubs (Production tickets) were fixed in the test environment
• Performed functional testing, unit testing, integration testing and regression testing
• Created, maintained and updated defects to closure using HP Quality center during the conversion testing phases

Confidential, Richardson, TX

Defect Manager

Responsibilities:

• Ensured defined defect management and triage processes were followed and defects were fixed in a timely manner
• Managed defects and coordinated among QA Test Lead, Dev Lead, UAT Lead and QA Managers
• Coordinate testing activities of incoming defects among different end users and test teams
• Prepared and track status updates to Quality Center, Defect Planning Release Manger, Testing and 3rd party vendors.
• Coordinated calls with Consumer IT Teams, Testers and Developers to bring critical defects to a resolution
• Open, monitored and resolved defects for Developers in Rational Clearquest
• Schedule code releases along with test teams for various test efforts
• Generated reports and metrics for defects including root cause, resolution time and aging of defects

Confidential, Monroe, LA

Sr QA Test Lead

Responsibilities:

• Lead testing efforts, researched and reviewed usage Price Plans and Features variances for each cycle in Confidential Ensemble CC&B and Enabler Billing Module and Singleview
• Prepared test strategy, test approach, high level test plans and test matrices
• Identified and Analyzed risk to the test schedule and budget
• Reported and reviewed issues to and with business partners and follow up with Incident Reports to the various development groups
• Performed functional testing, unit testing, integration testing and regression testing
• Mapped data from Embarq product, price plans and features to Confidential CES products, etc
• Pull AMA/EMR data if needed to verify usage information
• Created queries to extract specific data (price plan query, international trending query, customer specific queries
• Pulled customer data (charge, billing account, normalized event, customer node history, rate, price plan, product, service agreement, etc.) using SQL for both Confidential CRM and Singleview CRM
• Reviewed states tariff information on price plans, features, DA, MRC, access line and setup information for accounts
• Submitted, tracked and retested defects for major release and point releases in Dimensions and HP Quality Center
• Reviewed test bills to insure compatibility between Confidential Ensemble bills and Embarq Singleview bills

Confidential, Overland Park, KS

QA Test Lead

Responsibilities:

• Effectively managed a team of 8 onshore or 10 offshore and was responsible for delegating work to the team members, monitoring team performance, ensuring overall team productivity and quality
• Created test cases/test plans for online modules CSM, CCB, SNAP, eCare (Customer Care), billing applications and Ensemble web application modules like WM on different environments
• Duties included but not limited to performing end-2-end, Integration, Regression, UAT, and Unit Testing of all Confidential Ensemble and Enabler applications
• Provided provisioning and billing test data for Confidential CRM modules
• Used Synergy and HP Quality Center for the purpose of inputting and tracking defects and performing test
• Partnered with the Developers to performed analysis for any open defects within Confidential CC&B, MAF, MPS, EMS, AR and AC applications during the integrated testing lifecycle
• Triaged defects found during test cycles, track the defects and notify the testers with the resolutions
• Copied hotfixes in Unix for all application modules according to environment specifications and supporting INFRA
• Performed performance testing, Triage, Troubleshooting and sanity checks for the AC Daemons in the Confidential Monitoring Center (AMC) Tool
• Updated the reference tables and application tables
• Use SQL Queries to verify the data from the Oracle database-using TOAD
• Ran and executed billing jobs in Unix and view logs to see whether the jobs ran successfully or not
• Responsible for documenting, MOP of Sanity Checks for FDT, SNAP, Wireless Manager, API, eCare(Customer Care) and ADD webservices applications.
• Attended rollout of Confidential Convergent charging (Turbo Charging) module
• Confidential System Test training in Tel Aviv, Israel.