Resume 9

• Hardware: Pentium III, PC Client on MS/Novell LAN Network & DEC Pathworks Server, Sun Solaris OS 5.6, HP UX 9000 UNIX Server, IBM OS2/PM, DEC 8200 VAX/VMS and MicroVAX, Win95/98/NT/2000, MAC G3, MS Dos 7.0, IBM ES9XXX OS/MVS/ESA, IBM 309X VM/CMS, IBM 4341 DOS/VSE

• Software: MS Commerce Server 2000, MS Content Management Server, DB2 Universal Database and Oracle for Windows NT, Visual Source Safe, Win2k Terminal Services, Crystal Reports for PeopleSoft, PVCS Version Manager/Tracker, TRACK, Vantive, Silk, TestDirector, WinRunner, Pure Performix, QA Robot, TCP/IP ISP Testing, QA Methodology, Exceed, Telnet, Saxon, XML, XSL, ClearCase, UNIX C-Shell, HP UNIX Animator and VI Editor, UNIX and PERL Shell Scripting, Oracle 7, SQL/RDBMS, SQL*Forms 4.0, SQL*Plus 2.0, Static SQL, Sybase System10, VS COBOL, COBOL II, APS/SCOBOL, IMS DB/DC, DL/1, DB2, QMF, SPUFI, VSAM, PLX/PLI, CICS, TSO ISPF/PDF, SDSF, OS JCL, Panvalet, Librarian, Expeditor, DYL280, Eztrieve, File-Aid, File-Aid for DB2, IMS/XPERT, CLISTs, IBM Utilities, FASTTAPE, BMC, Rumba, Extra!, Reflection 4, PSB and DBD Gens, DB2 Binds, DLT0, Syncsort, DataAger, Abend-Aid, Endeavor, SAR, Full System Life Cycle, CA7, DataManager, Microsoft Office 2000, Outlook and Project, Visio, cc:Mail, Lotus Notes, Infoman and PCS

• Methodologies: QA Black Box, White Box Testing, Understanding of JAVA test tool, JTEST and test framework JUNIT and JAVA knowledge and concepts , Full System and QA Lifecycle, all phases and deliverables

PROFESSIONAL EXPERIENCE

Planned, designed, developed, executed tool test cases in Test Director for Microsoft CS2K Commerce Server 2000 Biz Desk Security and Analysis reporting tool modules, CMS Site Builder managing repository of templates, web pages, image placeholders, file structure, security rights for departmental/functional role level access and workflow , CMS Asset Transfer from Photo Studio and Web Author Edit editing components, i.e. - placeholders, templates, pages, text, and images; creating, publishing, and approving web pages . Gathered requirements to design test cases from business requirements, business analysts, developers, subject matter experts and user education coordinators. Regression tested basic and critical functionality after each build. Actively participated in daily bug meetings reviewing new and reopened defects. Also responsible for the custom piece - Photo Studio Asset Transfer to CMS Data structure. Validated the transfer process to the Content Management Server DB hierarchy involving metadata structure parameters in properties files on local server via to a dropsite server. Worked closely with Microsoft development teams to coordinate test case execution and was involved in test environment setup. Logged defects in TD. Banana Republic BR Replatform project took existing BR product line website with its ordering system and RTCA real-time credit authorization architecture and integrated it into Microsoft CS2K and CMS Content Management Server Product Catalog and Campaign Manager. Migration to MS SQL7 server is also part of the planned replatform.

• Planned, designed, developed, executed Enterprise System QA test cases and data for new Gerard website integrating full Staffing Office functionality, job search engine, candidate matching, payroll, job posting, front and back office staff function, etc. into one site. Gathered requirements to design test cases from business requirements. Coordinated, planned and executed system interfaces test cases using AutoSys to release batch jobs for each Iteration. Used DB2 for NT to modify, reset data to baseline test case conditions.

• Under the direction of the QA and Project Test Managers, performed project design, planning and coordination of Enterprise System Test environment of required components - hardware, databases, files, system servers, software, tools, etc. Participated in meeting with Host System Engineering, DBA, Front and Back Office Support Staff to establish basis of EST Test Infrastructure. Executed Test Cases and entered observed and recorded defects in System and QA Acceptance Test using PVCS Tracker. Revisit defect fixes, revalidate code changes in Tracker.

