Qa Analyst / Tester, Business Analyst, And Sql Reports Developer Resume
SUMMARY:
- Test Manager of large scale testing projects
- Senior Quality Assurance Test Team lead, Quality Assurance Analyst and Tester
- Ability to develop detailed Test Plans, Test Scenarios, Test Cases, and Test Scripts based on use cases, user stories, functional and technical design specifications, and business requirements
- Full Lifecycle testing (SDLC - Software Development Life Cycle) (Unit, Integration, Functional, System Integration, Source-to-Target, Parallel, Regression, UAT, BETA)
- Tests COTS, custom software, PC, Client/Server, Mainframe, Web, Portal, Dashboard, Intranet, E-commerce, and Batch applications
- Working knowledge of ISO-9000, CMM Concepts, Agile, Waterfall, and RUP Methodologies
- Data mining
- Back end data validation
- Report development via SQL, Access and Passport queries
- Ability to develop complex reporting requirements documents
- Data Mapping (front end and back end)
- Experience with relational databases (RDBMS)
- Business & Report Analysis
- Ability to elicit requirements
- Ability to develop complex specifications and business requirements documents (BRD)
- Performs and documents Gap analyses
- HP Quality Center 11.0 (ALM - Application Lifecycle Management)
- Formal training and working knowledge of Rational Tools
- Website Designer and Coder (XHTML & CSS)
- Creation of GUI standards
- Facilitates project prioritization and change management
- Creates training manuals and release documentation
- Application training
- Mentor to other team members
- Ability to read, understand, interpret and learn different coding languages easily
- Self-motivated and able to learn software and development products rapidly
- Excellent analytical, problem solving, verbal and written communication skills
- Ability to adhere to deadlines, manage priorities and multi-task in a fast-paced environment
- Attention to detail and quality, pride in work
- Able to work alone, in a team environment (onshore, offshore, cross-country), or remotely
TECHNICAL SKILLS:
MS Office 95/97/2000/2003/2010 (Word, Excel, PowerPoint, Project, Visio, OneNote, FrontPage 2000)
HP Quality Center 11.0
Lotus Notes
Mercury TestDirector
Black Knight Financial Services Director, Passport, Navigator (formally Lender Processing Services (LPS / MSP)
Crystal Reports Pro
SharePoint
PlanView Enterprise
Oracle Siebel CRM 8.0 (Customer Relationship Management)
Golden Retriever
Netscape
Compuware FileAid
Rational Tools (ClearCase, ClearQuest, TestManager, Robot)
Internet Explorer
YouTube
SQL/Transact SQL
HP Functional Test (formally QTP)
QuickBooks Pro
Authoria
Business Objects
Query Management Facility (QMF)
Oracle Browser
Quicken
IBM FileManager
SQL Server Management Studio
PC Anywhere
VMWare
TSO/ISPF
Attachmate myExtra Enterprise
Quark Xpress
Daybreak
ProVision (Workflow Modeler)
XHTML / CSS
Maximo
LeasePak
ALS (Advanced Loan System)
PeopleSoft
Blogger
Citrix Program Neighborhood
WordPress
Firebug
VPN
BOS (Back Office System)
Photoshop
Firefox
PVCS
Concur Expense Reporting
Workbrain
Tomax
Toad
Oracle SQL Developer
TIBCO
CICS
Quest Central for DB2
Windows 95 / 98 / 2000 /NT / XP / Vista / 7
MVS/JCL
Informix
.ASP Pages (Active Server Pages)
VBScript
Cognos
ISO 9000-9001
Microsoft .Net Framework
PC SAS
UNIX
Waterfall Method
Java/JavaScript
Sybase
.COM
Agile / SCRUM
HTML/XHTML
COBOL
OS2
V-Model
Power Builder
Oracle
DB2
RUP
Visual Basic
AbInitio
DOS
CMM
MS Access
OS390
CSS
PMI
EMPLOYMENT:
QA Analyst / Tester, Business Analyst, and SQL Reports Developer
Confidential
Responsibilities:
- Writes test plans, test scenarios and test cases
- Tests reports and applications: Access, .Net, web, intranet, dashboard, portal, 3rd party vendor applications (COTS)
- Performs manual Unit, Integration, Functional, System Integration, Regression and UAT testing in an Agile environment
- Data Mining
- Documents software inaccuracies in a shared defect log
- Participates in defect resolution meetings
- Trains end users on new systems and applications
- Utilizes SharePoint as a central source for team and project documents
Business Analyst
Confidential
Responsibilities:
- Liaison between business lines and IT resources
- Works on multiple projects concurrently for various business lines within Residential Mortgage Default Management (RMDM) group
- Works closely with Corporate Compliance Quality Assurance (CQA) - RMDM teams to pull populations and learn testing processes, procedures
- Gathers business requirements from project stakeholders, executive management and outsourced consulting groups
- Documents complex Business, Functional, Application & Reporting Requirements (BRD, RRD, PDD)
- Reverse engineers SQL and .Net code to obtain criteria for requirements
- Creates traceability matrices for accountability to requirements
- Facilitates and participates in User Acceptance Testing with various business lines
- Creates test plans and test cases for UAT effort
- Designs prototypes for new applications
- Data mapping (front and back end) of default mortgage systems (ALS, MSP)
Reports Developer
Confidential
Responsibilities:
- Develops MSP and ALS reports via MS SQL Server, MS Access, and (LPS / Black Knight) Passport queries for various business lines, upper management, OCC compliance and audit testing
- Develops ad-hoc reports as needed
- Participates in Data Governance Meetings for MIW (Mortgage Information Warehouse - data conversion project)
- Analyzes reports for discrepancies and exceptions
- Tracks complex reporting metrics (qualitative and quantitative) for the Remediation initiative
Team Lead and Sr. QA Analyst / Tester
Confidential, Tustin, CA
Responsibilities:
- Utilized HP Quality Center to create test plans, test cases, test scripts, run scripts and log defects
- Cross browser testing
- Team Lead on mulitple test projects
- Tester on multiple projects concurrently
- Tested Production Support Service Change Orders (SCR)
- Tested Citrix Daybreak and LeasePak applications (loan application management)
- Performed backend data validation via SQL queries
- Utilized Oracle SQL Developer
- Developed testing schedules
- Calculated testing estimates
- Created traceability matrices
- Utilized Merant Tracker for project management
- Utilized SharePoint
- Participated in defect management meetings
Team Lead, Sr. QA Analyst / Tester and Business Analyst
Confidential, Fountain Valley/Costa Mesa, CA
Responsibilities:
- Performed full SDLC manual black box and batch testing on Telematics equipment, online enrollment application (BlueLink), web portals, reports, and an Oracle Siebel CRM application
- Wrote and executed complex Test Scenarios, Use Cases, and Test Cases
- Created traceability matrices
- Created and managed defects in SharePoint
- Participated in daily defect management meetings
- Supervised and trained junior testers
- Business Analyst on several projects concurrently (Project Reporting, Dealership Web Portal, Oracle Siebel CRM)
- Elicited business requirements from high level executives and other team members
- Utilized Project Charters to document User Requirements Specifications (URS) in accordance with PMI standards
- Documented Business Requirements
- Documented Policies and Procedures
- Designed prototypes
Business Analyst, Website Development & Maintenance and QA Tester
Confidential, Orange, CA
Responsibilities:
- Elicited business requirements from clients
- Performed GUI analysis and create standards for design
- Designed and developed corporate websites
- Created test plans and test cases for website testing
- Performed Unit, Funtional, Stress, and Load testing
- Performed website maintenance and updates
Team Lead, Sr. QA Analyst / Tester and Business Analyst
Confidential, Tempe, AZ
Responsibilities:
- Documented test scenarios and test cases from functional and technical specifications in a RUP environment
- Manually tested a Project Management web application
- Manually tested mainframe, online and batch applications on an MVS platform using TSO/ISPF and CICS
- Manually tested customized Crystal Reports within a Project Management web application, Oracle backend
- Team Lead on a customized, web-based Timekeeping portal with an Oracle backend
- Participated in JAD sessions to ensure adherence to testing methodologies
- Performed gap analyses on previous test efforts to ensure complete testing of all custom coded enhancements
- Elicited business requirements from high level executives and other team members
- Created test data utilizing SQL, FileAid, and QMF
- Performed a requirement risk analysis to enhance project success
- Utilized use cases to create test scenarios
- Maintained matrices to record test results and test iterations for traceability
- Documented software inaccuracies in a shared defect log
- Coordinated with Developers, Business Analysts, and Subject Matter Experts (SME) to resolve application defects
- Utilized SharePoint as a central source for teamwork documents
- Authored User Guides for a Timekeeping/Project Management web application
- Trained end users on a Timekeeping portal
- Guided the organization in establishing and implementing formal QA methodologies
Sr. Tester - Quality Control
Confidential, Jacksonville, FL
Responsibilities:
- Documented test scenarios and test cases from functional and technical specifications in an Agile environment
- System testing of COBOL and AbInitio processes via SQL queries against a DB2 database (Diamond, Common History, Common Suspense, Medco, and Nasco data)
- Performed Parallel and Boundary testing of the Enterprise Claims Opermart (ECO) database attributes
- Utilized various mainframe tools to perform source-to-target testing of database attributes: TSO, FileAid, FileManager
- Executed SQL commands via (QMF), SQL Navigator, SPUFI, and Quest Central
- Documented defects and worked with developers on resolution
- Utilized Business Objects for reporting
- Utilized Rational ClearQuest to track and manage defects and change requests
- Utilized Rational TestManager to develop test plans and test scripts
- Utilized Rational ClearCase (Unified Change Management) to archive test documents and maintain an auditable history
- HIPPAA Compliance was met
Automated Regression Test Lead
Confidential, Harrisburg, PA
Responsibilities:
- Created, documented, and executed test plans and test cases from functional and technical specifications
- Utilized Mercury QuickTest Pro for recording and scripting
- Utilized VBScript to add complex functions to recorded scripts
- Created data insertion scripts for test bed
- Developed test matrices to document test iterations and calculate current and future progress
- Documented software inaccuracies in a shared defect log
- Executed regression, system integration and UAT test scripts on a Microsoft .Net Framework application with ASP and COM pages on a Windows 2000 platform
- Utilized Golden Retriever to extract and manipulate data in an Oracle database
- Utilized Crystal Reports Pro
- Facilitated team status meetings
- Conducted requirements risk analysis
Team Lead / Sr. QA Engineer and Business Analyst
Confidential, Baltimore, MD
Responsibilities:
- Lead the team to conduct an extensive analysis of business processes and procedures, productivity and testing environment hardware
- Gathered requirements for streamlining testing processes and to ensure that business needs were reflected in software solutions
- Researched and proposed solutions (automated, manual, and organizational) to address quality and business process improvement initiatives and productivity issues for enhancements and implementation
- Analyzed QA lab environments and documented results for inventory and business process improvement
- Offered solutions for optimization of current software and hardware environments within the QA organization
- Prepared complex reports and roadmaps for implementation of proposed solutions and presented them to the client
QA Test Manager
Confidential, Jacksonville, FL
Responsibilities:
- Test Manager for multiple Client/Server, Web and Portal-Based projects
- Managed large scale testing projects comprised of multiple test teams and vendors
- Created detailed test plans, test scenarios, test cases and test datafrom functional and technical specifications, user requirements, use case documents, ERDs, and other supporting documentation
- Executed Full Lifecycle testing on web-based, Client/Server and e-commerce applications
- Utilized Mercury Test Director to create test plans and test cases
- Devised roll-out schedules for implementation of all vendor projects
- Assessed risk analysis for go-live implementation
- Analyzed and defined technical deficiencies and offered suggestions for maximum improvement
- Documented and managed software inaccuracies in a shared defect log
- Trained end users for UAT testing
- Developed corporate-wide Quality Assurance testing templates and procedures
- Facilitated meetings
- Prepared matrices for budgeting and resource requirements
- HIPAA Compliance was met
