PHONE 404-***-**** E-MAIL: acgbge@r.postjobfree.com
Osborne Odhiambo
5+ years of experience in QA and software testing of web based and client
server applications, with a sense of urgency and attention to detail with
the application of the SDLC methodologies and testing tools.
Summary of QUALIFICATIONS:
. Developing and maintaing effective test cases as well as the
implementation of the test scripts and the management of defects/bugs.
. Excellent written and verbal communication skills.
. Experience using standard ETL tools.
. Expertise in manual/Functional & automated testing.
. Experience in relational database design and file processing concepts.
. Proven ability to acquire and maintain technical skills and knowledge
in advanced automation techniques, frameworks and tools
. Experienced in formulating of effective test cases per business
requirements and the application of web based bug tracking tools. I.e.
Mercury Quality Center and Clear Quest.
. Experience in Vb scripting, T-SQL, Python, SQL Scripting.
. Experienced in, regression and Negative testing using Test complete.
. Experience in working in an extremely collaborative environment,
proactively innovating solutions that support the goals and desired
outcomes of Enterprise Technology organization.
. Exposure to automated software performance testing tools i.e. Load
runner.
. Experience in implementing application delivery process by
employing Agile Scrum practices, effectively questioning,
respectfully debating and challenging to deliver business value.
. Experienced in querying RDMS databases using SQL.
. Experience working with different RDBMS database systems, i.e. Oracle,
MS Access, DB2 and MS SQL Server.
. Experience in using mainframe tools and languages in relation to
automation testing.
. Experience in working with teams that are geographically dispersed and
in different time zones and location.
Technical Skills:
. QTP/UFT
. T_SQL
. Python
. Quality Center.
. Visual Studio
. TFS
. MTM
. MS Sql Server DBA
. Proficient with MS Office and similar web based internet applications.
. Oracle 11gR2 12cR1
. VB Script
. UNIX/ Linux
. HTTP, TCP/IP
. MS Sql Server 2008/2012
. MS Word, PowerPoint, Access, Excel, Outlook.
. SQL
. Toad
. Load Runner
Proffesional EXPERIENCE:
Sysco Cooperation, Atlanta GA
ETL QA ANALYST
2011-2014
Sysco is a foodservice marketer and distributor operating across the United
States and Canada. Sysco IT sector maintains a Data Warehouse in order to
increase the efficiency of data retrieved from their OLTP database for
quick and easy access of information to the Company executives and clients.
RESPONSIBILITIES
. Performing ETL and transferring the desired data into their
appropriate Data Marts.
. Writing SQL queries for various scenarios.
. Running record count checks as well as reconciling records with source
data to confirm the quality and validity of the data.
. Attending the daily inspection meetings intended for setting up the
Test Environment and writing the test cases.
. Interacted with Developers and QA Lead, to assist with effective Test
planning and testing.
. Logging and communicating the defects and coordinating the necessary
retesting of the ETL defects.
ENVIRONMENT:
. UNIX/ Linux
. Test Director
. SQL
. TOAD
. Oracle 10g
. IBM DB2
Alere Inc. Atlanta GA
QA analyst/ manual Tester 2009 -
2010
Alere Inc. is a major global developer, manufacturer and marketer of
pioneering consumer and
Professional medical diagnostic products. By developing new capabilities in
near-patient diagnosis, monitoring and health management.
RESPONSIBILITIES:
. Gathered Business and Functional requirement's and design documents.
. Designed and analyzed the test case design document based on the
Functional specified Requirements.
. Worked with the development team and test lead in verifying the test
cases.
. Attended the daily Scrum meetings and providing input and suggestions
on appropriate testing methodologies to adopt for each scenario.
. Created traceability matrices as per the functional requirements for
each module.
. Created test data for each test case scenario.
. Maintained a bug list using the HP Quality Center
ENVIRONMENT:
. Windows/2000//NT/XP
. Internet Protocol Suite (TCP/IP)
. HP QTP/UFT
. HP Quality Center
. Oracle and SQL Server DMBS Platforms
. MS Word, Excel, PowerPoint, Internet Explorer, Outlook.
Cardinal Health Memphis TN
Quality Assurance/Tester 2006
- 2008
Cardinal Health Company improves the cost-effectiveness of healthcare. As
the business behind healthcare, Cardinal Health helps pharmacies, hospitals
and ambulatory care sites focus on patient care while reducing costs,
improving efficiency and quality, and increasing profitability
RESPONSIBILITIES:
. Participated in reviewing and analyzing the business requirements
documents
. Assisting the development team in resolving the critical defects.
. Attended the QA testing team inspection meetings and providing input
and suggestions on appropriate testing methodologies.
. Adapting and transforming the business requirements into feasible test
plans and test cases.
. Executing of test scripts using HP Quick test Professional.
. Created and executed Test Plan/Cases/Scripts/Procedures based on the
Designed Specifications.
ENVIRONMENT:
. HP Quick Test Professional
. Internet Protocol Suite (TCP/IP)
. Hypertext Transfer Protocol (HTTP)
. HP Quality Center
. Oracle and SQL Server DMBS Platforms
. MS Office, Word, Excel, PowerPoint and Outlook.
The Kroger Company Memphis TN
ETL QA ANALYST
2004-2006
Kroger is a foodservice distributor and retailer operating across the
United State. Kroger IT sector maintains a Data Warehouse in order to
increase the efficiency of data retrieved from their databases for quick
and easy access of information to the clients and employees.
RESPONSIBILITIES
. Design routine ETL workflows for data validation and quality tests to
verify successful retrieval of customer data from the source,
verifying it, running ETL and transferring the desired data into their
appropriate Data Marts.
. Participated in inspection meetings intended for setting up the Test
Environment and writing the test cases.
. Logging and communicating the defects and coordinating the necessary
retesting of the ETL defects.
. Worked closely with Developers and QA Lead to facilitate effective
Test planning and Test case design.
. Involved in backend database testing using SQL.
ENVIRONMENT:
. UNIX/ Linux
. Test Director
. SQL
. TOAD
. Oracle 10g
. IBM DB2
Communications Test Design INC. Memphis TN
ETL QA Analyst
2001-2004
CTDI is a full-service, global engineering, repair and logistics company
providing best-cost solutions to the communications industry.
RESPONSIBILITIES:
.
. Performed backend testing by conducting initial ETL tests manually
using SQL script queries.
. Documenting and executing Test plans, Test cases and Test scripts
based on business requirements
. Attended and participated in all peer review, inspection and walk
through meetings.
. Reported and documented defects/bugs and sent Email notifications to
the developers.
. Assisted the development team in identifying and resolving defects.
ENVIRONMENT:
. Windows
. SAP Net Weaver 7.0 BI, Data Warehouse Solution
. SQL
. Mercury test director.
. MS Outlook
EDUCATION
Institute of Advanced Technology (Nairobi-Kenya)
1998-2000
Diploma Computer Science
Rust College (Holly Springs MS)
2001-2003
Computer science
University Of Memphis (Memphis TN)
2004- 2006
BSc Computer Science
Pursuing Certifications MCSA, CSTE
2014