• Analyzed, documented downstream interface flows between PeopleSoft and MJ Plus. Planning went forward in a dynamic environment, amidst major upgrades to system software and patches and releases, newly expanded data center, Oracle to DB2 vendor switch and conversion of key databases, changes to Accounting system vendor, Chart of Accounts, Line of Business, reporting level changes, revised Iteration release, test and rollout schedules, newly deployed applications, client number and other data conversion, Program Office and Change Control Board approval changes. Ability to track issues was paramount in design and development of environment and test case planning.

• Determine test plan time dependencies, define scope of testing based upon the requirements, test case design approach from information available from Program Specification and System Design documents and meetings/communication with Business Support Analysts, Program Office, Cognizant external development team , Interface Systems owners, Functional Analysts, RHI and CTS Development teams. Record, distribute Meeting notes, design agenda and wrote Enterprise System Test Infrastructure Environment business document. Met and worked with Performance/Load Test QA analyst to establish system load volumes of web data iterations.

Planned, designed, developed, executed QA test cases and data for revamped US Trust, COLA website integrating Schwab Retail accounts into the US Trust client Web experience from business requirements. Cloned existing accounts from Schwab retail profiles, set-up and linked Tax-ID numbers using Schwab.Com web site and Legacy CICS transactions to generate a set of functional and performance Test Ids. Logged bugs in Vantive, regression test bugs and validated data throughout test cycles based upon build schedule and migration of code from QA through Production regions. Responsible for the execution and validation of AMS Equity Assets, Bonds , Banking, Loans, Funds , as well as, Schwab Retail data in Portfolio Summary, Holdings and Activity Test Cases. Also, developed tests for Quotes and Symbols and Schwab Account Holdings. Develop and prototype White-Box testing of Saxon generated reports using XML and XSL templates in Clear Case. Monitored Weblogic, Resonate, DB2 Connect Sun Solaris system performance in Unix. Assisted in load testing server/application. Collaborated our efforts between QA/Design team in New Jersey, business partners, developers and Release Management in San Francisco and our COLA QA team. Resolved issues, bugs and questions in regular meetings and via email/phone interaction. Perform metrics in Certification and prepare Test Summaries reflecting tests conducted using MAC, PC under a host of browsers, including IE, Netscape and AOL, via Schwab internal network and ISP TCP/IP modem lines. Review and plan QA activities for Phase 2 features of this product, Expanded Permissioning, Bank Journaling, Downloads and 2-Way Email. Participate in Razorfish Web design of COLA site using their XTRANET clickthroughs.

Responsible for the Quality Assurance of Investment Manager Downloads and Alerts on SIM.COM and Schwab Link Windows Desktop. Develop, maintain and run regression suite for each release of SI.COM and hardware upgrades. Baseline/reset test environments in the QA Lab on PCs by reconfiguring them with various operating system/browser version/type combinations for regression test. Ran SILK automated regression scripts for both Downloads and Alerts. Run PERL and Unix based Alerts and Downloads File Splitter scripts to test and prepare data for baseline testing of new files state and functionality. Report and tracked bugs in Vantive. Support installs of SI.Com releases and hardware upgrades. Collaborated with TCS support personnel in Phoenix to close production bugs reported by IMs in the field. Worked with and attended meetings to discuss outstanding bugs and related issues found in QA test region. Establish test procedures for SIM analysts and Web Checkers in Phoenix for Download testing. Attended Use case review meetings and develop Referral Alerts and Referral Email test cases for the Advisor Source on SI.COM project from Use Cases and Business Requirements. Grasp and apply the knowledge of the Security model architecture found on the SI.COM website to QA. Loaded JRE on XML PC workstation in preparation of XML Prototype for Downloads Project testing. Worked and contributed to HUGO/SIM in a Box, IECMS and Workflow Status Alerts projects.

