BryanBlandResume_Oracle

Norman Bryan Bland

**** ****** **** *****

Durham, NC 27713

Work and Cell 919-***-****

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

SUMMARY

I am an Information Technology professional with more than 8 years of experience of technical expertise as an Oracle Database Administrator/Architect/Developer using the following Oracle tools: Oracle 10g/9i/8i/8.0/7.34, SQL, PL/SQL to include developing stored procedures, functions, packages, triggers, and PL/SQL libraries, Developer 2000 Forms and Reports 6.0, 6i, and 9i, SQL* Loader, Oracle Designer 2000, TOAD, SQL Navigator, and Oracle Discoverer. I have 6 years of Pharmaceutical/CRO experience as a database administrator/programmer using the following Oracle Pharmaceutical Applications: Oracle Clinical, TMS ( 4 years ), and Oracle AERS v4.3, 4.5.1, 4.5.2, and 4.6 ( 5 years ). I also have experience using Clintrace 2.6, 2.8, 2.9, 4.1, and then Empirica Trace 4.2. I have 3 years of Project Management experience, which includes managing a team and multiple projects at one time. In addition, I have experience with Unix Korn Shell scripting and web-based projects involving JavaScript, HTML, XML, and Visual Basic 6.0. I have 2 ½ year of experience using Oracle Applications, to include Oracle Financials, OE, Inventory, and Manufacturing using versions 10.7, 11.03, and 11i. Through my project management experience, I have experience in troubleshooting issues, performing system maintenance, upgrading systems, and documenting all aspects of the System Development Lifecycle. I have excellent problem solving, troubleshooting, and communication skills.

COMPUTER SKILLS

Oracle 8i/8.0/7.34 (6 yrs, last used ’08), Oracle 10g and 9i (3 yrs, last used ’09), Oracle PL/SQL (8 yrs, ’09), Oracle Clinical/TMS (4 years, last used ’07), Oracle AERS (5 yrs, last used ’08), Clintrace 2.6, 2.8, 2.8, and 4.1 (3 years, last used '08), Empirica Trace 4.2 (6 months, last used '09), Oracle Enterprise Manager ( 8 yrs, last used ’09), Developer 2000 Forms and Reports 6.0/6i/9i (6 yrs, ’08), HTML (4 yrs, ’04 ), XML ( 2 yr, ’09 ), JavaScript, Visual Basic 6.0 and .NET (1 ½ yrs, last used ’05), SQL*Plus, SQL*Loader (8 yrs, last used ’09), Oracle Discoverer (4 yrs, last used ’08), Oracle Designer 2000 (3 yrs, last used ’05), Unix Korn Shell scripting (4 yrs, last used ’08), Oracle Applications 10.7/11.03/11i OE, Inventory, Manufacturing, Financials, and HRMS (2 1/2 yrs, last used ’06), TOAD with DBA module (8 yrs, ’09), SQL Navigator (6 yrs, ’08), Visual Source Safe, PVCS, MS Project 98/2000, Visio, and MS Access 97/2000/2003/2007.

EXPERIENCE

Drug Safety Alliance (DSA), Durham, North Carolina Jul 2007 – Jan 2009

Business Systems Analyst II

Worked initially as support and lead developer for the Pharmaceutical database application Clintrace 4.1. My duties includes solving all user issues, developing custom reports, applying patches and fixes released by the vendor, and all validation activities involved in the process. Worked on the implementation and complete validation of the new version called Empirica Trace 4.2. My role changed to Validation Manager as I was responsible for running the complete project using MS Project 2007, running the validation which included writing all validation documents, writing test scripts, and executing test scripts. I was responsible for 4 other team members. I also assisted the QA department in client audits. I was then promoted to Business Systems Analyst II, which involved managing 2 team member full-time, working with the business to gather requirements for changes to our database, wrote documents and maintained validation documents. Due to my Database Administration experience, I also worked with out full-time DBA as his back-up.

November Research, San Francisco, California Oct 2004 – July 2007

Senior Consultant

