Project Quality Assurance

Pia Teresa Cainglet

P. O. Box ******

Sacramento, CA 95822

cell: 928-***-****

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

Summary:

Experienced Programmer/Analyst with solid experience working primarily in a

software development role. Worked in business and engineering related

industries. To date, work environment pertains to research and development,

application upgrading, and software maintenance. Primary work is server

side programming on various versions of UNIX. Secondary work includes

client and server web application, equipment integration, and graphical

user interface. Participation in projects involved analysis, design,

documentation, programming, testing, and end product support. Interaction

included but not limited to peers, systems analysts, quality assurance,

project owners, and end users.

Work Experience:

June 2008 - May 2010 Kelly Mitchell/Tiny Planet, Inc. Sacramento,

CA

UNIX Software Developer

Skills: C, AIX, Oracle 10.2, Oracle SQL developer, SQLPLUS, Oracle Database

10g Client 10g, SQL, UNIX Korn shell scripting, dbx, PHP, Subversion, HTML,

CSS, JavaScript

Contracting to AT&T. Assigned to AT&T Mailing Solutions.. Creating and

maintaining shell scripts and UNIX, C, and embedded SQL programs to

integrate with in-house mailing system. Using Oracle clients for writing

and testing SQL queries to access and extract data from multiple tables of

multiple databases. Developed web based database for information lookup

and search capabilities of in-house Oracle-based database. Developed and

maintained PHP based front end to AMS' printing and mailing system.

Preparing documents for technical design, and implementation for new

modules.

October 2006 - April 2008 Analysts International Lansing, MI

Enterprise Application Developer

Skills: C, Solaris, Oracle 10.2, Oracle SQL developer, SQLPLUS, Oracle

Database 10g Client 10g, SQL, UNIX Korn shell scripting, dbx, eclipse, XML,

ssh2, sftp

Contracted to Electronic Data Systems. Assigned to Medicaid project for

the state of Florida. Worked in a virtual team environment. Wrote shell

scripts and Pro*C programs to generate reports and letters for Buy-In and

Managed Care subsystems. Speed and efficiency coding practices emphasized.

Used Oracle clients for writing and testing SQL queries to access and

extract data from multiple tables. Prepared documents for technical

design, test cases, and implementation for each new assignment. Assisted

technical leads with tasks including orienting new members to development

environment, assisted team members with knowledge of business logic, worked

with other departments to implement newly defined procedures, and

participated in technical walkthroughs prior to system integration.

Familiar with Business Objects and SOA/SOAP concepts as implemented at

client site.

June 2003 - July 2003 Elizabeth May Corporation Phoenix, AZ

Database Designer/Programmer

Skills: Microsoft Access 2002, VB6, SQL

Worked with project owner in designing and developing a price comparison

database. Converted and imported Microsoft Excel spreadsheet to Microsoft

Access 2002. Created tables and developed forms. Customized forms using

VB6.

March 2001 - September 2001 Metro Information Services

Phoenix, AZ

Software Developer

Skills: SQL, C, Korn shell, AIX, make, SCCS, UDB DB2 v5.2/7.x, SUN OS,

Oracle 8.0 PL/SQL, ERWin, TOAD, DB Artisan

Contracted to Bank of America. Worked with multiple development teams in a

Data Mart department for a national financial data warehouse. Primary

responsibilities included but not limited to developing and maintaining

functionality of existing database application, and data migration project.

Maintained and provided ongoing support of existing UDB DB2 applications.

Used embedded SQL using C and Korn Shell, respectively, to interface with

UDB DB2 running on AIX. Created new additional functionality to existing

applications based on content of assigned projects. Wrote UNIX/C based

standalone programs for the purpose of parsing ASCII data files in

preparation for table loading into UDB DB2. Also, developed and maintained

C and Korn Shell based SQL programs for use in data manipulation and

retrieval from DB2 based tables.

During early phase of data migration project, translated business rules

from Oracle PL/SQL to UDB DB2 and assisted in data mapping of Oracle

schemas to UDB DB2 schemas. In addition, supported and maintained Oracle

PL/SQL based application running on SUN OS during data migration project.

Used ERWin, TOAD and DB Artisan, respectively, to work with said Oracle

applications. Created flowcharts to illustrate data flow of Oracle system.

Assisted team leader in setting up development environment. Provided

technical assistance to peers regarding usage and advance functionality of

languages and source control. Researched and contributed open source

software tools found readily on the internet. Contributed common C

routines for library. Introduced formal documentation for development

reference of new and existing applications. Participated in code and

design walk thrus.

October 2000 - February 2001 TSG IT Resources Phoenix, AZ

Web Developer

Skills: Windows NT, Tcl/Tk (Matrix One), HTML, Oracle, SQL

