Oracle Database Developer/Programer/Administrator

S a n d r a K o p ec k y

* ****** ****** ****: 573-***-****

Selden, NY 11784 E mail:

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

STRA T EG Y L E A D E RS H I P P ER FOR M A NC E

AREAS OF EXPERT ISE

Team Collaboration Programming Software Documentation

and

Database Management Technical Writing

Development

Oracle Skills Global Software Updates Customer Service

Troubleshooting

K EY SK I L LS A SSESSME N T

Database Administrator – Performed installations, patches, upgrades, backups, import/export, and tuning

of the database system and environment. Created detailed technical documentation for the processes and

standards that were developed and used to perform these tasks.

Software Engineering – W ithin a number of organizations, I worked on software development and

engineering, helping to create new software programs, as well as to further develop programs to become

more efficient and user-friendly. With a broad set of computer skills, I am able to accurately assess

p rojects, develop plans, and follow through on project goals.

P h D in Computer Science – Pace University

Currently attending Pace University as a Doctoral candidate for a PhD in Computer Science

MASTE R OF SC I E NCE, Computer Science, New York Institute of Technology – Dec 2011

Completed program in 15 months with a 4.0 GPA

Maste r’s project: Golden-i technology from Motorola/Kopin

H andsfree, voice user interface, computer headset – w ww.mygoldeni.com

Writ ten bio in Inventors Digest - h ttp://www.inventorsdigest.com/archives/7554

PROFESSIONA L E XPER I E NCE

SPECPRO TEC H N I CA L SER V I C ES ( STS), Selden, New York, October 2014 – P resent

SE N I O R A P P L I CA T I O N /O RAC L E P ROGRA M M E R

Work on multiple project teams in support of multiple Oracle-based information systems

Assist in the design, development, and testing of Oracle-based queries, database objects, PL/SQL-

based functions and procedures,and XML-based data transfers and Java programming

Assist in the documentation

CAC H E CL O U D, E ast Meadow, New York, October 2012 – Janua ry 2015

D ATABASE A D M I N IS T RA TO R ( AT V AR IO US C L I E N TS A S A C O NSULTA N T / CO N T RACTO R )

Hands on DBA t raining. & working knowledge of Database architecture

Proficient in Oracle Database Application installation and administration

Performed Oracle Database patches and upgrades; disaster recovery using RMAN, tuning of

Databases and applications, backup and recovery using RMAN, import/export of databases

Installed and supported Oracle ERP servers

Experience with Oracle Data Guard

Upgrade from Oracle 11i to 12g

Install & set up of OEM (Oracle Enterprise Manager); OBIEE/BIP; Weblogic servers

System and SQL monitoring through OEM

Worked with Oracle Corporation to resolve application/database issues by opening TAR/SR and

monitoring them to execute action plans

Project documentation, creation and adhering to standards of implementation and project

management

Sa n d r a K o pec k y – Page 2

N EW Y OR K I NST I T U T E T EC H NO LOGY, O ld Westbu ry, New York

OF

A D J U N C T F AC UL TY, Janua ry 2012 – P resent

Teaching undergraduate level courses:

o Database Management Systems

o D atabase implementation and programming

o Distributed Database Systems

G RA DUAT E A D M ISS IO NS /C OOR D I NA TO R, Janua ry 2012 – P resent

School of Engineering & Computing Sciences under the Dean’s office

Review, and process for the department graduate incoming applications as well as graduation

applications

Advise current graduate students of a plan of action to achieve the desired degree

Provide input to the Dean and other departments with respect to the applications being received

and the standards of the department and the school.

N P D G RO U P, Port Washington, New York, Ma rch 2014 – October 2014

O P E RA T I O NS D ATA I N P U T A NALYST

Received “Big Data” files from clients (via automation, FTP, email, etc.)

Created SQL scripts to manipulate, process information into a database and run reports against

database

Used and modified SQL scripts and stored procedures using SQL Server 2008 and SQL Server 2012

Used and modified Ab Initio to develop ETL processes that load into a database on a RAC Oracle

11g system

Used Linux for interaction with files created from the Ab Initio ETL process

G L OBAL E N T E R P R ISE, Selden, New York, May 2012 – September 2012

Hired as a knowledge base for the Golden-i device

Created personalized demos for the client/customer with the Golden-i device and attended meeting

for the presentations/demos

