Quality Assurance Project
Resume:
Michael W. Rogers
**** **** **** *****, ******, TX 76502
Cell: 317-***-****
E-mail: *******@*****.***
PROFESSIONAL SUMMARY
My background includes business, technical and leadership experience in
Information Technology with regards to the Pharmaceutical Medical
Devices/Healthcare, Government/Military, Loan and Energy industries.
Throughout my career I have gained advanced experience from working in
several Technical and Quality Assurance positions where I have developed
solid skills in Business Analysis, Manual and Automated Software Testing,
Technical Writing & Document Control, Quality Engineering, CAPA, Six Sigma,
FMEA, Planning & Scheduling, Software & Equipment Validation, System
Audits, Release Management and Change Control Processes. With the ability
to quickly analyze business and technical issues, assume a leadership role
and communicate effectively with clients and team members I have gained a
wealth of experience and been involved in many projects with successful
outcomes.
Quantifiable skills include but are not limited to gathering business and
technical requirements, interviewing subject matter experts, creation of
software test cases/scripts, test execution, bug tracking/resolution,
development of functional specifications and creating, editing, reviewing
and gaining approval of essential project documentation. Experienced in
leading the testing efforts for multiple ongoing projects while
concurrently prioritizing all other associated tasks and ensuring there is
attention to detail as well as quality are also part of the skill set as
well as providing technical training, evaluating system processes,
establishing metrics and implementing quality assurance programs to ensure
compliance with applicable regulations within assigned functional areas.
. Salary Requirements:
> Contract/W2 @ $35-50 USD/Hr. Range
> Direct Hire - Negotiable
. Active U.S. DoD Security Clearance: Secret
Business Process and Application Development Methodologies-
. Comprehensive knowledge of Software Development Life Cycle (SDLC),
having thorough understanding of various phases like Requirement
gathering/elicitation, Analysis/Design, Technical
Writing/Documentation, Development and Testing.
. Comprehensive Knowledge of Methodologies like Waterfall, Spiral,
Rational Unified Process (RUP), Agile/SCRUM, Capability Maturity
Models (CMM) and Six Sigma Techniques.
. Proficient in Object Oriented development processes and knowledge of
UML in implementing Use Case Model, Use Case Diagrams, and Class
Diagrams using Rational Rose and MS Visio.
. Extensive experience in developing creating Screen Mockups, conducting
Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit
Analysis, Risk Analysis.
Requirement Elicitation, Artifacts Creation and Analysis-
. Excellent facilitation skills in conducting walkthroughs, surveys,
questionnaires, interviews, brainstorming and Rapid and Joint
Application Development Sessions (RAD & JAD).
. Extensive experience in gathering, managing and documenting business
and functional requirements, communicating effectively with upper
management, developers and QA engineers.
. Extensive experience in writing Business Requirements Document,
Functional Specifications document, Non- Functional Requirement
Document, Technical Specification Document.
. Proficient in performing Gap Analysis, by evaluating the key
differences between the AS-IS and the TO-BE system and identifying the
key requirements for system reengineering and documenting them.
Project Management-
. Experience in developing Project Scope/Vision/Charter Documentation,
Project Plan, tracking project process, and managing resources to
ensure successful delivery and strong data repository experience of
preparing the project schedules, milestone tracking, and resource
allocation using MS-Project.
. Extensive experience working with PMO to write Requests for
Information, Request for Proposals, Statement of work and handing out
contract to vendors.
. Capable of Analyzing and tracking multiple projects, generate reports,
PMO metrics and resource allocation.
Technical Experience-
. Understanding as Business Analyst the collecting and analyzing
client's business requirements of OLTP, ETL
(Extraction/Transformation/Loading), Data Cleansing, Data Mapping,
Data Modeling, Data Mining, Data Manipulation and Designing.
. Extensive experience with Unified Change Management tool using
Rational Clear Quest, Configuration Management tool using Rational
Clear Case and requirements management solutions.
. 4 + Years of working experience in ecommerce and web-related projects
(site enhancements, site migrations & new site developments) using
different web technologies.
. Experienced in writing SQL, T-SQL statements.
Testing/Quality Assurance-
. Experienced in planning and executing tests from large system wide
tests to Black box, White box, UAT, End to End, Integration,
Functional, Stress, Regression, System testing, Data Driven,
Automated, Manual and Performance Testing.
. Exceptional problem solving and sound decision making capabilities,
recognized by alternative solutions, and confident, accurate, decision-
making coupled with excellent communication and interpersonal skills.
Excellent track record for meeting deadlines and submitting
deliverables on time.
Interpersonal Skills-
. Highly motivated team player with excellent Interpersonal and Customer
Relational Skills, Proven Communication, Organizational, Analytical,
Presentation Skills, and Leadership Qualities.
Skills:
Requirement/Application Management Tools: Rational Requisite Pro, MS Office
Suite, MS-Project, Share point Portal Server
2003/2007
Repository Management: Rational ClearCase, SharePoint, Remedy & Documentum
Methodologies: Waterfall, Agile, Capability Maturity Models (CMM).
Relational Databases: SQL Server 2005/2000, Oracle 10g/9i/8i, MS Access.
Operating Systems: Windows NT/2000/2003/XP/Vista, UNIX.
Quality Assurance Tools: Load Runner, Test Director, Quick Test Pro,
Quality Center, Rational Functional Tester, MS-Visual
Studio Team Server-Test Edition, FogBugz, TOAD, SnagIT
Languages: SQL, PL/SQL and T-SQL, HTML, XML, Java script and Visual Basic
Script.
ETL Tools: DTS, SSIS, Informatica.
Reporting Tools: Crystal Reports XI and Cognos 8.1.
work experience
Austin Energy, Austin, TX.
IBM/Veracity Solutions Consultant
July 2010 to Present
Lead Business Systems Analyst/Technical Analyst
Project Description:
This project involves the replacement of Austin Energy's legacy asset
management systems with an implementation/integration of IBM's Maximo
solution.
Roles and Responsibilities:
Business Requirement Gathering and Artifacts Creation-
. Work in conjunction with team leads to review, analyze, and recommend
changes and improvements to the gather requirements and documentation
and to develop a vivid presentation which used personas and scenarios
to establish themes illustrate overarching concepts and establish the
high level user experience requirements.
. Elicit, Capture and document functional and non-functional
requirements from clients and write supplementary specifications
documents for non-functional requirements for the web application.
. Facilitate Joint Application Development (JAD) Sessions for cross
functional teams participating in business process modeling, business
process performance measurement, and business object modeling and use
case development.
. Authored Business Requirement Document (BRD), GAP analysis
documentation, which included finding the gaps in the existing
processes and recommending new processes. Recommended new/modified
requirements as a result of GAP analysis to assist clients needs
better.
Business Process, Business Applications and Process Analysis-
. Reconciled functional and user experience requirements for accounting,
inventory and purchase requisitions.
. Developed Business Process Diagrams (BPDs) for the current system (AS-
IS) and the TO-BE system.
Technical Roles and Responsibilities-
. Partnered with the technical architecture team to document and refine
information flows, process sequences, and system enhancements needed
to support the user experience.
. Interfaced with application architects, subject matter experts
(SME'S), managers, quality review specialists, and service team
supervisors.
. Documented and managed deployment and cut-over processes for DEV, TEST
and Production environments.
. Created Project plans and schedules for installation, configuration,
and deployment of the Maximo solution.
UML Diagrams and Business Process Diagrams-
. A major part of the responsibility included interacting with the Users
and Business relationship managers and facilitating implementation of
changes using ERD diagrams created in MS Visio on the database in
order to ensure approval from process owners.
. Created UML Diagrams like Use Case Diagrams, Activity Diagrams,
Sequence Diagrams and ER Diagrams in MS Visio.
Project Management and Best Practices-
. Assisted Project Manager in planning the project time-line and
scheduled various project deliverable dates according to the various
phases of the project
. Developed and maintain the integrated Master Project Plan for cross-
functional teams.
. Prepared project reports for management and assisted the project
manager in the development of weekly and monthly status reports,
policies and procedures.
Quality Assurance-
. Analyze the Business Requirement Document (BRD), Functional
Specification/Requirement Documents (FRD) to prepare Test Cases based
on Test Plans in order to perform Performance Analysis.
. Collaborated with QA and Development managers to institute a flexible
SDLC for the web development team, worked with the QA manager to
define the end-to-end testing scenarios of various applications within
the Maximo solution.
. Participated actively in team meetings with Functional/Development
Team for fixing the bugs and documented the traceability matrix for
tracing the Test Cases and requirements related to them.
. Involved in the automation of the functional and regression test and
performed the integrated scripting and debugging processes.
[pic]
Green Mountain Energy Inc., Austin, TX.
TEKsystems Inc. IT Consultant April
2010 to July 2010
Lead Test Engineer/Business Analyst
Project Description:
This project involved the replacement of the company's Customer Relations
Management (CRM) system by an integration of Oracle's Siebel and Lodestar
applications with the company website.
Roles and Responsibilities
Business Requirement Gathering and Artifacts Creation-
. Responsible for streamlining business processes through analysis,
design and also involved in project management, risk assessments and
mitigations, creation of process flows according to the business
requirement and change enabling quality controls.
. Conducted JAD sessions for gathering and analyzing high-level business
requirements, system requirements needs and responsible for
understanding and translating business and system functional needs
into Business Requirement Document (BRD), System Requirement Document
(SRD), and Functional Specification Document (FSD).
. Involved in all aspects of the documentation generation/management of
new processes and applications. Aspects include conception, research,
planning, design, integration and system/usability testing, through
documentation management and support.
. Coordinated customer goals with appropriate I/T investment to meet the
business need working with both the business direction and acceptable
architectural solutions that can be supported by I/T support
organization.
Business Process, Business Applications and Process Analysis-
. Created navigation structures and information designs, as well as
constructed prototypes, storyboards, and mockups (Used Snag it) for
the web based product to effectively communicate designs to
development teams.
. Interacted with designers and software developers to create and
present the Screen Shots/ Screen Designs / Screen Mockups to developer
and business users in weekly meetings and kept user up to date with
the current status of the project, timeline and budget of the project.
. Performed GAP analysis to compare the existing system with the
proposed system and documented new requirements and features.
. Assisted in developing User Guide to help users understand full
application and assisted trainers in creating scenarios for training.
Technical Roles and Responsibilities-
. Developed mockup/prototype interaction designs, including user
interaction models, information architecture, wire frames and screen
flows.
. Developed and incorporated Joint Application Design session best
practices into company implementation methodology, reducing gap
analysis time by 70%.
. Developed sequential SQL queries and stored procedures to generate
statistics, and developed Excel pivot tables to report the results.
UML Diagrams and Business Process Diagrams-
. Created business workflow diagrams and Use Cases Diagrams, Activity
Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration
Diagrams by following the UML methods by using MS Visio.
Project Management and Best Practices-
. Defined version and change control strategies, and provided tactical
recommendations for short and long-term success with the Business
Information Systems Infrastructure Management Committee.
Quality Assurance-
. Examined, analyzed and modeled test approaches, test plans and test
procedures. Actively involved in developing, executing, and
coordinating Integration and User Acceptance Testing (UAT).
. Reviewed and analyzed Use cases and came up with System design and
test plan templates, defined, performed test strategies and associated
scripts for the verification and validation of all defined business
requirements and associated functionality.
[pic]
Eli Lilly Inc., Indianapolis, IN
TEKsystems Inc. IT Consultant November 2007 to
January 2010
Software QA Validation Engineer/Business Systems Analyst
Project Description:
Involved in multiple computer system validation projects including Data
Warehouse, CRM, ERP, R&D, QA (CAPA) and Laboratory Systems (LIMS)
applications.
Roles and Responsibilities:
Business Requirement Gathering and Artifacts Creation-
. As a Business Analyst was accountable for analyzing and defining
requirements and functionality for web-based information systems and
other solutions to meet the Company's business needs.
. Facilitated requirements gathering sessions for cross functional teams
participating in business process modeling, business process
performance measurement, and business object modeling and use case
development.
. Facilitate JAD and JRP sessions to gather functional and technical
requirements, prepared formal requirements documentation like use
cases, data flow diagrams, and GUI design, system design diagrams.
. Integrate with the end-users and business relationship managers to
understand the current process to gather change requests, business
requirements.
Business Process, Business Applications and Process Analysis-
. Captured business requirements and develop specifications for Crystal
Reports.
. Performed Gap Analysis to check the compatibility of the existing
system infrastructure with the new business requirements and prepared
project plan and solution documents and coordinated with multiple IT
teams (Development, QA, Vendors) both internal and external, to ensure
delivery of product within tight deadlines.
. Created and maintained the Requirement Traceability Matrix between the
requirements and other products such as design documents and test
plans.
Technical Roles and Responsibilities-
. Interfaced with application architects, business analysts, healthcare
provider information specialists, managers, quality review
specialists, and service team supervisors to gather requirements and
upgrade the Data Elements Index and Glossary.
. Attended data mapping, data modeling in Extract, Transform and Load
(ETL) for migration of data from legacy system and worked closely with
the data analysts, to reduce the redundancy of the gathered data
elements.
. Worked with the Data Conversion (Data warehouse / data marts /
repository) team to ensure the crucial data is not lost during the
conversion and duplicate data can be deleted.
. Designed, wrote, and produced glossy bound reports featuring Excel
charts and pivot tables.
UML Diagrams and Business Process Diagrams-
. Created UML Diagrams including Use Cases, Activity Charts, Sequence
diagrams, Data Flow Diagrams and ER Diagrams using Rational Rose and
MS-Visio thus defining the Business Process Model and Data Process
Model.
Project Management and Best Practices-
. Applied PMO methodologies and standards for business cases, project
charters, critical path analysis, work breakdown structures, reporting
intervals, and other controls needed to successfully manage I.T.
oriented projects.
Quality Assurance-
. Worked with Test Manager for a large mainframe/web testing, overseeing
multiple test teams through all phases of testing and supervised and
approved a complete set of UAT test scripts to ensure completeness of
the implementation and of the end-to-end functionality.
. Developed the test plans for GUI, Functionality Testing, System
Testing, UAT and Integration testing.
[pic]
Sallie Mae Inc., Fishers, IN.
Direct Hire Employee
November 2005 to November 2007
Programmer Analyst II, QA Testing
Project Description:
Multiple projects concerned with the maintenance and upgrade and patch
implementation for the company's online student loan solution.
Roles and Responsibilities:
Business Requirement Gathering and Artifacts Creation-
. Provided strategic planning, business process modeling, business
process analysis, object-oriented analysis & design, use case
modeling, use case analysis, component-based development, and quality
assurance.
. Gathered Business Requirements, analyzed data/workflows, and defined
the scope, developed project status metrics for weekly evaluation of
project status and analyzed the impact of the open issues and change
request on the project plan.
. Met with client groups to determine User Requirements and Goals, thus
converting User Requirements into Business Requirements and Functional
Requirement Specification.
. Set up meetings, conducted Walkthroughs, JAD sessions with Management,
Subject Matter Experts, vendors, users and other stakeholders in
different departments to elicit requirements, and understand their
vision of what the system should do and look like ( AS-IS and TO-BE
process).
. Facilitated collection of Business Requirement Documents (BRD),
Functional Requirements Specification (FRS) from system users and used
MS-Visio for creating Use Case Models and Use Case Specification
documents.
Business Process, Business Applications and Process Analysis-
. Developed processes / procedures; set up document repository, worked
directly with end users to shadow and in some cases perform their jobs
to better understand their requirements and to facilitate the creation
of step-by-step instructions and workflows.
Technical Roles and Responsibilities-
. Responsible for analysis and translation of user requirements into
functional and technical specifications, give design recommendations
and work with developers to ensure successful application delivery
throughout the SDLC.
. Used SSIS for data integration level of building validations, Created
Tables, Views, triggers and Stored Procedures and assisted in
development of new products and support of Decision Support System
with extensive use of TSQL (MS SQL Server 2005) in web based OLTP
environment.
Project Management and Best Practices-
. Project Major Deliverables for SDLC Phases included creation of system
development methodology documents: Scope, Test Scripts, Rough Order of
Magnitude (estimates), Design, Implementation and Post Implementation,
mitigation plans, weekly project status reporting (project metrics)
and detailed task lists/problem logs.
Quality Assurance-
. Reviewed and analyzed the Use cases and came up with system design and
test plan templates and created test plans, test cases and test
strategy for by using HP Quality Center.
. Defined and performed the Test strategies and associated scripts for
the verification and validation of all defined business requirements
and associated functionality and actively involved in developing,
executing, and coordinating User Acceptance Testing (UAT).
. Provided training to end users in using the new application as well as
explained the basic functionality and features/benefits, and status
reporting, analyzing and project planning.
[pic]
Thermo Fisher Scientific, Indianapolis, IN.
Direct Hire Employee
March 2003 to October 2005
Business Analyst/QA & Validation
Project Description:
Involved in multiple projects including the development and validation of
the company equipment calibration system, pharmaceutical manufacturing
equipment and document control system.
Roles and Responsibilities:
Business Requirement Gathering and Artifacts Creation-
. Facilitated Joint Application Development (JAD) sessions, Gathered
requirements using interviews, document analysis, requirements
workshops, storyboards and surveys.
. Gathered Business Requirements, interacted with the Users, Designers,
Developers, Project Managers, and SME's to get a better understanding
of the Business Processes, and analyzed and optimized the process.
. Prepared Business Requirement Documents (BRD) and used Requisite Pro
to manage, analyze, and convert business requirements into functional
specifications.
. Worked as an Interface between the users and the different teams
involved in the application development for the better understanding
of the business and IT processes, and communicated enhancements/new
features to stakeholders.
Business Process, Business Applications and Process Analysis-
. Responsible for producing process flow diagrams for TO-BE process
flows and AS-IS process flow's using Microsoft Visio.
. Responsible for analyzing and translating business requirements for
the development of business rules.
. Worked extensively with SMEs in understanding and documenting their
requirements.
Technical Roles and Responsibilities-
. Lead, managed and monitored full life cycle projects from conception
to implementation.
. Created and maintained an instrument calibration database to meet FDA
compliance standards.
. Automated instrument calibration report generation.
MS Visio Business Process Diagrams-
. Communicated requirements, architectures and designs using MS Visio to
create diagrams.
Project Management and Best Practices-
. Assisted the project management in designing project plans, validation
master plan, communication plan, change tracking, validation
protocols, resource management and quality management.
Quality Assurance-
. Provided overall management to multiple projects successfully
completing them on-schedule, on- budget and Involved in project
planning, coordination and implementation of QA methodology.
. Analyzed team performance with the QA manager and implemented the
changes if any, with respect to raising the efficiency of the entire
team.
. Leadership of functional, regression, integration and UAT testing
efforts.
[pic]
Bayer Inc., Elkhart, IN.
Direct Hire Employee
January 1984 to February 2002
QA/R&D Scientist, Medical Devices
Project Description:
Involved in multiple projects in the research and development of medical
devices, specifically for blood glucose determination. Ultimately involved
in the validation and qualification of software applications used in the
operation of laboratory and business equipment.
Roles and Responsibilities:
Business Requirement Gathering and Artifacts Creation-
. Interacted with client, conducted meetings and gathered requirements
by conducting brainstorming sessions, interviews and JAD sessions to
understand and formalize the business requirements with various SME's
at various phases of the SDLC to discuss open issues and resolve them.
. Responsible for analyzing and defining detailed business user
requirements, developing use cases and activity diagrams, and editing,
updating, and analyzing workflow processes.
. Facilitated collection of Functional Requirements Specification (FRS)
from system users and prepared of Business Requirement Documents (BRD)
by using Rational Requisite Pro along with applied MS-Visio for
creating Use Case Models and Use Case Specification documents.
Business Process, Business Applications and Process Analysis-
. Identified and designed the business rules per the business
requirements and documented these rules for deployment
. Followed structured approach to organize requirements into logical
groupings of essential Business Processes, Business Rules, and
information needs and ensured that critical requirements were met.
. Analyzed the Business Concept to understand the customer needs. Worked
with various functional groups to understand the underlying concepts.
Technical Roles and Responsibilities-
. Functioned as an R&D / QA scientist with responsibilities for product
development, validation and testing of medical device products,
research facilities, manufacturing equipment & processes and computer
software applications utilized for research and development and
quality assurance activities
. Validation of R&D software and equipment including Mass Spectrometry-
GC, HPLC, Rheometric Analyzers, cyclic voltammeters and manufacturing
equipment.
. Create, edit, review and gain approval of all test scripts, test cases
and validation (i.e. IQ, OQ, PQ) documentation
. Performed raw material and prototype validation and testing using
clinical laboratory analyzers, HPLC, Spectrophotometry, Mass
Spectrometry-GC, titrations, pH, LOD, rheometric measurements and
cyclic voltammetry
. Routinely performed statistical data analysis and reported
experimental results in group meetings and in written reports
Project Management and Best Practices-
. Developed Project Status metrics for weekly evaluation of Project
Status and impact of the Change Request on the time line.
Quality Assurance-
. Defined and performed the Test strategies and associated scripts for
the verification and validation of all defined business requirements
and associated functionality.
. As a part of software maintenance task team, Assisted the team
responsible for reducing production defects. Assisted in establishing
a process for quantifying defect requests for prioritization. Improved
project team relations.
. Responsible for keeping laboratory records and other vital scientific
documentation to support QA and R&D project requirements in meeting
FDA standards for product development
education/certifications
College:
Columbia Southern University
25326 Canal Road
Orange Beach, AL 36561
August 15, 2009 - Associate Applied Science - Information Technology,
4.0 GPA
BS - Information Technology (In Progress, Senior Standing)
Technical/Professional Training:
School of Healthcare Sciences, United States Air Force
Sheppard AFB
Wichita Falls, Texas
Graduated June 15, 1979 -Certification, Pharmaceutical Technology
Military Background
United States Air Force
Carswell AFB
Fort Worth, Texas
February 1979 - June 1983: Staff Sgt. (E5) / Pharmacy Specialist,
Certified
. Performed inpatient and outpatient hospital pharmacy duties
. Maintained pharmacy systems documentation
. Pharmacy computer system maintenance
. Pharmacy software service and support including applications testing
and maintenance
. Filled prescriptions and provided patient consultation
United States Air Force (Reserve)
Lackland AFB
San Antonio, Texas
Active Security Clearance: Secret
June 1992 - Present: Technical Sgt (E6) / Integrated Avionics Systems
Specialist
. Avionics electro-mechanical maintenance, repair, operational checks,
calibration and validation of aircraft guidance and control systems
. Troubleshooting and repair of avionics equipment failures using
technical order manuals and schematics
. Performance of quality inspections in regards to aircraft maintenance
and modification programs
. Avionics Computer Software support, Information Security, user
training, testing & validation
. Management and planning of aircraft modifications, maintenance and
quality control
. Preparation of aircraft maintenance documentation for quality
assurance
Contact this candidate