Project Data

Rachel Lavern

PROFESSIONAL PROFILE

I am the ultimate broker between the business and technology functions, helping to reduce the costs of project

implementation by creating clarity, order and alignment. I am a technology savvy professional and experienced

in multiple industries.

EDUCATION

B.S. in Computer Information Systems - California State Polytechnic University, Pomona

SUMMARY OF QUALIFICATIONS

IT Project Coordinator

Developed/updated project plans

Managed project execution to ensure adherence to budget, schedule, and scope.

Established/executed project communication plans.

Business Systems Analyst

Provided support throughout entire software development life cycle (SDLC)

Collaborated with stakeholders and subject matter experts to understand requirements

needs

Elicited and modeled requirements using interviews, document analysis, JAD workshops,

business process descriptions, use cases, scenarios, and workflow analysis (via Visio).

Decomposed high-level business and user requirements into use cases, functional and

technical requirements

Utilized strong oral, written and presentation skills with ability to facilitate, create, and drive

change.

TECHNICAL SUMMARY

Environments: OS/MVS, Windows NT/2000, IBM Mainframe, HP3000, Unisys A-Series, DEC/VAX, OS/390

Languages: JCL, COBOL, COBOL II, COBOL-74, MicroFocus COBOL, SAS, FOCUS

Software: SharePoint (Content Management), Microsoft Office Product Suite (Project, Excel, Word,

Access), SQL, SAP R/3, PeopleSoft, VISIO, CICS, IMS, DMS II, DB2, TSO/ISPF, VSAM,

Panvalet, XPEDITOR, Viasoft, SAR, CA-7, ROSCOE, CHANGEMAN, File-Aid, NDM,

SYNCSORT, ENDEAVOR, IMAGE, EASYTRIEVE, ViewDirect, INFOMAN, IBM Utilities

WORK EXPERIENCE

Life Success, Pleasanton, CA Apr 2013 to Present

Certified Business Developer and Coach

• Responsible for analyzing, planning, organizing, providing technical expertise and managing people, tools

and resources in the development and support of business.

Kaiser Permanente, Pleasanton, CA Jun 2011 – Apr 2013

Mid-Atlantic States Regional Coordinator

• Supported the Enterprise Environment Services (EES) group by providing expertise in technical planning,

building and supporting of application environments (including in-house and vendor-developed

applications), evaluating configurations and application architecture while assessing impact on KP platform

environments.

• Supported many mainframe and client-server systems, and Web-enabled technologies utilizing MVS and

UNIX-based operating systems.

• Performed detailed analysis of cross-functional applications and interfaces; accountable for data de-

identification framework deliverables; maintained close collaboration with internal groups and vendors to

gather requirements; responsible for project planning and scheduling, preparation of work effort estimates

and coordination of the execution of project build and data de-identification activities across multiple

teams; coordinate testing tasks with offshore team.

Achievements for Data De-identification Project:

• Supported data de-identification application specific activities.

• Perform detailed analysis of application data model and interfaces

• Designed and implemented data de-identification programs

• Defined sustainability processes

• Data and database Analysis and reporting using SQL with Oracle and MS Access

• Used FileAid/Data Solutions software for de-identification of PHI fields (translation, aging, encryption)

• Used DB Visualizer software to access various application database in test environments to analyze

schemas, tables, PHI fields

• Tracked application status and dates, created/maintained project plans, submitted weekly management

status reports for each region

• Performed system/integration testing of modified software programs using test/production files and

databases

• Lead the DDI project for entire Mid-Atlantic States region consisting of 43 applications. Provide status

reports to HP PM’s and regional IT PM’s for a total of eight regions

McKesson Pharmaceuticals, San Francisco, CA Jun 2006 – Jan 2010

SAP Business Analyst/Project Coordinator

• Plan, conduct, and direct the analysis of business problems to be solved with SAP.

• Partner with users to identify, evaluate, and develop solutions and procedures which are cost-effective and

that meet requirements.

• Work on problems requiring data analysis; select methods and techniques for obtaining solutions; support

applications by providing analysis, design and development of solutions that support the data systems;

provide support to the business partners; Provide Tier 2 help desk support; supported the transition of

