Teresa Tindell
Home phone: (850)508-1708
Email: [Send email using form at bottom]
SUMMARY OF EXPERIENCE
11 years of Oracle Development and Data Warehousing experience. Strong skills in
SQL for reporting. 4 years of experience of web development. 2 year java
experience. 2 years Cache database and web experience. 7 years experience with
client/server applications. Excellent communication skills and is a team player.
TECHNICAL EXPERIENCE
CERTIFICATIONS: Oracle Certified Associate Database Administrator
OPERATING SYSTEMS: UNIX, WINDOWS, NT
SOFTWARE: VISUAL BASIC, VISUAL FOXPRO, DELPHI, ASP, HTML, ACCESS ORACLE, PL/SQL,
INFORMIX, FOXPRO, ACCESS, CACHÈ, COGNOS, JAVA, JSP
09/04 Department of Children & Families, Tallahassee, Fl
Systems Programmer/Analyst
• Design and create Oracle database views to load data weekly from an online web
application to a data warehouse.
• Designed views used for data security in a data warehouse.
• Created functions, procedures and packages using PL/SQL.
• Analyze and troubleshoot data integrity problems.
• Write Control files, SQL and PL/SQL to load data into tables.
• Determine indexes that help with performance.
• Help decide what constraints would enforce data integrity.
• Wrote UNIX shell scripts to run jobs and load data.
• Migrated data and code from Cache web based system to Java and Oracle.
• Migrated Oracle data to Cachè from a Data Warehouse.
• Maintain and enhance a web interface used statewide using Cachè.
• Use Cachè ODBC drivers to connect to Access and Cognos to retrieve and analyze
data.
• Implemented code in Cachè to download files and reports to users.
• The Cachè system allows users to be alerted by email when files have been
processed or reports are complete and ready to be downloaded.
Environment: ORACLE, PL/SQL, UNIX, SQL LOADER, ASP, VISUAL BASIC, CRYSTAL
REPORTS, COGNOS, CACHE, JAVA, JSP.
03/01 – 09/04 Keane Federal Systems, Inc./ Department of Children & Families,
Tallahassee, Fl
Systems Programmer/Analyst
• Analyze and determine feasibility of storing images in Oracle using Visual
Basic and retrieving them in ASP, Visual Basic and Crystal Reports.
• Assisted in maintaining the Oracle Data Warehouse database using PL/SQL.
• Created and modified PL/SQL procedures and functions to maintain the Oracle
database.
• Wrote UNIX shell scripts to run jobs and load data.
• Used SQL loader and Access to load data to the Oracle data warehouse.
• Migrated Oracle data to Cachè from a Data Warehouse.
• Translated PL/SQL procedures to Cachè to process data daily.
• Maintain and enhance a web interface used statewide using Cachè.
• Use Cachè ODBC drivers to connect to Access and Cognos to retrieve and analyze
data.
• Implemented code in Cachè to download files and reports to users.
• The Cachè system allows users to be alerted by email when files have been
processed or reports are complete and ready to be downloaded.
Environment: ORACLE, PL/SQL, UNIX, SQL LOADER, ASP, VISUAL BASIC, CRYSTAL
REPORTS, COGNOS, CACHE
04/00 – 02/01 Flowers Bakeries Inc., Thomasville, GA
Systems Programmer/Analyst
• Assisted in maintaining the Oracle Data Warehouse database for Flowers
Bakeries using PL/SQL.
• Created and modified PL/SQL procedures, functions and packages to maintain the
Oracle database.
• Created views in oracle for reporting.
• Assisted using writing reports using BusinessObjects.
• Used SQL Navigator for debugging PL/SQL, adding tables and constraints and
analyzing data.
• Created constraints to help enforce data integrity throughout the data
warehouse.
• Analyzed, troubleshot and correct data integrity problems.
• Wrote UNIX shell scripts to run jobs and load data.
• Used SQL loader and Access to load data to the Oracle data warehouse.
• Assisted in the maintenance of the web pages (ASP) to download reports.
Environment: ORACLE, PL/SQL, UNIX, SQL LOADER, ACCESS
10/94 – 04/00 Department of Children & Families, Tallahassee, Fl
Systems Programmer II
• Maintained and modified windows applications using Visual FoxPro to generate
reports from an oracle database.
• Wrote PL/SQL procedures and triggers to insert data into a data warehouse.
• Analyzed, troubleshot and correct data integrity problems.
• Maintained and modified a windows application using Access to display,
maintain and, generate reports from a relational access database.
• Assisted in rewriting the interfaces to display and modify data that would
perform updates of files to different servers using Visual FoxPro.
Systems Project Analyst I
• Worked with a team to design, develop, test and implement a system using
Visual Basic for accountants to analyze data from an Informix database.
• Created an Excel workbook integrating Visual Basic and an Excel template to
view Informix data.
• Created interfaces using Visual Basic to insert, delete and update Informix
data.
Computer Programmer /Analyst II
• Designed, developed, tested and implemented several windows systems written in
Delphi that inserted, updated and deleted oracle data in small oracle databases.
• Created tables and indexes for small oracle databases.
• Extracted data from a relational oracle database and wrote the data to a text
file using Delphi.
• Created reports using Crystal Reports and Report Smith from oracle data.
• Designed, developed, tested and implemented a program written in Delphi to be
used to query accounting data to be viewed in a text editor.
• Responsible for installing and troubleshooting oracle connection problems.
Computer Programmer/Analyst I
• Assisted in the design, development and implementation of a Visual FoxPro
application to be used to reimburse travel expenses.
• Created interfaces to insert, update and delete data in a FoxPro database.
• Generated reports using Visual FoxPro from FoxPro data.
Computer Programmer I
• Maintained and modified systems written in Clipper.
• Changed the report formatting.
• Modified code to allow for different local and network printers to be used to
print the data.
Environment: ORACLE, PL/SQL, ACCESS, VISUAL BASIC, VISUAL FOXPRO, INFORMIX,
EXCEL, CRYSTAL REPORTS, CLIPPER, FOXPRO, HTML
|