Contracted to ON Semiconductor. Part of a development team in a data

processing department. Worked on enhancements to intranet-based

application as reported by users through in house trouble ticket reporting

system. In addition, developed applications for system administration

related to its commercial based ERP and to its source code management

process, respectively. Provided pager and on-call support of in house

application.

Enhanced HTML pages of intranet application by modifying Tcl source code.

All HTML pages generated using Tcl. Developed Tcl based server side

application to manage history data currently stored in Oracle based ERP due

to nonexistent archive process. Application included date storage

determination and ability to selectively process records. Developed Tk

based graphical user interface to its source code management process for

the purpose of automation, event logging, and overall management of source

code control.

November 1999 - October 2000 Sirius Software, Inc.

Phoenix, AZ

Various contracts

Equipment Integration and Application Developer (November 1999 - October

2000)

Skills: HP-UX, Solaris, Tcl/Tk, SECS/GEM, UIM/X, RCS, SECSimPro

Contracted to Motorola, Semiconductor Products. Part of a development team

in a computer integrated manufacturing department. Developed middleware

software for the purpose of reduction of wafer scrap in semiconductor

manufacturing fabrication. Took on project management related

responsibilities. Development project entailed tool characterization, data

translation using SECS/GEM protocol, and use and installation of components

to Tcl/Tk based in house product running on HP-UX for programming said

protocol. Additional GUI written using UIM/X running on Solaris.

Project management related responsibilities also part of assigned project.

Contacted equipment vendor for software product related issues. Verified

hardware infrastructure. Performed minor network hardware installation.

Estimated times of completion of components in project plan. Coordinated

with customer on requirements, documentation, testing phase, and production

release. Created documentation of customer requirements, tool

characterization, test plans, operation procedures, and overall design.

Project ownership designated by supporting delivered end product and

providing training to equipment engineer and its associates.

Java Consultant (April 2000 - May 2000)

Skills: Windows NT, Solaris, IBM Visual Age Java, Oracle, Internet Explorer

Contracted part time to Questek. Evaluated current enterprise software to

determine its feasibility for long term usage and maintainability.

Evaluation included analysis of Java source code, logic workflow, database

access control, and user friendliness.

May 1999 - August 1999 TechStar Phoenix, AZ

Developer

Skills: AIX, Tcl, Expect, Korn shell, Perl, Network Express, C, SCCS, awk,

sed

Contracted to Blue Cross Blue Shield of Arizona. Part of a development

team in an Electronic Data Interchange (EDI) department. Developed and

maintained shell scripts using UNIX software and commercial based product

Network Express. Customized scripts by combining Korn Shell, Tcl, and

Expect for the purpose of executing specific cron jobs and automating e-

mail notifications. Monitored transaction based system using Network

Express. In addition, developed TN3270 screen emulation with Electronic

Window scripts. Maintained standalone C programs. Contacted vendor

regarding product related support. Established development environment.

Set up Source Code Control System for development environment. Performed

software builds and installation of Tcl/Tk, Expect, and Perl on AIX.

February 1999 - March 1999 Envision Mesa, AZ

Web Developer

Skills: Solaris, Perl, HTML, JavaScript, Sybase, Netscape

Contracted to Motorola, Satellite Communications. Developed web based

management tool for the purpose of assessments of its contract related

practices in Policy and Procedures Department.

Performed project related tasks. Included but not limited to

interpretation of end user requirements, derived detailed system

specifications, implementation, system integration as well as

documentation. Application content entailed ad-hoc queries, retrieval of

archived HTML documents, and web based summary reports. Used HTML for data

input from forms and for output from database retrieval. Used JavaScript

for data validation within Netscape web browser. Used Perl for Common

Gateway Interface running on Solaris. Used Perl module to Sybase running

on Solaris for storing data from submitted forms into database. Performed

basic database administration duties.

November 1995 - December 1998 Interim Technology

Scottsdale, AZ

Various Contracts

"On the bench" (August 1998 - December 1998)

Skills: Borland C++, Windows 95/NT

Developed consultant database prototype for Software Quality Management

Lead. Used Borland C++ for in house project. Developed prototype as a

training tool for the Software Development Life Cycle Process.

Contracted to Salt River Project (May 1998 - August 1998);

UNIX/C Developer;

Skills: HP-UX, C, make, Powerbuilder, Clearcase, Sybase, Windows NT

Part of a development team in a data processing department for a regional

power supply company. Worked with a small team of developers on the

Client/Server area of Legacy/mainframe applications conversion project.

Project pertained to billing area for its business customers. Used C for

use on HP-UX as application programming interface to Sybase database. Used

Powerbuilder to create GUIs related to assigned billing project. Used

