CAROLYN SMITH
[Send email to request phone number] 43-0583
email: [Send email using form at bottom]
Experience Summary:
An Information Technology professional with twenty plus years of variegated
experience in IT as a Project Leader, Business Systems Analyst, Quality Assurance
Leader and Programmer. Extensive work in the Mainframe batch, On-line CICS and
Client Server business systems environments supporting Customer Service,
Insurance, Payroll, and Accounting.
Lead DB2 Application Analyst for the client side of a project to implement an
Audit software package. Provided data mapping,, designing and creation of new
interface programs, modifications to existing programs to integrate the
software package. Created production job design and integrated the package into
the daily production schedule. Established acceptance testing criteria, provided
client-side QA Support for the project, handled debugging issues, providing
feedback to the vendor for solutions to issues. Created new programs to upload
and store Audit data from the ORACLE server based system into the DB2
environment. Designed and created new Audit Management reports from extracts
from the Vendor provided system. Acted as sole technical interface to the
software vendor and lead analyst for ancillary IT support.
Total first response Production Support Responsibility for the DB2 based Policy
System. Effort included initial trouble shooting, problem resolution and
operational decisions for this company critical, large complex system. Daily
interface to Operations on production improvements and permanent fixes.
Lead End-to-End Quality Assurance and System Validation efforts spanning
Mainframe, Oracle, WEB, and End User on-line, distributed and batch environments.
Q. A. leadership experience required developing integrated and independent test
plans, planning and establishing test environments, creating test scripts to
ensure the quality, accuracy and applicability of IT applications and software
packages to the project requirements and business processes. Used hands-on
experience testing client/server, web and leagcy applications. Validation using
DB2 Spufi queries, Mainframe flat files, reports,Unix files validation, Oracle
tables, SQL Navigator, to develop and validate test plans and detail test data.
Project Leader responsibilities have included overall project plan development,
task level planning and tracking. Extensive experience in Insurance Business
User interface, gathering and reviewing business requirements, Vendor software
package evaluation, project and program level design reviews, hands-on coding
testing and debugging. Test case and test script preparations, problem isolation,
activity and problem tracking and resolution and 7/24 after installation support.
Heavy participation in the preparation of system and End User documentation and
training, and integration with multiple interfacing manual and automated systems.
Technical Summary: COBOL/COBOL II, CICS, Microfocus COBOL II , DB2, SQL, QMF,
SPUFI, HTML , EXPEDITER, EASYTRIEVE, VSAM, TSO, JCL, FILEAID, IBM Utilities
COMPAREX, IDCAMS, AFP, CA Scheduler , ,UNIX , ORACLE DB, OS/2 SQL SERVER,
DATACOM, IDEAL, SCLM, PANVALET, LIBRARIAN, MS Access, MS Project, Project
Workbench, MS WORD, MS EXCEL, MS POWERPOINT, OUTLOOK, WINDOWS 2000, IRMA.
Education: University of California, Santa Cruz Extension (Project Management
Certificate)
Chabot College, Hayward, Ca. (A.A. Information Systems Management)
Work Experience:
Salt River Project (SRP), Tempe, Az (11/06 – present)
Senior Programmer Analyst responsible for developing technical specs, developing
unit test cases and was responsible for developing the String Test Strategy
document as well as the String Testing test cases for the project.
I was assigned to code 25 new COBOLII DB2 report programs and developed
electronic letters to be sent to the customer using the IBM AFP custom print
language interface. I was also assigned CICS program changes supporting new
requirements.
Additionally I was assigned to assist the QA Analyst for the project in writing
Queries for data mining,
And determining the data mining requirements.
Salt River Project (SRP), Tempe, Az (05/06 – 11/06)
QA Analyst responsible for developing and executing test cases in a Web based
application. Test cases were developed from the functional design document .
Responsible for planning the sequence of the test case execution to span over
five logical days, documenting failures in an Access DB. Verifying and gathering
Test Data, validating test results using the GUI screens, Spufi queries in DB2
tables, mainframe flat files, and reports. Worked closely with other QA
Analysts, developers and the business experts, identifing and help resolve
defects in the enhancements of SRP's Billing. Provided input in Test Case
planing and documentation for future UAT activities.
State Compensation Insurance Fund (SCIF), San Francisco, CA (04/01 – 05/06)
Application Analyst responsible for supporting the DB2 Policy Data download to
the AMS ORACLE Server.
Provided data mapping, overall system design to accommodate the download from
the Policy and Claims systems, DB2 Reporting System design, coding a total of
34 new programs and modifying 97, Data Modeling of new tables, recommendations
for changes to the DB2 version of the Vendor tables, QA Support, debugging
issues, and making recommendations for solutions. Lead programmer analyst on
various projects within the Policy financial, reporting and auditing subsystems.
Primary Production Support for the off-shift production run of the DB2 Policy
System. Operational interface to programming and Operations for ongoing system
improvements.
Charles Schwab, San Francisco, CA (8/00 – 04/01)
Senior Consultant responsible for Quality Assurance Testing of Oracle extracts
to the
Mainframe for three interfacing systems as well as changes to the nightly batch
updates from Mainframe to the Oracle database.
Responsibilities include reviewing business requirements, project test data and
plans, Mainframe CICS screens, the DB2 data model, GUI screens on a client server
platform, and the Oracle data model. The SQL Navigator tool was used to query
the Oracle database, Unix shell scripts were created to extract data from the
database creating data to be shipped to the mainframe which would then update the
DB2 tables. Worked closely with the developers to hands-on test their
application. Spufi was then used to query and verify the mainframe DB2 tables.
Test scripts were written to test and validate the CICS transactions, nightly
batch updates to the Oracle database and batch updates to the DB2 tables from
Oracle batch extracts.
Lead the End-to-End Validation effort, entering data into the mainframe,
insuring Expected results are applied to DB2, expected results are applied to
Oracle, Updates to Oracle via the GUI screens, then expected results back to the
mainframe. This involved running numerous mainframe jobs and Unix scripts as
well.
CSAA, San Francisco, CA (8/99 – 8/00)
Senior Consultant responsible for coordinating and leading the Quality Assurance
Testing of the Homeowners Insurance software package using Windows N/T
Workstations, Citrix Servers and an Oracle database.
Responsibilities include gathering and reviewing business requirements,
evaluation of the package software documentation and the Rate Filing with the
Department of Insurance, development of the Statement of Work, test case
preparation, preparation of the project schedule. Identifying costs and other
resources. Test case and script preparation and result tracking and resolution.
Working with users on additional requirements, and the preparation of project
documentation. Also coordination and interface with Users, Actuaries and the
CSAA internal audit team.
State Compensation Insurance Fund, San Francisco, CA (07/98 – 8/99)
Consultant working on the Y2K Project. Responsible for inspecting code, aging
files and DB2 database tables, developing test scripts and plans, correcting
programs, testing and validating test results and updating appropriate
documentation. Applications systems included Claims, Policy/Premium and
Insurance Prospects covering both batch and online components.
Wells Fargo, San Francisco, CA (10/97 to 7/98)
Consultant working on the Y2K Project. Responsible for Year 2000 COBOL and
Easytrieve, program code remediation for the SUS Statement application.
Inspected code, aged files, etc. Extensive coordination and testing of
interfacing applications.
CSAA, San Francisco, CA (07/96 to 10/97)
Responsible for project and task management, requirements definition, analysis,
design and implementation of improvements involving legacy online and batch
Homeowner and Automobile Insurance Systems. Successfully solved issues related
to data transmission, storage, retrieval and updates from external sources.
Performed data modeling, working with Users to defining data elements rules and
usage. Designed screens, reports, test plans and detailed project and task
management.
Crowley Maritime Corporation, Oakland, CA (09/95 to 07/96)
Managed a team of four FTEs and four consultants involved in modifying a
Payroll package to convert the existing COBOL/IDMS application to a Client Server
package using a proprietary language and VSAM files.
CSAA, San Francisco, CA (06/88 to 09/95)
Team Lead and Programmer/Analyst on the Emergency Road Service Application.
This Client Server application is online 7X24 in 12 sites supporting 200+
workstations. It uses data stored in indexed files on a file server and in a
remote DB2 database server.
Analyst involved in converting the original COBOL programs to Microfocus COBOL
II, designing a new architecture was developed and developing GUI screens using
Microfocus GUI screen developer.
ADP Incorporated, San Ramon, CA (12/86 to 05/88)
Designed and coded major system enhancements, and converted existing online
modules from DATACOM/DC to CICS. Designed, coded and tested several new CICS
transactions .
Safeway Stores, Oakland, CA (11/83 to 08/86)
Designed coded and maintained test data and model files for testing and
debugging Accounts Payable system components. Assisted in program and system
walk-through and installations. Provided 7X24 production system support.
|
