Quality Assurance Project Manager

David o'dwyer alexander

***** ********** *** # ** ( NORWALK, CA 90650 ( PHONE: 714-***-**** (

******.*********@*******.***

PROJECT MANAGER

Fortune 500 client server enterprise implementation consulting and business

systems analysis project manager. A proven ability to deliver seamless

implementations with next-generation technical solutions that improve

revenues, margins and workplace productivity.

http://www.linkedin.com/pub/david-alexander/7/a10/948

Expertise Highlights

Data/Business/Systems Analysis Major SDLC Software/Systems

HRIS analysis (Lawson, PeopleSoft, Implementations

& ADP) Technical Writing (SOP/Manuals/System

Specs)

Client services and account Designing/re-engineering processes and

management workflows

Defined business and functional Large-scale enterprise migration

requirements and specifications projects, systems conversions,

performance tuning, and monitoring

Leveraged QA, data conversion System component project management

techniques, knowledge, and

practices

Technology Summary

Applications: Microsoft SQL Server Management Studio, Microsoft SQL

Enterprise Manager, Microsoft SQL Query Analyzer, Microsoft

Visio, Microsoft Office, QMF, Microsoft (Word, Excel,

PowerPoint, Access, and Project), and Domino Lotus Notes

Systems: Microsoft Windows, IBM MVS DB/2, MS SQL Server, Rational

Software's suite testing tools

Languages: SQL, Visual Basic, HTML, JavaScript

Professional Experience

Watson wyatt worldwide - Universal city, Ca

9/2007 to 6/2009

Senior Consultant Analyst II

Watson Wyatt is a global professional services company that helps

organizations to improve performance through effective people, risk and

financial management. As a senior analyst within the Technology

Administration Solutions practice, I managed various client system

components within an HRO IT technology infrastructure and administration

application software development. Collaborative within a client team in

large-scale enterprise migration projects, systems conversions, and

performance tuning and monitoring of applications/systems as well as helped

to set long-range technical direction, change management, and capacity

planning.

Key Results:

. Setup and configured eligibility for all plan rates, premium, prices,

stop loss fees, and ASO fees by multi-tier/coverage category using MS

Access and SQL Query Analyzer.

. Transformed over 12 separate business requirement documents for CHW's

from 40 individual hospital benefit plan rules stratified by employee

demographic eligibility into a codified single source plan design

document encompassing all hospital eligible employee populations.

. Managed more than 25 benefit enrollment and maintenance transaction set

(834-A1) eligibility EDI files and specifications for medical, dental,

vision, FSA, and COBRA plans.

. Maintained benefit function compliance with all federal and state

regulations, including ERISA, HIPAA, and COBRA.

. Ongoing client team profitability (90% of goal) and reduced HRIS employee

data edits/errors (5%) from implementation live date from previous year's

open enrollment.

. Instigated practice wide new hire orientation and training for the

consultant analyst role.

. Created and updated functional specifications for EDI eligibility files,

event processing, business requirements, and change orders.

. Upload client benefit plan prices and rates from an Excel format,

exported into Access, and uploaded to a MS SQL Server RDMS.

. Created database driven employee benefit eligibility, new benefit plans

and options, web text and format using SQL query inserts, updates, and

deletes.

Secova - Costa mesa, ca 8/2006 TO 9/2007

CLIENT SERVICE MANAGER

SECOVA IS AN HR AND BENEFITS MANAGEMENT SERVICES COMPANY. I MANAGED

EMPLOYEE GROUP BENEFIT ADMINISTRATION AND OPEN ENROLLMENT DELIVERY UPON

SECOVA'S PROPRIETARY BENEFIT ADMINISTRATION SOFTWARE APPLICATION.

Key Results:

. Advanced from an implementation coordinator to client service manager

role.

. Managed coherent client leadership, client service, and account

management for six small to medium sized clients with employee

populations ranging from 600 to 7,000.

. Managed requirements and data process flows for ongoing client open

enrollment as well as new client implementation.

. Maintained benefit function compliance with all federal and state