Clearcase in conjunction with ongoing project development.

Contracted to National Data Corporation (March 1998 - May 1998)

UNIX Developer

Skills: Dynix, SQL, Korn shell, Oracle, SQL, MVS

Developer for a national pharmaceutical data warehouse. Worked with a

small team of developers on an automation project involving data transfer,

data conversion, and data loading into Oracle. Used Korn Shell Scripts to

automate process by using ftp to transfer data from IBM mainframe to

Sequent UNIX server, UNIX command dd to convert data upon transfer

completion, Korn Shell specific features to validate transferred records,

and SQL statements to connect and store validated records into Oracle.

Contracted to Anasazi Inc. (June 1996 - February 1998)

Client/Server Developer

Skills: SINIX, C, Korn shell, Informix, ESQL, SCCS, Microsoft C, make,

Windows 95

Worked with multiple development teams of a software company in the

hospitality industry. Worked with other developers, technical leaders,

Quality Assurance and analysts in all stages of the Software Development

Life Cycle. Assisted in writing technical design documents related to

assigned area in development. Participated in documentation and code

reviews.

Developed and maintained applications for use with client's three tier

online transaction processing system. Created, verified, and released

software versions and builds to technical leads of various projects and

Quality Assurance. Releases included but not limited to patch releases,

and snapshots during testing phases. Used shell scripts and C programs to

monitor communication server and database server upkeep. Used ESQL and C

as the application programming interface to connect add, change, delete and

retrieve data from Informix. Used C to develop new software components and

maintain existing programs. Parsed messages and validated associated data

at the middleware level of client's online system. Maintained Microsoft C

GUI client.

Contracted to Healthcare Delivery Systems (November 1995 - June 1996)

Systems Integration / Technical Writer

Skills: Solaris, HP-UX, Dynix, C, TCP/IP, NCPDP, Oracle, Proc*C, SQL, Korn

shell, make, SCCS

Part of a development team in a data processing department for a McKesson

subsidiary in the pharmaceutical industry.

Benchmarked transaction processing system, assembled technical design

document, and developed middleware components in client's startup project.

Worked with senior team leader on utilizing interprocess communication

concepts for use on Client/Server three tier architecture, NCPDP standards

of data transmission, and message sending over TCP/IP. Wrote technical

design document on components making up the transaction processing system,

disaster recovery procedure, and usage guide to the transaction processing

system. Participated in documentation and code reviews.

Used Korn Shell scripts to measure and record performance of online

transaction processing system and to monitor communication server and

database server upkeep. Used UNIX/C based transaction processing system

prototype to simulate online real time processing scenarios. Used Pro*C as

application programming interface to Oracle running on Solaris and Dynix,

respectively for adding, changing, deleting, and retrieving data. Wrote C

programs for use on UNIX to validate incoming data from user interface.

January 1994 - November 1995 Occidental Fire And Casualty of North Carolina

Scottsdale, AZ

Systems Engineer I

Skills: Ultrix, C, Korn shell, awk, Informix C-ISAM, make, SCCS

Part of a development team in a data processing department for a national

auto insurance provider.

Developed and maintained components of Informix based online system running

on Ultrix. Coordinated with Systems Analyst in gathering customer

requirements for new projects and modification requests. Developed ad hoc

query interfaces for use with online system to generate custom reports for

accounting and underwriting managers of local office. Wrote C programs and

Korn Shell scripts for use with Informix C-ISAM APIs to interact with

database. Provided production support of online system and connectivity.

Performed basic system administration duties including tape backups, awk

scripts usage for automated night-end processing, and working with DEC

network hardware including patch panel, ethernet and DEC terminal server.

Non-IT Work:

May 2004 - October 2006

Assisted billing department at a medical office of an internal medicine

doctor in private practice. Familiar with HIPPA conformance, medical

billing procedures using ICD-CM-9 codes. Familiar with NDC Medisoft v9.0

software for patient information and payment history. Familiar with use of

Solace Electronic Medical Claims (EMC) for transmitting medical claims.

Minor knowledge of procedure codes and diagnosis codes associated with

billing to Medicare and insurance companies. Contacting Medicare and

insurance companies related to benefits and eligibility of patients, and

nonpayment related to claim status.

Developing, enhancing and replicating functionality of patient database and

EMC software for personal education.

Ongoing Personal Projects:

Cross-development of previous work projects to enhance current skills and

acquiring new skills. Ongoing self-training of OOAD, OOP, C++, Java,

Threads, embedded programming.

Education:

December 1992 Arizona State University Tempe, AZ

Bachelor of Science in Computer Information Systems

May 1989 Arizona Western College Yuma, AZ

Associate of Applied Science in Computer Information Systems

Contact this candidate