630-513-8545 202 Timbers Trail updated July 20, 2008
email@example.com St. Charles, IL 60174 www.geocities.com/rkaras
TARGET DBA/database developer, employee or contract
SUMMARY Expert database development skills using Oracle. Experienced with Microsoft Sql Server,
Access, and Sybase also. Extensive experience developing stored procedures, complex
SQL code, automating database import/export processes (ETL), report writing, tuning, and
data modeling. Automation often involved using UNIX Korn shell scripts or Windows
utilities. Oracle 9i DBA Certified Professional. Scored in the 99th percentile on Teckchek
Strong analytical and troubleshooting skills. Able to learn new technologies and business
terminology quickly. Work well with others in mentoring and lead roles. Familiar with the
software development life cycle (SDLC) .
TECHNICAL Languages: Transact-SQL PL/SQL * SQL * Korn Shell * HTML * SQR * C/C++ * VBA
Delphi * XML * Oracle Pro-C * Fortran * Perl * SNOBOL * ICON
Databases: Oracle * Access * Sybase * SQL Server * Interbase * Paradox * B-Trieve
Systems: Windows XP/2000/NT/98/95/3.x * UNIX (AIX, HP-UX, Solaris) * DOS
Tools: DTS * TOAD * SQL Navigator * SQL Plus * SQL Loader * Oracle Reports * Oracle
Forms * Visual SourceSafe * PVCS * Microsoft Office (Word, Access, Excel, Outlook) * IIS
(Internet Information Server) * Erwin
Misc: RDBMS * LDM * PDM * SDLC * EDI * Client/Server * Terminal/host
EXPERIENCE -- IT Consultant at Karas Enterprises -- St. Charles, IL (1996 to current)
(consultant) Services rendered: ETL (Extraction/Transformation/Loading of data), report writing,
process automation, troubleshooting, database tuning, design, development, production
support, logical data modeling, physical data modeling, documentation, requirements
gathering, and mentoring. Development is done utilizing a variety of tools, primarily SQL
and PL/SQL (to write stored procedures, packages, triggers, and report scripts). To
automate processes, UNIX Korn shell scripting and Windows utilities are used extensively.
DBA/Database Developer at AT&T -- Rosemont, IL (08/04 to Current):
Worked closely with internal business end users to provide DBA and Development
(PL/SQL, SQL) services on the distributed Oracle data warehouse database system.
Significantly improved the processing performance and reliability of the Local Oracle 9i
databases by adjusting various database parameters and tuning SQL statements,
PL/SQL code, and Solaris Korn Shell Scripts. Automated numerous tasks.
Migrated legacy databases from Access to Oracle, working closely with a Java GUI
Developer to create the supporting backend database objects and code for a Web
DBA/Database Developer at Rotella Capital Management -- Chicago, IL (04/04 to
08/04): Used Microsoft SQL Server (DTS, stored procedures, jobs) to automate data
processing. Designed data model, wrote stored procedures, and created jobs to
automate the downloading of financial data via Bloomberg Data License. Primary DBA
and database developer for the Cash Management database. Worked directly with end-
users and management in gathering requirements. Tuned the broker financial data daily
import process, resulting in substantial time savings. Tuned and enhanced an Excel
spreadsheet that used pivot tables retrieving data from SQL Server views and a cube.
Created VBA macros to initialize the various worksheets and to add additional information
beyond what the pivot tables provided.
Used Microsoft SQL Server (Enterprise Manager, DTS, Transact-SQL, Stored
Procedures, BCP, Analysis Manager, cubes), Microsoft Excel (Pivot tables, Macros, VBA)
Database Developer at Information Resources -- Chicago, IL (05/03 to 07/03):
Developed and implemented a data warehouse to facilitate the comparison of Information
Resource's data with data provided by its clients. Modified the logical data model and
created the physical data model. Created processes to initialize the database from legacy
data and to integrate future incoming flows of data. Used Oracle, SQL, PL/SQL, SQL
Loader, SQL Plus, TOAD, UNIX, FTP, Korn Shell. Microsoft office.
Database Developer at Abbott Laboratories -- Lincolnshire, IL (11/02 to 05/03):
Automated processing of in-coming sales data in various formats (EDI, flat file, Excel
spreadsheets, Access databases) from a variety of sources into the Oracle data
warehouse. Created schema tables (logical and physical modeling) to facilitate the data
processing. The data was often preprocessed with UNIX korn shell scripts or Excel
macros, then loaded into Oracle and transformed. Email messages were generated to
inform relevant parties of the load status. Created and maintained numerous scheduled
and ad-hoc internet and hard-copy reports based on the sales data in the data warehouse.
Used Oracle, SQL, PL/SQL, SQL Plus, SQL Loader, PL/SQL Developer, Brio Reports
(SQR), SysAdmiral, Visual SourceSafe, Visual Basic (VBA macros for Microsoft Access,
Word, Outlook, and Excel), Citrix Program Neighborhood, TextPad, Windows 2000, UNIX -
MKS Toolkit (Korn shell, Awk, FTP).
Database Consultant at Awana Clubs International -- Streamwood, IL (05/02 to 6/02):
Analyzed, debugged and resolved problems in the financial, sales, and inventory system.
Advised the DBA on various Oracle concerns. Used SQR, Oracle, SQL, PL/SQL, JD
Database Developer at Acxiom -- Downers Grove, IL (02/01 to 12/01, 04/02 to 05/02):
Created carefully designed and tuned SQL scripts to populate and maintain summary
tables in a very large Oracle database having information on 70 million potential customers
with some tables having over a billion records. Developed numerous reports with SQL
Plus. Replaced a Oracle Pro*C report with an innovative, complex SQL report that
executed in minutes.
Automated the processing of incoming data files from a various vendors. The data files
were preprocessed with UNIX Korn shell scripts then loaded into Oracle and transformed.
In some cases, outgoing files were generated from the database and sent to vendors.
Analyzed, debugged and tuned SQL code written by others, resulting in substantial
performance gains and product reliability. Mentored others in SQL and PL/SQL.
Developed back-end stored Oracle procedures that were called by the HTML/ASP/JAVA
code of a front-end Internet application. Used Oracle, SQL, PL/SQL, TOAD, HTML, ASP,
IIS, Windows, UNIX, Korn shell, TOAD, range partitioned tables.
Database Developer at Sara Lee Bakery -- Chicago, IL (11/00 to 02/01): Assisted in the
migration from Oracle Financials to Lawson Financials. Loaded legacy data into
temporary Oracle tables. Replaced SQR code with PL/SQL code. Created data reports.
Mentored other developers. Proactively convinced management to allow developers to
use Windows based tools, resulting in substantial developer productivity gains. Used
Oracle, SQL Loader, SQL, PL/SQL, SQL Plus, VBA (Excel) macros, SQR, TOAD.
Database Developer at Ameritech New Media -- Chicago, IL (02/99 to 9/00): Analyzed
the existing customer fulfillment process then completely redeveloped it, incorporating new
fulfillment criteria and requirements. Saved the company thousands of dollars by
drastically reducing fulfillment-related errors. Lead the effort in data modeling, data
normalization, design and coding of stored packages and triggers for the fulfillment related
portion of the database.
This distributed, data warehouse fulfillment process was implemented primarily with
PL/SQL code. E-mail messages were generated automatically to convey the weekly
fulfillment results. Reports were generated using PL/SQL and SQL scripts. Used Active
Server Pages (ASP), HTML, Java Script, VB Script, and Oracle SQL to automatically
create Intranet HTML files to assist in fulfillment analysis.
Mentored developers in the design and debugging of PL/SQL code and UNIX Korn shell
scripts. Tuned SQL statements embedded in Powerbuilder applications. Used Shell
scripts, SQL Loader, PL/SQL, and SQL Plus scripts to automate the back-end processes
for other campaign management projects.
IT Consultant at Knowles Electronics -- Itasca, IL (2/99 to 02/99): Critiqued the coding
of a Delphi/Oracle client server application. Made recommendations for improvement.
GUI/Database Developer at USN Communications -- Chicago, IL (12/97 - 11/98):
Used Delphi and Oracle (SQL, PL/SQL packages, stored procedures, triggers) to develop
applications to automate business functions that allow sales reps to maintain telephony
customer services. Technologies used include EDI, FTP, and Sockets.
The front-end application was written in Delphi using an extensive class hierarchy and
objected oriented coding. This application retrieved customer information from Ameritech
using EDI. The raw EDI data was tokenized and Oracle package code was called to store
this data in the highly normalized Oracle OLTP database. Subsequently, this information
could be retrieved from the Oracle database by calling Oracle package code and
presented to the sales rep in the GUI front end in a presentable format. Then the sales
rep could make changes to the customer’s account information and these changes would
be recorded in the database and sent to Ameritech via EDI.
GUI/Database Developer at CNA Insurance Company -- Chicago, IL (03/97 to 11/97):
Used Delphi, Sybase, Windows, UNIX, SQL, and stored procedures to develop Windows
client/server applications for the Loss Control Risk Management workstation.
GUI/Database Developer at Mesirow Financial -- Chicago, IL (12/96 to 03/97): Used
Delphi, Sybase, SQL, and stored procedures to develop a Windows client/server
brokerage billing Application. The application calculated and reported the fees associated
with clearing a trade. Numerous reports summarized the fees at various levels of detail.
EXPERIENCE -- Sr. Programmer/Analyst at First Chicago NBD (Bank One) -- Chicago, IL (1990 to 1996)
(full-time employee) Credit Policy Department -- Developed client/server database applications using Delphi, C,
C++, Visual Basic, Access, and Oracle (SQL, PL/SQL, Oracle Forms, Oracle Reports).
The applications provided data input, reporting and analysis for the bank's credit history
database. Created an Access application for the management of imported Oracle data.
Corporate Data Processing Department -- Provided technical consulting services -
Connectivity (TCP/IP, IPX, terminal/host, client/server, remote access), Oracle database
(installation, administration, development), Windows application development, UNIX,
Novell NetWare, and PCs in general. Installed and administered a NetWare LAN.
EXPERIENCE -- Software Engineer at Zylab Corporation -- Arlington Heights, IL (1989 to 1990)
(full-time employee) Developed and documented the report generating feature of ZyIndex (text search and
retrieval software) in both DOS and UNIX environments using C and Pascal.
EXPERIENCE – Software Engineer at AT&T Bell Laboratories (Lucent) -- Naperville, IL (1984 to 1986)
(full-time employee) Designed, developed, debugged, and documented 5ESS software using C/UNIX and 8086
assembly language. Projects included: allowing downloaded RAM software to dynamically
circumvent EPROM software and inter-processor communication via shared memory.
EDUCATION Illinois Institute of Technology 1993-94, 5 courses in Financial Mkts & Trading
Grace Theological Seminary 1986-88, MDiv except for thesis
Illinois Institute of Technology 1984-86, MS/Computer Science
Vanderbilt University 1980-84, BE/Electrical Engineering & Computer Science & Math