regulations, including ERISA, HIPAA, and COBRA.

. Assessed and coordinated both internal local and off-shore resources and

delegated assignments necessary to complete project task(s) by project

due date in order to meet 100% of milestone open enrollment deadline

dates.

. Met 100% of client service level agreements (SLA) and statement of work

(SOW) criteria through tracked and reviewed user acceptance testing,

benefit eligibility calculations, as well as all other ongoing

administrative issues through resolution resulting in $0.00 fees lost due

to system or service failures.

. Successfully managed a pilot project to transform internal plan design

business requirement documents from MS Excel spreadsheets into uniform MS

Word standard formats in line with statement of work documentation.

. Ongoing client team profitability (100%), implementation live dates

achieved (89%), and open enrollment live dates achieved (100%).

. Assumed Account Executive responsibilities for three of six clients in

reviewing, revising, and updating SOW, SLA, Change Orders.

. Managed the implementation of Secova's first web-based Total Reward

statement for Sundt Construction. Collaborated with a third party

development firm Enwisen to develop compensation data flow schema

requirements.

hewitt associates - newport beach, ca 6/1999

to 8/2006

Quality Assurance Analyst

1999 to 2001

Quality Assurance Lead/Conversion Analyst

2001 to 2002

Senior Business Operation Systems Analyst

2002 to 2006

Hewitt Associates is a global HR professional services and outsourcing

consulting firm. Within the HR Outsourcing practice, I advanced from

quality assurance analyst to senior business systems analyst as a result of

demonstrating my ability to leverage QA and data conversion techniques and

practices to new associates as well as supporting internal productivity and

efficiency measures.

Key Results:

. Managed new hire quality assurance associates in analysis/design and

testing of Hewitt Associate's proprietary administration software

application.

. Established as a subject matter expert (SME) and defined, wrote, and

managed requirements for ongoing client open enrollment and new client

implementation in accordance with client team productivity goals.

. Collaborated in the system design and conversion, set up, implementation,

integration and quality assurance testing to maintain client team

profitability 115% of goal average for ongoing administration.

. Reduced quality assurance and ongoing processing cost through a

collaborated and coordinated effort to manage domestic and offshore

implementation team schedules and resources as well as quality assurance

testing through automated test case tools execution resulting in 25%

workload reduction and a 17% decrease in utilization cost.

. Implementation client team profitability (15%), ongoing client team

profitability (avg. 115%).

. Reduced HRIS employee data edits/errors (25% reduction) from

implementation live date to the following year's open enrollment date,

implementation live dates achieved (100%), open enrollment live dates

achieved. (100%).

. Support Hewitt's first web-based client Sun MicroSystems as a QA Analyst

creating and executing test scripts for, event functionality, job

procedure flows, and system component integration.

. Trained four new hire QA Analyst on the McKesson HBOC implementation as a

QA Analyst Lead as well as the conversion data analyst for active,

retiree, and COBRA population data transaction and load.

. Led the data modeling and conversion effort and created the test script

for the HRIS data feed for the Hilton Hotels implementation with respect

to each unique business unit, union group, and payroll method.

. Senior Business Operation Systems Analyst for the Tenet's implementation

responsible for HRIS, payroll, Life, and LTD transaction and eligibility

file components and specifications. Set up a cross reference mapping

layout on an IBM MVS mainframe DB/2 relational database used to

redistribute file data for a user interface that integrated HRIS and

payroll files.

. Managed four Standard Operation Procedure (SOP) document components.

Trained 12 offshore associates on each component procedure via remote

virtual meeting applications. Each document encompassed high level data

models and finite step by step quality insuring procedures.

. Over six years of IBM relational database DB/2 SQL experience using ISPF,

CICS, QMF, FileAid dataset analysis, and JCL and SAS code modifications.

. Created ad hoc SQL reports that included enrollment statistics, premium

reporting, and operation and productivity efficiency practice measures.

Education

CALIFORNIA sTATE UNIVERSITY,

NORTHRIDGE

Bachelor of Arts in Communication, Marketing

Contact this candidate