Worked on Oracle AERS database implementation at Pharmaceutical/Biotech and CRO organizations. Main responsibilities have included DBA ( installation of databases, tuning databases, performing backups, and patching the database and software ). Other activities have included working on database modeling and warehousing, custom development using PL/SQL. Those custom development activities include creating reports and web reports using PL/SQL, modifying part of applications code written in Packages, Procedures, and Functions, and adding custom code to add email notification functionality. My responsibilities include writing PL/SQL programs to implement business processes, performance tuning, software validation, and report development using PL/SQL Server Pages. Previous project at November Research Group include: Project Manager for Oracle AERS/TMS pharmaceutical implementations globally. Responsible for all project documentation as well as working with the business to outline project timeline, managing application and database installation. Working on data migrations from legacy systems using PL/SQL stored procedures, functions, and packages. Worked on E2B implementations for electronic submissions of reports to the European EMEA as well as transferring files between companies. Worked with the following PM tools: MS Project, MS Visio, and MS Excel. Worked with the following development tools: Oracle Discoverer, Enterprise Manager, Oracle 8i, 9i and 10g, PL/SQL, and SQL*Plus, TOAD, Oracle Forms and Reports 6i and 9i. Oracle AERS vers 4.3, 4.5.1, 4.5.2, and 4.6, and Oracle Clinical/TMS 4.5

PPD, Morrisville, North Carolina Aug 2001 – Oct 2004

Sr. Systems Developer

Started as a developer for Oracle Clinical/TMS. Performed support on both application as well as worked on an in-house developer system, using Oracle Forms and Reports, to work in conjunction with Oracle Clinical. After this, I became the support for the Clintrace 2.6 application and then lead the effort to move to version 2.8 and then 2.9. I then became the PM for an Oracle Pharmaceuticals Application implementation (Oracle AERS v4.3). Primary Duties included: installation of the database and AERS 4.3 software, installing database patches, customizations to code, and implementing new reports and backup procedures. Assisting with all AERS validation activities, to include: writing user requirements, identifying test scripts to be written, writing validation plan, and writing and executing test scripts. Duties included creating custom Oracle Reports using Oracle Reports 6i. Oracle Developer for an in-house application developed using Oracle 9i SQL, PL/SQL to include writing procedures, Developer 2000 Forms and Reports 6i that was used in conjunction with Oracle*Clinical. Duties also included implementing, and supporting new Oracle based software to include full SDLC documentation and Pharmaceutical validation. Other tools used were TOAD, SQL*Loader, and HTML.

Intelligent Information Systems, Durham, North Carolina Feb 2000 – August 2001

Senior System Developer

Project Manager/Lead Developer for an Oracle ERP transformation project which included using Oracle Applications Financials, Inventory, Order Entry, PO, HRMS, SR, and AR modules to migrate the client from a Cobol system to Oracle. I was responsible for implementing, customizing forms, creating custom reports, and fully supporting the application. Worked with Oracle Applications 10.7, 11.03, 11i. Used Oracle 8.05, 8i, PL/SQL, Developer 2000 Forms and Report 6.0 and 6i, SQL* Loader, Oracle Discoverer, Oracle Designer 2000, HTML, JavaScript, Unix Korn Shell scripting, MS Project 98, and Visio. Duties included implementing software installations and performing customizations, performing all documentation activities, and managing a group of 3 programmers.

Durham Technical Community College, Durham, North Carolina Jan 2000 – Present

Instructor, Information Systems Department

Instruct the Database Programming I, Introduction to SQL and PL/SQL and relational database design and development and Database Programming II, Advanced Database Programming using Oracle Developer 2000 Forms and Reports 6i

GlaxoWellcome, Durham, North Carolina Sep 1999 – Jan 2000

Programming Intern

Developed applications for the business side of GlaxoWellcome, using Visual Basic 6.0, ASP, Java, Oracle 8i SQL, PL/SQL, Designer 2000, and Developer 2000 Forms and Reports 6i. Performed all database design and implementation duties to include documentation and full validation.

Education and IT Professional Development Courseware

Durham Technical Community College

AS - Computer Science/Computer Programming, May 2000

University of North Carolina at Chapel Hill, Chapel Hill, North Carolina

B.S., Computer Science, 2001

University of North Carolina at Chapel Hill, Chapel Hill, North Carolina

B.S., Medical Technology, 1994

University of North Carolina at Chapel Hill, Chapel Hill, North Carolina

B.S., Biology, 1992

Contact this candidate