OXYGEN, INC ., H icksville, New York, June 2010 – March 2014

O F F I C E M ANAGE R

Answering phones/filing/copying/faxing as needed to help support the company’s goals

Responsible for bookkeeping, payroll, accounts receivable, and accounts payable

Handled logistics, invoicing, and shipping for the company

Organized the office filing systems to ensure efficiency and documentation when needed

Updated the office bookkeeping on QuickBooks to t rack expenses and income

SE L F -E M P LOYE D, Columbia, M issouri, 1997 – 2002

SOF TWAR E D EV E LO PE R – C ON T RAC TOR M I SSO U R I E M P LOYERS M U TUA L I NSU RA NCE

FOR

Worked as part of a team on global updates throughout the entire system, including the year

format change from two (2) digits to four (4) digits

Reformatted the reports produced by the updates using Oracle databases, PL/SQL and SQR

Completed straightforward changes, updated necessary documentation, and created new code

based on other departments’ needs and requirements

D ATA P ROC ESS I NG P RO F ESS IO NA LS, C hesterfield, M issouri, 1994 – 1996

I N -H OUSE D ATABASE P RO J EC T /M A I N T E NA NC E T EA M ST RA TA G RO U P

AT

Researched and corrected defect reports as received from customers on a regular basis

Programmed in C in a UNIX environment utilizing an Oracle database

Designed and developed in-house database system to t race personal information on Power

M acintosh using FoxPro as database and language

Sa n d r a K o pec k y – Page 3

GT E, F ai rview Heights, I llinois, 1992 – 1994

M LS P RO J EC T

Ensured the continuation of the MLS Project at Digital Equipment Corporation utilizing both

I nformix and Oracle databases

Designed and implemented GUI application using C++, X, and Motif in a UNIX environment

Organized and maintained internal schedules, team status, and a team "development folder" to

ensure proper project management

Headed development of two user interface applications using Ada and DEC forms to access and RDB in a

VAX/VMS environment

D I G I TA L SYSTE MS C O NSULTAN TS, S t. Louis, M issouri, 1989 – 1992

M LS P RO J EC T D I G I TA L E Q U I P M E N T C OR PO RA T I O N

AT

Involved with the development of project coding standards following company standards and needs

Trained new engineers brought onto the project to ensure proper progress for ongoing work

T O MA HAWK U PG RA D E P RO J EC T M C D O N N E L L D OUG LAS C OR PO RA T I O N

AT

Coded and tested user interface software using Ada, X-Windows, and Open Dialogue (A Motif-like X

based user interface management system) on both Apollo and Silicon Graphics hosts

Wrote technical documents, managed documentation, and provided technical support for

management

ED UCAT IO N & TRA I N I NG

CYBER SECUR I T Y CON F E RE NCE, New York Institu te of Technology – September 2014

Part icipated as a speaker on panel regarding Cyber Careers.

Ph D in Computer Science – Pace University

Currently attending Pace University as a Doctoral candidate for a PhD in Computer Science

MASTE R OF SC I E NCE, Computer Science, New York Institute of Technology – Dec 2011

Completed program in 15 months with a 4.0 GPA

Maste r’s project: Golden-i technology from Motorola/Kopin

H andsfree, voice user interface, computer headset – w ww.mygoldeni.com

P roject used scanner technology to interpret 2D/QR code and make a match against a given

database returning a viewable map with exact location and other information

W rit ten bio in Inventors Digest - h ttp://www.inventorsdigest.com/archives/7554

B AC HE LOR OF SC I E NCE, Computer Science, New York Institute of Technology – June 1988

Oracle course "Develop Applications Using Database Procedures"

P latforms

Linux ~ Unix ~ VAX/VMS ~ Windows ~ Windows CE/.NET ~ SQL Server 2008/2012

Languages

Oracle Databases ~ SQL ~ PL/SQL ~ SQR ~ C ~ C++ ~ C# ~ Java ~ JavaScript ~ JSP

FoxPro ~ X ~ Motif ~ Ada ~ DecForms ~ HTML

Softwa re

OEM ~ OID ~ OAM ~ Toad ~ SQL Developer

Word ~ Excel ~ Access ~ PowerPoint ~ Quicken/QuickBooks

Follett – Library

Scoutmate - Boy Scouts ~ G-Scoutmate - Girl Scouts

Contact this candidate