Database Administrator/Developer Resume Philadelphia, PA - Hire IT People

TECHNICAL SKILLS:

RDBMS: Oracle 8.X - 11.g, Oracle ODW, ODS, ETL, SQL Server, Sybase, MS Access

Programming Languages: SQL, PL/SQL, Java, Basic, PL/1, Perl

Development Tools: Toad for Oracle and Java, SAS, WebLogic, Eclipse

Operating Systems: Windows, Linux

Web: JDBC, EJB, XML, HTML

PROFESSIONAL EXPERIENCE:

Confidential - Philadelphia, PA

Database Administrator/Developer

Responsibilities:

Support developers for efficient SQL query and performance (SQL trace and tkprof, explain plan).
Resolve issues for non-production and production environments.
Design and support PL/SQL programs for business purposes - data reconciliation, materialized views maintenance, etc.
Responsible for creation and modification of ETL processes using OWB and PL/SQL to provide data access for the reporting Cognos development team.
Provide Oracle Database Administration support and troubleshooting for Oracle ODS and Workflow.
Perform upgrades and patching.
Use Linux shell scripting and Perl script to automate processes on database.
Provide on-call database support for production databases.
Responsible for resolving Change Management tickets.

Confidential - Ambler, PA

Oracle Database Administrator/Developer

Responsibilities:

Utilized Linux shell scripting to automate processes on database.
Supported developers for efficient SQL query and performance.
Provided on-call database support for production, UAT and development databases.
Provided Oracle Database Administration support and troubleshooting, including install Oracle software.
Managed Oracle Enterprise Manager (OEM) for database backup and recovery.
Configured and managed RMAN backup and recovery.
Used ASM to manage disc groups and space utilization.

Confidential - Collegeville, PA

Sr. IT Engineer

Responsibilities:

Responsible for the development, deployment, maintenance, and support of Phase II (java/oracle application) of Safety Surveillance System/ S3
Managed several IAS (database) projects including Epidemiology, Auto-Narrative and Filters.
Lead Oracle / (PowerBuilder/Java)/Oracle ( HQ application which allowed Wyeth US users to directly enter and track adverse experience reports in the Global S3 database) projects: Reporting-Suspected, Device.
Designed, developed and implemented SAS derivation procedures and data load procedures.
Created, modified and maintained programs for monitoring on-going clinical studies. Performed validation of Clinical study reports and derived analysis datasets for individual and integrated studies.
Used testing methods and documentation standards to meet requirements for FDA Validated Systems

Confidential - Trevose, PA

Programmer/Analyst

Responsibilities:

Took part in development of an accounting application to serve the Master Servicing portfolio, including calculations of Expected Cash due from Servicers, loading Servicer Remittance data, Reconciliation (loan level, group level), Investor Remittance and Reporting, etc.
Created multiple windows and reports using PowerBuilder 5.0/6.0 in the first application release, PowerBuilder Framework - in the second, PowerBuilder 6.5/7.0 and PFC in the third.
Participated in the database design (Oracle, Sybase)
Created a data load utility to load data from ASCII files to the database using DataJunction performed on Oracle and Sybase databases.

Confidential

Chief Accountant and Programmer

Responsibilities:

Responsible for the accounting functions at a small publishing company.
Developed and maintained software to support accounts receivable, payable, invoice processing and inventory control.

Confidential

Cryogenic Engineer/Scientific Programmer

Responsibilities:

Developed computer models of cryogenic processes for the design of a new generation of crio-cooling systems for use in the space programming.
Programming was performed in PL/1 in IMB mainframe environment.