Responsible for the Quality Assurance focal point of the Mutual Funds Redesign WEB Project. Establish entrance/exit criteria, develop test plan, design and build test cases, prepared Test Summary, certify QA criteria met with signoff. Participate in daily bug meetings. Prioritize and review defects with development team. Re-test fixes. Identify potential showstopper type bugs in Acceptance testing phase. Work with Product Development, Development Team, Project Management in establishing screen design and navigation issues, proper charging of fees, issuance of messages, content, etc. Develop defect tracking procedure. Track program bugs, issues using defect tracking software. Manage defect list, queries and reports. Establish metrics for defects and test cycles. Provide/negotiate time estimates to Project Manager for QA tasks. Coordinate bug fixes with project team, regression and maintenance QA teams. Coordinate testing in Devo sandbox , acceptance, QA provided touch test checkout in Pre-prod and Prod. Currently on Scores and Decimalization projects on the Web development team. Offered Schwab-U presentation on Mutual Funds.

Reviewed QRP Y2K certification packages per workpaper and DEITON standards. Examined packages for date impacts, remediated code, change control and proper aging applied, adequate system and interface testing in a Y2K compliant environment. Also checked for proper exceptions filed, critical dates tested, test approach and objectives outlined and validation techniques employed. Documented findings in recommendation, action log and results summary. Analyzed and noted deficiencies. Updated metrics EXCEL spreadsheet which track inventory of packages received, completed and those being referred to QRP Audit. Assigned grade to packages according to adherence to guidelines, completeness, due diligence followed, etc. Scheduled and performed package walkthroughs with Business Liaisons. Made recommendations and resolved compliance and documentation issues. Managed Y2K package recertification. Participated and contributed in work-paper review meetings to refine work process guidelines. Revised tasks and approach to packages. Processed improvement changes made involved a discussion of relevant and non-relevant issues of QA review work steps and feedback from analysts?past reviews.

Provided MRDB Production Support. Setup parameters in DB2 PROCS and run AD-HOC reports written in QMF. Spooled extract reports to users by converting MVS report files to MS Word documents using FTP and attaching them to Email. Monitored and checked results of jobs. Made changes to COBOL interfaces to MRDB system COBOL/DB2 . Developed queries to verify accuracy of reports. Researched any problems with the running of queries. Develop workaround solutions for problematic, reoccurring symptoms. Responded to user inquiries as to which table elements are used. Modified and reconstructed SQL queries per user requirements. Tested revised queries. Handled deviation requests from schedule runs. Updated metrics report on LAN. Provided assignment status on a bimonthly and daily basis. Supported DCSS in conjunction with MRDB phase-out activities.

Y2K Conversion Team. Responsible for systematic migration of production groupings. Analyzed and maintained inventory of changes Programs, Copybooks, PROCS, PARM members, PSBs, etc. on Excel spreadsheets. Participated in walk-throughs of grouping changes. Managed project tasks of 3 programmer analysts. Set up test files and environment for unit and system test. Wrote test cases. Converted VSAM and sequential file using File-Aid Reformatter. Upgraded system to Y2K standards by running scan analysis of copybooks and programs for changes and wrote specs. Programs written in IMS and CICS online COBOL. Developed cutover and test plans, modify JCL to system test changes. Researched and troubleshoot bugs in test and production. Coordinate changes with other I/As, systems, client-server based processes. Analyze vendor upgrades, assess copybook change impacts upon other grouping and existing system matrix.

As Y2K Technical Team Member, planned, steered and coordinated Y2K conversion effort. Also, primary support of Sales Reporting & MSDS system. Upgrade SR to Y2K standards by performing Y2K analysis scan programs for changes and write specs for SR system. Recovered SR Master file using File-Aid Reformatter. Enhanced SR programs written in PLX/PLI and IMS per user functional specifications. Designed, coded, developed test plan and test scripts, built test data using Data Ager, tested changes, modified JCL. Researched and troubleshoot production problems.

Provided direct support of ITD client business requests. Worked in the Customer Service and Central DB applications. Extensive data manipulation, building test data using SYNCSORT, File-Aid/IMS XPERT, DYL280/EZTRIEVE. Staged and packaged program changes in Endeavor. Enhanced Sales Tracing programs written in IMS DB/DC, CICS, VSAM and COBOL. Built Monthly Pricing reports. Designed, coded, tested changes, modified JCL PROCS. Researched and troubleshoot production problems.

Worked in the Demand Deposit Accounts Area developing a new financial product for the retail bank. Responsible for initial sizing, analysis, functional and detailed design, test plans and modifications needed to Refresh BMPs to support this financial product. Existing system written in IMS DB/DC and COBOL.

