Oracle Sql
Resume:
Laura Tonesi
Pinole, CA
*******@*********.***
QA ANALYST
Fifteen+ years of experience in Information Technology as a Tester,
Documentation writer, Database Designer, Project leader, and Programmer.
Experience in Integration Testing, regression Testing, and Performance
Testing on multi-tier environments.
SOFTWARE / SKILLS:
Oracle 11g, Toad, Forms, Reports, Discoverer, PL/SQL, sql Loader,
Enterprise Manager.
Unix, data pump, ETL, Erwin, Warehouse Builder, SSIS, SQL Server.
Windows, MS Word, Excel, Access, Power Point, Crystal Reports, OLAP.
Eclipse, Java, JDBC, HTML, XML.
Mantis, CVS, Source Safe.
PROFESSIONAL EXPERIENCE:
Took refresh classes in Java and Sql Server. Provided childcare and
tutoring. 2009 - 2010
Senior Developer/Analyst, EC-WISE Consulting, San Rafael, CA
2007 - 2008
. Tested WEB interface that displayed Billing documents and reconciled
them with remittances (bank checks). Checked performance, accuracy,
and ease of use. Made recommendations on indexes to improve
performance. The system had a user interface written is Javascript, a
mid-tier written with Java APIs, and PL/SQL back end. Reported errors
using the Mantis software.
. Performed security testing on Billing Data Warehouse system to ensure
that the dynamic sql in PL/SQL procedures was protected from SQL
injection.
. Tested performance of PL/SQL load of Billing documents by loading 1
million rows files into a table of 150 million rows. Redesigned the
load and reduced processing time from several hours to minutes.
Programmed in PL/SQL and coordinated work with Java programmers.
. Redesigned and partitioned Oracle fact table containing 150 million
rows to improve accessing time.
. Wrote implementation documents.
. Created Unix Scripts to install Oracle programs, and to implement data
pump.
. Used: Linux, Mantis bug tracking, Oracle 10g-11g, Toad, sql developer,
Enterprise Manager, PL/SQL, data pump, MS Office, CVS Source Control.
Senior Data Warehouse Developer, PriMed, San Ramon, CA
2006 - 2007
. Performed integration testing of large Oracle Data Warehouse
application for Medical Referrals (designed by me as a project
leader). The Medical referrals had to interface with dimension tables
shared with the rest of the HMO reporting system.
. Wrote PL/SQL programs and complex SQL queries to test quality of data
loaded into the Pharmacy system, and to report and exclude faulty
records. The procedures were feeding data to MS Access for reporting.
. Provided technical directions and code reviews of Functions and
Procedures to Oracle programmers of ETL system.
. Responsible for project plan, documentation using MS Word and Power
Point, and end-user training for the Referral project .
. Wrote Unix scripts to install Oracle programs and to send emails to
end users notifying them of the reports' completion.
. Used: HP UX, Toad, Oracle 9i -10g, PL/SQL, sql loader, External
tables, MS Access, Excel, Power Point, Source Safe, Erwin, Sql server.
Programmer / Consultant, Booz Allen Hamilton - U.S. Navy, Fairfield, CA
2005 - 2005
. Tested performance of load and queries to the U.S. DOE Workload and
Workforce forecasting application. Modified PL/SQL code and complex
SQL-based materialized views to reduce processing time by 90%.
. Used: Sun Solaris,Toad, Oracle 9i, PL/SQL, Explain Plan.
Volunteer Office Administrator, World Bridges, Oakland, CA
2003 - 2004
. Performed Internet Marketing Research, Bookkeeping, and MS Access
programming to keep track of donors.
. Used: Outlook, MS Access, Excel (for accounting).
Contractor, telecommuting.
2002-2002
Wrote sql queries to be integrated into Teradata system.
Stay at home mother.
2001- 2002
Provided childcare and tutoring. Gave Italian lessons.
Programmer / Consultant, Pacific Bell Telecommunications, San Ramon, CA
1997 - 2000
. Created statistical reports to analyze trends on real-time dispatching
of telephone technicians (average number of hours a technician was
traveling or idle, average hours of usage for each technical skill,
etc).
. Created Unix scripts to install Oracle tables and PL/SQL procedures.
. Used: HP UX, Oracle Worksheet, Developer 2000 (Forms, Reports),
Pl/SQL, Windows.
Programmer / Consultant, Pinole Point Steel Manufacturing, Pinole, CA
1997 - 1997
. Created Oracle Reports on Manufacturing (Shipping, Receiving,
Inventory), and Financials (AR /AP /Purchasing /OE).
. Documented the system with ERD and Flowcharts (VISIO).
. Sun Solaris, Oracle Reports and Forms, PL/SQL, Oracle Financials,
Oracle Manufacturing, Visio.
Technical Leader, LFR Applied Geology, Emeryville, CA
1996 - 1997
. Tested Beta version of Oracle-based software for Chemical data
analysis. Entered data on geological sites and chemical results to
ensure that the screens worked correctly. Run reports and compared the
results I calculated with the results produced by the system.
. Oversaw configuration of Unix Server and Oracle installation.
. Sun Solaris, Oracle Reports, Crystal Reports, MS Access, sql loader.
Programmer, U.S. Department of Energy, Oakland, CA
1994 - 1996
. Designed applications for Inventory, Help desk, Human Resources.
. Used: Fox Pro, Dbase IV, Novell.
ADDITIONAL RELEVANT EXPERIENCE:
Programmer Analyst, WTS Payroll Processing, RHC Insurance, General Services
Life.
. Acted as a liaison with Banks and Corporations to implement EDI and
EFT transmissions.
. Used: VAX VMS, Oracle 7 and 8, Cognos, Cobol.
. Coded interfaces to several Accounting systems.
. Tested beta version of Life Insurance system by entering data on new
customers and making sure that the system generated premiums schedule
complied with federal tax legislation. Modified Insurance system to
comply with new laws.
. Used: DOS, Cobol.
EDUCATION AND TRAINING:
Bachelor of Science in Business Information Systems. San Francisco State
University.
Certificate in Financial Management. LOMA Institute.
Certificate in Medical Billing. Contra Costa adult education. El Cerrito.
Java and Eclipse. Academyx, San Francisco.
SSIS SQLServer ETL environment. QuickStart, San Francisco.
Data Warehousing Management. Online Course.
Visual Basic 2005 .NET. Online Course.
Creating WEB Pages HTML. WCC Education.
UNIX Operating System. Diablo Valley College.
ORACLE Optimization. ORACLE consulting group, Walnut Creek.
Database Normalization. DB consultants, San Francisco.
Contact this candidate