Customer Service Oracle

John G. Mosley

*** ******* ***.

Lansdowne, PA **050

(215) 847 - 9745

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

PROFILE

Microsoft Certified Professional (MCP), Microsoft Certified Desktop Support

Technician (MCDST) and Microsoft Certified IT Professional (MCITP) with

eight years experience working in Technology and Team Management. Currently

in the process of receiving Windows Server 2008 Active Directory

Certification, also team oriented with strong communication and problem

solving skills.

Technical Skills

Windows Server 2008 Active Directory, SQL Server 2005, MS Access, Oracle

8i, Oracle 9i, Oracle10g, UNIX, SQL Loader, PL/SQL, SQL Plus, SQL

Navigator, OEM, Backup and Recovery, Brightstor ARCserve Backup, Erwin Data

Modeling, Extract Transform and Load (ETL), Health Insurance Portability

and Accountability (HIPAA), PGP Whole Disk Encryption

EDUCATION

Drexel University, Philadelphia, PA

September 1998 - June 2001

Bachelor of Science, Information Systems

Knowledge Solutions International, Philadelphia, Pa

October 2009 - January 2010

Microsoft Certified Professional (MCP)

Microsoft Certified Desktop Support Technician (MCDST)

Microsoft Certified IT Professional (MCITP)

PROFESSIONAL EXPERIENCE

TEKsystems, Plymouth Meeting, PA

March 2010 - Present

Contractor

. Responsible for PC system software upgrade support

. Troubleshooting workstation and printer problems for 25+

workstations

. Provide first level technical support assistance to end users as

required

MEDecision, Inc. Wayne, PA

November 2006 - April 2008

Systems Analyst - Oracle 10g

. Secured Copied (SCP) from server to server for Patient Clinical

Summary (PCS) processing of electronic medical records as required by

Health Insurance Portability and Accountability (HIPAA) standards

while maintaining customer Service Level Agreements (SLA)

. Daily interaction with customer base troubleshooting, answering

questions and team lead

. Managed multiple vendors dump files by ensuring their proper

placement to UNIX servers via FTP

Methodology and Extract Transform and Load (ETL) procedures to Oracle

10g tables

. Performed QA analysis to the data to ensure proper reporting as

required by customer standards

. Trouble shooting unique constraint issues where resolved and the

unique indexes where created

. Documented and created various methods of processing and error-

handling and published documents on SharePoint for group access

. Managed programming for UNIX/Linux/Windows Servers

. Created User Accounts and Passwords

. Managed permissions for users

. Managed full and incremental corporate wide backups utilizing

Brightstor ARCserve Backup backing up UNIX and Windows servers and

storing tapes at secure offsite vendor

Lockheed Martin, King of Prussia, PA

July 2001 - October 2006

Oracle 8i, 9i, 10g, SQL Server 2005

Systems Engineer/Oracle Database Administrator

. Supported user requested schema creations and populations on an AIX

UNIX environment within my assigned databases

. Utilized Oracle 9i to Generate and store Data Definition Language's

(ddl's) based on the predetermined criteria of the user's and

established processes

. Developed conceptual, logical and physical data models

. Provided assistance to outside companies to assess data ownership,

source, hosting use, and levels of quality

. Formatted the projects sources into a schema formatted Access Database

to correspond with company guidelines

. Helped implement better mapping control of the Access Database

. Managed the development and production databases

. Implemented and maintained database security by creating indexing,

granting and revoking roles

. Operated PL/SQL to created triggers, procedures and functions to

capture additional data

. Managed installation, configuration and upgrades to database instances

and Oracle Software on AIX UNIX environments

. Extracted 1,000,000 records per table from an Oracle 9i database to a

SQL Server Data Warehouse

. Created database for the Defense Logistical Agency (DLA) utilizing SQL

Server 2005

. Transferred raw data into UNIX account using (FTP) UNIX Sun Solaris

. Utilized the full functionality of the ERWIN data-modeling tool

. Wrote and executed the commands to create and define the tables,

indexes, and supporting objects for the database

. Responsible for organization of unsystematic Excel and text files from

the user in preparation for table population

Merck & Company Inc. West Point, PA

March 2000 - September 2000

Oracle 8i

Oracle Database Administrator

Created processes to identify database objects that had been promoted

to production from the development environments

Created PL/SQL stored procedures that identified database objects that

did not conform to corporate standards

Established processes that identified database segments that did not

contain uniform extent sizes

Evaluated Oracle development tools utilized by application development

groups

Maximized SQL tuning methods to improve performance

Assisted with the logical and physical modeling of the Database using

the Erwin data-modeling tool

SmithKline Beecham Upper Merion, PA

March 1999 - September 1999

Oracle 8i

Oracle Application Developer

. Constructed SQL Plus tools to produce Ad Hoc queries using SQL

. Responsible for PL/SQL that provided users with instant reports based

on their requirements

. Assisted in the Y2K testing for UNIX Migration

. Involved in the creation of triggers, stored procedures and packages

to prevent future Y2K dilemma of potential miscalculations

Contact this candidate