legacy data to SAP; investigated and resolved production support issues (24/7); conducted parallel tests

to certify data transfers ensuring functionality of files in new system; provided weekly status reports to

co-workers and management.

Environment: Legacy SAP, PeopleSoft HRMS Application, COBOL, OS JCL, JES2, TSO, VSAM, ISPF, IBM

MAINFRAME, FTP, CICS, DB2, SQL, IMS, VISIO, SharePoint, MSOffice Suite (Project, WORD, EXCEL,

ACCESS)

Kaiser Permanente, Pleasanton, CA Jun 2005 – May 2006

Test Data Coordinator

• Conduct assessment of test data coordination processes for Kaisers Medicare Modernization Act (MMA)

project; conduct analysis for end-to-end test data suites; standardize/facilitate the test data

request/fulfillment processes of cross-functional applications; facilitate test data issue management;

monitor the integrity of data during test execution; perform gap analysis; created data models, gather and

fulfill ad-hoc data requests; identify data set-up and interface dependencies; coordinate data load

schedules; define data set up; analyze and de-identify test data in compliance with HIPAA rules.

WellPoint Health Networks, Newbury Park, CA May 2003 – Jun 2005

Project Coordinator

• Responsible for working with business partners to gather system requirements, writing technical and

functional specifications, writing/executing/validating test scripts for system, regression and user

acceptance testing.

• Handle production issues and various maintenance and enhancement projects.

• Log, verify, assign, and track system problems reported by business partners.

• Create/execute project work plans and revise as needed to meet changing needs and requirements.

Identify resources needed.

• Assign responsibilities.

• Review deliverables.

• Conduct engagement reviews and quality assurance procedures; provide weekly status reports to users

along with internal updates to management.

Environment: Legacy--SQL, COBOL, DB2, EASYTRIEVE, FTP, Microsoft Project and Access, VISIO

Community Bank of Central California, Santa Clara, CA Oct 2002 – Apr 2003

Consultant

• Developed a program for a small community bank that reads customer checking accounts and update a

positive balance file with the amounts from an overdrawn limit file.

• Created test plan, test script and test cases to conform to specifications.

Bank of America, Concord, CA May 2000 – Sep 2002

Business Analyst

• Provided application analysis, business/functional/technical specifications, design, development, testing,

implementation and support for new Liability Risk Model project, which applied behavioral model

algorithms/processes to reduce the bank's exposure to fraud.

• Responsible for design and maintenance support for fraud tracking and detection applications.

• Served in liaison function between statisticians and information technology department.

• Designed and reviewed test plans/scenarios/cases.

• Created data models. Defect tracking management.

• Facilitated acceptance testing and traced requirements during implementation.

Merrill Lynch, San Francisco, CA Jul 1998 – Mar 2000

Developer/Analyst

• Provided application analysis, technical specifications, design, development, testing, and implementation

for 401K migration systems.

• Maintained online benefit applications for Hewlett-Packard.

Deltanet, Inc., San Francisco, CA Oct 1997 – Jul 1998

Programmer Analyst Lead

• Provided application analysis, functional/technical specifications, design, development, testing, and

implementation for Eligibility and Claims Team (DHMO, PPO).

• Facilitated meetings on requirement analysis, change management, problem resolution, and code walk-

through.

Blue Cross, Woodland Hills, CA Jun 1997 – Oct 1997

Mainframe Applications Developer

• Provided programming support for Sales Incentive System and Broker Commission System.

• Designed and coded screens (for display terminals) using Message Format Service (MFS).

Kaiser Permanente, Pasadena, CA Sep 1996 – Jun 1997

Developer

• Conducted interviews to determine reporting requirements of medical centers and regional staff.

• Developed management, productivity and trend reports to assist users in reconciling referrals/emergency

claims and planning budgets.

Prudential Health Insurance, Woodland Hills, CA Mar 1994 – Sep 1996

Lead Programmer Analyst

• Designed, developed, tested, implemented and maintained large, national dental system (DHMO) and the

Billing, Eligibility and Claims systems (HMO, PPO, POS, Indemnity).

• Created systems documentation and user guides.

ASSOCIATIONS

Toastmasters, Chamber Chatter

Contact this candidate