Data Professional Experience
Resume:
Kim Freeark
Riverside, Illinois 60546
***********@*****.***
SUMMARY OF QUALIFICATIONS
Experienced professional specializing in database and BI programming using Oracle and SQLServer on both UNIX and Windows platforms, in a variety of business environments. Skills include SQL, PL/SQL, SQL*Plus, Data Warehousing, ETL, Perl and UNIX shell scripting. Experienced in all phases of system development and SDLC. Excellent verbal and written communication skills.
TECHNICAL SUMMARY
Oracle products: Oracle Database through v11g, Oracle Forms v11, PL/SQL, SQL*Loader, SQL*Plus
Languages: UNIX/Linux shell scripting, Perl, Expect, Hyperion SQR, C Language, HTML
Other Databases/ETL’s: Microsoft SQL Server, Qlikview, Pentaho, Talend
Applications/Tools/etc.: Data Warehousing, SDLC, BMC Atrium CMDB, Solarwinds Network Monitoring,
HP Openview, Bluecat IPAM (IP Address Management), Toad
PROFESSIONAL EXPERIENCE
Abbott Laboratories, Independent Consultant 1994 – present
Designed, developed, and maintained Oracle Data Warehouse integrating over 15 data sources, including network inventory, statistical, alerting, and utilization data. Development on both UNIX/Linux and Windows platforms.
Developed custom web-based network monitoring application that interfaced with many software/hardware lines.
Data warehouse and application required the design and programming of:
oover 40 web-based forms, developed under Oracle Forms/BI
oover 60 tables/views on both Oracle and SQLServer databases
ohundreds of reports, using SQL, PL/SQL, SQL*Plus, UNIX shell scripting, SQR, Perl, and Expect
Responsibility for all reporting, SQL queries, ETL’s, and maintenance.
Server as ‘Go-To’ data/reporting person for all ad-hoc queries, reporting, and data analysis requests in a fast-paced, volatile, highly reactive network operations environment.
Some DBA and sysadmin tasks
UNO-VEN Corporation, Independent Consultant 1993 - 1994
Design and programming in Oracle Forms and SQR under UNIX for an application that distributed Material Safety Data Sheets (MSDS).
Under tight deadline due to pending litigation developed Solvent Load Rack system to calculate/verify truckload chemical formulas.
Interstate Bankers Insurance, Independent Consultant 1992 - 2010
Developed customized insurance claim system using Oracle Database, Forms, and ReportWriter under UNIX.
Provided primary support to this mid-sized insurance company.
McDonald's Corporation, Independent Consultant 1992 - 1993
Programming in Oracle SQL, PL/SQL, ReportWriter and Forms under UNIX for Customer Relations Telephone Response system.
TSC, Inc., Principal 1989 - 1992
Design, programming, testing, and implementation phases of Point of Sale system for Bridgestone/Firestone's 1600 service centers nationwide.
Developed application software using Oracle Database/Forms under UNIX.
Project Leader on a Pricing and Promotion application for Ralston Purina, managing 6-person team.
Denniston & Denniston, Inc., Project Leader 1985 - 1989
Supervised team of three programmers responsible for development of a configurable factory automation software package written in C language, including interfaces to factory floor devices. Installed hardware, software, and PC networks.
Supported/installed PC-based speech recognition-telephone package.
Baxter Laboratories, Senior Programmer Analyst 1982 - 1985
Designed, programmed, and implemented computerized laboratory system for corporate R&D labs.
Arthur Andersen & Co., Programmer Analyst 1979 - 1982
Programmed and supported software and applications for network of minicomputers in 50 AA&Co. offices worldwide.
Managed application that collected and distributed firmwide payroll, client, and personnel information between offices and a central mainframe.
Duties included hardware/network installations, teaching programming classes for new hires, user training, and writing manuals.
World Book Encyclopedia, Editor 1977 - 1979
Responsible for annual revision of 1000-page computer-generated index to World Book Encyclopedia. Also wrote, edited, and researched articles.
EDUCATION
Completed 48 hours toward M.S. in Computer Science at DePaul University
B.A. with Honors in English and Italian, Trinity College, Hartford, Connecticut, 1976
Contact this candidate