Developed test plans, analyzed, defined, designed and constructed test data in Integration Test Region. Responsible for the Billing History Database subsystem test team support for RCRMS, Revenue Collection Reporting Management System , a major multi-platform development project at Pacific Bell. Tested online application in GUI/CICS front-end. Validated test cases using screen capture and playback in Winrunner. Built test cases and tested suites for BHDB and CEDB DB2 applications and extracted data from test repositories to build stable test bed. Worked Trouble Reports TR S . Took DB2 table loads, backups using DB2 Utilities, File-Aid for DB2, QMF and SPUFI. Worked with AMS vendor on credit history, Bureaulink, FICO scoring algorithms and SBC business partners on testing requirements of AOG, SORD and MI Billing Interfaces to RCS/RCRMS.

Analyzed, designed and wrote several Security subsystem specifications in the systems requirements definition phase and code subprograms for a new Statistics and Reserves Reporting System, which was currently a major IMS DB/DC - DB2 COBOL development project at the FRBSF. Upgraded front-end CLIST JCL local applications to reflect new communal district unique processing site requirements.

Worked in the R&D Tools Group testing TGS Tools for the 4th-GL Redwood?release of financial applications in a UNIX environment. Software included COBOL, SYBASE, HP UNIX Animator, WinRunner Testing Tools and Problem Resolution logging in Proactive "Vantive?System. Constructed test cases/suites for GUI Applications using WinRunner capture and playback of screen functionality. Logged defects and exceptions in MS Word and Excel. Working knowledge of Redwood" architecture and PSU/PDS process. IBM Mainframe VM/CMS-XEDIT Editor Novel PC-LAN applications, SYBASE Server, HP-UX UNIX Server, Lotus cc: Mail.

Updated and enhanced Workstation Configuration Management System using ORACLE SQL*Forms and SQL*Plus on a DEC PC-LAN platform.

Installed edits using IMS DB/DC COBOL to inhibit Non-Company Sales Reps from performing specific screen functions including viewing, selecting and updating data by customer region.

Maintained of over 14 systems in the Quality Systems area which automate the acquisition, control and tracking of Space Shuttle activities, including Automated Document Management System and Engineering Parts Inventory. Developed hazardous material/waste storage and tracking system. Converted existing vendor system databases to Andersen MAC-PAC DEFENSE MRPII procurement package requirements. Extensive use of IMS DB/DC, APS, COBOL II, VSAM, XPEDITER, FILE-AID, Eztrieve/DYL280 and IMS XPERT. Built test cases and scripts and tested BMP related applications processing. Enhanced Purchase Order System. Emergency Change Notice [ECN] Coordinator/Production Control Technician for Quality Systems using CA-7 scheduling package.

Converted shop order location system written in IMS DL/1, CICS and COBOL II to conform to Mil-Stds in the processing of labor hours thereby achieving the precise reporting of labor performance. Wrote screen applications for a shop floor production control system in Oracle SQL*Forms/ SQL*Plus on a DEC MicroVAX workbench platform.

Installed online inventory system written in IMS DB/DC COBOL, tracking storeroom inventory piece parts for the issuing, receiving and ordering of kit assemblies. Responsible for writing monthly update programs and the testing of various interfaces to this system. Developed DYL280-IMS application to unload and restore various databases for flat file editing and backup. Maintained several complex-manufacturing systems.

Maintained Broker System IMS DB/DC, COBOL , paying commission earned to broker or agents on reconciled dues received. Provided Membership maintenance programming and analysis support.

Developed and enhanced Hospital/Pharmacy online/bath applications using DL-1 and CICS, COBOL in an IBM DOS M/F environment with PCS Online front-end running under CICS. Projects completed include corporate financial spreadsheet conversion from DEC BASIC to VS COBOL; MAPS Marketing Survey Reporting changes to facilitate contract services/resource allocation, client targeting and demographic analysis/projection; and developing MEDI-LOG patient reimbursement and audit reporting system.

Provided programming and analysis of COBOL business applications. Responsible for the Purchasing Activity Reporting System. Also worked in other assignments within the Financial Systems area.

Bachelor of Science in Business Information Systems - California State University Los Angeles