PAUL W. RUFFIN
SUMMARY:
·
Highly motivated, versatile IT professional
(Business/Systems analysis and Quality
Assurance) with proven record of successful design and implementation of
applications for mainframe and client server based systems.
·
Accomplished problem solver with
wide-ranging experience in systems design and architecture, testing and
programming. Superior communication skills gained through exposure to
international projects and multinational teams.
TECHNICAL SUMMARY:
|
Hardware: |
IBM
3090, 4381, 3390, Solaris, HPUX, Personal Computer (IBM and Macintosh),
ThinkPad, Mac G4 |
|
Systems: |
Office
2000, UNIX, IBM MVS/ESA, MS DOS, Windows 95, 98, Windows NT, XP |
|
Languages: |
PL/SQL,
JAVA, HTML, XML, XSL, J2EE, javascript, Oracle 8i,
9, Sybase 12.5, VB.NET, Visual Basic 6.0, C, C++, perl,
Assembler 370, COBOL, VS COBOL II, JCL, Easytrieve |
|
Databases: |
DB2,
Access, Paradox for Windows |
|
Software: |
Peoplesoft CRM Vantive v 9.0.2, Rational Tools Set (Test Manager, Clearcase, Requisite Pro, Clearquest,
Robot), Peoplesoft 8.4.5, Tibco
Administrator, ILOG Business Rule Studio 2.1, Quick Test Pro 6.5, SQL
Programmer, IBM Visual Age for java, java server pages, java Beans, SQL Plus,
SQL Loader ,DB Artisan, Quest Software Toad VI, Lotus Notes, Mercury TestDirector, Business Objects, ACE, Visio, MS Office, UltraEdit, Crystal Reports, VSAM, Micro Focus Workbench
for Cobol, CICS, TSO/ISPF, Kenan Systems ARBOR/BP
FX 11, 10.5, 10.1, 9.1, 8.1, 7.X, 5.0, 3.0, PeopleSoft CRM v 9, Amdocs Ensemble 3.0 |
|
Concepts: |
Lean ADM, Agile, SOA, SOAP, UML,
Use Cases, Rational Unified Process, OOAD, System Process Modeling, Data
Modeling, Problem Analysis, Structured Programming Design and Techniques,
Debugging, Testing Procedures, Plans and Scripts, Database Schema and File
Manipulation, Table Handling |
WORK EXPERIENCE:
|
January 2008 to May 2009 |
End-to-End Test Analyst
·
Following a Lean ADM process I configured, prioritized, developed and planned test cases and test scripts using Rational Test Manager with emphasis on test case traceability.
·
Ensured requirement traceability by analyzing requirement artifacts including use cases, and system and design specifications (BRD, Vision documents, SRS, application design documents).
·
Analyzed, prepared and
developed test data.
·
Developed effort
estimations for resource planning and scheduling.
·
Resolved problems
with software and documentation.
·
Provided support for
issues involving test criteria and specifications.
·
Analyzed and co-ordinated
requirements for preparation, maintenance and scheduling of test environment.
·
Conducted regression test
analysis after installation of fixes in defect management system (Rational Clearquest).
|
Telefonica-o2- Munich,Germany
|
May 2006 to December 2007 |
Component Test Analyst Salcus
CRM application
·
Analyzed requirements and tests to validate the systems under development.
·
Developed test cases derived from the system and design specifications.
·
Planned test scenarios.
·
Provided data provisioning and or data creation for test execution using PL/SQL, perl scripts or database manipulation tools.
·
Executed test cases via either the gui or invocation of packages or procedures.
·
Monitored test progress and validated test results.
·
Tracked and documented errors, resolved and retested open defects.
·
Compiled test documentation including test completion reports.
·
Consulted and advised application owner and users during acceptance testing.
·
Functioned as technical test interface between development and business stakeholders.
|
November 2005 to April 2006
|
Component Test Analyst – Upgrade to Kenan Arbor FX
·
Analyzed, prepared, validated and documented
test scenarios and scripts in Test Director in support of the migration of
BT’s billing engine from Kenan Arbor v 10.1 to Kenan FX (v.11.5).
·
designed
and implemented data setup (test accounts, etc) to validate the databuild for usage, recurring and non-recurring charges,
discounts, adjustments, and GUI functionality.
·
Executed tests and documented test output in
Test Director.
·
Designed, implemented and executed
regression testing schema.
·
Supported End-to-End and Operational
Readiness testing and parallel processing of new billing platform.
|
o2- Munich,Germany – Project
Galileo |
March 2005 to September 2005 |
Lead Installation and Integration Test
Analyst
·
Analysis and assessment of Business Use
cases for testing and operational feasibility.
·
Oversight of pre-integration test strategy,
test plans and test scripts created by 3rd party vendor for functional and
formal completeness, consistency and accuracy to enforce adherence to RUP
(Rational Unified Process) and O2 internal software installation standards.
·
Review pre-integration test output to
verify/enforce robustness of testing procedures.
·
Developed Installation and Integration test
strategy and plans.
·
Created Installation and Integration test
data and test data management plan.
·
Developed Test Manager scripts
for installation testing based on entry, exit and performance criteria of
overall project test strategy for the core applications of the system. The
applications implemented and tested included Peoplesoft
CRM, ILOG JRules (business rules engine), Tibco Administrator (EAI application), and KenanFX (billing application).
·
Conducted application specific System
Installation testing of the core applications mentioned above. The testing
included RUP required design and documentation deliverables as well as basic
functionality.
·
Documented and tracked defects in Rational Clearquest.
·
Reviewed End-to-End test strategy, plans and
test scripts created by 3rd party vendor to ensure coverage and traceability of
Use Cases to test cases thereby enforcing strict adherence to RUP standards.
·
Reviewed End-to-End test data management schema.
·
Reviewed End-to-End test output to
verify/enforce accuracy and robustness of testing procedures.
|
o2-Munich, |
November 2004 to February 2005 |
Quality Assurance, End-to-End Test Analyst ARBOR
BP v11
·
Analyzed, prepared, validated and documented
test scripts in Rational Test Manager and Requisite Pro.
·
Conducted End to End System (GUI to db) and
Integration testing of provisioning, usage processing, billing and payments for
retail customer stack for full range of O2 products and features
(Voice, Data, GPRS, WAP, Internet, etc).
·
Supported System Integration test team with
billing and payments processing and test verification.
·
Analyzed and documented test results and
reported results in Rational Test suite.
|
Proximus, Namur, Belgium
– Consultant
|
May 2004 to September 2004 |
Business/Systems Analyst
·
Gap Analysis for Bonus process (tiered
discounts) for Network products (MMS, SMS, LES, WAP).
·
High level design, System architecture and
process analysis for end to end Revenue Settlement processes.
·
Developed solution architecture for the IP
Billing and Provisioning project (extraction and accumulation of WAP data).
·
Production Support for customer migration
from short term solution to Revenue Settlement system and SAP.
·
Coordinated/assured data integrity across
multiple databases for connectivity, billing, settlement and financial
reporting.
·
End to End System and Integration testing of
CRM GUI, provisioning, usage processing, billing, invoicing and reporting.
|
Proximus, |
October 2003 to April 2004 |
System and Integration Test Analyst/Team
Leader
·
Supervised a small team which conducted the
execution and analysis of test output and verified replication and
synchronization of front end database (Sybase v 12.5) with backend billing
engine (Arbor BP 10.5 running under Oracle 9).
·
System and IntegrationTesting
of synchronization of CRM with new billing system for Proximus
(Belgian cellular phone provider).
·
Assured software quality by developing test
plans, cases and scenarios as well as test scripts from business cases to
verify Product profile billing. Verified billing and rating of multiple usage
types for voice and data, including national, international and roaming.
|
SITA, Paris,
France– Consultant
|
August 2000 to July 2002 |
Migration Analyst/System Integration Test
Analyst/Systems Analyst
·
Responsible for testing migration of Global
legacy telecom billing system to ARBOR BP version 9.1 running on Oracle.
·
Created test plans, test scripts, test data
and executed the scripts to validate the end-to-end functioning of the billing
process. Validated results using SQL, Oracle and Business Objects to replicate
bill summary and detail items.
·
SQL analysis and repair of records rejected
by the preprocessing modules (in-house mediation engine) or by the Arbor BP
billing application (MIU). Recommended design or software changes to stored
procedures/SQL to prevent record fallout.
·
Gathered requirements and designed,
developed and implemented an automated file transfer and filtering process to
facilitate transmission of customer data from the legacy platform (mainframe)
to the new billing platform (ORACLE rdbms).
·
Development and validation of SQL and stored
procedures for customized billing contracts.
|
AJILON INFORMATION TECHNOLOGY SYSTEMS
– Consultant |
July
1999 to July 2000 |
Assigned to: Prudential,
Finance Operations & Systems: Demutual Datafile, DATA
ENHANCEMENT FACILITY (DEF)
Systems/Business Analyst - Sybase, UNIX,
Client Server, Mainframe, PC
·
Responsible for data integrity/validation
for Prudential’s CRM data warehouse. I conducted data analysis across
multiple platforms using SQL, UNIX and Cobol II programs and utilities.
·
Collected business requirements via
teleconferences and JAD sessions from users and interfacing systems in order to
design and develop new validation processes, as well as to design and develop
enhancements to existing systems and processes.
·
Created program specifications for
enhancements to the middleware and the VB front-end of the DEF, including data
and window content changes. Substantially reduced data inaccuracy to a
manageable degree, with a resultant savings in human and systems resources.
·
Created test plans, test cases, test data
and assisted in quality assurance system testing and user acceptance testing in
support of the de-mutualization process and Initial
Public Offering of Prudential.
|
ORANGE Communications SA - |
January 1999 to June 1999 |
·
Finance
Operations UAT Test Analyst - responsible for
design and execution of UAT Payments and Collections scenarios and scripts for
Swiss market launch of cellular Phone Company. The billing engine was Amdocs Ensemble running under Oracle.
·
Assisted in use case analysis of the
provisioning process, and products, features, and packages for GSM cellular
service and all of the interfaces for various automated payment methods (BVR,
Credit Card and Direct Debit).
·
Working from use case analysis I assisted in
the definition and creation of the required Billing, Payments and Collections
test data, verified and documented results and designed tools for analyzing
test results.
·
Designed scenarios and scripts for missing
and unallocated payments, installment and partial payments, refunds, deposits,
waivers and adjustments, as well as the entire Collections process.
·
Executed and validated
tests on provisioning, rating, usage, payments, adjustments and collections
processes.
|
VIAG
|
May 1998 to December
1998 |
Business/Systems Analyst
·
Business/Systems
Analyst responsible for ARBOR MIU (Message Investigation Unit) function.
·
Intense SQL based Analysis and investigation
of call detail records (national and roaming) rejected by the guiding and
rating modules of the Arbor BP billing application. Additional duties consisted
of the development, configuration and end-to-end system testing and production
implementation of the TK_Billing and BOL/BV
electronic invoice projects.
·
Participated in JAD sessions to gather
business and technical requirements and created functional specifications for
the throughput of the billing and collection systems with particular emphasis
on Concert Packet Services (CPS), the EDI translation process, the Direct Debit
process (EFT), and bill presentation and formatting (BIF) issues.
·
Designed and documented test plans, test
cases and expected results as well as supervised and verified test results for
the EDI, Direct Debit, and Object based TK_Billing projects.
Created operational training guides for the TK_Billing
and direct debit projects.
|
IMI SYSTEMS, |
March 1998 to May 1998 |
Business
Systems Analyst /Programmer- AT&T MultiQuest 900 Number Billing System.
·
Systems and business analysis, programming
development and maintenance of ad-hoc revenue and financial control reports.
·
Designed and developed programs to
reconcile/recover revenue charged against the Multiquest
billing system by other carrier (LEC) systems.
·
Interacted with business users and customers
to identify issues, collect requirements and design and develop specifications
for processes to reconcile billing and revenue issues between AT&T and its Multiquest vendors.
|
System Engineer - AT&T Local Billing System (LIMBS) |
January 1997 to February 1998 |
·
UNIX, C, SYBASE, SQL business and systems
analyst responsible for design and analytical support for the Local Billing
project (LBS).
·
Partnered with the user community on a
weekly basis (sales, CRM, LSPs, network providers,
vendors) to identify and resolve issues, collect requirements, and re-engineer
the Object based processes supporting the Inside Wire Time and Materials
project.
·
Extensive use of SQL for table analysis and
program errors of automated provisioning process (Inside Wire Time and
Materials).
·
Supported the LBS migration from Kenan Systems ARBOR/BP Version 3.0 to 5.0, specifically for
MVS usage processing, multiple server analysis, the Inside Wire Time and
Materials Project (development and configuration of Arbor and non Arbor tables
for Equipment, Customer Care, Account Creation and Provisioning), the Incentive
Tracking System (ITS) and the World Class Database Marketing Project. Provided
production support for MVS usage processing, file transfers to UNIX, database
data loads and ARBOR faults/errors (message investigation for records failing
the provisioning, rating, guiding or billing processes.)
|
Programmer/Analyst AT&T MultiQuest 900
Number Billing System |
November 1995 to December 1996 |
·
Provided development, analysis, daily
production support using COBOL II, JCL, VSAM and Easytrieve.
·
Investigated and analyzed operational
problems, user requests and system to system change requests.
·
Assisted in the requirements gathering
process used to transition the mainframe platform to an Oracle/C++/UNIX
production platform.
|
Systems Analyst AT&T WEFOS 800 Number Billing System |
May 1995 to October 1995 |
·
Developed logical design documents (draft
and final) for change requests.
·
Designed and developed test plans, test cases,
and expected results.
·
Presented projects at developer walkthroughs
and analyst walkthroughs.
EDUCATION:
The CHUBB Institute,
|
Diploma (with Honors)
in Business Application and Web Development |
July 2003 |
The CHUBB Institute,
|
Diploma in Application Programming |
April 1995 |
The University of Michigan Law School,
|
Juris Doctor |
|
Yale University,
|
Bachelor of Arts, History |
|